Mohamed Abdelhakeem, Senior ETL & OBIEE Developer

Mohamed Abdelhakeem

Senior ETL & OBIEE Developer

Giza Arabia

Location
Egypt - Ismailia
Education
Bachelor's degree, BA
Experience
14 years, 11 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 11 Months

Senior ETL & OBIEE Developer at Giza Arabia
  • Saudi Arabia - Riyadh
  • My current job since January 2016

• 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.
• 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.

Senior ETL & OBIEE Developer at Egabi Solutions
  • Saudi Arabia - Riyadh
  • August 2014 to January 2016

Creating interfaces, Scenarios, Star schemas and reports for Information and Statistics Center of Ministry of Water & Electricity Operational system To Help and Support the Top Management and Operation Management Levels to prepare the Annual Report of The Ministry.

Senior Functional Consultant at Egabi Solutions
  • Egypt - Cairo
  • June 2012 to February 2013

Senior Functional Consultant at Egabi Solution (specialized in developing solutions for Banking) from 6/2012 till now.
- Responsibilities:-
• 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.
• Design ETL Using ODI Tool.
• 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.

Application Developer at IT Fusion software house
  • Egypt - Cairo
  • December 2010 to May 2012

Application Developer at IT-Fusion (specialized in developing solutions for Insurance) from 12/2010 to 5/2012.
- Responsibilities:-
• Oracle 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.
• Responsible for maintenance and enhancement of “Horus” Insurance Brokerage System.
• Analyze problems with clients if found.
• Make formal visits to clients for support and maintenance if necessary to handle the problems with him.
• Tasks in OBIEE:-
1. Support, Fix And Enhance OBIEE Reports For The Reporting Instance.
2. Knowledge of database architecture and design (Star Schema) for Oracle Business Intelligence.
3. Work with Presentation, Repository and Catalogs layers of OBIEE.

• 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.

Oracle Developer (Part Time) at 1 Solution Co.
  • Egypt - Cairo
  • September 2009 to September 2010

- Creating, developing required forms and reports.
- Creating the required database components
- Testing the Application using and mechanism.

Technical Support Engineer at ESRINEA Co.
  • Egypt - Suez
  • December 2009 to December 2009

- Tracing errors and bugs of MCIT application.
- Backup operation for MS systems.
- Remote Desktop, Remote Assistant.
- System administrator.

Sales Retail at B.TECH Co.
  • Egypt - Ismailia
  • May 2009 to December 2009

Retail Sales.

Data Entry at Teleperformance Egypt Co.
  • Egypt - Cairo
  • January 2009 to May 2009

Data Entry For Vodafone Egypt In Pound Project

Data Entry at Teleperformance Egypt Co.
  • Egypt - Cairo
  • December 2008 to January 2009

Data Entry Agent For The Hard Copies Campaign

Call Center Agent at Teleperformance Egypt Co.
  • Egypt - Cairo
  • December 2007 to December 2008

- Receiving and Checking Files of Customers.
- Finishing reports of salaries and commissions.

Education

Bachelor's degree, BA
  • at Suez Canal University
  • May 2006

Faculty of commerce. - Department: accounting. - Year of graduation: 2006. - Overall grade: good, 65.83%. - Last year grade: good, 72 %.

Specialties & Skills

Oracle Developer 2000
Oracle SQL
Oracle Application Server
Good knowledge of windows 98, 2000, XP, Vista, 7, 8

Languages

Arabic
Expert
English
Intermediate

Memberships

Egabi Solutions
  • Senior Functional Consultant
  • May 2012

Training and Certifications

Oracle 10g developer track (Training)
Training Institute:
Next Academy
Date Attended:
March 2008
Linux Course. (Training)
Training Institute:
Orascom Training & Technology.
Date Attended:
July 2007
Oracle Application Server & E-Business (Web development track) (Training)
Training Institute:
Orascom Training & Technology.
Date Attended:
September 2007
Soft skills Course. (Training)
Training Institute:
CDC Academy.
Date Attended:
December 2006
English Course. (Training)
Training Institute:
CDC Academy.
Date Attended:
September 2006
Introduction to information systems and PC. (Training)
Training Institute:
Orascom Training & Technology.
Date Attended:
March 2007