Resource-Loaded Work Breakdown Structure
This is the resource-loaded view of the program's Work Breakdown Structure: every work package carries its named effort and cost, and every hour traces to a named person on the Resource Plan. It is the artifact that connects the three baselines the Charter authorizes — scope, schedule and cost — into a single reconciled model.
| WBS line items | 315 |
| Work packages (loaded) | 250 |
| Named resources | 55 (10 part-time) |
| Assignments | 256 |
| Total effort | 56,950 hours |
| Total labor cost | $7,369,050 |
1. How this WBS is loaded
Each work package names one accountable owner — a single point of accountability — plus any named contributors who do the work alongside them. That distinction matters: a WBS that lists three names against a package without saying who is answerable for it has recorded staffing, not accountability.
The loading is allocation-aware. Each person's hours come from their Resource Plan line, which already reflects whether they are full-time or part-time on this program — 10 of the 55 are part-time. Their hours are then distributed across the packages they work on in proportion to package duration, so a part-time analyst is never implicitly loaded as though they were full-time. This is the difference between a resource-loaded WBS and a resource-named one: naming a person against a task costs nothing, but loading them commits capacity that has to exist.
2. Effort & cost by phase
| WBS | Phase | Packages | Effort (h) | Labor cost | % of total |
|---|---|---|---|---|---|
| 1 | Initiation & Requirements | 51 | 10,009 | $1,512,315 | 20.5% |
| 2 | System Upgrade | 18 | 2,690 | $391,215 | 5.3% |
| 3 | Data Conversion | 41 | 3,349 | $462,570 | 6.3% |
| 4 | Integration Build (Agile) | 45 | 16,212 | $2,094,060 | 28.4% |
| 5 | Testing (Functional, System, UAT) | 35 | 13,664 | $1,407,915 | 19.1% |
| 6 | Cutover & Hypercare | 26 | 3,740 | $591,335 | 8.0% |
| 7 | Change Management & Training | 24 | 4,517 | $564,590 | 7.7% |
| 8 | Program Governance & Risk Management | 10 | 2,769 | $345,050 | 4.7% |
| — | Program total | 250 | 56,950 | $7,369,050 | 100.0% |
3. Reconciliation to the cost baseline
| Check | Value | Result |
|---|---|---|
| Sum of all assignment hours | 56,950 h | = Resource Plan total (56,950 h) ✓ |
| Sum of (hours × blended rate) | $7,369,050 | = labor baseline in the Program Budget ✓ |
| Per-resource distributed effort | 55 of 55 | each equals that person's Resource Plan hours exactly ✓ |
| Phase rollup | 8 phases | sums to the program total in both hours and cost ✓ |
These are not stated totals — they are assertions the generator evaluates, and it refuses to emit this page if any of them fails. The labor baseline reconciled here is the same $7,369,050 that appears as the labor subtotal in the Charter's authorized budget.
4. Resource loading by person
Each person's committed hours, blended rate and resulting cost, with the number of work packages they are loaded against. Sorted by cost.
| Resource | Role | Allocation | Rate | Hours | Cost | Packages |
|---|---|---|---|---|---|---|
| C. Tyrrell | Program Manager | Full-Time | $175/hr | 2,383 | $417,025 | 21 |
| J. Albert | Solution Architect | Full-Time | $165/hr | 1,600 | $264,000 | 4 |
| R. Whitfield | QA / Test Lead (Onshore) | Full-Time | $125/hr | 1,800 | $225,000 | 4 |
| L. Bergström | Change Manager (OCM Lead) | Full-Time | $145/hr | 1,536 | $222,720 | 5 |
| T. McCormick | Data Conversion Lead | Full-Time | $150/hr | 1,360 | $204,000 | 13 |
| K. Larsson | Data Architect | Full-Time | $160/hr | 1,200 | $192,000 | 4 |
| M. Castillo | Integration Architect | Full-Time | $160/hr | 1,200 | $192,000 | 3 |
| T. Halvorsen | Cloud Infrastructure Engineer | Full-Time | $145/hr | 1,100 | $159,500 | 4 |
| F. Jones | Lead Business Analyst | Full-Time | $140/hr | 1,120 | $156,800 | 7 |
| D. Okafor | Developer — Billing Integration | Full-Time | $130/hr | 1,200 | $156,000 | 3 |
| S. Lindqvist | Developer — Underwriting Integration | Full-Time | $130/hr | 1,200 | $156,000 | 2 |
| K. Delgado | Developer — Claims Administration Integration | Full-Time | $130/hr | 1,200 | $156,000 | 2 |
| S. Okwuosa | Security Engineer | Full-Time | $155/hr | 1,000 | $155,000 | 6 |
| D. Fontenot | DevOps Engineer | Full-Time | $140/hr | 1,100 | $154,000 | 4 |
| R. Fontaine | Developer — Billing Integration | Full-Time | $130/hr | 1,150 | $149,500 | 4 |
| K. Andersson | Developer — Underwriting Integration | Full-Time | $130/hr | 1,150 | $149,500 | 3 |
| M. Osborn | Developer — Claims Administration Integration | Full-Time | $130/hr | 1,150 | $149,500 | 3 |
| M. Ferraro | Business Analyst — Underwriting/Billing | Full-Time | $135/hr | 1,100 | $148,500 | 2 |
| T. Whitaker | Business Analyst — Claims/Commission | Full-Time | $135/hr | 1,100 | $148,500 | 2 |
| P. Novak | Developer — Commission Management Integration | Full-Time | $130/hr | 1,104 | $143,520 | 3 |
| A. Reyes | Developer — Data Warehouse/Reporting Integration | Full-Time | $130/hr | 1,104 | $143,520 | 3 |
| B. Sato | Developer — Payment Processing Integration | Full-Time | $130/hr | 1,104 | $143,520 | 3 |
| R. Sandoval | ETL Developer (Data Conversion) | Full-Time | $130/hr | 1,100 | $143,000 | 15 |
| T. Bergman | ETL Developer (Data Conversion) | Full-Time | $130/hr | 1,100 | $143,000 | 14 |
| A. Ferreira | QA Automation Engineer (Onshore) | Full-Time | $115/hr | 1,200 | $138,000 | 4 |
| D. Kowalczyk | QA Automation Engineer (Onshore) | Full-Time | $115/hr | 1,200 | $138,000 | 4 |
| T. Ibekwe | Developer — Commission Management Integration | Full-Time | $130/hr | 1,050 | $136,500 | 4 |
| L. Castellano | Developer — Data Warehouse/Reporting Integration | Full-Time | $130/hr | 1,050 | $136,500 | 4 |
| J. Whitmore | Developer — Payment Processing Integration | Full-Time | $130/hr | 1,050 | $136,500 | 4 |
| H. Osei | Training Lead | Full-Time | $110/hr | 1,210 | $133,100 | 7 |
| A. Winters | DevOps Engineer | Full-Time | $140/hr | 950 | $133,000 | 4 |
| M. Alvarez | System Upgrade Lead / Platform Engineer | Full-Time | $155/hr | 835 | $129,425 | 14 |
| R. Okonkwo | Business Analyst — Data Warehouse/Payment | Full-Time | $135/hr | 950 | $128,250 | 2 |
| D. Abernathy | Change Champion Network Lead | Full-Time | $130/hr | 900 | $117,000 | 3 |
| E. Solis | QA Automation Engineer (Onshore) | Full-Time | $115/hr | 1,000 | $115,000 | 3 |
| C. Marchetti | Developer — Billing Integration | Full-Time | $125/hr | 900 | $112,500 | 3 |
| P. Nakamura | Developer — Underwriting Integration | Full-Time | $125/hr | 900 | $112,500 | 2 |
| R. Solheim | Developer — Claims Administration Integration | Full-Time | $125/hr | 900 | $112,500 | 2 |
| N. Sharma | Compliance / Legal Representative | Part-Time | $180/hr | 624 | $112,320 | 5 |
| C. Solberg | PMO Scheduler | Full-Time | $110/hr | 900 | $99,000 | 4 |
| K. Ibrahim | Compliance / Audit Analyst | Full-Time | $140/hr | 700 | $98,000 | 4 |
| P. Andressen | Governance Analyst | Full-Time | $120/hr | 800 | $96,000 | 3 |
| P. Sundaram | Offshore QA Coordination Lead | Full-Time | $65/hr | 1,400 | $91,000 | 1 |
| M. Sorensen | Regional Trainer | Part-Time | $105/hr | 850 | $89,250 | 7 |
| W. Donnelly | Vendor / Procurement Manager | Part-Time | $145/hr | 600 | $87,000 | 19 |
| V. Rao | QA Manual Tester (Offshore) | Full-Time | $60/hr | 1,400 | $84,000 | 1 |
| S. Banerjee | QA Manual Tester (Offshore) | Full-Time | $60/hr | 1,400 | $84,000 | 1 |
| G. Fenwick | Internal Audit / SOX Compliance Lead | Part-Time | $150/hr | 480 | $72,000 | 2 |
| N. Fernandes | QA Manual Tester (Offshore) | Full-Time | $60/hr | 1,200 | $72,000 | 1 |
| E. Kowalski | PMO / Governance Analyst | Part-Time | $135/hr | 520 | $70,200 | 3 |
| M. Yamamoto | Underwriting SME (UAT) | Part-Time | $150/hr | 400 | $60,000 | 2 |
| D. Kessler | Claims SME (UAT) | Part-Time | $150/hr | 400 | $60,000 | 2 |
| R. Antonelli | Billing SME (UAT) | Part-Time | $150/hr | 350 | $52,500 | 2 |
| J. Restrepo | Commission SME (UAT) | Part-Time | $150/hr | 350 | $52,500 | 1 |
| V. Alaoui | Customer Experience Manager | Part-Time | $120/hr | 320 | $38,400 | 4 |
| Total — 55 resources | 56,950 | $7,369,050 | 256 | |||
5. Loaded work packages
All 250 loaded work packages with their accountable owner, contributors, effort and cost. Summary rollup levels are not repeated here — effort is carried at the work-package level only, so nothing is double-counted upward.
| WBS | Work package | Accountable owner | Contributors | Effort (h) | Cost |
|---|---|---|---|---|---|
| 1.1.1 | Draft business case & objectives | C. Tyrrell | — | 66 | $11,550 |
| 1.1.2 | Identify executive sponsor & governance structure | C. Tyrrell | — | 66 | $11,550 |
| 1.1.3 | Define high-level scope & success criteria | C. Tyrrell | — | 66 | $11,550 |
| 1.1.4 | Charter review & executive sign-off | C. Tyrrell | — | 66 | $11,550 |
| 1.1B.1 | Prepare kickoff deck (scope, team, milestones) | C. Tyrrell | — | 66 | $11,550 |
| 1.1B.2 | Conduct kickoff meeting with steering committee & core team | C. Tyrrell | — | 66 | $11,550 |
| 1.2.1 | Identify stakeholder groups | M. Ferraro | — | 366 | $49,410 |
| 1.2.2 | Requirements workshops — Underwriting | F. Jones | — | 124 | $17,360 |
| 1.2.3 | Requirements workshops — Claims Administration | F. Jones | — | 124 | $17,360 |
| 1.2.4 | Requirements workshops — Billing & Finance | F. Jones | — | 124 | $17,360 |
| 1.2.5 | Requirements workshops — Compliance/Legal | F. Jones | — | 376 | $52,640 |
| 1.2.6 | Requirements workshops — Customer Service & New Business | F. Jones | — | 124 | $17,360 |
| 1.2.7 | Document functional requirements | T. Whitaker | — | 550 | $74,250 |
| 1.2.8 | Document non-functional requirements (security, performance, compliance) | R. Okonkwo | S. Okwuosa | 427 | $59,865 |
| 1.2.9 | Build requirements traceability matrix | F. Jones | — | 124 | $17,360 |
| 1.2B.1 | Identify SOX-relevant systems & financial data flows | K. Ibrahim | — | 140 | $19,600 |
| 1.2B.2 | Assess control impact of upgrade, conversions & integrations | G. Fenwick | — | 360 | $54,000 |
| 1.2B.3 | Document required control changes & obtain Internal Audit input | K. Ibrahim | — | 140 | $19,600 |
| 1.2C.1 | Identify PII/PHI data elements in scope (member, provider, claims) | N. Sharma | — | 89 | $16,020 |
| 1.2C.2 | Assess privacy/regulatory impact of conversions & integrations | N. Sharma | — | 268 | $48,240 |
| 1.2C.3 | Document required privacy controls & sign-off | N. Sharma | — | 89 | $16,020 |
| 1.3.0 | Draft RFP document (Platform Upgrade) | W. Donnelly | — | 1 | $145 |
| 1.3.1 | Define vendor evaluation criteria | W. Donnelly | — | 1 | $145 |
| 1.3.2 | Issue RFP to platform vendors | W. Donnelly | — | 1 | $145 |
| 1.3.3 | Vendor demos & Q&A sessions | W. Donnelly | — | 3 | $435 |
| 1.3.4 | Score vendor responses | W. Donnelly | — | 5 | $725 |
| 1.3.5 | Reference checks | W. Donnelly | — | 1 | $145 |
| 1.3.6 | Contract negotiation | W. Donnelly | — | 1 | $145 |
| 1.3.7 | Draft & finalize SOW with selected platform vendor | W. Donnelly | — | 5 | $725 |
| 1.4.0 | Draft RFP document (Integration Middleware) | W. Donnelly | — | 1 | $145 |
| 1.4.1 | Define integration architecture requirements | W. Donnelly | — | 5 | $725 |
| 1.4.2 | Issue RFP to middleware vendors | W. Donnelly | — | 1 | $145 |
| 1.4.3 | Vendor demos & technical evaluation | W. Donnelly | — | 3 | $435 |
| 1.4.4 | Score vendor responses | W. Donnelly | — | 1 | $145 |
| 1.4.5 | Contract negotiation | W. Donnelly | — | 1 | $145 |
| 1.4.6 | Draft & finalize SOW with selected middleware vendor | W. Donnelly | — | 5 | $725 |
| 1.5.1 | Requirements walkthrough with SMEs & business owners | F. Jones | — | 124 | $17,360 |
| 1.5.2 | SME & business owner feedback period | M. Ferraro | — | 734 | $99,090 |
| 1.5.3 | Recirculate updated requirements for review | T. Whitaker | — | 550 | $74,250 |
| 1.5.4 | Final review & formal sign-off | R. Okonkwo | — | 634 | $85,590 |
| 1.6.1 | Define target-state architecture | K. Larsson | — | 600 | $96,000 |
| 1.6.2 | Design data conversion approach | M. Castillo | — | 240 | $38,400 |
| 1.6.3 | Design integration architecture (API/file-based) | J. Albert | — | 640 | $105,600 |
| 1.6.4 | Design security & access model | K. Larsson | S. Okwuosa | 261 | $41,205 |
| 1.6.5 | Design disaster recovery/failover approach | M. Castillo | — | 720 | $115,200 |
| 1.6.6 | Technical design walkthroughs with stakeholders | J. Albert | — | 160 | $26,400 |
| 1.6.7 | Finalize design documentation | K. Larsson | — | 150 | $24,000 |
| 1.7.1 | Architecture & design walkthrough with SMEs & business owners | J. Albert | — | 160 | $26,400 |
| 1.7.2 | SME & business owner feedback period | K. Larsson | — | 300 | $48,000 |
| 1.7.3 | Recirculate updated design documents for review | M. Castillo | — | 240 | $38,400 |
| 1.7.4 | Final review & formal design sign-off | J. Albert | — | 640 | $105,600 |
| 2.1.1 | Provision infrastructure (servers/cloud environment) | D. Fontenot | — | 244 | $34,160 |
| 2.1.2 | Configure network & security groups | A. Winters | S. Okwuosa | 158 | $23,785 |
| 2.1.3 | Install base platform software | M. Alvarez | — | 59 | $9,145 |
| 2.1.4 | Configure environment monitoring & logging | T. Halvorsen | — | 122 | $17,690 |
| 2.2.1 | Backup current production environment | D. Fontenot | — | 122 | $17,080 |
| 2.2.2 | Apply platform upgrade — Dev environment | A. Winters | — | 237 | $33,180 |
| 2.2.3 | Smoke test Dev environment | T. Halvorsen | — | 122 | $17,690 |
| 2.2.4 | Apply platform upgrade — Test environment | D. Fontenot | — | 612 | $85,680 |
| 2.2.5 | Smoke test Test environment | A. Winters | — | 47 | $6,580 |
| 2.2.6 | Apply platform upgrade — Staging environment | T. Halvorsen | — | 366 | $53,070 |
| 2.2.7 | Configuration & parameter tuning | M. Alvarez | — | 119 | $18,445 |
| 2.3.1 | Execute regression suite — core functions | M. Alvarez | — | 158 | $24,490 |
| 2.3.2 | Execute regression suite — reporting functions | M. Alvarez | — | 59 | $9,145 |
| 2.3.3 | Log & triage defects | M. Alvarez | — | 89 | $13,795 |
| 2.3.4 | Retest resolved defects | M. Alvarez | — | 29 | $4,495 |
| 2.4.1 | Performance benchmarking vs. baseline | M. Alvarez | — | 29 | $4,495 |
| 2.4.2 | Business stakeholder validation | M. Alvarez | — | 89 | $13,795 |
| 2.4.3 | Formal upgrade sign-off | M. Alvarez | — | 29 | $4,495 |
| 3.1.1 | Inventory source data fields | R. Sandoval | — | 42 | $5,460 |
| 3.1.2 | Identify target system field requirements | T. Bergman | — | 132 | $17,160 |
| 3.1.3 | Build field-level mapping document | T. McCormick | — | 143 | $21,450 |
| 3.1.4 | Identify data quality issues in source | R. Sandoval | — | 42 | $5,460 |
| 3.1.5 | Define transformation rules | T. Bergman | — | 44 | $5,720 |
| 3.1.6 | Business SME review & sign-off | T. McCormick | — | 71 | $10,650 |
| 3.2.1 | Inventory source provider/producer fields | T. Bergman | — | 44 | $5,720 |
| 3.2.2 | Identify target system field requirements | T. McCormick | — | 221 | $33,150 |
| 3.2.3 | Build field-level mapping document | R. Sandoval | — | 84 | $10,920 |
| 3.2.4 | Identify data quality issues | T. Bergman | — | 44 | $5,720 |
| 3.2.5 | Define transformation rules | T. McCormick | — | 71 | $10,650 |
| 3.2.6 | Business SME review & sign-off | R. Sandoval | — | 42 | $5,460 |
| 3.3.1 | Inventory source claims data fields | T. McCormick | — | 71 | $10,650 |
| 3.3.2 | Identify target system field requirements | R. Sandoval | — | 126 | $16,380 |
| 3.3.3 | Build field-level mapping document | T. Bergman | — | 132 | $17,160 |
| 3.3.4 | Identify data quality issues (large historical volume) | T. McCormick | — | 143 | $21,450 |
| 3.3.5 | Define transformation rules | R. Sandoval | — | 42 | $5,460 |
| 3.3.6 | Business SME review & sign-off | T. Bergman | — | 44 | $5,720 |
| 3.4.1 | Build extract scripts (source system) | R. Sandoval | — | 217 | $28,210 |
| 3.4.2.1 | Define null-handling rules | T. McCormick | — | 71 | $10,650 |
| 3.4.2.2 | Define deduplication rules | R. Sandoval | — | 42 | $5,460 |
| 3.4.2.3 | Define standardization rules (formats, codes) | T. Bergman | — | 44 | $5,720 |
| 3.4.2.4 | Build cleansing scripts | T. McCormick | — | 71 | $10,650 |
| 3.4.2.5 | Unit test cleansing scripts | R. Sandoval | — | 42 | $5,460 |
| 3.4.3 | Build transformation logic | T. Bergman | — | 264 | $34,320 |
| 3.4.4 | Build load scripts (target system) | T. McCormick | — | 214 | $32,100 |
| 3.4.5 | Unit test conversion scripts | R. Sandoval | — | 42 | $5,460 |
| 3.4.6 | Peer/technical review of conversion code | T. Bergman | — | 44 | $5,720 |
| 3.5.1 | Execute full extract from source | R. Sandoval | — | 42 | $5,460 |
| 3.5.2 | Execute cleansing & transformation pass | T. Bergman | — | 44 | $5,720 |
| 3.5.3 | Execute load into target (test environment) | T. McCormick | — | 71 | $10,650 |
| 3.5.4 | Record volume/counts (source vs. loaded) | R. Sandoval | — | 42 | $5,460 |
| 3.5.5 | Identify failed records & log defects | T. Bergman | — | 44 | $5,720 |
| 3.6.1 | Apply defect fixes from Dry Run 1 | R. Sandoval | — | 42 | $5,460 |
| 3.6.2 | Re-execute extract, transform, load | T. Bergman | — | 132 | $17,160 |
| 3.6.3 | Validate fixes resolved | T. McCormick | — | 71 | $10,650 |
| 3.7.1 | Run reconciliation reports (source vs. target) | T. Bergman | — | 44 | $5,720 |
| 3.7.2 | Spot-check sample records for accuracy | T. McCormick | — | 71 | $10,650 |
| 3.7.3 | Business SME validation of converted data | R. Sandoval | — | 42 | $5,460 |
| 3.7.4 | Document known exceptions/variances | T. Bergman | — | 44 | $5,720 |
| 3.7.5 | Formal sign-off (Conversion Lead & Business Owner) | T. McCormick | — | 71 | $10,650 |
| 4.1.1 | Interface design & spec review | R. Fontaine | — | 383 | $49,790 |
| 4.1.2.1 | Define message schema/payload | D. Okafor | — | 400 | $52,000 |
| 4.1.2.2 | Build listener/endpoint | R. Fontaine | — | 76 | $9,880 |
| 4.1.2.3 | Build field mapping & transformation logic | C. Marchetti | — | 300 | $37,500 |
| 4.1.2.4 | Code review | D. Okafor | — | 400 | $52,000 |
| 4.1.3 | Build outbound interface (Platform → Billing) | R. Fontaine | — | 461 | $59,930 |
| 4.1.4 | Unit test interface endpoints | C. Marchetti | — | 300 | $37,500 |
| 4.1.5 | Sprint 1 review/demo | D. Okafor | — | 400 | $52,000 |
| 4.1.6 | Error handling & performance testing | R. Fontaine | — | 230 | $29,900 |
| 4.1.7 | Integration test w/ converted data & Sprint 2 review | C. Marchetti | — | 300 | $37,500 |
| 4.2.1 | Interface design & spec review | K. Andersson | — | 822 | $106,860 |
| 4.2.2 | Build inbound interface (Underwriting → Platform) | P. Nakamura | — | 772 | $96,500 |
| 4.2.3 | Build outbound interface (Platform → Underwriting) | S. Lindqvist | — | 800 | $104,000 |
| 4.2.4 | Unit test interface endpoints | K. Andersson | — | 164 | $21,320 |
| 4.2.5 | Sprint 1 review/demo | P. Nakamura | — | 128 | $16,000 |
| 4.2.6 | Error handling & performance testing | S. Lindqvist | — | 400 | $52,000 |
| 4.2.7 | Integration test & Sprint 2 review | K. Andersson | — | 164 | $21,320 |
| 4.3.1 | Interface design & spec review | M. Osborn | — | 822 | $106,860 |
| 4.3.2 | Build inbound interface (Claims → Platform) | R. Solheim | — | 772 | $96,500 |
| 4.3.3 | Build outbound interface (Platform → Claims) | K. Delgado | — | 800 | $104,000 |
| 4.3.4 | Unit test interface endpoints | M. Osborn | — | 164 | $21,320 |
| 4.3.5 | Sprint 3 review/demo | R. Solheim | — | 128 | $16,000 |
| 4.3.6 | Error handling & performance testing | K. Delgado | — | 400 | $52,000 |
| 4.3.7 | Integration test w/ converted claims data & Sprint 4 review | M. Osborn | — | 164 | $21,320 |
| 4.4.1 | Interface design & spec review | T. Ibekwe | — | 403 | $52,390 |
| 4.4.2 | Build inbound interface (Commission → Platform) | P. Novak | — | 663 | $86,190 |
| 4.4.3 | Build outbound interface (Platform → Commission) | T. Ibekwe | — | 487 | $63,310 |
| 4.4.4 | Unit test interface endpoints | P. Novak | — | 110 | $14,300 |
| 4.4.5 | Sprint 3 review/demo | T. Ibekwe | — | 80 | $10,400 |
| 4.4.6 | Error handling & performance testing | P. Novak | — | 331 | $43,030 |
| 4.4.7 | Integration test & Sprint 4 review | T. Ibekwe | — | 80 | $10,400 |
| 4.5.1 | Define reporting data model/schema | L. Castellano | — | 439 | $57,070 |
| 4.5.2 | Build ETL feed to Data Warehouse | A. Reyes | — | 703 | $91,390 |
| 4.5.3 | Build standard report templates | L. Castellano | — | 437 | $56,810 |
| 4.5.4 | Unit test ETL & reports | A. Reyes | — | 100 | $13,000 |
| 4.5.5 | Sprint 5 review/demo | L. Castellano | — | 87 | $11,310 |
| 4.5.6 | Performance testing (large data volume) | A. Reyes | — | 301 | $39,130 |
| 4.5.7 | Integration test & Sprint 6 review | L. Castellano | — | 87 | $11,310 |
| 4.6.1 | Interface design & spec review | J. Whitmore | — | 403 | $52,390 |
| 4.6.2 | Build payment gateway connection | B. Sato | — | 663 | $86,190 |
| 4.6.3 | Build reconciliation/settlement logic | J. Whitmore | — | 487 | $63,310 |
| 4.6.4 | Unit test interface endpoints | B. Sato | — | 110 | $14,300 |
| 4.6.5 | Sprint 5 review/demo | J. Whitmore | — | 80 | $10,400 |
| 4.6.6 | Error handling & PCI compliance validation | B. Sato | — | 331 | $43,030 |
| 4.6.7 | Integration test & Sprint 6 review | J. Whitmore | — | 80 | $10,400 |
| 5.1.0 | Offshore QA Team Onboarding & Coordination Setup | P. Sundaram | — | 1,400 | $91,000 |
| 5.1.1 | Functional test planning & test case development | A. Ferreira | — | 744 | $85,560 |
| 5.1.2 | Functional testing — Billing & Payment integrations | V. Rao | — | 1,400 | $84,000 |
| 5.1.3 | Functional testing — Underwriting & Commission integrations | S. Banerjee | — | 1,400 | $84,000 |
| 5.1.4 | Functional testing — Claims & Data Warehouse integrations | N. Fernandes | — | 1,200 | $72,000 |
| 5.1.5 | Functional defect triage & retest | D. Kowalczyk | — | 927 | $106,605 |
| 5.2.1 | System test planning & environment setup | R. Whitfield | — | 490 | $61,250 |
| 5.2.2 | End-to-end scenarios — enrollment to claims | A. Ferreira | — | 171 | $19,665 |
| 5.2.3 | End-to-end scenarios — billing to payment | D. Kowalczyk | — | 102 | $11,730 |
| 5.2.4 | End-to-end scenarios — reporting | E. Solis | — | 668 | $76,820 |
| 5.2.5 | System test defect triage | R. Whitfield | — | 163 | $20,375 |
| 5.2A.1 | External penetration test (vendor-conducted) | D. Kowalczyk | S. Okwuosa | 582 | $84,730 |
| 5.2A.2 | Vulnerability remediation & retest | M. Alvarez | S. Okwuosa | 140 | $21,700 |
| 5.2A.3 | Security sign-off (Compliance/Legal) | N. Sharma | S. Okwuosa | 200 | $33,225 |
| 5.2B.1 | Define load profiles & performance targets | R. Whitfield | — | 163 | $20,375 |
| 5.2B.2 | Execute full-volume load test across platform & integrations | M. Alvarez | — | 59 | $9,145 |
| 5.2B.3 | Analyze results & tune performance bottlenecks | M. Alvarez | — | 29 | $4,495 |
| 5.2C.1 | Execute planned failover to DR environment | D. Fontenot | — | 122 | $17,080 |
| 5.2C.2 | Validate system functionality & data integrity on DR | A. Ferreira | — | 57 | $6,555 |
| 5.2C.3 | Failback to primary & DR test sign-off | M. Alvarez | — | 29 | $4,495 |
| 5.2D.1 | Execute testing of updated SOX-relevant controls | K. Ibrahim | — | 280 | $39,200 |
| 5.2D.2 | Internal Audit review of control testing results | G. Fenwick | — | 120 | $18,000 |
| 5.2D.3 | Formal SOX compliance sign-off | K. Ibrahim | — | 140 | $19,600 |
| 5.3.1 | Prioritize defects (severity/priority) | E. Solis | — | 166 | $19,090 |
| 5.3.2 | Development fixes — critical/high defects | R. Whitfield | — | 984 | $123,000 |
| 5.3.3 | Regression retest of fixes | A. Ferreira | — | 228 | $26,220 |
| 5.3.4 | Defect closure sign-off | D. Kowalczyk | — | 34 | $3,910 |
| 5.4.1 | UAT planning & test script development | R. Antonelli | — | 116 | $17,400 |
| 5.4.2 | UAT execution — Underwriting & New Business | J. Restrepo | — | 350 | $52,500 |
| 5.4.3 | UAT execution — Claims Administration | M. Yamamoto | — | 320 | $48,000 |
| 5.4.4 | UAT execution — Billing & Payments | D. Kessler | — | 267 | $40,050 |
| 5.4.5 | UAT defect triage & fixes | R. Antonelli | — | 234 | $35,100 |
| 5.5.1 | Consolidate UAT results | M. Yamamoto | — | 80 | $12,000 |
| 5.5.2 | Business stakeholder review | E. Solis | — | 166 | $19,090 |
| 5.5.3 | Formal UAT sign-off (Go/No-Go input) | D. Kessler | — | 133 | $19,950 |
| 6.1.1 | Develop detailed cutover runbook | C. Tyrrell | — | 66 | $11,550 |
| 6.1.2 | Cutover rehearsal (dry run) | C. Tyrrell | — | 198 | $34,650 |
| 6.1.3 | Go/No-Go readiness review | C. Tyrrell | — | 66 | $11,550 |
| 6.2.1 | Final data conversion to production | C. Tyrrell | — | 66 | $11,550 |
| 6.2.2 | Production deployment — platform & integrations | C. Tyrrell | — | 66 | $11,550 |
| 6.2.3 | Post-deployment smoke testing | C. Tyrrell | — | 66 | $11,550 |
| 6.2.4 | Go-live communication & business sign-off | C. Tyrrell | — | 66 | $11,550 |
| 6.3.1 | Daily production monitoring & issue triage | C. Tyrrell | — | 865 | $151,375 |
| 6.3.2 | Priority defect fixes during hypercare | C. Tyrrell | — | 132 | $23,100 |
| 6.3.3 | Hypercare exit readiness review | C. Tyrrell | — | 66 | $11,550 |
| 6.3B.1 | Monitor customer satisfaction & support ticket sentiment | V. Alaoui | — | 270 | $32,400 |
| 6.3B.2 | Consolidate CX feedback & report to Steering Committee | V. Alaoui | — | 29 | $3,480 |
| 6.4.1 | Vendor warranty support activation & SLA confirmation | W. Donnelly | — | 1 | $145 |
| 6.4.2 | Ongoing defect monitoring under vendor warranty | A. Winters | — | 619 | $86,660 |
| 6.4.3 | Warranty-period defect resolution tracking | W. Donnelly | — | 7 | $1,015 |
| 6.4.4 | Warranty exit review & sign-off | C. Tyrrell | — | 66 | $11,550 |
| 6.5.1 | Confirm data retention requirements & archive legacy data | R. Sandoval | — | 211 | $27,430 |
| 6.5.2 | Terminate legacy vendor licenses & contracts | W. Donnelly | — | 1 | $145 |
| 6.5.3 | Decommission legacy infrastructure/environment | T. Halvorsen | — | 490 | $71,050 |
| 6.5.4 | Decommissioning sign-off (Compliance/Legal) | N. Sharma | — | 89 | $16,020 |
| 6.6.1 | Finalize support runbooks & knowledge base | M. Alvarez | — | 29 | $4,495 |
| 6.6.2 | Knowledge transfer sessions with Production Support team | C. Solberg | — | 7 | $770 |
| 6.6.3 | Formal handover & Production Support acceptance sign-off | C. Tyrrell | — | 66 | $11,550 |
| 6.7.1 | Finalize project documentation & handover to support | C. Tyrrell | — | 66 | $11,550 |
| 6.7.2 | Lessons learned session | C. Tyrrell | — | 66 | $11,550 |
| 6.7.3 | Formal project closure & sign-off | C. Tyrrell | — | 66 | $11,550 |
| 7.1.1 | Identify impacted roles & workflows | L. Bergström | — | 592 | $85,840 |
| 7.1.2 | Assess change readiness by department | D. Abernathy | — | 270 | $35,100 |
| 7.1.3 | Document impact assessment findings | L. Bergström | — | 118 | $17,110 |
| 7.2.1 | Define communication audiences & channels | L. Bergström | — | 236 | $34,220 |
| 7.2.2 | Build communication calendar & key messages | D. Abernathy | — | 270 | $35,100 |
| 7.2.3 | Sponsor review & approval | L. Bergström | — | 472 | $68,440 |
| 7.3.1 | Assess role-based training requirements | H. Osei | — | 168 | $18,480 |
| 7.3.2 | Define training delivery approach (in-person/virtual) | M. Sorensen | — | 56 | $5,880 |
| 7.3.3 | Finalize training curriculum outline | H. Osei | — | 28 | $3,080 |
| 7.4.1 | Develop Underwriting & New Business training materials | H. Osei | — | 168 | $18,480 |
| 7.4.2 | Develop Claims Administration training materials | M. Sorensen | — | 172 | $18,060 |
| 7.4.3 | Develop Billing & Payments training materials | H. Osei | — | 168 | $18,480 |
| 7.4.4 | Develop Compliance & Customer Service training materials | M. Sorensen | — | 170 | $17,850 |
| 7.5.1 | Train Underwriting & New Business users | M. Sorensen | — | 56 | $5,880 |
| 7.5.2 | Train Claims Administration users | H. Osei | — | 56 | $6,160 |
| 7.5.3 | Train Billing & Payments users | M. Sorensen | — | 113 | $11,865 |
| 7.5.4 | Train Compliance & Customer Service users | H. Osei | — | 56 | $6,160 |
| 7.5.5 | Training feedback collection & reinforcement sessions | M. Sorensen | — | 113 | $11,865 |
| 7.6.1 | Send go-live readiness notices to end users | L. Bergström | — | 118 | $17,110 |
| 7.6.2 | Publish quick-reference guides & FAQs | D. Abernathy | — | 360 | $46,800 |
| 7.6B.1 | Draft customer-facing notices (portal, billing, statements) | V. Alaoui | — | 14 | $1,680 |
| 7.6B.2 | Distribute customer communications & update self-service channels | V. Alaoui | — | 7 | $840 |
| 7.7.1 | Staff & train hypercare support desk | M. Sorensen | — | 170 | $17,850 |
| 7.7.2 | Operate support desk during hypercare | H. Osei | — | 566 | $62,260 |
| 8.1.1 | Establish steering committee & reporting cadence | C. Solberg | — | 15 | $1,650 |
| 8.1.2 | Weekly project status reporting | P. Andressen | — | 403 | $48,360 |
| 8.1.3 | Monthly steering committee reviews | E. Kowalski | — | 259 | $34,965 |
| 8.2.1 | Establish risk register & escalation process | P. Andressen | — | 6 | $720 |
| 8.2.2 | Ongoing risk & issue tracking | E. Kowalski | — | 252 | $34,020 |
| 8.2.3 | Monthly risk mitigation plan reviews | C. Solberg | — | 873 | $96,030 |
| 8.3.1 | Build resource plan & staffing model | E. Kowalski | — | 9 | $1,215 |
| 8.3.1B | Establish Cost Baseline & Steering Committee Approval | C. Solberg | — | 5 | $550 |
| 8.3.2 | Ongoing budget tracking & variance reporting | P. Andressen | — | 391 | $46,920 |
| 8.3.3 | Vendor invoice management & reconciliation | W. Donnelly | — | 556 | $80,620 |