Dynamic Senior Manager with extensive experience at ZF India Pvt. Ltd., specializing in supply chain optimization and data visualization. Proven track record in automating processes and enhancing decision-making through real-time dashboards. Skilled in Power BI and effective communication, driving cross-functional collaboration to achieve strategic goals.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Manager
ZF India Pvt. Ltd.
Pune
10.2021 - Current
Perform advanced data mining across enterprise data warehouses and multiple data sources to drive performance insights in logistics and supply chain planning.
Serve as the business lead for the Inventory Measure Tracking Tool, enabling cross-plant visibility into inventory initiatives and performance.
Oversee dashboard updates using real-time data to support informed decision-making based on inventory metrics and Inventory Turnover Ratio (ITR) insights.
Implement inventory classification techniques such as ABC analysis and Economic Order Quantity (EOQ) to enhance stock management and reduce carrying costs.
Automate excel trackers using Power Automate and SharePoint.
Design and maintain integrated business views for data models grounded in comprehensive Bill of Materials (BOM) structures, enabling full end-to-end visibility across the supply chain.
Consolidate data from ERP systems to create unified, real-time dashboards that serve as control towers for monitoring and optimizing supply chain operations.
Collaborate with Information Architects to understand data architecture, metadata tagging, and storage strategies to ensure data integrity and accessibility.
Design and develop self-service analytics applications using tools like Power BI and SAP Analytics Cloud (SAC) to address specific supply chain challenges and business use cases.
Lead pilot initiatives to test and validate new analytics concepts in collaboration with business divisions and manufacturing plants.
Develop and implement rollout strategies and training programs to drive adoption of new analytics tools across supply chain teams.
Senior Analyst
Eaton Technologies Pvt. Ltd.
Pune
06.2019 - 10.2021
Performed detailed analysis on Key Performance Indicators of Spend and Savings Data.
Drive procurement analytics by performing spend analysis and identifying cost-saving opportunities using tools like Python, Excel, and Power BI; apply clustering algorithms and association rule mining (Apriori) to optimize vendor selection and enhance sourcing strategies.
Lead Environmental, Social, and Governance (ESG) analytics initiatives by monitoring key environmental metrics such as carbon footprint (CO2e per unit output), energy consumption across the supply chain. Utilize tools like Power BI to analyze sustainability data and support data-driven strategies that enhance environmental performance and ensure regulatory compliance.
Automated manual excel reports using Python to improve efficiency and quality.
Sr. Business Analyst
Shipco IT Pvt. Ltd
Pune
12.2015 - 06.2019
Completed transition of Analytics teamwork from Thailand office to Pune office.
Analyze shipping carrier data—including transit times, cost per shipment, and service reliability—using Excel, Power Query, and Power Pivot to build dynamic dashboards and support strategic logistics decisions.
Built forecasting model to predict sales region-wise and highlighted regions to be focused.
Conducted customer satisfaction surveys and performed text analytics.
Led analytics projects using regression, logistic regression, time series analysis with Python.
Data Specialist
Mindcrest
Pune
12.2013 - 12.2015
Performed macro programming in Excel for complex data transformations.
Developed dashboards to monitor case processing and associate performance.
Analyzed employee satisfaction survey using cluster and factor analysis.
Business Analyst
Tracmail India Pvt. Ltd
Pune
07.2013 - 12.2013
Prepared volumes and quality reports using Excel, Access and SQL.
Analyzed raw data and developed recommendations using PCA.
Statistical Analyst
Tata Motors
Pune
08.2011 - 07.2013
Performed reliability analysis using Poisson, Exponential and Weibull models.
Writing SQL scripts to manipulate data for data loads and extracts.
Conducted DFMEA and supported test engineers in developing test scenarios.
Forecasted sales using ARIMA and optimized testing using DoE.
Automated excel reports using excel macros.
Education
Master of Science - Statistics
Pune University
Pune, India
07.2011
Bachelor of Science - Statistics
Pune University
Pune, India
07.2009
Higher Secondary Certificate - Science
Maharashtra Board Exam
06.2006
Secondary School Certificate -
Maharashtra Board Exam
06.2004
Skills
Power BI and SQL scripting
Data analysis and visualization
Business intelligence and reporting
Supply chain optimization
Process automation
Cross-functional collaboration
Stakeholder engagement
Effective communication
Problem solving
Team leadership and training
Certification
Microsoft Certified: Power BI Data Analyst Associate (Microsoft certification ID: 14066991)
Certified in 'Intro to Python for Data Science' by DataCamp
Certified in 'Basic R' by WISDOM JOBS
Certified in 'Statistics graphs using Excel' by Udemy