// 03. My work
Projects.
AnalyticsData EngineeringPythonWeb ScrapingAnalyticCode
Vancouver Food Safety Analysis
Dual-source data pipeline ingesting Vancouver Coastal Health inspection records from annual closure PDFs and a live REST API. Covers 3,900+ inspections across 800+ establishments in 20 neighbourhoods (2019–2026), with violation severity scoring, repeat offender detection, and neighbourhood risk ranking.
AnalyticsNLPPythonReddit APISentiment AnalysisCode
Vancouver Reddit Sentiment Tracker
End-to-end NLP pipeline that collects posts from r/vancouver, r/britishcolumbia, and r/vancouverhousing, scores them with VADER sentiment analysis, and visualizes the results across 8 topic categories — housing, transit, crime, and more.
LiveCodeDesign
HomeBase
Full-stack household management PWA. 8 modules, real-time sync, multi-currency, trilingual. Built with Next.js + Supabase.
Identity, BrandingDesignSocial
Sozaiya
Complete brand identity manual for Sozaiya, convinience store in Vancouver, with color skemes, logo usage and social media templates
AMBranding
DesignSocial
Artis Management
Complete brand identity and social media content system for an international trade consultancy based in Ecuador.
MCIdentity
DesignMotionSocial
Multicourier
Social media visual system and motion graphics for a logistics brand — TikTok and Instagram Reels campaigns.
ContentSocialCode
Homelab
LinkedIn carousel series covering tech, homelab, and self-building. Fully self-produced.