Mohamed Ridha B.

Development of solutions around the central data platform to facilitate data access and usage (Azure SQL DB, Cube, Power BI):

- Data warehouse modeling, partition management.

- Creation and maintenance of SSAS Tabular cubes.

- Development of Business Power BI dashboards and reports (deployment, RLS…)

- Master Data Services development (entity creation, versioning, loading, business rules,

user training)

- Design and writing of functional and technical specifications as well as technical documentation and user guides for data valorization with the decision support system, including mock-up creation, workflow design, and participation in the overall system design.

- Implementation of "best practices" for SQL/SSIS/SSRS/SSAS developers.

- Leading development methodology workshops and training on Azure DevOps/TFS / new versions of SQL Server/VS.

- Writing technical documentation for database projects under TFS / deployment and configuration of SSIS packages.

- Redesign of incremental loading data model.

- Database design (tables, views, schema, constraints), T-SQL development (Trigger, SP, CTE, function) and SQL development management under TFS.

- Code review and optimization of T-SQL processes (Tuning).

- Development of SSIS integration pipelines.

- Development of SSAS tabular cubes.

- Power BI report design.

- Migration of SSRS reports/SSIS packages from versions 2008/2015 to 2017.

Implementation of a BI platform (SSIS, SSRS, SSAS):

• Training of an internal team on the MS BI suite (10 days).

• Documentation, naming conventions, best practices, and training support for TFS and database projects (DACPAC, BACPAC).

• Configuration of Team Foundation Services.

• Integration of data from 300 Leclerc stores via SSIS.

• Database design and development: ODS and DWH.

• T-SQL development, SQL code review, and processing time optimization.

• Development of SSRS reports (production and summary).

• SSAS cube implementation.

• Documentation of SSIS, SSRS, and SSAS SFD.