PRASAD MAHENDRA RAJPUT

Raleigh, NC, United States adm6jn@r.postjobfree.com +1-984-***-**** www.linkedin.com/in/prasad-rajput SUMMARY

Graduate Student in Industrial Engineering passionate about Supply Chain Analytics with a focus on Planning, Optimization and Business Solutions. Seeking full time roles starting July 2021. Willing to relocate anywhere in the United States.

EDUCATION

_

North Carolina State University August 2019 – Present Master of Industrial Engineering GPA-3.5/4

Veermata Jijabai Technological Institute, Mumbai August 2015 – May 2019 Bachelor of Technology in Mechanical Engineering GPA-7.55/10 TECHNICAL SKILLS

Programming and Software: Python, R, MATLAB, SQL, MySQL, Microsoft Access, VBA, Microsoft Excel, JMP, Llamasoft Supply Chain Guru X, MS Office, Visio, MS Project, Tableau, Minitab, AutoCAD, SolidWorks COMPANY PROJECTS

Predictive Analytics Student Consultant LENOVO – Raleigh, NC, USA Aug 2020-Nov 2020

• Performed data cleaning and exploratory analysis on RStudio. Utilised the data to forecast COVID cases as well as Demand for Commercial and Consumer products through various methods such as regression, logistic regression, decision trees etc. Developed a model with 80% accuracy that led to 25% cost savings. Designed a dashboard to study the trends in demands and cases as well as the relation between them using Tableau.

• Determined the base stock levels and formulated a Markov Decision Process to improve inventory management and minimize missed demands during the pandemic.

Data and Inventory Analytics Consultant Salvaterra Pottery – Weaverville, NC, USA Jan 2021-May 2021

• Designed a multi-user Order Management System using macros in VBA and ETL operations in SQL in MS Access Database. Utilised MS Visio for modelling processes and relational databases.

• Created a real-time dashboard to visualize KPIs, pending orders and Sales.

• Analysed stock levels, sales and lead time data to set up safety stock and production policies. PROJECTS

Regression Analysis to predict the compressive strength of concrete: Jan 2020-Feb 2020

• Built a regression model in R to understand the relationship between concrete strength and other properties of concrete.

• Utilized best subset selection, K-fold cross validation, ridge and lasso techniques to choose the best model to ensure accurate prediction.

Spare Parts Demand Forecasting: Jan 2020-Mar 2020

• Categorized 20,000 spare parts using HML and ABC Pareto analysis and forecasted demand using time series analysis techniques such as Moving Averages, Exponential Smoothing, Croston Method and ARIMA

• Determined the base stock inventory levels necessary to maintain a service level of 95% and achieved 29% cost savings across multiple products.

Design of Experiments for a Precision Parts Manufacturing System: Mar 2020-May 2020

• Designed a process experiment for the molding process to minimize the geometric variability by 35%.

• Performed hypothesis testing in JMP and analysed the data to identify significant factors and interactions affecting the variability.

• Built a regression model to predict variability from the significant factors and generated optimal settings for the factors based on the model.

Sichuan Telecom – Supply Chain Management Strategy: Mar 2020-May 2020

• Developed and examined push and pull strategies to reduce overstock and backorder problems at Sichuan Telecom.

• Determined the optimal inventory review periods for 21 district warehouses and the optimal locations to permit transshipments to reduce the variability in demands and pool the risk.

• Determined optimal locations to hold safety stock as well as safety stock levels to achieve a service level of 99% and estimated cost saving of 55%.

Revising Pharma Co Supply Chain Network: Nov 2019-Dec 2019

• Improved the Supply Chain Network of Pharma Co by closing 5 of their 13 distribution centres and maintaining a 99% service level using Supply Chain Guru X.

• A total cost saving of 15% was achieved after increasing the capacity of other 8 locations by more than 40%. Review of Harvard case study – Dynatrol Corporation: Aug 2019-Nov 2019

• Determined the bottleneck in the production line and critical WIP and found various improvements in the machine line design and a parallel rework line.

PRASAD MAHENDRA RAJPUT

Raleigh, NC, United States adm6jn@r.postjobfree.com +1-984-***-**** www.linkedin.com/in/prasad-rajput

Contact this candidate