Things I've built, solo and with teams.
Automated ELT pipeline for real-time air quality data from the AirKorea API. Bronze/Silver/Gold layers in Supabase, hourly Airflow runs, and alerts posted to X when the air gets hazardous.
Web app and Telegram bot for tracking missed prayers, with real users. FastAPI backend, React + TypeScript frontend.
ELT pipeline that ingests football data, cleans and standardizes it, and builds analytical tables for performance insights.
Data warehouse with Bronze, Silver and Gold layers built from raw CSVs, with a star schema for KPI and reporting queries.
Operating Systems course project at Inha. Led a team of 8: managed the repo, merged commits and reviewed everyone's code.
Real-time recognition of ASL letters and digits from a webcam.
SQL scripts that explore and analyze a sales database: rankings, trends over time, customer segments and ready-made reports.