Construction ERP

The problem

Construction firm operating across multiple sites had fragmented spreadsheet workflows that obscured project profitability.

Architecture

Modular MVC architecture with clear module boundaries: tendering, estimation, materials, resources, budgeting, reporting. Shared authentication and reporting layer.

Key decisions

Razor Pages for internal admin screens (fast to build) and MVC for the more complex tendering workflows. Heavy use of stored procedures for reporting.

Outcomes

• Replaced spreadsheet-based workflows across multiple project sites, with consolidated reporting visible to leadership.

What I would do differently now

I would push more of the reporting into a read-side projection rather than running heavy SQL on the operational database.