Freelancer profile translated to English.

Description

Microsoft BI Consultant with 7 years of experience, including 5 years in BI/Big DATA, mainly in Microsoft environments (On-premise and cloud), but also proficient in Talend and Tableau. I am passionate about data and data transformation. Through my various experiences, I have acquired analytical and interpretive skills, as well as a true sense of service and organization.

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Bourg-la-Reine (up to 50km), Antony (up to 15km)

Groupe THOM (Histoire d'Or, Marc Orian…)
Tech lead Microsoft BI
January 2023 - Today (3 years and 7 months)
❖ Technical environments: SSIS/ORACLE PL-SQL/SQL Server/Power BI, ❖ Functional environments: CRM, E-Commerce, Finance. ❖ Main Tasks:
• Audit of CRM data quality
• Analysis of SFCC data and data from web sales.
• Implementation of email alerts for SSIS errors
• Development and maintenance of SSIS data flows
• Analysis and correction of internal data quality maintenance processes
• Supervision of data quality failures
• Improvement of data quality at the source (removal of duplicates, alerting in case of absence of relevant information in customer records)
• Supervision and quantification of bad data
• Monitoring the implementation of CRM data quality corrections (Duplicates, loyalty...)
• Implementation of stored procedures to manage alerts
• Implementation of Power BI dashboards for data quality monitoring
• Reporting of sensitive data (Anticipate CNIL controls)
Axa
Consultant Big/data
BANKING AND INSURANCE
February 2020 - August 2021 (1 year and 6 months)
Nanterre, France
Big data IT consultant, data processing on the cloud, data ingestion on Datalake Azure Azure Data Factory, azure storage, development of Azure Analysis Services tabular cubes, development of Azure Databricks Pyspark and scala notebooks, Power BI reports development.
Microsoft Azure DevOps Big Data Databricks Microsoft Power BI Ssas Azure analysis services
Groupe BPCE
DBA Administrator and Microsoft BI technical referent
August 2021 - December 2022 (1 year and 4 months)
❖ Technical environments: SSIS/SSAS/SQL Server/Microsoft Power BI. ❖ Functional environments: Cross-functional services ❖ Main Tasks:
• Administration and maintenance of existing Microsoft SQL Server databases
• Implementation of an email alert system for production monitoring
• Automation of documentation processes
• Microsoft SSIS and SSAS monitoring.
• Implementation of automated processes for optimization and analysis of database performance
• Analysis and investigations in case of crashes or optimization flaws
• Optimization of SSIS flows and T-SQL queries
• Development and implementation of new data flows
• Optimization of Power BI reports and SSAS data models
• Development of C# .NET scripts for data transformations.