Freelancer profile translated to English.

Description

Your data is there. The insights, however, are waiting to be discovered.

After 19 years at the heart of the Caisse d'Épargne Group's information systems, one conviction has solidified: data only has value when it is reliable, fast, and understood by decision-makers.

What I do concretely for my clients:

▶ SQL DIAGNOSIS & OPTIMIZATION

I audit and rework Oracle/SQL queries that are slowing down your performance.

Typical result: -80% on the execution times of critical processes.

▶ POWER BI & DECISIONAL REPORTING

I build reliable and secure dashboards (dynamic RLS), directly usable by your executive committees and management. I have deployed solutions used by 50+ decision-makers.

▶ DATA QUALITY & GOVERNANCE

I integrate audit rigor into every project: 0 error acceptable on financial or strategic data.

▶ DATA ANALYSIS & EXPLOITATION

I transform your raw data into actionable indicators, from SQL extraction to the final report.

My unusual background? 6 years in internal banking audit, where I designed SQL queries to automate control sampling and produce environmental and risk analyses — and gained a rigor that only field experience can forge.

Certifications: Microsoft Power BI (PL-300)

In progress: Microsoft Fabric (DP-600)

All sectors of activity.

Terms: Freelance | Remote or hybrid | Daily rate €500 | Immediate availability

Do you have a data project in progress, an unforeseen workload increase, or reports that don't inspire confidence in your management?

Contact me directly: |

Industry field of expertise

Languages

French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Caisse d'Epargne Côte d'Azur
Senior Data Expert & Decision Support Architect
BANKING AND INSURANCE
January 2019 - August 2024 (5 years and 7 months)
Nice, France
▶ Design and optimization of complex SQL queries on Oracle databases (1M+ B2C/B2B clients, tables >50M rows) — data modeling, tuning, and structuring
▶ Reduction of execution times by over 80% on critical processes
▶ Production of ad hoc analyses at the request of General Management and Mandate Holders: strategic figures, zero error tolerance
▶ SQL extraction and targeting for Marketing campaigns (customer segmentation, commercial listings)
▶ Design and deployment of 5 Power BI reports in production (including MicroStrategy to Power BI migration): business needs gathering, SQL queries, modeling — used by 50+ COMEX decision-makers
▶ Security & confidentiality: implementation of dynamic RLS (Row Level Security) across the entire BI scope
▶ Data Quality: guarantee of financial data integrity, 0 error on strategic reporting
▶ Mentoring of 4 junior profiles (Data Analyst) over the last 4 years
Oracle Microsoft Power BI SQL Data Analysis Data Modeling
Caisse d'Epargne Côte d'Azur
Data Auditor & SQL Expert | Internal Control & Information System Reliability
March 2013 - December 2018 (5 years and 9 months)
Nice, France
▶ Automation of control samples via SQL: progressive replacement of manual procedures by the audit team
▶ Mass audit of financial data flows: identification and correction of systemic flaws
▶ Writing of audit reports for management: Managers, Directors, and Mandate Holders
▶ Development of automated control tools on SAP BI4, sustainably reused by the audit team
▶ Strict application of Basel II standards and banking regulatory constraints (laws, codes, internal procedures)
SQL Optimization Data Quality Oracle SAP BI4 SQL
Caisse d'Epargne Côte d'Azur
Marketing Data Analyst Lead | Customer Segmentation & Sales Reporting | SQL Oracle
BANKING AND INSURANCE
April 2009 - March 2013 (3 years and 11 months)
Nice, France
▶ Design and execution of complex customer segmentation campaigns: multi-criteria targeting on 1M+ profiles
▶ Translation of business needs into performant SQL queries: direct interface between business units and IT department
▶ Construction of sales monitoring dashboards on SAP Business Objects used by regional management teams
▶ Optimization of source data access times: significant reduction in reporting delays
Oracle datamining Reporting Marketing SQL

Check out Mickaël's experience

Be the first to recommend Mickaël

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

DESS: Sciences, Computer Science and Digital Technologies
Université Claude Bernard Lyon 1
2004
DESS : Sciences, Informatique et Techniques Numériques
Master's Degree in Mathematical Engineering
Université Claude Bernard Lyon 1
2003
Maîtrise