Mokrane Saoud

Mission tasks:

Implementation of a business intelligence solution for real-time collection monitoring - BI Suite 2016 ·

• Implementation of the BI architecture, design, and modeling ·

• Creation/Optimization of packages (SSIS)

• User monitoring, advice, and support.

• Implementation of PowerBI reports.

• Creation of tables, views, stored procedures, and post-deployment scripts with T-SQL.

• Deployment and continuous integration of the solution with GIT and DevOps, implementation of deployment pipelines.

• Creation of reports and implementation of pipelines with Power BI

• Business monitoring, advice, and support

Implementation of a business intelligence solution for monitoring PEAEC AND PEEC services - Azure

• Implementation of the BI architecture, design, and modeling ·

• Creation/Optimization of pipelines (Azure Data Factory)

• Implementation of a Data Lake (Azure Data Lake)

• Implementation of storage accounts (Azure Storage)

• Deployment and continuous integration of the solution with GIT and DevOps.

Technical environment: SQL Server 2016, Power BI.com, Power BI Desktop, Visual Studio 2017, SCRUM Agility, Integration Services 2016, DevOps, Git, Dax, Azure Data Factory, Synapse, Azure Data Lake

Implementation of a business intelligence solution for real-time management of sales, purchases, and inventory from the Microsoft Dynamics AX ERP with the MSBI 2017 suite.

- Implementation of the BI architecture, design, and modeling

- Creation/Optimization of packages (SSIS)

- Creation of a Tabular cube (SSAS)

- User monitoring, advice, and support.

- Security/Roles implementation

- Dashboard generation (SSRS), Power BI

- Deployment and continuous integration of the solution with GIT and TFS.

- Sharing and scheduling of Power BI dashboards.

Technical environment: SQL Server 2017, Analysis Services Tabular 2017, Power BI, Power BI Desktop, Visual Studio 2017, SCRUM Agility, Integration Services 2017, Git, TFS, Reporting Services 2017

Implementation of a reporting solution for managing credit portfolios - BI Suite 2012

- Implementation of the BI architecture, design, and modeling

- Refactoring/Creation/Optimization of packages (SSIS)

- Creation of a multidimensional cube (SSAS)

- Dashboard generation (SSRS)

- Support for Tableau reports (Tableau Software 8)

- User monitoring, advice, and support.

Technical environment: SQL Server 2012, Analysis Services Multidim 2012, Power BI.com, Power BI Desktop, Visual Studio 2015, SCRUM Agility, Integration Services 2012, Tableau Software 8, Reporting Services 2012.