Featured
Majid Constructions — Inventory & Invoicing Suite
Production SaaS dashboard for a construction & trading company in Oman
Majid Constructions needed to replace manual spreadsheets with a real-time system that finance staff and warehouse teams could both use safely. I designed the full data model in Prisma + MySQL, implemented three-tier RBAC (Super Admin, Admin, User) to gate sensitive financial records, and built server-rendered PDF generation for invoices and delivery orders. Stock costing uses a moving-average model with running ledger balances so discrepancies surface immediately. The client operates on this system daily; codebase is available on request under NDA.
Highlights
- Three-tier RBAC (Super Admin, Admin, User) securing financial and inventory records
- Full Prisma + MySQL data model covering invoices, DOs, purchase/issue tracking
- Server-rendered PDF generation for invoices and delivery reports
- Moving-average stock costing with real-time running ledger balances
- OMR currency handling with 5% VAT calculation throughout
- Codebase available on request (client NDA)
Tech stack
Gallery