Case Study: Enhancing “Last Mile” Delivery with Integrated QA Strategy for Construction Resources

Transforming QA and Testing with Automation

The Challenge

The Challenge: Modernizing the “Last Mile” Across Multiple ERP Systems

Construction Resources (CR), a leading provider of specialty building materials, operates using several ERP systems, including Syspro, Stone Profit Systems (SPS), and FloorManager. One of their most critical yet complex processes, known as “The Last Mile,” encompasses the final steps of delivering materials or services to the customer.

Before engaging CelticQA, the Last Mile was a manual, paper-based process that significantly limited scalability, transparency, and customer satisfaction. CR needed a streamlined, automated solution that integrated with all ERP systems to empower drivers and installers through a unified mobile app (DispatchTrack) while enabling managers and administrators to operate via a centralized web platform.

With a cross-functional internal team in place—product manager, scrum master, BAs, developers, and testers—CR sought a QA partner who could bring consistency, structure, and speed to their digital transformation roadmap.

The Engagement

Multi-ERP Integration and Automation Strategy

CelticQA partnered with CR to support the quality assurance of the DispatchTrack integration with:

Key responsibilities included:

Integration Testing: Validating seamless data flow between DispatchTrack and each ERP system.
Requirements Support: For FloorManager, CelticQA assisted with automating report generation to streamline field mapping for business analysts.
Test Case Development: Designing robust manual and automated test cases for both functional and regression testing.

The Results

Quality at Speed, Measurable ROI

1,000+ Test Cases Created
CelticQA developed over a thousand comprehensive test cases across three ERP systems to support functional and integration testing efforts.
220+ Defects Identified Early
The structured testing process enabled early detection of more than 220 defects, minimizing risk and reducing defect leakage into production.
2-Week Agile Cadence
CelticQA aligned seamlessly with CR’s agile methodology, conducting integration and regression testing within each two-week sprint and ahead of each production release.
End-to-End Automation for Syspro
In the initial automation phase, 150 end-to-end test cases were developed for Syspro, covering the full flow:
• Sales order creation
• Syncing with DispatchTrack
• Order processing on mobile
• Image/data updates back to Syspro

This initiative freed up the internal team to focus on higher-priority business objectives while laying the foundation for automation across additional ERP systems.

Strategic Impact

Risk Reduction, Agile Enablement, and Process Optimization

CelticQA’s risk-based testing approach played a pivotal role in preventing critical defects from reaching production. Through close collaboration with the product owner and technical leads, our team focused QA efforts on high-risk areas aligned with sprint goals and business priorities.

In addition to rigorous testing, CelticQA:

Conclusion

A QA Partnership That Delivers Lasting Value

Construction Resources’ Last Mile transformation is a testament to the power of strategic QA partnerships. By integrating tightly with internal teams, adapting to agile workflows, and driving automation forward, CelticQA has become a trusted quality partner in CR’s mission to elevate customer experience and operational efficiency

Passion is what drives us

High performing teams who are fully engaged & committed to delivering success

Let's discuss your Software Functional Testing Needs

Schedule A Call

Name

Company Name

Location

Phone Number

How can we help you?

By using this form, you agree with the storing and using of your personal information to get back in touch with you