Yannis Amirat

OLGA (hOlistic & Green Airports) was selected by the European Commission as part of the European Green Deal H2020 call for projects, focused on environmental innovation. This new strategic project, coordinated by Aéroports de Paris SA (ADP), with Paris-Charles de Gaulle Airport in France as the pilot site, and Zagreb Airport in Croatia as a partner, started on October 1, 2021. The project's objective is to improve the environmental impact of the aviation sector in an innovative and sustainable way. Two other European airports are also participating in the project: Milan-Malpensa in Italy and Cluj in Romania. Paris-Charles de Gaulle Airport is thus positioned as the leader of the consortium, responsible for leading significant environmental innovations to be deployed and disseminated until 2026.

I am working with a team from the UPEC LISSI research laboratory and with ADP and Zagreb Airport as clients.

Responsibilities:

• Design and development of the OLGA BiodiversIT platform framework

• Development and integration of modules: IAM RBAC, robot path module

• Implementation of CI/CD pipelines: GitHub, Docker, Kubernetes, multi-cloud environment – Hostinger, AWS, GCP

Technical environment: React, JavaScript, TypeScript, NodeJS (Express), Tailwind CSS, Python, FastAPI, Firebase, Docker, Kubernetes, AWS EKS, GitHub

Cimpa is the PLM subsidiary of the Sopra Steria company.

Mission:

• Development of widgets for the 3DEXPERIENCE platform (Dassault Systèmes)

• Development of a resource sharing module

• SNCF mission: Integration of VBA treatments and C# microservices with the 3DEXPERIENCE Catia thick client.

Technical environment: Vue.js, JavaScript, TypeScript, CSS3, VBA, Postman, Gitlab, Jira

AdOk is a tool from ASN's System Design R&D team for simulating and designing underwater optical transmission systems.

The data for the components used were initially stored in XML files.

A SQL database needed to be set up to store more data, improve data persistence and software performance with:

- A remote PostgreSQL database was chosen to store official component data.

- A local SQLite database to store unofficial components that are added or modified by users, in addition to the official components.

When network access is no longer available, the tool must use the data from the user's local SQLite database.

I made the AdOk tool compatible with SQL databases.

I am currently adding an update history to the remote database to be able to view the update dates of this database and retrieve deleted old data.

Responsibilities:

• Development of Java micro-services (porting JDBC PostgreSQL to ORM JPA).

• Implementation of a PostgreSQL back-end server database

• Development of a historization API

• Development of a thick client with an embedded SQLite database (Java FX)

Technical environment: Java, PostgreSQL, SQLite, Git, Jira