Backend engineer — Jakarta Backend Engineer

Systems that hold under load.

Backend engineer building data-heavy services: POS and ERP integration, financial reconciliation, and forecasting that operations can plan against.

View work Contact

Selected work

Case study 01 Data engineering, modelling

Sales Forecasting Layer

A bags and apparel business planned stock and budget from spreadsheets, with no view of what demand was likely to do next.

Role: Data engineering, modelling
Stack: ClickHouse · dbt · Python · Prophet · LightGBM · FastAPI

dbt marts in ClickHouse feed a Python worker, a Prophet baseline with LightGBM models, and a FastAPI serving layer, writing daily 0 to 6 month and monthly 6 to 24 month horizons back into the warehouse. Every modelling decision is recorded with the evidence behind it.

Case study 02 Schema design, full stack

jowarung POS

A retail business ran purchasing, stock and cash across spreadsheets, so cost of goods and the real stock position were both estimates.

Role: Schema design, full stack
Stack: Next.js · Prisma · PostgreSQL · Tailwind CSS · Cloudflare R2

A Next.js and Prisma application on Postgres covering purchase orders, an inventory ledger with stock opname, sales transactions, cash movements, and price plus cost history, with an audit log on every write.

Case study 03 Architecture, media pipeline

Photographer Gallery SaaS

Photographers needed to deliver and share client galleries without running their own storage and image pipeline.

Role: Architecture, media pipeline
Stack: Next.js · Prisma · BullMQ · Redis · WebDAV · Cloudflare R2 · sharp

Multi-tenant by custom domain on Prisma, with albums, pages and download analytics. A BullMQ worker on Redis handles image processing while originals are stored on NAS storage over WebDAV and Cloudflare R2 serves the CDN copies.

Case study 04 Full stack

PhotoBox

Event photo booth sessions ended with guests waiting for someone to copy files off a laptop.

Role: Full stack
Stack: Next.js · Supabase · Tailwind CSS · Resend · QR codes

Next.js on Supabase for database and storage. Sessions hold their photos, a QR code per session and an email download link hand them to guests, and the download page needs no account.

Case study 05 Full stack, multi-tenant

Invitation Platform

Invitations sent as a static image cannot collect RSVPs or keep a guest list in one place.

Role: Full stack, multi-tenant
Stack: Next.js · Prisma · NextAuth · Radix UI · zod

Next.js with Prisma and NextAuth: themes per invitation, a guest list with RSVP, comments and an event schedule, with forms validated end to end by zod and React Hook Form.

Capabilities

Backend Systems

Node.js services with a clean controller and service split, REST and webhook integrations, and background workers that survive a restart.
- Node.js
- Express
- Workers
- REST APIs
Data & Databases

SQL-first modelling and query work across MySQL, Postgres and ClickHouse, from schema design through aggregation at volume.
- MySQL
- MariaDB
- PostgreSQL
- Prisma
- ClickHouse
Financial & Reconciliation

Money flows that have to balance: purchase and sales ledgers, cost history, and exports that tie back to the source system.
- Reconciliation
- Ledgers
- ERP Integration
- Reporting
Pipelines & Export

ELT into the warehouse, dbt marts, and the formatted outputs operations asks for: XLSX, CSV and PDF pipelines.
- dbt
- ClickHouse
- XLSX
- CSV
- PDF
Infrastructure & Delivery

Containers, object storage and CDN delivery, with the unglamorous parts handled: migrations, backups and repeatable deploy paths.
- Docker
- Cloudflare R2
- Vercel
- NAS and WebDAV
Product & Interfaces

Type-safe interfaces over the same data: Next.js applications, BI dashboards, and the admin screens an ops team actually uses.
- TypeScript
- Next.js
- Tailwind CSS
- BI Dashboards