Description

Fort d’une expérience de 16 ans dans le domaine BI et des ETL, je sais mener à bien les missions qu’on me donne . De la modélisation au développement de rapport BI en passant par une forte expertise ETL , mon profil est complet

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Lyon (up to 50km)

Linxcom
BI developer (freelancer)
August 2024 - October 2025 (1 year and 2 months)
Geneva, Switzerland
. Gather and analyze business requirements, translating them into technical BI specifications through close collaboration with stakeholders.
• · Design and implement data warehouse and data mart models using star schema, optimizing data storage and retrieval processes.
• · Develop and maintain robust ETL processes for seamless data extraction, transformation, and loading from multiple sources like databases, APIs, and flat files.
• · Build and optimize SQL queries, stored procedures, and data pipelines to ensure efficient data processing and retrieval.
• · Create and manage interactive dashboards and reports with Power BI, enhancing data visualization and business decision-making capabilities.
• · Document all BI processes, data models, report logic. . Implement data security standards to safeguard data integrity and compliance.
Msc
Senior ETL Developer / BI Team Lead
January 2018 - May 2024 (6 years and 4 months)
Geneva, Switzerland
• · Developed robust ETL processes and migrated SSIS interfaces to Informatica PowerCenter, improving data management and reliability.
• · Translated business needs into clear and actionable requirements.
◦ · Developed robust ETL processes in Informatica PowerCenter and Informatica Data Quality.
◦ · Migrated ETL interfaces from SSIS to Informatica PowerCenter and created technical specifications.
◦ · Performed gap analyzes to assess current processes versus desired outcomes.
◦ · Authored several documents in Jira.
◦ · Created interface monitoring using PL/SQL. Tuned SQL queries.
◦ · Created reliable ETL framework for data recovery in case of failure.
◦ · Spearheaded data profiling initiatives to ensure data accuracy and integrity.
◦ · Led data profiling and implemented quality checks with enhanced SQL tuning, refining data accuracy.
◦ · Authored specifications and leveraged DevOps to improve delivery and efficiency through streamlined deployment.
◦ · Directed Alpha and Beta testing to ensure system robustness and reliability.
◦ · Utilized SQL and PL/SQL for interface monitoring and simplified the data recovery process within the ETL framework.
◦ · Enhanced project transparency and delivery using Kanban methodology.
• · Troubleshoot data and performance issues in BI reports and ETL workflows.
◦ · Hired as Consultant in 01/2018 and transitioned to a permanent position by 07/2018, reflecting strong performance.