Professional Summary
To obtain an Informatica PowerCenter Administrator position that will
enable me to
utilize my experience in information technology
Technical Skills
. Languages : PL/SQL, SQL, JAVA, C
. Web Development: PHP, HTML, XML
. Database Systems: ORACLE (9i,10g, 11g), MICROSOFT SQL
Server (2005, 2008), MYSQL
. Operating Systems: WINDOWS (NT, 2003, XP), LINUX
. OLAP: ORACLE EXPRESS
. ETL: INFORMATICA POWERCENTER, TALEND OPEN,
STUDIO,MICROSOFT DTS
. Method: MERISE, UML
Soft Skills
A self-motivated individual, good time management
skills, pay attention to details, a
great problem solver, good communication skills, a
quick-learner, and a responsible
team player
Education
Oracle Database Administrator
2012
SAIT Polytechnic, Calgary, AB
Master of Economy and Management (IQAS)
2006-2007
University of Picardie, Amiens, France
Bachelor of Information Technology (IQAS)
2001-2005
University of Sfax, Sfax, Tunisia
Experience
Oracle Database Administrator
2012
SAIT Polytechnic, Calgary, AB
. Created and configured database in Linux and Windows
environment using command lines and GUI tools
. Created tables and constraints
. Created users, profiles and granted privileges
. Created materialized views for improving performance
. Loaded data into the database using SQL*Loader,
import/export, external tables, and data pump
. Developed and tested storage strategies and disaster-
recovery plan that guaranteed recovery performance and
high availability
. Established auditing plan
. Recovered lost objects and data files
Business Intelligence Developer
2008-2010
Business & Decision, Bordeaux, France
. Analyzed the production data in order to understand their
availability and semantic
. Interviewed the future Application Users to help complete
the book of Specifications
. Created repository, datawarehouse and data marts
. Imported source definition from different sources such as
tables, flat files (source analyser)
. Created target definition(target designer)
. Developed mapplet and mapping(mapplet and mapping
Designer)
. Created session, scheduled and executed jobs(workflow
manager)
. Leaded the application tests
. Created users and granted privileges
. Developed the application User Manual
. Trained Users
. Maintained and upgraded repository
. Tuned source queries and mapping(aggregator, lookup,
joiner, expression)
Business Intelligence Developer
2007-2008
Fininfo, Paris, France
. Benchmarked and tested business intelligence ETL and
report open tools and business intelligence ETL and
report none open source to Understand the advantages and
disadvantages of each tool and did a proposal for which
tools fit better according the reality of the Company
. Developed entity relational and datawarehouse models
. Designed and created cubes with SQL SERVER 2005
(Analysis services) to receive data
. Planned and implemented Extract - Transform - Load (ETL)
processes by using Talend Open Studio as ETL
. Extracted data from different sources(Excel, Mysql, Sql
Server), cleaned and loaded them into the cubes
Volunteer History
Volunteer Admin/Internet Advertisement/Research
2011-2012
Heart & Stroke Foundation of Alberta, Calgary, AB
Languages
Advanced ability to speak and write in French