Sohan Bhat
Student Inventory & Demand Analyst- Pro-bono · Putnam's
Oceanside, CAWork Experience
Student Inventory & Demand Analyst- Pro-bono
Putnam's2020 – 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 Catering2020 – 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 consulting2017 – 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 & Global2016 – 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 University2013 – 2017
BS
MS
State University of New York2019 – 2020
MS