Projects & Case Studies
Bringing structure to complexity, craft to systems, and clarity to scale.
SubForge
Case StudyLocal-First AI Subtitle Studio & TUI
A fast, local-first subtitle generation and editing studio. Powered by standalone whisper.cpp with zero-bloat GGML models, interactive terminal UI audio scrubbing, and instant SRT/ASS export for video editor.
Open Lakehouse on GCP (StarRocks + Apache Iceberg)
Case StudyProduction Open Lakehouse with Iceberg, Polaris & StarRocks
Architected a cloud data lakehouse on GCP separating storage, metadata, and compute using Apache Iceberg, Apache Polaris REST Catalog, StarRocks, Airbyte CDC, and Terraform.
Cuan
LiveLocal-First Personal Finance Engine
A zero-knowledge, offline-first personal finance app. All your financial data lives in a browser-embedded PostgreSQL database — never on our servers unencrypted. Works on planes, underground, anywhere.
Scitia Exam
In DevelopmentDigital SAT & IELTS Online Exam Platform
A high-performance online examination & LMS platform tailored for Digital SAT and IELTS standards with WebAssembly AI proctoring and real-time LaTeX formula rendering.
PostgreSQL Data Warehouse & CDC Pipeline
Case StudyNear Real-Time CDC & Micro-Batch Data Warehouse
Architected an efficient analytical Data Warehouse using PostgreSQL, Debezium, and Kafka for CDC. Isolated analytical workloads from MySQL OLTP with sub-5-minute latency and zero cloud bloat.