Confidential Client Project

Confidential Client Project

A modernised order management and processing system built as a final year project in partnership with a confidential Singapore-based distribution client. The goal was to redesign and rebuild their ancient legacy system — improving usability, performance, and maintainability.

Note: Built under NDA. The client, system name and images have been omitted.

What it does

Core module:

• Secure login with session management across multiple devices
• Forgot password flow via one-time email links
• Granular, flexible permission and role management system — inspired by AWS IAM policy format, with no hardcoded roles
• Full user management — create, edit, deactivate users and assign roles
• Audit logging across the system

other modules:

• Manage products, batches, suppliers, and incoming shipments with full CRUD
• Track batch quantities with available, on-hold, and locked states
• Hold and release batch amounts with reasons
• Full activity history timeline for batches and shipments
• Search, filter, and paginate across all listings

Highlights

• Built an ultra-granular ACL (Access Control List) system using JSON-based policy statements, enabling complex nested logic and per-user permission overrides
• Adopted Scrum with 2-week sprints, regular client sprint reviews, and a pull request-based code review workflow
• Used Redis for fast transient data (sessions, password reset tokens) alongside MariaDB
• Deployed on a client-provided server via Docker and Docker Compose over VPN