Profile

Senior Oracle BI Consultant, having 13 years of experience in software development and instruction, also owning in-depth knowledge of System Analysis and design.

Highly motivated team player with excellent communication skills, presentation skills & a continuous will to quickly learn and apply new technologies.

Experience in Building Oracle BI Publisher Report with different data sources.

Experience in Building Oracle BI Analyses and Building Oracle Bi Dashboards.

Experience in Creating & Editing Oracle BI KPIs (Key Performance Indicators) and KPI Watchlist.

Experience in Administrating BI users and groups on Oracle WebLogic.

Experience in Administrating BI elements on Oracle Enterprise Manager 11g.

Experience in Creating a Repository Using the Oracle Bi 11g Administration Tool.

Experience in Building internet applications with Oracle forms developer & reports developer (6i, 9i & 10g).

Experience in Developing with PL/SQL and PL/SQL program units (Creating stored procedure, function, package

and Triggers as well as maintaining & debugging PL/SQL program code).

Experience in Database processing concepts, techniques, DB Analysis & design and ERD development.

Experience in system analysis and design.

Experience in Install, create & administer Oracle Database. Configure the database for an application.

Experience in Move data between databases and files & Oracle server database security (controlling user

access).

Excellent customer service skills.

Having a very good communication and presentation skills (4-year experience as a part time instructor).

Able to work in-group, helpful, sociable, work under pressure, deliver under strict deadlines, manage

stress, calm.

Dynamic, self organized, creative, quick learner and eager to learn, teaching other.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL

Server and Flat files.

Responsible for all activities related to the development, implementation, administration and support of ETL.

Processes for large scale data warehouses using Informatica Power Center.

Strong experience in Data Warehousing and ETL using Informatica Power Center 9.xx

Had experience in data modeling, Star Schema Modeling, FACT and Dimensions tables, physical and logical

modeling.

Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like

sources, targets, mappings and sessions.

Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader,

Informatica Power Center.

Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.

Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful

execution of the data & used pager for notifying the alerts after successful completion.

Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

Objective

Seeking for a BI consultant or data warehouse specialist position in a Multi-National company, to gain more experience from multi culture and to match my knowledge with my objective.

Mobile: 0100-57 59 409

: 0128-1 444 806

Email: Mohamedattia77@yahoo.com

: Mohamedattia77@gmail.com

Mohamed Elsayed Mohamed Attia

2

Work Experience

○ Kuwait Food Company (Americana). Jul 2009 -- Present

Mohandesin,Giza.

Senior Oracle BI Consultant (Using Oracle Database Server 10g, 11g, Oracle Developer Suite 6i, 10g, Oracle BI

11g, OBI administration tool, Data Warehousing and ETL using Informatica Power Center 9).

Responsibilities: Training & Consultation Information Systems team on Oracle BI tools, for each branch of the Americana

Group as (Green Land, Farm Frites, ICAPP, Senyorita, Egyptian Canning Company). Creating & Editing Oracle BI Publisher Report, OBI Analyses, OBI KPIs & Building OBI Dashboards for each

branch of the Americana Group. Collect and consolidate data from each branch of Americana Group and displayed to Head Office. Administrating BI users and groups on Oracle WebLogic. Administrating BI elements on Oracle Enterprise Manager 11g. Creating a Repository Using the Oracle Bi 11g Administration Tool. Data Requirement Analysis and Data mapping for ETL processes using Informatica Power Center 9. Developing with Oracle forms builder, Report builder and PL/SQL program units (Creating stored procedure,

function, package and Triggers as).

○ Prima Soft. Jul 2007 -- June 2009

El-Maady.

Oracle Developer Team Leader (Using Oracle Database Server 10g, Oracle Developer Suite 6i, 10g).

Responsibilities: Reviewing and understanding specs, planning out the structure of the program before coding. Direct daily operations of department, analyzing workflow, establishing priorities, developing standards, setting

deadlines and Prioritizes work to meet goals or deadlines. Review project plans in order to plan and coordinate project activity. Review and approve all systems charts and programs prior to implementation.

○ Informatique. Jul 2006 -- June 2007

Nasr City.

Senior Oracle Developer (Using Oracle Database Server 10g, Oracle Developer Suite 10g).

○ Sadat Academy for Management Sciences. Software Development Center (SDC- Oracle Partner).

Jul 2003 -- June 2006

El-Maady:-

(Sadat Academy)

Oracle Developer & Instructor (Using Oracle Database Server 8i,9i,10g & Oracle Developer Suite 6i, 9i, 10g).

○ Allied Consultants. Sep 2002 -- Mar 2003

Helioplis.

Sponsored by Ministry of Communication & IT In cooperation With Orascom Technology System. Study Oracle Developer Track (SQL, PL/SQL, Forms, Reports) & Preparing for OCP exam.

○ Khalifa Computer Group. Jul 2000 -- Jan 2001

El-Haram.

(Analyst, Designer and Quality Controller).

Work Experience

Instruction “Part Time”

○ Cairo University- Faculty of Computers & Information. Sep 2014 -- Present

El-Giza:-

(Cairo University)

Instructor [-Oracle Business Intelligence Enterprise Edition 11g].

○ Orascom Telecome Sep 2014 -- Present

Roxy.

Instructor [-Oracle Business Intelligence Enterprise Edition 11g].

○ Sadat Academy for Management Sciences Software Development Center (SDC- Oracle Partner). Jul 2003 -- Present

El-Maady:-

(Sadat Academy)

Instructor ( Teaching & training (Oracle Developer Track, Oracle DBA, Oracle BI tools, Data Warehouse Concepts & Tool "Informatica Power Center 9")).

3

○ ITEGYPT – corp. Mar 2007

Nasr City.

Instructor [-Oracle Database 10g (SQL, PL/SQL, Program Units, Forms, Reports) ].

○ Virgitech.

Feb 2007

El-Dokky.

Instructor [-Oracle Database 10g (SQL, PL/SQL, Program Units, Forms, Reports) ].

○ IBM – Education. Nov 2005 -- Jan 2007

El-Maady.

Instructor [-Oracle Database 9i,10g (SQL, PL/SQL, Program Units, Forms, Reports).

○ ICL – United Co. For Training. Apr 2002 -- Sep 2002

Nasr City.

Instructor (Database Concept, Visual Basic, System Analysis & design, Programming Concept).

Details of Main Projects

( EPIC. ) System

○ Title Education Processes Integrated Community.

○ Customer Misr International University ( MIU ).

○ Description A university students’ management information system dedicated towards automating all students’ related processes in a credit-hours teaching environment. EPIC was developed with Oracle Developer to work on ORACLE Database as a Client/Server application.

○ Technology tools (Oracle Server 10g, Oracle Developer 6i).

Omar Efindi System

○ Sub system title 1- Supplying Management System.

○ Description The project contains entire database for maintenance contracts & following up all maintenance operations for machines.

○ Sub system title 2- Fixed Asset Depreciation Accounting System.

○ Description The project contains an entire database for fixed assets & calculates their depreciation.

○ Customer Omar Efindi .

○ Technology tools (Oracle Server 10g, Oracle Developer 10g).

SAMS College System

○ Title Student Information System and Graduates Affairs for faculty of management .

○ Customer Faculty of management sciences.

○ Description The project contains an entire database for student and graduate affairs.

○ Technology tools (Oracle Server 9i, Oracle Developer 6i).

SAMS Institute System

○ Title Student Affairs Management System for National Institute.

○ Customer National Institute for Higher Management.

○ Description The project contains entire database for student affairs and graduates affairs.

○ Technology tools (Oracle Server 9i, Oracle Developer 6i).

System of operation orders

○ Title System of operation orders.

○ Description The project contains entire database for operation orders.

○ Technology tools (Oracle Server 8i, Oracle Developer 6i).

4

Graduation Project

○ Title Production control system.

○ Description The project contains full database about Production Control System at Banha Electronic Co.

○ Technology tools (Visual Basic, Ms. Access).

Web Application Development

○ Title E-commerce for Computer Company.

○ Description Web page, Contains information about the Satellite Company &visitors able to choose the computer element and pay by bill or visa.

○ Technology tools HTML, Java Script and JSP.

Education

○ 1996 – 2000 Sadat Academy for Management Sciences: EG B.Sc. in Computer and Information Systems.

Graduation Year : 2000 Degree : Good (76%)

○ 2002 – 2004 Sadat Academy for Management Sciences: EG

Higher Education Diploma in Management Sciences

Graduation Year : 2004 Degree : Very Good (81%)

○ May 2013 Sadat Academy for Management Sciences: EG

Master’s Degree in Management Information Systems.

Training

○ Sep 2002--Mar 2003 Allied Soft - MCIT scholarship (for Oracle Developer track).

Technical Course for Study: Oracle Developer Track (SQL, PL/SQL, Forms, Reports)

& Preparing for OCP exam.

○ Sep 2003--Oct 2003 MCIT scholarship (for Oracle 9i Java Developer track).

Technical Course for Study: Oracle-9i Java Developer (Java Programming, Access

Oracle 9i With java, Creating Java Servelet & JSP,

Developing Application With BC4J, 9i As Basic Admin).

○ Feb 2008--May 2008 Oracle University, Orascom Training & Technology (for Oracle DBA track).

Technical Course for Study: Oracle DBA 10g (Admin Workshop I, Admin. Workshop II)

Advanced course (Performance Tuning, Tuning SQL).

○ Jan 2013--Mar 2013 United Consultants(UC) (for Oracle Business Intelligence and Data Warehouse Concepts).

Technical Course for Study: Oracle BI 11g (Oracle Business Intelligence Solutions and

Data Warehouse Concepts).

○ May 2014—Jun 2014 Becom Academy (for PMP course). Technical Course for Study: Project Management Process (PMP).

International Certifications

Oracle Certified Profisional (OCP).

Exam: Introduction to Oracle: SQL & PL/SQL (001).

Date: May 26, 2003

Exam: Programming with PL/SQL (147).

Date: Nov 06, 2006

Exam: Oracle Forms: Build Internet Application (141).

Date: Jan 29, 2006

ICDL International Computer Driving License. Date: Dec 05, 2005

5

Professional Skills

Language Proficiency:

○ Arabic Mother Tongue

○ English Good (Speaking & Writing).

Technical Skills:

○ Oracle BI Tools Oracle BI (OBIEE 11g, OBI administration tool, Data Warehousing and ETL using Informatica Power Center 9 & Oracle Data Integrator (ODI 11g)).

○ Oracle Developer Oracle Database (Database Concept, SQL, PL/SQL, Program Units, Forms, Reports).

○ Oracle DBA Oracle 10g (Workshop I, Workshop II, Performance Tuning, Tuning SQL).

○

Oracle 9i Java developer Java Programming, Access Oracle 9i With java, Creating Java Servelet & JSP, Developing Application With BC4J, 9i As Basic Administration.

○ Programming Languages Basic, Pascal, C, Visual Basic, Cobol.

○ Web Development HTML, Front page.

○ Administration DOS, Windows 3.x/95/98/NT/2000/2003/2008/XP/Vista/7/Linux.

○ Others

- S/W Engineering & Design of web page. - System Analysis and design. - Database processing concepts, techniques, DB Analysis & design. - Operating System. - Artificial Intelligent. - Internet & Network. - Graphics.

○ Hardware Maintenance Any Type of PCs.

Personal Skills

o Enjoying in solving problems.

o Enjoy with self study.

o Punctual, hard worker and have a Creative thinking.

o Team work and team leadership skills.

o Ability to work under pressure.

o Ability to manage difficult tasks.

Personal Data

Date of birth : 27 Jul 1977 Place of birth : Giza , Egypt Religion : Moslem Military Service : Completed Nationality : Egyptian

Interests

Sports (Karate), Reading, Chess, Internet, and making new friends.

References

Furnished upon request.