Selected work

Projects

Retail demand planning, financial data engineering, and transaction analytics, alongside completed work with transit, mobility, and public retail data. In-progress architecture is labeled as planned direction.

03Retail analyticsCompleted

Retail Demand & Financial Planning Intelligence

An end-to-end retail analytics platform using public data to connect demand planning, financial performance, and inventory decisions.

Built a workflow for forecast-versus-actual analysis, variance review, and scenario-based revenue, gross profit, and inventory planning, with results presented in Power BI.

Tools & focus

  • Python
  • SQL
  • PostgreSQL
  • Power BI
  • DAX
  • Public retail data
04Transit operationsCompleted

Green Line Operations Intelligence

Operational analysis of the MBTA Green Line using official GTFS data, Python, SQL, and Tableau.

The project focuses on service performance measures such as headways, schedule adherence, and operational KPIs.

Tools & focus

  • Official MBTA GTFS
  • Python
  • SQL
  • Tableau
05Mobility analyticsCompleted

NYC Taxi Trip Analytics

Demand and revenue analysis across more than two million NYC Yellow Taxi records using SQL and Power BI.

Analysis covers high-traffic zones, hourly trip patterns, payment types, trip distance, and revenue.

Tools & focus

  • 2M+ taxi records
  • SQL
  • Power BI
  • Demand & revenue
Discuss a project