Industrial Engineer

SOHAN BHAT

adgner@r.postjobfree.com 716-***-**** *** Englewood Avenue, Buffalo, NY-14214 linkedin.com/in/sohanbhat EDUCATION

Master of Science, Industrial Engineering Aug 2019 - Present University at Buffalo, NY, US GPA: 3.554/4.0

Bachelor of Engineering, Mechanical Engineering Aug 2013 - Jun 2017 PES University, Bangalore, India GPA: 8.68/10.0

SKILLS

Tools: Tableau, Power BI, Minitab, MS-Excel, Powerpoint, Python, SQL, R, Access, SAP-ERP, AutoCAD, Creo Competencies: Forecasting, Inventory management, Demand planning, Production planning, Lot sizing, MRP, EOQ, Operations scheduling, Cost analysis, Facility design, Supply chain planning, S&OP, Procurement & strategic sourcing, Negotiation & contract management, Lean, Six sigma, PDCA, 5S, Kaizen, VSM, 8D, CAPA, SPC, Quality control EXPERIENCE

Student Lean Consultant - Pro bono, 3-Pillars catering, Buffalo, US Jan 2020 - May 2020

• Reduced the losses occurring to the firm due to late deliveries by 8.5%

• Performed Root Cause Analysis for delays through 5-Why analysis, and slashed time taken to deliver the orders by 15%

• Used PDCA cycle, performed Current state analysis using tools like VSM and collated the details of the entire project

• Served as a team liaison and held brainstorming sessions with the stakeholders Research Executive - Analyst, Feedback Business Consulting, Mumbai, India Nov 2017 - May 2018

• Estimated market sizes, forecasted and contributed to SWOT, PESTLE analysis

• Analyzed service data using Excel, analyzed trends, developed KPIs to increase service frequency and revenue

• Used and created dashboards using Tableau/Power BI for data visualization of business impact with our solution design

• Prepared short/long term demand-supply forecasts and tracked price movements in the Construction sector

• Migrated data, helped reduce labor and analytical manhours by 30% Business Analyst Trainee, Skillpanther, Bangalore, India Jun 2017 - Jul 2017

• Used Excel in order to monitor and track day to day delivery processes for an online retail business

• Created a tracking dashboard on Excel to quantify delivery trip performance into normal and faulty delivery trips

• Used SQL to automate recurring dashboard reports, reducing the time of tracker-report generation by 40%

• Automated cleaning and analysis of sales data in macro-enabled Excel sheets using VBA scripting Mechanical Engineering Intern, Volvo CE, Bangalore, India Jun 2016 - Jul 2016

• Analyzed process parameters such WIP, cycle times, bottlenecks & utilization for Kaizen improvements

• Enhanced productivity by streamlining production operations and managed a 12% reduction in overall costs

• Implemented a just-in-time inventory and stocking level program that decreased the overall inventory by 20%

• Monitored in-stocks, on-hands & on-order levels on the ERP system PROJECTS

To determine the exergy destroyed in a waste heat recovery process from exhaust of gas turbines

• Performed a parametric analysis of combined cycle gas turbine using MATLAB

• Conducted an analysis for several organic fluids and their efficiencies were determined based on the exergy destroyed

• Determined exergy destruction to be the highest in combustion chamber by a margin of 16% Developed SPC chart and analyzed process capability for variable data of pizza delivery process

• Determined critical characteristics of delivery time, set specification limits and developed X-MR process control chart

• Checked for acceptability of the process within limits by determining process capability values for the bell-curve data Framed experimental design for understanding significant factors affecting weld strength & adhesion in a process using Minitab

• Created 2-level fractional factorial design, determined aliasing structure & used ANOVA to determine significant factors

• Applied surface optimization concepts to obtain good estimates of parameter settings for maximum strength & adhesion Implementation of TSP between Target stores and its distribution centre in Western New York region

• Applied the Travelling Salesman Problem technique wherein ’Nearest Neighbor’ method and ’Clark & Wright Savings’ heuristic were used between the distribution center and the retail outlets

• Determined the location of a new facility by using single-facility location method & compared it with the existing one

• Achieved 200 miles in logistics-savings by implementing the tour obtained from nearest neighbor method Determination of an optimal distribution warehouse for a sporting goods supplier

• Applied facilities-location method, determined a CAR warehouse for 13 existing retails stores using Weiszfeld algorithm and identified optimal length, depth of aisles

• Slashed one-time re-stocking cost by 22% by locating a new facility and also developed a TSP optimal route for delivery of a single SKU from located warehouse to 9 retail outlets

Contact this candidate