Services : Full Stack Development
Custom Manufacturing ERP
Project Overview
A leading developer and manufacturer of advanced concrete materials faced significant challenges with outdated software. The software, developed over 25 years ago, was running on a Windows XP virtual machine, and lacked the necessary functionality to meet the manufacturer’s evolving operational needs. To bridge the gap, the manufacturer relied heavily on Microsoft Excel, resulting in cumbersome manual data entry and calculations by management.
After extensive research, the manufacturing organization opted to modernize their existing custom application over purchasing an off-the-shelf ERP.
Solution Overview
Mantrax partnered with the manufacturing client to modernize their systems and streamline operations. Key elements of the solution included:
Fresh UI Design
We introduced a user interface that balanced familiarity with modern design principles, simplifying the learning curve while enhancing robustness.
Database Redesign
The existing database was completely overhauled to meet industry standards, simplifying backend processes and incorporating essential missing features.
Core Functionality Enhancement
We refined and simplified core functions to reduce redundant user inputs, ensuring data integrity and improving overall efficiency.
Services Provided
Consulting and Discovery
Comprehensive in-person workshop to understand current state processes and design future state processes. The workshop resulted in a detailed functional specification outlining the scope of ERP modernization.
UI/UX Design
A user-centered design approach ensured a smooth transition to the new system. As part of agile development, wireframes for each module was designed and approved by client before starting development.
Solution Architecture and Development
Design of three-tier architecture: frontend, backend and database development. End-to-end module development, ensuring seamless integration and efficient data flow across all modules.
Quality Assurance
Rigorous testing processes included testing as part of agile sprints, and testing by the Client at regular intervals. A final User-Acceptance-Testing (UAT) at the client’s production facility was facilitated.
Project Management
We provided end-to-end project management, including 100% agile development cadence, ensuring transparency and timely delivery at every stage.
Data Migration
Static and transaction data migration from legacy application to new ERP.
Technology Stack
Front-end
Backend
Database
Cloud-Hosted
CI/CD
Solution: A modernized ERP system with integrated modules to streamline end-to-end production operations
Materials Management
- Raw, WIP, and Finished Goods inventory tracking
- Inventory valuation (FIFO, LIFO)
- Formula/Recipe creation and management
- Physical inventory tracking
- Material availability checks tied to production schedules
- Scrap and variance tracking
- Bill of Materials (BOM) management
Production Management
- Production Planning and Scheduling
- Work Order Creation and Routing
- Shop Floor Reporting and Process Conditions Tracking
- Supervisor Controls
Quality Control (QC)
- Test Templates Creation
- Incoming, in-process, and final inspection workflows and results
- Pass/Fail based on Standards per Product
Master Data Management
- Centralized item, customer, vendor, and BOM master data
- Data validation and governance rules
- Version control and audit trails
- Role-based access
- Duplicate detection and data normalization
- Cross-module data consistency enforcement
Reports and Analytics
- Role-based reports (operations, quality, finance)
- Real-time production and inventory tracking
- Custom and ad-hoc reporting
- Historical trend analysis
- Customer specific QC reports (i.e., Certificates of Analysis/Bill of Lading)
Other Functionality
- Equipment inventory and tracking
- Health and Safety Assessment Reports and Logs
- Maintenance Fuel Tracking
- Internal Memo Tool
- Customer and Supplier Profile Management
- Purchase Order Creation
- Lead Time and Shipment Profiles