Yogesh Aggarwal
Gurgaon
Summary
Finance professional with 13+ years of extensive experience in the Regulatory & BASEL III reporting, Change management, Finance and Tax reporting, Auditing, Accounting & FP&A
Overview
17
17
years of professional experience
1
1
Certification
Work History
AVP
HSBC
01.2022 - Current
- Understand functional/regulatory requirements, undertake impact analysis, and define technical requirement including Basel regulations
- Propose and prepare functional design solution ETLs with attributes & their derivations for successful delivery of functionalities in Cloud for credit risk and RWA
- Prepare underlying reference data tables for parameters used in RWA calculation
- Review and analyze existing logic & derivations for defects and provide resolution
- Involved in various stages of change delivery cycle (design, testing, implementation)
- Ensure design solution meets regulatory, operational, cloud and business needs
- Engage with stakeholders regarding requirement/design/functionality of changes
- Interrogate Google Cloud BigQuery via SQL for data extraction and analysis
- Use applications like JIRA and Confluence for test execution and impact assessment.
Senior Associate (AVP)
JPM Chase
07.2020 - 01.2024
- Formulated Daily capital Monitoring & LER reports on day to day basis
- Analyzing major variances and ensuring compliance with BASEL provisions
- Optimizing resources to delivery reports within stipulated timeframe
Manager
HSBC Group
03.2016 - 07.2020
- Capital Reporting for PRA Group regulatory reporting team in preparation of daily, monthly, quarterly and annual reporting to local European Regulators and other European competent authorities on various statistical reports, internal management and external ad-hoc reporting
- Complete and accurate preparation of weekly, monthly, quarterly and annual reporting to applicable regulators (PRA, EBA and Bank of England) arranged in accordance to the rules and regulations laid down in BASEL III
- Prepare initial schedules and reports, including primary data provider capture point and work paper preparations
- Analyze financial data in order to complete filings, understand fluctuations and uncover potential inaccuracies
- Perform edit check reviews and follow up on applicable discrepancies
- Perform reconciliations across reports and schedules
- Prepare monthly management reports and trends on capital adequacy
- Monthly systems processing of Saracen including UAT’s, data extractions, data quality checks and reconciliations
- Stay informed of regulatory changes and work with management to develop processes for implementation of new reporting requirements
- Maintain detailed procedures and documentation for the above processes
- Leverage Reporting: submitting at group level on quarterly & monthly basis as per the guidelines set under Prudential Regulation Authority & Basel 3 guidelines, which involves; Populating regulatory balance sheet item and assessing the exposure for calculating leverage ratio
- Preparing the commentary over underlying impact on MTD, QTD and YTD basis
- Updating the movement walk from last quarter to current quarter with material drivers
- Checking the appropriateness of the manual reclass between various head in balance sheet
- Extracting the off-balance sheet number from reporting system and segregating it into the right bucket for CCF conversion
- Understanding all the regulatory adjustment for reaching to numerator (Tier 1 capital), to calculate leverage ratio
- Interacting with policy and diverse reporting team for clear understanding of any new guidelines/changes which perhaps impact our submission
- Submitting regulatory returns to PRA as per CRR guidelines (Monthly PRA101, Quarterly COREP and associated packs)
- Public disclosures (Pillar 3 disclosures, Interim reports etc.)
- Operational Risk RWA’s & Basel line of business (Blob): Submitting at group & regional level on quarterly & annual basis according to the guidelines set by Prudential Regulation Authority & CRR rules, which involves; Review operating income from Saracen and calculating the Blob net income
- Analyze material variance, separating FX impact and underlying impact & reconciling P&L with Blob submission
- Check the appropriateness of the transfer pricing number reported in each Blob lines
- Calculate operational RWA, using appropriate risk factors and 3 years average income
- Collaborate with policy / IFRS team for clear understanding of any guidelines which impact our submission
- Quantify the material impact of unposted intercompany transaction due to timings difference
- Submit “COREP form C16” to PRA and MI and varied analysis packs to management and diverse stakeholders
- Other reports: FSA reporting (FSA001, FSA002 & FSA015), GSIB, Group Solvency report etc.
Assistant Manager
Bank of America
06.2014 - 03.2016
- Prepare Monthly/Weekly/Daily Loans & Deposits Reports for different business/LOB segmenting different regions/geography
- Organize MOR decks & Expense sheet providing plan & forecasted numbers for the 2 successive years using different parameters
Assistant Manager
Genpact
01.2012 - 05.2014
- Formulate financial statements for legal entities of GE UK and Ireland as per UK Statutory norms
- UK corporate tax project - creating tax computations for GE UK legal entities as per UK corporate tax
- Managed SAO (Senior Accounting Officer) project.
Audit Executive
unpostedRWA’sreclassUAT’sDoogar & Associates
01.2011 - 12.2011
- Conducted statutory audit, internal audit and limited review of financial statements for the PSU’s and diverse corporate sectors
- Auditing and summarizing of annual reports (financial statements, auditor’s report, director report etc.) in accordance with varied statutory compliances
- Reviewing the soundness of internal control and recommending necessary changes.
Intern
Adesh Jain & Associates
05.2007 - 05.2010
- Experience in Direct Taxation & Internal Audits.
Education
CA Final -
I.C.A.I.
05.2010
CS Inter - Company Law & Finance
I.C.S.I.
06.2010
B.Com (H) -
Delhi University
05.2007
12th Class -
C.B.S.E.
Diploma in IFRS -
ACCA
Pursuing MBA in Data Science From IMT Ghaziabad
Skills
- Regulatory & BASEL III reporting
- Finance and Tax reporting
- Auditing
- Accounting
- FP&A
- Operational efficiency
- Project Management
- Business analyst
- Technical requirement definition
- Functional & Technical designer (ETL's)
- Google Cloud BigQuery, SQL, JIRA
Languages
Hindi
First Language
English
Proficient (C2)
C2
Certification
- Scaled Agile
Profile Snapshot
- HSBC, AVP, Jan 22 - Present
- JPM Chase, Senior Associate (AVP), July 2020 - Jan 2022
- HSBC Group, Manager, Mar 2016 - July 2020
- BOA, May 2014 - Mar 2016
- Genpact, Jan 2012 - May 2014
- Doogar & Associates, Jan 2011 - Dec 2011
Languages
- English
- Hindi
Timeline
AVP
HSBC
01.2022 - Current
Senior Associate (AVP)
JPM Chase
07.2020 - 01.2024
Manager
HSBC Group
03.2016 - 07.2020
Assistant Manager
Bank of America
06.2014 - 03.2016
Assistant Manager
Genpact
01.2012 - 05.2014
Audit Executive
unpostedRWA’sreclassUAT’sDoogar & Associates
01.2011 - 12.2011
Intern
Adesh Jain & Associates
05.2007 - 05.2010
CA Final -
I.C.A.I.
CS Inter - Company Law & Finance
I.C.S.I.
B.Com (H) -
Delhi University
12th Class -
C.B.S.E.
Diploma in IFRS -
ACCA
Pursuing MBA in Data Science From IMT Ghaziabad
Similar Profiles
Risha RajRisha Raj
Data Scientist - Manager at HSBCData Scientist - Manager at HSBC
Sashank BhootSashank Bhoot
Fund Administrator at HSBCFund Administrator at HSBC
YUGAMBIGA RAJENDRANYUGAMBIGA RAJENDRAN
Assistant Manager at HSBCAssistant Manager at HSBC