PARTH PRAJAPATI

adm0cj@r.postjobfree.com 857-***-**** linkedin.com/in/parth-prajapati

EDUCATION

Master of Science in Industrial Engineering, Northeastern University, Boston, MA April 2021 Relevant Courses: Supply Chain Engineering, Data Mining, Data Visualisation for Analytics, Database Management Database Design, Project Management, Lean Concepts and Applications, Operation Research Micro-Masters in Supply Chain Management, MITx, EDX May 2021 Course: Supply Chain Analytics, Supply Chain Fundamentals, Supply Chain Design, Supply Chain Technology Bachelor of Engineering in Mechanical Engineering, L.J.I.E.T, India May 2018 TECHNICAL SKILLS

Analytical/BI Tools: MS Excel(Lookups, Pivot Table, Macros, Solver) Tableau Power BI R Python Flourish Software: SAP ERP Glovia G2 ERP Auto Cad 2D Solid Works MS Office Database systems: MS SQL MySQL Oracle Database EXIPERENCE

Axcelis Technologies(Semiconductors), Beverly, Massachusetts Supply Chain Analyst Co-op January 2020 – July 2020

• Generated a series of sales report daily using advanced MS Excel and SAP for the procurement team to reduce operational time by 10%

• Established KPI by collaborating with other cross functional teams to optimize the missing delivery routes by 84%

• Delivered Dashboards using Tableau and executed SQL queries to assist Senior Managers to monitor supplier issue resolving time, supplier lead time etc

• Assisted procurement head to automate amortization financial report to analyze quarterly data

• Performed Activity-based costing (ABC) analysis to filter out inefficient and slower-moving products reducing storage space and inventory handling cost by 15%

• Eliminated irregularities between BOM and actual product packaging, hence reducing obsolete inventory by 14%

• Implement 5S, Kanban, Process mapping in the Robotics Arm Cell and increased efficiency of production line

• Managed and resolved more 200 supplier issues by working cross functionally with multiple teams Vardan Engineering, Ahmedabad, India

Supply Chain Analyst December 2017 – Jan 2019

• Created Visualisation Dashboard of Sales KPI’s for marketing and Business Development group

• Optimized Cycle & Safety stock for 50+ SKU’s using Inventory performance metrics reducing the inventory by 8%

• Led a team 30 technicians to implement 5S in tool carts and resolving bottle necks in the production line

• Assisted in reducing distressed inventory for a cartridge filter category from ~13% in January to ~9% by end of June by creating Inventory health report project to drive successful results by using the pareto analysis ACADEMIC PROJECTS & PROFESSIONAL DEVELOPMENT

Visualization for Startup Investment Dataset (Tableau, R) Spring 2021

• Performed Data cleaning on 85k rows and 30 columns by removing null values & unnecessary columns. Created different metrics, visualizations charts, Dashboard and Storyline to represent COVID-19 Nursing Home Dataset Analysis (Tableau, MS Excel) Spring 2021

• Performed data cleaning on 600k rows and 120 columns to get the consistency of the dataset

• Created different metrics such as No of weeks with staff shortage based on facility, county, different supply shortages and then developed visual charts, What-If Analysis and summarization into the report Data mining on IMDB Rating (R) Fall 2020

• Extracting useful information behind IMDB 5000 movie data with data visualization strategy and implemented Classification Tree, KNN, Random Forest algorithms and improved model efficiency by 72% Inventory Management System (MS SQL,TABLEAU) Fall 2019

• Developed Strong Database to optimize inventory and implemented triggers, stored procedures, transactions and generated the reports using Tableau and imported data from MS SQL and presented it CERTIFICATES

TABLEAU ANALYST, APICS CPIM(In-Progress), SQL- MySQL for Data Analytics, Lean Six Sigma Certification

Contact this candidate