← Back to list
Registration: 25.01.2025

Stavan Brahmbhatt

Specialization: Business Analyst
— I am a Data enthusiast, I like to play with data and find interesting insights that be missed by just eyeballing.
— I am a Data enthusiast, I like to play with data and find interesting insights that be missed by just eyeballing.

Skills

Python
SQL
PowerBI
MS Excel
Jupyter Notebook
Adobe Creative cloud
Figma
Jira
Notion
Adobe Illustrator

Work experience

Business Analyst intern
05.2024 - 08.2024 |Marico Limited
MySQL, Power BI, Python, MS Excel
● 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.

Educational background

Technology in Engineering Physics (Bachelor’s Degree)
2021 - 2025
Indian Institute of Technology

Languages

EnglishProficientHindiNative