Mohsen Mahmoud Hassanien

+1-226******* ac63ij@r.postjobfree.com

*** ****** **** ********* ******, ON

http://linkedin.com/in/mohsen-mahmoud-bi

Summary:

I have an open work permit to work in Canada

Highly-adaptable professional with 9+ years of experience in Successfully implemented the data warehouse design and business intelligence & ETL& Cloud platforms for Different Systems

Expertise in Oracle Business Intelligence, ETL ( Informatica,ODI ), Hyperion Planning, Hyperion Financial Disclosure, Data Visualzation, RDBMS performance tuning SQL, PLSQL, ETL and systems integration.

Expertise in Project management, Business analysis, IT Services Management

(ITSM) and ITIL methodology, designing processes, strategies, infrastructure planning and developing cost effective solutions to meet both customer and business requirements.

Responsibilities:

Expert in using Oracle Business intelligence Enterprise.

Integrate Oracle Business Intelligence with Mobile Devices both Android and IOS.

Integrate Oracle Business Intelligence 12c with Oracle Maps using Map Viewer

Expert in Oracle Database Programming SQL & PLSQL.

Install and configure OBIEE10g, 11g, 12c in different OS.

Fair Knowledge in tuning OBIEE, ETL using ODI.

Proficiency in OBIEE Migration from Version 10g to 11g and 12c.

Proficiency in using Informatica Power Center 9.0.1 & Oracle warehouse Builder 10g.

Proficiency in using SQL Server Integration Services for Defining Workflows to automate updating multidimensional Cubes and automating maintenance tasks for SQL server databases

Extensive work in ETL process of data transformation, data sourcing, mapping, conversion and loading using Informatica Power Center & Oracle warehouse builder.

Create Procedures, Functions and Packages according to business need.

Design and Develop OBIEE Repository using Admin tool by importing the required objects with integrity Constraints into physical layer using connection pool.

Create Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns & manipulate Fact column in BMM Layer as per requirement using Calculation Wizard.

Create Time Series objects for comparing business performance with previous time periods using Ago and To Date Functions

Create various Presentation Catalogs in presentation layer with tables and sub tables.

Develop Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.

Generate Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Sub Reports, Linking Reports etc.

Using putty UNIX system.

Proficiency in using Oracle Essbase Studio and Console.

Expert in Oracle BI Data Visualization.

Good knowledge of Oracle PaaS Cloud (Business Intelligence).

Good knowledge of Oracle Bi Cloud Services, BI Cloud Data Sync

Good knowledge of Oracle BICS (Business Intelligence Cloud Services) Mashup.

Good knowledge of Oracle Database Cloud Services (Creating Service Schema, Loading the data and Connecting to the schema on the cloud from External Source).

Good knowledge in WebLogic, Unix Commands, Shell Scripts & Unix Tools (WinSCP, Putty).

Oracle Disclosure Management System.

Design customization based on new customer requirements.

Good knowledge of Oracle BI Metadata Modelling

Good Knowledge in Oracle Big Data & Advanced Analytics

Knowledge of Hadoop & Its Components.

Connect between Apache Hadoop and OBIEE.

Expert in Finance Business and Banking Source systems.

Working in Analytics - BI - EPM Hyperion requirement, analysis & understanding, solution design, finance transformation, functional technical road map, implementation, transition & go live.

Managed a team of General accounting applications system, Financial solution design & implementation, solution and service delivery.

Use Hyperion and Smart View to validate reports figures. Experience :

BI & Data Analytics Delivery Manager

AL Rajhi Bank, Riyadh KSA

Financial/Banking 9,000+ Employees

Jan 2016 –Present

Development Team Leader BI&DWH

AL Rajhi Bank, Riyadh KSA

Financial/Banking 9,000+ Employees

Aug 2014 – Dec 2015

Senior ETL & BI Consultant (Outsourcing)

AL Rajhi Bank, Riyadh KSA

Financial/Banking 9,000+ Employees

Sep 2011 – Aug 2014

Senior Technical Consultant

Egabi Solutions, Egypt,Cairo

IT/Software 500+ employees-

Aug 2011 – Aug 2014

Oracle Developer

IT Fusion Software House, Egypt,Cairo

IT/Software 50+ employees-

Sep 2009 – Jul 2011

Major Projects :

Current Project:

Description:

New Dashboard for C Level in The Bank across all Departments. Tools:

OBIEE 12c, Informatica, Oracle DB12c, SQL server DB, Essbase,and install the OBIEE 12c into Exalytic Machine.

Project 1:

Description:

Implementing and supporting the following systems: Oracle Hyperion Planning.

Oracle Hyperion Financial Disclosure.

Function Leading:

Oracle OBIEE (Hyperion Related dashboards).

QA & QC project activities.

Vendor Management (Oracle, Accenture, EY, Wipro)

Participated member in IT transformation program. Project 2:

Description:

Implement MRA (Management Reporting Analytical) Project into Rajhi Bank:

By designing the Reports using OBIEE 12c to High Management

And Using ODI as An ETL Tool and Essbase to create the Required Cubes based on business needs then display the data into BI Reports using Cubes.

Project 3:

Description:

Upgrade the Informatica Power Center from Version 9.0.1 to version 9.6

And also upgrade the OBIEE from Version 10.0.3.4.1 to version 11.1.1.7

And applying some security Patches into OBIEE.

Project 4:

Description:

Full System for Exception Monitoring Department at al Rajhi Bank: used to fill Reporting tables with Informatica maps and building all the Reports with OBIEE 12c.

Project 5:

Description:

FAH Project (Financial Accounting Hup): Build Reports for Finance Department at Al Rajhi Bank) Using Informatica and OBIEE11g.

Project 6:

Description:

Replacing All OWB maps used to fill Reporting tables with new Informatica maps for better Failure Recovery Management

And building all the Reports using OBIEE.

Project 7:

Description:

Full System for Operation Risk Department at al Rajhi Bank at al Rajhi Bank used to fill Reporting tables with new Informatica maps and building all the Reports with OBIEE 10g.

Project 8:

Description:

Full System for All OFSA Maps at al Rajhi Bank at al Rajhi Bank: used to fill Reporting tables with new Informatica maps and building all the Reports with OBIEE 10g.

Project 9:

Description:

• Full System for Trasset Department at al Rajhi Bank at al Rajhi Bank: used to fill Reporting tables with new Informatica maps and building all the Reports with OBIEE 10g.

Courses:

Oracle BI Suite EE 10g&11g R3 Build Repositories Training at Oracle academy

Oracle BI Suite EE 10g&11g R3: Create Reports and Dashboards Training at Oracle academy

Oracle Hyperion Disclosure Management 11.1.2 Create and Manage XBRL Documents Oracle Self-study.

Oracle Hyperion Financial Data Quality Management EE Administration By Implementer (Oracle)

Oracle Hyperion Planning Fusion Edition 11.1.2 for Interactive Users by Implementer (Oracle)

Oracle Hyperion Financial Reporting 11.1.2 for Essbase and Planning Oracle Self- study

Oracle Hyperion Planning 11.1.2 Create and Manage Applications Oracle Self- study

Agile Fundamentals Training & Certification

ITIL Foundation Certificate in IT Service Training & Certification

Virtualization. (VM-Ware, Oracle VM VirtualBox).

Oracle SQL Fundamentals & Advanced Self Study.

Oracle PLSQL Fundamentals and Advanced Self Study.

Microsoft SQLServer 2000 (Amac Center, Egypt)

Management Skills (Training Center)

Oracle Essbase Development Course (Admin console) at Oracle University Riyadh

ITIL Fundamentals at Saudi Arabia Jodayan Center\

C++ (IT Center in the faculty of Engineering (Cairo University))

C# (Yet education center)

OFSAA Infrastructure Fundamentals.

Tools: -

Informatica Power Center.

OBIEE 10g,11g,12c

ODI

SQL

PL/SQL

Essbase

Oracle Warehouse Builder

Teradata

EPM & Disclosure Management

Informatica Power Center 9.0.1

Oracle Warehouse Builder10g

ESSBASE

OBIEE

Oracle 11g

Oracle 10g

Oracle 9i

Oracle 6i

Project Management

Unix

Certificates:

Oracle Business Intelligence Certified Specialist

Agile Fundamentals Certified.

Oracle VM Server for x86 Implementation Certification.

Oracle Database 12c New Features Certification.

Personal Skills:

Ability to initiate and implement new Ideas and methods

Analytical approach to problem solving & decision making

Ability to work in a team & under pressure

Good communication with people & self-Motivated

High business sense and time management

Language Skills:

Arabic: Mother Tongue.

English: Fluent written and spoken.

Programming Languages:

SQL

PL/SQL

Operating Systems:

Windows

Unix

Personal Data:

Date of Birth: 13/5/1987

Nationality: Egyptian.

Marital State: Married.

Military Status: Postponed.

BSc. Computer Science, faculty of computer and informatics Suez Canal University .

Graduated: May 2008

Grade: Very Good

Contact this candidate