Enabling real-time decisions, improving efficiency, and unlocking Aimsio data’s full potential.
Terracon, a leading provider of geotechnical and materials engineering services, partnered with Pontem Innovations to modernize access to operational data, unifying exposure hours and revenue into a centralized intelligence system that improves forecasting, billing accuracy, and strategic planning.
The Challenge
High-volume data. Manual processes. Limited visibility.
Terracon’s growing operations generate substantial volumes of labor, project, and billing information across multiple systems. Much of this data existed in disconnected locations including Aimsio, Excel, and manual spreadsheets, creating significant challenges for timely analysis and cross-departmental visibility. As Dave Hanlon, a Controller at Terracon shared:
“We have a lot of data everywhere and don’t know what to do with it… we didn’t have the person in place to put everything together.”
The Solution
Pontem Innovations developed an integrated reporting system that consolidates Terracon’s Aimsio data into a single, accessible, and automated source of truth through Power BI. The Solution Included:
Automated Exposure Hours Reporting
Real-time breakdown of billable and non-billable hours
Live visibility into labor categories and utilization
Mid-month snapshots in seconds previously unavailable without manual recalculation
Accurate, timely insight for operational and financial planning
Project Revenue Report
A transformative tool offering immediate insight into revenue drivers, labor mix, project performance, and anticipated month-end outcomes, enabling weekly review and proactive issue resolution.
“You’ve supercharged our whole company in terms of using Aimsio for what it could be.”
A Strong Foundation for Aimsio-Driven Invoicing
With reporting streamlined and validated, Terracon is now preparing to shift toward automated invoicing directly from Aimsio reducing reliance on Excel and accelerating billing cycles.
The Impact
Visibility. Precision. Control.
Empowered Teams. Elevated Performance.
Aimsio-first adoption accelerated: The reporting foundation increased confidence and alignment across teams, enabling Terracon’s shift toward Aimsio-driven billing.
Stronger workforce planning: Centralized data supports proactive staffing decisions, use of transparency, and regional resource allocation.
Faster financial timelines: Improved data reliability allows earlier review cycles and more prompt financial statement delivery.
“Everyone’s buy-in to using Aimsio to bill out of it wouldn’t have happened without the tool you built.”
Supercharged Today. Scaling Tomorrow.
Terracon’s reporting transformation lays the groundwork for future growth. With the foundational Exposure Hours and Revenue Reporting Intelligence system in place, the organization is now exploring next steps:
Aimsio-first automated invoicing
Expanded forecasting capabilities
Enhanced PM dashboards for field operations
Internal capacity-building to create smaller reports independently
Additional reporting variations to support evolving operational needs
“We’re looking at the next two years of where we’re going to go with this… the whole company’s buy-in will be invaluable.”