Projects

Personal projects, open-source contributions, and selected professional work.

Personal Projects

herdr-lazy

Featured

A declarative, reproducible plugin manager and curated distribution for Herdr. Keep plugins in a plain list, lock exact commits, and sync a setup across machines.

RustHerdrTUILockfile

Open Source Contributions

TiDB optimizer hint warning fix

Contributed a bug-fix PR for optimizer hint warnings to TiDB, a Go-based distributed SQL database by PingCAP. My first open-source contribution, completed from a good first issue through two LGTM reviews and fully passing CI.

GoTiDBOpen source

Professional Work

Daily profit reporting BFF

Built a BFF that delivers daily operating profit data to a management dashboard, covering API design, OpenAPI contracts, authentication, authorization, and testing while migrating the source from Blob to BigQuery.

TypeScriptHonoOpenAPIDrizzle ORMBigQuery

E-commerce parcel tracking system migration

Led a near-real-time pipeline processing roughly 5 billion parcel records per year at ten-minute intervals. Rebuilt a legacy system with idempotent incremental processing and parcel-ID deduplication.

Azure Data FactoryDelta LakePySparkPower BI

Management information SSOT

Built a platform that consolidates company-wide management information into a single source of truth. Designed authentication, layered permissions, and dynamic access control while migrating analytics from Power BI to a web application.

Next.jsTypeScripttRPCAuth.jsPrismaApache EChartsBigQuery

GraphRAG research and evaluation

Evaluated whether GraphRAG is necessary for a real-world use case by comparing it with a standard RAG baseline across quality, cost, and latency.

PythonLLMGraphRAG / RAGGoogle Cloud