Wissi Yvann Lin Moukagni Mapaga

Projects: SIGMA and SIGMA DIGITAL Project Objectives: Within the DEV FACTORY/JAVA RUN of the studies department, SIGMA is the downstream information system of the Mousquetaires group. It manages the repository of points of sale and their turnover. Furthermore, SIGMA DIGITAL offers a web interface to view information on points of sale (addresses, opening hours, services offered, ...).

Technical Environment: Oracle 11g/19c, PL/SQL developer, TOAD, JIRA, SHELL / UNIX, AGILE SCRUM

My daily tasks:

• Technical lead for DATA activities on both applications around Oracle PL/SQL

• Monitoring of night processes

• Corrective and evolutionary maintenance of applications (ORACLE PL/SQL Study and development)

• Development of tools for automating certain processes.

• Proposal of improvement projects/US (regular purge tool, monitoring tool, data quality control tool for integrated data).

• Optimization of processes (partitioning, parallelism, bulk collect, use of data dictionary views, statistics calculation).

• Unix Shell scripts for automation/operation of solution modules.

• Data backup and restore via RMAN (during study of purge subjects and Oracle version upgrade from 11g to 19c).

.High availability via ORACLE DATAGUARD & RAC

Technical Project Manager / Expert PL/SQL DBA Oracle Study for BOUYGUES TELECOM Client

Cross-functional PL/SQL technical expert on several applications within the NETWORK/ITRES/IRT/FEDS department:

JAR_FTTH & FIDS: fiber optic deployment

DRIM: management of the Business repository.

EP1: Modeling of equipment from different manufacturers.

IBB: Mass integration of business data

DECLARAN: Declaration and registration of regulatory documents for ANFR & ARCEP.

Technical Environment: Oracle 11g, PL/SQL Developer, SVN, GIT, GIT EXTENSIONS PANDA, NetDesigner

My daily tasks:

- Taking charge of and managing various evolution and R&D projects on the RET portfolio.

- UML modeling for redesign subjects

- Task estimation and daily reporting

- Technical design and PL/SQL Development.

- Implementation of a JSON file parser in PL/SQL.

- Optimization of processes and reports AWR / HINTs / STATSPACK.

- Unix shell scripts for automation/operation of applications.

- Daily monitoring of operations and maintenance in operational condition of databases.

Expert PL/SQL DBA Oracle Study for CANAL+ CLIENT

PROJECT KISS_CGAWEB: KISS_CGAWEB is the customer relationship management application for CANAL+ group's individual customers.

Technical Environment: Oracle 11g/19c, PL/SQL Developer, GIT, JIRA, BITBUCKET, EQUIBASE, MAVEN

My daily tasks:

- Within the Finance and Logistics departments, I carried out cross-functional PL/SQL ORACLE technical expertise actions on the following issues:

- optimization of processing time on very large tables (from 500 million to several billion records => more than 30GB per table)

=> Study and Implementation of application high availability (via Oracle DATA GUARD/RAC)

=> Data backup and restore via RMAN

- code sharing.

The concrete actions were as follows:

==> Real-time analysis of PL/SQL processes

==> Optimization of several processes (from 11h to 1h, from 3s to 0.016s,....)

==> Module sharing with Dynamic PL/SQL

==> Sharing of cursors in PL/SQL Modules with collections and temporary tables

==> Table partitioning or redefinition

==> Writing technical documents

==> Code review

==> Corrective and evolutionary maintenance