Open to Data Analyst roles

Sanket
Kothiya

Data Analyst · Turning messy data into decisions that move the needle.

01About

Data with a point of view.

Data Analyst with 2 years of experience turning complex datasets into business insight. I work across SQL, Python and BI tooling (Power BI, Streamlit, Excel) to clean, model and visualize data — building dashboards and pipelines that make reporting faster and decisions sharper.

I care less about the chart and more about the decision behind it — the recommendation a stakeholder can act on tomorrow morning.

0+
Years analyzing data
0
End-to-end projects
0%
Best model accuracy
0%
Peak conversion lift
02Toolkit

The stack I reach for.

Languages

PythonSQLRJavaScriptTypeScript

Analytics & BI

Power BIDDAXExcel (VBA)GAGoogle AnalyticsMatplotlibSeaborn

Python Stack

PandasNumPyStreamlitScikit-learn

Data & Cloud

PostgreSQLMySQLSQL ServerMongoDBETL PipelinesAWSAzureGCPMFMicrosoft Fabric
PythonSQLPower BITableauPandasScikit-learnPostgreSQLStreamlitETL PipelinesStatsmodelsNumPySeabornPythonSQLPower BITableauPandasScikit-learnPostgreSQLStreamlitETL PipelinesStatsmodelsNumPySeaborn
03Journey

Where I've made an impact.

Data Analyst — Industry Collaboration @ Jaguar Land Rover

May 2025 — Aug 2025

Windsor, ON · via University of Windsor

  • Partnered with JLR's Semiconductor Modeling & Performance Evaluation team to build an end-to-end AI benchmarking platform that accelerated GPU performance evaluation for stakeholders.
  • Designed a normalized PostgreSQL schema of 8 interconnected tables storing 2,100+ GPU records and 53 engineered features, improving query performance for downstream analytics.
  • Built a Streamlit dashboard delivering real-time GPU benchmarks, cost-optimization insights, and cross-vendor comparison so stakeholders could spot savings within hours.
  • Engineered an end-to-end ETL pipeline unifying heterogeneous data sources into a single benchmarking schema, cutting manual prep work.

Data Analyst @ LiveField

Sep 2022 — Mar 2024

Surat, India

  • Analyzed structured and unstructured data with SQL and Python (pandas, NumPy) to streamline workflows and surface the drivers behind faster operational decisions.
  • Built interactive Power BI dashboards and reports that lifted visibility into key business metrics and sharpened stakeholder reporting.
  • Implemented data validation and quality checks, reducing errors and protecting data integrity across multiple systems.
  • Built reusable data models and reporting templates to cut redundancy and scale recurring analysis tasks.

University of Windsor

Master of Applied Computing

May 2024 — Aug 2025 · Windsor, Canada

A.D. Patel Institute of Technology

B.Tech, Computer Engineering

May 2018 — May 2022 · Anand, India

04Selected Work

Eight projects, sorted by craft.

Machine LearningMachine Learning · Jaguar Land Rover

AI Benchmarking & GPU Performance Prediction

2025

Predictive analytics platform that evaluates AI hardware performance, correcting manufacturer bias and forecasting GPU efficiency with research-grade accuracy.

94%
Prediction accuracy
2,100+
GPU records
53
Engineered features
  • Built Random Forest & XGBoost models reaching 94% accuracy on GPU performance prediction.
  • Designed a normalized PostgreSQL schema with 8 interconnected tables.
  • Implemented bias-correction algorithms to neutralize manufacturer reporting skew.
  • Shipped an end-to-end ETL pipeline feeding a real-time Streamlit dashboard.
PythonXGBoostPostgreSQLStreamlitPower BI
BI & Data AppsPeople Analytics · Power BI

HR Workforce Attrition Analysis

2025

Power BI dashboard analyzing attrition across 1,470 employees — surfacing where talent slips through and giving HR a filterable view across department, role, age, and tenure.

1,470
Employees
16.12%
Attrition rate
8+
DAX measures
  • Analyzed attrition with DAX across department, job role, age group, and tenure.
  • Engineered KPI measures: attrition rate, active headcount, age-band segmentation.
  • Added slicers for filtering by education, gender, and department.
  • Layered validation and segmentation logic to keep every view reporting-accurate.
Power BIDDAXMS SQL ServerExcel
Case study
Statistical AnalysisStatistical Analysis

Marketing Campaign A/B Testing & Regression

2024

Compared Facebook Ads vs AdWords for a marketing agency — using hypothesis testing and regression to recommend where every ad dollar should go.

2 platforms
Head-to-head
t-test
Significance
Conversion model
  • Ran an independent t-test to prove one platform converts significantly better.
  • Trained a linear regression model predicting conversions from clicks.
  • Added cointegration testing to find long-term spend–conversion relationships.
  • Translated stats into a budget recommendation for non-technical stakeholders.
PythonPandasStatsmodelsScikit-learnSeaborn
Case study
Statistical AnalysisHypothesis Testing

Maximizing Driver Revenue — NYC Taxi

2024

Tested whether payment method drives fare size across NYC yellow-cab trips, then quantified the revenue upside of nudging riders toward card payments.

p < 0.001
Significant
Card > Cash
Avg fare
1M+
Trips analyzed
PythonPandasSciPyMatplotlib
Case study
SQL & EDASQL · Revenue Analytics

Aviation Performance & Occupancy

2024

Explored an airline's booking and fare data in SQLite to find where empty seats bleed revenue — and modeled the upside of a 10% occupancy lift.

+10%
Occupancy scenario
8 tables
SQLite schema
Fleet
Level analysis
SQLSQLitePythonPandas
Case study
BI & Data AppsFinTech · Streamlit

CAPM Financial Analysis Web App

2024

An interactive Streamlit app that benchmarks stocks against the S&P 500 — calculating beta, expected return and normalized price movement on the fly.

Beta
Risk estimate
S&P 500
Benchmark
Live
Market data
  • Built reusable functions for normalization, daily returns and beta.
  • Pulled live market data via yfinance and merged on trade date.
  • Rendered interactive Plotly charts for price comparison.
  • Computed CAPM expected return against the S&P 500 benchmark.
PythonStreamlitPlotlyYyfinancePandas
Case study
SQL & EDASQL + Python

Yelp User Engagement Analysis

2024

End-to-end study of whether user engagement predicts restaurant success — from loading raw Yelp JSON into SQLite to a custom success score and sentiment cuts.

5 datasets
Yelp JSON
IQR
Outlier control
Geo + time
Dimensions
SQLSQLitePythonFoliumSeaborn
Case study
SQL & EDAExploratory Analysis

Hotel Booking Cancellation Analysis

2024

Dug into why hotel bookings get cancelled — separating City vs Resort behavior and linking price, season and channel mix to cancellation pressure.

City vs Resort
Segmented
ADR
Price driver
Seasonal
Patterns
PythonPandasMatplotlibSeaborn
Case study
BI & Data AppsBusiness Intelligence · Power BI

Vendor Performance Analysis

2024

Company-style vendor analytics combining a SQLite ingestion pipeline, statistical testing and a Power BI dashboard to guide pricing, purchasing and inventory.

Pipeline
CSV → SQLite
KPIs
Margin & turnover
Power BI
Dashboard
PythonSQLSQLAlchemyPower BIPandas
Case study
05Contact

Let's turn your data into decisions.

I'm open to Data Analyst roles and collaborations. The fastest way to reach me is email — I usually reply within a day.