Mohamed Essam Shabaan

Egypt, Cairo. El-Shrook city, Al Narges 2 District, Buildings, 35, Flat: 1

Mobile: 002-010-67826388

Email: adgn3v@r.postjobfree.com

LinkedIn: https://eg.linkedin.com/in/moessam

Summary

Highly motivated Business Intelligence Professional & Application Development using Oracle Technologies. And manipulating various data sources to support Senior Management decisions. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Have 10+ years of experience in development of Application programs, Database Tables and Stored Procedures, and Reports in several Technologies such as Forms Builder, Reports Builder, Application server 10g, WebLogic 11g, OBIEE, ETL (Informatica&ODI), Flexcube, UX/CX and ITIL v4.

I'm interested in working on ITIL, business & technical analyst, service design and design thinking projects includes leading Design Thinking transformation for Agile teams and delivering Service Design projects for digital transformation.

Experience

From 7/2019 till now Ejada Systems

Sr.Data Management Consultant (specialized in analysis solutions for Banking)

-Responsibilities As (Functional Analyst specialist):-

Communicate with Bank Team to understand their requirements

Develop and analyze functional specifications

Design efficient IT systems to meet business and technology needs

Coordinate developers to build and implement technology solutions

Integrate multiple systems and reconcile needs of different teams

Gather feedback from end users about system performance

Provide advice and technical training

Keep abreast of technology trends and developments

Work with Informatica ETL Developer Tool

-Self-study:-

ITIL Foundation V4.

Participate in many online workshops to discuss (business analysis, product strategy, lean model canvas, value proposition canvas, write storming, etc...).

Intro. UX/CX & service design.

11/2017 to 6/2019 Egabi Solution

Functional Consultant specialist (Provide Business and technical solutions for Banking)

-Responsibilities As (Functional Analyst specialist):-

Communicate with Bank Team to understand their requirements

Develop and analyze functional specifications

Design efficient IT systems to meet business and technology needs

Coordinate developers to build and implement technology solutions

Integrate multiple systems and reconcile needs of different teams

Gather feedback from end users about system performance

Plan and oversee projects (e.g. upgrades, hardware/software installations)

Provide advice and technical training

Keep abreast of technology trends and developments

-Responsibilities As (Applications Developer ):-

Define client’s business, technical & functional requirements.

Formulating the application design.

Testing acceptance.

Apply internal testing for the software quality, measure its compliance with customer business requirements.

Assisting in any additional tasks requested by Direct or Unit Manager.

Train the new users of the application.

7/2016 to 10/2017 Oracle Egypt

Sr.Technical Support Analyst (Flexcube-Oracle Financial Services Software)

-Responsibilities As (Flexcube Global Support):-

Handling Support activities for FLEXCUBE Core banking system at customer location

Analyzing the issues reported and work on providing quick / work around solutions and work on data corrections for known patterns to help restore the situation.

Interpreting reported problem in technical terms and then sharing detailed analysis along with debugs and data conditions with technical team in base location in India for RCA & permanent fixes.

Helping coordinate between various teams onsite and offshore and also working with Bank’s IT team to help them test and deploy solutions to address issues permanently.

Actively participating in meetings and publishing minutes as well as sharing/presenting the overall progress update and action plan to bank’s senior management (as needed) on a periodic basis.

Monitoring EOD&EOM&EOY cycle and prepare monthly reports status required.

6/2012 to 6/2016 Egabi Solution

Sr.Functional Consultant (specialized in developing solutions for Banking)

-Responsibilities As (OBIEE Developer ):-

Creating the Requested DDL Objects as a Preparing Step to OBIEE Reports.

Import Metadata, Design Star Schema Using OBIEE Administration Tool.

Manage OBIEE Users and Privileges.

Manage OBIEE Policies and Roles.

Manage OBIEE Catalog Groups, Permissions.

Create Customized Reports Using OBIEE.

Create Prompts, Dashboards.

Testing, Creating Manuals, User Training.

-Responsibilities As (ETL Developer ):-

Work with Informatica & ODI ETL Developer Tool.

Develops logical and physical data flow models for ETL applications. Translates data access, transformation and movement requirements into functional requirements and mapping designs.

Plans and conducts ETL unit and development tests, monitors results and takes corrective action, when necessary.

Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarizing, and integration.

Designs automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner.

-Responsibilities As (Applications Developer ):-

Define client’s business, technical & functional requirements.

Formulating the application design.

Testing acceptance.

Apply internal testing for the software quality, measure its compliance with customer business requirements.

Assisting in any additional tasks requested by Direct or Unit Manager.

Train the new users of the application.

8/2010 to 5/2012 IT- Fusion

Sr.Application Developer (specialized in developing solutions for Insurance)

-Responsibilities As (OBIEE Developer ):-

Installations – OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK, Oracle Client Installation.

Knowledge of database architecture and design (Star Schema) for Oracle Business Intelligence.

Work with Presentation, Repository and Catalogs layers of OBIEE.

-Responsibilities As (Applications Developer ):-

Develop applications to support complex technical functions & Assisting in any additional tasks requested by Direct or Unit Manager.

Application Support: Acting as technical support at customer side & Conduct necessary modifications in case of errors occurrence.

Data Analyst & Data Modeling: Starting and Making (RMC, URS, ER Diagram) For “ACIS” ERP System.

Implementation Tasks: (Develop New Releases in Our Applications, Install application, implement, conduct minor customer training, testing the software at customer site & gathering related issues to create the appropriate modifications).

Starting and Developing Medical insurance System from 11/2011 to 5/2012 using Oracle database 11g, web technologies including Weblogic & Oracle Fusion Middleware.

2/2009 to 7/2010 Egypto-Soft

Oracle Developer (specialized in developing solutions for tourism and hotels)

-Responsibilities:-

Develop applications to support complex technical functions & Assisting in any additional tasks requested by Direct or Unit Manager.

Application Support: Acting as technical support at customer side & Conduct necessary modifications in case of errors occurrence.

Starting and Developing Inventory System for Hotels (Similar to Inventory module in Oracle ERP).

2/2008 to 12/2008 Orascom

Training in OTT (Orascom for training and technology)

-Graduation Project:

1.Roaya project (Entire database for a Computer & Language Institute).

2.Stock life project (Entire database for a stocks company).

Projects

FATCA Data Extraction & XML Reports in SFB :-

Integrate & Extract Data between Bank plus system (Core banking) and 1099 PRO. Software forms to get FATCA XML Reports Using Oracle database 11g.

Used Programming tools: Oracle Database 11g, Oracle Developer 11g.

Standard MT 2018“Swift Messages system “as part of Bankplus system in EALB & SFB:-

Analysis and Develop Swift Messages system by using forms and Report Builder as a separated system.

Used Programming tools: Oracle Database 11g, Oracle Developer 11g.

Migrate Data between Bankplus system and Clearing checks system in EALB :-

Integrate & Migrate between Bank plus system and Clearing checks system by using forms and Oracle database.

Used Programming tools: Oracle Database 11g, Oracle Developer 11g.

Flexcube Global Support (All Modules) in BME (Bank Misr Egypt) (6 months)https://www.linkedin.com/groups?home=&gid=161315&trk=anet_ug_hm:-

On Site Activities >> New Role SPC (single point of contact) Handling Support activities for FLEXCUBE Core banking system at customer location and prepare reports status required.

Used Programming tools: Oracle Database 10&11g, FCUBS 12.0.2.10.7.

Flexcube Global Support (All Modules) in BME (Bank Misr Egypt) (6 months)https://www.linkedin.com/groups?home=&gid=161315&trk=anet_ug_hm:-

On Site Activities >> Handling Support activities for FLEXCUBE Core banking system at customer location.

Used Programming tools: Oracle Database 10&11g, FCUBS 12.0.2.10.7.

Flexcube Global Support (CL Module) in NBE (National Bank Egypt) (2 Months)https://www.linkedin.com/groups?home=&gid=161315&trk=anet_ug_hm:-

On Site Activities >> Handling Support activities for FLEXCUBE Core banking system at customer location.

Used Programming tools: Oracle Database 10&11g, FCUBS 12.0.1.

Flexcube Global Support (EOY) in CAE (Credit Agricole Egypt) (2 Months)https://www.linkedin.com/groups?home=&gid=161315&trk=anet_ug_hm:-https://www.linkedin.com/groups?home=&gid=161315&trk=anet_ug_hm:-

On Site Activities >> Handling Support activities for FLEXCUBE Core banking system at customer location.

Used Programming tools: Oracle Database 10&11g, FCUBS 12.0.1.

ETL / INFORMATICA & OBIEE Developer in Al Rajhi Bank:-

Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes.

Used Programming tools: Informatica Power center, OBIEE 10g.

Instructor "OBIEE" Reporting Tools in Egabi solutions:-

Used Programming tools: OBIEE 10&11g.

General ledger system as part of Bank plus system:-

A general ledger system developed by using ADF forms and migrated from Bankplus as a separated system.

Used Programming tools: JDeveloper 11g.

MIS OBIEE reporting instance for Bank plus System:-

A Reporting Instance of MIS reports for Bank plus system To Help and Support the Top Management and Operation Management Levels in Core Banking Field.

Used Programming tools: OBIEE 11g (Last Version).

Oracle Financial Services Analytical Application OBIEE Reporting Instance in UNB:-

A Reporting Instance Of Oracle Financial Services Analytical Application (OFSAA) To Help And Support The Top Management And Operation Management Levels In Core Banking Field Established For Allot Of Clients.

Union National Bank (UNB) – U.A.E - Abu Dhabi.

Nour Islamic Bank (NIB) – U.A.E - Dubai.

Commercial International Bank (CIB) – A.R.E - Cairo.

Used Programming tools: OBIEE 11g.

Bank plus For Banking System:-

A Banking System to managing and arrange the work flow of the Banks Established for Allot of Clients.

Egyptian Arabic Land Bank – Egypt.

Egyptian Arabic Land Bank – Jordan.

Egyptian Arabic Land Bank – Palestine.

Nilen Bank – Abu Dhabi.

Nilen Bank – Sudan.

RCEB Bank - Sudan.

Used Programming tools: Oracle Database 10g, Oracle Database 11g, and Oracle Developer 10g.

Develop System "Marketing & Sales" for Medmark company:-

Starting and Developing Medical insurance System using Oracle database 11g, web technologies including Weblogic & Oracle Fusion Middleware.

Used Programming tools: Oracle Database 11g, Oracle Developer 11g.

Horus Insurance Brokerage System OBIEE Reporting Instance:-

A Reporting Instance Of Horus System To Help And Support The Top Management And Operation Management Levels.

Gras Savoye Egypt Co. For Insurance Brokerage

Good Life Co. For Insurance Brokerage.

Used Programming tools: OBIEE 10g.

Horus Insurance Brokerage System (Support, Enhancement & Implementation):-

An Insurance Brokerage System to manage and arrange the work flow of the Insurance Brokers Established for Allot of Clients

Gras Savoye Egypt Co. For Insurance Brokerage

Good Life Co. For Insurance Brokerage.

Arab Allied Assurance Co. For Insurance Brokerage.

Used Programming tools: Oracle Database 10g, Oracle Developer 10g.

Inventory System for Hotels:-

Similar to Inventory module in Oracle ERP.

Used Programming tools: Oracle Database 10g, Oracle Developer 10g.

Travel Agents & Tour Operators System "ETATOS" (Support & Enhancement):-

ETATOS is a complete integrated computer system for the travel agency industry.

Used Programming tools: Oracle Database 9i, Oracle Developer 9i.

Training

Oracle, Cairo, Egypt:

-Flexcube- Core Banking

Egabi Solution, Cairo, Egypt:

-Oracle Data Integration – ODI

-Informatica Power center – Ver. 9.0.1

-Java – SE, EE, ADF1, spring boot

IT-Fusion, Cairo, Egypt:

-Oracle Business Intelligence Enterprise Edition – OBIEE 10g

IBM, Ismailia, Egypt:

-A+ COMPTIA (hardware core)& (operating system)

-Network Fundamentals & Technical Support

-C language

-MCSA

Education

(MCIT), Ismailia, Egypt.

Training course From the Ministry of Communication and Information technology:

-Oracle 10g (OCP – Oracle certificate Professional) Developing, 2008

-Oracle 10g (OCP – Oracle certificate Professional) Administration, 2008

- English (ELS Certificates and London College) (General English, Conversation, and Effective Business writing Skills), 2008.

-Soft Skills (CDC Academy Certificates) (Communication Skills-Presentation Skills-Team Work-Problem Solving and decision Making-Customer Service skills-Basic Sales and marketing skills), 2008.

Computer & Internet Skills

-Excellent in general computers skills

-Excellent knowledge in Microsoft office

-Fair knowledge with Visual Basic Studio

-Fair knowledge with Visual FoxPro

-MS Project (as analyzing tool)

-MS Visio (as analyzing tool)

-ER Studio

-Toad & SQL Developer

-Built in Oracle tools, The Forms Builder and Report Builder (as Designing tools)

-SQL and PL/SQL (as Programming Languages)

-ETL Tools :- ODI, Informatica Power Center, Oracle Warehouse Builder (OWB)

-Plus all the previous certificates

Languages

Arabic : Mother Tongue

English : V.Good (Read, Write, Speak)

French : Fair (Read, Write, Speak)

Personal Data

Nationality : Egyptian

Military Status : Exempted

Birth Date : 01/07/1986

Marital Status : Married

Undergraduate Studies:

B.Sc. of Commerce - Accounting, Grade Good, May 2007

Suez Canal University, Ismailia, Egypt

Contact this candidate