Project work
1. Buyers have historically been required to pull daily reports to evaluate material coverage to support daily production needs. This is a gross simplification of the different reports needed, and the various SAP reports that contained different pieces of key information required to get a holistic view of production coverage, but the team spent a lot of time simply pulling together data to do their jobs effectively, and there was an opportunity for error. In addition, different reports were needed to evaluate phase-out material to prevent unneeded obsolescence at the factory, which made it very challenging to balance production needs while minimizing phase-out obsolescence.
2. My team worked to automate and streamline this critical data through Hana tables that are now published and refreshed in Power BI. Taking the “data pulling” task off of buyer’s and planners’ plates allows them to spend more time ensuring we have production coverage and prevents errors that were possible when individuals were required to pull their data.
3. The supply base dashboard provides vastly improved visibility to past due PO’s, stockout data, forecasted obsolescence, and supplier performance that previously took hours to produce. The total hours saved per week across the SM team in pulling data is tremendous, but more importantly preventing errors and giving the tactical team improved visibility to the key “big rock” metrics that allow them to keep production running.
Hours saved by buyers per week = 98.5; multiply by 50 work weeks = 4925 hours
Assuming $100 / hour = $492.5K savings
- This is visible with elimination of resource ask for +2 contingents and enabling buyers to work on other projects
Date of birth 18-02-1979 Place of birth Mumbai Gender Male Nationality Indian Marital status, , LinkedIn linkedin.com/in/rushi-kadam- b5a39a9 Interests Watching Documentaries on National Geographic Travel Volunteer for Teaching & counselling students to explore Tech career path
Dynamic Sequencing Project (MTS & MTO Factories)
Problem Statement
Solution
MAI Dynamic Sequencing Tool Enables Production Planner with Real Time Material Availability for individual BMC/Material Variant for all the critical components , on top of it user can access bill of materials for BMC/Material Variant.
Complexities associated with Dynamic sequencing Tool