Freelancer profile translated to English.

Description

•Writing detailed functional specifications: data-oriented user stories, business rules, data dictionaries, source → target mappings.

•Collecting, cleaning, and transforming large amounts of data.

•Data modeling (3NF, star, snowflake) in different business contexts.

•Using visualization tools such as Tableau, Power BI, SAP BI, and Qlik to create dynamic reports.

•Applying statistical techniques and predictive models to identify trends and opportunities.

•Collaborating with multidisciplinary teams to translate business needs into relevant data solutions.

Industry field of expertise

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Poissy (up to 50km)

SNCF
Expert Power BI
TRANSPORTATION
November 2024 - Today (1 year and 9 months)
Saint-Denis, France
Migration of 4 business intelligence applications from QlikView to Power BI.
•Audit of existing Qlik applications (reports, scripts, data model)
•Identification of business KPIs and business rules
•Redesign of the data model into a star schema
•Optimization of relationships, cardinalities, and management of dimensions/facts
•Gathering user requirements and prioritizing reports for migration
•Analysis of functional gaps between Qlik and Power BI
•Implementation of security (RLS), access management
•User training and documentation writing
Microsoft Power BI SQL PostgresSQL Python DAX
CREDIT MUTUEL
DATA ANALYST
BANKING AND INSURANCE
June 2023 - October 2024 (1 year and 4 months)
Paris, France
Implementation and production of KYC indicators in the fight against money laundering and terrorist financing.
Mission conducted within a strict regulatory framework, aiming to better know clients, monitor transactions, and detect unusual behaviors.
• Collection and verification of client data (identity, income, activity, residence)
• Verification of documents, detection of sanctions and politically exposed persons (PEPs)
• Analysis of suspicious reports and atypical transactions
• Production of compliance reporting for control teams

Technical environment: SQL, Power BI, Vertica, Web Focus, Python
Python Development SQL Microsoft Power BI Web Focus
Banque de France
DATA ANALYST Power BI / SAP BI
PUBLIC SECTOR
October 2021 - April 2023 (1 year and 6 months)
La Courneuve, France
Migration of a SAP BI application to Power BI as part of the modernization of the business intelligence system.
The former application was redesigned and split into two new Power BI applications, with functional improvements for a smoother and more intuitive user experience.
• Audit of existing SAP BI universes, reports, and models
• Identification of KPIs, business rules, and business logic
• Gathering requirements and prioritizing objects for migration
• Development and supervision of semantic models and reports
• Analysis of gaps between SAP BI and Power BI, validation with business teams
• Publication on Power BI and configuration of refreshes

Technical environment: Power BI, SAP BI4, Oracle, PostgreSQL, SQL
Microsoft Power BI DAX SAP Business Objects SQL