for a manufacturing company in Germany and Luxembourg.

Supporting the business in delivering high quality data in terms of integrity/dependency to other data objects.

Creating a migration schedule/plan.

Planning and Execution of Mapping Workshops.

Creating LSMW Load Programs for Materials, Vendors, Customers, PIR, Routings, Pricing Conditions. Using Standard Programs, Batch Input, BAPI and IDoc.

Using Datasure to transform data.

Creating test scripts in HPQC.

SAP Data Migration Consultant FI/SD/MM

Technical Lead

Development LSMW/SAP BODS

for a glass manufacturing company in South Africa and Kenya:

Creating Mapping templates together with the business. Holding mapping template workshops for the different data objects.

Creating a migration schedule/plan.

Coordination of different mock loads.

Microsoft SQL Server was used as ETL tool to transform and enrich data and create data files.

Creating LSMW’s for Material (IDoc MATMAS), Vendor, Customers, Open Sales Order and Open Purchase Orders, AP Open Items, AR Open Items, Fixed Assets, BOMs, Functional Locations, Equipments with ABAP validations against T-tables.

Loading data into the QAS and Production client.

for a manufacturing company in Germany:

Holding Mapping workshops.

Developing LSMW’s for various data objects: AP Open Items, AR Open Items, Fixed Assets, Customers, Vendors, Open PO’s, Sales Orders, Pricing Conditions, Bins, BOMs, Equipment

Data loads into various clients.

Support of cleansing activities in the legacy system.

Developing reports for validation and reconciliation activities, ie. SE16 and SQVI.

Creating, following up defects with HPQC.

for a food processing company in Germany, Poland

and Denmark.

Evaluate the existing Master Data processes, data governance and data migration approach.

Development of a new concept for the data migration approach for future SAP implementations starting from extraction to transformation, loading and finally reconciliation of master data and transactional data. Goal was to involve BODS and HPQC in the future.

Coordination of data loads of the ongoing implementation in Germany.

Training in-house developers in LSMW for Material, Vendors and Customers.

for a leading food processing company for several plants in Switzerland and Germany. Working for the end-client.

Developing load (mapping) templates together with functional consultants and business.

Developing load plans.

Coordinating data cleansing activities.

Managing and load status and report to project management.

Working closely together with the cut-over manager and test manager.

Developing LSMW’s for Vendors, Customers, Material, Recipes, Pricing Conditions, Stock, AR, AP and Fixed Asset, various PP Data objects with ABAP validations.

Loading Customers, Customer Hierarchy, Info Records and Pricing Conditions myself.

SAP BODS was used as ETL tool.

Doing minor BODS development (transforms).

Implementing HPQC for SAP Test scripts and as a tool to handle defects for the migration.

Content: Defining Source and Target Meta data, Batch Jobs, Transforms (Mapping, Validation etc.), Functions, Scripts, Variables, Text data processing.

for commercial and CRM data for a brewery in South Africa.

Tasks:

Working with a team of four on-shore Cransoft and LSMW recourses. This team was responsible for the transformation, validation and load into SAP.

Working with an off-shore team in India. Team was responsible for developing of Z-programmes for the CRM load.

Managing defect resolution with HPQC.

Managing status for commercial loads.

Writing Technical Specifications for the ABAP Team in India.

Testing and debugging of the load programs.

Being the contact between Functional and Business in terms of Data Migration requirements and SAP Load (LSMW and Z-programs).

Liaise with Business about data cleansing, transformation rules, reconciliation.

Data Migration Project SAP à Navision for Direct Distribution Company for petro-chemical (fuels, lubes) products (subsidiary of BP) in Hamburg, Germany.

Migration Objects: Main objects of FI (AP, AR, Open Items, Fixed Assets, Line Items), MM (Material Master, Vendors, POs), SD (Sales Orders) and Historical Data

Tasks:

Being the main point of contact on the SAP side for the client.

Defining load objects, mapping templates in workshops together with client and Navision consultants.

Developing  Z-Programs to extract data for the various load objects to load into Navision into .txt, .csv and excel files.

Developed a ‘dash board’ to allow user to extract one or more load object simultaneously.

Developed FI interfaces based on BDC between SAP and Navision vice versa to send FI postings between the two systems. SAP and Navision had to run parallel for a period of time.

Extracting data from SAP for Navision.

Helping the business to extract FI and stock data for the yearly audit via .txt and excel files.

for a global network provider for 2 countries (UK, Ireland).

Tasks:

Creating mapping templates.

Validate data before data load.

Creating load programs using LSMW.

Loading using LSMW (Recordings, IDocs, Standard Programs etc.)

Material Master, Vendors, Customers, Open Purchase Order, Purchase Order History

FI AP, FI AR.

Using Microsoft SQL Server as ETL tool.

Logging defects on HP Quality Centre and manage the defect resolution.

Extract data from SAP after data load for reconciliation for business (Queries, SE16, ABAP reports).

Writing functional and technical Specs.

for a large South African retail company.

Roll-out IS-Retail in South Africa

Responsible for Data Migration and ABAP development using LSMW:

Master data:

Article (Single, Generics, Variants) using ARTMAS05 plus extension.

Purchase Source List using SRCLST

Creating Article Purchase View using INFREC

Vendor and Customer using CREMAS and DEBMAS

Additional Vendor Z-Fields update using recordings

Site Customer and Vendor View using DEBMAS and CREMAS

Pricing using recordings

Transactional data

Open Purchase Orders using Business Object BUS2012, Message type PORDCR1

Completing Mapping templates for the above data objects.

Loading the data using LSMW with above loading methods.

Writing functional specs for data load programs, IDoc extensions for MARA, MARC, WLK2

Validate data.

Work on reconciliation process with transformation team

Logging defects on HP Quality Centre

Developing Smartforms (Purchase order, Purchase Requisition)

ALV Reports