Ayoub BENKHOUI

Implementation of BI solutions for managing the commercial activity of Caisse d'épargne agencies in ÎLE-DE-FRANCE - Expression of needs with business teams - Creation and maintenance of stored procedures, SSIS packages for data integration - Creating data models - Maintenance of reports under SSRS - Creating reports in Power BI - Sharing reports on Power BI service by setting up data access restrictions/permissions - Training and supporting users on reports, helping them extract relevant information and valuable insights - Maintenance and evolution of Power BI reports and SSIS packages

Development of an analysis approach to identify recurring non conformities - Expression of the business need for the A350 quality service - Development of SSIS (SQL Server Integration Services) packages to enrich the non conformities database - Cube construction for advanced analytics using SSAS (SQL Server Analysis Services) - Setting up Dashboards using Power BI to have the visibility on the inflow of non conformities, concessions and scraps - Conducting analysis which provides Quality team with detailed KPIs on the non conformities evolution - Producing and delivering Central reports each month - Identification of the most recurring production issues - Setting up tools for corrective actions follow-up - Gain estimation of the identified actions & Highlighting the impact on the global non quality cost - Training and supporting users on the reports, helping them extract valuable insights - Maintenance and evolution of Power BI applications, SSIS packages, and existing SQL stored procedures

Establishment of a strategy to reduce non conformities in order to minimize non-quality costs and production disruptions - Expression of the business need for the A330 quality service - Implementation of a tool for identifying non-conformities in order to minimize non-quality costs and production interruptions - Development of KPIs, dashboards and reports in Excel to visualize the evolution of non-conformities - Implementation of tools for monitoring corrective actions - Reporting to the client - Estimation of realized gains - Training of users of the tool put in place

Evaluation of the project management of Morrocan customs administration by comparing it to the PMBOK framework. - Development of a questionnaire for project managers. - Statistical analysis (AFCM) of collected data. - Definition of deviations from the PMBOK and proposition of solutions.

Development and design of a VB.net application for payroll. - MERISE design of the database with POWER AMC & implementation in SQL SERVER. - Application development using VB.net.