ELiidi بن عمر

Join BBI/Atos development teams in Ooredoo Algeria to work on the third and last phase of the migration from the old DWH (SAP BusinessObjects DataService + Exadata) to Informatica PowerCenter 10.0.1 + Greenplum Database.
• Develop of the Delta Staging Area using Informatica PowerCenter and the CDC solutions of Informatica & BBI.
• First responsible on the full development and integration of the below models: Invoices & Revenues, B2B and Contact Center from the source databases: Oracle, SQL Server and Informix.
• Develop the incremental batches (Daily and Monthly) for the STG Area, EDW & Aggregation.
• Develop the needed workflows for the history load. • Fix the daily/history issues of data by developing the needed script SQL/Unix.

Migration project from the information system PLANET (SIP) used by OTN to manage the contracts of their clients ADSL B2B to the target system BSCS. • Organize Workshop sessions with the customer.
• Prepare the technical and functional documents of migration.
• Prepare the product catalogue of migration (List of new services and offers in BSCS)
• Develop of SQL scripts to normalize and Cleanup the source data in the DB SIP.
• Develop of SQL scripts to migrate SIP data (customer, Contracts, Invoices & Paiements) to BSCS.

Join BBI/Ooredoo development teams in Ooredoo Algeria to work on the second phase of the migration project from the old existing ETL BODI (SAP BusinessObjects DataService) to Informatica PowerCenter 9.6.1 + Greenplum Database.

• Develop and Implement of new optimized solution for the Delta Staging Area to treat the huge number of CDRs generated by the platforms EMM and MZ.

• Create of Informatica mappings, sessions and Workflows for the module Traffic and Recharge based on the provided High level design document.

• Participate in the phases of SIT, Pre-UAT and UAT.

• Provide a new optimization and recommendation for the daily/existing issues based on my experience for the same project in OT.

• Project Documentation + Handover to DWH team.

Join EMC Development team in Ooredoo Tunisia and lead the ETL development team in a big project of migration from the old existing ETL BODI (SAP BusinessObjects DataService) to Informatica PowerCenter 9.5.1 + Greenplum Database.

• Develop of the Delta Staging Area using Informatica PowerCenter and the CDC solution of BBI based on the provided Solution Design document.

• Develop of Informatica jobs (mappings, sessions and Workflows) for 12 source systems (BSCS, CRM, Silog, IN, LP, StroreCash, CTI) based on the provided High level design document.

• Develop of Daily/Hourly and Monthly Batches for the STG Area, EDW & Aggregation.

• Administrator of all Informatica environments (Dev, Acceptance, Preprod and Prod).

• First responsible on the Go live of phases 1, 2 and 3 into Production.

• Implement a new process of monitoring and supervising as per Ooredoo request to monitor in Real-time the Hourly/Daily ETL load in production.

• Project Documentation + Handover to operation/DWH teams.

Working with BBI team and OPENET team on implementation Online PCRF “Policy Management” Solution BI Platform project for Mobinil Egypt including Extract data from OPENET EDRs and load into Mobinil DWH using Informatica PC 9+ under Linux Environment
• Design the staging area model
• Responsible for 50% ETL development
• Design and testing the ETL Mappings
• Optimization of Developed Mappings for efficient execution for over 100 Million EDR per day.
• Perform performance Enhancement
• Identify and raise possible data quality issues impacting ETL.
• Standardize and normalize data using Informatica DQ.

Joining Billcom/BBI teams to migrate the Billing system full data from BSCS7 to BSCSIX
• Upgrade Morocco telecom billing system “BSCS” from “BSCS7” to “BSCSIX”.
• Migrate the old data from “BSCS7“tables to the new version tables “BSCSIX” in consideration the handling of differences between the two versions database tables.
• Intensive use of Informatica in development Data Migration of migration process for migrating over 1 billion records per table.
• Applied Performance Tuning Techniques of Powercenter to optimize CPU and Memory utilization • Build Development Environment.
• Prepare the test cases for each developed Mapping. • Prepare test scripts for each developed Mapping.
• Testing/FIX ETL Development Issues.
• Analysis for the new Development for the New BSCSIX tables.
• Prepare ETL Development for New BSCSIX Tables

• BSCS Configuration (Baseline Setup, Service configuration, Rate plan…).

• Configuration of new CR and run the test of Raiting and Billing. • Participate in the phases of SIT.

• Leader in Data Migration:
* Proposal of a Data Migration Solution (PL/SQL ou ETL as needed)
* Optimizing the PL/SQL scripts of migration.
* Adaptation of Non-Kernel scripts used by different operators (promotions, Reporting, ...)