Fransiscus
Agustinus

Software Builder · Custom Business Systems · Indonesian SMEs

I help Indonesian SMEs replace chaotic operations with custom software, built one-on-one and hands-on. The kind of business whose operations have outgrown spreadsheets but where a generic ERP feels too rigid for how the team actually works.

My work turns manual processes into structured ones: visible to managers, controllable through approval flows, and reliable enough to run a daily shift on. Two years of ops coordination ran in parallel with my CS studies, so when an owner explains a margin, stock, or late-payment problem, I don't need it translated. The hardest part is rarely the code. It's mapping the actual workflow honestly, then deciding what's worth automating and what isn't.

Recently, I've worked on:

  • Custom dashboards mapped to how the team actually works
  • Pricing and operational logic for retail/wholesale workflows
  • Secure multi-user systems with row-level access control
  • AI-assisted tools for content and internal operations

01 //

Experience

Software Builder (Freelance)

2025 — 2026

Dreame Indonesia

Architected a Next.js 16 and Supabase retail ERP. I directed AI coding agents to ship at solo-builder velocity. The system handles atomic PostgreSQL transactions to prevent race conditions. It also features dynamic channel pricing and strict Row Level Security (RLS) for data isolation.

Backend Developer Trainee

2024

Enigma Camp

Built backend services using Golang, Docker, and PostgreSQL.

Operations Coordinator

2020 — 2022

Game Consign / PT. Inovasi Dunia Gim

Led daily operations for a 6-person team. Engineered a markup pricing system that drove a 200% revenue increase.


02 //

Projects

Project_01

OMNICHANNEL RETAIL ERP

Client: INTERNAL RETAIL CLIENT

Problem:Marketing and supply chain teams were managing daily data entry and channel pricing across broken spreadsheets.
Solution:Built a custom dashboard using Next.js Server Actions and Supabase. I wrote atomic database RPCs to stop inventory race conditions. The system includes a fiscal calendar engine for reporting. Role-Based Access Control (RBAC) keeps staff and dealer data strictly isolated.
Result:Zero inventory mismatches across 1000+ SKUs and multiple stores. Reports in seconds. Full audit trail on every transaction.
Stack:
Next.js 16TypeScriptSupabasePostgreSQLTailwind CSS v4Zod
DEMO_01 · PRODUCT TOUR
DEMO_02 · AI COACH
DEMO_03 · ANTI-DUPLICATE
Project_02

RUANGKONTEN — AI CONTENT STRATEGIST

Client: PERSONAL SAAS PRODUCT · Status: In Development

Problem:Founders and creator-operators have to write the same topic in three account voices, schedule across time zones, avoid duplicate posts, and learn from what works. All manually.
Solution:A multi-tenant content workflow with AI that learns from every post. Funnel-aware generation (TOFU/MOFU/BOFU), anti-duplicate fingerprinting with a 60-day memory window, per-org Threads OAuth encrypted via Supabase Vault, and a Pro-tier coach trained on real customer data instead of generic advice.
Result:One topic generates three voice-tailored drafts in under 30 seconds. Lifecycle (DRAFT, SCHEDULED, READY, POSTED) is fully audited. The 60-day fingerprint window catches accidental reposts before they ship.
Stack:
Next.js 16TypeScriptSupabasePostgres 17Vault + RLSDrizzle ORMZodn8n9routerHyperFrames

03 //

Education

DEGREE

Bachelor of Computer Science

Gunadarma University

2018 - 2023

CERTIFICATION

Certified Developer Generative AI

Alibaba Cloud

2025

CERTIFICATION

Certified AI Marketing Strategist

VibeCoding.id

2026

BOOTCAMP

Golang Backend Bootcamp

Enigma Camp

2024


04 //

Stack

Frontend

Next.jsTypeScriptTailwind CSS

Backend & DB

PostgreSQLSupabaseGolang

Infrastructure

DockerGit

AI & Tooling

Agentic AI