8+ Yrs Exp · 5y Data Engineer · 3y Project Manager · Fullstack & Math Tutor

Making sense of data, getting lost in game worlds, and capturing the moments in between.

I’m Yudho Prakoso (@yudopr). I architect data platforms to find clarity in chaos, immerse in virtual worlds for the stories they leave behind, and write about life whenever inspiration strikes.

Explore Systems & Code Watch Chronicles Read Field Notes

SYSTEMS & ARCHITECTURE

Featured Systems & Case Studies

Bringing structure to complexity, craft to systems, and clarity to scale.

All projects

SubForge

Case Study

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 DaVinci Resolve.

Pythonwhisper.cppTextual TUISpeech-to-TextDaVinci ResolveOpen Source

Read Case Study Live Demo

Open Lakehouse on GCP (StarRocks + Apache Iceberg)

Case Study

Architected a cloud data lakehouse on GCP separating storage, metadata, and compute using Apache Iceberg, Apache Polaris REST Catalog, StarRocks, Airbyte CDC, and Terraform.

StarRocksApache IcebergApache PolarisAirbyteGCPTerraform

Read Case Study

Cuan

Live

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.

PGliteOPFSWASMXChaCha20GoReact

Learn about Cuan Live Demo

Scitia Exam

In Development

A high-performance online examination & LMS platform tailored for Digital SAT and IELTS standards with WebAssembly AI proctoring and real-time LaTeX formula rendering.

GoPostgreSQLReactTypeScriptViteWASM ProctoringDocker

Visit Scitia Edu

PostgreSQL Data Warehouse & CDC Pipeline

Case Study

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.

PostgreSQLDebeziumKafkaCDCpg_cronETL/SQL

Read Case Study

VISUAL CHRONICLES

Watch on YouTube & TikTok

Data engineering walkthroughs, deep dives into game worlds & lore, and candid life shorts.

YouTube

Persona vs Trails in the Sky - Story & Game Mechanics Breakdown

Aug 5, 2026Watch on YouTube

TikTok

SQL Challenge: Compressed Mean - Data Engineering Teardown

Jun 17, 2023Watch on TikTok

FIELD NOTES & ESSAYS

Data, Stories & Life Telemetry

Reflections on data systems, narrative game analyses, and honest moments from everyday life.

View all articles

Architecture

Building SubForge: A Local-First, Zero-Bloat AI Caption Studio for Creators

How moving from CapCut to DaVinci Resolve inspired me to build a keyboard-driven, local-first AI subtitle generation and editing studio powered by whisper.cpp and Textual.

2026-08-286 min read

Data Engineering

Why Big Companies Keep Migrating Their Data Stacks (Hint: It's Not Technical)

BigQuery to Snowflake, Snowflake to Databricks — enterprise data stack migrations are rarely about benchmarks. Here's the business politics that actually drive them, and why it's good news for data engineers.

2026-08-226 min read

Data Engineering

When Does a Data Engineering Take-Home Become Overengineering?

A reflection on two Data Engineering take-home projects, why I deliberately went beyond the minimum requirements in one, kept real-time processing optional in another, and how I decide whether extra architecture is justified.

2026-08-2021 min read