Yash Kumar Pandey
Deputy Manager II
Mumbai
Summary
Dynamic Finance Analyst with ICICI Bank Limited, skilled in advanced Excel and project management. Spearheaded automation of regulatory reporting, enhancing compliance ratings and reducing manual processes. Expert in data management and UAT, driving efficiency and accuracy in financial submissions while collaborating effectively with cross-functional teams.
Overview
2
2
years of professional experience
Work History
Finance Analyst
ICICI Bank Limited
06.2023 - Current
Conducted SIT (System integrated testing) for data flow checking from core banking system to data warehouse to ensure smooth automation before UAT.
Conducted UAT (user acceptance testing) for new reporting automation tooks and ensured seamless integration with the finance and regulatory reporting framework.
Collaborated with IT and compliance teams to develop a centralized reporting dashboard, reducing dependency on manual spreadsheets and reducing regulatory observations and improving compliance ratings.
Led automation of ALM, Liquidity coverage ratio (LCR) and Capital Adequacy (CAPAD) reports enhancing real time visibility for senior management ensuring with RBI guidelines.
Currently, working on the development and automated FTP implementaion for regulatory and financial reporting , ensruing timely and accurate data submissions.
Authored BRS/BRD for automation projects by engaing with risk, treasury, planning, reporting and finance teams to enable faster and accurate reporting leading to reduction in manual intervention.
Led the Exposure and Undrawn reporting for corporate and retail portfolios, feeding into capital adequacy and regulatory submissions for domestic, overseas , UK and CANADA.
Enhanced risk management through maturity gap analysis, liquidity monitoring and stress testing within ALM framework.
Education
Bachelor of Technology - Civil Engineering
NIT DURGAPUR
Durgapur, India 04.2001 -
Skills
Advance excel
Power BI
OFSAA
Microsoft SQL developer
Data management
Jira
Process and data automation
Regulatory reporting
Project Management
Business requirement documentation
SIT/UAT
Additional Information
Completed Projects:
Automated exposure report for reporting customer having exposure above 5Cr for fortnightly/monthly CRILC reporting for both domestic and overseas.
Automated undrawn report for Liquidity Coverage Ratio (LCR) in BASEL III regulatory reporting.
Bank's LCR reporting migration project from Microsoft SQL database to OFSAA database as per RBI inspection.
Built frontend page for senior management and auditor to check customer exposure as well as undrawn along with the product relationship with the bank.
Automation of reports as per the requirements from Risk, treasury, FARG and Planning teams.
Ongoing Projects:
In collaboration with ORACLE for developing PFT/FTP reports as per the CAPAD, LCR and ALM guidelines for RBI regulatory reporting.
Into migration project for souring customer details through MDM system which is more efficient and smoother as compared to current DWH source.
Timeline
Finance Analyst
ICICI Bank Limited
06.2023 - Current
Bachelor of Technology - Civil Engineering
NIT DURGAPUR
04.2001 -
Similar Profiles
Laxmi KumariLaxmi Kumari
Wealth & Trade Relationship Manager (M2) at ICICI Bank LimitedWealth & Trade Relationship Manager (M2) at ICICI Bank Limited
Mangapathi Rao PandiMangapathi Rao Pandi
Deputy Branch Manager at ICICI Bank LimitedDeputy Branch Manager at ICICI Bank Limited
Priya ShuklaPriya Shukla
Manager of Operations at ICICI Bank LimitedManager of Operations at ICICI Bank Limited
Bhoomi KumbhaniBhoomi Kumbhani
Clinical Physiotherapist at Umiya Physiotherapy ClinicClinical Physiotherapist at Umiya Physiotherapy Clinic
Diksha SinghDiksha Singh
Key Account (Project Management Office) at Brandola Marketing Solutions Pvt. Ltd.Key Account (Project Management Office) at Brandola Marketing Solutions Pvt. Ltd.