Mes compétences :
Oracle
ETL
UNIX
Informatica Analytics Package > Informatica PowerC
SAP Data Services 12
Shell scripting
RDBMS
PostgreSQL
Oracle PL/SQL
GREEN PLUM
Microsoft Windows
Microsoft SQL Server
Entreprises
OOREDOO ALGERIA
- Data Warehouse specialist & ETL developer
2011 - maintenantMy mains tasks are :
Develop the new ETL process,
Maintain and modify the existing ETL process.
Assure the daily execution of all ETL process
Support externals teams which want extract data from the data warehouse.
During this experience I had a chance to be involved in many projects, use many tools and participate in some trainings
Project :
1. Migration of our source system (charging system), this migration has touched 80% of DWH process, our job consist to detect the change and adapt this change to our model and process (DEC2012- MAR2013).
2. Migration of our ETL tool from SAP Data Services 12 to Informatica 9.5 (JAN2013-SEP2013), my job consists to assist the consultant of the vendor and develop some process with Informatica.
3. Participate to the project “Churn and Segmentation of customers” as support of development team (help them to extract data from the Data warehouse and prepare the necessary data to run the model) and validate all the delivered process and scripts (APR2013- FEB2014).
4. Migration of our DWH made in home installed in Oracle database in Exadata server to another solution Green plums with standard model (NOV2013- today). In This project, I am member of Green plum ETL team and I support all technical team of green plum project (information about data, source system, old process, …)
5. Participate to BI automation project of OOREDOO group, the goal of this project is to report some KPIs from each branch of OOREDOO group , my task was to develop some ETL process to load some staging tables with the KPIs of Algeria branch and these tables will be used by the dashboard of the group.(FEB2015-MAR2015)
Tools :
1. Oracle 11G installed in a standard server « unix » or in Exadata server.
2. SQL Server (2000,2003 and 2008)
3. Unix and Shell scripting
4. SAP Data Services 12
5. Informatica power center 9.5
6. pgAdmin III to interrogate a Greenplum database
Training:
1. Tuning SQL Oracle 11G(Mai 2012)
2. Informatica Power Center v9 level 1 (JUN 2013)
3. Business object 4 (universe designer , Rich client and administration ) (APR 2014)
4. Initiation to GreenPlum database (MAR 2014)
5. Oracle Exadata Database Machine (AUG 2014)
AXA
- Analytic Workspace Manager
Nanterre 2010 - 2011Final project of study was developed for AXA Algeria (full-time internship).
In this project we have implemented a Data warehouse specific to our insurance
company.
****Schema: stars schema, Kimball way.
****Tools : Oracle Entreprise Edition 11G R2, Analytic Workspace Manager 11G R2,
Oracle Business Intelligence Entreprise Edition 10G, SAS entreprise guide 4.1.
Formations
ESI, National School Of Computer Science, Ex :(INI), Algeria (Algeirs)