Freelancer profile translated to English.

Description

I support my clients through all stages of their decision-making projects: Project management and technical expertise in Business Objects and Oracle Data Integrator (ODI)

 General:

o Gathering requirements

o Writing functional and technical specifications

o Design and modeling of decision-making systems (ODS, Datamarts, and DWH)

o Producing technical BI architecture documentation

o Operational Maintenance (MCO)

 Business Objects Expertise:

o Modeling and implementation of Business Objects universes and reports

o Administration of the Business Objects server

o Migration from BOXI3.1 platform to BO4.1

 ODI & Genio Expertise:

o Design and implementation of DWH feeding flow via Genio and Oracle Data Integrator (ODI)

o Customization of KMs, development of Shell scripts calling ODI scenarios

o ODI optimization with the implementation of variables aimed at reducing data flow

o Development of a load control tool, a quality control tool.

o Use of substitution functions, KMs, tools, deployment of scenarios, direct querying of ODI system tables, KMs

o Writing operating procedures for ODI operators

 Management:

o Project management: team leadership / reporting / costing / planning / client relations

o Supervision of development teams

o Role allocation, resource management, task planning

o Acceptance testing, deliverable qualification, and anomaly tracking

Languages

French
Native or bilingual
Arabic
Native or bilingual

Workplace preferences

Can work on-site

(up to 50km)

André Groupe Vivarte
Decision-making Consultant
RETAIL (SMALL BUSINESS)
January 2018 - June 2018 (6 months)
Paris, France

Operational maintenance and system evolution
- Taking charge of Retail applications and their integration with the decision-making system,
- Corrective and evolutionary maintenance of the Genio flow
- Design of Webi reports
- Administer SAP BI server and users.
Environment: Oracle 11G ETL Genio V8.0, SAP BI4.2; Retail software: Colombus; Ubud
Genio SAP Business Objects Oracle Database Linux Oracle PL/SQL Transact-SQL
Saint-Gobain
Consultant / ODI Expert
CIVIL ENGINEERING
August 2018 - Today (7 years and 10 months)
- Migration from ODI12.1.3 to ODI12.2.1.4

- Administer the ODI platform
- Automated management and installation of ODI Agents via Ansible
- Securing data flow transit on ODI servers with enterprise-signed certificates
- Management of 150 servers distributed across different data centers
- Flow monitoring, incident analysis, proposing solutions
- Technological watch and monitoring of various JDBC evolutions (Oracle, Sybase, DB2, MySql, SAP HANA)
- Assisting developers and the scheduler team (DollarU)
- Interfacing with different business units
- Monitoring the production chain via the DollarU scheduler
Part: OSB
- Administration of the OSB platform
- Analysis of OSB flow incidents (Oracle Service Bus)
- OSB server monitoring
- Weblogic, Oracle Enterprise Manager, JMS queues
TIBCO
- Monitoring TIBCO flows by SOFT Monitor
- Configuration of TIBCO Administrator and TIBCO Enterprise Administrator
- Management of VIPs and PSAT
- Management of enterprise-signed Root and server certificates
Environment: Oracle 11g/12C/19C; ODI 11/12; DB2; Sybase IQ; DB2; MongoDB; Mysql; Sql server
Oracle Data Integrator Oracle Database IBM Db2 Sybase IQ SQL Server MySQL TIBCO BW OBS Studio Ansible Dollar Universe
Mutex prévoyance et mutuelle
Decision-making Project Manager
BANKING AND INSURANCE
October 2017 - December 2017 (3 months)
Malakoff, France
Project management for migrating ETL OWB to ODI 11g
- Costing, project planning
- Resource allocation: 2 FTEs
- Rewriting of ODS and Datamart loading flows
- Monitoring development, unit testing, and acceptance testing.
- Planning qualification acceptance testing and production deployment
Environment: Oracle 11G ETL OWB, ODI11g (provident and mutual insurance)
Oracle Data Integrator Oracle Database Linux SQL Oracle PL/SQL