Data Oracle
Resume:
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
***.*******.*******@*****.***
• 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