← PM Suite Data Conversion Plan

Enrollment & Claims Platform Modernization

Download Word

How the historical member, policy, provider and claims data of the legacy platform is moved to the vendor-delivered platform with full reconciliation, a tested rollback, and no silent data loss — and how the program proves that before it is allowed to carry live enrollment and claims traffic. This plan is the owning document for transition requirements TR-001 through TR-007, which are stated in the Business Requirements Document and traced in the Requirements Traceability Matrix (gap G-01), but until now were specified only inside the FSD and Test Strategy rather than in a plan of their own.

7
Transition reqs owned (TR-001–07)
3
Full-volume dry runs
100%
Reconciliation, not sampling
16 Mar 2027
Data Conversion sign-off
24 Aug 2027
Production cutover

1 · Purpose, scope and what this plan owns G-01

The RTM records G-01 as an open gap: nine transition requirements name conversion behaviour that was specified in the FSD and the Test Strategy but owned by no single maintained document. A conversion whose rules live only inside a test plan is a conversion whose rules change silently when the test plan is revised. This plan is that single owning document. It states the rules once, names an owner for each, and makes the sign-off a gate.

This plan ownsRequirement (from the BRD)Owner
ReconciliationTR-001 — historical member, policy, provider and claims data converted with 100% record and control-total reconciliationT. McCormick
De-duplicationTR-002 — duplicate member records resolved by documented rule, every merge auditable and reversibleT. McCormick
Exception handlingTR-003 — records that cannot be converted quarantined, reported and owned — never silently droppedT. McCormick
RehearsalTR-004 — conversion rehearsed at full volume before production executionT. McCormick
Parallel runTR-005 — legacy and new platform run in parallel on representative transactions, variances explained before cutoverR. Whitfield
Outage windowTR-006 — conversion completes within the available cutover outage windowT. McCormick
RollbackTR-007 — a tested rollback path exists up to the defined point of no returnM. Alvarez

Out of scope, by design. TR-008/009 (training, process documentation) belong to the Training Plan; TR-010 (hypercare) and the cutover runbook belong to the Cutover Plan; TR-011 (legacy read-only retention) and TR-012 (member notification) are named there too. This plan stops at the moment converted data is accepted into production; what happens to the people and the process at that moment is the Cutover and Training plans' work.

2 · What is being converted Data scope

Four data domains move, and they do not move independently — a claim references a member, a member holds a policy, a policy names a provider network. The conversion sequence respects those dependencies: reference data first, then the entities that depend on it, then transactional history last. Loading claims before the members and providers they reference would produce orphaned transactions that reconcile to nothing — so the sequence is a correctness control, not merely an efficiency choice.

DomainContentsPrincipal conversion risk
Member & policyEnrolled members, dependents, coverage elections, plan-year accumulator balances (deductible, out-of-pocket)Accumulator continuity across the conversion boundary (FS-008)
ProviderContracted providers, networks, fee schedules, effective-dated participationEffective-dating: a provider's network status must be correct as of each historical service date
Claims historyAdjudicated claims, payment records, adjustment history, accumulator-affecting transactionsVolume and data quality — the largest, oldest, dirtiest domain (I-001)
Financial / commissionCommission calculations, payment ledgers tied to the Commission Management integrationLegacy calculation logic differing from the new spec (I-004)
The accumulator is the highest-consequence field in the conversion. FS-008 requires that a member's plan-year position — how much of their deductible and out-of-pocket maximum they have already met — is continuous across the conversion boundary. A member who has met their deductible on the legacy platform on the day before cutover must not be asked to meet it again on the day after. This is not a reporting nicety: an incorrect accumulator causes incorrect member cost-share on the very first claim adjudicated post-cutover, and it is visible to the member immediately. Accumulator reconciliation is therefore a named control-total in every dry run, not a field checked at the end.

Claims history dominates the risk. It is the largest domain by record count, the oldest (so the most likely to carry data-quality debt accumulated over years of legacy operation), and the domain where the duplicate-record problem I-001 surfaced. It is also the domain whose conversion time drives whether TR-006's outage window is met. For all three reasons the plan sequences claims conversion last and rehearses it hardest — the dry runs in §5 exist primarily to de-risk this domain, because the other three are comparatively small and clean.

3 · The conversion pipeline TR-001–003

Every record travels the same five stages. The design principle is that a record can leave the pipeline in exactly two ways — converted-and-reconciled, or quarantined-and-owned. There is no third path in which a record simply disappears, because a record that silently fails to convert is a member whose claims will not adjudicate, discovered weeks later by that member.

1
Extract
Pull from the legacy platform against a frozen snapshot. Every extract is counted at source: record counts by domain and financial control totals (sum of accumulator balances, sum of claim payments) are captured before a single record is transformed, because reconciliation is meaningless without a trusted starting number.
2
Profile & cleanse
Assess data quality and apply documented cleansing rules. This is where I-001 lives — early profiling revealed higher-than-expected duplicate member records in historical claims data; a de-duplication pass was added to the pipeline (see §4). Cleansing rules are versioned and reviewed; a rule is never applied that isn't written down, because a silent cleanse is indistinguishable from data loss.
3
Transform & map
Map legacy structures to the new platform's model, including effective-dated provider participation and accumulator carry-forward. Where legacy behaviour and the new spec disagree — the I-004 Commission divergence is the known case — the FSD's resolution is authoritative and is applied here, not re-litigated per record.
4
Load & reconcile
Load into the target and reconcile to the source counts and control totals from stage 1. TR-001 requires 100% record and control-total reconciliation — not a sample. A domain is not "converted" until its loaded counts and financial totals equal its extracted counts and totals, less exactly the records accounted for in quarantine.
5
Quarantine & account
TR-003: records that cannot be converted are quarantined, reported and owned by a named business data owner — never dropped. The quarantine is itself reconciled: extracted = loaded + quarantined, with no remainder. An unexplained remainder halts sign-off.
The reconciliation identity that governs sign-off: for every domain, extracted = loaded + quarantined, and Σ(source control totals) = Σ(target control totals) + Σ(quarantined value). If either identity leaves a remainder that cannot be explained by a named quarantine record, the conversion has lost data, and Data Conversion Sign-off (16 Mar 2027) cannot be given.

4 · De-duplication — auditable and reversible TR-002 · I-001

TR-002 is deceptively demanding: duplicate member records must be resolved by documented rule, and every merge must be auditable and reversible. Reversibility is the hard part. A merge that cannot be undone is a decision made permanent before it has been proven right, and member-record merges are exactly the decisions most likely to be wrong — two people with the same name and date of birth are not the same member, and a merge that assumes they are creates a privacy incident, not a data-quality improvement.

I-001 is closed, and this is why it stays closed. The duplicate-record volume that early profiling surfaced was resolved by adding this de-duplication pass. Recording it here, as a maintained plan with a reversible journal, is what prevents the same issue re-opening silently when the pipeline is re-run for the next dry run — a fix that lives only in a closed issue ticket is a fix that the next engineer doesn't know to preserve.

5 · The three dry runs TR-004 · D-002

TR-004 requires the conversion to be rehearsed at full volume before it is run for real. This program does that three times, and the third rehearsal is pre-funded on purpose. The Test & Quality Strategy and decision D-002 pre-approved up to $150,000 of contingency for a third dry-run cycle before anyone knew whether it would be needed — because on a mandatory replacement with a fixed open-enrollment go-live, the time to discover that historical claims data is dirtier than expected is the second dry run, not the production cutover.

Dry runPurposeExit criterion
Dry Run 1Prove the pipeline runs end-to-end at full volume; establish the reconciliation baseline; surface the bulk of data-quality exceptionsPipeline completes; reconciliation identities computed; exception population characterised
Dry Run 2Prove the cleansing and de-duplication rules resolve the exceptions found in Run 1; measure the conversion against the outage window (TR-006)Exception rate materially reduced; conversion completes within the target outage duration
Dry Run 3
(pre-funded, D-002)
Confirmation run only, executed if Run 2 still shows the data insufficiently clean. Not a schedule slip — a pre-approved contingencyA clean run reproducible on demand; sign-off candidate
Why the pre-funding matters more than its cost. $150,000 is small against the $11,582,050 program baseline. Its value is that it removes the incentive to declare the data "clean enough" under schedule pressure. When a third rehearsal is already funded and approved, the honest finding — "the data isn't ready, run it again" — costs nobody a difficult conversation. That is the decision D-002 actually bought.

6 · Parallel run — the independent check TR-005

Reconciliation proves the data moved correctly. It does not prove the new platform processes it correctly. TR-005 closes that gap: legacy and new platforms are run in parallel on representative transactions, and every variance is explained before cutover. This is owned by the QA / Test Lead (R. Whitfield), not the Conversion Lead, on purpose — the party that performed the conversion should not also be the sole party certifying that its output behaves correctly.

7 · The outage window and the point of no return TR-006 · TR-007

Production conversion runs inside a bounded outage window during the cutover weekend. Two requirements govern it, and they are in tension: TR-006 says the conversion must complete within the window; TR-007 says a tested rollback must exist up to a defined point of no return. The tension is deliberate — the point of no return is the moment those two requirements hand off to each other.

T-0 · Window opens
Legacy platform taken offline; final extract against the frozen snapshot begins. Rollback available: revert to legacy, no data lost.
Conversion runs
Pipeline executes at production volume, timed against Dry Run 2's measured duration. Rollback still available throughout.
Point of no return
The go/no-go decision. Reconciliation identities are checked against the loaded production data. If they close, the program commits forward and the rollback path is retired. If they do not, the rollback (TR-007) is executed and legacy is restored — this is the last moment that choice exists.
Validation & smoke test
Post-load validation on the new platform; the Cutover Plan takes over here.
Go-Live · 24 Aug 2027
New platform carries live enrollment and claims traffic.
The rollback is only real if it is rehearsed. TR-007 does not say "a rollback path shall exist" — it says a tested rollback path. A rollback executed for the first time under cutover pressure, on production data, at 3 a.m., is not a control; it is a hope. The rollback is exercised during the dry runs so that at the point of no return the decision to invoke it is a routine, practised action rather than an improvisation. The Cutover Plan carries the operational runbook for it.

8 · Roles and sign-off authority Governance

RoleNamedConversion accountability
Data Conversion LeadT. McCormickOwns the pipeline, reconciliation, de-duplication, exception accounting and the dry-run cycle (TR-001–004, TR-006)
QA / Test LeadR. WhitfieldOwns the independent parallel run and variance disposition (TR-005) — deliberately separate from the Conversion Lead
System Upgrade LeadM. AlvarezOwns the tested rollback path and the technical point-of-no-return execution (TR-007)
Business Data OwnersPer domainAdjudicate quarantined records and ambiguous merges; no record is dropped without a named owner's decision
Program ManagerC. TyrrellChairs the point-of-no-return go/no-go; owns Data Conversion Sign-off
Data Conversion Sign-off — 16 Mar 2027. This is a gate, not a status. It is given only when: all four domains reconcile with no unexplained remainder; the exception population is fully owned; the parallel run's variances are all explained; and the rollback has been executed successfully in at least one dry run. Sign-off is the milestone the RTM names as G-01's close date, and it precedes Integration Build Complete (11 May 2027) so that downstream build proceeds on converted, reconciled data rather than on assumptions about it.

9 · Traceability — this plan against the RTM G-01 closed

The RTM records TR-001 through TR-010 as transition requirements and flagged G-01 because seven of them had no owning plan. With this document, they do:

RequirementOwned by this plan inStatus
TR-001§3 pipeline, §8 reconciliation gateOwned
TR-002§4 de-duplication (auditable + reversible)Owned
TR-003§3 stage 5 quarantine accountingOwned
TR-004§5 three dry runsOwned
TR-005§6 parallel run (independent QA)Owned
TR-006§7 outage windowOwned
TR-007§7 point of no return + rollbackOwned

TR-008 and TR-009 are owned by the Training Plan; TR-010, TR-011 and TR-012 by the Cutover Plan. Together the three plans close the RTM's transition-requirement gaps G-01, G-02 and G-03 without overlap and without a requirement falling between them.