Jihad Rahme

Qlikview professional
Oracle 12C

Development, testing and delivery of all DW business requirements.
Develop star-schema structures and ETL for new data warehouse initiatives.
Develop data models for applications, metadata tables, views or related database structures.
Develop or maintain archived procedures, procedural codes, or queries for applications
Develop and document database architectures.
Migrate ETL from Oracle MDM to SAP HANA Matrix
Conduct a new project for an insurance company in the Gulf:
* Requirements gathering & data collection
* Software development - Preparing the specs document and validate them
* Data Modeling and implementation in Oracle platform
* Prepare the database environment with all the configurations
* Data migration Oracle to Oracle using latest PL/SQL syntaxes for merge and data validation
* Perform several DBA tasks such as RMAN restore, backup, database maintenance, recovery...

Maintain a database system of key performance indicators as students enrollment, attrition, graduation and other matrices.
Report on data, perform analysis, and produce comprehensive reports with clear, relevant and accurate information.
Provide interpretation of results and scenario planning and prepare qualitative and quantitative analysis of data.
Assist in the completion of surveys for different stakeholders and conduct corresponding analysis.
Assist in improving the attendance of the students by doing wide analysis reports for decision making of the students enrollment.
Learn and use many analytic tools such as SPSS, SAS, R, Excel, and SQL Server to perform the above tasks.

Programming Languages: PL SQL (fluent), SqlPlus
Database: Oracle 10g, Oracle 11g, SQL Server
Generalities: MS Office, Networks tools, Security tools, communication tools
Microsoft Sql server, business intelligence tools, SSIS, SSAS and SSRS.
Oracle Data Warehouse, OWB, ODI and AWM.
Business intelligence tools knowledge.
Database administration: Monitor database and tablespaces, datafiles, cash, export/ import database/schema/tables/objects…


Data Integration and Migration process
Data forecast for long period of time using trend, slope seasonality, cycle…
History Data cleansing for smooth and better forecast.
Retail Optimization based on defined objective
Testing, Validation and certification
Database monitoring and tablespace checkup.
Analysis and design of data flow between the various components.
Preparing test plans and test cases.
Entering data accurately onto computerized databases & Excel spreadsheets.
Locate and correct data entry errors.
Maintain logs of activities and completed work.
Reviewing validation output and performing specified manual checks on the data to ensure consistency and completeness.

Training sessions regarding the Data warehousing with Oracle, and business intelligence.
Workshop with Bank Of Beirut to understand the hierarchy of their data and build appropriate ODS.
Work with OWB tool in order to build the warehouse the ETL process.
Discover and practice more Oracle tools to build the DW and related analysis.