Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Timeline
Generic

Anbumalar James

Kampong Punggol

Summary

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.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Senior Analyst Programmer

Quesscorp Private Limited (Standard Charted Bank)
02.2024 - Current

Developer/UAT Tester

CSS Corp private limited
06.2024 - 11.2024

Business analyst /Development Lead/ Business tester

HCL Singapore Pte Ltd (GE &Health Promotion Board)
01.2024 - 09.2024

Software Engineer

Mondial soft private limited
11.2024 - 05.2024

Product owner/Business/Data Analyst

Apar technologies (DBS Singapore)
09.2024 - 02.2024

Education

Master of Computer Applications (MCA) -

Madurai Kamarajar University
01.2008

Bachelor of Computer Applications (B.Sc, CA) -

Madurai Kamarajar University
01.2005

Skills

  • Business Analysis
  • Data Analysis
  • Business Analytics
  • Proven record of delivering actionable insights
  • Self-service data preparation
  • Reporting architecture
  • Guidelines
  • Roadmap
  • Enterprise reporting
  • Self-Service reporting
  • Channel team collaboration
  • UAT and Production testing
  • Regulatory requirements
  • New product launch documentation
  • Stakeholder coordination
  • Product features Workshop
  • BI and data warehouse troubleshooting
  • Budgeting
  • Tracking
  • Forecasting
  • Interface with product vendors
  • Development guidelines
  • Standards
  • Best practices
  • Cost Allocation
  • Performance Management
  • Critical thinking
  • Multitasking
  • Effective communication
  • Vendor management
  • Incident ticket handling
  • Data warehouse implementation
  • Data Migration
  • Data management
  • Data architecture and design
  • Customer and Account reporting
  • Technical Support
  • Design process
  • Competitive analysis
  • Gap analysis
  • Report Generation
  • Reconciliation
  • Campaign reporting
  • Coordination across teams
  • Testing (functional, regression, user acceptance, integration, performance)
  • Machine learning model design
  • Hadoop
  • R
  • Python
  • QlikView
  • Tableau
  • Oracle Reports
  • SQL
  • Hive
  • Spark
  • PySpark
  • Spark SQL
  • Elasticsearch DB
  • New 4J
  • Apache Superset
  • Teradata
  • DB2
  • Oracle
  • MySQL
  • AI Studio (Squirro)
  • Data Comparator tool
  • DB Visualizer
  • ITFW
  • Confluence
  • ADO board (Azure)
  • GitHub
  • Jenkins
  • Eclipse (30)
  • IntelliJ IDEA
  • SharePoint
  • KOFAX(OSR)
  • Collibra
  • Serena Dimension CM Web Client
  • MS Office
  • VB
  • HTML
  • XML
  • JavaScript
  • React JS
  • Microservices
  • SOLR Collection
  • JAVA
  • J2EE
  • C
  • C
  • PLSQL
  • Requirement Analysis
  • DATA Management
  • Cards Management(CC)
  • Data Governance
  • Business Metadata Management
  • Data Classification(Customer and Account)
  • Data Security
  • Data Privacy
  • Data Modeling
  • Maintaining data quality
  • Test management
  • Dashboard design
  • Machine learning
  • Storyboarding
  • Insight representation (data translator)
  • Financial domain experience
  • Insurance domain experience
  • Large-Scale Data warehousing
  • Business Intelligence projects
  • Banking products
  • Insurance products

Certification

Certified Scrum Product Owner (CSPO), 001071208

Accomplishments

  • Got awarded as “BIP critical contributor DBS- Manulife Integration Programme” in the year 2016.
  • Data Migration Specialist “DBS-ANZ integration for Project Lantern” in the year of 2017-2018
  • Key Contributor HK- GDW Data Migration in the Year of 2018-2019.
  • Awarded for Data Migration to BPDS from Insurance partners Manulife and Chubb
  • Awarded Top Performer of the Month in SCB for CAP Project
  • Project Delivery Appreciation Award for ADS in SCB

Projects

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.

Timeline

Software Engineer

Mondial soft private limited
11.2024 - 05.2024

Product owner/Business/Data Analyst

Apar technologies (DBS Singapore)
09.2024 - 02.2024

Developer/UAT Tester

CSS Corp private limited
06.2024 - 11.2024

Senior Analyst Programmer

Quesscorp Private Limited (Standard Charted Bank)
02.2024 - Current

Business analyst /Development Lead/ Business tester

HCL Singapore Pte Ltd (GE &Health Promotion Board)
01.2024 - 09.2024

Master of Computer Applications (MCA) -

Madurai Kamarajar University

Bachelor of Computer Applications (B.Sc, CA) -

Madurai Kamarajar University
Anbumalar James