Challenge
A leading construction company operated with fragmented data: financials, schedules, resources, and compliance lived across ERP systems and state-specific stores. Reporting cycles were slow and leadership lacked trustworthy cross-region comparisons.
Critical questions about budget alignment, labor productivity, and compliance exposure were hard to answer with confidence, which delayed decisions and hid efficiency opportunities.
Solution
We partnered with the client to design STTMS, a statewide technology and tracking management system that harmonizes multiple ERPs into one governed analytics layer.
Platform capabilities
Data mapping and harmonization
Normalized metrics across legacy systems to enable consistent comparisons for the first time.
Unified dashboards
Executive scorecards consolidate KPIs for cost per project, labor efficiency, and compliance adherence in near real time.
AI-driven analytics
Natural-language queries over operational data use retrieval-augmented generation for transparent answers.
Agentic workflows
Multi-agent pipelines perform data quality checks, reconcile cross-system mismatches, and surface anomalies automatically.
Cloud-native scale
Azure Data Factory, Snowflake, and Power BI provide secure, elastic analytics suitable for large project portfolios.
Tech at a glance
Azure Data FactorySQL ServerSnowflakeAPI and custom ETL connectorsGPT-4 with LangChainPower BIRole-based access and SOC 2-aligned governance
Delivery process
- 01Mapped and standardized metrics across ERP and state systems.
- 02Built ETL flows to unify cost, compliance, and resource signals.
- 03Delivered dashboards and natural-language search for executives.
- 04Integrated Medicare- and Medicaid-related cost recovery checks for government contracts.
- 05Established feedback loops from dashboard usage into continuous improvement.
Impact
- Month-end close and reporting cycles compressed from weeks to days.
- True cross-state and cross-project benchmarking on shared definitions.
- Leadership decisions anchored in current, reconciled metrics.
- Foundation for predictive analytics and deeper GenAI decision support.
STTMS reframes decision-making in a fragmented industry by combining harmonized data, governed metrics, and agentic quality workflows.