Mohamed Farag, MIS & Data Warehousing Specialist

Mohamed Farag

MIS & Data Warehousing Specialist

CREDIT AGRICOLE EGYPT BANK

Location
Egypt - Cairo
Education
Bachelor's degree, Commerce
Experience
25 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :25 years, 10 Months

MIS & Data Warehousing Specialist at CREDIT AGRICOLE EGYPT BANK
  • Egypt - Cairo
  • My current job since July 2009

• upgrade version of flex cube from v6 to v12
• Extracting data from multi sources (flex cube, Credit card system, Work Flow system, and other flat file sources) to the data warehouse.
• Administrator for Oracle Business Intelligent Enterprise Edition.
• Developer at Oracle Business Intelligent Enterprise Edition.
• Developer at Business Objects XIR2, R3.
• Support system ACP to CBE and other reporting For CBE.
• Support and developed programs at OFSA.
• Data warehousing and OFSA implementation.
• Implementing Business Intelligence project for Enterprise Reporting, Ad-hoq reports, and Analysis.
• Development of the bank Mass reports.
• Development of the Bank analytics for business performance monitoring.

at Company Industry
  • Egypt
  • July 2009 to March 2014

In order to provide past, present and prediction information, and create software that helps in decision making, data resources such as databases, the hardware resources of a system, decision support systems, people management and project management applications, and any computerized processes that enable the department to run efficiently.


DWH: Design, model, or implement corporate data warehousing activities.
Program and configure warehouses of database information and provide support to warehouse users.

Location: Egypt, Cairo.
Company Industry: Banking.
Job Role: Technical.
July 2009 - Present
Key Responsibilities: • upgrade version of flex cube from v6 to v12
• Extracting data from multi sources (flex cube, Credit card system, Work Flow system, and other flat file sources) to the data warehouse.
• Administrator for Oracle Business Intelligent Enterprise Edition.
• Developer at Oracle Business Intelligent Enterprise Edition.
• Developer at Business Objects XIR2, R3.
• Support system ACP to CBE and other reporting For CBE.
• Support and developed programs at OFSA.
• Data warehousing and OFSA implementation.
• Implementing Business Intelligence project for Enterprise Reporting, Ad-hoq reports, and Analysis.
• Development of the bank Mass reports.
• Development of the Bank analytics for business performance monitoring.


* DBA Oracle
At AL WATANY BANK OF EGYPT

Location: Cairo, Egypt
Company Industry: Banking.

Oracle Developer and subsequently merited promotion at Job Role
  • October 2002 to July 2009

Job Role: Technical.
October 2002 - July 2009
Joined as Oracle Developer and subsequently merited promotion to the post of DBA Oracle through excellent performance.

Key Responsibilities:
➢ Administrate oracle database under operating system Solaris 64 bit, and Solaris 32 bit.
➢ Implementation latter of credit import "LC" system "Informix".
➢ Develop "LC" import & export system by "Oracle 6i".
➢ Bill of LCS system "Oracle 6i".
➢ Implementation of Signature system "Informix".
➢ Migration data of Signature system from "Informix" to "SQL server".
➢ Implementation Signature system "SQL server".
➢ Migration data from Oracle 9i relies1 with character set 'US7ASCII ' to Oracle 9i relies2 with character set 'UTF8'.
➢ Design system Backup & recovery from database oracle 9i for all branches in bank.
➢ Design database disaster site from main site.
➢ Replace database & migrate data from SUN machine 420 to SUN V890.
➢ Send SMS online for any transaction.
➢ Design database for historical data.
➢ Design and implementation for data guard from life site to disaster site.
➢ Support Risk Rating "Oracle 6i".
➢ Support Human resources "Microsoft access"

Oracle Developer & DBA Oracle at AL WATANY BANK OF EGYPT
  • Egypt - Cairo
  • October 2002 to July 2009

 Administrate oracle database under operating system Solaris 64 bit, and Solaris 32 bit.
 Implementation latter of credit import "LC" system "Informix".
 Develop "LC” import & export system by "Oracle 6i".
 Bill of LCS system "Oracle 6i".
 Implementation of Signature system "Informix".
 Migration data of Signature system from "Informix" to "SQL server".
 Implementation Signature system “SQL server".
 Migration data from Oracle 9i relies1 with character set 'US7ASCII ' to Oracle 9i relies2 with character set 'UTF8'.
 Design system Backup & recovery from database oracle 9i for all branches in bank.
 Design database disaster site from main site.
 Replace database & migrate data from SUN machine 420 to SUN V890.
 Send SMS online for any transaction.
 Design database for historical data.
 Design and implementation for data guard from life site to disaster site.
 Support Risk Rating "Oracle 6i".
 Support Human resources "Microsoft access"

Network Administrator & Hardware Maintenance at COMPUTER HOME COMPANY
  • January 2000 to July 2002

• Jan '2000 - July '2002: Network Administrator & Hardware Maintenance, COMPUTER HOME COMPANY.

Network Administrator & Hardware Maintenance at COMPUTER HOME COMPANY
  • Egypt - Cairo
  • January 2000 to July 2002

Network Administrator & Hardware Maintenance

Developer at AL TAKWA DENTAL CENTER
  • Egypt - Cairo
  • June 1998 to January 2000

Developer

Education

Bachelor's degree, Commerce
  • May 2001

Bachelor's degree At Commerce faculty. Location: Cairo, Egypt Completion Date: May 2001 Grade: Good. Trainings and Certifications: • General IT Courses (Internet Fundamentals, Network Fundamentals, Web Page Authoring Fundamentals, Introduction to Programming Concepts), 55 Hour, Egypt, YAT. • Web developer Courses (Java script, HTML, Photo Shop & Flash), 48 Hour, Egypt, YAT. • Oracle Introduction Courses (Introduction to SQL, Introduction to PL/SQL, program unit), 104 Hour, Egypt, SYNERGY. • Oracle 9i track (internet applications 1, internet applications 2, report builder 9i), 104 Hour, Egypt, SYNERGY. • Oracle data warehouse Courses (warehouse builder, Discoverer Desktop edition, and Discoverer administration edition), 64 Hour, Egypt, ORATECH. • Oracle OFSA Courses (For End User, For Administration), 104 Hour, Egypt, Oracle. • 7 Habit (management), 24 Hour, Egypt, In House. • ITIL Foundation (certified), 60 Hour, Egypt, In House. • Informatics (Developer, Administrations), 120 Hour, Egypt, In House. • AIX, 40 Hour, Egypt, INTERCOME.

Bachelor's degree, Commerce
  • at Cairo University, Commerce faculty
  • May 2001

Commerce

Specialties & Skills

MIS Reporting
Oracle Developer 2000
Oracle Enterprise Manager
HTML, Java Script
Informix
UNIX (SUN Solaris)
DATABASE
HUMAN RESOURCES
INFORMIX
MICROSOFT ACCESS
MS ACCESS
SOLARIS
Visual Basic
Oracle Business Intelligent Enterprise
Oracle Report 9i
Oracle data warehousing
Application server 9i
Microsoft SQL server
Microsoft Windows
Oracle financial server application

Languages

French
Beginner
Arabic
Expert
English
Intermediate

Training and Certifications

Oracle 9i track (Training)
Training Institute:
SYNERGY
Date Attended:
April 2002
Oracle OFSA Courses (Training)
Training Institute:
Oracle
Date Attended:
July 2009
General IT Courses (Training)
Training Institute:
YAT
Date Attended:
January 1999
Oracle Introduction Courses (Training)
Training Institute:
SYNERGY
Date Attended:
February 2002
Web developer Courses (Training)
Training Institute:
YAT
Date Attended:
April 1999
Oracle data warehouse Courses (Training)
Training Institute:
ORATECH
Date Attended:
January 2008
• AIX (Training)
Training Institute:
INTERCOME
Date Attended:
August 2007

Hobbies

  • Running
  • Swiming
  • Reading