Mohamed Ben Moula

Migration of the Natixis BI data warehouse from Sybase IQ to MS SQL SERVER:

. Migration of flows (Trade, title, share, Risk, Compliance, Reporting,…) from Sybase IQ to a new data warehouse under Sql Server

. Creation of tables, Indexes, complex stored procedures in T-SQL.

. Optimization of existing code.

. Optimization of processing under Control M.

. Scheduling of processing with the ETL (Internal Natixis tool).

. Recipe of developed flows (Comparison with SAP BO reports).

. Deployment of the solution on Sql Server and Control M

Project: Development of a decision-making solution for the analysis of sales, purchases and stocks from the Microsoft Dynamics AX ERP with the MSBI 2017 suite.

• Setting up the solution architecture, design and data modeling.

• Database:

• Definition of tables and columns to be loaded from the data source.

• Creation of the database project.

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

• Data integration:

• Creation of 3 layers: Collection, operational (Staging) and warehouse (Datawarehouse) for data integration from the Microsoft Dynamics AX ERP in real time.

• Creation and optimization of SSIS packages and scheduling of jobs with SQL Server Agent.

• Data analysis:

• Definition of measures (KPI) according to user needs.

• Creation of a tabular cube and measures in DAX.

• Role management.

• Data restitution:

• Development and deployment of Power BI reports for Chanel teams in Germany and Austria.

• Development and deployment of SSRS reports for Chanel ITALY teams.

• Sharing and scheduling of Power BI dashboards.

• Support and assistance to users to consolidate data from the cube.

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

• Project management according to the Agile Scrum methodology (Sprint of 2 weeks).

Environment: SSIS, SSAS Tabular, SSRS, SQL Server 2017, T-SQL, DAX, Power BI, Dynamics AX, TFS, GIT

Processing requests from business lines: Treasury, Credit Management, Business Development, Operational Consulting Outsourcing, Human Resources:

• Development and deployment of an SSIS solution for the HR team for the mass integration of Gant Thornton employee data into the Supermood tool (employee engagement measurement tool).

• Development of dashboards (Power BI) to analyze the distribution of employees and teams by site.

• Development and deployment of SSRS reports for audit teams (Visualization of opportunities and appointments) from the CRM Selligent tool database.

• Development and deployment of SSRS reports for treasury teams. (Visualizations of bank account statements by company and by bank)

• Application support for "Credit management" teams for the management of debt collection and doubtful debts.

• Development and deployment of SSRS reports for "Credit Management" teams for the analysis of doubtful debts by partners and by companies.

• Application support for business lines by processing their requests on the various applications (Clarity, SSRS Reporting, SQL).