Nisha Chandrani

• Leading a team of 10+ analysts and senior analysts, overseeing the development and delivery of advanced Power BI dashboards for promotional analysis across multiple brands.
• Develop and deploy responsive Power BI dashboard solutions that directly address ad hoc analytical needs, enhancing client capacity to strategically navigate market trends and opportunities. Worked with 30+ Brands like P&G, Mars, Dabur, Reckitt, Unilever etc.
• Working on leveraging AI to build intelligent analytical tools that enhance data processing, improve decision-making, and streamline business operations.

• Led a team of 5-7 members (including Developers, Quality Analysts, Data Scientists, Business Analysts and Data Analysts), responsible for delivering projects for global clients

Promotion Optimizer Tool, FEMSA (Coca-Cola Bottling Group)

• Successful end-to-end execution; Improved ROI by 8% (percentage points) through effective promo strategies
• This Product was used by the client in 6 different countries because of its effectiveness
• Worked with Data Engineering Team to create ETL pipelines on AZURE, collaborated with the Research team to implement models, worked with Business analysts for deep analysis of models and data to form Strategies, provided Wireframes to the Development team for Dashboard/UI creation, worked with QA team to ensure the quality of end product
• Created the sprint plan, and communicated the priorities well within the team so as to have a smooth execution of the project and meet the client/project timelines
• Effective interactions with the client on business objectives, data understanding, and ad-hoc queries.

• Provided CPG Clients with analytical consulting on diverse projects such as Price Bucket Analysis, Competitor Study, Long Range Projections, Market Share, Cooler Analytics and Price Change Impact Analysis using Price Elasticities and Switching.

Cooler Analytics, Mondelez India Pvt Ltd

• Delivered insights presentation and cooler deployment strategy plan to the client that helped the client in identifying horizontal and vertical opportunities.

Market Share Forecast, The Coca-Cola Company, Central Asia

• Value market share projection using time series forecasting modelling techniques such as ARIMA, VARMAX while considering Macroeconomic factors, business factors, and competition etc. Highlighted the opportunities at Category, Brand and Pack levels to accelerate share gain and arrest share loss.

• Worked directly with the CEO/VP of Sales on product planning, strategic interventions, delivery, post-launch tracking, and P&L tracking

Merchant Product

• Achieved 4x growth in merchant acquisition by creating a lead optimization framework
• Restructured the process of assignment of potential clients to tele-callers and simplified the onboarding process for Merchants in the merchant app

• Understood the requirement specifications as per business needs and identified the key metrics to be measured to evaluate the performance of the product
• Management of cross-functional teams and liaising relations with external associates, 3rd party vendors like Radisys, Nokia, Genband