Alexandre Momo

Reporting to the financial department of INSERM, I am the technical referent for the 2 FTE service center dedicated to the evolutionary maintenance of the group's budget and accounting steering application, in direct contact with central management control. Mission activities:

• Ensure the link between the financial department and the IT department within the framework of technical projects.

• Technical project management:

• Database optimization

• Data loading process optimization

• Report response time optimization (fact table aggregation and partitioning, report caching automation)

• OBIEE version upgrade (reporting tool)

• TLS protocol version upgrade

• Integration of a new Oracle EBS module (Fixed Asset) into the BI data foundation:

• Implementation of ETL processes for integrating data from the new module

• Implementation of detailed reports

• Analysis and correction of discrepancies.

• Management of support requests made to the publisher.

• Implementation of budget monitoring reporting supporting the write-back feature

• Implementation of proactive reporting (email notification)

• Intern supervision:

• Presentation of concepts

• Tool training

• Task management

• Handling of various evolutions (data foundation and reporting levels).

• Implementation of procedures for the daily operation of the platform.

• Provide support to business users.

• Operational reporting:

• Prioritization of support requests

• Preparation and animation of project committees Technical environment: Informatica ETL, Oracle 19c Datawarehouse, Oracle BI Data Visualization, Oracle EBS R12 ERP, skills=[]

Integration of the new financial reporting tool for internal management control based on OBIEE as part of an ERP Finance version upgrade project. Mission activities:

• Integration of the Financial reporting solution around Oracle BI:

• Implementation of the security model in the reporting tool:

• SSO authentication,

• Data contextualization based on user profile,

• Application privileges,

• Catalog security

• Implementation of a CORE Model for reporting on GL (General Ledger), AP (Accounts Payable), and AR (Accounts Receivable) modules.

• Training of the TMA on modeling principles

• Training of key business users on tool usage. Technical environment: Oracle 12c DBMS, OBIEE 12c, Oracle EBS R12

01/2019-05/2019, skills=[]

OBIEE to MicroStrategy migration project. As part of the project team responsible for the Oracle BI App to Microstrategy migration, I ensure the operational maintenance of the BIAPPS tool during the dual-run phase and provide support to developers for translating OBIEE reports to Microstrategy. Mission activities:

• Corrective maintenance of ETL processes.

• Reverse engineering to provide SQL scripts derived from BIAPPS reports for Microstrategy report construction.

• Analysis of discrepancies between target reports and the OBIEE source system. Technical environment: INFORMATICA ETL, Oracle 12c DBMS, Oracle BI Apps 7.9.6 ecosystem, Oracle EBS R12 ERP

02/2018 – 12/2018, skills=[]