Antoine GAMELIN

The ATHOME Digital group brings together 3 leading home renovation brands: Préservation du Patrimoine, Devibox and Avenir Rénovations. Devibox is a SaaS worksite management solution for artisans and building professionals. 𝐅𝐞𝐚𝐭𝐮𝐫𝐞𝐬: Led the development of a new interface for the MLM network, integrating Stripe API for subscription man- agement and e-signature for contracts. 𝐌𝐚𝐧𝐚𝐠𝐢𝐧𝐠 𝐭𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐝𝐞𝐛𝐭: Managed technical debt and led the migration of the development environment to PHP 8.2 and Symfony 6.4, improving stability and performance. Conducted security audits to identify vulnerabilities and replaced deprecated dependencies, enhancing the platform’s security and stability. 𝐎𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬: Implemented a full CI/CD pipeline to automate deployments and ensure continuous integration of changes

Robotik Technology is a medical sector company, which offers the installation of robots for the PDA (Preparation of doses to be administered) for various pharmacies. It offers as a service a medical platform for the management, monitoring and guidance of the patients. 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭: • Fixtures implementation • Implementation functional tests • Refactoring the application • Setting up tools to improve code quality (PHP CS Fixer, PSR standards...) • Drafting of worksheets (Database structure, Installation-related dependencies, etc.) • Development application features • Implementation queue list system with supervisor (Symfony messenger) in order to execute tasks asynchronously. 𝐒𝐞𝐫𝐯𝐞𝐫 𝐀𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 (𝐂𝐞𝐧𝐭𝐨𝐬 / 𝐃𝐞𝐛𝐢𝐚𝐧): • Audit of the different servers (website, installed packages, versions ...) • Setting up NGINX reverse proxy • Apache (httpd) configuration for the preprod environment

The University Institute of Technology of Calais provides different university courses in the field of computer science, electronics or human resources management. 𝐒𝐲𝐦𝐟𝐨𝐧𝐲: • Realization of a project for students to get familiar with the different basic components of symfony (Entity, Repository, Routing, Migration, Form and TWIG). • The project consists in the implementation of an application allowing to create online surveys. 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐏𝐨𝐬𝐭𝐠𝐫𝐞𝐬𝐪𝐥: • The objective of this course is to perform queries on a database with a large dataset in order to optimise the queries. The students had to benchmark different methods (COPY of a csv, BULK insert and simple insert) to insert data through a JAVA application. • Use of indexes to improve queries 𝐀𝐏𝐈: • The students had to use the discord API to build an application of their choice. The objective of the course was to learn how to use an external API.

SISA (Applied Statistical IT Solutions) has more than 15 years of know-how in the fields of Business Intelligence, online surveys and dashboarding. 𝐏𝐇𝐏 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭 (𝐂𝐨𝐝𝐞𝐢𝐠𝐧𝐢𝐭𝐞𝐫): • Development of an interface for secure file uploads in PHP allowing exchange of sensitive files with clients. • Management of permissions to ensure that the file is only accessible to the users concerned. • Interface for the management of users 𝐒𝐞𝐫𝐯𝐞𝐫 𝐀𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 (𝐃𝐞𝐛𝐢𝐚𝐧): • Setting up an Apache server • Setting up a Postgres database • Implementation of an automatic deployment of the project using GITLAB CI/CD. • Firewall configuration with iptables • Setting up an ftp server for file deposit with directory restriction for users (chroot)

Odyssey Resources is a company that provides accounting services for its clients. It offers various services such as corporate bookkeeping, data conversion from one accounting platform to another. 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭: • Creation of a dashboarding system allowing managers to see the number of accounting tasks in process and to send alerts in the case where tasks have exceeded the ETA. • Refactoring of the code. • Migration of Microsoft Access database to a MySQL database (Update of the intranet tools in order to use the MySQL database). 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐦𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧: • Creation of a Chrome extension (prototype) to generate CSV files of customer data from an accounting platform. • Creation of an PHP intranet interface to convert these files to a new format in order to import them on an accounting platform. • Using the API of the accouting platform to import the data automatically.

Dynvibe is an expert in social media intelligence. They collect and analyse what consumers say on social media about brands, products, or a market in the broadest sense. From this data they produce 'consumer research'. 𝐃𝐚𝐭𝐚 𝐩𝐫𝐨𝐜𝐞𝐬𝐬𝐢𝐧𝐠 • Collecting data using PHP script from stories from social networks. • Development of a word cloud to highlight the most quoted words. • Starting to implement a semantic analyzer in the scope of sentiment analysis. 𝐓𝐮𝐧𝐢𝐧𝐠 𝐚 𝐏𝐇𝐏 𝐬𝐜𝐫𝐢𝐩𝐭 𝐟𝐨𝐫 𝐛𝐞𝐭𝐭𝐞𝐫 𝐬𝐜𝐚𝐥𝐚𝐛𝐢𝐥𝐢𝐭𝐲 • Implementation of a CRON script that will analyse all the stories (Tweet, Facebook message...) and from a dictionary will allow to define the stories' themes. • Carry out tests on a volume of 2 million stories and a dictionary of 200,000 words

SISA (Applied Statistical IT Solutions) has more than 15 years of know-how in the fields of Business Intelligence, online surveys and dashboarding. 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭𝐬: • Implementation of a monthly survey system concerning the sales of shop products by two methods: entry form or import from CSV files. • Transformation of the data allowing to automatically classify the data thanks to a mapping table. • Integration of these data in an OLAP CUBE to be able to perform MDX queries with the SAIKU application (Data Warehouse). • Creation of a dashboard for customers (using the ChartJS library), allowing an analysis of the monthly data entered / imported. 𝐒𝐞𝐫𝐯𝐞𝐫 𝐚𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 (𝐃𝐞𝐛𝐢𝐚𝐧) • Installation of SSL certificates with LetsEncrypt. (certbot) • Implementation of the GITLAB solution on a dedicated server. • Creation of a CI/CD script allowing automatic deployment during release commits (Git Flow) on the client server. • Securing the different servers with ssh certificates and by passing through the VPN (pritunl vpn) • Cron allowing to make daily backups of the database. • Implementation of a self-hosted password manager (passbolt) • Setting up an SMTP server with POSTFIX/Dovecot. Securing it with SPF, DKIM and DMARC records.