Freelancer profile translated to English.

Description

Specialist in the design and operation of high-volume data warehouses, I work on the entire decision-making chain: modeling, ETL (Datastage, SSIS, Talend), Oracle/SQL Server databases, and Business Objects / Power BI reporting.

Last mission: real-time toll data warehouse at Vinci Autoroutes - several million daily transactions, GDPR compliance, fraud detection POC.

Immediately available for permanent or freelance positions - Avignon/Montpellier region or remote work.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Villeneuve-lès-Avignon (up to 50km)

Missions coworking Luxembourg
Independent Consultant
CONSULTING AND AUDITS
September 2025 - March 2026 (6 months)
Bertrange, Luxembourg
Assistance with IT implementation for VSEs in a coworking space in Luxembourg. Network installation, EBP ERP integration, website development, task automation (VBScript/PowerShell, Python), MS Access and PostgreSQL database management. Advanced Excel.
PostgreSQL Microsoft Excel VBScript Python
Groupe Vinci Autoroutes
BI Engineer
TRANSPORTATION
February 2022 - July 2025 (3 years and 5 months)
Vedène, France
• Design and implementation of a high-volume toll data warehouse (real-time flow via Datastage/Kafka, several million lines/day)
• Project management in Agile mode (Jira/Confluence): daily stand-ups, sprints, backlog, validation of indicators with business teams.
• Fraud & Control POC: fraud detection and automatic control of user entries/exits through optimization of aggregation tables and indexing strategies.
• GDPR Compliance: anonymization of sensitive data (credit cards, license plates).
• Creation of business statistical infocenters: database modeling, BO XI 4.3 universes, reporting, and user support.
• Populating repositories: integrating flows via secure API calls, tested and validated in Postman/SoapUI before integration into Datastage jobs.
• Reverse engineering of existing PL/SQL packages: analysis, documentation, and migration of toll transaction DWH loading scripts prior to the overall redesign.
• Redesign of loading processes: migration of Oracle PL/SQL scripts to Datastage jobs.
• Access and exploitation of Unix scripts for launching DB2 loads as part of ETL process redesign.
• Migration of BO Server 4.2 / 4.3 and user account management (personal login and SSO Active Directory)
Consommables Diffusion France
Company Creation
RETAIL (SMALL BUSINESS)
January 2015 - December 2016 (1 year and 11 months)
Montpellier, France
● Field prospecting and business development
● Design and development of dedicated management software: customer tracking, orders, invoicing, inventory management, and competitive pricing monitoring
● Stack: VBA Access, Python, MS SQL Server

Check out Philippe's experience

Be the first to recommend Philippe

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Python Developer MySql Administration, Bootstrap, jQuery, GitHub
2019
Développeur Python Administration MySql, Bootstrap, jQuery, GitHub
– Quantitative Studies Quantitative studies program + advanced training
ISM
2013
– Études quantitatives Parcours études quantitatives + perfectionnement