Bogor GMT+7

Consultation

DESIGN · SYSTEMS · AI

Digitalization that actually gets used.

We design websites, systems, and AI for businesses and institutions in Indonesia, with design your team understands and engineering you can rely on.

Free consultation See our work

Illustration · sample data

Our approach

A good system doesn’t add work; it removes work that never needed to exist. We start by understanding your workflow, build in phases, and hand over a system you can run yourself.

  1. 01 · Design

    Understood without long training

    Interfaces designed around how your team works, so the system actually gets used.

  2. 02 · Systems

    Tidy, secure, and ready for messy data

    One source of data, role-based access, and a change history you can trace.

  3. 03 · AI

    AI that helps, not replaces

    Assistants that summarize, check, and answer, with decisions staying in human hands.

Featured solutions

  1. 01

    New student admissions with an AI assistant

    Initial interviews with prospective parents at any hour, summarized for the admissions team.

    See details →
  2. 02

    Online store for small businesses

    Start selling online, manage it from your phone, with support until it runs smoothly.

    See details →
  3. 03

    Websites and landing pages

    Fast, tidy websites you can manage yourself.

    See details →
See all services →

HAILMARY LAB

How we solve hard technical problems

One data source for many roles
Databasesingle source

Selected role access

  • Customer dataEdit
  • OrdersEdit
  • Products & stockEdit
  • Financial reportsEdit
  • System settingsEdit
  • Customer dataEdit
  • OrdersEdit
  • Products & stockEdit
  • Financial reportsView
  • System settings—
  • Customer dataOwn only
  • OrdersOwn only
  • Products & stockView
  • Financial reports—
  • System settings—

Audit log

  1. Staff A changed price of product #118
  2. Admin added the "Warehouse" role
  3. Customer B downloaded invoice INV-2031
  4. Staff B exported the stock report
  5. Admin revoked access for Staff C

Hailmary Lab

One data source for many roles

  1. Problem

    Systems with several roles (admins, staff, customers) easily end up with duplicate data and leaky permissions.

  2. Approach

    A single central data model with role-based access control (RBAC) and an audit trail for every change.

  3. Outcome

    Every role is served from one source of truth without duplication, and every change is traceable.

  • RBAC
  • Audit log
  • PostgreSQL
Migrating data from spreadsheets
customers.xlsx12,480 rows
#NameEmailPhoneCity
1Customer ACustomer Aa@contoh.ida@contoh.id0812 0000 010812 0000 01JakartaJakarta
2Customer BCustomer Bb@contohb@contoh.id812-0000-020812 0000 02bandungBandung
3Customer CCustomer Cc@contoh.idc@contoh.id0812 0000 030812 0000 03SurabayaSurabaya
4Customer ACustomer Aa@contoh.ida@contoh.id0812 0000 010812 0000 01JakartaJakarta
5Customer DCustomer Dd@contoh,idd@contoh.id0812 0000 040812 0000 04MedanMedan
6Customer ECustomer Ee@contoh.ide@contoh.id0812 00000812 0000 05SemarangSemarang

Email format

Phone format

Merge duplicates

Valid12,237
Needs review169
Duplicates74

Hailmary Lab

Migrating data from spreadsheets

  1. Problem

    Legacy data is inconsistent: mixed formats, duplicates, and columns that don’t line up.

  2. Approach

    Validation and cleaning scripts plus an exceptions report that a person reviews before anything is imported.

  3. Outcome

    A repeatable, auditable migration flow that never overwrites data that is already correct.

  • ETL
  • Data validation
  • Reporting
Automatic payment reconciliation

1.271 matched2 mismatch

ReferenceBankSystem
INV-2031Transfer Rp 1.250.000 Rp 1.250.000 Matched
INV-2032QRIS Rp 840.000 Rp 840.000 Matched
INV-2033Card Rp 2.100.000 Rp 2.150.000 Resolved
INV-2034Transfer Rp 560.000 Rp 560.000 Matched
INV-2035Transfer Rp 925.000 Rp 975.000 Resolved

Hailmary Lab

Automatic payment reconciliation

  1. Problem

    Matching QRIS and virtual account payments by hand is slow and error-prone.

  2. Approach

    Payments from the gateway are recorded automatically, and invoice status updates without manual entry.

  3. Outcome

    Payments are recorded automatically and never duplicated, even when a notification arrives twice or late.

  • Payment gateway
  • Auto-recording
  • No duplicates

Internal prototypes we built to test technical approaches before using them on client projects. See all work → · Hailmary Terminal ↗

How we work

About the studio
  1. 01

    Discovery

    We map your workflows, user needs, and existing systems through interviews and data audits. The result: an agreed list of problems and priorities.

  2. 02

    System design

    We define scope, architecture, data structure, and interface prototypes for your approval before development begins.

  3. 03

    Execution & testing

    Built in short sprints with regular demos, testing, and security review, so progress is visible at every stage.

  4. 04

    Handover & support

    Launch, data migration, team training, documentation, and hands-on support until the system runs stably.