Rishabh Khandelwal
Chartered Accountant
Jaipur
Summary
A highly analytical and process-oriented Chartered Accountant with over two years of specialized experience in Liquidity Risk Reporting, complemented by a foundational career as an Audit Associate in a large multinational corporation. Demonstrated a robust understanding of financial compliance and risk assessment, with a proven track record of delivering detailed analytical reports and insights that inform strategic decision-making. Possesses a strong aptitude for data analysis and interpretation, leveraging advanced accounting knowledge to ensure accuracy and integrity in financial reporting. Adept at navigating complex regulatory environments, consistently upholding the highest standards of audit excellence and financial scrutiny.
Overview
5
5
years of professional experience
8
8
Certifications
2
2
Languages
Work History
Analyst - Liquidity Risk Reporting
Barclays Bank PLC
11.2022 - Current
- Production of Periodical Reports (PRA110, LCR, NSFR and ILST) for Internal Risk Management and submission to Key Regulators (PRA and Federal Reserve)
- Perform Variance Analytics and deep dive analysis to provide insightful commentary on variances
- Liquidity related external disclosures and ILAAP
- Monthly reconciliations of liquidity data to the Balance Sheet along with execution of controls and governance around reconciliations.
- Managing the escalation of Data Quality issues in System Feed (Derived and Provider Backed Data Sets) with RTB and BTB Teams.
- Investigation of Variances between LCR and PRA110.
- Working on Liquidity Transformation Projects to define requirements, provide data and test solutions.
- Collaboration with IT and data teams to enhance reporting systems, ensuring accuracy and efficiency in data processing and report generation.
- Collation and Production of Periodical Insured Deposit Disclosures for Investors Relations and Annual Report Deck.
- Preparation of Annual Working of Deposits for the Purpose of calculation Bank Levy Tax.
- Stayed abreast of regulatory changes (FR2052a and PRA110) and ensured compliance with all relevant guidelines and requirements (BCBS239, EUDA Criticality Assessments).
- Validated results and performed quality assurance to assess accuracy of data.
- Identified trends and patterns in large datasets, leading to actionable insights for business growth.
- Researched and adopted new technologies to add value to existing offerings
- Increased efficiency by streamlining data analysis processes and implementing automation tools ((VBA, Kyvos, Power Query, Hue and Power Automate)
Associate II
PricewaterhouseCoopers Service Delivery Center
06.2021 - 11.2022
- Statutory Audit of Private non-public companies across multiple sectors in jurisdictions across UK, USA and Canada
- Substantive Analytic and Test of Details Procedures and controls of various FSLIs including understanding policies, auditing procedures, evaluation of qualitative items
- Financial statement review procedures based on understanding of relationships between supporting documentation and financial statement documents in accordance with auditing standards
- Application of Territory Specific Accounting Standards (US GAAP, FRS) along with IFRS and SEC Regulations.
- Use of Digital Assets, Automation Tools and Data Analytics Software like Alteryx to improve the quality of Deliverables.
- First Level Reviewer for EGAs pertaining to Inventory, Revenue and Payroll.
Subject Matter Expert - Accounting and Finance
Chegg Inc.
11.2019 - 11.2020
- Authoring questions from the student’s perspective by carefully reading them , researching about the topics determine precisely what the student is requesting.
- Creating, evaluating, and using technological solutions.
- Comprehend answering by including examples, illustrations, diagrams, pictures, and other details.
- Ensuring that solutions satisfy the required specifications and are in accordance with Quality Control Standards.
Education
Bachelor of Commerce (B.Com) -
University of Rajasthan
Master of Commerce (M.Com-ABST) - undefined
University of Rajasthan
Chartered Accountant - undefined
The Institute of Chartered Accountants of India
ACCA (Pursuing Professional Level) - undefined
Association of Chartered Certified Accountants
ACA - Accounting, Auditing And Finance
CPA Australia (Pursuing)
Australia 04.2001 -
Skills
Tally ERP
Certification
Data Analysis by Microsoft
Additional Information
1. Winner of Digital Infinite Week (Alteryx Designer)
2. Recognized for Automating the Manual Analysis and Review Procedures of Daily Metric Adjustments by using Power Query and VBA.
3. Worked with Liquidity Methodology Implementation Team for Interpretation and Validation of PRA110 Line Code (10 - 50) in PRA110 Mteric.
4. Worked with Liquidity Methodology Implementation Team for Interpretation and Validation of FR2052a Report Table "Supplemental Balance Sheet" for LCR and NSFR Reporting.
5. Participated in Insolvency and Bankruptcy Code organized by IBBI.
6. Recognized for integration of Business Views Spreadsheets (RAPIT) with Kyvos resulting in analyzing the Data for Multiple Dates and different products on a real time basis.
7. Recognized for Identification of issues in existing Macros making the metrics prone to Data Quality Issues and Incorrect Reporting.
8. Worked towards redesign of EGA (Auditing Templates) in accordance with the changes in IFRS.
9. Implemented the Control Checks in the Reporting Templates to ensure Efficiency and timely identification of significant variances across different products.
Timeline
Analyst - Liquidity Risk Reporting
Barclays Bank PLC
11.2022 - Current
Associate II
PricewaterhouseCoopers Service Delivery Center
06.2021 - 11.2022
Subject Matter Expert - Accounting and Finance
Chegg Inc.
11.2019 - 11.2020
ACA - Accounting, Auditing And Finance
CPA Australia (Pursuing)
04.2001 -
Bachelor of Commerce (B.Com) -
University of Rajasthan
Master of Commerce (M.Com-ABST) - undefined
University of Rajasthan
Chartered Accountant - undefined
The Institute of Chartered Accountants of India
ACCA (Pursuing Professional Level) - undefined
Association of Chartered Certified Accountants
Similar Profiles
Judy O BellamyJudy O Bellamy
Credit Counsellor at Barclays Bank PLC, FirstCaribbean Int'l BankCredit Counsellor at Barclays Bank PLC, FirstCaribbean Int'l Bank
Vicky DussaramVicky Dussaram
Senior Payments Supervisor / Payments Risk MI Supervisor / Group MI Analyst at Absa Bank Ltd formerly Barclays Bank Plc (Mauritius)Senior Payments Supervisor / Payments Risk MI Supervisor / Group MI Analyst at Absa Bank Ltd formerly Barclays Bank Plc (Mauritius)
Vicky DussaramVicky Dussaram
Senior Payments Supervisor / Payments Risk MI Supervisor / Group MI Analyst at Absa Bank Ltd formerly Barclays Bank Plc (Mauritius)Senior Payments Supervisor / Payments Risk MI Supervisor / Group MI Analyst at Absa Bank Ltd formerly Barclays Bank Plc (Mauritius)
Daniel CostallDaniel Costall
Quality Manager at Barclays Bank PLCQuality Manager at Barclays Bank PLC
ANKIT AGARWALANKIT AGARWAL
Assistant Manager at Jain Rathore & Associates, Chartered AccountantsAssistant Manager at Jain Rathore & Associates, Chartered Accountants