Driving Forecasting Innovation with eCMS: How Onware Helped Miller Brothers Transform Their Financial Planning
Accurate forecasting is essential for construction organizations striving to maintain financial control, manage risk, and keep projects on track. For Miller Brothers Construction, this meant moving beyond a legacy desktop tool that no longer supported the speed, accuracy, or collaboration required in today’s data-driven environment. Their existing process relied heavily on manual data entry, disconnected spreadsheets, and time-consuming reconciliation efforts that made it difficult to respond quickly to changing project conditions.
To modernize their forecasting process, Miller Brothers partnered with Onware, a long-standing expert in eCMS data integration, analytics, and custom software development. Together, we built a modern forecasting platform that not only streamlined internal workflows but also unlocked new levels of visibility and confidence in project financials.
A Modern Forecasting Platform Built on eCMS Data
Miller Brothers needed a forecasting solution that could seamlessly connect to their eCMS Cloud Construction ERP, reflect real-time project performance, and support the complex cost structures inherent to heavy civil construction. Their teams required a tool that could handle detailed cost codes and the nuanced forecasting logic that evolves throughout a project’s lifecycle.
Onware delivered a custom web-based forecasting application designed specifically for these needs. The platform integrates directly with eCMS using secure SQL data pipelines and real-time APIs to pull cost, revenue, labor, and historical performance data into a unified forecasting environment. This ensures that every projection is grounded in accurate, up-to-date ERP information.
The new system allows project teams to:
- Drill into cost codes
- Update projections with intuitive, spreadsheet-like interactions
- Reconcile variances between actuals and forecasts
- Track trends across months, projects, and divisions
- Export data for executive reporting and audit purposes
By eliminating manual data manipulation and spreadsheet-based workflows, Miller Brothers reduced their monthly forecasting effort from 40 hours to just 4, while improving accuracy and consistency across the organization. The tool also supports multi-user access, enabling project managers, finance teams, and executives to collaborate more effectively.
Expertise in eCMS Data: A Key Differentiator
One of the most significant contributors to the project’s success was Onware’s deep familiarity with eCMS data structures, reporting logic, and integration patterns. Construction ERPs are complex, and eCMS is no exception—its job cost, payroll, equipment, and forecasting modules each have unique data relationships that must be understood to build reliable, high-performing integrations.
Onware’s team brought years of experience working with eCMS customers across North America, allowing them to:
- Navigate eCMS’s data model efficiently
- Identify the data sources for forecasting inputs
- Build performant queries that scale with large datasets
- Align the application’s logic with how users work with eCMS
This expertise shortened development timelines, reduced risk, and ensured the final product aligned with Miller Brothers’ operational reality. Instead of forcing teams to adapt to a generic forecasting tool, we built a solution that fit naturally into their existing workflows.
Beyond Reporting: Advanced Analytics and Custom Development
While many partners focus solely on software development or integrations, Onware combines data analytics expertise with full-stack custom software development. This dual capability allows us to build solutions that go far beyond dashboards—solutions that reshape how organizations plan, forecast, and operate.
For Miller Brothers, this meant developing a forecasting engine that:
- Applied business rules specific to heavy civil construction
- Supported multiple forecasting methodologies (e.g., percent complete, cost-to-complete, earned value)
- Provided dynamic filtering and drill-down capabilities
- Enabled scenario modeling for “what-if” analysis
- Integrated seamlessly with existing reporting tools
The platform also includes built-in auditability, allowing teams to track changes over time and understand how forecasts evolve month-to-month. This level of transparency is essential for financial governance and executive oversight.
Onware’s ability to blend analytics with custom application development is what enables us to deliver tools that are both insightful and operationally impactful. Instead of choosing between a rigid off-the-shelf product or a disconnected spreadsheet model, Miller Brothers now has a solution that is tailored, scalable, and deeply integrated with their ERP.
A Partnership Approach That Reduces Risk
Working with a third-party development partner can raise concerns about continuity, support, and long-term ownership. Onware addresses these risks through a team-based delivery model designed to ensure reliability and transparency.
Key elements of this approach include:
- Cross-trained developers who can step in if a team member becomes unavailable
- A dedicated project manager who oversees communication, timelines, and quality
- A responsive support team that ensures issues are resolved quickly
- Industry-standard technologies that make the solution maintainable by any qualified developer
- Full customer ownership of all source code, documentation, and intellectual property
Onware stores source code in secure, customer-accessible repositories, ensuring that clients retain full control of their technology investments. This eliminates the risk of vendor lock-in and provides peace of mind that the solution can be maintained or extended by internal teams or other partners in the future.
This commitment to transparency and continuity is a core part of Onware’s philosophy and a major reason why contractors trust them with mission-critical systems.
Strengthening the eCMS Ecosystem Together
The Miller Brothers forecasting project demonstrates what’s possible when Computer Guidance’s robust ERP platform is paired with a partner who understands how to unlock its full potential. eCMS provides the foundation—accurate job cost data, reliable financials, and a strong operational backbone. Onware builds on that foundation by creating tools that extend functionality, improve decision-making, and modernize workflows.
Across North America, Onware supports construction organizations in:
- Building custom applications that integrate with eCMS
- Developing advanced analytics and forecasting tools
- Creating data pipelines and reporting environments
- Enhancing operational efficiency through workflow automation
As construction firms continue to modernize their operations, Onware remains committed to helping them build data-driven cultures, streamline processes, and make smarter decisions powered by eCMS.
About the Author
Fraser Gallop is the CEO of Onware and a recognized leader in construction data analytics, business intelligence, and custom software development. With deep expertise in Tableau, Power BI, and complex construction ERP ecosystems—including eCMS—Fraser has spent his career helping the construction industry unlock the full value of their operational data. He is a Tableau Ambassador, a sought-after speaker, and an active mentor in the analytics community. Fraser is known for blending strategic vision with hands-on technical insight, guiding organizations toward scalable, data-driven decision-making. His work spans forecasting, workflow optimization, and enterprise reporting solutions used by hundreds of construction professionals across North America.
About Onware
Onware is a North American software development and data analytics firm with offices in both the United States and Canada. Founded in 2002, Onware began as a project management software provider and has since evolved into a trusted partner for construction organizations seeking to modernize their operations through custom applications, ERP integrations, and advanced analytics.
For more than two decades, Onware has specialized in custom web applications, forecasting tools, data pipelines, and business intelligence solutions that integrate seamlessly with construction ERPs like eCMS, as well as financial systems and field tools. Our team combines deep industry knowledge with modern development practices, ensuring every solution is scalable, maintainable, and fully owned by the customer. With a team-based delivery model, dedicated project management, and a commitment to transparency, Onware helps contractors build resilient, data-driven cultures and unlock the full potential of their operational data.
Scottsdale, Arizona—March 31, 2026—Computer Guidance Corporation, the leading developer of cloud-based ERP solutions for the construction industry, today announced that Computer Guidance’s eCMS v.4.2 ERP solution was selected as a 2026 Top Product by Constructech.