Mohammed Hamdi

Project 1 - Implementation of the Decision Support System for monitoring the transition of copper lines to very high speed/fiber optics (calculation of the park of accesses by client views, geographical area, eligibility, etc.)

Project 2 – Development of a solution to monitor the financial activities of the Orange Group

Main Missions:

- Analysis and Understanding of the expressed need.

- Writing of Functional and Technical Specifications. - Design & Modeling of Databases, DataMarts, and DataWarehouses.

- Design of ETL data integration flows with SSIS.

- Audit and optimization of ETL processes.

- Deployment of Multidimensional and Tabular OLAP cubes by SSAS.

- Creation of Power BI and Tableau Reports.

- Unit and integration tests.

- Monitoring of integration, acceptance, and production deployment.

- Management of feedback and correction of anomalies.

- Monitoring of server performance (CPU, RAM, Storage, ...)

- Writing documentation on Confluence. Tools: SQL, T-SQL, SQL Server, SSIS, SSAS, Power BI, Visual Studio,

Implementation of decision support solutions for business teams: Management Control, Marketing, Networks.

• Study & Analysis of expressed needs and their feasibility and development of the specifications document.

• Support for different stakeholders during analysis workshops.

• Design and modeling of Projects (star model, snowflake model).

• Implementation of ETL Flows (SAP BI).

• Creation of universes, reports, dashboards (SAP BO).

• Support for business teams during acceptance testing.

• Preparation of prerequisites for production deployment.

• Implementation of appropriate project documentation.

• Processing and analysis of reported anomalies.

• Monitoring and support of processes with service providers.

Implementation of decision support solutions for major clients (Orange, Samsung, SFR, TotalEnergies…)

• Study of the expressed need and development of the specifications document.

• Conducting analysis workshops to define the necessary mapping and business rules.

• Design and Modeling of Databases and DataWarehouses (SQL SERVER).

• Creation of ETL Flows (SSIS).

• Creation of OLAP Cubes (SSAS) and Reports/Dashboards (SSRS/POWER BI) and automation of sending with C#.

• Acceptance monitoring with the client.

• Preparation of prerequisites for production deployment.

• Implementation of appropriate project documentation.

• Ensure the maintenance of Projects in Production.