Nikhil Mehra

***N River Road, West Lafayette, IN ady1gh@r.postjobfree.com +1-765-***-**** Linkedin

EDUCATION

Purdue University, West Lafayette August 2021-May2023 Master of Science in Industrial Engineering, Concentration: Computational Science and Engineering (3.9/4) GB Pant University of Agriculture and Technology, Pantnagar, India Aug 2014-July 2018 Bachelor of Technology in Mechanical Engineering, (8.2/10)

*Received Vice chancellor’s Gold medal for being top graduating student PROFESSIONAL EXPERIENCE

Data Analyst Consultant Purdue University(Client:Accenture), United States Jun 2022 -Aug2022

• Developed dashboards in Tableau for Accenture to visualize thousands of rows of patient data helping client to draw insights and readily identify gaps in medical tests and also analyse the performance of 1000+ clinics across US using HEDIS data.

• Lead a team of 5 coordinating team activities with Accenture Team to meet weekly goals and deadlines. Senior Engineer, Supply Chain IndianOil Adani Gas Pvt. Ltd., India July 2018 – July 2021

• Conducted detailed analysis of supply chain data to identify trends, optimize inventory levels, and reduce costs, resulting i n a 7% reduction in overall supply chain expenses.

• Prepared tenders, quotations, and purchase orders for material, managing 3 million worth of running inventory data using the company’s ERP software (SAP) and Excel leading to 200 thosusand worth of annual savings in inventory and operational costs.

• Collaborated in continuous improvement efforts to reduce daily gas losses for the company resulting in gas loss reduction from 7% to 2% resulting in savings of 2 million Rupees per month.

• Developed and maintained demand forecasting models, improving forecast accuracy by 5% and ensuring optimal inventory levels to meet customer demand.

• Collaborated cross-functionally with procurement, project execution, and vendors to streamline processes and enhance communication, leading to a 5% decrease in lead times and improved order fulfillment.

• Utilized advanced data analytics in Excel to create insightful dashboards and reports, providing real-time visibility into key supply chain metrics and facilitating data-driven decision-making.

• Conducted regular inventory audits and cycle counts, maintaining an accuracy rate of 98% and minimizing discrepancies between physical and recorded inventory levels.

• Managed vendor relationships, negotiated pricing terms, and evaluated supplier contracts, contributing to a 5% reduction in procurement costs while maintaining product and service quality standards.

• Developed and communicated material planning forecasts and reports to key stakeholders, facilitating informed decision- making and alignment across departments.

• Managed end-to-end material planning activities, ensuring timely availability of critical components while minimizing excess inventory and stockouts.

• Maintained key performance indicators (KPIs) to monitor supply chain performance, facilitating data-backed decision- making and driving process improvement.

• Utilized root cause analysis techniques to identify the underlying causes of inventory discrepancies and implement corrective actions, resulting in reduction in inventory inaccuracies. Manufacturing Intern NHK Springs Pvt. Ltd., India June 2016 – Aug 2016

• Managed day to day activities related to spring manufacturing for automobile suspension.

• Studied the manufacturing processes involved in spring manufacturing of Automobile suspension system.

• Recommended improvement in painting process leading to saving of time in the process by 5% per part produced. ACADEMIC PROJECTS

Leftover Food management Supply Chain System at Purdue Dining Hall using Arena Simulation software, 2021

• Collected data and Created efficient system for leftover food management in Purdue university dining halls, using programming in arena simulation software, resulting in well received model to reduce food wastage. Created a statistical model to study factors affecting weld properties in Minitab, 2021

• Created a full factorial design in Minitab to study the effect of weld speed, filler material and current on weld strength. Personnel Scheduling using simplex algorithm from scratch in Python (Numpy and pandas), 2022

• Programmed simplex algorithm from scratch using Numpys and pandas libraries in python for personnel scheduling using linear programming.

Database model for inventory management in automobile assembly plant using MySQL, 2022

• Created a database management system for inventory management in automobile assembly plant using MySQL. SOFTWARE SKILLS

• SAP, Microsoft Excel, AUTOCAD, CATIA, ARENA, Minitab, Python,Matlab EXTRA CURRICULAR ACTIVITIES

• VP of Social Events- INFORMS, Purdue Student Chapter,2022-2023 -Lead a team of 4 to organize social events and encourage student participation.

Contact this candidate