Operations manager with 5 years experience working in Supply chain Planning,  Sourcing, Category , Product Management 

VOLVO GROUP - Transport Network Optimization at Volvo Transport Parts, Export Operations

Database Modeling and BI Automation

LENOVO - Optimization of Customer Service Delivery at Lenovo, Data Center Operations

Simulation Modeling- Supply Chain Analytics

AMERICAN AIRLINES - Predictive analysis of Split Airline trips and operations risk management at American Airlines Crew Operations

AMERICAN AIRLINES : Variance Analysis of Actual and Planned Crew Operations Parameters at American Airlines

• Analysis and reduction of the standard deviation of error for a given set of data using regression. Found the optimized smoothing factors for forecasting the error free data. Developed models for the same.

Airline Freight Forecasting

Developed a patient case scheduling system for the Electrophysiology laboratory which included- 
• Generation of a user form on Microsoft Access using codes developed on Microsoft VBA which accepts patient data, procedural 
    requirements

Case Scheduling system- Data Modeling, VBA Macro programming

• Led a project team of four to design an innovative type of shell and tube heat exchanger to be used in an ethanol treatment plant with a mechanism to avoid the mixing and leakage of working fluids.
• Created the thermal and mechanical des

Double tube double tube sheet heat exchanger

•	Collaborated across cross-functional teams including Sales, Product, Finance to influence demand assumptions, scenarios, inputs and adjustments to consensus forecasts
•	Worked in partnership with NPI and Sustaining Operations, Materials Management, and Global Commodity teams to set optimal build plans & transportation choices to ensure supply is at the right place at the right time to meet worldwide demand
•	Lead weekly Planning, Forecasting & Replenishment discussions with our key stakeholders within SC, Sales, Finance or directly with our consumer electronics retailers / network carriers.
•	Maintained optimal levels of DC, channel inventory to balance availability and E&O through the various products' lifecycle.
•	Daily Responsibilities:
o	Developed short and long range supply/demand models that seek to minimize total costs and inventories while maintaining excellent service levels to our client partners and customers worldwide.
o	Present Supply/Demand recommendations to Executive 

•	Streamlined operations KPI reporting through automation using VBA Macros and data consolidation and modeling using SQL, Python 
•	Drove process improvement initiatives across Volvo Logistics Services through analysis of logistics service data 
•	Partnered with 3rd party logistical partners to gather metrics requirements, data collection and consolidation.
•	Delivered live dashboards reporting carrier /supplier delivery performance metrics to senior leadership and provided data-based recommendations for strategic decision making
•	Achievements:
o	Achieved time savings of 3 hours by introducing data extraction queries using SQL and Python, automating invoice tracking using VBA Macros and data modelling on MS Access
o	Slashed export emergency shipment lead time by 50% through optimization of transport plans and partnering with Warehouse management Systems

• Analyzed operations data, built predictive models using CART/CHART and ARIMA in R (wrote 400+lines of R code) for forecasting service delivery time series data 
• Designed an Optimal Service Action Policy for customer delivery scheduling process using Stochastic Optimization and Decision Modeling
Reduced process lead time by 20% of customer service delivery process through stochastic modelling of service data

Modeled the inventory and supply management database of Primrose Healthcare into an MS Access Database using VBA macro programming, SQL and developed an automated tool to access data and place orders.

• Extracted Crew Operations data from multiple Teradata databases using complex SQL joins, performed feature engineering and created new variables for analysis 
• Designed a go/no-go Decision model for crew swapping in airline trips by training a machine learning model (decision tree classification) in Python using Pandas and Scikit learn libraries
• Collaborated with analysts to formulate an analytical framework targeted to reduce Split Airline trips and revenue losses by 15%, visualized insights by delivering multiple Tableau dashboards
• Designed complex queries on T-SQL to extract and analyze Crew Revenue data for 2016 Q4 and 2017 Q5, generated internal reports using Advanced Excel and VBA Macros 
• Developed SAS Programs to identify factors responsible for variance in actual and planned synthetic, deadhead and other Crew Revenue KPIs, implemented a strategy for variance reduction

●	Identified performance improvement areas through variance analysis of actual/planned operations met

• Combined 40000 miles of vehicle probe data and corresponding traffic data by writing SQL queries 
• Established correlation between Driver Aggressiveness and Level of service (measure of road traffic) by training machine learning models – KNN clustering, logistic regression on high dimensional datasets

Achievements: Modeled a connection between driver behavior and service road levels by applying key machine learning methods and utilizing R. Prepared, validated, and assessed large datasets through data gathering, exploration and hypothesis testing.
• Successfully provided a large data set (three consolidated data sources) covering 40K miles of traffic data by data mining using SQL and derived metrics via feature engineering.
• Developed a model of driver behavior and traffic metrics within 90% accuracy by utilizing machine learning models, establishing connections between road level of service and driver aggressiveness.
• Drove on-road performance by 50% through recommending operatio

As student member of Supply Chain Resource Committee(SCRC) we helped Duke Energy in Supply Chain optimization
• Performed spend analysis, inventory analysis to segment inventory and prioritized items with forecast-able characteristics
• Developed forecasting model for 12 months for strategic utilities at SKU level using regression tools and key variables with high correlation to kWh sales; helping reduce inventory, create more space in warehouse and freeing up more cash on hand
• Forecast model helped in financial budget planning, maintenance and labor projections
• Developed guidelines and training material for users

•	Developed an interactive reporting tool using VBA Macros, enabling easy access to transaction and inventory data, automated KPI reporting process and forecasted demand trends.
•	Designed SQL queries for introducing new functionality in the application which reduced lead time and improved efficiency of business processes by 30%
•	Supported decision making activities through detailed analysis on supplier and transport data, generating work models and determining resource utilization 
•	Optimized distribution network and achieved 30% reduction in supply costs by collaborating with a cross-  functional team from Supply Chain, Sales and Operations; earned Excellence Award for project management.
Developed simulation models of business activities on SAS, analyzed sales and Marketing trends, provided solutions 
to manage risk and minimize revenue losses

Achievements:
●	Overhauled the sales KPI reporting through process mapping and automation, improving efficiency by 90%  
●	Received the Pe

• Worked directly with the founder of the online food delivery start-up to develop the product roadmap and business development model. Changed business model based on demand requirements.
• Effectively handled operations, responsibilities of which included forecasting and planning of sales and promotions, management of inventory and improvement and application of supply strategies.

• Improved process efficiency and removed non-value added activities which led to a time saving of 2 man-hours/shift 
• Performed trend analysis on historical supply data and suggested methods to improve lead time by 50%

<p class="leading-6">Skills: Stakeholder management, vendor relationship management, strategic sourcing, negotiations, contract management, Category management, Technology Procurement
.

Achievements:
Supported end-to end sourcing for supplier portfolio of 100+ vendors within categories - (software and cloud services) across business areas - Engineering, Product, Security, Infrastructure, Operations 
Managed supplier relations and built sustaining partnerships, conducted quarterly and monthly strategic business reviews ensuring adherence to SLAs and performance quality 
Consolidated contracts across company acquisitions and tier 3 suppliers resulting in savings of $1M 
Reduced total cost of ownership by 20% by driving savings through contract negotiations 
Streamlined Software Intake and Contract management process through collaboration with product managers and technical project managers
Senior Supply Chain Analyst - Software Category Management	Mar 2020 – Mar 2021
Drove the software sourcing pipeline tha</p>

Madhura Indurkar

Operations manager with 5 years experience working in Supply chain Planning, Sourcing, Category , Product Management