Project 1: Inventory Optimization for a US Network Infrastructure Company
Situation: A US-based network infrastructure company sought to optimize its inventory to enhance service levels and improve working capital utilization.
Task: Implement an inventory optimization project, which included defining inventory parameters and processes, developing user stories and functional specifications, coordinating with technical teams, leading training and UAT sessions, and ensuring timely bug resolution for a successful go-live within a tight timeline.
Action:
o Collaborated with the customer to establish key inventory parameters and processes.
o Authored user stories and comprehensive functional specifications.
o Coordinated effectively with technical teams throughout the implementation phase.
o Led training and User Acceptance Testing (UAT) sessions with customer teams.
o Managed and ensured in-time resolution of bugs and issues.
Result:
o Achieved a projected ~10% reduction in working capital.
o Realized a projected 10-15% increase in service levels across various product groups.
o Successfully completed the project within the tight 6-month deadline.
Project 2: Inventory Process Improvement for a US Cars & Parts Supplier
Situation: A US-based cars and parts supplier faced challenges with their existing inventory processes, specifically experiencing ETL job failures and prolonged run times between systems, which negatively impacted service levels.
Task: Improve the current inventory process by optimizing problematic ETL jobs and proposing new inventory policies and parameters to elevate service levels.
Action:
o Optimized ETL jobs between systems, which were the root cause of failures and long execution times.
o Suggested and facilitated the implementation of new inventory policies and parameters.
Result:
o Increased the adoption rate of the inventory optimization tool.
o Significantly boosted service levels from 74% to 92%.
o Achieved a reduction of job failures to 0.
o Reduced ETL job run times by an impressive 85%.
o Received a SPOT award for significant contribution to the project.
Project: Sales and Operations Planning (S&OP) Implementation for a South African Mining Company
Situation: A South African mining company required the digitalization of its Sales and Operations Planning (S&OP) process to enhance demand and supply planning capabilities and streamlining their S&OP process.
Task: Implement the SAP IBP S&OP module as a consultant, overseeing all phases from design to delivery, and proactively ensuring a successful go-live.
Action:
o Led requirement-gathering workshops during the design phase to thoroughly understand client needs.
o Crafted comprehensive design and blueprint documents tailored to the client's specific requirements.
o Collaborated closely with the integration consultant, providing essential inputs to orchestrate seamless data flows between SAP IBP and SAP S/4HANA.
o Developed custom scenarios specifically for the mining industry to ensure better product adoption.
o Facilitated change management activities, including developing training materials and conducting sessions, to empower end-users and stakeholders and ensure smooth adoption of the new solution.
Result:
o Achieved successful digitalization of the S&OP process, leading to improved demand and supply planning.
o Resulted in streamlined demand planning and more accurate forecasts.
o Enabled rough-cut capacity planning for supply planning, enhancing strategic operational capabilities.
Project: Demand, Supply, and Transportation Planning Implementation for an Egypt-Based Consumer Durables Company
Situation: An Egypt-based consumer durables company needed to implement comprehensive demand, supply, and transportation planning capabilities to improve their operational efficiency.
Task: As a consultant, implement demand planning and develop a custom transportation planning solution using SAP IBP, working proactively through all phases: design, build, test, and delivery.
Action:
o Assisted in requirement-gathering workshops during the design phase to thoroughly understand the client's needs.
o Developed and built custom scenarios specifically for transportation planning, as these were not out-of-the-box features in SAP IBP and were crucial for the customer.
o Utilized advanced forecast models, including Croston, ARIMA, and SARIMAX, for demand planning.
Result:
o Achieved a significant decrease in forecast error of approximately 20-25%.
o Successfully digitalized and automated the customer's transportation planning process.
o Received appreciation awards for contributions to the project.
Project: SAP Preferred Success for SAP IBP
Situation: The "Preferred Success for SAP IBP" program required the ideation, creation, and execution of new microservices to enhance the offering for customers.
Task: Contribute to the development and delivery of these microservices, from initial concept to successful launch, ensuring high customer satisfaction and adoption.
Action:
o Contributed to the ideation of microservices, leveraging insights from similar offerings and personal experience.
o Developed essential collateral required for the delivery and support of various microservices.
o Delivered the microservices as a pilot project, gathering feedback to refine both the services and accompanying materials.
o Launched approximately 15 microservices post-umbrella service offering, in addition to the initial pilot.
Result:
o Achieved the best NPS (Net Promoter Score) for Preferred Success for SAP IBP under the overall Preferred Success program.
o Received appreciation awards and consistently positive feedback from customers for contributions.
Project: Pre-sales and Project Management
Situation: Small and medium-sized companies in the CPG and life sciences industries needed readily adoptable, end-to-end supply chain solutions. There was also a need to streamline and industrialize the project delivery process for SAP IBP.
Task: To conceptualize, develop, and deliver comprehensive supply chain templates for quick adoption, support pre-sales efforts through demos and RFP responses, and establish an efficient "Factory model" for SAP IBP project delivery, including the creation of necessary tools and collateral.
Action:
o Developed end-to-end supply chain templates, guiding them from ideation through to delivery, specifically for medium and small companies in the CPG and life sciences sectors.
o Executed multiple Proof of Concepts (POCs) for customers spanning different industries and geographical locations.
o Assisted in crucial pre-sales activities, including conducting product demonstrations and preparing responses to Requests for Proposals (RFPs).
o Contributed to the ideation and execution of a "Factory model" for SAP IBP project delivery, concurrently developing the essential tools and collateral to support this model.
Result:
o Achieved the sale and successful adoption of ready-made template builds.
o Successfully converted numerous POCs into full-fledged projects.
o Ensured the successful adoption and execution of the "Factory model" for project delivery, which included successful project completion under this new model.
Project 1: Warehouse Space Requirement Computation
Situation: There was a critical need to accurately determine the warehouse space required at various locations across India. This computation had to be based on precise SKU-wise demand estimates.
Task: To calculate the exact warehouse space necessary, integrate diverse operational considerations into the calculations, and estimate the associated warehousing costs for different potential distribution models.
Action:
o Computed the warehouse space required at locations across India, based on detailed SKU-wise demand estimates.
o Factored in critical considerations such as aisle space, service area, and activity-based space requirements.
o Conducted primary and secondary research to accurately identify storage efficiency and honeycombing percentages.
o Calculated space requirements for various proposed distribution models.
o Estimated the warehousing cost associated with each different distribution model.
Result: The project successfully provided a comprehensive analysis of warehouse space and cost estimations, forming the analytical foundation for future logistics and distribution strategy development.
Project 2: Hub-Based Model and Dispatch Strategy Development
Situation: The existing distribution process needed significant improvement to enhance service levels for fringe SKUs and reduce primary distribution costs. This was identified through an initial As-Is analysis.
Task: To perform a detailed As-Is analysis, then design and propose an innovative hub-based model. This included identifying key warehouses for conversion into hubs, developing an optimized dispatch strategy, and ultimately proposing a single, optimal integrated model.
Action:
o Performed an in-depth As-Is analysis of the current distribution processes.
o Carried out ABC-XYZ classification of SKUs based on Q1 FY-19 sales data to accurately identify "fringe SKUs."
o Applied the Weighted Factor Rating method to strategically identify the most suitable warehouses for conversion into hubs.
o Developed a new, efficient dispatch strategy designed to both reduce primary distribution costs and improve service levels.
o Identified specific warehouses where direct dispatch was feasible, further reducing primary distribution cost and lead time.
o Proposed a holistic optimal model that seamlessly integrated the new hub-based system with the refined dispatch strategy.
Result:
o Devised a hub-based model with a projected saving of INR 30 lakhs per year in distribution costs and the liberation of 6500 square feet of warehouse space.
o Developed an optimal comprehensive model with a projected saving of INR 1.2 Crore per year and an additional 6500 square feet of warehouse space savings.
o Proposed an optimal model projected to reduce lead time by 1 day for 40% of the warehouses, which collectively cater to 70% of the business volume.