Oracle cloud roll-out project with a financial scope AR/AP/GL/CM/FA. The goal was to roll-out a second division of the group on January 1st 2022. This based on an Oracle Cloud Core model which was deeply enhanced during the project. My role on the project included among others the following:
• General representation of the business for all financials and fiscal topics of the project especially for the design of the new division solution,
• Systematic review and enhancement of the Core model financials Cloud flows to fit them with the program management driving of this new division -> I enhanced 200 financials flows.
• Preparation and execution of the business users trainings on the new solution.
• Preparation and execution of the reception tests of the solution for the new division. Execution with the business users of 200 financials tests on AR/AP/GL/CM/FA.
• Permanent update of the target solution to take into account the users remarks mainly during upper phases and training.
• Parallel involvement with the data migration team to design the migration rules and routines from previous legacy systems (Anael / Imael + Company specifics)
• Execution of the GO LIVE on January 1st 2022,
• Since then:
o Single point of support for all the division users on the new solution:
Initial reconciliation of the open items after data migration to Oracle (AR/AP/GL/CM/FA),
Leader of all the periods closing execution plans,
Daily management of all the business team on the new solution (Recommendations, controls, correction of issues on any modules)
Implementation of evolutions permanently tracked.
The group had to secure the operations for 2 foreign subsidiaries on Prod under Oracle Cloud Apps and reengineer the financial CORE processes:
• In relation with the Corporate financial direction and 2 dedicated BPOs, I reviewed and enhanced the CORE Financial business processes for Oracle Cloud compliancy and best practices,
• For one of the subsidiaries, I designed the Oracle SAFT process (Production of SAFT files in case of a fiscal control):
o Design of the SAFT files for compliancy the country requirements (Production of FAIA files for Luxembourg in our case),
o Specifications including the review of existing, creation and assignment of custom accounting rules in the SLA on the AP and AR sides.
o Supervision of the developments,
o Tests scripts design and execution,
o Users training on original data maintenance and process execution,
o PROD go live.
• Maintenance of the CORE accounting and performance Oracle cloud hierarchies for the Group.
• Creation of new CORE P&L reports based on new CORE hierarchies under FRS (Oracle Cloud Financial Reporting Studio)
• Maintenance of the Oracle cloud CORE Mass allocations formulas (Update of the Mass allocations formulas for compliancy with the new CORE hierarchies)
• Maintenance of the CORE Oracle Cloud Etax Engine. Creation/Update of Etax Branches.
• Management of Issue tickets on the financial domain.
For RATP, the French public transportation company (Leader on his domain) + 60000 employees.
On purpose of the application of an E.U Directive, this group had to reorganize by creation of a new branch of activities.
For this reorganization project (Creation of a new branch of activity by partial transfer/conversion of the activities sourcing from other branches of the group), I was EBS V12 Oracle Expert on the domains QP -> O2C, P2P (E-PROC/OTM. INCLUDED), FINANCIALS:
• This project has been physically managed as a migration one with complex conversion rules of assets and open items,
• Conception of a migration/conversion general planning (finalized to 3000 tasks):
o Setup of the EBS V12 target structure according to a group Core model (Leger, Etax, E-proc, PO, AP, OTM, QP, OM, AR, ETL exchange platform with around 30 peripheral applications),
o Unit Review, Portability of 100 complex specifics toward an 100% Multi-org target,
o Design, setup, execution, technical debriefing of 2 Blank migrations,
o Training of users (New Org, Ported specifics),
o Execution of the production Roll-out,
o Reconciliation of the migrated/converted assets and opens items,
o MOC.
• On this, I have:
o Setup the target EBS V12 Orgs on QP OM AR, Ledger, E-proc PO AP OTM (2 blank migrations/conversions + the final Production roll-out),
o Reviewed the existing SLA accounting Rules (AP AR) and created and assigned new custom accounting rules on both AP and AR sides.
o Controlled, Rewrote, Supervised redevelopment, Unit tested more than 50 complex specifics,
o Designed, executed and reconciled the migration/conversion of assets and open items during 2 blank migrations and the final roll-out,
o For the 30 peripheral applications, I have executed the migration/conversion tests on assets and open items. Peripheral applications -> ETL Exchange platform -> EBS new branch of activity,
o Trained the users (New org, Ported specifics…),
o Executed on my domains the production roll-out (Migration / conversion / reconciliation) of open items,
o MOC.
For RATP, the French public transportation company (Leader on his domain) + 60000 employees.
On purpose of the application of an E.U Directive, this group had to reorganize by creation of a new branch of activities.
For this reorganization project (Creation of a new branch of activity by partial transfer/conversion of the activities sourcing from other branches of the group), I was EBS V12 Oracle Expert on the domains QP -> O2C, P2P (E-PROC/OTM. INCLUDED), FINANCIALS:
• This project has been physically managed as a migration one with complex conversion rules of assets and open items,
• Conception of a migration/conversion general planning (finalized to 3000 tasks):
o Setup of the EBS V12 target structure according to a group Core model (Leger, Etax, E-proc, PO, AP, OTM, QP, OM, AR, ETL exchange platform with around 30 peripheral applications),
o Unit Review, Portability of 100 complex specifics toward an 100% Multi-org target,
o Design, setup, execution, technical debriefing of 2 Blank migrations,
o Training of users (New Org, Ported specifics),
o Execution of the production Roll-out,
o Reconciliation of the migrated/converted assets and opens items,
o MOC.
• On this, I have:
o Setup the target EBS V12 Orgs on QP OM AR, Ledger, E-proc PO AP OTM (2 blank migrations/conversions + the final Production roll-out),
o Reviewed the existing SLA accounting Rules (AP AR) and created and assigned new custom accounting rules on both AP and AR sides.
o Controlled, Rewrote, Supervised redevelopment, Unit tested more than 50 complex specifics,
o Designed, executed and reconciled the migration/conversion of assets and open items during 2 blank migrations and the final roll-out,
o For the 30 peripheral applications, I have executed the migration/conversion tests on assets and open items. Peripheral applications -> ETL Exchange platform -> EBS new branch of activity,
o Trained the users (New org, Ported specifics…),
o Executed on my domains the production roll-out (Migration / conversion / reconciliation) of open items,
o MOC.
For the Swedish subsidiary of the Trimble American group leader in the domain of laser geographic solutions.
Oracle Manufacturing / MSCA / ASCP / OTM leader role (Horizontal business flows integration with SCM (OTM, PO, e-procurement, OM)). Mission of conception and roll-out of an Oracle EBS V12 solution to run the Swedish subsidiary.
• In the context of the Oracle international Core Model of the Group, conception, build and roll-out of the Oracle local solution:
o General and detailed design of the local business requirements,
o Design and build of Oracle EBS V12 sequential instances (CRP1, CRP2) for presentation of the processes, training of the key users, and final acceptance of the solution,
o Training of Key Users,
o Management of the Users during the acceptance tests of the solution,
I wrote all the tests scripts (Manufacturing, MSCA, ASCP, SCM),
I managed my dedicated HPLM environment (Creation of users and grants, loads of tests scripts, tests execution monitoring, Issue tracking and resolution until final approval).
Execution of the test scripts by the Key Users under HPLM tracking,
I supported users during tests execution,
I managed the reengineering of issues detected during the tests until final approval by users in HPLM.
o Setup of the production instance,
o Go-live execution,
o Maintenance under operational conditions.
• In parallel, Conception, support to development, Unit control, and integration controls of the data conversions:
o Items, Unit costs (With execution of costs rollups after unit costs conversion), BOMs, Routings, Open WIPs and all peripheral data (Locators…)
Oracle Manufacturing/SCM/OTM expert role. Mission of control and correction of all the valuations and accounting translations generated by all the unit manufacturing/SCM/OTM processes.
• Review and unit execution of all the manufacturing/SCM/OTM processes in use in the group (Intra and Interco manufacturing flows, integrated flows with PO/e-procurement):
o Systematic control and analysis of:
The costs incurred and released by each manufacturing/SCM/OTM process,
The accounting translations generated at Subledger level (Inventory/WIP) and ...