Company Type
Collier & Associates practice-built, engagement-linked. Engagement linkage is the outcome source: Alstom, Volvo Penta (over $700K NVA in two weeks), Exterran, PBM ($2.8M / 18.9% OpEx), Investure (919 tasks, 234 flow units, 37 systems; $1.33M NVA), Macmillan/MPS (91,072 hours at ~97% accuracy).
What Drove the Need
A repeatable, budget-reconciled way to measure every role, process, task, and system in an operating model — and tie each to the P&L
Business Impact
Recoverable cost quantified at the task level across six core cases verified against source engagement documents (2005–2017): $2.8M in cost reductions identified — an 18.9% OpEx reduction (Case 5); $1.33M in NVA cost identified — 13.4% of modeled OpEx — across 919 tasks, 234 flow units, and 37 systems (Case 11); over $700K in NVA identified in two weeks (Case 20)
Systems/Data Integration
Design
Multidimensional data model across four dimensions and fifteen facets; every facet resolves to two denominators, hours and cost
Technology Stack
Oracle APEX / Oracle Database / PL/SQL (current); SQL Server/T-SQL and MS Access/VBA (lineage)
BAS™ Value Creation Solution
Stack lineage: MS Access/VBA → Access/VBA + SQL Server → Access front end on SQL Server/T-SQL → partial migration to Oracle APEX / Oracle Database / PL/SQL on cloud hosting, with a WSL2/Ubuntu Pro project underway to complete the migration and add functionality.
