Subham Sarin

About

Aspiring Data Analyst pursuing a B.Tech in Computer Science, with hands-on experience building end-to-end analytics projects in Power BI, Excel, and SQL. Skilled in data cleaning, KPI tracking, reporting, and query optimization, with a strong self-driven approach to solving business problems.

Education

• B.Tech in Computer Science
  IIMT University, Greater Noida
  Computer Science · 2023 – 2027
• Senior Secondary (XII)
  AVB Public School, Delhi
  CBSE · 2023 – 2023
• Secondary (X)
  AVB Public School, Delhi
  CBSE · 2021 – 2021

Skills

• Automation
• Python
• Data Cleaning
• NumPy
• Pandas
• KPI Tracking
• Statistical Analysis
• Query Optimization
• Window functions
• Subqueries

Projects

• Sales Data Analysis — SQL Processing System
  SQL, MySQL, Query Optimization, ETL, Data Cleaning

  Reduced query run time by 20% on large-scale sales data using JOINs, GROUP BY, and window functions. Improved data quality by 30% via ETL cleaning pipelines; generated reports on sales performance and customer trends.

• E-Commerce Sales Dashboard
  Excel, Pivot Tables, Pivot Charts, KPI Tracking, Data Visualization

  Analyzed 50,000+ sales records and built KPI dashboards (revenue, AOV, category sales) with slicers, cutting reporting effort by 35%. Surfaced actionable insights on top products, customer behavior, and seasonal demand patterns through trend analysis.

Courses & certifications

• SQL for Data Analysis · MySQL & Query Optimization
• Statistics for Data Science · IBM
• Data Analytics 101 · Simplilearn / Microsoft / LinkedIn Learning