Aldo Purnama

Systems for businesses that never sleep.

An ice factory and a machinery import company in East Java, both running on software I build and ship myself.

Factory operations platform · internal system

Java Ice Webapp

Java Ice Cristal is a real ice factory and depot distribution business in Mojokerto. This webapp replaced its paper logbooks and fragile spreadsheets with one integrated system covering the whole daily cycle: production, freezer stock, depot loading and unloading, delivery routes, sales, cash (kas), receivables (piutang) with integrated settlement, and repack with photo evidence.

It runs on Google Apps Script and Google Sheets. The business owns 100% of its data in its own Google account and pays no monthly SaaS fees.

Placeholder poster for the Java Ice webapp walkthrough recording
Internal, PIN-protected system. Previews are redacted screen recordings, not a live link.
Automated tests
188+
Integrated modules
15+
Major versions shipped
9
Monthly software cost
Rp 0
  • Production & stock
  • Route & delivery
  • Piutang + pelunasan in one flow
  • KAS cash management
  • Repack with Drive photo evidence
  • WhatsApp receipt links
  • Per-employee PIN login
  • GPS-geofenced selfie absensi
  • Versioned deploys, SHA-256 manifests

Attendance that can't be faked politely

GPS geofence plus a live selfie clock-in. Multi-site by config: adding a site means adding a row, not writing code. Fraud gets flagged for review instead of hard-blocked, and the whole thing is a reusable module for other businesses.

Customers order ice over WhatsApp

A Node.js bot on a WhatsApp number: automatic customer registration, a self-learning delivery coverage zone, an order queue posted to the staff group, and a transfer-payment flow. No app install, because the customer already has WhatsApp.

Trading operations system · internal

Wellmatic App

Placeholder poster for the Wellmatic order and cash flow recording
Also internal. Previews are redacted recordings of the order and kas flows.

PT Wellmatic Machinery Indo imports industrial machinery and spare parts from China for Indonesian manufacturers. This system runs the commercial pipeline end to end: tender and offer tracking, RFQ, orders, proforma invoice generation, surat jalan, invoicing with Faktur and Non-PPN handling, price history, cash tracking, and automatic Drive folder organization per deal.

Behind it, one master spreadsheet consolidates AR/AP, P&L and cash flow, so a bilingual trading operation works from a single source of truth instead of scattered files.

  • One pipeline. Tender to PO to PI to invoice, nothing retyped in between.
  • Three languages. English, Indonesian and 中文 in the same workflow.
  • One source of truth. AR/AP, P&L and cash consolidated in a master sheet.
  • Tender & offer tracking
  • RFQ to order flow
  • Auto PI generation
  • Surat jalan
  • Faktur vs Non-PPN logic
  • Price history
  • Kas module
  • Auto Drive folder naming
  • AR/AP + P&L consolidation

Custom systems, built to fit

Placeholder poster for the Java Ice public website scroll-through

Local marketing · SEO

Java Ice Website

The public face of the ice factory, built static-first for speed and indexability while the Apps Script app stays private behind it. Optimized for local search in Mojokerto and WhatsApp-first conversion.

  • WhatsApp click-to-chat as the primary CTA
  • Local SEO aligned with the Google Business Profile
  • Static HTML front, private app behind
  • LocalBusiness & Product structured data for search and AI
Visit javaice.wellmatic.co.id

Dental clinic · website concepts

Kanari Dental, one clinic, two directions

Two website drafts built for the same dental clinic, showing design range: the reassuring option and the ambitious one.

Placeholder poster for the Kanari Aurora concept scroll-through

Kanari · Aurora

A calm, premium face for a dental clinic.

  • Clean, patient-friendly visual system
  • Booking and contact oriented layout
  • Mobile-first
  • The safe premium option
View the draft
Placeholder poster for the Kanari 3D concept interaction clip

Kanari · 3D

The same clinic, with custom interactive 3D built into the page.

  • Custom interactive 3D element in-page
  • Performance-conscious, still loads on mobile
  • Distinctive against template clinic sites
  • The capability showcase
View the draft
Placeholder poster for the Meomory photobooth preview clip

Cafe tech · Photobooth

Meomory Photobooth

Meomory turns a cafe's receipt printer into a photobooth: guests snap a photo and take it home printed on their receipt, giving the cafe a keepsake customers post and share.

  • Photo to printed receipt in one flow
  • Built to support cafe businesses
  • A shareable keepsake with every visit

How I build

Tested like software, because it is

188+ automated tests on the ice-factory system, and every deploy versioned with SHA-256 manifests. If it breaks at 5 AM, that's my morning too.

Your data stays yours

Systems live in the client's own Google account: Sheets, Drive, Apps Script. No vendor lock-in, no per-seat fees, no exporting your business from someone else's cloud.

WhatsApp-native

Built for how Indonesian businesses actually communicate. Receipts, ordering bots and every call to action flow through WhatsApp, not a contact form nobody opens.

Operator-built

I run the businesses these systems power, so I build for the person doing bongkar before sunrise, not for a demo screen.

About

Aldo Purnama runs two businesses in Mojokerto, East Java: PT Wellmatic Machinery Indo, importing and trading industrial machinery sourced from China, and Java Ice Cristal, an ice manufacturing and depot distribution operation. He builds the software both run on.

Stack of choice: Google Apps Script with Sheets, Node.js and Python, shipped fast under heavy test discipline. Working comfortably across English, Indonesian and Mandarin supplier communication. Aldo Purnama on LinkedIn

Have an operation that's still running on spreadsheets?

Work with me