Malik Deghoul

Project: ASIF – Finance SI Analysis Finance SI Analysis is a daily information repository for financial information (accounting, management, and logistics) from SAP Project: DLK Compta DLK Compta is a decision-making tool dedicated to Data Analysts of CSP2C (EDF's accounting department)

Tasks:

- Design and implementation of new solutions (ETL and Reporting)

- Optimization and evolution of existing applications (ETL and Reporting)

- Performance improvement of stored procedures to ensure efficient data processing

- Monitoring of production incidents and communication with various stakeholders

- Migration of SQLS, SSIS, SSRS, and MDS components (2014 to 2017, then 2017 to 2019)

- Installation and configuration of development, testing, and production environments during SQL Server migrations

- Installation, configuration, and administration of the Power BI Report Server platform (server version upgrade every 6 months).

- Use of SAP transactions (ME23N, MIR4, FB03, and VF03, etc.) to consult data from CO, FI, MM, and SD modules

- Training and mentoring of team members (junior consultant, intern, and apprentice) on Microsoft technologies (Technical Referent)

- Participation in the analysis of business requirements and specifications issued by the business unit

- Replacement of the project manager for a period of 12 months: leading team meetings, tracking tasks with the business unit, leading steering committees

Projects: Copilote/ Waouh and NRJ Waouh and NRJ - Decision-making system for piloting Engie Cofely's activities for its clients in service and energy (operational performance, satisfaction, budgets, and costs…)

Copilote - Decision-making system for internal piloting across all company functional areas (HR, sales, operations, finance…)

Role: Experienced SI Consultant - MS BI Technical Referent

- Needs analysis

- Evolution of the architecture and decision-making model (Data Warehouse and Datamarts)

- Development/evolution of data feeds with SSIS: Optimization of T-SQL stored procedures, Optimization of SSIS feed packages, Integration of a new IS (Maximo) into Wahou

- Development of SSRS reports

- Evolutions of SSAS cubes

- Study on migration from 2008R2 to 2014

- Preparation of DataSources for Tableau Software reports

- Mentoring interns and junior consultants.

Technical Environment: SQL Server 2008 R2, SSIS/SSRS/SSAS 2008R2, Tableau Software

Project: Endemol Financial Monitoring Decision-Making System

Role: Experienced SI Consultant - Technical-Functional Referent

Analysis of needs

Evolution of the architecture and decision-making model (Data Warehouse and Datamarts)

Technical design of the solution.

Development of data feeds with SSIS

Creation of MDS entities

Implementation of business rules (management rules in MDS).

Analysis and correction of anomalies/evolutions identified during the acceptance phase.

Technical Environment: SQL Server 2014, SSIS 2014, Master Data Services 2012 (MDS)