Anurag Kumar Pal

Experience

• 

  NBCC (India) Limited

  May 2018 - Jun 2018

  Internship Trainee
• 

  Mu Sigma Inc.

  Jul 2019 - Aug 2022

  -- Collaborated with multiple Strategic Revenue Management teams of a Fortune 100 retailer from Spain, Portugal and Poland in order to streamline their supply and demand planning by creating an automated tool that can produce forecast values accurately at the granular level and empower them to visualize the forecasted values of their products and make corrective actions in their plans as necessary.-- A better Demand and Supply plan will benefit them in creating and achieving effective promotional plans that boost the sales of existing products and increase the exposure of newly launched products.-- Project involves generating Baseline Forecasts at the Account, Item, and Week levels using statistical analysis and Machine Learning techniques which will assist the Demand Planners in creating better demand plans, as well as help the Sales team determine their Return On Investments (ROI) for their promotional activities in the recent and past times.-- Leading a team of 7 members to create data assets for an automated app on React using ETL frameworks with the help of PyCharm (IDE), PySpark, Python, Sphinx, Hive, DBFS, Azure Data Lake, Azure Data Bricks, Azure Data Factory, Azure Blob, Azure Key Vaults, Azure DevOps, CICD and Django (Middleware). Show less -- Teamed up with the Supply Chain Analytics team of a Fortune 100 retailer and created data assets for an automated report that provided better insights into customer and product demand patterns, allowing various departments in the supply chain to identify areas requiring short and long-term corrections from demand and production planning perspective with the help of KPIs like Sales Forecast Accuracy, Forecast Value Added, Unconstrained Demand and BIAS.-- Implemented the usage of a new data source from scratch using various data exploration, data analysis and data wrangling techniques to provide visibility into different aspects of supply chain elements such as forecast, order, billing, shipment, delivery with the help of metrics and KPIs at various levels.-- Led the entire backend development team to develop an automated solution with the help of ETL frameworks on PyCharm (IDE), PySpark, Python, Sphinx, Hive, DBFS, Azure Data Lake, Azure Data Bricks, Azure Data Factory, Azure Blob, Azure Key Vaults, Azure DevOps, CICD and PowerBI Show less -- Developed the backend logic and data assets for an automated PowerBI report which served as a one-stop tool for the leadership and executive teams of one of the world's largest CPG retailer to allow them to monitor their key metrics and focus on their supply chain drivers like sales, marketing, demand management, production, inventory management, and new product introduction. -- The solution yielded positive results and was immediately scaled to the retailer's various other geographies like Spain, Portugal, America, Africa, Europe and Australia.Technologies Used:Was part of the backend development team which worked extensively on PyCharm (IDE), PySpark, Python, Sphinx, Hive, DBFS, Azure Data Lake, Azure Data Bricks, Azure Data Factory, Azure Blob, Azure Key Vaults, Azure DevOps, CICD and PowerBI Show less -- Developed backend logic and data assets for a consolidated and automated tool that would give one of the world's largest CPG retailer a better understanding of their customer and product demand patterns, point of sales data of the end consumers and the daily stock levels in order to assess their forecast plans, delivery of products and risks/exceptions for the upcoming orders.-- Project also included the re-creation of the previously used Excel dashboard into an automated PowerBI report, which earlier used to require extensive use of raw data and laborious manual inputs. The current PowerBI reports eliminates the need of manual inputs by providing all the information in individual views having values of high accuracy and precision.-- Was part of the backend development team which worked extensively on PyCharm (IDE), PySpark, Python, Sphinx, Hive, DBFS, Azure Data Lake, Azure Data Bricks, Azure Data Factory, Azure Blob, Azure Key Vaults, Azure DevOps, CICD and PowerBI.-- The PowerBI report received a lot of appreciation from the clients and the business users because of its user friendliness coupled with highly accurate and precisive data. Show less -- Built a "Profitability Dashboard" for the Strategic Revenue Management team of Germany that allows their executive team to quickly see the daily progress of the business by reviewing their important KPIs on a granular and an uber level.-- The dashboard provided full visibility into standardized supply chain and financial KPIs like NSV, GSV, MAC, GMAC etc. which helped the executive and business team to gather quick insights and take better decisions from demand, revenue and supply planning perspective. Show less

  • Project Lead | Iberia and Poland

    Sept 2021 - Aug 2022

  • Back End Lead | US Geography

    May 2021 - Aug 2021

  • Back End Developer | Global Market

    Feb 2021 - Apr 2021

  • Back End Developer | Russia Geography

    Mar 2020 - Jan 2021

  • Business Analyst | Germany Geography

    Nov 2019 - Feb 2020

  • Trainee Decision Scientist

    Jul 2019 - Oct 2019