Tran Dai Phuc Pham Email & Phone Number

Maisons-Alfort, FR

Lille, Hauts-de-France, France

Constructed an Extract, Transform, Load (ETL) pipeline on Airflow and DBT, Spark from CRM tools (Hubspot, Chargebee, Mixpanel) to Cloud AWS RDS, EMR then revert Load (Push) to CRM Tool.Orchestrated connection to AWS with Terraform.Optimised SQL query and constructed Data Lakehouse (Postgre).Optimising Data Warehouse, query SQL, changing data data model.

Vibraye, Pays De LA Loire, France

Vibraye, Pays De LA Loire, France

Parsing of Python code, extracting function definitions, parameters, and their relationships within the codebase (Ctags) Build a call hierarchy graph to capture these relationships by Langchain inputTransform codebase into vectors, divide it, and utilize OpenAI's LLM to produce docstrings for each function.(LLM, OpenAI)

Poitiers, Nouvelle-Aquitaine, France

DB migration data retail to Google Cloud. Orchestrated the construction of an Extract, Transform, Load (ETL) pipeline on Airflow to seamlessly transform and load data into Google Cloud using BigQuery.Implemented data validation and verification at each stage of the transformation process using Python code.Presented and visualized the analyzed data on.

Vietnam

Construction of structured database SQL by Sequelize ORMConstruction of RESTFull API with Express Nodejs running on local host server Creation of control access for users by Json Web Token

Poitiers, Nouvelle-Aquitaine, France

Intership about THERMAL and DYNAMIC simulation for LAB of institut P (ENSMA - École Nationale Supérieure de Mécanique et d'Aérotechnique) colaborated with CNRS- Coding and programing on LINUX system - Simulating flow system of fluid dynamic and thermal by using DFMIBM ( the numerical simulation code which is based on the full periodic condition for.

Poitiers, Nouvelle-Aquitaine, France

The internship is the cooperation between CNRS and LAB PPrime FTC in ISEA ENSMA, Poitiers

Ho Chi Minh City, Vietnam

Published the scientific research paper:- DESIGN AND SIMULATION OF FOLDABLE DRONE ARM TUBE JOINT (2020)Role: - Design a folding arm tube joint by using SOLIDWORKS - Simulation those parts by ANSYS in a static situation

Vietnam

Main Responsibilities:- Using SpaceClaim to convert 2D drawings to 3D models of ships oil tankers- Construction of the database to manage all tanker elements- The use of unique applications from the company Akselos to simulate all components of the FPSO tanker using the FEM method (Trelis, Akselos Modeler)

Ho Chi Minh City, Vietnam

Published the scientific research paper:- VALIDATION AND COMPLETION THE MINIATURE TESTING MACHINE FOR COMPOSITE MATERIALS (2019)Role: - The use of the digital imaging method to measure the angle of rotation of the handle during test bench operation- The use of SOLIDWORKS to design the anti-rotation system- The use of ANSYS to simulate the reactions of the.

Master'S Degree, Data Engineering

Bachelor'S Degree, Aerospace, Aeronautical And Astronautical Engineering

Followed P.F.I.E.V (Programme de Formation d'Ingénieurs d' Excellence au Vietnam), which is the program cooperation between France and.

Stage, Aerospace, Aeronautical And Astronautical Engineering