Summary
Overview
Work History
Education
Skills
Accomplishments
Professional Qualification Synopsis
Timeline
Generic

Sarvpriya Singh Arora

New Delhi

Summary

With over 11 years of experience in the financial industry, I possess expertise in liquidity reporting, regulatory reporting, COREP reporting, capital Basel III, change and transformation implementation, project management, business analysis, and data analytics. This strong background allows for effective navigation of complex financial landscapes and delivery of accurate and insightful reports. Skilled at identifying areas for improvement and implementing strategic changes to drive operational efficiency, consistently delivering high-quality results that meet stakeholder needs.

Overview

11
11
years of professional experience

Work History

AVP – Liquidity Lead Business Analyst

HSBC Bank
09.2023 - Current
  • Implementation of new requirements of liquidity as per stake holder guidance using BRD Document.
  • Preparation of L1/L2 RRT’s to transfer new requirements in liquidity reports.
  • Working on Projects as EBA 3.2 Taxonomy Changes,
    FotC Liquidity Platform Changes etc.
  • Analyses of requirements through Big query using
    SQL queries and performing reference data changes.
  • Responsible for transferring requirements information to Testing and Implementation team for closure of
    liquidity projects.
  • Efficient in mapping requirements of clients as well as multiple stakeholders, translating requirements into business requirement documents (BRD).
  • Provide tactical solutions where strategic work stream is either aiming to deliver later or it is not in scope

Manager – Liquidity/Treasury Risk & Reporting

Natwest Bank
01.2022 - 08.2023
  • Accountable for preparation & submission of liquidity risk reports: - PRA 110 and DILAA and other internal liquidity monitoring reports
  • Performing variance analysis and providing commentary for day-on-day movements
  • Taking care of SOPs and BOPs and other adhoc queries
  • Working on Corep risk reporting for Asset encumbrance reporting
  • Preparing adhoc request from PRA on FIR for Asset encumbrance reporting for senior stakeholders
  • Taking daily calls with senior stakeholders to discuss and interpret the current scenarios effecting liquidity risk

Manager – Liquidity Finance Reporting

HSBC INDIA
07.2018 - 01.2022
  • Accountable for preparation & submission of liquidity risk reports: - Liquidity Coverage Ratio (LCR) and Net Stable funding ratio (NSFR) to European Banking Authority (EBA)
  • Preparing HKMA LMT Part I to IV, ALCO pack, PRA110 and ILM reports
  • Performing variance analysis and providing commentary for month on month variance
  • Running queries for various financial transactions such as (capital market, Lending & Borrowing Nostro & Vostro A/ Cs)
  • Preparing returns for Monetary Authority of Singapore (MAS) and UK PRA
  • Monitor all the stress scenarios as applicable for accurate and realistic projections
  • Updating dash board and KPI Tracker and taking sign off on the same on a monthly basis
  • Making various Adjustments in reports based on BASEL III norms
  • Taking monthly call with in-country team and taking care of business updates
  • Taking care of SOPs and BOPs and other adhoc queries
  • Worked on PRA110, DA LCR and NSFR implementation process on Google Cloud – a transformation of SDIs from Big data & Moody’s to Google

Assistant Manager - Regulatory Finance (Orange Blanks)

UnitedHealth Group (UHG)
04.2016 - 06.2018
  • Responsible for the Preparation of Quarterly & Annual Statutory Report like “Orange Blanks” (Financials of US Health insurance entities to NAIC) with Supplemental Schedules
  • Responsible for electronic filing of financial Statement to NAIC and various state departments
  • Preparation of Statutory Journal Entries based on SSAP
  • Preparation of Investment Schedules, Claims Schedules, General Interrogatories
  • Preparation of Cash flow statement & Notes to Financial Statement
  • Preparation of Analytical Report and document findings through In-depth Variance Analysis
  • Preparing Board Reports and Board Narratives (Financial Statement Summary) to present them to BOD and CEO/CFO of the legal entity
  • Preparation of State Supplements: A&H (Accident & Health Policy Exhibits), MD&A (Management Discussion & Analysis) and SHCE (Supplemental Healthcare Exhibit) filings and all related activities, HHS Medical Loss Ratio Rebate filings and all related activities
  • Prepare the Audited Financial Statements and supporting documents for Audit & develop responses to Audit inquiries
  • Collaborate with other UHG departments, external parties to resolve Legal Entity inquiries
  • Work on project teams outside of active reporting periods to respond to changing technical requirement, new reporting requirement and suggestion for improved team performances

Assistant Manager - Regulatory Reporting (Y11/2314/009) HQ level

Genpact
09.2013 - 03.2016
  • Looking after accounts of Real Estate business containing 131 Subsidiary of General Electric Capital Services for the purpose of submission of Regulatory reports (Y11/2314/009) to Federal Reserve Bank
  • Preparing appropriate adjustment entries and formulating Back up data for various Reporting purpose (like Y11/2314,Y9C)
  • Analyzing company financial data (P&L, Balance Sheet & Headcount) on periodical basis, including support of Financial Conditions analysis, external revenue reporting etc
  • Commentary on variance analysis of B/S and P&L items giving pin point impact of various items
  • Analyzing intercompany asset/liability and intercompany income/expense to ensure correct presentation
  • Assisted SEC team in preparing Quarterly Financial Statement by implementing Oracle Discoverer Calculations
  • Working closely with the business Controllers, Product and Coverage Managers and the respective Finance Business Partners to provide in-depth and business centric Value-Add MI analysis, to assist the business heads in identifying risks and opportunities
  • Assisting business partners in budgeting and forecasting
  • Extracting and developing concise financial reporting from MI sources and other reports, including developing excel models
  • Taking weekly calls with our client and answering their query on regular basis
  • Assisting in development of complex financial models
  • Ensure that financial reporting is of high quality and meets applicable accounting principles and regulations
  • Receipt of Cheers award within 6 months of joining production for delivering excellent performance
  • Single Handedly remote transitioned 009 submission and implemented successfully
  • Receipt of 2 client awards in First 15 months
  • Got T20 ratings - Highest yearly rating a Genpact employee can get

Education

Bachelor of Commerce -

Delhi University
01-2011

XII -

CBSE
01-2007

X -

CBSE
01-2005

Skills

Tableau

SQL

MS Excel

Tally

Oracle

Hyperion

WKFS

PeopleSoft

Wings

Blackline Reconciliation

Accomplishments

  • Receipt of Cheers award within 6 months of joining production for delivering excellent performance.
  • Single Handed remote transitioned 009 submission and implemented successfully.
  • Receipt of 2 client awards in First 15 months.
  • Got T20 ratings in all my previous organisations.
  • Was part of Global Leaders program in Natwest bank


Professional Qualification Synopsis

  • CA Final, ICAI, 53.88%, Got Exemption in Corporate and Allied law and Indirect Tax Laws.
  • CA PCC, ICAI, 56.33%, Got Exemption in Advanced Accounting, Costing and information technology and strategic management.
  • CA CPT, ICAI, 55.50%

Timeline

AVP – Liquidity Lead Business Analyst

HSBC Bank
09.2023 - Current

Manager – Liquidity/Treasury Risk & Reporting

Natwest Bank
01.2022 - 08.2023

Manager – Liquidity Finance Reporting

HSBC INDIA
07.2018 - 01.2022

Assistant Manager - Regulatory Finance (Orange Blanks)

UnitedHealth Group (UHG)
04.2016 - 06.2018

Assistant Manager - Regulatory Reporting (Y11/2314/009) HQ level

Genpact
09.2013 - 03.2016

Bachelor of Commerce -

Delhi University

XII -

CBSE

X -

CBSE

Similar Profiles

CREATE PROFILE
Sarvpriya Singh Arora