Summary
Overview
Work History
Education
Skills
Websites
Languages
Certification
Timeline
Generic

Yogesh Bhatia

Pune

Summary

Accomplished Senior Business Analyst with a proven track record at SG Analytics and Deutsche Bank, specializing in data analysis and regulatory compliance. Expert in SQL and pivot tables, I've led AI-driven projects to enhance data quality, significantly reducing issues by streamlining processes. Skilled in cross-functional team leadership and analytical tool implementation, my work has directly contributed to improved Data Quality and making operational efficiency.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Business Analyst

SG Analytics
Pune
04.2024 - Current
  • Performed root cause analysis to determine the underlying causes of data quality issues highlighted by different regulators.
  • Resolve regulatory data quality issues by suggesting changes at the source, modeling, or core functionality of the data master.
  • Partnering with the AI Hub team to develop a generative chatbot using AI agents, which compares various structured and unstructured data sets to answer or highlight DQ issues.
  • Identified opportunities for the automation of manual DQ analysis processes and developed solutions.
  • Managed projects and served as the primary liaison between business, regulatory teams, and multiple internal groups to clarify goals and meet standards and deadlines.

Business Analyst

SG Analytics
Pune
03.2023 - 03.2024
  • Working as a techno-functional business analyst for a multinational bank client.
  • Requirement gathering from various different stakeholders, such as finance, risk, billing, compliance, etc. To help them adapt to the new master data system.
  • Understand the scope of the requirement and test the availability of data in the new master system.
  • As per the stakeholders' requirements, assess various data distribution methods and suggest the best for consumption. IE. Snapshot API, Stream, etc.
  • Requirements are vague for tech teams if needed for developing a new solution for data distribution.
  • Perform monthly metrics analysis and documentation in JIRA and Confluence.

Business Analyst

Credit Suisse
Pune
08.2022 - 03.2023
  • Perform root cause analysis on issues assigned under set deadlines, working closely with the business, IT, and various stakeholders, like product control, legal entity, liquidity reporting, etc.
  • Act as a liaison between multiple business stakeholders, post-RCA, and help in solution design by proposing solutions, and aiding in testing in the pre-release phase.
  • Create support documents like Impact Analysis, Business Requirement Document for major changes, and maintain them in ALM and SharePoint.
  • Perform IT testing and provide additional weekend support for various feeds before every quarterly release.

Senior Analyst

Deutsche Bank
Pune
10.2021 - 08.2022
  • Requirement gathering from various lines of business, i.e., Risk Finance, Treasury, Asset Servicing, etc.
  • Understanding the requirements and building various data quality checks on the bank's internal tool.
  • Identify and highlight defects to higher management, producers, data masters, and consumers of data.
  • Raising and maintaining each defect on the JIRA board to track, assign, and test the resolution of these defects.
  • Getting sign-off from all consumers before going live, and once in production, performing the RTB function of posting adjustments for any pending defects until resolved in the next release.

Analyst

Deutsche Bank
Pune
06.2019 - 09.2021
  • Correctly map commercial banking exposure to its respective counterparty to reduce the overall RWA of the bank.
  • To oversee the entire month-end flash and actuals process for accurate calculation and reporting of RWA and leverage for the bank.
  • To host daily calls with every business and IT team for addressing or remediating any issues.
  • Reporting actual RWA and leverage numbers to top management on a daily basis.

Education

Post Graduate Diploma - Banking and Finance

Brihan Maharashtra College of Commerce
Pune
04-2021

Bachelor - Business Administration

Brihan Maharashtra College of Commerce
Pune
06.2019

Skills

  • SQL proficiency
  • Data analysis expertise
  • Pivot tables
  • Microsoft PowerPoint
  • Tableau experience
  • Analytical tool implementation
  • User acceptance testing

Languages

Hindi
First Language
English
Proficient (C2)
C2
Sindhi
Proficient (C2)
C2
Marathi
Advanced (C1)
C1

Certification

  • Certified Program in Financial Management (Stock and Options) - BSE India

Timeline

Senior Business Analyst

SG Analytics
04.2024 - Current

Business Analyst

SG Analytics
03.2023 - 03.2024

Business Analyst

Credit Suisse
08.2022 - 03.2023

Senior Analyst

Deutsche Bank
10.2021 - 08.2022

Analyst

Deutsche Bank
06.2019 - 09.2021

Post Graduate Diploma - Banking and Finance

Brihan Maharashtra College of Commerce

Bachelor - Business Administration

Brihan Maharashtra College of Commerce
Yogesh Bhatia