Omran Musa

** ********* ********

Scarborough, ON

M1C 4X2

Tel: 416-***-****

Email: acr0wi@r.postjobfree.com

OMRAN MUSA

OBJECTIVE

To obtain a challenging position as Oracle Database Administrator / Business Objects Consultant, PL/SQL programmer, Oracle Portal developer

Professional Profile

With more than seven years of experience maintaining and administration Oracle 9i/10g/11g Database running on SunSolaris, HP-UX, AIX, RedHat Linux and Windows.

Oracle9i DBA Certified (Associate) and Java Programmer Certified

10 years of experience in SDLC

4 Years of experience in Oracle Portal Application

12 years of experience as Business Analyst transforming business requirements into efficient IT solutions

15 years experience in PL-SQL, SQL, Oracle Views, Function, Procedures and Packages

10 years of experience in working closely with senior management team for planning long term strategies & objectives

2 years of experience in Oracle 10g/11g RAC implementation & administration.

7 years experience in architecture, analysis, design, development and testing of Data Warehouse/Data Marts systems

7 years of experience with Oracle 10g/11g Physical / logical Data Guard .

5 years of experience with Backup/Recovery/Cloning of databases using RMAN.

10 years of experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM

5 years of experience in writing/editing UNIX Shell Scripts.

Strong skills in critical thinking and analysis, verbal and written communications, and interpersonal interactions.

3 years experience in SAP HANA database appliance administration.

7 years experience in SAP Business Objects Intelligence 3.1 & 4.x administration.

7 years experience in developer SAP Crystal, Webi, Deski reports.

Technical Experience

Hydro One Inc

Sr. Oracle DBA / BI (Business Object 4.1 (SAP) Consultant

Duration: Jun 01, 2008 – Sept 25, 2015

Duties included:

Worked in Data Modeling [using ERWIN, Power Designer], Data mart and OLAP for business analysis using Star & Snowflake schemas for faster and effective querying.

Worked in Designing, Developing, testing, and implementing PL/SQL triggers, cursors, stored procedures, packages, functions at Database level and reporting level.

Expert of Rman, OEM, and AWR tools.

Developed and coding Unix script to Transfer, Extract and Loading Data (ETL)

Enforced security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.

Performed database tuning and performance monitoring

Installation, configuration and upgrading of Oracle server software and related products

Patch Management and Version Control

Performed complex database maintenance such as, but not limited to, executing complex, corrective action database utilities, designing script structures, appropriately defining indexes, analyzing requirements, and

Performed analyzed and evaluate database performance to maximize efficiencies and take advantage of tuning opportunities

Oracle 10g, 11 g Recovery and failover task.

Experience operating in a Linux (Redhat), Windows and VMware environment.

Very experience in Xcom Granite DB.

Create cluster and configure a Business Objects environment with 2 nodes.

Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Datawarehouse

Developed more than 300 Webi reports mostly are very complex.

Designing universes including star type universe.

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Tuning the performance of SQL queries and ETL process.

Working and implementation of Desktop Intelligent 7.0/8.0/9.0/10/XI/XIR2, Xcelsius dashboard

Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.

Created different types of reports like Master/Detail, Cross Tab and Chart.

Developed various full client and thin client reports using Business Objects and Web Intelligence.

Imposed several Joins, Filters, and Alerter to restrict the unwanted data and highlight the required data.

Resolved loops with Aliases and Contexts.

Provided training to end users to use various functionalities of Business Objects

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

Created the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments

Created various Views and Stored procedures using PL/SQL for Crystal Reports.

Designed and maintained Universes and exported them to the repository.

Migration database from Oracle 9i to Oracle 10g

Developed various reports using Web intelligence Desktop Intelligence

Migrated Reports, Universes from Version 6.5 to Business Objects XI R2

Evaluated Oracle features and Oracle related products

Established and maintain sound backup and recovery policies and procedures

Take care of the Database design and implementation

Implement and maintain database security (create and maintain users and roles, assign privileges)

Work as part of a team and provide 24x7 support when required

Performed general technical trouble shooting and give consultation to development teams

Interfaced with Oracle Corporation for technical support.

Installation, configuration and Setup Oracle 12c on Linux server.

Environment: Oracle 9i, Oracle 10g, Oracle 11g IAS, Oracle 12c, Java, PL/SQL, TOAD, Granite DB, NE and OVSD database, BI, BODS, ETL, Linux, Unix, RMAN, OEM and AWR,OLTP, OLAP, SQL Server 2008, Sap Business Objects, Sap Designer., SQL Server

BELL CANADA

Oracle DBA / Senior Oracle Portal Developer (Prime)

Duration: Oct 25, 2004 – May 1, 2008

Duties included:

•Created Content Management System (CMS) built on Oracle portal

•Created PL/SQL script, Packages, procedure and functions

•Created Oracle portal packages, procedure, function and triggers.

•Developed access package for the application users invoked LDAP & AD(Active Directory ) and Oracle Internet Directory (OID) and synchronized all bell Canada user around 47,000.00 user into backup tables incase LDAP is down.

•Tuned Oracle SQL statement in the web application and increase the performance of the application.

•Created UNIX and PL/SQL scripts for data migration and modified data.

•Supported Oracle portal website.

•Configure Oracle Portal pages (create portal pages, StyleSheet Access, privilège, cache.

•Implemented caching mechanism and the invalidation cache mechanism for more than 9000 Oracle portal pages

•Created, maintain, monitor and troubleshoot the Oracle system. Will work closely with users and system and network administrators

•Modeled data using Oracle Designer & Erwin

•Cloned environments when required to replicate and test fix for a production problem

•Import and export database

•Worked in migration Oracle 9i database to Oracle 10g .

•Backup and restore scripting procedures and testing

•Backup, RMAN and cloning Oracle Application environments.

•Created Java web service to integrate Oracle Portal application with .Net application

Environment: Oracle 9i, Oracle 10g, Oracle IAS 10g IAS, Java, Oracle 10g database, Autonomy Http Fetch spider, PL/SQL, TOAD, SQL Server, Java, Windows 2000, Unix, JDeveloper, SiteMinder., Erwin, Oracle Designer

HEALTH CANADA

Java Developer, Oracle DBA

Duration: September 22, 2001 – March 1, 2003

Duties Included:

Designed and developing data interface components between existing applications and Oracle database (RDBMS)

Writing PL/SQL code of more than 500 lines to refresh a single table that contained more than 5 million records; that refresh involved updating fields, inserting records, and deleting records; it also involved converting and loading data while PL/SQL code scripts were running.

Implemented database conversion from different database structure and environment

Migrated database from Oracle 7.3 database to Oracle 9i database

Analyzing, mapping, modifying tables, and creating PL/SQL triggers, procedures, functions and packages for MTRS database (Oracle 9i) using SQL script

Ensured integrity and concurrence in the database, managed storage allocation of database, tuned database, and maintained backup and recovery

Migrated and converting MTRS (Medical Transportation Records System) database

Ability to write queries, used all stats tools, DBA studio and TOAD

Deploying backup and recovery strategies

Mapping and validating the table fields and mapped the values in each table in the database

Developing JSP, Java Beans, Java Classes, Java Script and HTML for MTRS application

http://java.sun.com/j2ee/Creating dynamic web content and JSP technology that enables rapid development of web-based applications that are server and platform independent

Creating HTML pages and Java script functions to implement business rules for the client side interface

Developing data modeling objects in Oracle Java Developer 3.2.3

Created Java objects and classes to validate application users

Used Oracle Java developer to build Java classes, JSP, and Java beans

Created Java classes and objects to implement business rules in the MTRS application

Created Forms in the web pages to allow users to gather data interacting with Java Beans

IPerforming different levels of Java codes integration

Deploying the MTRS application on the Websphere 3.5 application server

Environment: Oracle 8i, Oracle 9i, Oracle 9iAS, Oracle 9i Workflow, PL/SQL Developer, XML, Java, J2EE, Oracle Designer, SQL*Loader, JDeveloper, Lotus Notes, Sun Solaris, Linux, Window SQL NT, Microsoft IIS, Secure FTP, SSH, HTTPS.

Department of Fisheries and Oceans (Agriculture Canada)

Oracle DBA / Oracle Developer

Duration: June 1, 1999 – September 15, 2001

Duties included:

Data modeling of an Inventory application

Writing library functions, procedures, and triggers

Performed database creation

Performed database sizing requirements

Managed database Users & Database Access by using the Enterprise Manager GUI

Configured and troubleshooting Net8 to enable Oracle client-server communication

Ensured data integrity and concurrency

Managed storage allocation Databases, data files, roll back segments, extents and blocks

Maintained backup and recovering database

Used Oracle 7 & 8, tuning tools to improve the performance of database applications and programs

Scripting, supporting, and optimizing bulk data loads from legacy applications (Oracle SQL*Loader)

Migrated data from Oracle RDBMS v7.3.4 to v.8.0.4 (Oracle Export/Import tools and Oracle Migration Wizard)

Developed Management Information System for the MPIRS project using SQL*PLUS, PL/SQL, and Oracle Developer 2000 in Windows NT environment. Responsibilities included implementing the stored procedures, database triggers, and packages in accordance with the system specifications.

Developed system query and update customized interfaces using Oracle Forms.

Developed system administrative reports, using Oracle Report. Write system operation manuals, training users. This system became a model project in my company.

Developed Business Transaction Management System for MPIRS Import/Export Company using Oracle 7.3.3 on Windows NT. Responsibilities included coding data models, user interfaces, subsystem reports and SQL*Plus Report Scripts. Installed, configured, and maintained Windows NT, Oracle, and application system environment for users. Updated application systems for user’s new Business rules.

Installed, administered, maintaining and supporting Windows 3.11, 95, 98 Windows NT and Linux

Designed all data-entry screens (forms) and a significant part of the reports, including graphical presentation of the data using Oracle Developer 2000, Oracle Reports, and SQL

Environment: Oracle 7.1, PL/SQL, Forms 4.0, Reports 2.5, PL/SQL, SQL*Net v2, ERwin, Oracle, Designer. SQL*Loader, SQL*DBA, HP-UX, Window NT, HP9000,

Skills

Languages:

PL/SQL, SQL, Dynamic SQL, Java, JSP, HTML, XML, Java Script

Development Tools:

Oracle Forms 4.5 / 5.0 / 6i, Reports 2.5 / 6i, JDeveloper, JBuilder Procedure Builder, TOAD, SQL*Loader, Developer/2000,

DBA Tools:

Oracle Enterprise Manager, SQLServer Enterprise Manager, SQL*Loader

Performance Tuning:

Oracle Enterprise Manager, SQL*DBA, SQLExpert, Tkprof, Statspack

Web Development:

Oracle Application Server 9iAS, Java, Servlet, JSP, Swing, XML, Oracle Forms 6i, Reports 6i, Forms & reports, JavaScript,, Websphere.

Networks:

Net8, SQL*Net, TCP/IP, Listeners, Intelligent Agents, Database Links, CMAN TCP/IP, UDP, HTTP, POP3, SMTP, SNMP, Socket, SSL

Database:

Oracle v6, v7, v734, v8, v8i, v9i v10g, v11g with Jserver 8.1.6 SQLServer, MySQL, MS Access

OS:

Windows NT/2000/XP, Linux/UNIX (Sun Solaris)

Modeling Tools:

Oracle Designer, Rational Rose, Erwin.

Certifications

July 13, 2003

Oracle 9i Fundamental I

Oracle9i Associate Certification

June 18, 2003

Introduction to Oracle9i: SQL

Oracle9i Associate Certification

June 10, 2003

Sun Certification for Java 1.4 programmer

Education

Feb, 2003

Servlet and JSP

Acquired Notions Inc.

Dec, 2002

Java Programming Course

Acquired Notions Inc

Oct, 2000

Oracle Database Administration

Praxis Institution

Jan, 1999

PL/SQL

Praxis Institution

June, 1995

Database Management System

Sahara for Computer System

May, 1995

Electrical Engineering, B.Sc.

University of San Carlos

Security Clearance: Enhance Level

Contact this candidate