Customer: Mercury

Wave 1 — Migration Progress

65% CompleteETA: 18 Jul 2026
Entities Migrated
12 / 38
Wave 1 scope
Quality Score
87%
Above threshold (85%)
Records Processed
2.4M
Source: Velocity V4
Overall Status
On Track
Last updated: 8 Jul 2026
Timeline
12 Jun 2026Discovery & Schema Analysis Complete
20 Jun 2026Wave 1 Extraction Started
8 Jul 2026Wave 1 Transformation In Progress
18 Jul 2026Wave 1 Reconciliation & Sign-off
1 Aug 2026Wave 2 Kickoff

Wave 1 — Customer & Account

In Progress
65%12 / 18 entities
CustomerAccountContactAddressAgreementService Point
EntityRowsStatusQuality
Customer245,000Complete92%
Account310,000Complete89%
Contact180,000In Progress85%
Address420,000In Progress88%

Wave 2 — Billing & Payments

Planned
0%Starts 1 Aug 2026
InvoicePaymentBill LineTariffAdjustment

Wave 3 — Meter & Consumption

Planned
0%Starts 1 Sep 2026
MeterRegisterReadingConsumptionChannel
Quality Trend
Jun 12 Jun 25 Jul 8 87%
Entity Quality Scores
EntityScoreNullsDuplicatesFormat Errors
Customer92%0.3%1245
Account89%1.1%8120
Contact85%2.4%34210
Address88%0.8%587
Agreement83%3.1%19156
Open Issues
IssueEntitySeverityStatus
Missing phone format for 2,400 contactsContactMediumIn Progress
Duplicate customer IDs (legacy merge)CustomerHighResolved
Null agreement end dates (expired)AgreementMediumUnder Review
Source vs Target Comparison
Overall Match Rate
99.7%
Records Compared
1.15M
Variances
3,412
BCT Status
Passed
Variance Details
EntitySource CountTarget CountMatch %Variance
Customer245,000244,98099.99%20
Account310,000309,85099.95%150
Contact180,000178,20099.00%1,800
Address420,000418,55899.66%1,442
BCT Results Summary
TestResultDetails
Row Count ValidationPassAll entities within 0.5% threshold
Primary Key IntegrityPassNo orphaned keys detected
Financial Balance CheckPassBalances reconciled to $0.00
Date Range ContinuityPassNo gaps in transaction history
Available Reports
Migration Progress Report
Generated 8 Jul 2026
Download PDF
Data Quality Assessment — Wave 1
Generated 7 Jul 2026
Download PDF
Reconciliation Detail Report
Generated 6 Jul 2026
Download Excel
BCT Certification Report
Generated 5 Jul 2026
Download PDF
Entity Mapping Specification
Generated 1 Jul 2026
Download Excel
Migration Sign-off Checklist
Schema discovery completed
Entity mapping approved
Data quality threshold met (≥85%)
BCT tests passed
Reconciliation signed off
UAT acceptance
Go-live approval