Work
Analytics, databases, and client work — built end-to-end.
End-to-end data warehouse built in PostgreSQL using a star schema (fact + dimension tables). Python ETL pipeline ingests and transforms raw CSV sales data. Includes 20+ analytical SQL queries — YoY revenue growth, customer cohort retention, and product margin analysis — surfaced via a Tableau KPI dashboard.
Analyzed a 10,000+ row retail dataset to identify churn drivers using Python (pandas, seaborn) and SQL. Built a Tableau dashboard surfacing top churn risk segments with a business-ready retention report.
Designed a normalized relational schema (3NF/BCNF) for an e-commerce business. Wrote 15+ SQL queries to answer business questions and validated results in BigQuery. Built a Google Sheets KPI dashboard for non-technical stakeholders.
Client site delivered end-to-end. Built a modern, mobile-responsive website for a Toronto barbershop. This is a React/Next.js recreation of the delivered design.
Built client websites under arweb.co (barbershop & catering). Implemented Google Analytics, pulled and cleaned GA export data in Python, and delivered monthly performance reports with traffic and conversion recommendations.
A data pipeline that ingests historical game statistics from public sports APIs into a normalized PostgreSQL database, applies machine learning models (scikit-learn) to forecast game outcomes, and serves live predictions through a Flask dashboard. Designed with data integrity, query performance, and model accuracy in mind.
