Freelancer profile translated to English.

Description

Hello, I am Jacques,

A Data Analyst Consultant with 7 years of experience, I support companies in transforming their data into reliable and actionable decision-making tools.

Specializing in Power BI, SQL, ORACLE, SAAS, and data environments, I work across the entire chain.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational
Italian
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

AXA
Data Analyst
BANKING AND INSURANCE
January 2025 - Today (1 year and 7 months)
Paris, France
Within the dematerialization team, the mission is:

Optimize (Shell) scripts for return flows from service providers containing registered mail numbers.
These optimizations will aim to considerably reduce the processing time of files loaded into our database (ADF).

Automatically populate the database via scripts.

Catch up when loading problems are encountered.

Implement additional controls on generated scripts to avoid any data loading and batch closing problems.

Bring enhancements to existing Power BI reports.

Implement new Power BI reports.

Achievements

- Optimization of (Shell) scripts for return flows from service providers containing registered mail numbers

_ Implementation of additional controls on generated scripts to avoid any data loading and batch closing problems (PowerPoint)

- Management and oversight of loading and updating data for AXA France and sister entities (Sogarep, Direct Assurances, Mutuelle Saint Christophe)

- Ensure the update and loading of data for AXA France and all sister entities into the Oracle database.
- Make corrections on non-compliant data (perform catch-ups)

- Creation of over 15 reports on Power BI for all AXA France sister entities and for the E-sign team (dedicated to electronic signature tracking)

- Manage the monitoring of updates and their refresh

- Ensure the configuration of reports on Power BI Online and share reports with different users -

- Implement security on roles defined for each user according to their profile.
Power BI DAX Power BI Desktop Oracle SQL Developer Shell Script Power BI Services
BPCE
DATA ANALYST
BANKING AND INSURANCE
December 2021 - December 2024 (3 years)
Paris, France
Project Context:

Develop the Firco Web multidimensional cube, create Dashboards connected to the new database.
Analyze and investigate missing data (AML, QDI, STE) in the ODS, DWH, and Datamart. Finally, bring enhancements to the Natixis AML Cockpit report.

Achievements:
Development of the Firco cube (creation of new tables, calculated fields, measures)
Execution of tests in the Bench environment, and deployment of the cube in Production using the XL deploy tool, and SSMS for creating XML files
Creation of Dashboards, reports, and maintenance of their evolution
analyze missing data in source files and in the database. (GCP)
Execution of SQL scripts on GCP (Big Query)
Gathering client requirements
Use of Kanban for ticket tracking
Data modeling in the SSAS cube (Visual Studio)
Organization of presentation sessions for completed reports and client feedback collection
Creation of specification files and maintaining documentation for each report version
Administration of roles with security (RLS) on Power BI.

Technical Environment: Visual Studio 2022, XL Deploy, SSMS, SQL Developer, Excel, DAX, SQL, Notepad, Power BI, GCP (Bigquery)
Power BI Desktop Power BI DAX SQL SQL Server Analysis Services (SSAS) Oracle
SNCF
DATA ANALYST
TRANSPORTATION
November 2020 - November 2022 (2 years)
Paris, France
Project Context:

Provide Dashboards on ticket sales monitoring and information on train circulation throughout France.

Achievements:

Gathering client requirements
Participate in project steering meetings/Organize business workshops
Resolution of tickets and correction of anomalies/Maintain documentation
Execution of various SQL queries and scripts with GCP (BigQuery)
Analyze and formalize client business needs
Creation of Dashboards and publication on Power BI service (configuration of the gateway for different databases and alert configurations)
Creation of data visualization models/Maintain documentation for each reporting version
Data processing in Power BI Query
Power BI DAX SQL Oracle SQL Developer Microsoft Power BI Big Query