Vishal Surya A P

Assortment Analysis

• Analyzed product performance across retailers and regions. Developed a Product Quadrant analysis and a 5-star rating framework to identify strengths and gaps. Built scalable, automated data pipelines for multi-retailer analysis. Identified a 10% market gap in an $80M market, unlocking growth opportunities.

Trade Promotion Optimization

• Developed price elasticity regression models to assess the impact of pricing, seasonality, and promotions on sales. Engineered features from sales, competitor pricing, and external factors to enhance model accuracy. Optimized pricing strategies, improving promotional ROI and sales performance.

Retail Media Attribution

• Built regression models to measure the impact of marketing spend across channels and placements. Developed a budget optimizer using Pyomo to allocate spend effectively, increasing ROI by 5-6%.

Hackathon

• Developed a multi-agent workflow to clean, query, and analyze datasets. Created agents to generate strategies based on insights, using LangChain for implementation.

Data Pipeline Optimization

• Built and managed data pipelines to automate data extraction across regions, reducing processing time from 5 days to 1 day. Implemented automated data quality checks to ensure accuracy and reliability. Developed the solution using Microsoft SSIS for seamless automation.