Enterprise PMO, Timesheet & Billing Automation (-80% Manual Effort)
Replacing error-prone spreadsheet reconciliations with an automated C#/.NET, Blazor, and SQL Server platform governing timesheets, project budgets, multi-rate billing, and executive profitability reporting.
Engineering Context & Operational Pain
Month-end billing and PMO margin tracking relied on stitching together dozens of spreadsheets, manual rate-card lookups, multi-currency rules, and email approvals — consuming days of finance and delivery-lead time every cycle.
Leadership lacked real-time visibility into budget burn until weeks after work had already been delivered.
System Architecture & Technical Decisions
Temporal Rate-Card & Contract Rules Engine (.NET)
Modeled effective-dated rate cards, overtime/holiday rules, cap thresholds, and multi-currency billing contracts in C#/.NET with deterministic unit-tested calculation pipelines.
Multi-Stage Approval & Reconciliation Workflows
Built Blazor workflows for consultant time entry, delivery-manager sign-off, and finance invoice generation with immutable period-lock controls.
SQL Server Analytical Views & Executive Dashboards
Designed indexed relational schemas and fast aggregation queries surfacing live utilization, gross margin, and forecast variance per client and practice.
Financial Controls & Audit Readiness
- Strict separation of duties: consultants, project managers, and finance controllers see only authorized rate and margin data.
- Period-close locking with full delta audit trails for any post-close credit note or adjustment.
- Automated CI/CD deployment and database migration validation via Azure DevOps.
Measured Production Impact
- Eliminated ~80% of manual monthly PMO and billing reconciliation effort.
- Accelerated month-end invoicing cycles while removing manual rate-card calculation errors.
- Gave executive leadership live visibility into project profitability and resource capacity.