ABOUT ME

With more than ** years of

success in data management, BI,

analy cs, and Enterprise

applica ons.

- includes consul ng, solu on

design, model, and implement

complex analy cal solu ons,

development, post-

implementa on maintenance and

support of data management &

implementa on, post-

implementa on, upgrade technical

solu ons, and customiza on of

Oracle e-Business suite modules

(R12.2.x, R12.1.x, 11i).

Key Personal characteris cs:

• Deep knowledge in a wide range

of products and technologies.

• Quick adap on to any new

technologies or ideas.

• Strong implementa on

capabili es in various business

sectors: Telecommunica on,

Healthcare, Government,

Manufacturing, Consul ng, Food

Industry, Steel Industry, and

Insurance

• Excellent communica on,

presenta on, and demonstra on

skills.

Specialized in:

• Data Visualiza on and

Dashboards.

• Enterprise Data Warehouses &

ETL’s.

• Data Quality & Master Data

Management.

• Enterprise service and

integra on.

• Advanced Analy cs/ Data.

• Microso BI full stack (SQL

Server Data warehouse, SSIS,

SSAS, SSRS, Power BI Cloud

Service, Power BI on Premise).

• Oracle BI full stack(Oracle Data

warehouse, Admin Tool, OBIEE,

OBIA, ETL (ODI)).

EDUCATION

Cair, Egypt

2004

Cairo, Egypt

2007

Cairo, Egypt

2007

WORK EXPERIENCE

Jeddah, Saudi Arabia

Jun 2018 - Present

• Responsible for design, implement, deploy, and

maintain full-stack BI solu ons.

• U lizing my technical and func onal experiences of Oracle E-Business Suite in BI solu ons.

• Develop healthcare BI solu ons include (Healthcare stander indicators, Outpa ent, Inpa ent, Procedures, Pharmacies, Laboratory, Radiology, ER, revenue

analysis), to enable management levels to make be er performance and revenue.

• Building up a centralized data warehouse and

mapping out and integra ng it with all healthcare

applica ons & Oracle ERP modules.

• Develop analy cal Oracle ERP e-Business suite

(Finance, SCM, HR) indicators dashboards, and

reports.

• Build and maintain reports, Scorecards, Dashboards, and KPI’s tools (SSRS, Power BI (cloud or on-

premises), Oracle Admin Tool, Oracle Analy cs)

• Develop and maintain Extract, Transform, Load

(ETL) processes tools (SSIS - Oracle ODI)

• Build and maintain mul dimensional cubes, Online Analy cal Processing (OLAP) tools (SSAS)

Riyadh, Saudi Arabia

Nov 2016 - May 2018

• Fresh new implementa on of Oracle BI Apps

Source: Oracle EBS - BI Target: OBIA HCM /

Financials / Supply Chain Management.

CAIRO UNIVERSITY Bachelor of Science, Computer Science ORACLE CERTIFICATION OCA Oracle Cer fied Associate

ORACLE CERTIFICATION OCP Oracle Cer fied Professional FAKEEH CARE GROUP Senior Business Intelligence Consultant DOMINO'S PIZZA MIDDLE

EAST (ALAMAR)

Senior Business Intelligence Consultant

MOSTAFA

ELROUBY

DATA MANAGEMENT DATA INTEGRATION

DATA WAREHOUSING ETL BUSINESS

ANALYTICS FULL-STACK MICROSOFT BI

FULL-STACK ORACLE BI POWER BI

ORACLE ERP EBS APPLICATION

Jeddah, Saudi Arabia

054*******

adesla@r.postjobfree.com

• U lizing my strong knowledge of

Oracle e-Business suite

experiences (Technical -

Func onal) in the challenges of BI

solu ons.

• Excellent knowledge in all

technical Oracle ERP tools (Extend

Oracle Applica ons: Forms,

Extend Oracle Applica ons:

Reports, BI Publisher, Data

Migra on and System Integra on

Using APIs & Interfaces, Oracle

Applica ons Alerts, Forms

Personaliza on, Oracle Workflow,

AME Approval Management

Engine, OAF, OAF

Personaliza on).

• SQL & PL/SQL.

• Java & J2EE & JSP.

• I have membership in the Saudi

council of engineers.

Current Study Plan:

Data Science & Big Data.

Ar ficial Intelligence & Machine

Learning.

WEBSITES & SOCIAL

LINKS

h ps://www.linkedin.com/in/most

afa-el-ruby-21b69621/

Linkedin:

LANGUAGES

ENGLISH

ARABIC

Tools used:OBIEE (Build Analysis and Dashboards) - Oracle BI Administra on (Build/Modify Repositories) - ODI (Oracle Data Integrator).

Work includes:

• Implemen ng requirements on OBIA ready-made

dashboards/analysis.

• Implement new customiza ons (BI Answers /

Repository / ODI)

• Examine the performance of Incremental & Full ETL runs

• Designed and developed various cri cal business

processes.

• Par cipate in business analysis ac vi es to gather the required repor ng and dashboard requirements.

• Translate business requirements into specifica ons that will be used to implement the required reports and dashboards, created from poten ally mul ple

data sources using an ETL tool.

• Translate business requirements and knowledge of data warehouse to model the Physical Layer, BMM

Layer, and Presenta on Layers in Oracle BI

Administra on Tool.

• Provide exper se to the business with repor ng,

analy cs, and dashboards and provide insights into data that will drive business growth and performance. Riyadh, Saudi Arabia

Jan 2014 - Oct 2016

• Develop Oracle BI Analyses and Dashboard.

• Develop OBIEE metadata repository (.rpd),

configuring metadata, Business Model Layer, Physical Data, and Presenta on Layer by using the Oracle BI Admin tool.

• Develop and designing Oracle BI Analyses and

Dashboards tool.

• Build and extend OAF pages.

• Analysis, design and develop different solu ons

using Oracle applica on development tools.

• Develop SQL, tables, views, func on, procedure,

package objects under Oracle E-Business suite

environment.

• Personalize Oracle Forms and OAF pages.

• Develop and customizing AME, Workflow.

• Crea ng custom Alerts to no fy users based on

various business events.

• Develop an integra on solu on.

• Load data by used APIs and Interface tables tools.

• Suppor ng several standard and custom modules.

Riyadh, Saudi Arabia

Jun 2012 - Dec 2013

• Data Load tasks using APIs and Interface tables.

• Developed PL/SQL Objects, Forms, Menus, and

Reports.

• Interacted with users to resolve any issues during the produc on, development, and enhancement

phases.

• Create a custom solu on by using ADF Business

Components, Threads, and JSF & Web Logic tools.

• Using the Oracle OAF tool to develop a new

extension solu on into the iProcurement module.

• Suppor ng several standard and custom modules.

• Developed and customized Workflow process by

using Oracle Workflow builder and Oracle AME tools. RAYA INTERNATIONAL

SERVICES

Sr. Oracle ERP Technical and Business Intelligence Consultant

AL RAJHI STEEL Oracle ERP Technical & Oracle ADF Consultant Riyadh, Saudi Arabia

Oct 2010 - May 2012

• Responsible for NCCI Reimbursement System, Fax

So ware & Integra on using Waseel Portal.

• Responsible for WebLogic, Reimbursements

Systems using ADF Technology.

• Using Java Technology to build SDS (Scan

Document System) to Control scanners & Cams

(JTwain Java Lib) to capture images of MDB Claims

Synchronized with File Net Project.

• DB Analysis, Design, developing DB objects.

• Responsible for the modifica ons and develop a

new process which is requests from the QA team, fix any bugs in the system.

SKILLS

SQL SERVER DB SQL SERVER ANALYSIS SERVICES (SSAS)

SQL SERVER INTEGRATION SERVICES (SSIS) POWER BI REPORT SERVER POWER BI CLOUD SERVICE POWER BI ON PREMISE

DAX DATA ANALYSIS EXPRESSIONS ORACLE BUSINESS INTELLIGENCE (OBIEE) DATA WAREHOUSING ARCHITECTURE,

DEVELOPMENT, ANALYTICS AND

MODELLING.

ORACLE BUSINESS INTELLIGENCE

APPLICATIONS (OBIA)

ORACLE DATA INTEGRATOR (ODI) JAVA SE, JAVA EE.

ORACLE E-BUSINESS SUITE (FORMS – OAF)

PERSONALIZATION

E-BUSINESS SUITE ALERT.

UPLOAD E-BUSINESS SUITE DATA API’S &

INTERFACE.

ORACLE WORKFLOW.

ORACLE E-BUSINESS SUITE EXTEND ORACLE

APPLICATIONS: FORMS - REPORTS

ORACLE APPLICATION FRAMEWORK (OAF).

SQL, PLSQL ORACLE DATABASE ORACLE XML PUBLISHER.

PERSONAL DETAILS

Na onality

Egyp an

Visa status

Resident Visa in Jeddah, Saudi Arabia

Marital status

Married with 2 Kids

TAWUNIYA INSURANCE Oracle ERP Technical Consultant & Oracle ADF Developer

Contact this candidate