Metal Carports USA (CRM): Manufacturing & Installation Order Management Enterprise Back-Office

Project Overview & Business Context

To handle expanding nationwide steel building orders, Metal Carports USA required an enterprise internal CRM. The system coordinates the entire post-sale lifecycle: technical engineering reviews, manufacturer purchase orders, installation crew scheduling, balance collections, and warranty ticket management.

Engineering Architecture & Technical Execution

Architected an enterprise Laravel application featuring strict Role-Based Access Control (RBAC) across Sales Agents, Engineers, Dispatch Managers, and Executives. Connected to AWS RDS MySQL with automated read replicas and strict transaction isolation to prevent race conditions during scheduling.

Key Functional Modules Delivered

• Centralized customer order hub tracking orders from deposit payment to physical installation
• Automated manufacturer purchase order generation and steel delivery timeline tracking
• Interactive crew dispatch calendar with route clustering and geographical territory boundaries
• Integrated payment balance collections tracking milestone payments, refunds, and bank reconciliations
• Custom warranty claim and customer service ticketing system with automated SLA alerts

Measurable Business ROI & Outcomes

• Reduced order fulfillment processing overhead by 65% through automated workflow triggers
• Handled millions of dollars in monthly manufacturing orders without a single transaction error
• Enabled seamless multi-office collaboration between headquarters and remote installation crews