Engineering Assistant

ABHIJIT PADHI

Dearborn, MI ***** Email: ********@*****.*** Phone: +1-313-***-****

LinkedIn: https://bit.ly/2qNJ1rE Tableau: https://tabsoft.co/2XdZodl GitHub: https://github.com/abhijitp17 SUMMARY

Graduate with a master’s degree in Industrial and Systems Engineering with a specialization in Supply Chain Management and Data Analytics.

Areas of Expertise: Industrial Engineering, Supply Chain Management, Data Analytics, Quality Management, Business Intelligence EDUCATION

University of Michigan-Dearborn Sept 2018 – Apr 2020 Master of Science – Industrial & Systems Engineering GPA: 3.67 Courses: Supply Chain Management, Operations Research, Data Analytics, Statistics, Quality Management, Systems Engineering, Project Management New Horizon College of Engineering, India Aug 2013 – May 2017 Bachelor of Engineering – Mechanical Engineering GPA: 3.70 WORK EXPERIENCE

Data Analytics Consultant – Intern Feb 2020 – Mar 2020 Umlaut Inc., Southfield, MI, USA (Client – Ford Motor Company)

• Worked with Connected Vehicle Platform and Products (CVPP) team on vehicle launch timeline and testing data

• Managed data received from multiple sources, cleansed data as per requirement and developed data storage solutions using Alteryx

• Developed descriptive analytical models to explore KPIs and find relationship between different features

• Created visualization dashboards to draw insights and recommendations & communicated project progress to senior management

[Tools/Skills: Alteryx, Tableau, JIRA, Descriptive Statistics, KPI, Data Visualization, Business Intelligence] Supply Chain Analyst Mar 2018 – Jun 2018

Headout Inc., Bangalore, KA, India

• Management of inventory to ensure efficient pricing and availability of products

• Collaborated with suppliers to maintain product information and build solutions across product related issues

• Participated in outbound logistics by working on received orders, crosscheck inventory for availability and shipping products to customers

• Worked on complex data to create KPI metrics & setup dashboards for optimizing the process and pricing of the products

• Coordinated projects with technology team into analysing and forecasting sales trend to automate the inventory and order process

• Improved the profit margin by 17% by automating the inventory and reducing lead time

[Tools/Skills: MS-Excel, SalesForce, Inventory Management, Demand Forecasting, KPI, Data Visualization, Optimization, Troubleshooting] Manufacturing & Operations - Intern Jul 2015 – Dec 2015 Kartech Engineering, Bangalore, KA, India

• Supported the design team in developing chassis design and analyzing using CATIA V5 & ANSYS V14.0

• Participated in DVP&R and conducted FMEA of the Go-karts chassis design and fabrication process

• Conducted cost estimation planning during product development & decreased scrap by 13% through lean manufacturing

[Tools/Skills: MS-Excel, Lean Manufacturing, BOM, FMEA, Cost Estimation] PROJECTS

Sales forecasting of Walmart stores 04/2020

• Forecasted the sales of 45 Walmart stores data which was collected from Walmart Recruitment Challenge (Kaggle.com)

• Conducted feature selection by considering VIF score and correlation amongst features

• Conducted Time Series Analysis using ARIMA model to make the data stationary and forecasted the sales for following years

[Tools/Skills: Python, Time Series Analysis, Forecasting, Data Visualization] Analyst Accuracy and Stock Price Prediction 12/2019

• Developed models to calculate the accuracy of stock price predictions made by the CFA using Logistic Regression

• Used Artificial Neural Network to predict closing stock price of a corporation and conducted quantitative analysis of the data

[Tools/Skills: Python, Quantitative Analysis, Artificial Neural Network] Breast Cancer Prediction using Machine Learning methodology 11/2019

• Worked on predicting breast cancer based on two types of tumors

• Used scikit-learn libraries (logistic regression, random forest) in python to test the accuracy of training and testing data

[Tools/Skills: Python, Machine Learning, Classification models] Service Quality Improvements for Southwest Airlines at Prime hubs 10/2019

• Collected data from the Bureau of Transportation Statistics (BTS) on the on-time performance of the Southwest Airlines

• Prioritized the airports with the help of individual contribution to the Chi-square which has most association with delays

• Identified certain regions to increase on time performance with the help Chi-Square test in Minitab

[Tools/Skills: Minitab, MS-Excel, Tableau, Hypothesis Testing] Data Analysis in Transportation Systems 04/2019

• Used geographic location and address to create network diagram using ArcGIS to improve commuting services for university students

• Came up with a solution which could be used as a business plan to improve transportation systems for commuting services

[Tools/Skills: Minitab, ArcGIS, MS-Excel, Transportation Network Design] Clustering Analysis for Customer Profiling 12/2018

• Conducted Clustering Analysis of customer survey to improve marketing strategy & product procurement plans of a company

• Segmented customer base into clusters based on similarity of responses and characteristics to give structure & find relationship

[Tools/Skills: Minitab, MS-Excel, Tableau, Clustering Analysis] Predictive Analytics for Bike Rental Company 11/2018

• Conducted Time Series Analysis and Forecasting techniques in Minitab to analyze the demand for a bike rental company

• Forecasted data was used by inventory management team to purchase and stock the bicycles based on the demand

[Tools/Skills: Minitab, MS-Excel, Time Series Analysis, Forecasting, Inventory Management] ACADEMIC EXPERIENCE

Teaching Assistant Sept 2019 – Apr 2020

University of Michigan – Dearborn, USA

• Worked as a graduate teaching assistant for the graduate course IMSE 586 – Big Data Analytics & Visualization and undergraduate course IMSE 317 – Probability & Statistics

Research Assistant Sept 2015 – Oct 2016

New Horizon College of Engineering, India

• Worked as a research assistant for the Department of Mechanical Engineering, New Horizon College of Engineering

• Supported the research team in designing vehicle chassis parts using CATIA V5R20 and conducting CAE simulations using ANSYS 14.0 Multiphysics Simulation

• Led a team of 24 members to design and fabricate a fuel-efficient go-kart and improve crashworthiness with design constraints

• Conducted research in enhancing the factor of safety of a go-kart chassis and optimizing the chassis design to increase safety during front impact

• Supported Formula SAE team of the university in conducting competition-based research PUBLICATIONS

• Swami S., KD Bopanna, Padhi A. “Microstructure and Mechanical Properties of Aluminium Metal Matrix Composites”, International Journal of Technical Innovations in Modern Engineering & Science, 4(7), 2018, 53-59

• Padhi A., Joshi A., Hitesh N. and Rakesh C., “Increase Factor of Safety of Go-Kart Chassis during Front Impact Analysis”, International Journal for Innovative Research in Science & Technology, 3(4), 2016, 385-390 SKILLS

Programming & Database: Python (Numpy, Pandas, SciKit-Learn, Scipy, Seaborn, Matplotlib), R, MySQL Analysis & Visualization Tools: MS Excel (VBA & Macro), Minitab, SPSS, Alteryx, Tableau, Business Intelligence, SalesForce CRM Project Management: JIRA, Trello

Statistical Methods: Descriptive Statistics, Prescriptive Statistics, Predictive Statistics, Hypothesis Testing, ANOVA Machine Learning Models: Classification (Linear & Logistic Regression, Naïve Bayes, k-NN, Random Forest, Decision Tree), Clustering (K-Mean, Hierarchical), Dimensionality Reduction (PCA), Time Series Analysis (ARIMA) Supply Chain & Quality Skills: Demand Forecasting, Inventory Management, Demand Planning, Cost Estimation, EOQ, BOM, Troubleshooting, Lean Six Sigma, DMAIC, Kaizen, 5S, 8D, PPAP, APQP, Root Cause Analysis, Statistical Process Control, Lean Manufacturing, DVP&R, PFMEA, DFMEA CERTIFICATIONS

• Supply Chain Analytics – MITx Open Learning In Progress

• Python for Data Science and Machine Learning Bootcamp – Udemy In Progress

• Data Analysis with Python - IBM

• Python for Data Science - IBM

Contact this candidate