My previous role was as Data Migration Technical Lead was with one of the ‘big 6’ energy companies. My previous role involved delivering a complex data migration solution, involving the migration of reference, transaction and master data from multiple legacy systems into a highly customised suite of software packages. I developed the data migration and reconciliation approach for each phase of the programme, and identified the key data control points, at which to quantify and identify the levels of data quality as part of the landscape analysis and data profiling stage of the project.
I identified the data quality issues in the legacy data systems and introduced a data quality board to facilitate the remediation of the erroneous data. I introduced and documented the data cleansing strategy and managed its execution including the appropriate stage of migration for cleansing activity to be carried out where possible.
I managed a team of customer service analysts to correct the non-financial generic errors including but not restricted to correcting formats in postcodes, telephone numbers and email addresses.
I worked closely with the head of finance, a finance team member and a business analyst to remediate erroneous financial data, the balancing of the nominal ledger was key and as such many ledgers at all levels had to be adjusted, from the general ledger to customers individual sales ledger balances. The identification of these errors and the subsequent root cause analysis allowed the identification of where deviation and or aggregation of these errors took place. Journals were then posted to the correct ledgers in order to remediate the errors caused by the poor quality data.
Identified the mapping between the legacy and target system and produced the data lineage documents that detailed all of the extraction, exclusion and transformation rules for regulatory compliance and to link the new system into a pre-existing overarching SIEBEL CRM database.
Successful completion of migration build, testing and execution, was implemented within the allocated time scale overcoming significant architecture problems and system integrator resource issues.
Demonstrated a successful financial reconciliation, which was designed to show at each logical data control point that the financial data being migrated had not changed and although some data was moving into different areas as per the new design, all accounts reconciled within a pre-determined threshold.
Post implementation mop up, further reconciliation checks were made to identify any errors in the process, known issues were then presented to the business change team to correct post the migration go live.