Yassine K.

Context 1:

Integration of Proscope with Hyperplanning for room reservation management

Actions:

• Development of cloud solutions using appropriate GCP services (Compute Engine, BigQuery) for the interface between Proscope (master system) and Hyperplanning to synchronize room reservations

• Development of a robust solution for transferring reservation data from Proscope to Hyperplanning, respecting security constraints.

• Design and deployment of secure APIs with API Gateway and Cloud Endpoints.

• Use of BigQuery for advanced analytics and dashboard development, and optimization of data exchange between systems.

• Implementation of DBT models to transform, validate, and standardize reservation data within BigQuery, with quality tests and automated documentation.

• Responsibility for coordinating multiple developers and supporting skill development on project tools.

Context 2:

Implementation of DocuSign for electronic signature

Actions:

• Analysis of DocuSign and EDM SOAP/REST APIs, definition of service contracts (WSDL / Swagger).

• Design of orchestration in Talend ESB (Route / Data Service) ensuring bidirectional data transfer.

• Development of a robust ESB service for secure transfer of reservation data between DocuSign and the EDM to synchronize document transfers.

• Implementation of security policies for DocuSign and EDM calls (token and BasicAuth authentication, SSL/TLS management, access filtering), with complete exchange traceability, SOAP/REST error handling, automatic retry mechanisms, and monitoring of processes via logs and tracking files.

• Responsibility for coordinating multiple developers on the project

• Business acceptance testing support / Production incident resolution

Context:

Migration and redesign of the WHOLESALE INFOCENTRE infrastructure to a cloud environment

Actions:

- Analysis of the existing system, KSH scripts / DATASTAGE JOBS / Packages / Stored Procedures

- KSH reverse-engineering for conversion to Talend and GCP.

- Writing detailed technical specifications.

- Design of the data architecture on GCP to accommodate new pipelines

- Implementation of data flows between Talend, GCP, and Snowflake

- Implementation of DBT models to transform, validate, and standardize data in Snowflake

- Development and optimization of SQL and PL/SQL queries before migration to Snowflake.

- Optimization of SQL queries and performance tuning in Snowflake

- DATASTAGE > TALEND migration

- Development and optimization of JAVA routines.

- Execution of unit and integration tests.

- Anomaly and incident management.

- Coordination and upskilling of several developers within the team

Context: Evolutionary and corrective maintenance of a decision-making chain for monitoring operational risks and liquidity problems

Actions:

• Study and analysis of detailed functional specifications.

• Analysis and update of detailed technical specifications.

• Data warehouse modeling using Visual Paradigme

• REVERSE-ENGINEERING of PL-SQL code / PL-SQL processing optimizations.

• Data extraction, transformation, and loading using Talend.

• Development and optimization of routines.

• Execution of unit tests and integration tests.

• Assistance to the acceptance testing team/ PP (VABE+VABF).

• Development of reports on POWER BI.

• Anomaly management and tracking.

• User support 1 & 2.

• Snowflake BDD migration in the context of another project.