$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Ashley Johnson
,
Experience
Other titles
Skills
I'm offering
Ashley Johnson has been working in the IT occupational sector for more than 14 years with extensive leadership experience and stakeholder management. Ashley specialises in large scale SAP Data Migration and Data Warehousing projects coupled primarily with Extract, Transform and Load (ETL) using a breadth of technologies including SAP Data Services (BODS), S4 HANA Smart Data Integrator, SAP GUI, advanced PL/T SQL, SQL Server including SSIS, S4 HANA Studio, Data Stewardship Platform/SAP Advanced Data Migration (DSP/ADM). Ashley has extensive knowledge of data quality and cleansing techniques using SAP Data Services, SAP Information Steward and Information Steward Accelerator (ISA). Ashley also has a background in Business Intelligence using various technologies including Business Objects reporting tools (WebI, Universe Designer) and Crystal reports.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
My experience
2013 - ?
freelance
FREELANCE SAP DATA SERVICES CONSULTANT
unknown.
UK AND EUROPE
Clients and Projects
Clients and Projects
SAP
2019 - 2020
freelance
SAP Data Migration Consultant
Capita.
ECC to S4 HANA data migration and quality Management
SAP Data Services 14.2.12, SQL Server Management Studio 15.0, SAP ECC R3, SAP GUI 760, SAP S4 HANA, S4 HANA Studio 2.3, SAP Information Steward 4.2.9
Requirements gathering via workshops with business. Document data migration approach and source to target mappings. SAP data migration via Rapid Deployment Solution (RDS). Extraction, transformation, validation and enrichment (with use of Migration Services) of migration objects using SAP Data Services. Data quality management and cleanse using SAP Information Steward and integration into SAP Data Services Data Quality for cleanse component use. SAP Information Steward SAP Best Practice deployment.
SAP Data Services 14.2.12, SQL Server Management Studio 15.0, SAP ECC R3, SAP GUI 760, SAP S4 HANA, S4 HANA Studio 2.3, SAP Information Steward 4.2.9
Requirements gathering via workshops with business. Document data migration approach and source to target mappings. SAP data migration via Rapid Deployment Solution (RDS). Extraction, transformation, validation and enrichment (with use of Migration Services) of migration objects using SAP Data Services. Data quality management and cleanse using SAP Information Steward and integration into SAP Data Services Data Quality for cleanse component use. SAP Information Steward SAP Best Practice deployment.
Sql, SQL Server, SAP, Deployment, Management, Integration, Quality Management, Workshops, Data quality, Transformation, Server, Server Management
2019 - 2019
freelance
SAP Data Migration Consultant
Glaxo Smith Kline (GSK).
D-MERP SAP Migration, SAP Hybris Migration, Pfizer SAP Financial Consolidation Migration
SAP Data Services 14.2.11, SQL 2012, Data Stewardship Platform (DSP) v6.6, SAP ECC R3, SAP GUI 7.x, SAP Financial Information Management (FIM) v10.0, SAP Financial Consolidation v10.1
Extract, transform and reporting of D-MERP and Hybris migration objects using SAP Data Services and DSP. DSP Front end page build.
Pfizer SAP Financial Consolidation migration using SAP Data Services and SAP FIM.
SAP Data Services 14.2.11, SQL 2012, Data Stewardship Platform (DSP) v6.6, SAP ECC R3, SAP GUI 7.x, SAP Financial Information Management (FIM) v10.0, SAP Financial Consolidation v10.1
Extract, transform and reporting of D-MERP and Hybris migration objects using SAP Data Services and DSP. DSP Front end page build.
Pfizer SAP Financial Consolidation migration using SAP Data Services and SAP FIM.
Sql, SAP, Management, Information Management, DSP
2017 - 2018
freelance
Senior Consultant
Syniti.
Mercadona, SAP Data Migration and Data Quality Management
SAP Data Services 14.2, SQL Server 2017, SAP Data Services Information Steward 4.2.9, Information Steward Accelerator (ISA), Data Stewardship Platform (DSP) 6.6, SAP GUI 7.5, S4 HANA Studio 2.0, S4 HANA Smart Data Integration 2.0, SAP S4 HANA Focused Build Solution Manager
End-to-end extract, transform and load of migration objects (Material Management, Financial Accounting, Sales and Distribution etc.) using SAP Data Services, DSP, iDOC. Data quality management and cleanse using SAP Data Services Data Quality and Cleanse components, Information Steward and Information Steward Accelerator.
* Use SAP Data Services data quality and cleanse transforms including address cleanse as well as use Information Steward and advanced SQL for data profiling, writing data quality rules and data cleanse advisor. Deliver reports and dashboard of data quality and resolution via ISA.
* Completion of mapping documentation, extract and transformation of SAP data migration objects using SAP Data Services and DSP. Load via SAP Data Services Idoc.
SAP Data Services 14.2, SQL Server 2017, SAP Data Services Information Steward 4.2.9, Information Steward Accelerator (ISA), Data Stewardship Platform (DSP) 6.6, SAP GUI 7.5, S4 HANA Studio 2.0, S4 HANA Smart Data Integration 2.0, SAP S4 HANA Focused Build Solution Manager
End-to-end extract, transform and load of migration objects (Material Management, Financial Accounting, Sales and Distribution etc.) using SAP Data Services, DSP, iDOC. Data quality management and cleanse using SAP Data Services Data Quality and Cleanse components, Information Steward and Information Steward Accelerator.
* Use SAP Data Services data quality and cleanse transforms including address cleanse as well as use Information Steward and advanced SQL for data profiling, writing data quality rules and data cleanse advisor. Deliver reports and dashboard of data quality and resolution via ISA.
* Completion of mapping documentation, extract and transformation of SAP data migration objects using SAP Data Services and DSP. Load via SAP Data Services Idoc.
Sql, Writing, SQL Server, SAP, Management, Integration, Sales, Quality Management, Data quality, Transformation, Server, DSP, Manager
2013 - 2014
freelance
SAP Data Services Consultant, Profit & Loss Financial Report
Jones Lang Lasalle.
Data Mapping, SAP Business Objects Data Services 12.2, SQL Server 2008, SSIS, Oracle 11g, Oracle CDC, Data Modelling
Completely overhaul ETL processes and data warehouse environment for increased performance and robustness for the financial profit and loss reporting solution.
* Advise and instruct ETL developers on Data Services and data warehousing modelling best practises.
* ETL Performance tuning: Improved ETL run time (40 mins reduced to 15 mins).
* Database performance tuning: revise indexing strategy for improved query run time.
* Implement presentation layer environment and revise data model: reporting run times 4 times faster than previous environment set up.
Completely overhaul ETL processes and data warehouse environment for increased performance and robustness for the financial profit and loss reporting solution.
* Advise and instruct ETL developers on Data Services and data warehousing modelling best practises.
* ETL Performance tuning: Improved ETL run time (40 mins reduced to 15 mins).
* Database performance tuning: revise indexing strategy for improved query run time.
* Implement presentation layer environment and revise data model: reporting run times 4 times faster than previous environment set up.
Sql, SQL Server, Oracle, SAP, Database, Data Warehouse, ETL, Ssis, Data mapping, Server, Tuning, Sql server 2008, UP, Processes
2013 - 2013
freelance
SENIOR CONSULTANT
IM GROUP.
Clients and Projects:
2011 - 2013
job
LEAD ETL DEVELOPER
CENTRICA PLC.
ETL, Developer
My education
2001
-
2005
University of Brighton
Bachelors, Computing and Information Systems BA
Bachelors, Computing and Information Systems BA
?
-
1999
Churchill Community School
Secondary, Mathematics, Physics, History
Secondary, Mathematics, Physics, History
Ashley's reviews
Ashley has not received any reviews on Worksome.
Contact Ashley Johnson
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ashley directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark