Jun 2022 – Jun 2023 · 1 yr · Bengaluru, Karnataka, India · Hybrid

• Tolerance Price Analysis
• The Poland Market team wanted to understand in case a product is elastic, what is the tolerance price range for those products
• Price vs Volume relationship is first defined and for the products with considerable price changes historically, tolerance
• range is created
• RRP Alignment with ASP
• South Africa Market wanted to know if the retailers are abiding by the Retail Price Recommended by Pricing Managers
• in the Market and find out the difference between RRP and ASP
• Created a visualization which tells the difference between RRP and ASP by week, Site, Category, Sub Category, Product and Geography
• This helped the Team to find out all the sites where the difference between ASP and RRP was huge and take appropriate measures to optimize the profits
• Retail Store Clustering for Pricing Strategy Implementation
• Canada Market wanted to cluster its Non Fuel Retail Site Stores in order to understand what pricing strategy should
• be implemented across different stores
• Created store clusters of sites with similar behaviour using K-Means Clustering for three provinces Alberta, British
• Columbia and Ontario
• This helped the Team to decide which Pricing Strategy should be implemented to maximize the margins and minimise
• the loss in volumes
• «Technology/ML Algorithms used»: • Python • K-Means Clustering • SQL • Power BI

Aug 2021 – May 2022 · 9 mos · Bangalore Urban, Karnataka, India

• Bottom's Up Forecasting
• Led this project for Predicting Article level Demand to reconcile with the existing Top Down and provide more data backing to Buying team to firmly align on the targets with Finance team.

Mar 2020 – Aug 2021 · 1 yr 5 mos

• BFSI
• Created several KPI Dashboards in Tableau to help insurance company track if the changes done in claim process are actually impacting the process or not and if yes then to see by how much is it impacting in terms of time and money
• CPG
• Worked on business process planning, Marketing Mix
• Modeling and determining the reasons of failure for
• deliveries for a leading European Sports Manufacturer
• Integrated Business Planning
• Automated the Target Planning for the upcoming year
• in Alteryx and determined the Net Sales to be achieved
• daily to complete the Target.
• Developed a performance dashboard in MSTR to keep a
• track of fulfilment
• Marketing Mix Modeling
• Determined the effect of different Marketing Channels
• on Sales using Linear Regression in R.
• Optimized the Marketing Mix to drive more Sales using
• Linear Optimization Algorithm
• Failed Delivery Analysis
• Ascertained the reasons of failure for non fulfilled
• deliveries and standardized the failure reasons across
• carriers.
• Developed an analysis dashboard to track the
• performance of carriers in Europe and generating
• insights and help business better understand the
• reasons for failure of a delivery

Oct 2019 – Feb 2020 · 4 mos

• FMCG
• Created Price Elasticity Model for a European chocolate
• manufacturer
• Determined Price Elasticity for Top Performing SKUs in
• France Market using log- log and linear regression (in R) .
• Finally selected linear regression owing to its better
• performance.
• Created Sales Simulator (in Power BI) to check how
• change in Base Price would affect the Sales Volume

Aug 2018 – Oct 2019 · 1 yr 2 mos

• BFSI
• Worked on an archiving utility and report migration for
• a leading Swiss bank
• Project involved extracting insightful information from
• reporting files and align the output in a format useful for
• business users

Jun 2017 – Jul 2017 · 1 mo · KAPURTHALA, PUNJAB, INDIA