MRIGANKA CHOWDHURY

Pricing Analytics:

• Analyzing price elasticity, assessing the impact of competitor pricing, calculating price indices, and examining the effects of price changes on categories, subcategories, brands, manufacturers, and products.

Category Analytics:

• Conducting range reviews, planning assortments, identifying trends and patterns in category performance, and launching new products.

Marketing and Promotion Analytics:

• Designing campaigns and testing promotion effectiveness, cross-selling, up-selling, and performing Market Basket Analysis.

Store Analytics:

• Using data and visualization to provide actionable insights for on-ground store teams, territory, and district managers.

Leadership:

• Managed a team of pricing analysts, offering guidance and support to ensure achievement of Plan vs Actual financial targets and improvement of C1 and C2 margins.

Training and Development:

• Organized regular training sessions and workshops to improve team members' knowledge of pricing analytics, storytelling, data processing tools, and the use of project management tools like Azure DevOps.

Led a category revitalization project that boosted sales by 8% and increased margins by 3% in just 12 months. Collaborated with retailers, suppliers, and pricing managers to generate an additional revenue of $1.9 million.

• Conduct comprehensive category analysis to identify trends, consumer behavior, and growth opportunities across various retail and product categories to provide actionable insights and develop strategies to improve category profitability.
• Analyze sales performance, inventory levels, and market dynamics to optimize product assortment, pricing strategies, and promotional efforts.
• Develop and maintain sales forecasts, ensuring alignment between demand and supply, and minimizing stock-outs or overstock situations.
• Leverage data analytics tools (Azure data bricks,Python, Excel, SQL, Power BI,Tableau) to create detailed reports, dashboards, and data visualizations for senior management.
• Monitor and assess competitors' activities, price changes, and market share using data from Nielsen and IRI, providing recommendations for maintaining a competitive edge.
• Inspired team members to generate creative ideas and solutions for pricing challenges, nurturing an environment of continuous improvement.

Led a project to streamline category performance reporting, reducing reporting time by 6 hours per week. Additional generated incremental supplier fees of $1 million

• Analyze Sales, Cost and Price data and historical trends to create accurate demand forecasts and replenishment plans.
• Monitor inventory levels across multiple warehouses to ensure optimal stock levels and minimize stockouts or excess inventory.
• Maintain inventory accuracy through regular audits, cycle counts, and reconciliations with the ERP system, resulting in improved overall accuracy.
• Apply sentiment analysis and topic modeling tools to derive sentiment scores for each product and customer review, highlighting SKUs with quality concerns and preventing retailer/distributor loss across regions.
• Utilize Python,SQL and Power BI to build reports and dashboards tracking key inventory metrics such as turnover, stock levels, and lead times.
• Proactively automated dashboards by incorporating industry best practices, resulting in faster and more scalable dashboard solutions

• Analyze supply chain data to pinpoint areas for improvement in inventory management, demand forecasting, and logistics.
• Develop reports and dashboards using Excel and Power BI to monitor KPIs, including lead times, inventory turnover, order accuracy, and supplier performance.
• Collaborate with procurement and logistics teams to optimize inventory levels, minimize excess stock, and enhance order fulfillment rates.
• Monitor vendor performance and work closely with suppliers to ensure timely deliveries and negotiate favorable terms for the organization.
• Conduct root cause analysis on supply chain issues and recommend solutions to reduce bottlenecks and enhance overall efficiency.