Summary
Overview
Work History
Education
Skills
Timeline
Generic
Apoorva Patil

Apoorva Patil

Business analyst

Summary

Experienced over 5.6 + years of expertise as Business Analyst ,financial reporting, regulatory reporting, compliance, and process automation. Proven ability to optimize workflows, ensure data accuracy, and drive regulatory reporting processes.

  • Led analysis, design, and implementation of regulatory reporting for accurate and timely submissions of federal and financial regulatory reports.
  • Successfully managed and reviewed US regulatory reports such as FR Y-9C, FFIEC 031, and FR2644, ensuring completeness and compliance with regulatory guidelines.
  • Skilled Financial Reporting Associate proficient in preparing, analyzing, and ensuring accuracy of monthly, quarterly, and annual financial statements in compliance with regulatory and client requirements.
  • Experienced in designing and implementing automated workflows using tools like Alteryx to streamline processes, improve data accuracy, and enhance reporting efficiency.
  • Proficient in data mapping, SQL analysis, and logic decoding for regulatory reports to ensure compliance with industry standards and regulatory requirements.
  • Strong background in performing thorough cash and equity reconciliations, resolving discrepancies between custodians and internal records, ensuring timely resolution of exceptions, and maintaining accurate position records for financial reporting purposes.

Overview

11
11
years of post-secondary education

Work History

Business Analyst

Wells Fargo Centre
  • Analyze and interpret business requirements and implement technical specifications for the regulatory reports of the Federal Reserve Board
  • Decoded and analyzed SQL logic in Vena’s (regulatory reports) ensuring data accuracy and compliance with regulatory requirements
  • Developed and maintained logic mapping for Vena (regulatory reports)
  • Ensuring accuracy and compliance and industry standards and regulations
  • Analyzed EIDF tables to understand data structures and relationships, and designed automated workflows to ensure seamless data integration, transformation, and accurate reporting, optimizing financial processes and compliance efficiency
  • Designed and built automated Alteryx workflows to streamline data extraction, transformation, and loading processes, enhancing data accuracy, efficiency, and reporting capabilities across business units
  • Gathered and documented business and technical requirements, ensuring clear and actionable specifications for the development team
  • Collaborated with stakeholders to gather, document, and prioritize business requirements, facilitating clear communication and successful project outcomes
  • Efficiently completed JIRA tasks, ensuring timely progress tracking and project management

Financial Analyst

JP Morgan Chase
  • Co-ordinated with relevant stakeholders, Data provider and Technology to implement regulatory reporting requirement changes
  • Aggregating submissions from multiple lines of businesses, data contributors and preparing the firm's regulatory reports, Financial Reports such as FR Y-9C, FFIEC 031 and FR 2644
  • Risk Reports such as FR Y-15, FFIEC 101\102, Country exposure risk, Capital Reports such as FR Y-14A, FR Y-14Q etc.) and executing the relevant controls to ensure completeness and accuracy of the report preparation
  • Managed and analyzed reports such as FR Y6 in LES reporting, ensuring accuracy and timely submission of data
  • Prepared and reviewed various reports, including head count reporting and peer analysis for business units ensuring comprehensive data accuracy and compliance financial standards
  • Prepared and presented a comprehensive deck on LES metrics monthly, highlighting key insights and trends for senior management review to inform strategic decision-making
  • Provided on-the-job training and ensure coverage for activities Understand the trends and drivers for the balance movement in the reports
  • Prepared and maintained supporting documentation to provide detailed evidence and ensure the accuracy and completeness of regulatory reports, facilitating transparent and compliant reporting practices
  • Preparation of senior management review \ regulator's review materials
  • Provided additional details and \addressed queries from stakeholders and regulators on the submitted data and filed numbers regulatory report
  • Periodic review, update and comprehensive documentation of process changes\system logic updates that impact the report preparation
  • Document, track and resolve errors in regulatory reporting
  • Actively participated in continuous improvement initiatives to enhance report quality, collaborating with the team on the successful onboarding of the FRI tool to streamline reporting process

Finance Analyst (Associate 2)

State Street Corporation
  • Supported the preparation and delivery of financial reports, ensuring accuracy, compliance with regulatory standards, and alignment with client specifications
  • Managed and reviewed monthly, quarterly, and annual financial statements, coordinating with various internal teams to resolve discrepancies and ensure timely delivery
  • Assisted in the preparation of consolidated financial statements, including balance sheets, income statements, and cash flow reports
  • Worked closely with clients and auditors to ensure the timely submission of regulatory filings and financial disclosures
  • Analyzed financial data for trends, variances, and key performance indicators, providing insights to senior management for decision-making
  • Contributed to process improvements in financial reporting, implementing best practices to increase efficiency and reduce reporting errors
  • Coordinated with cross-functional teams, including operations, compliance, and accounting, to ensure accurate and timely reporting
  • Assisted in the preparation of audit schedules and documentation, ensuring smooth and efficient audits
  • Participated in system upgrades and automation initiatives to enhance the accuracy and speed of financial reporting processes

Financial Analyst (Associate 1)

State Street Global Advisors
  • Ensuring cash investigations are conducted thoroughly on Set guidelines and matching of exceptions
  • Investigations of various BANC desk funds including -company stock, Investors service group Global equity Beta services desk Exceptions are cleared in par on agreed deadlines
  • Investigate unsettled broker and tax reclaims are performed
  • Reconciliation between various custody’s and SSGA Cash records to maintain set records for performance reports to be clean and accurate
  • Liaising with various Portfolio administrators on new funds, corporate action teams on security wise corporate actions for respective funds are in Par with our records and Bloomberg
  • Responsible for preparing MIS reports and reconciliation reports to Top Management with regards to the position breaks and the reasons based on investigation for top management review
  • Second level check and Four Eye check in activities performed by team analysts

Education

Bachelors of Commerce -

Mysore University
04.2013 - 01.2016

Masters of Business Administration - International Business

Mysore University
01.2016 - 01.2024

Skills

Risk Analysis & Mitigation

Audits & Investigation - Réconciliation

Automation

Testing

Stakeholder Management

Agile

TLM-RP29

Smart-Stream 360

MDF

RKSE RKS

Cash application

Mosiki Performance tool

AXIOM

SAP-BPCPM

Alteryx

GEMS

FR-Y10

FRI-SPIDER

Abacus

SQL

JIRA

Essbase

Timeline

Masters of Business Administration - International Business

Mysore University
01.2016 - 01.2024

Bachelors of Commerce -

Mysore University
04.2013 - 01.2016

Financial Analyst (Associate 1)

State Street Global Advisors

Business Analyst

Wells Fargo Centre

Financial Analyst

JP Morgan Chase

Finance Analyst (Associate 2)

State Street Corporation
Apoorva PatilBusiness analyst