Rabah L.

In a marketing-related IS, migrate 11 Talend flows from 4 projects to connect them to the new Redshift database, providing a complete view of user data, replacing a MySQL database that consolidated user connection data. The new cloud-based database aims to offer increased performance, historize data, and provide a global view of customer data to better meet BI analysis needs.

- Identification of impacted job parts and types of impacts.

- Reconfiguration of database query components.

- Rewriting queries to respect the Redshift SQL dialect and correct join errors identified in the initial version.

- Replacement of API calls (coupled with the old database) with SQL queries. This unusual choice compared to architectural standards met a performance constraint.

- Rationalization / optimization of jobs through parameterization and re-orchestration.

- Correction of JVM memory saturation.

- Analysis of the conservation of existing volumes in the target version compared to the initial version of the flows.

- Reorganization of certain jobs to allow their deployment in the cloud.

- Creation and management of Git branches from the Talend studio, with manual commit management to track development history.

- Deployment of jobs in the cloud, management of tasks and execution plans.

- Production monitoring.

Synchronization of flows between the Magento e-commerce site and the Odoo ERP.

Participation in the pre-sales phase.

Implementation of Talend ETL foundation / modular development of jobs.

Unit tests.

Configuration of access to service applications.

Deployment of jobs in the cloud, management of tasks and execution plans.

The mission for the M6 client revolves around the advertising IS. This IS is divided into 2 domains: offer management and demand management. The focus is on the latter. The central business concepts are as follows:

1- Brief: A brief specifies the constraints and wishes of advertisers for the broadcast of advertising for a product over a given period, with a given budget, possible spot formats, and fixed commercial clauses.

2- Slot: Advertising time slot.

3- Spot: Advertising flash.

The subsystems addressed:

Wy9: Brief specification system.

Edeal: Brief validation system. This module is separate from Wy9 because Wy9 is not the only channel for brief specification. The other channel is not within the scope of the mission.

Hélios: Main engine for placing spots in advertising slots.

EP Engine: System for calculating the order of spots placed in an advertising grid.

Rolling BB6: Optimization module (evolutionary algorithm) for program sponsorship schemes.

Mission points:

- Evolutionary maintenance.

- Implementation of optimization functionalities through linear programming.

- Refactoring of software architecture and component substitution: web services, unit tests, and package organization.

- Migration to Java 15.

- Improvement of tests and code.

- Level 2 and 3 support.