Abhinav Kakkar
Gurgaon
Summary
Regulatory Reporting Manager with over 19 years of experience in driving change and BAU for well-known Banks in regulatory reporting space. Detail oriented, quick learner and adapt to changing regulatory requirements for ensuring completeness and accuracy of reports. Being a techno-functional expert, trusted by business, tech and data providers for driving change as well as BAU.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Regulatory Reporting Manager
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Assisted the Regulatory Inquiries group with FDIC Special Assessment for the Bank.
- Transformed the current operating model of the US regulatory reporting space to align with strategic blueprint (Target Operating Model).
- Collaborated with data and technologies to drive change management of key call report schedules as well as other key systemic risk reports.
- Migrated reviews of key deposits schedules of Call Reports from US to India.
- Drove implementation of detective/preventive control framework across span of deposit reports to ensure data accuracy and completeness.
- Dealt with external and internal audits for call reports.
- Leading a team of 11 US Regulatory Reporting Loans and Deposits Specialists.
- Identified Issues in current reporting and remediated these by doing quantitative as well as qualitative research on the data attributes.
- Drove operational excellence to generate holistic efficiencies in the ongoing processes.
- Project: US Regulatory Reporting for Deposits for 9C and Call Reports.
- Role: Regulatory Reporting Manager
Senior Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Reviewed AS-IS system by analyzing existing documentation and interviewing users (regulatory analysts).
- Engaged users in prototyping phase to align and tune gathered requirements with business needs.
- Determined the direction and timelines for product-wise migration of reports in Axiom by prioritizing stories in the product backlog using MoSCoW method.
- Defined scope of migration from legacy to target system.
- Collaborate with users and data providers to ensure all data mappings and reporting requirements are accurately defined and documented in the target system.
- Engage Technology, Data and UAT teams to ensure the captured requirements are implemented and tested accurately.
- Identified and remediated business drivers of the data-variances between current and target system.
- Tracked QoQ (Quarter on Quarter) movement of loans in post-production reporting and isolated the business drivers of the variances.
- Project: Migration of US Systemic Risk Report (FRY-15) from AS-IS system to target system (Axiom and Enterprise data-sources) for exposures to Financial Institutions (Sch B).
- Role: Senior Business Analyst
Senior Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Elicited and documented the business requirements by going through the logic in current system and referencing the regulatory instructions to anchor the report to Sch C/L of FRY-9C for Assets and contingent liabilities.
- Brain-stormed with tech, data and users to discuss manual adjustments process in the current system and remove it in Axiom hence improving operational efficiency as well accuracy.
- Resolved FFIEC009 report dependency in the current system to ensure that this report is decoupled in the target system.
- Did Impact Analysis of migrating the line assignment from current system to Axiom by comparing country/currency/sectorial exposure between both the systems.
- Mentored Junior team members for doing an assessment of data models in current and target systems in Axiom.
- Project: Migration of country/currency/sectorial line assignments for FR2510 report from database to Axiom
- Role: Senior Business Analyst
Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Implemented the solution for excluding intercompany loans in 9C/031 in Axiom to get away with the manual process of consolidating and generating the data by regulatory reporting officers. This enhanced the accuracy of reported numbers as well as reduced operational risk.
- Reconciled reference data (for company hierarchy) with enterprise data-source to come-up with data attributes that can be used to identify counterparties consolidated under bank holding company (for 9C) and banking entity (for 031).
- Engaged users in prototyping sessions to sign-off on the data attributes and business logic for excluding intercompany loans.
- Reviewed test plans, provided test scenarios and drafted test cases for data validation and conducted User Acceptance testing (UAT)
- Project: Identification and Exclusion of Intercompany loans in FRY-9C and FFIEC031
- Role: Business Analyst
Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Work with Stakeholders to define/redefine, develop and document workflow processes along with optimization of existing business processes.
- Perform data map and gap analysis between incoming upstream feeds or trading systems and reporting system.
- Translate large shareholding and short selling position reporting requirements for equity derivatives into meaningful technical and functional documentation and provide technical recommendations to members of the team.
- Defining data flows to assist understanding of aggregated reportable short positions of specified shares for HK SFC.
- Providing technical support to resolve business issues. Also, leading integration efforts of staging area with internal and external applications and data.
- Routinely develop complex SQL queries to support reporting and troubleshooting needs.
- Project: Enhancement and support of Large Shareholding and Short Selling Reporting.
- Role: Business Analyst
Solution Architect
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
- Analyzed business requirements for data validation framework, understood system needs and subsequently created system design while ensuring that the framework is ready within the timelines.
- Created plugins for the integration of application with enterprise DevOps backbone.
- Drove user demos in UAT environment to walk them through the features of the validation framework.
- Mitigated performance issues as part of post-production support
- Project: Maintenance and Migration of Compliance applications
- Role: Solution Architect
Solution Architect and Team Lead
Dell Services
09.2009 - 03.2016
- Designed, implemented and integrated Oracle based staging areas for transforming transactional data into spanned data as per down-stream requirements which later acted as “Authorized Data Sources” for the enterprise.
- Worked on Oracle XML DB along with oracle objects and collections to routinely load all the updates from providers in staging database.
- Worked on system enhancements for handling EDI 278 and 837 transactions using Perl, Tibco RV and GIS (Gentran Integration Suite).
- Enhanced SOAP based WebServices using Tibco AMX and Java.
- Handled 5-6 members team.
- Client: Harvard Pilgrim HealthCare
- Role: Solution Architect and Team Lead.
Data Network Engineer
Idea Cellular Limited
12.2008 - 09.2009
- Responsible for maintaining the data network nodes (like GGSN, L2 Cisco switches, ISP facing routers (Juniper)) of the organization after air interface.
- Configured Cisco Switches and Juniper Routers for various protocols like BGP, IGP.
- Role: Data Network Engineer
Software Engineer
Dell Services Erstwhile Perot Systems TSI
08.2006 - 12.2008
- Wrote automation scripts for the administrative tasks for the client using Perl and shell (Korn) scripting.
- Designed an advanced pattern matching software (based on Levenstein Algorithm), which was used to find the nearest match from input CSV data.
- Client: Harvard Pilgrim Health Care
- Role: Software Engineer
Education
B.E. - Electronics and Communication Engineering
CRSCE
01.2006
Skills
- US Regulatory Reporting
- Change Management
- People Management
- Stakeholder Management
- Product Analysis
- Gathering Functional Requirements
- Map and Gap Analysis
- Business Process Mapping
- Providing data-driven scalable solutions
- Agile Methodology
- XML
- PL/SQL
- Tableau
- Axiom
- Python/Perl
- Process mapping
- Cross-functional coordination
Certification
- CFA Charterholder, CFA Institute. Attained charter in June, 2023.
- Passed GARP SCR (Sustainability and Climate Risk) Exam in 2022.
- Tableau Certified Desktop Specialist 2021.
- Passed CFA Level 2 in 2019.
- Passed CFA Level 1 in 2017.
- Sun Certified Java Programmer (for Java 2 Platform 1.4) 2007.
Timeline
Regulatory Reporting Manager
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Senior Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Senior Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Business Analyst
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Solution Architect
BA Continuum India Ltd. (Bank of America)
03.2016 - Current
Solution Architect and Team Lead
Dell Services
09.2009 - 03.2016
Data Network Engineer
Idea Cellular Limited
12.2008 - 09.2009
Software Engineer
Dell Services Erstwhile Perot Systems TSI
08.2006 - 12.2008
B.E. - Electronics and Communication Engineering
CRSCE