About Yannick
English
Fluent
French
Native or bilingual
Experience
- Prisma MediaData Engineer - GCP Analyst / Project Management / Symfony DeveloperPRESS AND MEDIAAugust 2018 - Today (7 years and 10 months)Gennevilliers, FranceCurrently, I am managing a GCP Cloud project within the Enterprise IT department. This project involves collecting a large volume of data from various sources (Partners, Adserver, Traffic, Acquisition, ERP). The main idea is to "reconcile" revenue on the traffic of Prismamedia's websites.The project requires the development and management of a central GCP Cloud ecosystem for aggregating advertising data (Google AdManager) and traffic data (Google Analytics) from over 20 internal sites. The core of the mission involves retrieving, processing, and analyzing data using an internal application (Symfony 7) and cloud services (BigQuery, Composer Airflow, Storage) to deliver dashboards with KPIs and ROI (Looker, SalesForce) to collaborators.My role at Prisma:Data Engineer:- Writing and implementing complex SQL queries in BigQuery to process data (managing volume & windowing).- Implementing a data workflow using ETL tools like Google Composer 3 with Airflow 2 (configurations, maintenance, and scalability testing).- Creating Airflow DAGs in Python 3 for processing and calculating daily data (over 38TB of data processed per day).- Implementing the various data processing steps to transform raw data into refined data.- Managing a Data Lake of over 500TB of data.- Implementing a data lifecycle system to manage the large volume of data (Archiving).Project and Team Management (+ 5 people):- Writing specifications in collaboration with the business units.- Collaborating with business teams for the implementation of dashboards and new features.- Prioritizing tasks, planning, and mapping workflows.- Organizing weekly meetings with business units, IT, and partners.
- PrismamediaSymfony 4 / MYSQL / ORACLE / Google GCP DeveloperPRESS AND MEDIAFebruary 2016 - July 2018 (2 years and 6 months)Gennevilliers, FranceWithin PRISMAMEDIA's IT department, I participated in the development of a Back-office software using SYMFONY 3 / PHP 7 / MYSQL to analyze, supervise, and manage digital advertisements (CRM / REPORT / ROI / KPI / INVOICE). Through the implemented indicators, advertisers can get feedback on ad conversions based on various parameters: search / display / performance, and thus make decisions on their campaign strategies. For the development of this tool, there were 3 of us: a project manager and 2 developers. One was responsible for ad delivery, and I was responsible for the Back-office, focusing on CRM / REPORT / ROI / KPI / BILLING / DATA EXPORT, as well as data retrieval via Adserver (GOOGLE DFP).
- EURO MEDIA (FRANCE)FLASH DeveloperPRESS AND MEDIAOctober 2015 - November 2015 (1 month)La Plaine Saint-DenisFLASH AS3 development for implementing graphical elements in FLASH scenes to create visual elements for integration into a television broadcast stream. AS3 programming to enable proprietary software to control animations and actions for television broadcast.
Recommendations
Be the first to recommend Yannick
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Computer Engineering degree (Master's level) from IMAC school (Image Multimedia Audiovisual Communication) affiliated with the University of Marne-la-Vallée.IMAC (Image Multimedia Audiovisual Communication)2008