Omega ERP — Enterprise Resource Operating System
High-availability multi-tenant ERP managing HR, procurement, asset tracking, and accounting for 150+ users
Demonstrates staff-level system architecture, robust transactional data modeling in PostgreSQL, enterprise security, and delivering commercial software that runs real businesses.
The Problem & Business Context
Growing enterprise businesses and institutional organizations were burdened by fragmented spreadsheets, disconnected payroll tools, manual paper procurement cycles, and lack of real-time financial auditing.
Constraints & Scale
Multi-organization tenant isolation, strict double-entry ledger integrity, dynamic multi-level approval workflows (Manager -> Director -> CFO), and reliable performance over low-bandwidth office connections.
Technical Architecture & System Design
Layered domain-driven design with TypeScript Node.js backend, Prisma ORM, PostgreSQL transactions with row-level locks for inventory operations, and React single-page application with optimistic UI updates.
Architectural Trade-Offs & RFC Decisions
Prevented financial drift by enforcing balanced debits and credits on every journal entry at the database constraint level.
Guaranteed total data segregation for enterprise clients with separate schema namespaces.
Security & Zero-Trust Architecture
Granular role-based access control (RBAC), cryptographically signed JWT sessions, audit logging for every mutation, and strict CSRF/CORS policies.
Verified Outcomes & Metrics
- Successfully deployed across enterprise clients supporting 150+ daily active users.
- Reduced month-end financial reconciliation time from 5 days to 2 hours.
- Eliminated inventory discrepancies and automated purchase order approval cycles.
Designing the transactional financial ledger with immutable audit tables from day one saved hundreds of engineering hours that would have been spent debugging state drift.