Omran Musa Email & Phone Number

Toronto, On, Ca

14 Carltop

• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.• 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• Analyzing, mapping, modifying tables, and creating PL/SQL triggers, procedures, functions and packages for NMS database (Oracle 11g) using SQL script• Ensured integrity and concurrence in the database, managed storage allocation of database, tuned database, and maintained backup and recovery• Building/Creating very complex SQL query , back end database Netezzaa ( IBM ) or Oracle 12c • Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces• Operates within various end-to-end project development methodologies including Agile, SDLC, , gathering and defining requirements before iteratively developing solutions and consistently assessing quality during and after implementation.• Stakeholder Engagement: Coordinates and collaborates with numerous cross-functional stakeholders to thoroughly understand business objectives and ensure deliverables meet established quality and functionality expectations.• Migrated and convert a legacy Oracle packages/Procedures/Functions into the latest version of Oracle 12c • Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.• Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.

Toronto, Canada Area

• Business Objects 3.X & 4.x administrator • Installation, configuration and upgrading of Oracle server software and related products• Evaluate Oracle features and Oracle related products• Expert of RMAN, OEM and AWR tools..• Establish and maintain sound backup and recovery policies and procedures• Take care of the Database design and implementation• Perform database tuning and performance monitoring• Work as part of a team and provide 24x7 support when required• Perform complex database maintenance such as, but not limited to, executing complex, corrective action database utilities, designing script structures, appropriately defining indexes, analyzing requirements, and• Perform analysis and evaluate database performance to maximize efficiencies and take advantage of tuning opportunities• Experience operating in a Linux (Redhat), Windows and VMware environment.• Create cluster and configure a Business Objects environment with 2 node.• Developed more than 300 Webi reports mostly are very complex.• Designing universes including star type universe.• 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.• 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• Experience and deep knowledge of Granite (XNG ) database , Network Engineering (NE )

Toronto, Canada Area

• Creating Content Management System (CMS) built on Oracle portal• Creating PL/SQL script , Packages , procedure and functions • Creating Oracle portal packages, procedure, function and triggers.• Develop 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.• Tuning Oracle SQL statement in the web application and increase the performance of the application. • Create UNIX and PL/SQL scripts for data migration and modified data. • Support Oracle portal website • Configure Oracle Portal pages (create portal pages, StyleSheet Access , privilège, cache …) .• Implementing caching mechanism and the invalidation cache mechanism for more than 9000 Oracle portal pages • Create, maintain, monitor and troubleshoot the Oracle system. Will work closely with users and system and network administrators• Modeling data using Oracle Designer & Erwin • Clone environments when required to replicate and test fix for a production problem• Import and export database • Work in environment of migration Oracle 9i database to Oracle 10g .• back up and restore scripting procedures and testing• backup, RMAN and cloning Oracle Application environmentsCreate 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, Java, Windows 2000, Unix, JDeveloper , SiteMinder. , Erwin , Oracle Designer

Ottawa, Canada Area

• Designing 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. • Implementing database conversion from different database structure and environment• Migrating 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• Ensuring integrity and concurrence in the database, managed storage allocation of database, tuned database, and maintained backup and recovery• Migrating and converting MTRS (Medical Transportation Records System) database• Ability to write queries, used all stats tools, DBA studio and TOAD• Assessing existing data and database infrastructure, identified data sources, data migration, design, integration and implementation recommendations• 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• 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

Ottawa, Canada Area

• Analyzing and migrating the database for Human Resource system (Oracle 8i) in Oracle DBMS to Oracle 9i • Writing PL/SQL packages, procedures, functions and triggers to help the java developers in implementing the business logic and requirements.• Creating and modifying functions, procedures and packages.• Setup and installing Oracle database server in Windows 2000 server.• Setup Apache server in Windows 2000 server operation system.• Tuning, backup, recovering, and maintaining database.• Helping java Developers create web site for Object Computing International Inc. using java, JSP, Java script, HTML.Environment: Oracle 8i, Oracle9i, PL/SQL, Oracle Designer, SQL*Loader, Window 2000 Server, Java Script, HTML, TOAD, Java, JSP.