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

Ayoub Benkhoui

CONSULTANT BUSINESS ANALYST DATA

€900/day
Le Plessis-Robinson, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ayoub

  • French

    Native or bilingual

  • Arabic

    Native or bilingual

  • English

    Fluent

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

Experience

  • TOTALENERGIES MARKETING & SERVICES
    CONSULTANT BUSINESS ANALYST DATA
    ENERGY AND UTILITIES
    November 2023 - Today (2 years and 9 months)
    La Défense, France
    Implementation of BI solutions for the management of petroleum product stocks for subsidiaries in Africa

    - Scoping of needs expressed by business teams
    - Expression of business needs for BI teams
    - Supervision / Testing of developments carried out
    - Exploitation and cross-referencing of data from multiple sources
    - Automation of data extractions with Power Automate
    - Modification of Power BI datasets (Data transformation, DAX measure creation, data model modification...)
    - Creation and maintenance of reports in Power BI
    - User access management
    - Documentation of developed Power BI reports
    - Monitoring the usage of deployed reports
    - Support and Training of subsidiary users on the reports

    Technical environment: Power Automate, SQL Server, Power BI

    Assistance to project ownership and implementation of BI solutions in the Supply perimeter for all subsidiaries of the MS branch

    - Supervise the integration of SAP data (MM, PCA, COPA) into the data warehouse & data recovery in case of integration problems
    - Participation in operational and strategic committees for project monitoring
    - Scoping of reporting needs expressed by business teams
    - Exploitation and cross-referencing of data from multiple internal and external sources
    - Modification of Power BI datasets (Data transformation, DAX measure creation, data model modification...)
    Creation and maintenance of reports in Power BISuivi of the usage of deployed datasets/reports
    - Documentation of developed Power BI reports
    - Support and Training of deployed subsidiary users, helping them extract relevant information
    Microsoft Excel SQL Server Tabular Editor Microsoft Power BI SAP MM
  • CEIDF - Département Pilotage BDD
    CONSULTANT DATA ANALYST
    BANKING AND INSURANCE
    November 2022 - October 2023 (11 months)
    Paris, France
    Implementation of BI solutions for monitoring the commercial activity of Caisse d'épargne agencies in IDF

    - Gathering business needs from teams
    - Creation and maintenance of stored procedures, SSIS packages for data integration
    - Creation/Modification of data models
    - Creation of reports in SSRS
    - Creation of reports in Power BI (Using DAX for measure creation)
    - Sharing reports on Power BI service by setting up data access restrictions/permissions
    - Training and support of users on reports, helping them extract relevant information

    Technical environment: SSIS, SSRS, SQL Server, Power BI
    Microsoft Power BI Microsoft SQL Server Microsoft Power Query Microsoft Excel MS BI
  • AIRBUS OPERATIONS SAS
    CONSULTANT DATA ANALYST
    AVIATION AND AEROSPACE
    April 2016 - April 2022 (6 years)
    Saint-Nazaire, France
    Implementation of solutions for identifying recurring non-quality issues

    - Gathering business needs from the A350 quality department
    - Development of SSIS packages (SQL Server Integration Services) to populate the database
    - Construction of cubes in SSAS (SQL Server Analysis Services)
    - Implementation of dashboards in Power BI to gain visibility on the influx of non-conformities, concessions, and scrap
    - Development of SSRS reports for the quality department and for production
    - Identification of the most recurring non-quality issues
    - Estimation of gains from identified actions & Highlighting the impact on the overall cost of poor quality
    - Training and support of users on reports, helping them extract relevant information

    Technical environment: SAP, Excel, SSIS, SSAS, SSRS, SQL Server, Power BI
    Microsoft Power BI excel SAP QM MS BI

Recommendations

Be the first to recommend Ayoub

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

  • Bachelor of Science in Techniques - Mathematics and Computer Science
    Université HassanII
    2011
    Licence sciences et technniques - Mathématiques et Informatique
  • Master in Business Intelligence and Project Management
    Université Ibn Tofail
    2013
    MasterMaster en Informatique décisionnelle et Management de projets

Skill set

Categories