Prashant Ranjan

Understanding problem statement, define objectives and provide plausible solutions, supported by a team of twenty senior business analysts

• Shipment Optimization to increase Sell-Thru for one of the largest Coffee Retailer: Created an optimization model to obtain optimal shipment lot across stores in order to reduce wastage and loss of sales opportunity problem faced by the client. It ensured an incremental revenue of $20M to the business. The project eventually helped the organization with four new resource engagement
• Store Segmentation: Identify store segments that can be targeted differently at the pre-planning stage of campaign seasons in order to maximize activations by using K- Means clustering
• Inventory Planning Product- Time Series: A project aimed to help Retailer facing with issue of inventory management by creating an automated product which will provide future demand for each product enabling business in doing better inventory management
• Process Automation: Automation of different data touch point using Python to processes including source data extraction, data manipulation, data validation and bring process and resource efficiency
• Product Analysis: Enabling an ideation journey on the specific type of coffee consumers and understand if those coffee consumers are lapsing, where they are going, and their preferences & if they are moving into more premium categories or leaving. The analysis helped the stakeholder to validate their hypothesis and enable them in taking a better decision
• Dashboard Development - Designed, developed and deployed multiple dashboards using Tableau Desktop and Power BI to analyses day-to-day performance of Products, Promotions, Programs and Merchant of a multi-million dollar retailer. The dashboard provides a better understanding of the customers which enables the stakeholders to make better strategic decisions
• Migrate all the processes from the legacy Oracle system to Microsoft Azure database (EDAP) : Swift and error free migration of data to EDAP, complete reporting automation using Power BI Incremental productivity and capacity for advanced analytics projects
• Post campaign analysis: Evaluation and comparison of results of marketing campaigns, performance assessment of promoted products, and their effect on customer engagement

• Relationship management with External vendors, Channel Partners & other stake holders for further deepening the business relationship
• Solely responsible for Total portfolio management, monitoring, quality control and ensuring compliance of all internal and external guidelines