Ike Lim← All projects

Case Study

Social40

A full-stack ERP for an SAF unit - built solo from scratch as Software Lead.

Nov 2023 – Mar 2025

ARCHIVED
Next.jsTypeScriptTailwindCSSPythonSentry

The problem

Unit administration in the SAF ran on manual tracking - soldiers' activities, medical statuses, booking in and out - costing hours of repetitive work. As Software Lead, I built Social40 to streamline it.

The approach

A full-stack ERP engineered from scratch in Next.js, using server-side rendering to keep transactions between API route handlers and clients secure. Custom permissions and rules control exactly who can see and modify data, protecting personnel privacy.

An innovatively designed scanning system makes booking in and out fast and reliable. Python and CSV automation streamlined existing admin workflows, and I restructured logistical databases to significantly reduce data redundancy. The UI applies design principles from social-media apps so the experience feels familiar, with Sentry monitoring across client, server and edge.

The outcome

A working unit ERP combining personnel records, duty scheduling, attendance, approvals and analytics with an internal social layer - significantly reducing the manual labour of tracking and monitoring across the unit.

Unit dashboard combining personnel records, duty scheduling, attendance and approvals
Unit dashboard combining personnel records, duty scheduling, attendance and approvals
View more here →

Learnings

Owning a real system end to end - requirements, data model, permissions, UX and operations - and designing for non-technical users under real-world constraints.