Wael - Consultant INFORMATICA

PROFESSIONAL CAREER AT WYNSYS (TUNIS - TUNISIA)

Client FAURECIA
Sector Automobile
Projets Business Inteligence and Data Migration projects
Duration Since January 2019
Role ETL – BI Consultant
Technologies Informatica
Microsoft SQL Server
Oracle
Data source BW
SharePoint
Projects description
5 Informatica Projects:
➢ P1 (FAB): Improve production in factories for all sectors and detect existant
anomalies.
➢ P2 (FCM): Detect inconsistency in the FAURECIA CLEAN MOBILITY sector.
➢ P3(MII): Have a global visibility on the transactions between all the sectors of the
company.
➢ P4: Analyse the projects and apply the necessary optimizations.
➢ P5: Migrate data according to RFCs.
➢ P6 (Monitoring): Monitor Inforamtica WFs execution.
These projects are based on the following points:
• Configure and setting up the environment.
• Extraction Mapping’s development / Informatica Workflow.
• Technical documentation’s preparation.
• Tests Development.

Client SANOFI Aventis
Sector Pharmaceutical
Projet Projet SHIFT- Data Migration to SAP S/4HANA (USA / Italy)
Duration November 2018 - January 2019
Role ETL Consultant– SAP BODS
Technologies SAP Business Objects Data Services
Microsoft SQL Server
Project description
Migration project from ECC ERP to SAP S / 4 Hana
• Configure and setting up the environment
• Extraction flows developement
• Database scripts development
• Technical documentation preparation
• Tests development

Client EDATIS
Sector Mailing
Projet Business Inteligence project - Decisional system’s development and implementation
Duration January 2018 - October 2018
Role BI Consultant
Technologies Talend BI
Elasticsearch – Kibana
MySQL
Projects
description
➢ P1 (CS): Improve the targeting of EDATIS customer contacts and consult the
opening rates of sent emails.
➢ P2 (Monitoring): Monitor the database server state and supervise its capacity.
➢ P3 (ES): Have visibility into EDATIS customer statistics according and service
needs.
• Analysis and definition of needs in collaboration with managers.
• Data Warehouse database’s design.
• ETL configuration with Talend.
• Data transfer to Elastichsearch and reports generation with Kibana.
• Historical tables monitoring with Talend jobs.
• Log management (system, send emails …) with talend.

Client El AMOURI (External Project)
Sector Survey
Projet Business Inteligence project - Decisional system development and implementation
Duration January 2017 - July 2017
Role BI Consultant
Technologies Talend BI
Power BI
MySQL
Project
description
➢ Have total visibility on the survey report.
➢ Have visibility on the performance of each employee who did the survey.
• Analysis and definition of needs in collaboration with managers.
• Design of the Data Warehouse database.
• ETL configuration with Talend.
• Reports generation with Power BI.

Client ESPRIT
Sector Education
Projet Business Inteligence project -Decisional system development and implementation (school)
Duration October 2015 - January 2018
Role ETL / BI Consultant
Technologies MS BI (SSIS, SSAS)
Power BI
Microsoft SQL Server
Oracle

Project
description
➢ Have visibility on teachers assignment during the admission period.
➢ Have visibility on the admission stages (Registration, Pre-Registration, Registration), staff
and results.
➢ Have visibility on the complaints made by the students.
➢ Ensure the smooth functioning of data migration to ERP NAVISION
• Analysis and definition of needs in collaboration with managers.
• Design of the Data Warehouse and Cube database according to the axes
(Admission, Staff, Result, Graduation, Hourly load, Teachers).
• Working environment Establishment for MS BI.
• ETL configuration.
• Reports generation with Power BI.
• Sharing collected information with decision makers.