You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Yannick NgYN

Yannick Ng

Data Engineer - GCP Analyst / Project Management

€700/day
Aubervilliers, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Yannick

I have been a PHP/MYSQL developer for 6 years, working as a Freelancer and primarily remotely. My experience focuses on 4 main clients who have allowed me to consolidate strong foundations in E-commerce and Business Back-Office development. These projects required technical skills revolving around PHP / MYSQL / AJAX / DB2 / AS400. Indeed, I worked for 5 years for the site Attitudesk8.com (online skate shop) developing an e-commerce site from scratch tailored to their needs. I was able to implement a development strategy with them that significantly increased their revenue. Subsequently, I developed a Business Back-Office for EMF (Euro Média France, formerly Société de Production Française) over 6 years (ongoing mission). The goal of this mission was to evolve their old DB2/AS400 systems with a more flexible PHP/MYSQL solution for managing their quotes, purchase orders, staff scheduling, and filming equipment management. In the same vein, I worked for Darty for over a year (ongoing mission) implementing new features for their After-Sales Service Back-Office, with the highlight of the project being the integration of multiple environments via Webservices (MYSQL / AS400 / SIEBEL / SQLSERVER). The last client was CultureBD.com (comic book site) where I had to implement a content management Back-Office for the editorial site. You can therefore note the loyalty of my clients, demonstrating my seriousness and rigor in my work.
  • English

    Fluent

  • French

    Native or bilingual

Can work on-site
Aubervilliers (up to 10km), Paris (up to 10km)

Experience

  • Prisma Media
    Data Engineer - GCP Analyst / Project Management / Symfony Developer
    PRESS AND MEDIA
    August 2018 - Today (7 years and 10 months)
    Gennevilliers, France
    Currently, 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.
    BigQuery Project Management Airflow Data Engineer Big Data
  • Prismamedia
    Symfony 4 / MYSQL / ORACLE / Google GCP Developer
    PRESS AND MEDIA
    February 2016 - July 2018 (2 years and 6 months)
    Gennevilliers, France
    Within 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).
    MySQL Google AdManager PHP 7 Oracle Symfony
  • EURO MEDIA (FRANCE)
    FLASH Developer
    PRESS AND MEDIA
    October 2015 - November 2015 (1 month)
    La Plaine Saint-Denis
    FLASH 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.
    AS3 Adobe Flash

Recommendations

Be the first to recommend Yannick

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

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

Skill set

Categories