Data Migration and Integration from Exact Globe/Synergy to ACES Port Management System (Empormontt)
Budget: $5,000 – $10,000 USD
Empormontt seeks to migrate seven years of financial and operational data from its existing Exact Globe and Exact Synergy platforms into ACES, the company’s new SQL Server–based Port Management System. The project covers the full data lifecycle—from analysis to final load—across multiple databases containing DEM/DRM port-service liquidations, invoicing records, general ledger transactions, and all supporting structures required for complete accounting traceability.
Every source table must be accurately mapped, transformed, and loaded into the ACES relational model without loss of context or integrity. Data accuracy, field-level validation, format consistency, preserved timestamps, and full end-to-end auditability are mandatory.
Since both environments run on SQL Server, expertise in T-SQL, SSIS (or equivalent ETL frameworks), and version-controlled script delivery is essential.
Deliverables:
• A comprehensive data-mapping document linking every Exact field to its ACES target.
• Reusable and parameterized ETL packages/scripts for repeatable runs.
• Validation routines and reports demonstrating parity of record counts, balances, and hash totals with the source.
• A detailed migration runbook and a handover session for Empormontt’s IT team.
Acceptance Criteria:
All balance sheet and income statement figures in ACES must reconcile 100% with Exact data; operational service records must reproduce identical invoice totals; and all migration logs must be timestamped and auditable to ensure future traceability.
Every source table must be accurately mapped, transformed, and loaded into the ACES relational model without loss of context or integrity. Data accuracy, field-level validation, format consistency, preserved timestamps, and full end-to-end auditability are mandatory.
Since both environments run on SQL Server, expertise in T-SQL, SSIS (or equivalent ETL frameworks), and version-controlled script delivery is essential.
Deliverables:
• A comprehensive data-mapping document linking every Exact field to its ACES target.
• Reusable and parameterized ETL packages/scripts for repeatable runs.
• Validation routines and reports demonstrating parity of record counts, balances, and hash totals with the source.
• A detailed migration runbook and a handover session for Empormontt’s IT team.
Acceptance Criteria:
All balance sheet and income statement figures in ACES must reconcile 100% with Exact data; operational service records must reproduce identical invoice totals; and all migration logs must be timestamped and auditable to ensure future traceability.