Data Analyst with 2 years of experience turning complex datasets into clear business insights and decisions. Strong in data cleaning, transformation, and building dashboards that improve reporting efficiency in Agile environments.
- 📊 I work the full analytics workflow: SQL · Python · Power BI · ETL · Cloud
- 🌱 Currently deepening Microsoft Fabric and ETL pipeline work
- 👯 Open to collaborate on analytics, dashboarding, and ML applications
- 💬 Ask me about data modeling, dashboards, DAX, and SQL optimization
- 👨💻 See my work at sanketkothiya.netlify.app
- 📝 I write on Medium
- 📫 Reach me at sanketkothiya50@gmail.com
- 📄 View my resume
Jaguar Land Rover — Industry Collaboration, University of Windsor · Windsor, ON · May 2025 – Aug 2025
- Partnered with the Semiconductor Modeling & Performance Evaluation team to build an end-to-end AI benchmarking platform (Python + PostgreSQL) for faster GPU performance evaluation.
- Designed a normalized PostgreSQL database of 8 interconnected tables storing 2,100+ GPU records and 53 engineered features.
- Built a Streamlit dashboard for real-time benchmark analysis, cost-optimization insights, and cross-vendor comparison.
- Engineered an ETL pipeline integrating heterogeneous sources into a unified benchmarking schema.
LiveField — Data Analyst · Surat, India · Sep 2022 – Mar 2024
- Analyzed structured & unstructured data with SQL and Python (Pandas, NumPy) to surface key business drivers.
- Built interactive Power BI dashboards improving visibility into business metrics and stakeholder reporting.
- Implemented data validation & quality checks, reducing errors and maintaining data integrity across systems.
- Built reusable data models and reporting templates to cut redundancy in recurring analysis.
| Project | What it does | Stack |
|---|---|---|
| JLR AI Benchmarking System 🔗 live | GPU benchmarking platform built with Jaguar Land Rover — 2,100+ records normalized into PostgreSQL, cost-optimization insights via a live Streamlit dashboard. | Python · PostgreSQL · Streamlit · ETL |
| HR Workforce Attrition Analysis | Power BI dashboard analyzing attrition across 1,470 employees; 8+ DAX measures surfacing a 16.12% attrition rate by department, role, age & tenure. | Power BI · DAX · MS SQL · Excel |
| CrediWise — Automated Credit Approval | Credit-decisioning analytics with TD Bank / University of Windsor. A/B testing in Agile lifted form completion by 28%. | Python · SQL · Scikit-learn · Power BI |
🔎 More projects at sanketkothiya.netlify.app
Data Analytics & Visualization
-217346?style=for-the-badge&logo=microsoftexcel&logoColor=white){kind=icon}
Languages & Python Libraries
Databases (+ ETL Pipelines · Data Modeling · Data Validation)
Cloud & DevOps
- 🎓 Master of Applied Computing — University of Windsor, Windsor, ON · May 2024 – Aug 2025
- 🎓 B.Tech, Computer Engineering — A.D. Patel Institute of Technology, India · May 2018 – May 2022
