Material Management Integration with ERP for Large Heavy/Civil Contractor with Trucking, Equipment, & Aggregate Manufacturing
February 2020 – July 2020
$500M to $1B (Annual Revenue)
Other Related Applications
• Various scale ticketing solutions
• CMiC in process of upgrade to R12 from V10
• HCSS HeavyBid
Management was frustrated with the inability for Project Managers (PM) to get real-time job cost information from their enterprise resource planning (ERP) system because of delays associated with material, equipment and trucking costs. There was a lot of spreadsheet and manual effort needed to get the data the company had available into the primary system. The ERP solution, though capable, was lacking in much of the necessary data. Processes were deemed inefficient for admin personnel.
Some of the key solutions in place were older/legacy solutions without good integration and/or data access. This presented considerable challenges for the client. Further, some of these systems were not previously integrated so data was very much siloed.
BCG did extensive process mapping and solution engineering to identify how all data needed for project and resource management moved through the organization and which systems were involved. Once this was known, BCG worked with IT to evaluate the back-end infrastructure and databases of the primary systems to determine the integration capabilities. This involved working directly with each of the solution developers like CMiC, Command Alkon and HCSS as well as some new vendors for trucking.
The client ended up with a data and integration roadmap that allowed their IT department to effectively develop the necessary integrations and reports once the optimal data flow was understood. This also gave the vendors the requirements to better implement their solutions within the client organization. They especially appreciated the added direction from BCG and acknowledge that this was not something they could have done individually.
“Burger Consulting confidently led our operations, material and accounting personnel through extensive workflow mapping which opened our eyes to the inefficiency of our current processes. With the process maps in hand and data architecture better understood, IT was able to set about integrating various solutions and building out middleware solution with adapters. Reporting was made much more timely and accurate within the ERP solution and BI.”.