Gayatri Butkar

About

B.Sc. Information Technology graduate with practical experience in SQL, Python, and Power BI. Built an e-commerce analytics project involving data cleaning, MySQL modeling, SQL analysis, and interactive dashboarding, with basic machine learning experience in regression models.

Experience

• Machine Learning Intern
  Acmegrade
  2024 – 2024

Education

• B.Sc. Information Technology
  SNDT University
  Information Technology · Jun 2023 – Apr 2026
• HSC (PCM)
  Patkar Varde College
  PCM · Jun 2021 – Apr 2023

Skills

• Python
• Data Cleaning
• NumPy
• Pandas
• scikit-learn
• Exploratory Data Analysis
• KPI Analysis
• Relational Database Design
• Sql Joins
• Aggregation
• Subqueries

Projects

• Interactive E-Commerce Sales Dashboard
  Power BI

  Created a Power BI dashboard to explore e-commerce sales performance across different report views. Included revenue trends, profit distribution, product category performance, customer contribution and payment mode breakdowns.

• E-Commerce Analytics Pipeline — Olist Dataset
  Python (Pandas), MySQL, SQL, Power BI

  Worked with the Olist e-commerce dataset from data cleaning through analysis and dashboard creation. Used Pandas to clean and prepare order, customer, seller and product data, then organized the data in MySQL for analysis. Wrote SQL queries to find top products and customers, revenue by city and state, monthly sales, average order value and best-selling categories. Created an interactive Power BI dashboard showing 72.53K total sales, 182 orders and 398.52 average order value, with filters for time, city and product category.

🏆 Achievements & awards

• Winner — Code Decode & IT Quiz, SNDT Tech Fest
• Participant — Next Edge Conclave, Data Analytics Track