Menu

Wael HORCHANI

ARIANA

En résumé

Senior INFORMATICA and DATAWAREHOUSE consultant

Mes compétences :
Informatica
Talend
Datawarehouse
Oracle
Telco
SQL
Linux
Gestion de projet

Entreprises

  • Ooredoo Tunisia - Consultant Senior ETL INFORMATICA

    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 - maintenant Project manager of ETL platform migration from SAP BO to INFORMATICA

  • Ooredoo Algérie - Consultant Senior ETL 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;

  • Orange - Project Manager Talend ETL Implementation

    Paris 2012 - 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

    Paris 2010 - 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

    Paris 2010 - 2013 Depuis 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-Perret 2009 - 2010 Fé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ône 2008 - 2009 Rapport 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

    Toulouse 2008 - 2009 Poste : Consultant Business Intelligence
    Entreprise : Makina Corpus / Département BI

  • TELMA Madagascar - BI Consultant

    Antananarivo 2008 - 2009 Auditing Telecom Madagascar TELMA Data Warehouse: ETL scripting, documentation, team, process,
    DWH model...

  • Ooredoo Tunisiana - Billing Engineer

    Tunis 2007 - 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)

  • ORASCOM TELECOM TUNISIE - Ingénieur Facturation

    2006 - 2008 Poste : Billings Engineer (Ingénieur Facturation)
    Entreprise : ORASCOM TELECOM TUNISIE: TUNISIANA

Formations

  • INSAT

    Tunis 2002 - 2008 Engineer

  • INSAT (Institut National Des Sciences Appliqués Et De Technologies) (Tunis)

    Tunis 2002 - 2008

Réseau

Annuaire des membres :