Portfolio

My Data Analyst Portfolio.

NYC Taxi KPI Dashboard

• Built ETL on 3M+ TLC trips + Meteostat weather; added pre-aggregations to cut Tableau read time −70%.
• Project Link

Retail Sales & Fulfillment Analysis

• Modeled 120k+ orders across 8 tables using CTEs/window functions; identified 137% YoY growth and 20+ day delivery gaps.
• Project Link

Ride-sharing Seasonality Tests

• Ran t-tests/ANOVA/Chi-squared with Shapiro-Wilk & Levene checks on 10k+ trips; found season & weather significant (p<0.05); translated into dynamic pricing and fleet recommendations.
• Project Link

Last-mile Route-ETA Feature Pipeline

• Engineered scalable feature pipeline for 144K+ delivery records, implementing temporal extraction, geospatial parsing, IQR outlier detection, and multi-dimensional aggregations to enable predictive modeling for India's largest logistics platform.
• Project Link