KARAN PAREKH

Jersey City, NJ 857-***-**** add4gm@r.postjobfree.com

www.linkedin.com/in/karanparekh0918

Education

University of New Haven, West Haven, CT Jan 2018-May 2020 Master of Science in Engineering and Operation Management – (3.3 GPA) Relevant Courses: Supply Chain Management, Project Management, Lean Concepts and Applications, Deterministic Operations Research, Product Development, Scheduling and Inventory Control, Sourcing and Procurement. Gujarat Technological University-(SVIT), Vasad, Gujarat Aug 2013-May 2017 Bachelor of Engineering in Mechanical Engineering – (3.5 GPA) Skills

Certification: Complete SQL Bootcamp-Udemy, AWS Data Analytics Fundamentals, AWS Cloud Practitioner Essentials, Advanced Google Analytics, Six Sigma: Black Belt, Supply Chain Foundations, SAP ERP Beyond the Basics-LinkedIn, Tableau Essential Training, SAP MM (Materials Management), SAP SD (Sales and Distribution), SAP (Transportation Management). Programming Language and Tools: DBMS (SQL, MS Access, SAP ERP), BI (Tableau, Power BI), Data Insights (AWS Web Analytics, Google Analytics), Advanced MS Excel (Pivot Tables, Lookup, Macros, VBA), MS Project (WBS, Gantt Chart). Soft Skills: Process Improvement, Material Planning, Data Analytics, Lean Six Sigma, Agile Project Management & Facilitation, Time Series, Continuous Improvement and Optimization, Technology and Operations Strategy. Professional Experience

All India Pharma, Gujarat, India Jan2017-Aug 2017

Supply Chain Intern

• Improved efficiency of the purchase order by 13.6 percent/month/buyer; by identifying KPIs related to supplier quality and purchase order cycle time using SIPOC analysis and process mapping.

• Analyzed 5 years of sales and inventory data using Excel; to recommend new re-order limits (ROL) to the procurement manager resulting in a 30 percent reduction of the total inventory costs.

• Analyzing actual demand vs. sales forecast to reach 90% forecast accuracy goal and help maintain high customer service level.

• Developed a dashboard with Advanced Excel Tool and VBA Macros to analyze data and losses at the packaging station.

• Carried out Kaizen Training and Implementation on shop floor during ‘Kaizen week workshop’, analyzed VA and NVA activities with Value Stream Mapping and Spaghetti Charts. H.P Enterprise, Singapore May2016-June 2016

Mechanical Engineer Intern

• As a mechanical engineer intern, my responsibility was to create new prototypes for manufacturing jigs for new production parts, create G-code for the CNC machine, and machine the production parts in a fast pace environment.

• Developed various prototype using 3D scanning and printing, CNC manufacturing technologies for an end-to-end solution.

Relevant Projects

COVID-19 Pandemic and its impact on Supply Chain of New Zealand, West Haven, CT Mar 2020-May 2020

• Designed and developed Tableau Dashboard for showing total cases, confirmed cases, probable cases, active cases, deaths, and recovered cases in New Zealand.

• Forecasting strategy to improve their business models and prepare themselves for a future crisis relative to the supply chain.

• Outlook of New Zealand and its supply chain resilience and economic well-being and required effective policy- making for the better future of the country.

An economical alternative for Uni. Athletics Transportation, West Haven, CT Jan 2019-May 2019

• Assembled most relevant data with the help of an Excel pivot table to create Pre-Unit Model, Segmentation Model, and estimated overall cost and suggested the best economical alternative for a 10-year period using Net present value and Annual worth.

Optimal Solution for Transportation, West Haven, CT Sept 2018-Dec 2018

• Identified multiple supply and demand locations with fixed cost and capacity and formulated a mathematical model in a spreadsheet to obtain the optimal solution for minimizing the shipping cost using Solver.

• Suggested new warehouse location with the help of sensitivity analysis and linear programming method in Excel.