Projects & Skills
Projects I've actually built. Tools I actually use.
Technologies
Analytics & BI
Data Engineering
Cloud & Databases
Machine Learning & AI
Projects
Data Platform for Vacation Rental Marketplace
Event-driven AWS ELT pipeline with Snowflake, dbt Medallion architecture, SCD Type 2 snapshots, and a 7-task fail-fast Airflow DAG with 64 automated data quality tests.
MBTA On-Time Performance Prediction with ML and Parallel Processing
Distributed PySpark pipeline on Databricks ingesting 150M+ records across 5 sources, training 4 MLlib regression models, and benchmarking parallelism scaling from single-node to multi-node Spark – achieving 2.73x speedup.
Los Angeles Wildfire Visualization Pipeline with AWS and Tableau
Near real-time wildfire monitoring pipeline using AWS Lambda, S3, and Glue, feeding live geospatial Tableau dashboards that auto-refresh every 3 hours – reducing manual tracking by 85%.
End-to-End Azure Data Factory & Databricks Incremental Data Pipeline
ADF-orchestrated Databricks pipeline with parameterized incremental loads, star schema in Delta Lake with SCD Type 1, Unity Catalog governance, and high-water mark ingestion.
Clinical Trial Data Management System
Hybrid MySQL + MongoDB system managing patient data, treatments, clinical trials, researchers, and outcomes – with Python analytics covering demographics, adverse events, and drug utilization.
Apple Retail Sales Analysis with Advanced SQL
High-performance PostgreSQL analytics across 1M+ Apple retail transactions – solving 23 business problems with query optimizations delivering up to 95% faster execution and 54% performance gains.
Los Angeles Crime Analysis and Predictive Modeling
Python-based EDA and ARIMA time-series forecasting on LA crime data from 2020–2024, identifying vehicle theft as the top crime category and projecting a 14.89% crime reduction through late 2025.