Supply Chain Engineer

ANURAG PRAJAPATI

Houston, TX +1-832-***-**** *******************@*****.*** www.linkedin.com/in/anurag-prajapati-2095

Industrial Engineer, seeking full-time opportunities in Supply Chain Management and Process Improvement.

/EDUCATION

UNIVERSITY OF HOUSTON, TX Master’s in Industrial Engineering

Global Supply Chain, Operations Research, Business Intelligence, Engineering Analytics, Statistical Process Control

May 2019

UNIVERSITY OF MUMBAI Bachelor’s of Mechanical Engineering

Supply Chain Management, Production Planning & Control, Quality Engineering, Project Management

May 2017

WORK EXPERIENCE

Procurement Analyst Engie North America Inc., Houston, TX (Feb 19 – Present)

Generate RFI/RFP/RFQ competitive bidding events in Coupa to source HVAC/electrical/renewables/battery equipment.

Analyze historical data (Power BI) to study spend across different business units for various commodities or shared suppliers.

Develop procurement plan for renewable operations team & negotiate with high contributing vendors to save $1.2M annually.

Reduced invoice processing time by 43% by onboarding new supplier to Coupa and P2P process by electronic invoicing.

Design and develop dashboards to report dynamic performance of asset management/spend across BUs to stakeholders.

Implemented Kanban to track supplier performance in global sourcing to mitigate risk for direct/indirect commodities.

Process Optimization Intern Chirality Research, Houston, TX (Sep 18 – Dec 18)

Scripted ad-hoc queries to extract database from MongoDB and SQL for visualization of drilling of oil wells.

Developed statistical optimization model to predict completion cost of drilling a well and developed UI on R shiny.

Improved accuracy of Regression, Random forest, Decision tree to reduce RSME to $6,700 for the model on R programming.

Global Supply Chain Analyst Intern G. E. T. Enterprises LLC, Houston, TX (Apr 18 – Aug 18)

Implemented JIT inventory for on-time replenishment by managing end to end supply chain factories (China) and DC (Houston) by strategically placing blanket POs and increasing in-transit inventory.

Forecasted for over 10,0000 SKUS using 3/6/12 month moving average to keep backorder level under 5%.

Planned inventory level and re-order point on WMS(Netsuite), comparing it with sales forecasted by improving test accuracy by 95%. (Also tested ARIMA’s forecast to check performance).

Documented, negotiated, consolidated Global Inbound Freight for (FCL, LCL, TL, LTL) containers by evaluating freight optimization performance for freight bill/route to save $1.1M annually using network visualization on Tableau.

Categorize SKUs intomatrix with high to low sales and inventory utilization using cluster analysis on Python for better product-life cycle and discontinue low sales and high inventory products.

Supply Chain Analyst Ahluwalia Contracts (India) Ltd., Mumbai (Jun 16 – Jul 17)

Coordinated in purchasing and planning activities to procure raw materials (steel & concrete) for projects over $120M in SAP.

Implemented SCOR model to develop site-based capacity models to plan budget/optimum inventory and transport.

Revised NCR for quality checks to match product compliances by vendor while maintaining CAPA for errors.

Industrial Engineer Intern KLT Automotive & Tubular Products LTD, Mumbai (May 15 – Aug 15)

Developed operations plan to manufacture products witnessing demand volatility from sales forecast.

Performed process mapping(Visio) & time-motion study to improve throughput by 22%, eliminating bottlenecks at workstation.

ACADEMIC PROJECTS

Tooling family analysis to reduce setup time between jobs (Superior Energy Services scikit-learn, pandas, FMEA, TPM)

Performed tooling analysis on VT-36 CNC Lathe to decrease setup time by using cluster analysis of tools which reduced downtime of machines by 421 hours annually saving $9000/per employee/per machine/year.

Total Site Electricity Usage Prediction (RECS ggplot, dplyr, glm, rpart, tree, R)

Accumulated data from RECS and applied various regression techniques to train different models like CART, BART, Bagged and Boosted Trees to reduce the RSME to select the best output to study the majors causes of electricity in the specific area.

Simulated a Supply Chain selling Muesli Cereals, using SAP HANA & Predictive Analytics(SAP Lumira, SAP HANA S/4, Excel Pivot)

Extracted, Transferred and Analyzed Raw master data from SAP ERP to understand the regional sales, record revenue generating KPI’s and production schedule and market trend to generate €14,317590 sales, by controlling parameters such as marketing and production.

Optimization of Transportation Cost from Factories to Shop for a chemical plant (GAMS, Excel Solver)

Formulated a Mixed Integer LP to minimize the transportation cost for trucks to $ 2742.38 subject to the constraint of distance between DCs and retail stores, truck loading capacity, fixed cost, supply & demand constraint motive to reduce empty miles on truck.

Improve Product Development Lead Time for Textile Industry (Minitab, dplyr, ggplot, Root cause analysis, AutoCAD)

Performed RCA analysis using SPC controls tools and DMAIC to eliminate the natural causes and decrease the overall idle time for machine by 16.74% using Minitab and also performed Value Stream Mapping to reduce steps used in procurement of raw materials.

Contact this candidate