Selected Work

Case studies of personal projects I designed and built — problem, constraints, decisions, and what shipped.

Product Owner & Engineer

Stream of Worship

A system that analyzes Chinese worship songs and renders seamless multi-song audio and lyrics-video sets — from catalog scraping to offline-capable playback.

Built for a 400+ song catalog with thousands of scored pairwise transitions

  • Next.js 16
  • FastAPI
  • AWS Lambda/SQS
  • Neon Postgres + pgvector
  • Cloudflare R2
  • PyTorch / Demucs
  • Jetpack Compose (Android)

Designer & Author

googleads-analyst-skill

A Claude agent skill that conducts period-over-period Google Ads analysis, root-causes anomalies against change-event history, and applies approved mutations — with guardrails at every irreversible step.

60+ GAQL fields validated across 12 resources before shipping (.internal validation audit)

  • Claude Agent Skills
  • mcc-gaql CLI suite
  • prompt engineering
  • pandoc / weasyprint

Creator & Maintainer

mcc-gaql-rs

Three Rust CLIs for querying, mutating, and LLM-generating Google Ads GAQL across MCC child accounts — with a RAG pipeline that knows the API schema better than a generalist model.

NL→GAQL generation in ~3-4s end-to-end (docs/RAG_OVERVIEW.md)

  • Rust (workspace, edition 2024)
  • tonic gRPC
  • Polars
  • rig-core / FastEmbed
  • LanceDB + Arrow
  • Cloudflare R2