Photo by CDC on UnsplashOverview
Mendoza Brothers Holdings needed to replace a patchwork of spreadsheets and email chains with a centralised, secure web platform for managing their medical supply chain. The system needed to support multiple user roles, handle bulk product data efficiently, and give management real-time visibility over orders and staff activity. I designed and built the entire platform from scratch — database schema, REST API, React UI, and deployment infrastructure.
Key Features
JWT + Role-Based Access
Multi-tier authentication with granular permissions. Admins, managers, and staff each see a different interface with appropriately restricted data access.
Bulk Excel Import
Drag-and-drop spreadsheet uploads processed asynchronously in chunks. Row-level validation catches errors before they reach the database, with a real-time progress bar.
Real-Time Chat
Socket.io powered messaging tied directly to orders and supplier threads. Reduced issue resolution time by 35% by replacing disconnected email chains.
Order Lifecycle Tracking
End-to-end order management with status transitions, audit logs, and automated notifications at each stage of the supply chain.
Admin Reporting Dashboard
Comprehensive analytics panel giving management a live view of stock levels, order volumes, staff activity, and supplier performance.
Async Processing
Heavy operations like bulk imports and report generation run asynchronously, keeping the UI responsive and avoiding server timeouts.
The Challenge
The hardest part was designing a RBAC system flexible enough to accommodate evolving business rules without requiring code changes. I built a centralised permission config object — a single source of truth — so access rules could be adjusted by editing one file rather than hunting across dozens of route handlers.
Outcome
60% reduction in admin workload through bulk automation. 35% faster issue resolution via real-time chat. Zero security incidents across the full deployment period. CEO review: 5 stars.
Interested in working together?
I build projects like this for clients across Australia and globally. Get in touch to discuss your idea.