Financial Planning & Analysis (FP&A)/ CCAR PPNR model developer.

Financial Planning & Analysis (FP&A)/ CCAR PPNR model developer.

Extending Microsoft Power BI based Business Intelligence solutions across FMCG, Pharma, Agro-Chemical & more.

> Power BI developer & Analyst to the Supply Chain (SC), Coca-Cola India Private Limited (CCIPL). > Single Point of Contact to the SC, reporting directly to the SC Sr. Manager, G.M. & Director. > Entrusted with both written & in-person direct communication with key stakeholders in the BU.> Responsible for driving projects (End to End): Gathering requirements, developing dashboards, delivering presentations, performing & communicating analysis, trainings & support. > Major Projects: ✓ Out of Stocks: • Automation (Framework set up) to optimisation (Out of Stocks position at 15 bottling units).• Powered OOS dashboards reflecting Unit, Distributor & Retail level OOS, with SKU level granularity. • Creating further analysis & writing weekly mailers to bottling units suggesting corrective intervention. ✓Stock Sourcing: • Powered the strategic Stock Sourcing dashboard, enabling user (@ respective plant/ @BU) to view SKU wise stocks availablity at their own plant & that at plants in a vicinity of 500kms of their own, over a map. •Dashboard access extended to the Leadership team @ CCIPL.✓Distributor Stock Availability Index (DSAI):• Working directly with the General Manager, SC, to bring in Distributor level stock visibility to the BU. • Leading the project End to End: From setting up SharePoint data repository for bottlers to upload data, to generating insights over dashboards, to tracking & action. • Made use of Power BI AI capabilities in the form of Decomposition Tree visualizations, enabling bottlers a deep dive into root cause analysis.✓Overall Automation: •Automating data sharing by Bottling units over Box, SharePoint, etc.•Creating data flows where required.•Data cleaning.•Generating complex analysis & key insights over Power BI dashboards.•Using PowerBI AI capabilities to the fullest.•Data tracking & exceptions reporting (faulty data, delayed receipt, etc.) •Training end users.

GRID (Government Reforms and Infrastructure Development), Advisory

Assessing Out-of-Pocket Expenditure on Health & its poverty inducing impact, under Dr.Krishna Ram, project funded by ICSSR.