Summary
Overview
Work History
Education
Skills
Software
Internship
Certification
Accomplishments
Timeline
Generic

Gopal Nawani

Business Analyst
Mumbai

Summary

Accomplished at Sanofi, I spearheaded advanced analytics initiatives, integrating data across global units and enhancing decision-making with machine learning and strategic planning. My leadership in financial analytics and project management led to significant efficiency gains and a prestigious Finance Award, showcasing my ability to drive business development and innovation.

Overview

8
8
years of professional experience
6
6
years of post-secondary education
11
11
Certifications

Work History

Advanced Analytics - Manager

Sanofi
07.2022 - Current
  • Experienced people manager leading a global team of 12 professionals to drive data integration, deliver actionable insights, and implement advanced analytics solutions. Conducted global adoption training for stakeholders, covering data preparation and analytics using Power BI, ensuring seamless integration across diverse business units.
  • Led the Financial Data Foundation project, integrating all Financial ERPs across Sanofi into a unified Data Warehouse under the CFO and finance business partners. Migrated Financial and Market datasets to the Snowflake cloud platform, establishing robust Data Governance and Machine Learning standards. Achieved a monthly savings of 90 man-hours and received a Finance Award for excellence.
  • Engineered an end-to-end data warehousing and dashboard solution for the Finance team using IBM Cognos TM1 and Power BI, integrating IQVIA Market Access, Marketing Mix Models, and Financial ERPs. Delivered global ROI breakdowns, promotional effectiveness metrics, and market insights, improving data accuracy by 100% with Azure ML. Dashboards featured Market Growth, Market Share, Price Volume Effect, NPS, patient trends, and competitor benchmarks.
  • Analyzed product and service profitability by identifying P&L drivers, including manufacturing and SIOP, to uncover risks and opportunities. Developed advanced forecast models for revenue, pricing strategies, operating expenses, CAPEX, and new product launches, supporting strategic decision-making and resource optimization.
  • Applied Marketing Mix Modeling (MMM) and advanced ROI analyses to optimize promotional budgets, successfully guiding new product launches at Sanofi. Projects included customer profiling, segmentation, predictive modeling, and evaluating marketing strategies, influencing brand planning, digital marketing, and field force allocation.
  • Automated the Sales Incentive Calculation process globally using Power Automate and Power Apps, saving 18 man-hours monthly and receiving recognition for process innovation.
  • Developed an Omnichannel Tracker and Sales Analysis Dashboard using Veeva, providing global stakeholders with detailed KPI and sales performance breakdowns for quarterly, monthly, and mid-month analyses.

Data Specialist - Assistant Manager

Abbott Ltd
03.2021 - 07.2022
  • Prepared and designed financial analysis on Procure-to-Pay (PTP), Order- to-Cash (OTC), Employee Business Expense (EBE) and Payroll data (HR) from Oracle Hyperion Planning for all business units using Tableau, PowerBI Python and Qlik sense to support auditors globally in sampling, testing and risk assessment from key ERP Systems.
  • Data Transformation using Tableau Prep, SAP Business One and SAP HANA to make the data intuitive for analysis which is then published on the tableau server.
  • Automated the analytics on balance sheet and profit and loss statement from Oracle HFM server for testing all business units across countries using Automation Anywhere and Power Automate.
  • Prepared affiliate snapshot dashboard that provides key information on a particular country like workforce, divisional system matrix, coordinator list, prior audit findings, customer and product analysis, profit and loss statement, balance sheet, application reporting and top customer vs product analysis across a landscape of more than 100 ERP systems
  • Redesigned the audit data request process on Auditboard reducing request time and improved data quality across a landscape including financial data from the local systems as well as corporate systems to make it centralized for effective data management.
  • Developed a process to effectively perform completeness testing of audit data against data shared by Financial Team.

Business Intelligence Analyst - Manager

IDFC First Bank
11.2018 - 03.2021
  • Introduced Tableau in the Data Analytics Team, enabling real-time visualization of audit data across Core and Branch Departments. This streamlined anomaly detection, improved decision-making, and enhanced audit efficiency.
  • Programmed SQL queries and statistical calculations using Python on Tableau and Power BI to create dashboards for Retail Assets, Liabilities, Currency Chest, Digital Payments, and Audit Milestone status, delivering actionable insights.
  • Created advanced dashboard analytics to identify and monitor customers at risk of fraud, supporting proactive risk mitigation strategies and enhancing banking security.
  • Developed a Task Bot in Automation Anywhere to automate data cleansing for Internal Audit Data Indent requests and Open Observations from ServiceNow, saving 2 man-hours daily.
  • Automated email triggers for Audit leads to resolve open observations from ServiceNow, reducing manual follow-ups and saving 1 man-hour daily.
  • Created an IQ Bot in Automation Anywhere, standardizing data for internal auditors and streamlining annual risk assessments, saving 1–2 man-hours daily.

Business Analyst - Manager

Kotak Mahindra Bank
10.2017 - 11.2018
  • Streamlined workflows with Power BI dashboards to optimize NFTR cases, account opening TAT, and Service Requests in Core Banking Operations, achieving a 40% efficiency gain and earning a performance excellence award.
  • Designed analytics solutions to evaluate customer service requests, driving process improvements in retail assets and liabilities, with insights on loan timelines, payment delays, and satisfaction scores.
  • Automated complaint categorization in Retail Banking using IQ Bot and Word Mapping, speeding up resolutions and reducing manual effort.
  • Led “Project Velocity” by creating a Process Description Document, improving handling of account modifications and complaints, reducing closure times, and enhancing resolution rates.

Business Analyst - Assistant Manager

Yes Bank
10.2016 - 10.2017
  • Implemented AI-driven automation in Retail Banking, streamlining the account opening process and saving 8 man-hours daily, significantly boosting operational efficiency.
  • Digitized MIS reports for Retail Assets and Liabilities, leveraging Tableau Creator to develop SQL queries and complex scripts. Created End-to-End and Productivity Dashboards that improved process transparency and increased overall productivity by 50%.
  • Pioneered image-based processing for account instructions, leading the User Acceptance Testing and ensuring seamless implementation and migration, enhancing operational accuracy.
  • Established a centralized data warehouse for Retail Assets and Liabilities on Tableau Server at Yes Bank, integrating disparate datasets and enabling advanced analytics for improved decision-making and reporting efficiency.

Education

MBA - Finance

Welingkar Institute Of Management
Mumbai
05.2014 - 08.2016

Bachelor of Engineering - Computer Engineering

Datta Meghe College Of Engineering
Mumbai
03.2010 - 05.2014

Skills

Financial Analytics

Advanced Data Analytics

Data Engineering

Business Intelligence And Data Visualization Tools

Project Management

Robotic Process Automation

Machine Learning

Python Programming

Data Science

Business Development

Strategic Planning

Leadership

Commercial Analytics

SQL Developer

Software

Tableau

Microsoft PowerBI

SQL Development

Automation Anywhere

UIPath

Google Analytics

MS Office

Microsoft Azure

Python

TensorFlow

TM1

Oracle HFM

Financial Data Management

Internship

  • Axis Bank, Mumbai (Jan 15) : Studied processing of centralized Forex transactions
  • Indusind Bank, Mumbai (May 15) : Identifying operational risks in Forex Processes
  • Deloitte, Accenture, KPMG (Jun 20) – Data and Business Analytics

Certification

Lean Six Sigma Black Belt from KPMG

Accomplishments

  • Delivered financial savings of €300M, earning a Finance Award, reflecting impactful and innovative contributions to resource allocation and financial optimization.
  • Recognized with an Innovation Award for implementing the Salesforce App across the APAC region at Sanofi.
  • Awarded for automating the data request process for the Global Audit Team, reducing turnaround time to a single day at Abbott.
  • Honored for introducing AI-driven process automation in the Audit Department at IDFC First Bank, significantly improving efficiency.
  • Received a Scholarship from Automation Anywhere University for excelling in RPA learning modules with top scores.
  • Achieved the YES Brand Ambassador and YES Personality of the Year 2017 title at Yes Bank.
  • Awarded the rank of Black Belt from WFSKO in Karate, showcasing dedication and discipline.

Timeline

Microsoft Certified: Azure Developer Associate

10-2023

Advanced Analytics - Manager

Sanofi
07.2022 - Current

Microsoft Certified: Power BI Data Analyst Associate

07-2022

Data Specialist - Assistant Manager

Abbott Ltd
03.2021 - 07.2022

Master Robotic Process Automation Professional from Automation Anywhere University

07-2020

Developing AI Applications on Microsoft Azure from Coursera

07-2020

Advanced Google Analytics from Google Analytics Academy

07-2020

Deep Learning Using TensorFlow from IBM

06-2020

Applied Data Science Using Python from IBM

06-2020

Tableau Author, Consumer and Analyst

06-2020

Lean Six Sigma Black Belt from KPMG

05-2020

Advanced Robotic Process Automation Professional from UIPath and BluePrism

05-2020

Business Analyst, Bot Developer and RPA Program Manager from Automation Anywhere University

04-2020

Business Intelligence Analyst - Manager

IDFC First Bank
11.2018 - 03.2021

Business Analyst - Manager

Kotak Mahindra Bank
10.2017 - 11.2018

Business Analyst - Assistant Manager

Yes Bank
10.2016 - 10.2017

MBA - Finance

Welingkar Institute Of Management
05.2014 - 08.2016

Bachelor of Engineering - Computer Engineering

Datta Meghe College Of Engineering
03.2010 - 05.2014

Similar Profiles

CREATE PROFILE
Gopal NawaniBusiness Analyst