- Contact: +1 (416) 856-3451 | hetachavda16@gmail.com
- LinkedIn: LinkedIn Profile | GitHub: GitHub Profile | Portfolio: Portfolio
- Master of Data Analytics, University of Niagara Falls, Niagara Falls, ON, Canada (Oct. 2024 - Apr. 2026)
- Master of Commerce, Advanced Accounting, Sardar Patel University, India (Jul. 2019 - Jul. 2021)
- Data Analyst Co-op, Sense of Beauty Spa & Brow Bar, Niagara Falls, ON, Canada (Sep. 2025 - Dec. 2025)
- Student Data Analyst, University of Niagara Falls, Niagara Falls, ON, Canada (Apr. 2025 - Jul. 2025)
- Data Analyst, Anblicks, Ahmedabad, India (Apr. 2023 - Sep. 2024)
- Associate Data Analyst - Client: CCIL/RBI, Munimshree Accounting & Tax Services, Dakor, India (Aug. 2021 - Mar. 2023)
- Languages: Python, SQL
- Data Visualization Tools: Power BI, Tableau, Looker Studio
- Libraries: Pandas, NumPy, Matplotlib, scikit-learn
- Data Analysis & Reporting: Power BI (DAX, Power Query), Advanced Excel (PivotTables, Formulas, Charts, Data Validation), KPI Reporting, Trend & Variance Analysis, Root-Cause Analysis
- Database and ETL Tools: MySQL, Snowflake, Relational Databases, Azure Data Factory (ADF), ETL, Automated Data Pipelines
- Data Quality & Validation: Multi-source Data Collection & Consolidation, Data Validation, Data Accuracy & Consistency, Data Quality Checks
- Digital Analytics: Google Analytics 4 (GA4), Google Tag Manager
- Business Analysis: Requirements Gathering, Process Improvement, Stakeholder Communication, Cross-functional Collaboration
- Version Control: Git/GitHub
- Developer Tools: JIRA
- Google Data Analytics Professional Certificate (In Progress)
- Bloomberg Market Concepts (BMC)
- SQL - HackerRank
- Databricks Fundamentals
- Introduction to JIRA
A selection of projects demonstrating practical experience in data analysis, business intelligence, predictive modeling, visualization, database design, and optimization.
Python Β· Power BI Β· Linear Regression Β· Random Forest Β· ARIMA/SARIMA
Engineered an end-to-end analytics pipeline using NAPS air-quality data from 2020β2023. Built and compared predictive models to forecast PM2.5 levels and developed interactive Power BI dashboards to identify high-risk regions.
Python Β· Pandas Β· scikit-learn Β· Machine Learning
Developed a classification model to identify customers at risk of loan default. Performed data preprocessing, exploratory analysis, feature evaluation, and model comparison, achieving a ROC-AUC score of 0.915.
Python Β· Pandas Β· Machine Learning Β· NLP
Analyzed application ratings and customer reviews to identify factors associated with user satisfaction. Applied sentiment analysis and compared five machine-learning models for predictive analysis.
Python Β· K-Means Β· Excel Β· Customer Analytics
Applied K-Means clustering to segment customers into four distinct behavioral groups and translated analytical findings into targeted marketing opportunities.
Tableau Β· Data Visualization Β· Trend Analysis
Built an interactive Tableau analysis of 14.8K+ electric vehicle registrations, examining adoption patterns, vehicle types, manufacturers, geographic trends, and BEV versus PHEV distribution.
MySQL Β· SQL Β· Database Design Β· 3NF
Designed a fully normalized relational database for 8+ dealership entities and developed SQL queries using JOINs, aggregations, and GROUP BY to analyze sales performance and support future forecasting.
| Project | Focus | Technologies |
|---|---|---|
| Housing & Bike-Sharing Analytics | Predictive and prescriptive analytics | Python Power BI |
| Urban Public Transit Route Optimization | Transportation scheduling and optimization | Python OR-Tools |
| End-to-End Python Data Analysis | Data cleaning, EDA and analytical modeling | Python Pandas |
| Customer Behavior Models | Regression, classification and clustering | Python SQL Power BI |
| Uber vs Lyft Comparative Analysis | Statistical analysis of ~650K ride records | Python Statistics |
| PESTEL Analysis β Ethanol Blending | Policy, economic and strategic analytics | Python Analytics |
| Ethics in Prescriptive Analytics | Responsible analytics and data privacy | Optimization |
I'm open to Data Analyst,and Business Analyst opportunities where I can turn complex data into actionable business insights.
π§ Email: hetachavda16@gmail.com πΌ LinkedIn: linkedin.com/in/hetachavda π Portfolio: hetachavda.github.io
Let's turn data into decisions.