Business Analyst
CurrentAnalyzed 10 years of sales data(2014-2024) from an FMCG & Healthcare business generating over 150–200 crore annually comprising more than 200+ products having their supply in all the states along with branch level details for an overall estimate on output across India which is being supplied through total-78 branches. Formed real-time Power BI dashboards to enable the tracking of Regional, Monthly, Seasonal, and Festival sales performance. With this understanding, the management was able to plan strategic initiatives designed to reduce inventory and logistics costs while at the same time improving delivery times. Financial Products: It has a dashboard of financial products generating an annual revenue of 250-300Cr. A project to study the maturity of policies and record credit & debit cycles for RD, FDs, and Savings Plans. From the cash flow standpoint, this dashboard tracked monthly and quarterly credits from policy installments and less debits from matured policies to monitor how money was constantly moving in and out. The company now had a slightly better idea of its monthly and quarterly profitability based on insights derived from the dashboard. Allowing the business to track performance in real-time resulted in better financial decision-making and operational efficiencies.