Aakansha Verma

- Worked with Demand Planning Manager and team for all European Market and led a team of 5 to build a Power BI report which provided visibility on Forecast Accuracy, BIAS and Forecast Patterns. The solution developed successfully reduced manual effort by 50% and improved CSL by 5 %

- Worked with Business Operations head and team for a CPG in Australian Market to create framework which caters to all sections of a Supply Chain. Led a team of 5 to develop five inter active Power BI Reports with a highly complex Data Model. The solution provides daily updates on Orders and Inventory health, which in-turn helped demand planners to make better decisions for their Short-Term Demand requirements

- Worked with Customer Relation and Inventory Management team of a Fortune 500 in a CPG space. Developed a solution with Power Apps integrated into Power BI Dashboard which gave visibility to customer relation team on any risks on stock presented by inventory/supply team and how it can impact promotions or volume cuts along with ways to mitigate these cuts.

- Worked with Demand Planning Head and his team to develop automated Power BI Dashboard to give users insights on Forecast Accuracy, BIAS and Demand Patterns of the past, to give insights on forecast errors and plan better for the future. The solution built reduced 50% of manual efforts and brought down human errors as well.

- Worked with Demand Planning Head and his team to develop a product segmentation framework based on order pattern and Demand plan exceptions, and successfully built a Power BI report to show past patterns and exceptions of each product to give insights on segments formed. The solution enabled the demand planners to bridge the gap between planned and actual demand by 6%.