2015 - maintenant* Analyzing existing sources, target and ETL process ;
* Writing functional and technical ETL specifications ;
* Complex Informatica ETL process development, test and validation ;
* Implementation, monitoring post production, support ;
* Advanced Performance Tuning for the daily load process;
Ooredoo
- Senior INFORMATICA consultant
2013 - maintenantProject manager of ETL platform migration from SAP BO to INFORMATICA
2013 - 2015* Analyzing existing sources, target and ETL process ;
* Writing functional and technical ETL specifications ;
* Complex Informatica ETL process development, test and validation ;
* Implementation, monitoring post production, support ;
* Advanced Performance Tuning for the daily load process;
Paris2012 - 2013* Project Management (workshop leading, team management, alert reporting, progress
monitoring)
* Ensure compliance with the standards of SYNERGY methodology ;
* Documentation ;
* Participate in ETL process development, test and validation
Orange
- BackOffice Architect
Paris2010 - 2012* BI BackOffice jobs designing and architecture validating ;
* Import data from source in production (IN, MSC, SMSC, SGSN, BILLING, CRM, ERP ...) to
ODS data base (Operational Data Store)
* ODS data base modeling
* Data Quality control in ODS data base ;
* Enrichment, Transforming & Loading data from ODS data base to DWH data ;
* DWH data base modeling, tuning (partitioning, indexing) ;
* Aggregating data from DWH data base to DM data base (Data Mart) ;
* DM data base modeling (Star Schema : fact and dimension tables, USAGE, REVENU, SALES,
STOCK, BILLING, COMMISIONNING, etc), tuning
* Functional specification validation for BI BackOffice jobs (presentations, workshops, business rules,
mapping rules, constraint, limitations, ...)
* Technical specification validation for BI BackOffice jobs (mapping rules, data base object
procedure, function modeling, jobs parameters setting, cron planning, job dependency, ...)
* Design ETL cycle jobs ;
* Design Data Warehouse model, Design Operational Data Store model, Design Data Mart model ;
* Shell, PLSQL scripting ;
* Tools: TALEND ETL, ORACLE data base, Shell UNIX ;
* Sources: BSCS, RTX, IN, VOLUBILL, ZEBRA, MSC, SMSC, PLATINE...
ORANGE TUNISIE
- BI / DATAWAREHOUSE Analyst
Paris2010 - 2013Depuis Avril 2010
Poste : Développeur BI / DATAWAREHOUSE Orange TN
Faurecia
- Informatica Consultant
2009 - 2010* Migration of data since several ERP (+40) towards SAP with Informatica POWER CENTER ;
* Design and development of ETL mappings responsible for data loading. ;
* Design and development of ETL mappings responsible for the generation of the IDOC and LSMW files. ;
* Monitoring of the activity and operation management ;
* DATA Quality control with Informatica DATA QUALITY (IDQ)
Faurecia
- CONSULTANT DATA MIGRATION
2009 - 2010
NSIS
- Consultant / Analyste INFORMATICA
Levallois-Perret2009 - 2010Février 2009 - Mars 2010
Poste : Développeur Analyste INFORMATICA
Entreprise : NSIS (Partenaire IBM France)
Projets : FAURECIA DATA MIGRATION
Migration de données depuis plusieurs ERP (+40) vers SAP avec INFORMATICA POWER CENTER
TELMA
- Auditeur Datawarehouse
Saint-Ouen l'Aumône2008 - 2009Rapport d'audit détaillé du Système d'Information Décisionnel de l'opérateur historique malgashe Telecom Madagascar. TELMA
Makina-Corpus
- Consultant BI/TELCO
Toulouse2008 - 2009Poste : Consultant Business Intelligence
Entreprise : Makina Corpus / Département BI
Tunis2007 - 2008* Rating & Billing workaround and configuration ;
* Design and implementation of the application of calculation of the expenses of international MMS
interconnection (JAVA/UML/ORACLE/BSCS)
* Design and implementation of the application of Anti-churn SMS (JAVA/ORACLE/PLSQL/BSCS)
