Data Migration Erp

Mark Dicken, ERP (SAP & Non SAP) Data Migration Consultant UK Mob +44(0)778*-***-***

Specialising in Legacy to New System / ERP Data Migration Projects, works within the ‘Data Team’, Data Transformation & ETL / SQL

SAP & Non-SAP Data / ERP Data Migration Consultant (Data Team)

Legacy ERP Data Extraction, Transformation, Harmonisation, Validation, Loading, Reconciliation / Cleansing, also GxP PHARMA

Key Skills: ERP (SAP & Non SAP) Data Migration Projects

SAP & Non-SAP Data / ERP Data Migration Consultant since 2001

34+ ERP Data Migration Projects, 20 Countries, 6 PHARMA GxP Projects

SAP Classic ECC 4.6/6.0 to SAP S4C (Cloud), SAP ARIBA, SAP SuccessFactors, Microsoft Dynamics 365, IFS, Oracle NetSuite, Oracle PeopleSoft, Bespoke / Other

Config Data, Master Data, Finance Data, Transactional Data, Historic Data, Archiving Data

Customers, Materials, Vendors, BOMs, HR, MM, FI/CO, CRM, Leasing, Other Data Objects

Extracting Data from Any Format and Any Legacy Systems, Data Transformation / SQL and Scripting, Pro-Active Data Validation Before Loading, Data Loading, Uploading History, Archiving, Validation and Reconciliation After Loading, Sign-Off, After Care Hyper Care

ERP Data Migration Consultancy from Junior to Team Lead, Many Times Data Analyst

MS SQL Server (2000 to 2022), MS Access, ETL Tools, SAP Data Services, SSIS, Talend

Blueprint Documentation, Data Object Project Planning & Definition

Successful SAP/ERP Data Migration Bidder, Experienced Senior Data Migration Consultant

Worked for Software Vendors & Transformation Consultancies & End Clients & PHARMA

SQL, C#.Net, MS SSIS (ETL), Visual Studio, VBA, Excel, MS Full Stack Developer Skills

Worked For Summary: ERP (SAP & Non SAP) Data Migration Projects

SAP Client Ascential, SalesForce.com to SAP S/4C Cloud Data & Integration Consultant

IFS Client Survitec, IFS ERP Data Migration (Technical), Remote (UK, USA, Germany)

D365 Client BMA/BMJ, Data Migration Consultant, London, UK

SAP ARIBA Client Eisai (PHARMA), SAP Ariba Data Migration Analyst (Technical),Remote

SAP ARIBA Client Bridgestone SAP Ariba Data Migration & Supplier Enablement Cons.

SAP Client YARA, via IBM, SAP Global Data Lead & Migration Consultant, Norway

SAP Client Equinor/Stat Oil, Data Migration Consultant / Data Analyst / ETL Cons., Norway

SAP Client CARGILL, Data Migration Consultant / Data Analyst / ETL, IE, India, Indonesia

SAP Client Viatris/MYLAN(PHARMA), SAP Data Migration Consultant, Belgium

SAP Client Sulzer Pumps, SAP Data Migration Consultant, Leeds, UK

SAP Client Nielsen, SAP Data Migration Consultant / Project Manager (Hand-Off), Remote

SAP Client Smith & Nephew (PHARMA), IBM AS400 to SAP Data Migration Consultant, DE

SAP Client Heineken, SAP Data Migration Consultant & SQL / ETL Analyst, Amsterdam

SAP Client Thames Water, HCL-Axon, SAP Data Workstream Lead & Data Migration, UK

SAP Client ECOLAB, BOA, SAP Data Migration & ETL / BOA Syniti Consultant, Germany

SAP Client CORUS, Cap-Gemini SAP Data Migration Consultant / Data Analyst, UK

IFS Client Maersk Drilling, IFS Data Migration Analyst & SQL / ETL Consultant, Denmark

SAP Client OCS, SAP Data Migration Team Lead, (Successful Bid in front of SAP), UK

SAP Client Nestle, SAP Data & Disaster Recovery Consultant, Switzerland

SAP Client Total, Accenture, SAP Data Migration Analyst & SAP LSMW Consultant, UK

SAP Client TFL, HCL-Axon, SAP Data Migration Analyst & SQL / ETL Consultant, UK

SAP Client SABIC, ATOS ME, SAP Data Migration & Validation Consultant, Saudi Arabia

Bespoke Client BT Directory Solutions, Data Migration & Cleansing Consultant, UK

Argos & GUS, Year 2000 MS Access Database Upgrade & Data Consultant, UK

Bespoke Life ERP Client, Caledonian Life, Euro Conversion Data Migration Analyst, Ireland

Banco Santander, Trading Room IT & Networking / Infrastructure Support, UK

DB Trader Client, Deutsche Bank, Data Reconciliation Consultant, AS/400 & SQL, Italy

British Petroleum, Trading Room IT & Infrastructure Support (Zone 1 Traders) London, UK

Bespoke Client, Network Rail, Data Migration Consultant, MS Access and SQL, UK

Macquarie Bank, IT Trading Room Support & Infrastructure Consultant, UK

Previous: UBS, Burton Group, HMIP, OFCOM, ICAEW, Unipart Group, Dairy Crest Group

Worked For Detailed: ERP (SAP & Non SAP) Data Migration Projects

Training, Microsoft Blazor UI 8.0 Training & IoT / Electronics Learning Nov 2025 to Present

Multiple Online Computer Based Training Content – Pluralsight.com & YouTube Learning Videos

Various Courses Beginner / Intermediate / Advanced. Created a Delivery Website for a Client

Skills Used: MS Blazor 8.0, ASP.NET CORE, MS SQL Server, Stored Procedures, EF-Core

Ascential, SalesForce.com to SAP S4C (Cloud) Data Migration/Integration 2023- Nov 2024

Reporting to the Solutions Architect and the Programme Platform Lead I was tasked to automate daily the collection of Sales Orders from SalesForce.com and upload to SAP S/4 HANA (Cloud) Service Contracts / Sales Orders. Data Collection, Data Manipulation and Transformation then Uploading. SIT, UAT, Go-Live and in the first 2 months processed over £5 Million in orders

Skills Used: SAP S4C/Cloud, ETL / Data Migration, SalesForce.com, MS SQL Server 2022, T-SQL, Excel, Visual Studio 2022, C# .Net, MS Access & VBA, Automation and Scripting

Survitec, IFS ERP Data Migration Lead Dec 2021 to Dec 2022

On this IFS ERP Project I reporting to both the Global Programme Lead and main Project Manager for this USA, UK and Germany project. Initially before I started the main issues was “Data” and I managed to shift the spotlight from data to the next stages of the implementation. I identified they had major data quality and disconnect issues between Engineering-BOMs and Manufacturing-BOMs so provided daily statistics and progress which went up the chain from Programme Lead to Chairman then to the six Company Shareholders. SIT, UAT, Go-Live. Data Objects was Config & Master Data / Financial Data Objects, AP, AR, Fixed Assets & BOM’s

Skills Used: IFS, ETL / Data Migration, Finance and other Module Data Objects, MS SQL Server 2019, ETL, Visual Studio 2022, SQL, Excel, C#, MS Access / VBA

BMA/BMJ, D365 ERP Data Migration Consultant May 2021 to Dec 2022

Reporting to the Chief Technology Officer on this Finance Business Transformation Project. I was brough onboard to assist with the Data Migration Activities from 3 Legacy Systems to Dynamics 365. I Collected the Legacy Data and working with the Business agreed the Transformation Rules for me to then Document and Transform as needed. I automated and provided daily extracts of all the required Data Objects in the correct format for Uploading. I provided Red / Green Reports on Data Quality and Cleansing including a cockpit Data Quality Report. After Data Uploading the Data was downloaded and reconciled which assisted in Sign Off.

Skills Used: D365, ETL / Data Migration, Finance and other Module Data Objects, MS SQL Server, Visual Studio 2022, SQL, Excel, C#

Eisai, SAP ARIBA Data Migration Consultant May 2020 to May 2021

Reporting to the ERP Global Data Lead, Providing Data Migration activities to Migrate from 2 Legacy Legal Document Systems (one French and one English) to SAP Ariba. Collection of 105K+ Legal Documents to be converted to 65K SAP Ariba Contract Workspaces. This was my second SAP ARIBA role in a row and instead of Supplier Enablement/ Onboarding this was Contract Workspaces and the associated documents plus meta data

Skills Used: SAP S4C – Cloud /SAP ARIBA (Supplier Onboarding), MS SQL Server 2019, ETL, Visual Studio 2022, SQL, Excel, C#, MS Access / VBA

Bridgestone, SAP ARIBA Data Migration & Ariba Supplier Enablement Cons. 2019/2020

Providing Data Migration activities to Migrate from Legacy SAP ECC Suppliers/Vendors to SAP Ariba. Data Collection, Data Validation, Data Cleansing/Harmonisation and Reporting. After the initial Pilot Go-Live providing SAP Supplier Enablement (on-boarding) Support. Assisted with Excel/VBA and MS Access/VBA to assist in Automation of email mail merging excel Vendor Master Data Forms to Vendors to update and collect required data needed by SAP Ariba. Later I personally paid the Certified Training of SAP ARIBA Supplier Management and passed the exam

Skills Used: SAP S4C – Cloud /SAP ARIBA (Supplier Onboarding), MS SQL Server 2019, ETL, Visual Studio 2022, SQL, Excel, C#, MS Access / VBA

YARA via IBM Global Data Lead, Oslo, Norway 2019

Reporting to the IBM Programme Lead (and Director) assisting YARA in implementing SAP. Here I produced 2 of the required 172 Blue-Print Documents for the SAP Data Migration Strategy & the SAP Master Data Management & Approach. This was the Blue-Print Pre-Work before bidding for the SAP Realisation Phase. My two documents were one of the first to be agreed by a member of the SAP ASAP Methodology board of Consultants and then after agreed for the YARA Project. Because I was also working closely with the Clients Yara SAP Programme Lead I assisted in interviewing an SAP Data Migration Consultant to represent the Clients interest. Then I naturally worked closely with the Clients SAP Data Migration Lead Consultant. Here this role was more of a Hand-Off Approach and More Project Management and Planning than previous Hands-On ETL and Data Migration / Data Analyst Roles which I have performed in the past

Skills Used: SAP Data Lead (Hands-Off), SAP Data Migration Document, SAP MDM Approach Document, Blue-Print Phase, SAP Data Services, SAP ASAP Methodology & Best Practices, IBM

Equinor/Stat Oil, ERP Data Migration Consultant / Data Analyst Oslo, Norway 2018

Reporting to the ERP Data Migration Lead from SAP to Oracle for the Downstream 1800+ Service Stations around the Nordics. I was tasked with Hands-On ETL/SQL Data Migr ation Activities. After Taking Initial taking Sample Legacy Data, I worked with the supplied New Upload File Format Documents then arranged Data Mapping Meetings with the Key Users where I would Document the Requirements before later performing the ETL/SQL & Data Transformation Activities then once a Version 1.0 was agreed then changes were made under change control. Working with the Key Users various Data Enrichment Spreadsheets were agreed and these files was used during the Transformation Process to improve Data Quality. Iteratively the results of each Data Object was gradually improved to be able to perform uploading for Unit Testing, SIT, UAT and Pre-Production Testing then final Go-Live. After Go-Live some Hypercare was given for a few weeks.

Skills Used: Data Migration Consultant / Data Analyst (Hands-On), ETL / SQL, Data Mapping Meetings, Documentation, Coding & Scripting, Upload Testing, Validation After Loading, Sign-Off

CARGILL, SAP Data Migration Consultant (Ireland, India & Indonesia). 2017

Reporting to the Client’s ERP Data Migration Lead I was tasked to assist in Legacy to SAP Data Migration Activities. Initial 2 days in Ireland followed by 1 Month in India then 1 Month in Kaula Lumpa / Indonesia. The business was already tasked to complete Uploading Templates so this was more about Validation Before Loading followed by SAP LSMW Uploading then I would perform Validation After Loading to help in getting all the Data Objects Signed-Off one by one. I presented all my output in Excel as this was the preferred format from the Business. Excel, SQL,

Skills Used: SAP LSMW, Excel, MS SQL Server, T-SQL, Microsoft Project, Cap Gemini

Viatris/MYLAN(PHARMA), SAP Data Migration Consultant, Waterloo, Brussels 2016

Reporting to a Small SAP Consultancy Director (After a 10PM Sunday Phone call I was onsite in Brussels at 09:20AM the next day Monday) I was tasked to help them with Legacy to SAP Data Migration Activities to “Just help them get over the live for Go-Live”. Because the MYLAN Client was a PHARMA Client then the usual GxP Best Practices needed to be applied. After the SAP Data Migration Project, I continued daily to provide the CPO (Chief Pharmaceutical Officer) with Daily Reporting due to some on-going internal SAP QM issues for several weeks till their QM issues were resolved.

Skills Used: SAP Data Migration (hands-On), MS SQL, T-SQL, Excel, Reporting, SSIS

Sulzer Pumps, SAP Data Migration Consultant, Leeds, UK 2015

Working for a “local” Non SAP Data Migration Consultancy I assisted in SAP LSMW Uploading for all the In-Scope Data Objects. The data was already prepared (Extracted and Transformed) and I uploaded all the Data Object and dealt with correcting errors till each object was loaded 100% so here I was performing Validation Before Loading and Validation After Loading to get each Data Object Signed off as Completed. Uploading of DIR (Document Information Records) / CAD Files

Skills Used: SAP LSMW, MS SQL, T-SQL, Excel, SAP Data Migration / Data Analyst

Nielsen, SAP Data Migration Consultant & Project Manager Remote (18 Countries) 2014

Reporting to the SAP Programme Financial Lead I was tasked to assist in the Legacy to SAP Data Migration of half a dozen SAP Financial Data Objects for 18 Countries and 20 Company Codes. Here this role was 100% Hands-Off so using more of my Project Management Skills. I was working Remote and my day locally started 2AM for me which was 9AM Singapore Time and we had Daily Meetings hourly to track progress. I had to work with Offshore Resources for the ETL Development and I maintained the current online status with Hourly “Follow The Sun” Meetings with different Countries. Unit Testing, SIT, UAT, Pre-Go Live and Go-Live

Skills Used: Microsoft Project, Project Management Reporting, Excel, Data Migration Reporting

Heineken, SAP Data Migration Consultant / Data Analyst 2013

Reporting to the SAP Data Migration Lead I assisted in onboarding a new acquisition. I was provided with the Legacy Data and the Upload Templates with the agreed ETL and Data Migration Rules Required. I programmed a technical solution as needed to populate the data into the required format for uploading and then this data was uploaded by their chosen Systems Integrator

Skills Used: MS Access, VBA, SQL, Excel, Financial AP & AR Data Object Data

Thames Water, HCL-Axon, SAP Data Workstream Lead 2012

Reporting to the HCL Axon Head of Consulting Services and the HCL ERP / SAP Project Manager I was invited to work for them a second time and this time to act as their SAP Data Workstream Lead. Here I was tasked to provide the SAP Data Migration Strategy & Approach Blue-Print Documentation which was day 6 of the start of their initial Mobilisation Phase. Provided the Best Practices of the SAP ASAP Methodology and Approach. This at the time was the largest project for UK HCL Axon assisting Thames Water in moving to SAP who had 14.1 Million Customers at the time

Skills Used: Non-Technical (Hands-Off), LSMW, Data Object Planning, Documentation, Blue-Print

ECOLAB, BOA, SAP Data Migration & ETL / BOA Syniti Consultant 2011

Reporting internally to a new BOA European Director and externally to the Clients SAP Data Migration Lead (From USA) I was brought on as a new UK Team member to assist ECOLAB in Germany with ETL/SQL and Data Migration Activities. Using ETL Toolset from BOA / Syniti. Large project where the “Burn Rate” was around EUR € 5 Million a Month

Skills Used: Legacy to SAP Data Migration (Hands-On), ETL/SQL, BOA / Syniti Toolset, Deloittes

CORUS, Cap-Gemini SAP Data Migration Consultant / Data Analyst 2010

Reporting to a Cap Gemini Programme Lead (and Director) I was tasked to assist in Legacy to SAP Data Migration Activities. Here IBM Data Stage was used to perform the ETL/SQL/Scripting type of activities and I was brought on board to assist with Uploading which included Validation Before Loading and Validation and Reporting After Loading for Sign-off

Skills Used: Legacy to SAP Data Migration (Hands-On), LSMW, MS SQL, T-SQL, ETL,

Maersk Drilling, IFS Data Migration Analyst & SQL / ETL Consultant, Denmark 2009

Reporting to a local Denmark Small SAP Consultancy Director and externally reporting to the Clients IFS Data Migration Lead I was tasked to help with SQL and ETL Data Migration Activities migrating from SAP to IFS for Maersk Drilling. This was my first introduction to IFS which at the time had a user base of over 250K users worldwide. I was working closely with the Sweden IFS Employees who drove weekly to the Denmark site in Lingby near Copenhagen. Working on a variety of different Data Object I helped and took the workload away from an original developer that was becoming flooded with requests so I was an extra set of ETL/SQL/Developer Data hands to distribute the workload between us.

Skills Used: ETL Data Migration (hands-On), MS SQL Server, SSMS, T-SQL, Excel, SAP to IFS

OCS, SAP Data Migration Team Lead, (Successful Bid in front of SAP), UK 2008

Reporting to a UK Small SAP Consultancy Director and externally reporting to the Client’s Head of IT Services I was tasked to help with the Legacy to SAP Data Migration Activities, New at the time was SAP CRM and we was using the latest version at the time where Customers become Business Partners with Sold-To, Ship-To, Bill-To and Payers with also Marketing Attributes. This role started with me creating an SAP Data Migration Bid Proposal that was jointly presented to the Client and also in-front of SAP Engagement Project Manager and amongst 4 proposals they requested myself and the Small Consultancy that I was representing. Collecting Data from 50 Legacy Systems (Versions) of a Database and 2 more Legacy Systems. I needed to hire 2 LSMW developers to created LSMW’s for Uploading and worked closely with 2 internal employees around the Legacy Systems and to co-ordinate the SQL Activities for ETL and Data Migration Scripting for the project. Unit Testing, SIT, UAT, Final Go Live Testing then Go-Live.

Skills Used: Data Object Planning, Project Management, Data Migration Lead, ETL/SQL/Scripting

Nestle, SAP Data & Disaster Recovery Consultant, Switzerland 2007

Reporting to the Head of SAP Services I was tasked to Plan and Coordinate a Disaster Recovery Strategy if a whole Data Center needed to be recovered to a backup Data Center Location of Bussigny in Switzerland. Nestle is the 10th Largest Worldwide Company so as you can guess the Data Volumes was enormous and I performed 1 test in 6 Months and did this twice for Frankfurt to Switzerland and from USA to Switzerland and we only identified a loss of just 130 IDOC documents that were then re-created as needed

Skills Used: Large Scale SAP Disaster Recovery, MS Project for Planning

Total, Accenture, SAP Data Migration Analyst & SAP LSMW Consultant, UK 2006

Reported to SAP Data Migration Lead providing SAP LSMW Uploading assistance for a UK Rollout. Giving Errors back to Transformation Team to make corrections

Skills Used: SAP Data Migration, SAP LSMW Uploading, Excel

TFL, HCL-Axon, SAP Data Migration Analyst & SQL / ETL Consultant, UK 2005

Reported to the internal Business Development Manager (Client Account Manager) I was tasked to assist in a Legacy to SAP Data Migration Project for Occupation Health & EH&S. After two previous failed attempts I succeeded so for the Client it was “Third Time Lucky”. Here I replaced a previous Consultant and quickly re-wrote the complete ETL process

Skills Used: MS SQL Server, ETL / T-SQL, Data Cleansing, Data Enrichment, End to End, Excel

SABIC, ATOS ME, SAP Data Migration & Validation Consultant, Saudi Arabia, 2003/2004

Provided a software solution to perform ERP / SAP Validation Before Loading (Reverse Engineered Referential Integrity Checking)

Skills Used: C#.Net, Microsoft Dot Net Connector, MS SQL Server, Winforms, ASP.Net

Training / Qualifications Certifications:

2024-2025: Ongoing Training – MS Full Stack Blazor 8+ .Net, C# 12, Visual Studio 2022, Entity Framework Core

2021-2023: Online Training – Various Subjects – Blazor.Net, ASP.Net Ongoing, C#, Visual Studio 2022

2020: Training - SAP ARIBA Supplier Enablement Certification (AR310, AR320, AR330), Now SAP ARIBA Certified

2019: MTA Microsoft Technology Associate (SQL Data Track)

2017: ETL Training x 3 (SAP Data Services 4.2, Informatica ETL 8.x / 9.x, MS SQL Server SSIS with Gold Partner)

2008: MCPD, MCTS x 4 (Including MS SQL Server)

2001: SAP R/3 ABAP/4 Training Academy (Singapore – Self Funded)

1998: MCP / Microsoft Certified Professional (six times)

Contact: Mark Dicken (Data Migration Consultant), End-To-End Data Migration, SQL,ETL,C#

Mark Dicken, ERP (SAP & Non SAP) Data Migration Consultant

UK Mob: +44(0)778*-***-***

WhatsAPP: +447***-***-***

Email: *****@**********.***

Nationality: British / UK Passport Holder

Available: 29rd January 2025

Contact this candidate