● Developed actionable insights for Marico Limited’s expansion strategy through detailed market analysis and long term planning, supporting business growth initiatives as a part of the institute’s product management club.
● Developed 10+ detailed charts and visualizations enabling data-driven decision-making for stakeholders.
● Optimized data processes, reducing data retrieval time, which accelerated analysis, improved data accuracy, enhanced actionable insights, and supported strategic decision-making.
Customer Segmentation and Sales Optimization | Python.
● Developed a data-driven customer segmentation by analyzing demographic and purchasing patterns, enabling targeted marketing strategies that improved customer satisfaction and engagement.
● Conducted in-depth sales trend analysis using Python libraries (Pandas, Matplotlib, Seaborn) to identify
high-performing product categories and optimize inventory planning, boosting operational efficiency.
● Delivered actionable insights through exploratory data analysis (EDA), cleaning and manipulating raw datasets to empower business decisions and enhance sales performance.
E-Commerce Data Analysis for Pizzeria | SQL, MS Excel.
● Designed a SQL database schema for an e-commerce Pizza shop, efficiently managing 10,000+ orders and 50+ product entries with various table relationships, ensuring seamless data organization.
● Performed sales and revenue analysis using SQL queries, constituting a revenue of $81260 in total from top-selling pizzas. Also revealing insights like customer purchasing behavior, peak order times, and inventory performance to optimize business strategies.
● Supported strategic decision-making by delivering actionable insights on sales trends, product life-cycle, and customer preferences, contributing to revenue growth and enhanced operational efficiency.