I have 16+ years of experience in Business Data analytics as a Systematic Technical Analyst cum Product Owner with core skills in Business Analysis, Requirement Analysis, DATA Management, Cards Management(CC), Data Governance, Business Metadata Management, Data Classification(Customer and Account), Data Security, Data Privacy and Data Modeling, maintaining data quality, test management, dashboard design, machine learning, storyboarding, and insight representation (data translator) experience with a strong financial and Insurance domain experience in the implementation of Large-Scale Data warehousing and Business Intelligence projects. Defining requirements, outlining specifications, and working with stakeholders and technical team members to bring to life high-quality products for customers. Good planner and problem-solver with an in-depth understanding of Banking and Insurance products.
ADS (Analytical Data Store), Business analyst (CCIB Client Coverage & Data Technology), 05/23, Present, ADS platform will support Enterprise Risk Analytics in building, Validating and Monitoring IRB and IFRS9 for Corporate Institutional Clients(CIC). This is mainly used in Model Life Cycle, Digitize and Automate Data, Wrangling, Profiling and DQ controls. Individual Data Marts and sources(CRHS, EDM IFRS9, External data) have been built in response to specific Regulatory Requirements. ADS resolves the challenges in standardizing the data sets, Merging the data sets and underlying data and Data Quality assurances., Understanding of the existing Business and Data flow from various systems and Data sources like SCI, Creditmate(CMT), ESE, BCRS and External Data like SNL BvD etc., Business Analysis and Story writing and Scrum facilitation on the requirements., Business Metadata and Mapping document Preparation with CDE and Classification., Data Mapping with documentation and data alignment check for financial and non-financial sector., Data Ingestion and Data Validation using ITFW Framework., User Group access and Data Masking for compliance, Working closely with Data Asset team for any New data Request. CCMS (Credit card Management system), Data analyst for Credit card Application system in SCB, CCMS is a single source application, predominantly build on Vendor based product called Cardlink with the associated compliance and Enhancement patches delivered and maintained by ATOS product team. It is a Customer based and transaction driven system, one customer with one or Multiple accounts. Type of account includes Visa, MasterCard, Debit card etc. It is a group of related systems that supports SCBs Credit card Issuing and Acquiring functions. Issuance of CC, Customer and Cardholder Management, Authentication and Authorization processing, Transaction Posting, Statement Generation and Billing., In House customization that catered for Business needs for Multiple countries., System Functional Validation., Requirement Analysis, Story creating, Understanding the Functional Requirements., Understanding the Technical Feasibility and T Sizing, Creating or converting requirements to Functional and Technical Jira’s CCIB - CAP & CRMx Analytics - (Commercial Corporate Institutional Banking), Senior Business analyst (CCIB Client Coverage & Data Technology), 02/22, Present, CCIB- CAP: Commercial Analytics Platform: The CB App is a transformative digital tool, specifically designed to simplify and enhance the client prospecting & cross-sell process by providing the frontline staff with access to relevant enablers such as value proposition materials, analytical insights, research feeds, and Sales Management tools such as Call reports and Working capital cycle calculators, etc. in a seamless manner anywhere, anytime. CRMx – Customer Relationship Management Analytics – It is a New CRM Eco-system (Client-Centric, Single, and Data Platform), which will enable CCIB to effectively manage, measure, and Analyse their client relationships and help Frontline staff to perform their day-to-day activities more efficiently. It makes data actionable by providing recommendations on your Leads, automated Alerts, and Triggers to help you spot trends and capture opportunities required for understanding client behaviors and improving relationships., Engage with internal and external (Tech and Business team) teams to refine and clarify requirements., Define key metrics for governance to ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements, Understanding the Functional Requirements., Understanding the Technical Feasibility and T Sizing, Creating or converting requirements to Functional and Technical Jira’s, User story Prioritizing, Solutioning and Grooming, Facilitate Scrum and Agile Meetings, System Performance Analysis., Reconciliation of Insight or Signal counts with source data., Provide and Facilitate data access to the Business team, Train the Modal to the Business Development team. EPMS - (Enterprise Performance Management System) - New Cost Allocation, Business DATA analyst (MOT Finance), 09/21, 02/22, EPMS – NCA is a New Cost Allocation engine that breaks down the cost and reallocates according to the users’ inputs. The cost allocation engine is an in-house product and it allocates the cost by various drivers based on the nature of the cost that giving the bank a strategic advantage in enabling deep insights into Product/Customer profitability, Channel strategy, Customer behavior, Productivity, and Digital Value Capture and greatly helps in the strategic cost optimization. NCA Engine works with 3 main categories: Cost Categorization, Cost Allocation, Cost Analysis., System Performance Analysis and finetuning, Reconciliation of Computation and Variance Analysis., Engage with internal and external (Tech and Business team) teams to refine and clarify requirements., Provide and Facilitate data access to requestors, Owns the Cost Allocation data strategy, data life-cycle and data to deliver effective data to Cost Allocation engine and ensures it aligns with business priorities., Prepared the playbooks, learning agendas for scaling DMP across the project team., Experienced in scoping and evaluation – Defining overall considerations, including scalability, maintainability, cost, operations and technology principal risk to provide a recommendation, Collaborated with teams to discover and deliver the best solution to the market presented by the product team lead and the business., Created and maintained the solution vision, roadmap, and backlog of work through the project's life cycle., Convey the vision and goal at the beginning of every release and sprint to Development TeamsOwns the full Cost Allocation. BPDS (Banca Platform Digital Services), DBS – BANCA, DBS, Singapore, Product Owner/ Business / Data analyst (CBG finance), 04/19, 08/21, BANCA Platform Digital Services (BPDS) is a digital platform, it has an Admin module as a front-end application wherein DBS staff will be given an authority to access the product catalogue and customer holdings data provided by Insurers, including Manulife and Chubb. BPDS system receive and store Insurance data created Digitally via API for Chubb and Daily Batch files for Manulife and Chubb. BPDS consists of Product Holdings, Insurance holdings and Funds related data. In Addition, receives transactions of customers who purchased General Insurance policies (GI) through the DBS channel catalogue of GI products introduced through the DBS channel., To liaise with Insurance partner for Project discussions on scope and deliverables., Preparing a Business Requirement Document with all the requirements captured., Managing projects/Migration with complex environments ADA and BPDS; multinational and cross-departmental., Collaborated with stakeholders to understand business problem statements to refine and clarify requirements. And convert them into user stories., Preparing user stories with established user story acceptance criteria for the tech team to understand the requirements and refined stories with Scrum teams clearly on Sprint basis., Data Mapping for New and Existing fields from Chubb and Manulife to BPDS., Understand Data acquisition, Develop data set processes, knowledge of data concepts, End to End data flow verification from BPDS, CIS/CMCP to Account Summary of Internet Banking and ADA (for SAILOR and Intelligent Banking teams), Understand the complex transformation logic and translate them to Spark code or Spark-SQL queries., Responsible for defining the scope and business rules of the project, interacted with cross functional teams to facilitate gathering of business requirements., Automated scripts prepared to reconcile the Commission with Chubb raw data. And Analyzed the difference month wise for better planning of the Budget. BIP_Regionalization (GDW Migration) DBS – HK, Business / Data analyst, 05/18, 04/19, The BIP Regionalization project is to inject Hong Kong (HK) and Taiwan (TW) data into the Singapore Business Intelligence Platform (BIP) modelled using FSLDM. The data in the warehouse can be used to build data marts, downstream systems and developing reports and analytical models using Qlik view & SAS. Loans and Credit Cards (LAM, LRE and LCL) data will be loaded into SIM and then it processes to down streams and data marts like CMP and GAS as per current GDW process., To integrate the data with the existing model built with BIP., Project deliverables include creation of Information Mapping document., Security Matrix preparation to identify each user against department with various Roles and access matrix, Data Mapping for New and Existing fields, Responsible for defining the scope and business rules of the project, interacted with cross functional teams to facilitate gathering of business requirements. Project – Lantern (ANZ Migration) DBS – ANZ, Business / Data analyst, 02/17, 04/18, Lantern is a project initiated for technology/data integration of acquired ANZ businesses of wealth management and retail banking by DBS. The scope of the project includes, Credit cards, Cash line, Personal Loans and Debit Cards business lines. Integration for Project – Blue (MIS), DBS- Manulife, Business / Data analyst, 09/15, 01/17, DBS bank partnering with Insurance company Manulife to sell Manulife’s insurance products to DBS customers. DBS Sales agents will sell these policies and in return Manulife will pay commission to DBS bank. Project blue MIS is to receive the data from ML system to DBS BIP system and expose it to DBS BANCA users. It involves Commission and VSF Calculation with multiple Insurance products and various premium methods BIP systemic EDW of DBS where data from various system will be received in staging area, Transform to FSLDM, convert to data marts as per user requirement and Create Reporting platform for insurance data for DBS and Manulife users and management. National Immunization Registry, Health Promotion Board (HPB), Business analyst /Tech Lead, 02/14, 09/15, NIR – National Immunization Registry System provides the online services through the web-based interfaces to maintain the immunization records i.e. Create, Update, View the Immunization data of the children and the adults by the users General Public, healthcare providers (GPs, Polyclinics, Hospitals) and HPB-NIR Staffs. FPMS -Great Eastern Life Assurance Company Ltd, Singapore, Business Consultant, 01/12, 12/14, FPMS – Financial Project Management System is the main policy admin system of Great Eastern Insurance Company, Singapore. FPMS implements the life insurance operation and is based on three-tier structure and J2EE standard. It consists of presentation layer, logic layer and data layer. The system supports to create and manage new customers, policy/application creation and functional core business includes Product Definition, New business, Customer Service, Claim, BCP, Finance, Valuation report, Integration. The salient features of system are supporting in multi-language, multi-currency and date format. This system is developed as common system and it is rolled over to different countries by including country specific requirements.