Summary
Overview
Work History
Education
Skills
Websites
Awards
Projects
Timeline
Generic
Santosh Gadewar

Santosh Gadewar

PowerBI Analyst
Pune

Summary

Experienced professional with over 12 years of diverse expertise in Business Intelligence (BI) tools, Financial Reporting, Account Management, Supply Chain Management, and Operations. Proficient in leveraging Power BI Analytics alongside visualization tools such as Excel Dashboard and Excel Linked Website Table. Currently expanding skill set with Power BI and Smartsheet. Strong background in Financial Reporting, with expertise in SAP MM & SD Module.

Overview

13
13
years of professional experience
4
4
Languages

Work History

Assistant Manager MIS Business Intelligence

WNS Global Services
Pune
10.2022 - Current
  • Awarded league of Champion Award for Quality automation resulting in 30% reduction in manual data entry, leading to improved data accuracy and efficiency
  • Collaborated with stakeholders to gather and understand business requirements for data analysis and reporting
  • Developed and maintained Power BI dashboards and reports to visualize complex data sets and metrics, facilitating data-driven decision-making
  • Created interactive and visually appealing data visualizations to effectively communicate key insights
  • Performed data cleansing, transformation, and modeling to ensure accuracy and consistency of data
  • Optimized Power BI reports for performance and scalability, considering large datasets and complex queries
  • Provided training and support to end-users on navigating and interpreting Power BI dashboards and reports.
  • Implemented staff training programs, enhancing product knowledge and improving customer service skills

Account Manager

Cummins Generator Technologies
Pune
03.2021 - 10.2022
  • Leveraged Power BI Analytics to analyze account data and derive actionable insights, contributing to strengthened customer relationships and increased sales
  • Spearheaded order to cash cycle management using Power BI dashboards, optimizing processes and improving efficiency
  • Implemented Power BI reports to track customer quality issues and coordinate with internal teams for resolution, driving continuous improvement initiatives
  • Utilized Power BI Analytics for material planning, supplier quality monitoring, and open order tracking, enhancing supply chain visibility and performance
  • Developed Power BI dashboards to communicate supplier delivery performance and resolve quality issues, improving overall supply chain efficiency.

Assistant Manager SCM

Knorr-Bremse
Pune
03.2020 - 11.2020
  • Utilized Power BI Analytics for material planning, supplier quality monitoring, and open order tracking, enhancing supply chain visibility and performance.
  • Developed Power BI dashboards to communicate supplier delivery performance and resolve quality issues, improving overall supply chain efficiency.
  • Managed inventory levels to minimize stockouts while reducing overhead costs
  • Improved customer satisfaction by addressing and resolving complaints promptly

Deputy Manager Demand Manager

Continental
Pune
11.2017 - 03.2020

Assistant Manager Customer Support

Brembo Brake India Pvt. Ltd.
Pune
06.2017 - 11.2017

Deputy Manager SCM

Continental
Pune
05.2015 - 06.2017

Specialist Planning

Flextronics
Pune
06.2014 - 06.2015

Engineer- Supply Chain

TE Connectivity
Pune
06.2011 - 05.2014

Education

Bachelor of Engineering (B.E.) - Mechanical Engineering

Kavikulguru Institute of Technology & Science
Nagpur
01.2009 - 04.2011

Diploma - Mechanical Engineering

SSPC
Chandrapur India
01.2005 - 04.2008

SSC - Secondary Education and Teaching

LTV
Chandrapur
01.1997 - 04.2003

Skills

Workforce Management

DAX

Forecasting

Macros

Microsoft Power BI

Smartsheet

Supply Chain Management

VBA Excel

Workforce Management

Excellent Communication

Multitasking Abilities

Critical Thinking

Supervision and leadership

Awards

  • SuperChampion 2017, 02/2017, Continental Automotive Components India Pvt Ltd
  • SuperChampion 2016, 02/2016, Continental Automotive Components India Pvt Ltd

Projects

  • VBA Automation for Quality Audit projects 01/2024 - 02/2024
    Led the implementation of VBA automation for Quality Report collection to streamline data gathering processes and improve reporting efficiency. Developed customized VBA scripts to automate data extraction, formatting, and consolidation from multiple sources into standardized Quality Reports. Collaborated with Quality Assurance teams to understand reporting requirements, optimize data validation processes, and ensure data accuracy and completeness. Provided user training and support to enable stakeholders to utilize the automated solution for timely and accurate reporting, resulting in improved operational efficiency and decision-making.
  • PowerBI- Voice of Customer Dashboard 11/2023 - 12/2023
    Led the development of a Voice of Customer (VoC) Dashboard to enhance customer experience insights and drive business improvements. implemented an interactive dashboard using Power BI to aggregate and analyze customer feedback data from various channels, including surveys, reviews, and social media. Collaborated with crossfunctional teams to define key metrics, automate data collection, and visualize customer sentiment trends. Provided user training and support to empower stakeholders to leverage the dashboard for actionable insights and strategic decision-making aimed at enhancing customer satisfaction and loyalty.
  • PowerBI- HeadCount/Employee Dashboard 08/2023 - 10/2023
    Led the implementation of a Process Headcount Dashboard to optimize workforce management and resource allocation. Designed and deployed a comprehensive dashboard using Power BI to visualize headcount metrics, monitor staffing levels, and track workforce trends across departments and teams. Collaborated with HR and departmental stakeholders to define key metrics, automate data integration processes, and ensure data accuracy and reliability. Provided user training and support to enable stakeholders to leverage the dashboard for strategic workforce planning and decision making.
  • PowerBI- Quality Dashboard 06/2023 - 08/2023
    Led the development of a Process Quality Check Audit Dashboard to streamline quality assurance processes and enhance operational efficiency. Designed an interactive dashboard using Power BI to visualize audit results, track compliance metrics, and identify areas for process improvement. Collaborated with stakeholders to define key performance indicators (KPIs), automate data collection, and implement real-time monitoring capabilities. Facilitated user training and support to ensure effective utilization of the dashboard for informed decision making and continuous quality improvement initiatives.
  • PowerBI- SLA Dashboard 03/2023 - 05/2023
    Led the implementation of a Power BI solution for Service Level Agreement (SLA) monitoring, aimed at improving service delivery performance and compliance. Developed a dynamic dashboard to provide real-time visibility into SLA metrics, including response times and resolution rates, enabling proactive identification of issues and driving continuous improvement initiatives. Collaborated with cross- functional teams to gather requirements, integrate data sources, and ensure user adoption through comprehensive training and support.

Timeline

Assistant Manager MIS Business Intelligence

WNS Global Services
10.2022 - Current

Account Manager

Cummins Generator Technologies
03.2021 - 10.2022

Assistant Manager SCM

Knorr-Bremse
03.2020 - 11.2020

Deputy Manager Demand Manager

Continental
11.2017 - 03.2020

Assistant Manager Customer Support

Brembo Brake India Pvt. Ltd.
06.2017 - 11.2017

Deputy Manager SCM

Continental
05.2015 - 06.2017

Specialist Planning

Flextronics
06.2014 - 06.2015

Engineer- Supply Chain

TE Connectivity
06.2011 - 05.2014

Bachelor of Engineering (B.E.) - Mechanical Engineering

Kavikulguru Institute of Technology & Science
01.2009 - 04.2011

Diploma - Mechanical Engineering

SSPC
01.2005 - 04.2008

SSC - Secondary Education and Teaching

LTV
01.1997 - 04.2003
Santosh GadewarPowerBI Analyst