Charlie Guo
Data engineer in Toronto. I build small, inspectable software to understand the systems underneath.
Twelve letters, six obsessions. Hover, focus, or tap a letter to see what it is made from.
Selected work
A banking data pipeline, a relationship tool, a salon display built for someone else, and an offline trip handbook.
Featured project · synthetic banking data
A weekly bank report, with the pipeline behind every number.
A Python and dbt pipeline turns messy synthetic sources into a tested DuckDB report. Inspect portfolio contact coverage, branch roll-ups and data quality checks.
Open project
Small tool · public demo uses fictional people
Remember the people, the conversations and who to reconnect with.
A local-first relationship map keeps context close for your next conversation. The public version uses fictional seed data; a real vault stays on its own disk.
Open project
Built for a nail studio
A salon window that shows the work and makes booking easy.
An iPad display pairs rotating nail designs with fixed booking QR codes. Cached photos keep it running when the hotspot drops.
Open project
Personal travel tool · archived trip
Five days of plans in your pocket, even without a signal.
Routes, bookings and daily plans in one HTML file. Made for a Cape Breton trip and kept as an archive after the journey.
Open projectThis site is a project too: one static page, interactive letters and a live edge readout. Explore the source.
