Atharva Chaskar

Work

Projects

Data Engineering

CTA Performance Analytics Platform

End-to-end pipeline ingesting 25 years of Chicago Transit Authority ridership data from a public REST API, loaded into SQLite, and surfaced through an interactive live dashboard.

Ingested 9,190 records (Jan 2001–Feb 2026) from Chicago Data Portal REST API via Python ETL
Uncovered 57% COVID-driven ridership drop, peak year (2012), and busiest single day (2.05M rides)
Built interactive Plotly Dash dashboard with 4 visualizations — deployed and live

Python Pandas SQLite SQLAlchemy Plotly Dash REST API Render

Live Dashboard ↗ GitHub ↗

Spatial Analytics

Transit–Walkability Gap Research

Applied unsupervised machine learning to 3,322 census block groups to identify mobility misalignment patterns across the Chicago metro area.

K-means clustering (scikit-learn) identifying a Transit–Walkability Gap affecting 53% of the Chicago–Naperville–Elgin CBSA
Rejected fourth variable (D5AR) based on multicollinearity analysis (r = 0.79) and cluster instability
End-to-end pipeline: data cleaning → feature selection → z-score standardization → clustering → ANOVA validation
Publication-quality spatial maps via GeoPandas and Matplotlib

Python scikit-learn GeoPandas Matplotlib K-means ANOVA

GitHub ↗

Data Mining

Chicago Crime Data Engineering & Mining Pipeline

Large-scale preprocessing and analysis of 750K+ Chicago crime records with Tableau dashboards and machine learning models for pattern detection.

Preprocessed 750K+ records — missing values, type conversions, structural inconsistencies
3 Tableau dashboards: executive overview, time/arrest insights, geographic hotspot analysis across 262K+ incidents
Hierarchical clustering in SAS Enterprise Miner with 90% sub-sample stability; Decision Tree at 88% accuracy

Python Pandas Tableau SAS Enterprise Miner Hierarchical Clustering

GitHub ↗

Toolkit

Technical Skills

Analytics & BI

SQL Tableau Power BI EDA K-means Clustering Statistical Modeling

Programming

Python Pandas NumPy scikit-learn GeoPandas R

Data Engineering

Azure Data Factory ETL / ELT SQLAlchemy REST APIs SQLite

Workflow & Dev

Git CI/CD Agile / Scrum Plotly Dash Excel

Background

Experience

Associate Application Developer

Accenture · Data & Analytics · Pune, India

Apr 2023 – Jul 2024

Reduced support incidents by 30% and maintained 99%+ data reliability by designing and enforcing data quality checks across Azure Data Factory ELT pipelines processing data from 5+ heterogeneous sources
Authored SQL transformations producing curated, analytics-ready datasets powering enterprise reporting dashboards
Partnered with analysts and product owners to translate business requirements into validated data outputs in Agile-Scrum sprints
Managed code promotion across environments using CI/CD and Git-based workflows

Education

M.S. Management Information Systems

University of Illinois Springfield

GPA 3.91 / 4.00 · May 2026 · Beta Gamma Sigma

B.E. Mechanical Engineering

JSPM's Rajarshi Shahu College of Engineering, Pune

May 2022