Analytics manager working directly with stakeholders to help them manage and utilize their data for business growth. • Setting up dashboards for CEO and leadership for visibility on KPIs and growth • Managing the setup of first ever data warehouse of Krave Mart to enable data usability. • Setting up dashboards for commercial team for effective sourcing of products on Dark Stores including stock ageing, stock allocation and stock in hand visibility. • Built a price comparison dashboard for commercial function to assist them in pricing strategies. • Setting up dashboards for Warehouse Operations to enable stakeholders to identify inefficiencies in warehouse operations i.e transfer orders, putaways, order picking and packing performance, inventory losses. • Setting up dashboards for Finance for cash reconciliation of sales. • Setting up dashboards for Marketing for visibility on user acquisition and retention including analysis on discounts and ROI.
• Coordinated with engineering team to revamp the existing ETL for data points, requiring modifications, based on new business processes. • Collaborated with marketing team to provide visibility on the ROI of marketing campaigns for Acquisition team. • Testing and monitoring the underlying data, assuring quality and optimizing the tables in data warehouse. Designed and executed SQL queries for extraction of data upon ad hoc request of data.
• Support existing offshore clients with queries related to software and communicating bugs & issues to the Engineering Team. • Integrating machine learning algorithms to enhance software features and create models for the clients according to their business requirements. Tools: MSSQL, Astera Data Integration Software, MS Excel
DATA ANALYST: Analyze consumer data across different units to report the changes in consumer dynamics and identify consumers with theft billing over 0.5 million. Launched the initiative to ensure correct mapping of 102,000 consumers resulting in an effective billing and consumer feedback system.