You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Alex DzukamAD

Alex Dzukam

Senior BI & Data Analyst — Optimization

€600/day
1 project
Le Plessis-Robinson, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Alex

Senior BI and Data Analyst Consultant, I help companies transform their data into actionable elements and make their decision-making fast and robust.

My specialty: diagnosis and performance optimization of dashboards and the BI chain.

My added value comes from a dual skill: business expertise and data mastery, as well as a structured diagnostic approach.
I identify the root cause across the entire chain, I manage the investigation with the relevant teams, and I align the right expertise to remove blocking points.

Some achievements:
- BNP Paribas: diagnosis of an undersized Oracle server which led to doubling its RAM and restoring a critical, unusable dashboard.
- Bouygues Telecom: redesign of an SQL model (Teradata) reducing execution time from ~2h to a few seconds.
- GIP e-Santé Centre Val de Loire: database quality audit and design of business rules.
- Design of prediction methods for the 4G/5G mobile network (Dataiku, Python).

My interventions: audit and optimization of dashboards (Tableau, Power BI), design of decision-making dashboards (dataviz), optimization and reliability of SQL queries and models, implementation of data quality controls, and integration of generative AI to accelerate analytical production.

Technical environment: SQL (Teradata, Oracle, SQL Server, MySQL, Impala, Hive), Power BI (certified), Tableau Desktop & Server, Power Query / DAX, Python, Dataiku
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Le Plessis-Robinson (up to 50km), Paris (up to 50km)

Experience

  • BNP Paribas
    Data Analyst
    BANKING AND INSURANCE
    April 2025 - Today (1 year and 4 months)
    Paris, France
    Handling requestsin the form of tickets: enhancements to existing dashboards, incident resolution, design of new dashboards (Tableau).
    • **Managing dashboard performance optimization**: transverse investigation across the Tableau Server / Oracle / databases chain, leading meetings, highlighting undocumented blocking points.
    • **Diagnosis of a major infrastructure bottleneck**: highlighting that the Oracle server processing SQL queries for Tableau Server was undersized.
    • **Technical facilitator role**: asking the right questions, guiding analyses, and aligning experts to resolve complex performance issues.
    Jira ServiceNow Agile method Tableau Troubleshooting
  • Bouygues Telecom
    Billing Data Analyst
    TELECOMMUNICATIONS
    February 2023 - March 2025 (2 years)
    Meudon, France
    I joined a billing control team for fiber connection services for clients:
    - Responsibility for enhancements to automatic controls (in SQL)
    - Redesign of the SQL model for tables and views to improve the performance of the billing control system:
    -- Execution time gain: tens of seconds vs. 2h
    -- Implementation of historization
    - Expertise support for Build: continuous improvement of the billing control process.
    Teradata SQL Tableau software Microsoft Power BI Optimization
  • GIP e-Santé Centre Val de Loire
    Data Analyst Expert
    PUBLIC SECTOR
    November 2022 - February 2023 (3 months)
    Olivet, France
    Expertise for resolving anomalies on repositories
    - Client interviews regarding the context
    - Familiarization with the technical environment (e-health tools)
    - Data collection and cleaning (Power Query and M Language)
    - Overall assessment of the problem
    - Reverse engineering and identification of unknown business rules.

    SQL Database familiarization
    - Client support on manipulation (MySQL)
    - Visual restitution of the Physical Data Model
    - Creation of SQL procedures to facilitate client use.

    Tools: e-health tools, Power Query, M Language, MySQL
    Microsoft Power Query M Language MySQL Microsoft Excel

Reviews

5.0

Out of 1 rating

E

Emilie

E.Santé Centre-Val de Loire

Reviewed on 2/2/2023

I had the pleasure of working with Alex on a three-month mission. Alex was able to adapt quickly to the e-health environment. He helped us analyze discrepancies in our object database and hypothesize about the origin of the anomalies. He has a perfect command of database querying, Excel, and Power BI. Alex is proactive and very responsive. His deliverables are of high quality and have helped us resolve complex situations. Alex also has excellent interpersonal skills and knows how to adapt his communication to his audience. I highly recommend working with Alex.

Recommendations

Be the first to recommend Alex

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Engineering degree, Telecommunications
    EPF Engineering School
    2012
    Diplôme d'ingénieur, Télécommunications
  • Semester of study, Networks and Telecommunications
    University of Montreal - Polytechnique Montreal School
    2012
    Semestre d'études, Réseaux et Télécommunications

Skill set

Categories