Tushaar Kapil

About

Computer Science and Engineering student with hands-on experience in SQL, Python, Power BI, and Google Cloud BigQuery through analytics projects in retention, engagement, and experimentation. Strong in data transformation, dashboarding, and statistical analysis for business decision-making.

Education

• Bachelor of Technology (B.Tech)
  Anand Engineering College
  Computer Science and Engineering · Jul 2027

Skills

• SQL
• Data Engineering
• Python
• Matplotlib
• NumPy
• Pandas
• DAX
• Hypothesis Testing
• Seaborn
• Data Modeling
• ETL
• A/B Testing
• KPI Analysis
• Google BigQuery
• Chi-Square Test

Projects

• EdTech Student Engagement & Dropout Risk Analysis ↗
  SQL (SQLite), Python, Pandas, Matplotlib, Power BI

  Analyzed student engagement and dropout risk using 7 source tables and a 32,593-record analytical dataset. Built a Power BI dashboard and an early-disengagement indicator to identify at-risk students.

• Customer Retention Risk Analysis ↗
  SQL, Power BI, DAX, ETL/Data Transformation

  Analyzed repeat purchase behavior across 93K customers and built a reproducible SQL ETL pipeline and Power BI dashboard for churn-risk analysis.

• Cyclistic Bike-Share: Casual-to-Member Conversion Analysis ↗
  Google Cloud BigQuery, SQL, Power BI

  Processed 5.41M trip records to analyze casual vs. member behavior and proposed a weekend-focused membership plan based on rider patterns.

• Cookie Cats: A/B Testing & Retention Analysis ↗
  Python, Pandas, Matplotlib/Seaborn

  Evaluated an A/B test on gate relocation using statistical tests and confidence intervals, finding a significant Day-7 retention drop.

Courses & certifications

• Google Data Analytics Professional Certificate ↗ · Coursera
• Google AI Essentials ↗ · Coursera
• McKinsey Forward Program ↗ · McKinsey & Company
• CS50: Introduction to Computer Science ↗ · Harvard University