Projects
Case Studies
E-Commerce Analytics Engineering
Built and validated a PostgreSQL analytical warehouse for a simulated e-commerce business, then modernized the transformation layer with dbt while preserving exact business logic and outputs.
Machine Learning Ridership Forecast
An XGBoost ridership forecast, written back to the database and published in Power BI, so users can price five fiscal years of planned service.
Transit App Trip Patterns
A scheduled Python-to-SQL-to-ArcGIS Online pipeline that turns Transit app mobile trip data into 7-day travel and 31-day transfer patterns users can analyze in an ESRI web experience site.
OSM Business Locator
A Python CLI that turns a search polygon into a planner-ready business inventory from OpenStreetMap — Excel, GIS files, and an interactive Leaflet map.
GTFS Difference
A local Flask tool that diffs two public GTFS zips — routes, stops, service, calendar, transfers, and fares — then draws the changes on an OSM map and writes an Excel workbook.