ConstructionStaff Augmentation
Enterprise Construction Cost Estimation & Carbon Analytics Platform
Centralized permissions architecture across BES and Carbon Tool, built cost curve governance, and improved carbon analytics data integrity for Benchmark's enterprise construction cost estimation and sustainability platform.
Company Context
An enterprise platform used by infrastructure and construction organizations for BOQ-based cost estimation, benchmarking analysis, and carbon impact reporting. Supports large-scale projects where cost accuracy and sustainability compliance are both critical deliverables.
Engineering Environment
.NETSQL ServerCarbon AnalyticsEnterprise PermissionsCost EstimationSustainability
What Our Scale Partnership Revealed
- Permissions were maintained separately in BES and the Carbon Tool — two different codebases, two different role definitions, no synchronization. Users could have different access levels in each module with no unified governance view.
- Cost curve access had no role-based control — any user could apply any cost curve to any estimation regardless of authorization.
- Carbon analytics data was duplicating across modules with no detection or reconciliation logic — sustainability reports were potentially counting carbon impact multiple times.
- Legacy MAX-based primary key generation was a concurrency problem — in a multi-user environment with concurrent submissions, MAX(id)+1 produces collisions under load.
- 22+ tightly coupled legacy functions across the permissions layer made any change high-risk.
Engineering Work
- Migrated Carbon Tool permissions into the centralized BES role management system — one permissions model, one place to manage it.
- Refactored the 22+ tightly coupled legacy permission functions into clean, independently maintainable modules.
- Implemented role-based cost curve visibility and application controls.
- Built carbon duplication detection with visual indicators in the UI.
- Enhanced carbon recalculation logic to maintain consistency across BES, reporting, and backend APIs.
- Replaced MAX-based primary key generation with a proper sequence-based approach — eliminating the concurrency collision risk.
System Outcome
- Unified permissions architecture — one role definition governs access across both BES and Carbon Tool.
- Cost curve governance implemented — access controlled by role, estimation workflows protected.
- Carbon analytics accuracy improved — duplication detected and flagged before it corrupts sustainability reports.
- Database concurrency risk eliminated — primary key generation is collision-safe under multi-user load.