MIS & Data Warehousing Specialist
CREDIT AGRICOLE EGYPT BANK
Total des années d'expérience :25 years, 9 Mois
• 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.
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.
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"
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"
• Jan '2000 - July '2002: Network Administrator & Hardware Maintenance, COMPUTER HOME COMPANY.
Network Administrator & Hardware Maintenance
Developer
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.
Commerce