Freelancer profile translated to English.

Description

BI Consultant specializing in data analysis and the design of decision-making solutions to optimize business performance. Expert in business intelligence tools, data modeling, and advanced reporting, I guide organizations towards informed strategic decisions. My passion for intelligent data utilization aims to transform challenges into tangible opportunities.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km), Bordeaux (up to 50km)

ALTEN
BI Consultant
DIGITAL AND IT
January 2021 - Today (5 years and 6 months)
Bordeaux, France
Design and deployment of end-to-end ETL pipelines (SSIS / Azure Data Factory) integrating 15+ heterogeneous sources
Migration and modernization of the data warehouse to SQL Server 2016, reducing processing times by 35%
Dimensional modeling (star and snowflake schemas) and T-SQL query performance optimization
Development of decision-oriented Power BI dashboards (KPIs, advanced DAX, RLS, publication on Power BI Service)
Exploratory and descriptive analysis of business data to identify trends, anomalies, and optimization opportunities
Creation of advanced analysis reports with interactive visualizations and data storytelling for the Executive Committee
Implementation of data quality indicators (data profiling, consistency checks) and monitoring of production pipelines
Close collaboration with all business departments (Finance, Accounting, HR, Marketing, Sales, Actuarial) to gather needs and deliver adapted BI solutions
Participation in Microsoft Fabric exploration (Lakehouse, Dataflows Gen2, Semantic Models)
Management of functional and technical acceptance testing (unit, integration, system) and writing of documentation
SSIS Power BI Desktop SQL Agile Methodology Python
CGI
SSIS Power BI Consultant
DIGITAL AND IT
March 2019 - January 2021 (1 year and 10 months)
Bordeaux, France
Architecture and design of complex ETL solutions for the integration of multi-source banking data
Development of optimized SSIS flows with error handling, logging, and incident recovery
Creation of analytical Power BI reports (tabular models, DAX, role-based security) for the Executive Committee
Audit of existing systems, identification of optimization areas, and reduction of processing times by 25%
Key contact for business teams (Finance, Risk, Compliance, HR, Marketing) for requirements gathering and deliverable validation
Effort estimation, writing of technical and functional specifications
Coordination and upskilling of a team of 2 developers
Implementation of version tracking
SSIS Microsoft Power BI SQL Server T-SQL Talend
Business & Decision - Occitanie
MSBI Consultant
CONSULTING AND AUDITS
March 2018 - March 2024 (6 years)
Marseille, France
Definition and implementation of the complete data warehouse architecture (star schema, dimensional modeling)
Development of 30+ SSIS packages for multi-source data ingestion and transformation
Design and deployment of SSAS OLAP cubes (multidimensional and tabular models) for advanced analysis
Creation of parameterized SSRS reports and Power BI dashboards with real-time indicators
Close collaboration with Finance, Accounting, Sales, and General Management departments to scope analytical needs and validate restitutions
Implementation of the testing strategy (unit, integration, system) and complete technical documentation
Training and support
SSIS SQL SQL Server Microsoft Power BI Oracle Database