The group Daher Aerospace has absorbed the company SOCATA based in the south west of France and which it’s specialized in manufacturing private jet.
The main requirement was to make the migration of SOCATA data and flow business process from SAP system 4.7 toward SAP ERP ECC6 with an external software
So I’ve been asked to recommend an ETL software and to manage the migration.
I’ve recommended in order to guarantee the success of the migration the software TALEND software which has a very high recommendation from GARTNER.
For such complex project TALEND OPEN STUDIO offers the best advantages because the migration was made of 80 of full specific developments coming from several parts and 20 made of standard objects to re-import.
For this project, I’ve done the following task
Install TALEND
Set up a developers team and train them on this software
Create a follow up document in order to track the status per data object
Create several template as model for migrating the data with the most accurate rules
Advice the team
Giving support
Participate to weekly status meeting with the IT department
Manage the different teams functional and technical teams
The client Seagate has absorbed the French company LaCie. In this project the requirement was to make the migration of LaCie Business across all the SAP Modules from SAP ERP ECC6 to Oracle R12 Release. So the migration concerns the following Modules FI AP, AR & AA , MM and PP. I had to develop Jobs in TALEND to assume the data transfer for these following objects
FI-AP Vendor Invoices.
FI-AR Invoices, Credit, Down Payment and Doubtful Receivables
FI-AA Fixed Assets Master Data and Balances and Final Merge file between both objects
MM – Stocks Standard Stock, Customer & Vendor Consignment Stock
MM – Sources List
MM – Movements from MSEG
MM – Items Costs
MM – Min Max
MM – Serial Number / Shipment Number & Packages
PP – Routings
PP – BOMs Bill of Material
TALENT Jobs for cross checking the results going out from SAP toward Oracle R12. The Migration is still in process and additional objects are added daily.
SAP Finance Tax Data Retention Tool DaRT implementation
The client Seagate has to provide to the French Tax Authorities and theirs auditors all the finance statements of the French subsidiary company. For this purpose, SAP provides a tool called DaRT for which I had to configure the following
Setup the DaRT tool with the transaction data object to manage Finance Document FI and Tax Data in our case .
Create the Directory Set with its relative path for the Data Retention extraction file
Run the extraction to this appropriate Directory Set
Run the conversion according to the French Law Clause L47.A.I.
Generate the final file for the auditors
Create Talend JOB to cross check Data Extracted by the DaRT against the Data in the SAP System.
The FI-DPC client module is linked to construction of buildings. As part of the project at the current client, you have to manage the differences that can exist between an established Léon Grosse market with its customers and suppliers. As part of this project, I had to
Correct certain balances established in the direct payment made by a customer to a subcontractor.
Manage cancellation of an accounting document made by accountants outside of the module directly on the DPC FI module thus causing a balance between the DPC and FI module.
Synchronize tables of the CPD by keeping days since the data in the FI tables to eliminate the remainder generated by the previous point.
Update a few features on the screens of the application to DPC does not affect the information on contracts when they were seized.
Update the data reported in the form of the invoice.
Adjust the data listed in a report with ALV to reflect accurate records of contracts drawn by Léon Grosse with customers via the channel deposit customers and suppliers via the chains of subcontractor’s deposit.
In addition to the master in Finance done at the High School of Brussels ICHEC, I’m achieving a certification in Finance as well in SAP. This will allow me to move on functional area and maintain the technical knowledge as an alternative solution to business requirements. During this preparation, I learnt to configure the following objects:
Define and set up fiscal period, posting period and closing period.
Work with variant principle to assign different finance objects
Maintain currencies during document entry
Creation and maintain vendors and customers (manually via transaction or technically via Data migration programs)
Document control creation to check the documents already posted. In case of error, then I generate document for cancellation.
Clear open items
Configure the cash journal
The project at Harp consist to migrate from all data from Oracle database toward SAP IDES ECC6 – roll-out Luxembourg and the rest of Europe from Luxembourg. All objects related to finance, logistics, and sales have been migrated into SAP. Data has been extracted from Oracle via the Talend Tool for data migration purposes.
Responsible to coordinate all the data migration and developing the jobs in Talend for extracting data and developing the migration program with LSMW in SAP for migrating the data.
Follow-up the progress of the project.
Reporting the status, managed small team 3 persons and myself .
After implementation and migration phase, I've developed some specific ALV reports to report the Gap between what have been migrated across the different modules.
Personalized Letter and specifics editing Labels have been developed through SAP Smartforms to notify the clients about the changes made and the new references to use from SAP instead of the old Oracle references
The project consists on resolving issues based on change request called GAPs in their internal organisation.
Implementation of substitutions rule to remove automatic block payment from vendor invoice for French sites and Emirates Countries.
Configuration of account determination per tax code for under and over payment for country Germany
Interface for sending vendor in automatic Extraction of vendor.
Replication of project costs per cost centre / WBS Element on different line per IDOC technics
Implementation of a technical filter to clear specifics customer invoices based on specific criteria
Optimization program for Royalties calculation
Optimization program for Join/Venture process
…
The project at Meggitt Plc. migrates from Oracle to SAP ECC6 – rollout of EMEA for the France and Swiss companies with the rest of Europe. All objects related to logistics, production, HR and finance are migrated into the main SAP client. I used a specific tool called TALEND for data migration purposes. This tool allows the data extraction from legacies, the conversion and enrichment. This tool also generates the file structure required by SAP.
Responsible to coordinate all the data migration for the France subsidiary Angoulême.
Data Migration for the whole data static as well as dynamic objects to SAP cross modules MM, SD, PP and FI by using TALEND data extraction tool.
IS-Retail Data Transfer from Warehouse via specific Interface development via IDOCS and BADI's
Requirement was to transfer/communicate changes made in the warehouse system into SAP. This need was implemented through the development of custom IDOCS and the use of change pointers to detect when changes are made.
Wrote an ABAP to transfer the data from warehouse system to SAP using Idocs.
ArcelorMittal decided to merge 3 French companies to 1 system.
Responsible for migration of all logistics data objects, e.g. Purchase orders, Agreements, Outline agreements etc.
Swisscom SHS migrated from multiple legacy systems into SAP.
Manage a data migration team around 5-7 persons
Identify and select the objects to migration for all modules Finance, controlling, logistics and HR
Creat...