Pranav Kumar Email & Phone Number

Atlanta, Georgia, United States

- Developed a model to compare lead times, price, FLM, and MOQ of common parts and suppliers across global manufacturing network to determine a $44 million savings opportunity - Collaborated with cross-functional teams to validate impact of high opportunity parts by analyzing demand variability, purchase order history, unique supplier agreements, and consumption data- Synthesized data into relevant charts and graphs as well as calculated optimal lead times, price, and MOQ before presenting proposal to suppliers and making updates in material planning system

- Used CAD to develop models/prototypes of the wearable device as well as 3D print necessary molds- Synthesized various Tellurium yields using different reactions to determine which yield is most viable to use alongside an infrared photosensor- Analyzed and summarized related studies to expand the group’s knowledge pertaining to the study

Columbus, Indiana, United States

- Implemented key metrics dashboard for Regional Distribution Centers to monitor periodic performances on parameters such as order fill rate, back orders, past dues, inventory, and demand patterns- Analyzed and understood the end-to-end fulfillment process flow of parts demand and supply between MDC, RDC and customers- Collated data from multiple data sources such as ERP systems, data warehouse and reporting tools to normalize, cleanse, and prepare data for reporting- Used Power BI and SQL tools in addition to Oracle Business Intelligence suite to present the data as a dashboard to identify and analyze performance metrics

Indianapolis, Indiana, United States

- Researched and analyzed different methods of calculating safety stock, demand, and lead timeand compared it to multiple clients’ existing methods for improvement opportunities- Wrote a program in python based on my research and analysis that calculatessafety stock based on the distribution and correlation of historical data for lead timeand demand

- Worked in conjunction with Wabash National plant in West Lafayette to address their plant and warehouse optimization problems- Completed a plant optimization to accommodate for a planned 30% increase in material inflow- Analyzed ERP data, traffic patterns, and warehouse layout to derive a solution to the congestion caused by in the inflow of more material- Utilized stochastic modeling and simulation tools to analyze material flow and identify process gaps- Performed a cost-benefit analysis to determine the most cost-effective solutions based on Wabash National’s budget

- Collaborated with other Purdue students and the Indiana School for Blind and Visually Impaired to design a web-based program enabling visually impaired students to learn how to code- Developed a dictionary between Java and a Google Cloud API to convert natural language commands into coding syntax- Responsible for establishing a project partnership with the Indiana School for Blind and Visually Impaired to test our program and get feedback

Bachelor Of Engineering - Be, Industrial Engineering

Minor: Design and Innovation

High School Academic & Technical Honors Diploma