Athmane G.

 Study and design of the target technical and functional BI architecture.

 Create and modeling Data warehouse (fact and dimension tables under SQL Server 2019).

 Drafting detailed technical specifications.

 Development of Talend jobs and supplying the BI chain (SA, ODS, DWH).

 Take charge of data recovery requirements from different sources, of transforming and supplying the target data warehouses and data marts.

 Historical data migration and transfer from the old DWH to the new DWH (20 years of data).

 Modeling of the data mart layer and supplying through stored procedures.

 Development of tabular cubes by functional domain and creation of measures under SSAS.

 Application interface: data exchange from the new DWH to the CEGID billing system.

 Conducting unit tests, acceptance tests, and pre-production testing.

 Drafting technical documentation.

Project - CRM: Production of reports to analyze Cevital's customers and sales by segment

Project duration: 15 months

Team: 2 Data Analyst/Engineer

Tasks :

 Detailed preliminary study of the CRM solution (Sales Buzz) and needs analysis.

 Identification of relevant indicators for sales and marketing activities.

 Modification of the datawarehouse data model (SQL Server 2019).

 Development of Talend jobs.

 Consolidation of business data in Microsoft Master Data Management (MDS) to create a single customer record.

 Development of tabular data cubes.

 Production of business performance dashboard reports using Power BI.