Mark Dicken

Available Now

Bridgestone - SAP Data Migration & Ariba Supplier Enablement Consultant - Brussels, Belgium

Providing Data Migration activities to Migrate from Legacy SAP ECC 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. Assisting 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. Assisting with matching data to SAP Ariba Flight Plan. Studying SAP ARIBA Supplier Management Certification and exam soon.

Skills Used: Skill1, Skill2, Skill 3

Riwal - Oracle Netsuite Data Migration Lead / Developer - Netherlands

Data Migration activities for a renting / leasing company who operates in 18 countries. Legacy Systems included off the shelf software + bespoke + Sage and migrating to Oracle Netsuite 2019.1 brought in to assist with data mappings for AUE and gave late in the day help for Spain Go-Live.

Skills Used: Skill1, Skill2, Skill 3

Vianet - ETL Data Migration & SSIS / SSRS Developer (SQL / ETL / Reporting) - UK

Helping a company to put in place the Data Migration automated scripts to move across 80 existing customers to a new data collection platform collecting Internet of Things (IoT) data collecting over 1 Petabytes of Data per year based on Millions of Pints and Alcohol Drinks sold on a Daily basis covering multiple countries.

Skills Used: Skill1, Skill2, Skill 3

NHS - Welsh NHS, SSIS Developer (SQL / ETL / Reporting) - Wales, UK

SSIS / ETL / SQL Developer. Importing and collecting data from CSV file formats then providing reports and statistics. Normalising data for reporting purposes.

Skills Used: Skill1, Skill2, Skill 3

Applegreen - ERP Data Migration Project Manager, (SAP S/4HANA RETAIL) - Dublin, Ireland

Brought on board to help with Data Migration during SIT (System Integration Testing) whilst they were replacing their chosen Systems Integrator. Daily Data Migration Project Management and Reporting for 41 SAP Retail Data Objects. Provided Validation Before Loading and Reconciliation After Loading to help with Validation/Signoff. Produced a daily plan on a page for the 27 SAP Consultants and produced an automated daily MS Project to Excel (RAG) Report using C# / VBA.

Skills Used: Skill1, Skill2, Skill 3

JLL - Data Migration Senior Consultant (Peoplesoft) - Warsaw, Poland

Here I was hired to assist with Validation Before Loading and Reconciliation After Loading for half a dozen PeopleSoft Financial Data Objects. Providing Record Counts and Balance Checks with Details/Checks/Errors. SQL, Excel, PeopleSoft Data.

Skills Used: Skill1, Skill2, Skill 3

BMA - BMA/BMJ, MS NAV 2018 ERP Financials Data Mig - London, UK

Brought on board by the CIO to assist them in Data Migration activities. I Extracted Legacy Data, Collected Data Mapping Rules and created repeatable Data Transformation Rules to provide the in-scope Data Objects in the correct format for uploading via Webservices or RapidStart format. MS SQL Server, SSIS, Data Reconciliation & Red/Green Reporting/Validation. MS Visual Studio.

Skills Used: Skill1, Skill2, Skill 3

Warwick University - Success Factors HR Data Mig - Warwick, UK

Brought on board by the SAP Success Factors Project Manager to complete unfinished work by the current data team. Collected Source Data and created/performed ETL Rules for Uploading and Testing. Because the system architecture was 50% on premise and 50% off premise in the cloud this caused challenges with data replication issues which we had to deal with (data pain).

Skills Used: Skill1, Skill2, Skill 3

TCS SAP Consultancy & Axalta Paints Company - ERP/SAP ETL Developer - Wuppertal, Germany

Assisted within a Switzerland and Germany Mergers & Acquisition Project, here I was asked to create a soft coded Rules Based ETL Tool to perform Extraction, Profiling, Transformation, Validation Before Loading, Validation / Reconciliation After Loading. Approx. one dozen Data Objects. Very much a Data Migration Consultancy Role with plenty of hands on Programming / Developing. Used C#, Visual Studio, MS SQL Server / SSMS & .NET. Provided Red-Green Reporting. Data Objects: Master & Transactional Data, Visual Studio / C# / MS SQL / ETL / .NET.

Skills Used: Skill1, Skill2, Skill 3

ERP Consultancy & COSTA Coffee (UK No 1 Coffee Company) - ERP Data Migration Consultant & Data Lead - UK

Data Lead for COSTA Coffee (the UK number one coffee company) to migrate customers to a new Customer Loyalty System (Loyalty accounts for 55% of all transactions and revenue)

Data Objects: Master & Reference Data … and 1500+ Purchase Transactions per Minute

Skills Used: Skill1, Skill2, Skill 3

KPMG & Celesio (Pharma/Retail), ERP/SAP Global Data Lead - Stuttgart, Germany

For KPMG (SAP systems integrators) working on a global template design and rollout I created the ERP Data Migration Strategy and Approach. Identified around 100 In-Scope Data Objects.

Data Objects: Master Data, Transactional Data, Historic Data, SAP Data Services / BODS

Skills Used: Skill1, Skill2, Skill 3

Staples - SAP Data Services (BODS) Data Migration. Cons - Stuttgart, Germany

Extracted 2.2 million legacy AS400 customers and uploaded 348,000 ‘good’ customers to SAP. Performed Data Harmonisation between five Legacy & Reporting Systems. Red/Green Reporting.

Data Objects: Customer Master Data (From 2.2 million to 348K)

Skills Used: Skill1, Skill2, Skill 3