Louis Lai | Systems Portfolio

Approach

Build internal systems your team can run day to day.

I help enterprises and chain headquarters turn ERP/POS and back-office workflows into web systems. We map roles, data, and handoff first, then build and launch in phases.

Services

What I do

ERP / POS consulting

Map store and headquarters operations, data flows, permissions, and reporting needs.

Internal admin platforms

Bring forms, approvals, search, and printing into one admin platform.

SQL reporting and performance

Find slow queries, tune SQL and indexes, and make reports run reliably.

Process digitization

Replace paper, Excel, and LINE workflows with one shared system.

Next.js / Supabase development

Build internal systems with frontend, backend, database, and access control.

Permissions and audit design

Define access, change history, and audit trails before issues appear.

Process

How we work together

01

Understand the current state

Go on-site, observe the workflow, and identify the slowest manual step.

02

Map flows and specs

Turn data structures, permissions, and screens into build-ready specs.

03

Build in phases, iterate

Build in phases and validate each release with real users.

04

Hand off for self-maintenance

Document operations so your team can maintain the system after launch.

Projects

Featured work

Operations platformHigh-concurrency booking

Food Truck Slot Booking System

Vendors competed for limited slots through messaging apps, making capacity, order, and billing hard to verify.

Vendors register themselves; ops no longer confirms each entry manually.

Booking capacity stays locked to session limits.

Registration, allocation, and fee records are all searchable in admin.

View project
Chain store management systemMulti-store management

Pet Prescription System

Prescriptions were scattered across paper and spreadsheets—print formats varied and permissions were hard to manage.

44 stores file, search, and print in one system.

Each store can access only its own records.

Stores can print immediately after veterinarian approval.

View project

Need to turn a manual process into a system?

No full spec needed upfront. We can start with the process causing the most friction today.