Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic
AAKANKSHA SINGHAL

AAKANKSHA SINGHAL

BUSINESS ANALYST
GURUGRAM

Summary

Dynamic Business Analyst with over 11 years of experience in credit risk management across wholesale and retail banking portfolios, specializing in Corporate & Institutional Banking (CIB) within global banking and consulting environments. Expertise in requirement gathering, impact assessments, UAT, process flows, data validation, and the development of credit risk models (PD, LGD). Proven track record in creating comprehensive BRDs, use cases, and process flows while managing stakeholder relationships to deliver actionable insights and high-quality risk solutions. Committed to driving process improvements that enhance operational efficiency and support strategic objectives.

Overview

11
11
years of professional experience
1
1
Certification

Work History

AVP

HSBC
GURUGRAM
05.2023 - Current
  • Key Projects: CRD VI Article 21c Regulatory Program
  • Leading HSBC's global readiness for CRD VI Article 21c, covering interbank, interbank exemptions, reverse solicitation, and grandfathering. Enabled delivery of the Target Operating Model (go-live Mar 2026) while enhancing compliance, capital reporting accuracy, and operational efficiency.
  • Delivered detailed impact assessments of Article 21c, identifying regulatory gaps in interbank exposures and solicitation rules, ensuring compliance readiness.
  • Analyzed large, complex datasets in Excel, reconciling exposures and validating capital impact to improve accuracy of regulatory reporting.
  • Produced BRDs, use cases, and requirement flowcharts, streamlining requirement sign-offs and reducing delays in approvals.
  • Designed process flows and data lineage diagrams for the Target Operating Model, driving consistent implementation across global entities.
  • Created executive decks and governance packs that improved stakeholder clarity and accelerated decision-making at senior forums.
  • Partnered with global teams (Risk, Finance, Treasury, Compliance, IT, Reporting) to align systems, controls, and processes across EMEA and APAC.
  • Supported UAT cycles by preparing test cases, executing scenarios, and logging defects to ensure solution quality and regulatory accuracy.
  • Delivered a CRM tool to capture client and counterparty feedback, improving transparency, audibility, and regulatory engagement.
  • Data Quality Remediation
  • Worked as Business Analyst on a global data quality remediation project, gathering requirements and documenting BRDs, ensuring hassle-free and on-time sign-offs.
  • Conducted in-depth data analysis to identify, investigate, and prioritize 64 data quality issues, ensuring accurate root cause identification.
  • Created and managed Scrum boards, defining 60+ Epics and User Stories, maintaining the backlog, and tracking issues through different resolution stages.
  • Streamlined the process of logging data issues in JIRA, improving transparency, tracking, and resolution efficiency.
  • Collaborated closely with Development and Testing teams to resolve critical data issues, improving data accuracy, reporting reliability, and model development readiness.
  • Coordinated in Agile environment, facilitating sprints, stand-ups, and stakeholder communications, enhancing process efficiency and team alignment.
  • Managed and led meetings and workshops with multiple departments to solidify requirements.

SENIOR CONSULTANT

ERNST & YOUNG
GURUGRAM
05.2021 - 04.2023
  • Key Projects: Data Migration & Ingestion from legacy to centralized system
  • Led requirements gathering and analysis across 5+ geographies, consolidating data into HSBC's central system to support downstream model development, improving reporting accuracy.
  • Identified and validated 10+ source systems, reducing data inconsistencies.
  • Analyzed 50+ complex SAS codes, reconciled datasets, and validated against requirements, data dictionary, and golden source, enhancing data quality.
  • Defined sensitive fields to be masked, achieving full regulatory compliance.
  • Mapped complete data lineage, applied phased migration technique, streamlining migration processes and reducing errors.
  • Tested raw data across all sources, coordinated UAT, logged 100+ defects, and supported production go-live for France, ensuring on-time delivery with minimal post-go-live issues.
  • Developed BRDs, functional specifications, and data flow diagrams, improving stakeholder clarity and alignment.
  • Development of behavioral scorecard for PD model
  • Developed logistic regression–based PD scorecard for the mortgage portfolio, converting scorecard points to PD to improve default prediction and support risk-based lending decisions.
  • Enhanced data quality through missing-value imputation, outlier treatment, and EDA, ensuring robust and reliable modeling inputs.
  • Selected predictive variables using IV and WOE; mitigated multicollinearity with VIF for stable, interpretable models.
  • Validated model using KS, Gini, and Actual vs Expected analysis, ensuring regulatory compliance and supporting capital adequacy assessments.

CONSULTANT II

EXL SERVICES
GURUGRAM
04.2019 - 04.2021
  • Key Projects: UAT Testing of Reporting Data Layer for COREP, FINREP
  • Gathered and analyzed business and regulatory requirements to design comprehensive test plans and scenarios across multiple reporting regimes.
  • Coordinated with developers, testers, and stakeholders to track and resolve defects using Jira and Confluence, ensuring timely issue closure.
  • Conducted data validation and automated testing using SAS macros for ~300 variables, ensuring accuracy and integrity of reporting outputs.
  • Summarized results using PROC SQL and PROC SUMMARY; prepared Excel reports and communicated findings and business impacts to stakeholders.
  • Produced end-of-testing reports, highlighting issues, process improvements, and compliance impact for management and regulators.
  • Re-calibration of Basel LGD model based on CRD IV directive
  • Analyzed and calibrated the LGD model for a mortgage portfolio, ensuring alignment with the new definition of default and regulatory changes.
  • Created data based on the updated definition of default, including incorporating a probation period into the model's structure.
  • Calibrated model components according to the new default definition, assessing existing segmentation and applying margin of conservatism (MOC) and adjustments as needed to enhance model accuracy.
  • Calculated Downturn LGD and Best Estimate of LGD (BEEL) for model validation, performing Actual vs Expected analysis to ensure compliance with regulatory requirements.
  • Evaluated the impact on Risk-Weighted Assets (RWA) and Loss by calculating PD, EAD, and LGD, applying parameters from the newly developed model for recent periods.
  • Prepared detailed documentation for the LGD model, including comprehensive analysis of each model component, and presented it for stakeholder approval to ensure regulatory compliance.

ITA

TATA CONSULTANCY SERVICES
GURUGRAM
12.2014 - 04.2019
  • Key Projects: Building Propensity Model for targeted marketing of new Banking Product
  • Designed predictive model measuring buyer's propensity to purchase using model building techniques on SAS. The purpose of the model was to improve upon customer targeting and increased sales conversion.
  • Differentiate the key characteristic b/w buyers and non-buyers and focus on predicting prospective buyers from existing customers & identify the best segment of cards.
  • Developed a logistic regression model by performing Exploratory data analysis, variable selection and removal of multi-collinearity using VIF.
  • Measured the model performance by analyzing ROC curve, Gini and KS statistics for threshold value to target the customers.

Education

PGPM - Finance

Great Lakes Institute of Management

B.Tech - Electronics & Communication

JECRC

High Sec Certificate - CBSE Board

Brightlands school

Sec. School Certificate - CBSE Board

Brightlands school

Skills

  • Data interpretation

  • Stakeholder engagement

  • Effective communication

  • JIRA, Confluence, SAS, SQL

  • Wholesale and Retail lending

  • Data-driven business analysis

  • Agile methodologies

  • Model development & validation

  • Experience with BASEL compliance

  • Comprehensive BRD development

  • Knowledge of PRA, EBA, CRDIV, and CRDVI regulations

  • Credit risk modelling including IRB models like PD, LGD

Certification

Certified SAFe 6 Product Owner/Product Manager

Accomplishments

  • HSBC H2 , 2024 excellence award
  • EY Kudos for excellent client delivery and team management – 2022
  • Promising newcomer of the year award- 2019 , EXL
  • Intellectual Team Award for H1 & H2- 2019, EXL for excellent and zero defect delivery
  • On the spot award for critical work in 2017,TCS
  • Won award for organizing various yearly events and fun activities in 2015, TCS
  • Appreciation from clients for presentation skills – Excel
  • College and school topper, first student who got 89% - 1st Sem in JECRC, Jaipur

Timeline

AVP

HSBC
05.2023 - Current

SENIOR CONSULTANT

ERNST & YOUNG
05.2021 - 04.2023

CONSULTANT II

EXL SERVICES
04.2019 - 04.2021

ITA

TATA CONSULTANCY SERVICES
12.2014 - 04.2019

B.Tech - Electronics & Communication

JECRC

High Sec Certificate - CBSE Board

Brightlands school

Sec. School Certificate - CBSE Board

Brightlands school

PGPM - Finance

Great Lakes Institute of Management
AAKANKSHA SINGHALBUSINESS ANALYST