Aurélien Gazengel Email & Phone Number

Nantes, Pays De La Loire, France

- Tableau platform management- Data transformations- Analyses and visualisations

Nantes

Groupe Rocher - Database migration:- Developped bash script to clean and prepare database DDL from MySQL to PostgreSQL- Wrote python script to parse and modify xml documents- Executed non regression tests- Used Git & GitLab for collaborative workSystème U - Member of data integration team:- Developped python script to archive ETL logs from GCP compute instance to buckets- Tested integration jobs using GCP Biq queries- Used Git & GitLab for collaborative work

Nantes, Pays De La Loire, France

Personal project - Web app design, development and deployement:- Collected, cleaned and uploaded data through AWS Lambda python script using Serverless framework- Managed database through AWS RDS postgreSQL instance- Designed web app back and front end (Django, Bootstrap)- Deployed web app on AWS (EC2, Nginx + Gunicorn, Load balancer)

Nantes

- Project 1: Dashboard solution to follow sales, supply-chain and finance from a database (PowerBI, SQL)- Project 2: Movies recommandation platform based on machine learning algorithm (Python)- Project 3: Automatic data collection and integration into a postgreSQL database (Python, SQL)- Hackathon: Case study on "Ile de France" real estate market including complete dashboard and machine learning (Power BI, Python)- Final checkpoint: Case study on wine price including dataset… Show more - Project 1: Dashboard solution to follow sales, supply-chain and finance from a database (PowerBI, SQL)- Project 2: Movies recommandation platform based on machine learning algorithm (Python)- Project 3: Automatic data collection and integration into a postgreSQL database (Python, SQL)- Hackathon: Case study on "Ile de France" real estate market including complete dashboard and machine learning (Power BI, Python)- Final checkpoint: Case study on wine price including dataset cleaning, analysis and machine learning (Python, Power BI) Show less

Nantes, Pays De La Loire, France

- Implemented new reporting tool for result analysis (e.g: EBIT bridge)- Designed a dashboard to follow-up the turnover with percentage of completion method

- Designed and implemented new reportings with standardized rules (e.g.: EBITDA bridge)- Business point of contact for SAP continuous improvement projects related to controlling activities

- Translated business unit strategy into the 5 years plan- Determined projects’ return on investment (NPV, IRR, payback): network optimisation, additional capacities, ...

- Developed automated financials reports: transports and raw materials’ price increase, lent packaging follow-up, customer contribution margin, ...- Transition to SAP- Led budget/forecast process on the perimeter

Paris

- Implemented Qlikview dashboard on manufacturing performances- Designed a program to extract from Excel budget information to be loaded in data warehouse (VBA)

Paris

Paris

Data Engineer

Cloud computing (AWS), SQL, Docker, DBT, Web, CI/CD

Data Analyst

- Data Analyst training program focusing on Python, BI tools and SQL

International Certificate In Corporate Finance, Corporate Finance

- Financial analysis, Corporate value, Investments and financing

Master’S Degree In Cost Control And Business Analysis, Cost Control

Graduate Business School Degree, Finance