Summary
Overview
Work History
Education
Skills
Projects
Professional Development
Timeline
Generic

Jay Singh

Bengaluru

Summary

Results-driven professional with extensive experience at Goldman Sachs, specializing in data analytics and visualization. Proficient in SQL and advanced Excel, I have successfully implemented reporting tools that enhanced decision-making processes. Adept at stakeholder management, I consistently deliver actionable insights that drive business objectives and improve operational efficiency.

Overview

6
6
years of professional experience

Work History

Sr Reporting Associate

Bank of Montreal
Toronto
10.2019 - 06.2024
  • Extraction and manipulation of RAF data from various data sources (Including Salesforce) using SQL to come up with meaningful market insights about our products and present findings in decks to Sr leadership
  • Leveraging tools like sales force to identify the Auto deals in pipeline and evaluate competitor information
  • Deep dive into RAF financials to understand and present trends, business health and compare YOY performance to create a business plan
  • Liaise closely with various teams like the pricing, fraud, lending, funding to understand their reporting needs and create Spotfire dashboards and excel reports where needed.
  • Worked with the product and pricing team to measure, monitor and analyse key performance indicators to determine the effectiveness of BMO standard and special rates with respect to its competitors
  • Identify any anomalies in data and raise any trends spotted in business to help
  • Analyse distribution mix across originations for prior years to help create a target for dealers and come up with the official Retail auto finance strategic plan for the next year
  • Used advanced MS Excel skills - like creating formulas, pivot-tables, macros, charts/graphs to send across data pertaining to originations, market share and various other business stats across to the Management
  • Helped automate the fraud and lending scorecard for Managers to track performance of their team
  • Worked on database of competitor activity including pricing and competitive offer trends
  • Map process flows and create Process documents as required
  • Carry out any Ad hoc product and pricing reporting and analysis as requested

Senior Analyst

Goldman Sachs
Bengaluru
01.2018 - 06.2019
  • Implemented designed reporting tools like SAP BO to present demographics data across regions and divisions in form of succinct dashboards and presentations used for business decision making purposes
  • Used advanced MS Excel skills - like creating formulas, pivot-tables, macros, charts/graphs to send across data pertaining to diversity, compensation distribution to business leads as Ad hoc reports
  • Acted as subject matter expert, SME by leading the Global reporting across Goldman Sachs for federation divisions - Ensured the accuracy and timely production of over 200 reports on a weekly/monthly/quarterly basis related to people demographics and performance intended to drive particular business objectives
  • Used analysis to identify high attrition areas and suggest measures to help grow/enhance the business solutions. Thereby raised issues to management that require further investigation
  • Liaise between various stakeholders across the business, operations and IT team to analyse requirement, facilitate designing dashboards and enable enhanced system functionalities
  • Built cross functional relationships and identifying scope for improved efficiency in reporting; Gathered reporting, visualization processes requirements and began the implementation and usage of Tableau
  • Created and managed multiple Microsoft SharePoints to store & share reports which were used by clients
  • Extensively used Business Objects to extract information and share findings with stakeholders across business
  • Modified SQL Queries to extract from database and warehouses as per requirement

Education

Master of Business Administration -

SCMHRD Symbiosis University
Pune
04-2016

Bachelor of Tech - Engineering

Jaypee University of Information Technology (JUIT)
India
05-2014

Skills

  • Data analytics and visualization
  • Client and stakeholder management
  • SQL querying and advanced Excel
  • Dashboard creation and reporting
  • Data manipulation and financial modeling
  • Statistical analysis and critical thinking
  • Business intelligence tools (SAP, Tableau, Spotfire)
  • Presentation and project management skills
  • HRIS expertise

Projects

Analysed data, used forecasting techniques and gave proposals to build a future campus hiring strategy for the Finance - Technology division; $400,000 USD Saved. Design Compensation Models across divisions based on Benchmarking, Compression factors and Performance data to arrive at the annual bonus amount for employees. Clean up of 500+ existing scheduled reports to bring about standardization and consistency of data usage.

Professional Development

  • R Programming, Johns Hopkins University, 2017
  • Capstone business simulation certification, Management Simulations Inc. USA, 2016
  • Certified Six Sigma Green Belt, ADAAP Process Solution, Bangalore, 2015
  • Financial Markets: A Beginner's Module of NCFM, National Stock Exchange, 2013, 90%

Timeline

Sr Reporting Associate

Bank of Montreal
10.2019 - 06.2024

Senior Analyst

Goldman Sachs
01.2018 - 06.2019

Master of Business Administration -

SCMHRD Symbiosis University

Bachelor of Tech - Engineering

Jaypee University of Information Technology (JUIT)

Similar Profiles

CREATE PROFILE
Jay Singh