Architected an end-to-end ETL pipeline (Snowflake, Python/Pandas, Excel) consolidating 7 Massachusetts DESE datasets across 395+ districts and 6,000+ records to investigate public school resource allocation. Built a multi-stage Snowflake cleaning pipeline - staging, CTE-based deduplication, type-casting, and null handling via TRY_TO_DECIMAL and QUALIFY - with standardized outputs exported to Python/Pandas for exploratory analysis.

View Repo

Low overhead HTML/CSS website to showcase background, skill set, creativity.

View Repo

Led an end-to-end data analysis project to guide Bellabeat's marketing strategy for the launch of a new biometric fitness product line. Sanitized and structured raw user data with SQL in BigQuery, then performed exploratory data analysis in Excel to identify trends in customer behavior. Distilled findings into 3 actionable insights projected to drive profitability in the next fiscal year, presented to shareholders in a comprehensive strategic report.

View Repo

Developed a full-stack, mobile-compatible Snake game from the ground up for Quizlet Inc.'s 2023 Game Development Competition, competing against a field of entrants to place 3rd overall. Built a responsive React/TypeScript frontend and engineered a backend database with full API integration to support real-time gameplay.

View Repo

Engineered UVMap, a full-featured iOS navigation app for the University of Vermont campus, built with Swift/SwiftUI and powered by Apple MapKit for real-time, campus-specific routing. Integrated a Google Firebase backend for secure authentication and credential encryption, and built a dynamic course-scheduling system enabling students to search UVM's catalog and build custom weekly schedules.

View Repo