Case Studies

Deep dives into selected work — the background, my role, the technical decisions, and the outcome.

• 01

  ReplicationServer (anonymized): SQL Server → Oracle replication at tens-of-millions-row scale

  Posted on September 30, 2026

  A pull-based, row-level replication service: Change Tracking capture in-engine, a measurement-driven delivery path, row-level and batch-level failures treated separately, and recovery left to an operator runbook with WhatIf dry-runs — every design decision backed by a measured number.

• 02

  Face Shape and Color Analysis Mini-Program, in One Month (Privacy-First)

  Posted on September 24, 2026

  On-device feature extraction (photos never leave the phone), algorithmic analysis, and a complete paid-report funnel with coaching referral — from frozen requirements to launch checklist, solo, in one month.

• 03

  Learn It by Building It: the Agent Skills Course Site

  Posted on September 20, 2026

  Learning these skills was the process of building the site that teaches them: three days, 24 issues, 10 learning logs — every workflow the course teaches has one real run in the repo's issue history.

• 04

  12 Years on an Enterprise Case-Management Platform

  Posted on September 1, 2026

  Anonymized deep dive: an application platform built to generate business systems — relational data management, distributed data access, and a tens-of-millions-row replication pipeline — evolving through six technology generations without a single rewrite.