SB

Sohan Bhat

Student Inventory & Demand Analyst- Pro-bono · Putnam's

Oceanside, CA

Work Experience

Student Inventory & Demand Analyst- Pro-bono

Putnam's

2020 – 2020

Streamlined inventory management & boosted delivery and scheduling efficiency by 35% by moving to MS Excel database system Monitored inventory levels, made suggestions on safety-stocks, ensured 97% inventory level accuracy via tracking & cycle counts of finished goods Reduced inventory costs by 45% by performing capacity planning using linear programming in Excel Achieved target in-stock levels and planned inventory turns to improve inventory productivity Reviewed and forecasted inventory levels and decreased the overall inventory by 12%

Student Lean Consultant - Pro bono

3-Pillars Catering

2020 – 2020

Implemented cost reduction & reduced the losses occurring due to late deliveries by 8.5% Performed Root Cause Analysis (RCAs) for delays through 5-Why analysis & slashed time taken to deliver orders by 15% Used PDCA cycle, performed Current state analysis using tools like VSM & collated the details of the project on a A3 sheet Created PFMEAs, implemented Kaizen, Kanban to improve material process flow, production lead time Coordinated with project team to identify & drive continuous improvement opportunities and eliminate waste

Research Analyst - Demand/Supply planning

Feedback Business consulting

2017 – 2018

Generated short/long term demand-supply forecast plans for construction giants using ARIMA models Managed forecasting to generate 12 month rolling demand forecast & purchasing plans and maintained error reports Analyzed service data using Excel & SQL queries and developed KPIs to provide actionable insights Generated dashboards using Tableau for data visualization, analyzed trends/patterns & helped clients make data-driven decisions

procurement Intern

Logistics & Global

2016 – 2016

Maintained relationships with suppliers/vendors, created daily reports & issued purchase orders (PO's) to ensure on-time delivery Benchmarked & negotiated supplier agreements, handled and executed purchase orders from start to finish Measured supplier performances (on-time delivery, quality, lead time, reverse logistics, planning parameters) Evaluated lead times vs cost before purchasing materials, and assisted material resource planning (MRP) team Created detailed Bill of materials (BOM) structure in SAP for new request for quotes (RFQ) & created ad-hoc reports Monitored in-stocks, on-hands & on-order levels on the Enterprise Resource Planning (ERP) system Developed thorough and accurate requests for proposals (RFPs) to suppliers & also assisted warehouse team

Education

BS

PES University

2013 – 2017

BS

MS

State University of New York

2019 – 2020

MS