Rotana Store Platform
An enterprise Warehouse Management System (WMS) and Franchise Management ERP designed to run complex logistical networks.
Project Overview
Rotana Store Platform is an enterprise-grade digital ecosystem designed to streamline retail franchise operations, supplier accounting, and warehouse logistics. Prior to this platform, franchise inventory reporting was handled manually via spreadsheets and physical ledgers, leading to stock discrepancies, delayed supply chains, and reconciliation errors in supplier payouts.
The Business Problem
The management team faced three major hurdles: (1) real-time visibility of stock counts across multiple franchise outlets was non-existent; (2) tracking supplier invoices and B2B credit terms was manual and error-prone; and (3) staff operation logs lacked security parameters, leading to inventory leakage.
Warehouse-First Architecture & Ledger Schema
To solve these issues, we designed a centralized system featuring a three-tier relational database structure and secure API endpoints:
Real-time Inventory Synchronization
Designed a PostgreSQL event-trigger pipeline that automatically updates master stock registers when a franchise reports a transaction.
B2B Credit Ledger System
Built a transactional credit framework allowing franchises to request inventory on credit terms with automated caps and penalty logs.
Secure Role-Based Access Control (RBAC)
Implemented JWT authentication with strict authorization profiles (Admin, Warehouse Manager, Franchise Manager, Supplier).
Delivery Route Logistics
Configured a dispatch module that aggregates franchise orders and calculates optimal distribution routes for delivery trucks.
Technology Stack Used
Challenges Solved
- !Mitigating concurrency conflicts when multiple franchise outlets concurrently attempted to claim matching warehouse batches.
- !Designing a secure transaction rollback structure to protect data integrity during network failures in the middle of a ledger check.
Project Results
- Achieved 100% real-time inventory visibility across all franchise outlets.
- Reduced warehouse order processing times by 45% within the first month of deployment.
- Eliminated 90% of manual credit reconciliation errors, saving substantial accounting overhead.
- Established strict audit trails for all inventory changes, reducing stock leakages to absolute zero.
Future Roadmap
Integrating predictive AI models to forecast seasonal franchise inventory demands.
Building a custom mobile application for delivery drivers to track logs offline.