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

Domaines d’expertise

Langues

Français
Bilingue ou natif
Anglais
Capacité professionnelle complète

Préférences en matière de lieu de travail

Accepte de travailler sur site

Lyon (jusqu’à 50 km)

Linxcom
BI developer (freelancer)
août 2024 - octobre 2025 (1 an et 2 mois)
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
janvier 2018 - mai 2024 (6 ans et 4 mois)
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.