Freelancer profile translated to English.

Description

Experienced professional in implementing and optimizing Business Intelligence solutions based on the Microsoft suite and the Azure platform.

Expertise in designing, developing, and deploying robust analytical solutions, integrating technologies such as Power BI, Azure Data Factory, and Azure SQL Database. Strong skills in data modeling, ETL, as well as creating dynamic and interactive reports for informed decision-making.

Proven experience in integrating data from multiple sources, and collaborating with multidisciplinary teams to align technological solutions with strategic business objectives.

Ability to solve complex problems and lead digital transformation initiatives to improve organizational performance and efficiency.

Industry field of expertise

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Grant Thornton France
MSBI/Power BI Consultant
October 2022 - Today (3 years and 10 months)
Neuilly-sur-Seine, France
Manage and correct anomalies and incidents related to production.
Analyze and challenge business needs
Perform data integration tasks with SSIS.
Train colleagues and help skill development
Analyze and diagnose application integration, testing, pre-production, and production incidents
Provide support for business acceptance testing
JTI (Japan Tobacco International)
Data Integration/Power BI Consultant
March 2020 - September 2022 (2 years and 6 months)
Boulogne-Billancourt, France
Tasks performed:
Manage and correct anomalies and incidents related to production.
Analyze and challenge business needs
Perform data integration tasks with SSIS.
Create and modify stored procedures.
Add new KPIs as new indicators appear.
Perform acceptance testing / non-regression tests (TNR).
Daily and monthly monitoring of existing SSIS Jobs.
Create new jobs with the aim of fully automating data feeding.
Deploy SSIS packages to the SSISDB catalog.
Perform unit and integration tests.
Support for business and IT acceptance testing.
Design reports and dashboards with Microsoft PowerBI.
Migrate existing SSIS packages to Azure using Azure Data Factory.
Create data pipelines using activities, data flow, and schedule the pipeline using triggers in Azure Data Factory.
Use Logic App to monitor the arrival of new files on an SFTP server and trigger an ADF pipeline upon the arrival of each file.
Load data into Blob Storage and transform it using data flow.
Methodology: Scrum (Microsoft Teams)
Continuous integration: Microsoft Azure DevOps
Technical environment: SQL Server 2014/2016, T-SQL, SQL Agent, Sap business objects, UserLaunchJob, Power BI, TFS, VSTS, Excel, Access, SSIS Toolkit Manager, ServiceNow, Azure SQL DB, Azure DataFactory, Azure Blob, Azure Key Vault, Logic App
Altarea Cogedim
MSBI/Power BI Consultant
November 2019 - February 2020 (3 months)
Rue de Paris / Ruelle de Paris, Valenton, France
Mission: Intervention on a Reporting solution migration Tasks performed:
Analyze and challenge business needs
Create and modify stored procedures.
Report design.
Optimization of SSRS report queries.
Design reports and dashboards with Microsoft PowerBI.
Perform unit and integration tests.
Support for business and IT acceptance testing.
Production deployment of SSRS reports.
Methodology: Scrum (Microsoft VSTS, Microsoft Teams)
Continuous integration: Microsoft Azure DevOps
Technical environment: SQL Server 2016, T-SQL, MS Reporting Services, Sap business objects, Power BI, TFS, VSTS, Excel, MDX, JIRA