Project Oracle

Mostafa M. Elsaadawy

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

Hoover, AL 35244

1-205-***-**** **********@*******.***

IT PROFESSIONAL

QUALIFICATIONS

. Twelve years as an IT professional with strong focus on enterprise

business objectives.

. Experienced and highly-motivated team leader, with analytical mind and

creative problem-solving abilities.

. Productive self-starter with a strong work ethic; decision maker and

consistently achieve goals.

. Unique ability to multi-task and manage multiple projects simultaneously.

. Proficient in Data Warehousing analysis, architecture and implementation.

. Strong Professional experience in designing and building Business

Intelligent (BI) reports and Dashboards

. Professional in financial reports generation and validation.

. Highly experienced in functional as well as technical areas of Oracle ERP

system with in depth focus on financial modules.

. In depth experience in the KSA banking sector where complex projects to

drilldown and reconcile balances of Oracle GL to different feeder systems

using the concept of Oracle Financial Accounting Hub (OFAH) were managed

successfully to completion.

. Strong Professional experience in Oracle PL-SQL and T-SQL

SKILLS

Data Warehousing ETL - Informatica Power Oracle database 8i,

Business Analyst Centre 8.1.1 9i, 10g, 11g and

Project management Oracle EBS Financial R12 12g.

Oracle EBS Financial Oracle Developer 6i

BI - SAP Business 11.5.10.2

Objects Oracle PL/SQL - T-SQL Teradata - Database

PROFESSIONAL EXPERIENCE

National general Automotive Co. (NAT), Riyadh KSA, Senior Business Analyst

Jan 2014 - Jul 2014

NAT holding group in automotive business hold Nissan, Autostar, Isuzu and

Autostar Express Service.

. Responsible for analysis / Design phases for oracle E-Business suite

financial (GL, AP, AR, FA) R12 implementation.

. Developed standard templates and procedures to collect and document

requirements.

. Surveyed and ran workshops with key business owners and stakeholders to

understand their needs for system changes required to support those needs

and enhance their business unit operations.

. Documented comprehensive business requirements in the form of process

flows and functional design documents useable by business and technical

teams including clear specifications, user cases, and user interface

mockups.

. Worked directly with the developers to turn the business requirements

into technical requirements

. Tested and verified the implemented requirements, either directly or thru

QA team.

. Tracked issues resulted from testing until it is fully resolved and

closed with business user's approval.

. Led projects from initial concept through system acceptance and post

implementation support

EJADA Systems Company, Riyadh, KSA, Senior BI - Data Warehouse Consultant/

Team Leader 2007-2013

MOBILY Client Project: MOBILY Business Process automation and KPI 2013-

2014

1. Led the business process improvement team to improve automate processes.

2. Collected data from business users, analyzed and validated data

collected.

3. Designed a simplified functional model of business requirements and

convert it to technical requirements for the technical automation team.

4. Designed KPIs and Dashboards to measure the effectiveness and efficiency

of MOBILY processes as whole using SAP business object and xcelsius

dashboard.

5. Designed ETL maps to load the data from different data bases to a BI

data mart using Data stage tool.

ALINMA Bank Client Project: Outsourced to the bank as BI / Data warehousing

consultant 2010-2013

1. Analysis and Design new business users requirements.

2. Designed and analysis BI reports using SAP business object.

3. Monitor ETL loading cycle (Informatica).

4. Data validation and correction.

5. Write advanced scripts, procedure and functions using oracle PL-SQL.

6. Lead the BI team and develop complex BI reports.

7. Supported the Information system department (Data warehousing) with wide

range of technical and functional issues.

8. Managed and support different project built in data warehouse

a. Project to drilldown & reconcile ALINMA financial banking system

(Oracle E-Business Suite- Financial R12) to the core banking system

T24.

b. Saudi Arabian Monetary Agencies (SAMA) reports.

9. Conducted gap analysis and prepared gap analysis reports for mid and top

managements.

ALINMA Bank Client Project: Outsourced to the bank as Project Manager 2009-

2010

1. Managed a project to develop enablers of drilldown & reconciliation of

ALINMA financial system (Oracle E-Business Suite- GL) to the core banking

system T24.

2. Build the linkage between Oracle GL (transactions and balances) and the

core banking system T24 to ease reconciliations and drilldown.

ALINMA Bank Client Project: Outsourced to the bank as Consultant Aug 2008-

Feb2009

1. Managed a project to develop system for the Saudi Arabia Monetary Agency

(SAMA) reporting as done below for the SAUDI HOLANDI BANK.

SAUDI HOLANDI BANK Client Project: Outsourced to the bank as Operational

Risk Technical Consultant Feb 2008- Jul 2008

1. Managed a project to develop the Saudi Arabia Monetary Agency (SAMA)

reporting.

2. Wrote advanced PL-SQL procedures, functions and scripts to aggregate the

data as per SAMA requirements.

2. Build customized screen in the application for Metadata, Aggregations

rules, and Adjustment screen using oracle forms builder.

3. Developed reports as per SAMA requirements i.e. Balance sheet, Loans,

and Remittance using SAP business object.

SAUDI FARANSI BANK Client Project: Outsourced to the bank as Oracle EBS

Consultant Feb 2007- Feb 2008

1. Managed the implementation of Oracle EBS GL module for the bank and 4 of

its subsidiaries.

2. Developed fully integrated system between feeder systems (investment,

Core banking system) and the GL module using Oracle Pl/SQL scripts to

automatically import the journals.

3. Collected and implemented new reporting requirements as well as changes

to existing functionalities and process reengineering requirements.

4. Provided analysis to support the bank staff in implementing Oracle

Financial Accounting Hub between Oracle GL and other feeder systems.

5. Provided professional training to staff business user as part of the

change management effort of the implementation team.

6. Tools leveraged in all EJADA clients engagements are as follows:

> ETL - Data stage / Informatica

> BI- SAP Business Object (BO)

> Xcelsius dashboard

> Teradata Database

> SAP strategy management tools

> PL - SQL

> Oracle Forms / Reports

CULF MEDICAL CO. Ltd., Jeddah, KSA, Senior Oracle Developer 2006-2007

1. Provided support for the full ERP suite (including sales, inventory, GL,

Payables, Fixed Assets, human resources, and maintenance)

2. Monitored the technical and functional system performance and identified

new requirements.

3. Designed solution for the new requirements once approved.

4. Developed and tested the solutions using Oracle 10g for DBMS as well as

Developer 10g

SAFWA - information technology Oracle Developer Feb 2004-Dec 2006

1. Performed complete analysis of the old GMC ERP system developed

previously using Oracle developer 6i. Pain points were clearly defined;

subsequently all modules were redesigned including accounts payables, HR,

assets, sales, accounts receivables, and GL. In addition a new maintenance

module was designed, developed and deployed.

2. Developed a complete ERP solution for Gulf Medical Company (GMC) using

Oracle developer 9i (Forms & reports) and deployed in the application

server 10g (Forms edition)

3. Managed the data migration from the legacy system to the new system.

Arab Software Consultants - information technology Oracle Developer Jul

2002-Feb 2003

1. Developed Payroll & HR systems that handle multi-companies

2. Customized existing modules managing stock controls & accounting systems

EDUCATION

B.S.C., Computer Science & Automatic Control Dept., Faculty of Engineering,

Alexandria University, Egypt 2002

Graduation Project: developed a Hotel management system that provides

reservation system, inventory and fixed assets. The project achieved using

oracle form 6i, oracle report, and oracle database 8i (with excellent

grade)

Certificates:

Project Management Professional (2009-2012)

Project Management Professional (2012-2015) Renewal

TRAINING COURSES:

Oracle EBS R12

Informatica Power Centre

Hyperion financial management

Teradata Basic SQL

Project Management Professional

Project Management Professional Renewal

Contact this candidate