Nourchene Fakhfakh

Summary: Creation of a decision support tool (BI) from scratch.

Realization:

• Facilitation and participation in business workshops

• Formalization of needs by business domain

• Meeting with IT for source data definition

• Writing specifications and master data definition

• Modeling the DWT of the database in a snowflake schema to aggregate data

• Data extraction and ETL flow creation (Talend)

• Implementation of an operational DWT (DB2 on AS400)

• Creation of 2 DTM: Technical and Commercial

• Creation of 25 reports in PowerBI

• Calculation of KPIs based on business requests

• Support for interns whose internship topic focuses on data science in general and BI in particular

Participation:

• In the formalization of key indicators necessary for business decision-making

• In the segmentation of at-risk customers (claims, PD)

• In the segmentation of prospects fitting the company's strategy

Summary: Three missions within the BI - HR department

• Migration of the QlikSense solution to Talend (12 tables – 3 flows) and data integration (MySQL)

• Creation of 20 QlikSense reports and result verification

• Prediction of resignations

Realization:

• Based on technical specifications, implementation of a data integration mechanism (ETL) from the HR Access Legacy System and other sources

• Creation of dashboards that should reflect the analysis of defined indicators

• Creation of a report predicting potential resignations

Functional Domain:

• Human Resources

Result:

• Use of new technology

• Addition of a Data Quality Layer to improve data quality

• Creation and exploitation of new dashboards

Methodology: GIMSI

Environment: Talend, QlikSense, MySQL, Python, HR Access, Excel

Summary: Creation of a new decision support tool for sales and detection of high-potential prospects within a project team of 5 people.

Realization:

• Business workshop for needs definition

• Source data collection and master data definition

• Definition of the BI system architecture

• Star schema database modeling

• Data feed flow creation (Talend)

• OLAP cube creation

• DWT stabilization

• Dimension creation

• Key indicator calculation

• Report creation in PowerBI (20)

• Tabular cube creation

• Creation of a bank prospect prediction report

Functional Domain:

• Banking

NFA – BI Consultant, PowerBI [email protected]

Result:

• Use of new BI technology

• Data validation

• Dashboard creation and exploitation

• Use of a predictive approach for selecting the best prospects

Methodology: GIMSI

Environment: Talend, PowerBI, MySQL, Python, Hadoop, Excel

NFA – BI Consultant, PowerBI - Talend [email protected] 06 24 25 49 15