Summary
Results-oriented Data Analyst with expertise in leveraging Python programming and analytical tools for extracting actionable insights. Proven ability to develop and implement advanced statistical and machine learning models for demand planning, forecasting, and supply chain optimization. Adept at managing large volumes of data and driving continuous improvement through data-driven decision-making.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Analyst
Tech Mahindra
02.2023 - Current
- Techno-Functional Analyst with a specialized focus on demand and supply planning, utilizing cutting-edge O9 software
- Applied predictive modeling and forecasting techniques to optimize demand planning, inventory, and supplier performance
- Proficiency in a diverse technological toolkit, including IBPL, SQL, O9, and R
- Demonstrated the ability to translate complex demand planning and supply plan data into actionable insights
- Developed interactive Tableau dashboards that provide stakeholders with intuitive visualizations, facilitating informed decision-making and strategic planning.
Consultant in Supply chain
Deloitte
08.2021 - 01.2023
- Consultant specializing in Oracle Cloud solutions for supply chain management
- Engage in collaborative partnerships with stakeholders to devise tailored strategies, ensuring optimal utilization of Oracle Cloud capabilities
- Led cross-functional collaboration efforts by actively engaging with stakeholders to design and configure Oracle Cloud Inventory and Procurement modules
- Demonstrated proficiency in Oracle Cloud, SQL, and Tableau, leveraging these technologies to drive seamless integration and data-driven decision-making
- Defined functional specifications, system design, and business process flows for Oracle Cloud implementations.
Supply chain Analyst
Hero Cycles Ltd.
07.2013 - 05.2019
- Conducted data analysis and modeling to support demand planning, forecasting, inventory management, and supply chain optimization for a leading bicycle manufacturer
- Developed and implemented data-driven solutions that resulted in an annual savings of 21 Crores, improved operational efficiency, and reduced waste
- Driving the Supply Chain Processes and efficiencies at the plant and co-pack operation and Co-ordination, Supply planner and manufacturing teams for ensuring production plan compliance
- Created and maintained dynamic dashboards using Advanced Excel and Tableau to provide real-time visibility into key supply chain metrics and KPIs
- Proficiency in SAP S/4HANA and Material Planning Software Systems
- Identified and resolved process inefficiencies and bottlenecks by applying Lean Six Sigma principles and proposing optimization solutions
- Led inventory optimization initiatives by employing ABC and XYZ analysis, leveraging statistical techniques to classify and prioritize inventory items based on their demand patterns and cost implications.
Education
PGP: Data Science and Business Analytics -
01.2023
MBA: General Management -
01.2021
Bachelor of Engineering: Mechanical -
01.2013
Skills
- Client management
- Client Relationship Management
- Data Analysis
- Performance monitoring
Certification
Lean Six Sigma, Certified Scrum Master, Oracle Cloud Inventory, Supply Chain Optimization
Programming
Python, R, SQL
Tools
Tableau/Power BI, KNIME, SAP S/4HANA, Oracle Cloud, O9
Specialized Skills
Time Series Forecasting, Demand Planning, Supply Chain Planning, Data Science
Capstone Project
Forecasting Wine Sales for ABC Estate Wines company, Analyzed historical monthly sales data, developed multiple forecast models for two distinct products within a specific Wine Estate. Recommended the optimal forecasting model, projecting monthly sales for the next 12 months, incorporating lower and upper confidence limits.
Projects
Predictive Modelling, This project comprises two components: a) Computer-Active Project: Implemented Linear Regression to predict the percentage of time a computer remains in user mode. b) Women's Project: Utilized Classification techniques to categorize women based on pill usage. Segmentation using Clustering and PCA, Addressed challenges in a dataset with numerous variables by employing Data Science Techniques. Conducted Exploratory Data Analysis (EDA), followed by Clustering and Principal Component Analysis (PCA). Achieved two primary objectives: 1. Conducted Digital Marketing Advertisement Data Segmentation using clustering techniques. 2. Identified Optimum Principal Components explaining the most variance in Primary Census data. Advance Statistics Graded Project DSBA New Structure, Applied learned techniques from the Advanced Statistics Module to solve problems related to Probability, Probability Distribution, Hypothesis Testing, and ANOVA topics.
Timeline
Senior Analyst - Tech Mahindra
02.2023 - Current
Consultant in Supply chain - Deloitte
08.2021 - 01.2023
Supply chain Analyst - Hero Cycles Ltd.
07.2013 - 05.2019
The University of Texas (Great Learning) (Part time) - PGP: Data Science and Business Analytics,
K J Somaiya Institute of Management - MBA: General Management,
Punjab Technical University - Bachelor of Engineering: Mechanical,