Travel-retail SAP data migration
Parbel of Florida (L'Oréal) · SAP FICO Techno-Functional Consultant
Designed and built SAP data-migration programs for FI/CO, MM and SD data when L'Oréal's travel-retail companies in Florida merged their systems into one SAP ECC system.
- Client / organization
- Parbel of Florida (L'Oréal)
- Consulting firm
- VISEO USA
- Role
- SAP FICO Techno-Functional Consultant
- Period
- Oct 2017 - Feb 2019
- Location
- Miami, Florida, USA
- Team
- Up to 8 people
- Area
- SAP finance
Business context
L'Oréal's Parbel of Florida travel-retail (airport) companies were merging their systems into a single one. Finance, controlling, materials and sales data had to move from the source system to the new SAP system on ECC 6. Techno-functional FICO consultant on the migration, from analysis and design of the migration programs through extraction, reconciliation and testing.
Key contributions
- Analyzed and designed the data-migration programs for FI/CO, MM and SD data.
- Built the extractions for FICO open items, G/L accounts and the material master.
- Reconciled the migrated data and ran the functional analysis behind it.
- Ran extraction tests and integration tests on the migrated data.
Responsibilities in detail
Analysis & design
- Analysis and design of data-migration programs.
- Functional analysis supporting reconciliation.
Development
- Developed the migration programs.
- Extraction of FICO open items.
- Extraction of G/L accounts.
- Extraction of product (material) master data.
Testing
- Data-extraction testing.
- Reconciliation and functional testing.
- Integration testing.
Scope
The migration covered three families of data:
| Area | Data extracted and migrated |
|---|---|
| Finance (FI/CO) | Open items; G/L accounts |
| Materials (MM) | Product / material master data |
| Sales (SD) | Sales data in scope of the merger |
How the work ran
- Analysis and design of the migration programs for each data object.
- Development of the migration and extraction programs.
- Extraction testing to check that the source data came out complete and correct.
- Reconciliation and functional analysis between the source and target systems.
- Integration testing of the migrated data in the new SAP system.