Industry-Wide Experience
With a rich background in Database & ETL Management, I bring a wealth of experience across diverse sectors such as Automotive, Hospitality, Recycling, Retail, Luxury & Beauty, Public Sector, Telecommunications, and Oil & Gas, working with prominent names like STELLANTIS, Volkswagen, Accor, Veolia, Suez, LVMH, and Total.
Comprehensive Workflow Solutions
I specialize in creating seamless workflows from ERP/CRM systems to reporting databases, Data Marts, and Lakes. My expertise extends from crafting efficient ETL processes to sophisticated database modeling and creation. A notable project involved automating SAP trade receivables, payables, inventory, and financial data extraction.
Stringent Data Security
Understanding the importance of data security, especially when handling classified information (as with Naval Group), I adhere to stringent security protocols and align with each client's specific guidelines. My approach ensures the utmost confidentiality and integrity of your data.
Performance Optimization
Performance optimization is key in my services. For instance, for Accor's Fidelity program, I developed an ETL process to manage seven years of customer data, resulting in a highly efficient fact table with over 900 million entries.
Technological Expertise
My proficiency in various database systems (SQL Server, MongoDB, MariaDB, PostgreSQL, SQL Lite, Oracle) and ETL tools (SSIS, Alteryx, Apache Airflow, Informatica PowerCenter, Azure Data Factory), along with warehouse solutions (AWS, Google Data Warehouse Tools, Microsoft Azure Data Warehouse Tools, Snowflake), enables me to offer versatile and tailored solutions.
Data Migration and Integration
I have extensive experience in data migration and integration, adept at creating ETL scripts that bridge different applications and systems, ensuring seamless data flow across diverse platforms. My solutions are designed with future scalability in mind, accommodating the evolving needs of large-scale enterprises and adapting to both cloud and local server environments.
Comprehensive Documentation and Training
Upon project completion, I provide comprehensive documentation, including DB schema, structure, ETL systems, and project reviews. Additionally, I offer training sessions to ensure your team is well-equipped to manage and maintain the systems efficiently.