Souki Mejdi

Implementation of BI products for the various GDLP clients ( Payroll Management ) • Design of data models for reporting • Data storage according to a procedure on MyReport • Creating reports through PowerBI Desktop • Correction and follow-up of these reports according to customer needs • Transform imported data on PowerBI with Power Query •Development of PL/SQL scripts for Jira data integration and analysis using SQL Developer for script execution and debugging. •Creation of processes to monitor the evolution of tickets in real time, using triggers and procedures stored in PL/SQL. • Assistance in setting up BI indicators through EazyBI: Creation of custom measures with MDX request

• Implementation and production of data integration jobs from an SFTP(T24) server to an Oracle local database via Talend Integration Studio • Planning and implementation of PL SQL procedures and triggers for Collections & Litigation departments • Implementation of reports for the collection of contentious claims through PowerBI • Identify and implement Collections & Litigation department needs (PL SQL, Talend)

• Implementation of SSIS packages that develop the passage of data from Staging to DWH via the ODS and MDM databases • Completion of incident investigations in TMA projects (SSMS, SSIS, PowerBI) • Implementation of Azure (ADF) pipelines via blobs storage • Extraction of data through T-SQL queries • Application of changes to DAX measurements in OLAP cubes

Notre projet consiste au développement d’un système informatique décisionnel pour la gestion des projets réalisés sous Jira. Ce dernier doit offrir une vue globale aux décideurs sur le suivi des projets au sein d’une entreprise par le biais des tableaux de bords. Pour sa réalisation, nous avons commencé par la fouille d’un volume de données. Ensuite, nous avons couvert tout le processus BI commençant en passant par un processus ETL en utlisant Talend jusqu’à la génération des tableaux de bords à l'aide de PowerBI en dernière étape. Our project consists of the development of a decision-making computer system for the management of projects carried out under Jira. The latter must offer a global view to decision-makers on the monitoring of projects within a company through dashboards. For its realization, we started by mining a volume of data. Then we covered the entire BI process starting through an ETL process using Talend until the generation of dashboards using PowerBI as the last step.

Taches: réaliser une application web de gestion des chèques bancaires en symfony 4.