Mark Dicken

Led enterprise-scale Data Migration, Master Data Management (MDM), Master Data Governance (MDG) and Data Governance activities supporting a global business transformation across 26 countries and 4 international regions. Worked across SAP S/4HANA, SAP MDG, JD Edwards and Microsoft Dynamics ERP environments, partnering with business stakeholders, data owners and technical teams to improve master data quality, establish governance standards and prepare trusted data for migration.

Key Responsibilities

• Led global Data Migration, Data Governance, MDM and MDG initiatives across enterprise ERP platforms.
• Coordinated remediation of more than 925,000 master data quality issues across multiple business domains.
• Worked across Product, Customer, Vendor, Material, Finance and Business Partner master data.
• Established governance processes, data ownership, stewardship and enterprise data quality standards.
• Performed data profiling, cleansing, validation, reconciliation, root cause analysis and issue management.
• Produced KPI dashboards and management reporting to monitor remediation progress, data quality, governance compliance and migration readiness.
• Supported enterprise migration workstreams including business validation, UAT, reconciliation and deployment readiness.
• Collaborated with global business stakeholders, regional data owners and technical teams across multiple countries and time zones.

Key Achievements

• Coordinated remediation of more than 925,000 master data quality issues, improving data quality, consistency and migration readiness across 26 countries and 4 global regions.
• Strengthened Master Data Governance, enterprise data ownership and governance processes across SAP S/4HANA, SAP MDG, JD Edwards and Microsoft Dynamics environments.
• Contributed to the successful delivery of a global transformation programme by providing trusted, high-quality master data, reducing migration risk and improving long-term enterprise data governance.

SAP S/4HANA, Data Migration and +19 skills

Ascential – Part of the Informa Group logo

Delivered end-to-end Data Integration and automation between Salesforce CRM and SAP S/4HANA Cloud, supporting digital transformation. Collected, analysed, profiled, cleansed, de-duplicated, transformed, validated, reconciled and integrated business-critical data, delivering trusted information throughout the order lifecycle.
Designed automated integrations that reduced manual effort, improved efficiency, increased processing accuracy and strengthened data quality.

Key Responsibilities

• Collected, analysed and profiled data from Salesforce CRM and enterprise source systems.
• Performed data cleansing, de-duplication, transformation, mapping, validation and reconciliation.
• Designed and supported automated Salesforce CRM to SAP S/4HANA Cloud integrations.
• Developed business rules and transformation logic for transaction processing.
• Automated customer sales order processing exceeding £5 million.
• Reconciled source and target systems ensuring data integrity and completeness.
• Investigated data quality and integration issues using root cause analysis.
• Produced daily and weekly KPI dashboards covering order volumes, transaction values (£), throughput, reconciliation, exceptions, integration performance and operational trends.
• Worked with business stakeholders, finance, sales operations and technical teams to improve business processes.
• Supported SIT, UAT, production deployments and post go-live support.
• Produced technical and operational documentation.

Key Achievements

• Automated Salesforce CRM to SAP S/4HANA Cloud integration, reducing manual processing.
• Improved data quality, processing accuracy and operational efficiency through validation, reconciliation and automation.
• Delivered enterprise integration solutions supporting digital transformation, operational excellence and continuous business improvement.

Data Lifecycle

Collect • Analyse • Profile • Cleanse • De-duplicate • Transform • Validate • Integrate • Reconcile • Report • Support

Led Data Migration for a global IFS ERP transformation across the UK, USA and Germany. Reported to the Global Programme Lead and Project Manager, leading migration strategy, data quality, governance and implementation readiness across multiple business functions.
Identified that the programme's biggest challenge was poor data quality and disconnects between Engineering Bills of Materials (eBOM) and Manufacturing Bills of Materials (mBOM), rather than the ERP implementation itself. Defined remediation plans, prioritised data quality improvements and enabled the programme to progress into successful implementation.

Key Responsibilities

• Led the end-to-end Data Migration workstream across multiple countries.
• Analysed, profiled, cleansed, transformed, validated and reconciled business-critical data.
• Managed Configuration, Master Data and Financial Data migrations.
• Delivered migration activities for Accounts Payable, Accounts Receivable, Fixed Assets and Bills of Materials.
• Identified data quality issues and integration gaps between Engineering and Manufacturing master data.
• Produced daily KPI dashboards and executive reports covering data quality, migration readiness, issues and programme progress.
• Reported migration progress and KPI metrics through the Programme Lead to executive management, including the Chairman and company shareholders.
• Worked with engineering, manufacturing, finance and technical teams to resolve complex business and data issues.
• Supported SIT, UAT, Cutover planning and Go-Live.

Key Achievements

• Shifted the programme from data remediation to successful implementation through Data Migration leadership.
• Improved executive visibility through daily KPI reporting and migration statistics.
• Resolved critical eBOM and mBOM data discrepancies, significantly improving migration readiness.
• Reduced programme risk by delivering trusted data for a successful multinational ERP implementation.

Reported to the Chief Technology Officer on a major Finance Business Transformation programme delivering Microsoft Dynamics 365 (D365). Responsible for end-to-end data migration across three legacy systems, ensuring business-critical data was transformed, validated and successfully migrated into the new ERP platform.
Worked with business stakeholders, Finance SMEs and technical teams to analyse legacy data, define transformation rules, automate extraction processes and produce reconciliation reporting supporting migration readiness and business sign-off.

Key Responsibilities

• Led data migration from three legacy business systems into Microsoft Dynamics 365.
• Gathered, analysed and profiled Finance Master Data.
• Defined mapping, transformation and validation rules.
• Designed migration specifications and transformation logic.
• Developed automated SQL Server extraction processes to create migration-ready datasets.
• Produced daily Data Quality dashboards, Red/Amber/Green status reports and migration KPIs.
• Created Data Quality Cockpit reports.
• Supported business users with data cleansing, validation and remediation.
• Performed post-load reconciliation supporting business sign-off.
• Delivered multiple migration cycles covering extraction, transformation, loading, validation and reconciliation.
• Automated ETL processes using SQL Server, C#, Visual Studio and Microsoft Excel, improving efficiency.
• Supported migration of Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets and Master Data.
• Supported Finance Master Data, transactional and reference data.
• Worked with project teams to resolve migration issues.
• Supported SIT, UAT and Cutover by providing validated migration datasets and reconciliation reporting.
• Produced migration documentation including mapping specifications, transformation rules, validation procedures and Data Quality metrics.

Microsoft Dynamics 365 Finance (D365), Data Migration and +14 skills

Reported to the ERP Global Data Lead, delivering Data Migration for a global SAP Ariba Contract Lifecycle Management (CLM) transformation. Led migration from two legacy Legal Document Management Systems (French and English) into SAP Ariba Contract Workspaces, ensuring legal documents and metadata were successfully migrated to support enterprise contract management.
This was my second consecutive SAP Ariba programme, building on previous Supplier Enablement experience to deliver specialist Contract Lifecycle Management migration expertise.

Key Responsibilities

• Led Data Migration activities for SAP Ariba Contract Lifecycle Management.
• Collected, analysed, profiled and validated data from two legacy Legal Document Management Systems.
• Planned and managed migration of more than 105,000 legal documents into approximately 65,000 SAP Ariba Contract Workspaces.
• Mapped, transformed and reconciled legal documents, metadata and contract information.
• Defined transformation rules and migration mappings between legacy systems and SAP Ariba.
• Performed data cleansing, validation, reconciliation and migration quality assurance.
• Worked with business stakeholders, legal teams and technical specialists to resolve migration issues and improve data quality.
• Supported migration planning, testing, reconciliation, UAT and production deployment.
• Produced migration statistics, progress reporting and data quality metrics.

Key Achievements

• Successfully migrated over 105,000 legal documents into 65,000 SAP Ariba Contract Workspaces.
• Delivered high-quality legal document and metadata migration supporting enterprise Contract Lifecycle Management.
• Improved migration quality through structured validation, reconciliation and data quality controls.
• Built on previous SAP Ariba Supplier Enablement experience to deliver a second successful enterprise SAP Ariba implementation.

SAP Ariba, SAP S/4HANA and +23 skills

Reported to the SAP Programme Leadership Team, delivering Data Migration and Supplier Enablement for a global SAP Ariba transformation programme. Responsible for migrating Supplier and Vendor Master Data from SAP ECC into SAP Ariba, ensuring high-quality master data supported supplier onboarding and procurement operations.

Working closely with Procurement teams, Business Users and Suppliers, I improved data quality, accelerated supplier onboarding and supported a successful global programme rollout.

Following the Pilot Go-Live, I continued supporting Supplier Enablement, assisting suppliers through onboarding and resolving data quality and registration issues to maximise SAP Ariba adoption.

A key contribution was automating supplier communications using Microsoft Excel VBA and Microsoft Access VBA. I developed mail merge solutions to distribute Vendor Master Data forms, collect updated supplier information and reduce manual administration, improving supplier response rates and master data quality.

I performed data collection, profiling, validation, cleansing, transformation, harmonisation and reconciliation, working with business and technical stakeholders to ensure migration readiness and successful deployment.

To strengthen my expertise, I personally funded and completed the SAP Ariba Supplier Management Certification, expanding my knowledge of SAP Ariba, supplier lifecycle management and enterprise procurement.

Key Responsibilities

• Led Supplier and Vendor Master Data Migration from SAP ECC to SAP Ariba
• Performed Data Collection, Profiling, Validation and Cleansing
• Defined Transformation and Harmonisation Rules
• Automated Supplier Communications using Excel VBA and MS Access VBA
• Supported SAP Ariba Supplier Enablement following Pilot Go-Live
• Improved Data Quality with Procurement, Business Users and Suppliers
• Performed Data Validation, Reconciliation and Reporting
• Supported successful SAP Ariba deployment

Data Migration, Metadata Migration and +21 skills

Reported to the IBM Programme Director, supporting Yara's global SAP transformation programme during the SAP Blueprint Phase. Engaged as SAP Global Data Lead to define the Data Migration Strategy and Master Data Management (MDM) approach ahead of the SAP Realisation phase.
Working closely with IBM, Yara Programme Leadership and senior business stakeholders, I produced two of the programme's 172 Blueprint documents covering the SAP Data Migration Strategy and SAP Master Data Management (MDM) Approach.
These were among the first Blueprint deliverables approved by members of the SAP ASAP Methodology consultancy board before being adopted by the Yara programme. They established the governance, standards and strategic approach that would underpin the future migration workstreams.
Working alongside the Client SAP Programme Lead, I also assisted in interviewing and selecting the SAP Data Migration Lead Consultant for the implementation phase, ensuring alignment with the agreed Blueprint strategy. Following appointment, I worked closely with the successful consultant to provide knowledge transfer and support a smooth transition into programme delivery.
This strategic assignment focused on planning, governance, methodology and stakeholder engagement, complementing my extensive hands-on SAP Data Migration and ETL delivery experience gained across previous international SAP programmes.

Key Achievements & Responsibilities

• Produced the SAP Data Migration Strategy Blueprint
• Produced the SAP Master Data Management (MDM) Approach Blueprint
• Contributed to the SAP Blueprint Phase of a global SAP transformation programme
• Worked with IBM Programme Leadership and Yara stakeholders
• Applied SAP ASAP Methodology and best practices
• Defined governance, standards and migration approach for the Realisation phase
• Supported recruitment of the SAP Data Migration Lead Consultant
• Provided strategic knowledge transfer into programme delivery

SAP Global Data Lead, SAP Data Migration Strategy and +9 skills

Reported to the ERP Programme Leadership on a major enterprise transformation programme for Equinor (formerly Statoil), delivering the migration of operational and business data from SAP into Oracle ERP across one of the world's largest integrated energy companies.
Working as an ERP Data Migration Consultant, I analysed complex legacy SAP data, defined business transformation rules and developed repeatable ETL processes supporting multiple migration cycles. The programme involved business-critical operational and commercial data supporting more than 1,800 fuel stations, working with business stakeholders, Oracle consultants and technical teams.
I developed automated extraction, transformation and validation processes that improved migration quality, repeatability and auditability. Legacy SAP data was profiled, cleansed, transformed, reconciled and validated before loading into Oracle ERP, supported by exception reporting that enabled business users to resolve issues before each migration rehearsal.
Throughout the project I supported migration planning, data mapping, trial loads, reconciliation, defect resolution and production readiness activities. I worked closely with business SMEs and technical teams throughout System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-Live preparation, ensuring migrated data met agreed business rules and quality standards.

Key Responsibilities

• SAP Data Analysis & Profiling
• Oracle ERP Data Preparation
• Data Mapping & Transformation
• ETL Development & Automation
• Data Quality & Cleansing
• Data Validation & Reconciliation
• Migration Trial Loads
• System Integration Testing (SIT)
• User Acceptance Testing (UAT)
• Go-Live Readiness
• Stakeholder Engagement

This project strengthened my SAP-to-Oracle ERP Data Migration experience within the global energy sector, where data quality, governance, automation and repeatable migration processes were critical to successful delivery.

Reported to the Client's ERP Data Migration Lead on a global SAP transformation programme delivering Legacy-to-SAP Data Migration activities across Ireland, India and Indonesia. The assignment began with programme mobilisation in Ireland before supporting delivery teams onsite in India and Indonesia, working with business stakeholders to successfully migrate legacy business data into SAP.
The business had already completed the population of SAP upload templates, allowing my role to focus on validating data before loading, executing SAP LSMW migration activities and performing validation after loading to ensure each Data Object achieved successful business sign-off.
Working across multiple migration cycles, I analysed migration results, investigated loading errors, reconciled uploaded data and worked with business users to resolve data quality issues before subsequent migration rehearsals. Validation reports and reconciliation outputs were presented in Microsoft Excel, the preferred reporting format for stakeholders, enabling rapid review and approval throughout the migration lifecycle.
Throughout the project I supported Validation Before Loading (VBL), SAP LSMW data loading, Validation After Loading (VAL), reconciliation, defect resolution and business sign-off activities while ensuring migration quality and consistency across multiple SAP Data Objects.

Key Responsibilities

• Legacy Data Validation
• Validation Before Loading (VBL)
• SAP LSMW Data Migration
• Validation After Loading (VAL)
• Data Reconciliation
• Data Quality Assessment
• Error Investigation & Resolution
• Business Data Sign-Off
• Microsoft Excel Reporting
• SQL Analysis
• Stakeholder Engagement

This assignment further strengthened my international SAP Data Migration experience, delivering successful migration activities across multiple countries while ensuring high-quality business data, repeatable migration processes and successful Data Object sign-off throughout the SAP implementation programme.

ERP Data Migration, SAP Data Migration Strategy and +41 skills

Reported to the Director of a specialist SAP consultancy on an urgent SAP implementation programme for MYLAN (now Viatris), supporting Legacy-to-SAP Data Migration activities within a highly regulated pharmaceutical environment. Following a late Sunday request, I travelled to Brussels and was onsite by 9:20am Monday morning to help the programme achieve a successful Go-Live.
Working as a hands on SAP Data Migration Consultant, I immediately integrated into the project team, assisting with Data Migration, Data Validation, Data Quality, reconciliation and issue resolution across multiple SAP Data Objects. Operating within a GxP regulated environment, I ensured migration activities complied with pharmaceutical quality standards while helping the project overcome critical delivery challenges during the final stages before deployment.
Working closely with business users, SAP consultants and technical teams, I investigated migration issues, validated uploaded data, resolved data quality problems and supported business sign-off throughout successive migration cycles. My contribution helped reduce delivery risk while improving confidence in migrated data ahead of production deployment.
Following the successful Go-Live, I remained on the programme providing daily reporting directly to the Chief Pharmaceutical Officer (CPO), supporting ongoing SAP Quality Management (QM) activities until outstanding operational issues had been resolved.

Key Responsibilities

• SAP Data Migration
• Data Validation
• Data Quality
• Data Reconciliation
• Data Cleansing
• Legacy Data Migration
• SAP Quality Management (QM)
• GxP Compliance
• Business Sign-Off
• Go-Live Support
• Executive Reporting
• Stakeholder Management

This assignment strengthened my experience delivering SAP Data Migration within the pharmaceutical sector, combining hands on migration expertise with GxP best practices, executive reporting and post-Go-Live operational support to ensure a successful business transition into SAP

Data Migration, SAP ERP and +17 skills

Reported to the Director of a specialist Data Migration consultancy, supporting SAP Data Migration activities for Sulzer Pumps on a major enterprise transformation programme. Working within a SAP migration team, I was responsible for SAP LSMW data loading, validation and reconciliation, ensuring each Data Object achieved business sign-off before progressing through the migration lifecycle.
The legacy data had already been extracted and transformed, allowing my role to focus on Validation Before Loading, SAP LSMW uploads, Validation After Loading and resolving loading errors until every Data Object had been migrated. Working with business users and technical teams, I investigated migration issues, corrected upload errors and repeated migration cycles until data accuracy had been achieved.
A significant part of the assignment involved uploading SAP Document Information Records (DIR) with CAD documentation, ensuring engineering documents were accurately linked within SAP. This required validation, reconciliation and quality assurance to maintain document integrity throughout the migration process.
Throughout the project I supported Data Validation, reconciliation, defect resolution, business sign-off and production readiness while ensuring migration quality across SAP Data Objects. My contribution delivered accurate, repeatable migration processes that reduced delivery risk and supported SAP implementation.

Key Responsibilities

• SAP Data Migration
• SAP LSMW
• Validation Before Loading
• Validation After Loading
• Data Validation
• Data Quality
• Data Reconciliation
• Document Information Records (DIR)
• CAD Document Migration
• Error Investigation & Resolution
• Business Data Sign-Off
• Stakeholder Engagement

This assignment strengthened my SAP Data Migration expertise, delivering accurate SAP LSMW loading, validation, reconciliation and engineering document migration while ensuring high-quality business data and Data Object sign-off throughout the SAP implementation

Reported to the SAP Programme Financial Lead on a global SAP transformation programme delivering Financial Data Migration across 18 countries and 20 company codes. Working remotely, I coordinated Data Migration activities across international workstreams, ensuring migration progress remained aligned with programme milestones and Go-Live objectives.
This assignment focused on Data Migration governance, programme coordination and reporting rather than hands-on ETL development. Acting as the link between business stakeholders, offshore development teams and SAP programme leadership, I monitored migration progress, tracked outstanding actions and ensured delivery remained on schedule using a Follow-the-Sun model.
My working day commenced at 2:00am UK time to align with the Singapore programme office, participating in migration planning meetings and hourly progress reviews. Working with offshore ETL developers and country representatives, I coordinated migration activities, monitored risks, escalated issues and maintained communication throughout the programme.
The assignment covered Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Pre-Go-Live and Go-Live. Microsoft Project and Excel were used for programme visibility, executive reporting and decision support across teams.

Key Responsibilities

• SAP Data Migration
• Data Migration Governance
• Programme Coordination
• Project Management
• Financial Data Migration
• Data Migration Reporting
• Global Programme Delivery
• Follow-the-Sun Delivery
• Offshore Team Coordination
• Risk & Issue Management
• Unit Testing
• System Integration Testing (SIT)
• User Acceptance Testing (UAT)
• Pre-Go-Live
• Go-Live
• Microsoft Project
• Stakeholder Management

This assignment strengthened my leadership experience by coordinating SAP Financial Data Migration across 18 countries and 20 company codes, delivering governance, reporting and international team coordination supporting successful SAP implementation

Reported to the SAP Data Migration Lead on a major SAP transformation programme supporting the integration of an acquired business into the Heineken SAP landscape. Within the SAP Data Migration team, I prepared, validated and transformed legacy financial data into the required SAP upload format, ensuring high data quality throughout the migration lifecycle.
The assignment involved receiving legacy business data together with SAP upload templates and agreed business transformation rules. Using Microsoft Access, VBA, SQL and Microsoft Excel, I developed automated solutions to transform legacy data into the required SAP upload structures, reducing manual effort while improving consistency, repeatability and migration quality.
Working closely with business stakeholders and the Systems Integrator, I validated migration data, resolved transformation issues and ensured Data Objects complied with agreed business rules before progressing through migration cycles. My work improved migration accuracy, supported business sign-off and reduced delivery risk before production deployment.
I also supported Data Validation, Data Transformation, Data Quality, reconciliation and business sign-off, ensuring migration outputs met programme quality standards. The transformed datasets were delivered in the required SAP upload format, enabling successful loading by the Systems Integrator and supporting the successful integration of the acquired business into Heineken's SAP environment.

Key Responsibilities

• SAP Data Migration
• Data Transformation
• Data Validation
• Data Quality
• Data Reconciliation
• Financial Data Migration
• Microsoft Access
• VBA Development
• SQL
• Microsoft Excel
• Business Sign-Off
• Stakeholder Engagement

This assignment strengthened my SAP Data Migration experience by delivering automated transformation solutions, improving migration quality, reducing manual effort and supporting the successful integration of an acquired business into the Heineken SAP landscape.

Reported to the HCL Axon Head of Consulting Services and the ERP Programme Manager on one of the UK's largest SAP business transformation programmes. Having previously delivered a successful SAP engagement for HCL Axon, I was invited back to lead the SAP Data Workstream during the mobilisation phase of Thames Water's SAP implementation.
My primary responsibility was to define the SAP Data Migration Strategy, Data Workstream Approach and Data Governance framework. Working closely with programme leadership and business stakeholders, I produced blueprint documentation establishing the migration methodology, governance, planning approach and best practices for the programme.
The assignment focused on defining how data would be identified, analysed, transformed, validated, migrated and signed off across multiple business areas. This included establishing data object scope, migration lifecycle, governance, business ownership, risks and reporting before technical migration activities commenced.
Working within the SAP ASAP Methodology, I helped define the migration principles supporting ETL development, testing, reconciliation, business validation, SIT, UAT and production deployment.
At the time, this represented HCL Axon's largest UK SAP programme, supporting Thames Water's transformation serving approximately 14 million customers.

Key Responsibilities

• Led the SAP Data Workstream during programme mobilisation
• Produced the SAP Data Migration Strategy and Blueprint documentation
• Defined Data Governance and migration best practices
• Planned Data Object scope, ownership and migration approach
• Worked with Programme Management, Business Leads and SAP stakeholders
• Applied SAP ASAP Methodology throughout planning activities
• Defined migration lifecycle including validation, reconciliation and business sign-off
• Supported programme planning, risk management and delivery governance

Reported internally to the BOA European Director and externally to the client's SAP Data Migration Lead in the USA, supporting a major legacy-to-SAP transformation programme for ECOLAB in Germany.

Recruited as a new UK member of the European BOA delivery team, I provided hands-on Data Migration, ETL and SQL expertise using the BOA/Syniti migration toolset. The assignment involved working across international business, functional and technical teams to prepare legacy data for migration into SAP.

My responsibilities covered data extraction, transformation, validation, cleansing and migration preparation, ensuring data was converted into the required SAP structures and met agreed programme quality standards.

Using SQL and the BOA/Syniti ETL platform, I supported repeatable transformation processes, investigated data quality issues and helped resolve migration defects before data progressed through the programme's testing and loading cycles.

The programme was a large-scale international SAP transformation with an estimated delivery burn rate of around €5M per month. This required disciplined delivery, clear issue reporting and close collaboration with programme stakeholders to avoid delays and reduce migration risk.

The assignment strengthened my BOA/Syniti expertise, which became an important part of my SAP Data Migration, Master Data Management and Data Governance background.

Key Achievements & Responsibilities

• Delivered hands-on legacy-to-SAP Data Migration activities
• Developed and supported ETL and SQL transformation processes
• Used the BOA/Syniti toolset for migration preparation and processing
• Performed data validation, cleansing and quality remediation
• Investigated migration issues and supported defect resolution
• Worked with international SAP, business and technical teams
• Supported migration testing, readiness and delivery reporting
• Contributed to a major high-value SAP transformation programme

Reported to a Capgemini Programme Lead and Director on a major legacy-to-SAP transformation programme for CORUS, now part of Tata Steel. I worked as a hands-on SAP Data Migration Consultant and Data Analyst supporting data preparation, validation, loading and reconciliation.
IBM DataStage was the principal ETL platform for extracting, transforming and preparing legacy data. My role focused on downstream migration and upload activities, ensuring each data object was complete, correctly formatted and ready for loading into SAP.
I performed Validation Before Loading to identify data quality, formatting, mapping and referential integrity issues before migration cycles. Working with the ETL, business and SAP teams, I investigated errors, clarified transformation requirements and supported correction of rejected or incomplete records.
I also supported SAP LSMW uploads and performed Validation After Loading to confirm migrated records had been created correctly in SAP. This included reviewing load results and error logs, reconciling source and target totals, preparing status reports and supporting business sign-off.
The assignment required data analysis, SQL, ETL knowledge, SAP migration expertise and stakeholder coordination. My work helped improve migration quality, reduce upload failures and provide evidence that data objects were ready for approval.

Key Responsibilities

• Legacy-to-SAP Data Migration
• Data Analysis and Data Quality Validation
• Validation Before Loading
• SAP LSMW Upload Support
• Validation and Reconciliation After Loading
• Error Analysis and Resolution
• Source-to-Target Data Checking
• Migration Reporting and Business Sign-Off
• Coordination with ETL, SAP and Business

Technologies

Reported to a specialist ERP Consultancy Director and the client's IFS Data Migration Lead on a major SAP-to-IFS ERP transformation programme for Maersk Drilling in Denmark. This was my first IFS ERP implementation, working alongside IFS specialists from Sweden and Denmark.
Working as a hands-on ERP Data Migration Consultant, I supported the migration of multiple business data objects from SAP into IFS. My responsibilities included analysing legacy data, developing SQL-based ETL solutions, validating migration outputs and preparing data for loading into the new ERP environment.
Working closely with business users, technical consultants and the IFS migration team, I investigated data quality issues, applied agreed business transformation rules and improved the accuracy and consistency of migration data throughout testing cycles. As project demand increased, I shared the ETL and SQL development workload with another migration consultant, helping the team respond more quickly to changing business priorities.
The assignment covered Data Extraction, Data Transformation, Data Validation, Data Cleansing, Data Reconciliation and migration support through Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-Live preparation.
The role strengthened my knowledge of IFS ERP while expanding my experience of SQL development, ETL processes and international ERP Data Migration projects within the engineering and energy sector.

Key Responsibilities

• SAP to IFS ERP Data Migration
• SQL Development and ETL Processing
• Legacy Data Analysis and Transformation
• Data Validation and Data Quality Improvement
• Data Cleansing and Reconciliation
• Migration Testing Support (Unit Test, SIT & UAT)
• Business Data Analysis
• Technical Documentation and Reporting
• Stakeholder Collaboration

Technologies

OCS · Contract

Jan 2008 - Jan 2009 · 1 yr 1 mo

Hybrid

OCS
SAP Data Migration Team Lead
Contract · United Kingdom
2008
Reported to the Director of a specialist SAP Consultancy and the Client's Head of IT Services on a major SAP CRM implementation. I prepared and presented the SAP Data Migration proposal to the client and SAP, with our solution selected from four competing bids.
Appointed as SAP Data Migration Team Lead, I was responsible for planning and coordinating the migration of customer and business partner data from more than 50 legacy database versions together with two additional legacy systems into SAP CRM.
Working with business stakeholders, I defined migration requirements, coordinated data mapping and recruited two SAP LSMW Developers. I also coordinated SQL and ETL development to extract, transform, validate and prepare migration data.
The project involved Data Extraction, Data Transformation, Data Validation, Data Cleansing, SAP LSMW loading, Data Reconciliation and support throughout Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Final Go-Live Testing and Production Go-Live.
The implementation introduced SAP CRM Business Partners, including Sold-To, Ship-To, Bill-To and Payer relationships together with customer marketing attributes. The assignment combined technical delivery, team leadership, stakeholder management and project planning to deliver a successful SAP CRM implementation.

Key Responsibilities

• SAP CRM Data Migration Team Lead
• Legacy-to-SAP CRM Data Migration
• SAP LSMW Planning and Coordination
• SQL and ETL Development Coordination
• Data Mapping and Transformation Rules
• Data Validation and Data Reconciliation
• Unit Testing, SIT, UAT and Go-Live Support
• Team Leadership and Stakeholder Management
• Migration Planning and Reporting

Technologies

SAP CRM, SAP LSMW, Microsoft SQL Server, T-SQL, ETL, Excel, Data Migration, Data Validation, Data Mapping, Business Partners, CRM Master Data

Reported to the Head of SAP Services on a major SAP Disaster Recovery programme supporting one of the world's largest SAP environments. My role was to plan, coordinate and validate Disaster Recovery activities to ensure critical SAP systems and business data could be recovered successfully in the event of a major data centre outage.
Working closely with SAP Infrastructure, Basis, Technical and Business teams, I helped define recovery procedures, planned large-scale Disaster Recovery exercises and coordinated the execution of full recovery tests between the primary data centre in Frankfurt and the Disaster Recovery site in Bussigny, Switzerland.
The assignment involved detailed planning, coordination, execution and validation of complex recovery activities across multiple SAP landscapes. During two full Disaster Recovery tests performed over a six-month period, the recovery process successfully restored the SAP environment with only approximately 130 IDoc messages requiring manual recreation, demonstrating an exceptionally high recovery success rate considering the scale of the environment.
The role required strong planning, stakeholder coordination, risk management and technical understanding of SAP system architecture, business continuity and Disaster Recovery best practices. My work helped provide confidence that critical SAP business systems could be recovered within agreed recovery objectives while minimising operational risk.

Key Responsibilities

• SAP Disaster Recovery Planning
• Business Continuity Planning
• Disaster Recovery Testing
• Recovery Coordination and Validation
• SAP Infrastructure Planning
• Cross-Functional Stakeholder Coordination
• Recovery Reporting and Documentation
• Risk Reduction and Business Assurance
• SAP Recovery Test Execution

Technologies

Reported to the SAP Data Migration Lead on a UK SAP implementation programme delivered by Accenture. Working as part of the SAP Data Migration team, I supported the migration of legacy business data into SAP, ensuring data quality throughout the migration lifecycle.
My primary responsibility was SAP LSMW data loading together with Validation Before Loading and Validation After Loading activities. I worked closely with the Data Transformation team to identify data quality issues, analyse upload errors and ensure migration files complied with agreed business rules before progressing through successive migration cycles.
Following each SAP LSMW load, I reviewed upload results, investigated rejected records and provided detailed feedback to the ETL and Data Transformation teams so corrections could be made before the next migration iteration. This iterative approach helped improve migration quality and reduce loading errors as the project progressed towards Go-Live.
The assignment involved Data Validation, Data Cleansing, Data Reconciliation, migration testing and business support throughout Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) and Production Go-Live. Working closely with functional consultants, business users and the migration team, I helped ensure each Data Object achieved the required quality standards before business sign-off.

Key Responsibilities

• SAP Data Migration
• SAP LSMW Data Loading
• Validation Before Loading
• Validation After Loading
• Data Quality Analysis
• Error Investigation and Resolution
• Data Reconciliation and Business Sign-Off
• Unit Testing, SIT, UAT and Go-Live Support
• Stakeholder Collaboration

Technologies

Reported to the HCL Axon Client Account Manager on a SAP implementation for Transport for London's Occupational Health and Environment, Health & Safety (EH&S) programme. I joined the project after two previous migration attempts had failed and was tasked with redesigning the ETL process to deliver a successful migration.
Working as a hands-on SAP Data Migration Consultant, I analysed legacy data, redesigned the SQL-based ETL solution and developed an improved migration process that significantly increased data quality, reliability and repeatability. The revised solution successfully transformed and prepared legacy data for loading into SAP, enabling the programme to progress after earlier delivery issues.
My responsibilities included Data Extraction, Data Transformation, Data Validation, Data Cleansing, Data Enrichment, Data Reconciliation and supporting migration activities throughout Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-Live preparation.
Working closely with business users, technical consultants and project stakeholders, I investigated migration issues, documented transformation rules and implemented improvements that reduced manual effort while improving migration accuracy and consistency.
The assignment strengthened my expertise in SQL development, ETL design and end-to-end SAP Data Migration, demonstrating the ability to recover challenging migration projects and deliver practical technical solutions under demanding programme conditions.

Key Responsibilities

• End-to-End SAP Data Migration
• SQL Development and ETL Design
• Data Extraction and Transformation
• Data Validation and Data Cleansing
• Data Enrichment and Reconciliation
• Migration Testing (Unit Test, SIT & UAT)
• Go-Live Preparation and Support
• Technical Problem Solving
• Stakeholder Collaboration

Technologies

Reported to the SAP Data Migration Lead on a major SAP transformation programme in the Middle East, supporting the consolidation of 19 SABIC affiliate companies into a single SAP landscape. This was my first SAP Data Migration assignment and marked the beginning of my specialist ERP Data Migration career.
I identified an opportunity to improve migration quality by validating business data before SAP loading. To achieve this, I designed and developed a bespoke application that reverse engineered SAP referential integrity rules and automatically validated migration data before upload.
Developed using C#.NET, Microsoft .NET Connector, Microsoft SQL Server and WinForms, the solution analysed over 10 million business records, increasing performance from around 100 validation checks per second to approximately 4,000 per second. It identified data quality issues, missing relationships and integrity failures before migration cycles, reducing manual investigation and improving migration quality.
The solution introduced a proactive Validation Before Loading approach that reduced migration risk, improved data quality and accelerated business data correction before SAP uploads. The techniques developed during this project became the foundation of the migration methodology I have applied throughout more than 34 ERP Data Migration projects across 20 countries.

Key Responsibilities

• SAP Data Migration
• Validation Before Loading Solution Design
• C#.NET Software Development
• SQL Development and Performance Optimisation
• Reverse Engineering SAP Referential Integrity
• Data Quality and Data Validation
• Migration Risk Reduction
• Legacy Data Analysis and Transformation
• Technical Design and Automation

Technologies