Engineer Data

MURGESH GURAPPA AWATI

Las Vegas, NV P: +1-864-***-**** ******@*******.*** www.linkedin.com/in/murgesh-awati/ An Industrial Engineer with experience in Data Analytics, Supply Chain, Consulting, Lean, and Service Industry EDUCATION

Clemson University – Clemson, US May 2020

Master of Science in Industrial Engineering; Cumulative GPA: 3.74/4.0 B.V.B. College of Engineering and Technology – Hubli, India Jun 2016 Bachelor of Engineering in Mechanical Engineering; Cumulative GPA: 3.8/4.0 EXPERIENCE

SimWell

Simulation and Data Science Consultant Jan 2021 – Mar 2021

• Achieved an operational efficiency of 12% by enhancing existing ETL processes for large supply chain datasets using Power Query and ensuring data integrity

• Designed, developed, and applied engineering, mathematical and discrete event simulation models to drive solutions to complex manufacturing and material handling problems

• Developed advanced User Interface, generating log files, and developed Power BI dashboard to communicate metrics and report waste losses in production

Volvo Group

Supply Chain Analyst Co-op Aug 2019 – Dec 2019

• Built a KPI dashboard for the Service Centre and Claims team by mining the data from the Oracle, SQL Server, WMS and analyzing it to generate informative KPIs

• Transformed the KPIs to compelling data visuals in Power BI by writing complex queries in DAX; saved 20% of daily work by automating the tool by integrating Power BI, SharePoint, MS Excel (VBA, Macros), MS Access, and Flow

• Collaborated in developing the capacity planning tool using statistical techniques (Acc. of 93%) using R, Power BI; reduced running case backlogs by 30% by optimizing resource allocation using the capacity planning tool

• Coordinated with the cross-functional team in improving the lead time (81%) for high priority parts by streamlining the unloading system to a one-piece flow using lean principles; ensured cost-savings of $280,000 annually Industrial Assessment Center

Research Engineering Intern, Clemson University Jul 2020 – Jan 2021 Energy Analyst Intern May 2019 – May 2020

• Facilitated in developing cost-effective solutions for manufacturing plants (through audits) on process improvement, demand management, cost-energy savings using analytical and problem-solving skills

• Reduced man-hours by 60% by automating the business documentation report using Excel (VLOOKUP, VBA)

• Developed optimization models on the data, thereby accounting for an average cost savings of $25,000 per client Infosys Limited

Systems Engineer Nov 2016 – May 2018

• Supported as a Network Logistic Engineer with training in Python, SQL, Tableau, and Java by providing technical assistance for network issues and handling logistics of network devices

• Improved the team performance by 34% by creating ad-hoc reports (of network issues) in all regions to document business reports and develop data models in Excel

ACADEMIC PROJECTS

Supply Chain Network Design

• Formulated a Mathematical Model using Mixed Integer Programming to ensure facility locations (254 suppliers, 1330 hubs, and 168 factories) are optimized to minimize the variable and fixed costs

• Reduced total costs by 32% using Excel VBA for data cleaning, and Python GUROBI for programming the model Statistical Analysis using R

• Processed and cleaned the TV shows dataset, applied EDA to discover insights behind the data, and evaluated parameters using Regression and Hypothesis testing with R-Shiny dashboard and advanced UI ADDITIONAL

Software: SQL, MS Excel, Oracle, Python, R, Java, C, Julia, Power BI, R-Shiny, Tableau, Minitab, MS Office Suite, AnyLogic Technical: Capacity Planning, Demand Forecasting, Data Visualization, Statistical Data Analysis, Predictive Modelling, Linear Programming, Integer Programming, Optimization, Customer Satisfaction Certifications & Training: Lean Six Sigma Green Belt (Lean Sigma Corporation), SQL for Data Science

Contact this candidate