Freelancer profile translated to English.

Description

As a Data specialist since 2017, I am a professional focused on data management, analysis, and exploitation to derive strategic insights. My role involves transforming raw data into useful information for decision-making, using data processing and visualization tools. I intervene in various stages of the data lifecycle, from collection, cleaning, and structuring to interpretation and presentation. My goal is to make data accessible and understandable for teams and decision-makers, helping them optimize their strategies and performance.

Technologies: Informatica Powercenter, Alteryx, Tableau, Power BI, Python, Dataiku

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

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

Caisse des depôts et consignations
Data Business Analyst
November 2022 - Today (3 years and 7 months)
Bordeaux, France
Data Business Analyst: Project for migrating data from Oracle/BO to a BigData/Tableau architecture

• Facilitate requirements gathering workshops with various business units
• Write data dictionaries
• Design and model datamarts
• Validate the loading of pivot data and datamarts
• Alteryx: Create workflows for populating datamarts, analytical applications, and macros, and manage publications on the server
• Create Tableau Dashboards and manage publications on the server
• Migrate BO reports to Tableau
• Alteryx Support: Assist users in creating Analytics Apps or Alteryx workflows, ensure adherence to best practices
• Tableau Support: Assist users in creating, optimizing, using, and upskilling on dashboards, ensure adherence to best practices
• Dataiku Development for data preparation (replicating Alteryx usage): create flows and designer applications, develop pyspark, python, sql, create scenarios, partitioning

Technical Environment: DBeaver, Hue, Hive, Hql, SQL, Pyspark, Python, Dataiku, Alteryx Designer, Alteryx Server, Tableau Desktop, Tableau Server
Tableau Software Alteryx Alteryx Designer Dataiku PowerBI
Deloren
Data Engineer
March 2022 - November 2022 (8 months)
Paris, France
Sogecap - Data Engineer: Financial security project (filtering operations and client repositories on politically exposed persons and embargos)
• Write and present detailed technical specifications
• Design data transformation pipelines in pyspark
• Create universes, BO reports
• Create and maintain evolving Power BI reports and Dashboards
• Design and develop file ingestion flows into the datalake
• Extract individuals for filtering and cross-referencing operations using dbt (sql, tests, documentation)
• Create frameworks: launch jobs (shell scripts)
• Unit tests
• Write technical documentation (PVs, Operational Documents)
Technical Environment: Windows/Linux, DBeaver, SQL, GCP, Snowflake, DBT, Hive, Spark, GitHub, Shell, MobaXterm, Oozie, Power BI (desktop and service, DAX language), Business Object
Gitlab CI/CD Microsoft Power BI SAP Business Objects DBT Snowflake
ACII
Data Analyst
November 2020 - March 2022 (1 year and 4 months)
MAIF - Data Analyst: Policyholder claims observation project
• Gather and analyze business needs
• Write user manuals
• Technical design
• Create complex SQL view generation queries
• Develop Alteryx In-DB Workflows and migrate SAS processing to Alteryx
• Implement a Spotfire simulation tool
• Define KPIs in collaboration with business teams
• Power BI reporting and dashboards
• Unit tests and validation
• Demonstrate to various committees and business units
• Analyze user feedback and correct anomalies

Technical Environment: Windows/Linux, Alteryx Designer, Power BI, Spotfire, IronPython, DBeaver, Netezza, Hive, SQL, GitHub, Jenkins
Data Analysis Alteryx Spotfire Data Visualization Microsoft Power BI