Data Analyst

Hiral Bhavsar

***************@*****.*** 519-***-**** LinkedIn Oakville, On

Profile

Data Analyst with 4+ years of experience specializing in environmental and geospatial analytics. Proficient in Python, R, SQL, and cloud platforms

(AWS, GCP, Azure) to extract, clean, and transform large datasets into actionable insights. Skilled in developing interactive dashboards in Tableau and Power BI that reduced reporting time and improved decision-making efficiency by up to 50%. Experienced in ETL automation, database optimization, and statistical analysis (regression, time series, hypothesis testing). Proficient in ArcGIS/QGIS, ESG reporting, and Environmental Impact Assessment

(EIA), delivering compliance-driven solutions that support sustainability initiatives. Collaborative in Agile/Scrum environments with proven ability to deliver measurable business outcomes.

Skills

Programming & Scripting

Python (Pandas, NumPy, Scikit-learn), R

Data Visualization & Reporting

Tableau, Power BI, QuickSight, QlikView,

Excel (Pivot, Advanced Formulas), Jupyter

Notebook

Data Engineering & Automation

ETL Development, Data Cleaning &

Transformation

Databases

SQL Server, MySQL, PostgreSQL, NoSQL

Environmental & Geospatial Tools

ArcGIS, QGIS, EIA, ESG Data Reporting, EPA

Energy Star Portfolio Manager

Version Control

Git

Statistical & Data Analysis Techniques

Regression, Hypothesis Testing, Time Series,

Environmental Data Modeling, Cost/Benefit,

Risk, GAP, Business Impact Analysis

Cloud Platforms

AWS (S3, Redshift, Glue), GCP (BigQuery),

Azure (Data Lake, SQL)

Methodologies

Agile/Scrum, SDLC

Professional Experience

Data Analyst, Deloitte 01/2025 – Present

•Conducted exploratory analysis with SQL & Excel, delivering insights that strengthened business strategy.

•Designed Power BI dashboards, reducing reporting cycles and enabling real-time decision-making.

•Automated ETL workflows with Python, improving operational efficiency and data quality.

•Managed SQL Server, Oracle, and MySQL databases, optimizing performance and supporting warehousing.

•Collaborated in Agile teams, aligning analytics projects with evolving business goals. Data Analyst, TCS 10/2020 – 07/2024

•Conducted exploratory analysis with SQL & Excel, delivering insights that strengthened business strategy.

•Designed Power BI dashboards, reducing reporting cycles and enabling real-time decision-making.

•Automated ETL workflows with Python, improving operational efficiency and data quality.

•Managed SQL Server, Oracle, and MySQL databases, optimizing performance and supporting warehousing.

•Collaborated in Agile teams, aligning analytics projects with evolving business goals. Research Experience

Spatial Knowledge Mobilization 03/2025 – 04/2025

Analyzed liquor shop proximity to schools in Toronto using R Studio & ArcGIS; created a StoryMap for public awareness. Advanced GIS – Washington Snowstorm Analysis 03/2025 – 04/2025 Integrated NOAA snow data with social vulnerability, elevation, and population density in ArcGIS Pro to assess storm impacts. City of Kitchener Landmarks 02/2025

Classified city landmarks in R Studio; published results in an ArcGIS Dashboard for accessibility. Projects

Sales Forecasting (Python + SQL)

•Forecasted daily, weekly, and monthly sales trends using SQL + Python, identifying high-demand products.

•Delivered time-based insights with Matplotlib & Seaborn to improve planning and inventory management. Online Sales Data Visualization (Tableau)

•Built interactive dashboards with symbol maps, heatmaps, and text tables to reveal sales patterns.

•Provided actionable product, region, and time-based insights to support business decisions. Teaching Experience

Teaching Assistant, Wilfrid Laurier University 09/2024 – 04/2025

•Guided students in GIS applications, Python programming, and environmental research projects.

•Mentored on geospatial modeling and environmental statistics, improving student project quality. Assistant Professor, Gyan Manjari Innovative University, India 07/2022 – 07/2023

•Taught QGIS, ArcGIS, and environmental science topics to 150+ students.

•Conducted research projects with students, integrating data analysis and mapping. Visiting Faculty, Sir P.P. Institute of Science, India 01/2021 – 07/2022

•Delivered lectures on Ecology and Environmental Science.

•Simplified complex technical concepts (SEM, TEM, XRD) for undergraduate students. Certifications

Going Places with Spatial Analysis

Esri (Mar 2025)

GIS in QGIS 3 for Beginners

Udemy (Mar 2024)

Python 3

SoloLearn (Jun 2020)

Education

Master of Environmental Data Analytics, Wilfrid Laurier University 09/2024 – 09/2025 Master of Science with Physics, St. Xavier’s College 07/2018 – 08/2020

Contact this candidate