Core Banking Project Management

Ahmed Mohamed Khalil

Egypt, Cairo, Nasr city, Al_Waha, City Tours Compound, Al_Sawsan 1, floor 5, flat 20 +201*********, +201********* **********@*******.***

Profile

I am working in a leading bank in Egypt. I worked in IBM Saudi Arabia. I have experience in Project Management, Misys Equation & Path Solutions iMAL Core Banking, Oracle (SQL, PL/SQL), AS400 Administration and Programming (COBOL, RPG, RPGLE, SQLRPGLE, CLP), Unix, Java, C++, java script, etc. Also, I have experience in CBE reports and compliance applications.

I can work in IT sector in Development, Datawarehouse, Core Banking, Application, Oracle database, Digital transformation, and Management.

Experience

SOFTWARE DEVELOPMENT MANAGER AL_BARAKA BANK, EGYPT JUNE 2013 - PRESENT

oResponsibilities:

Develop programs over iMAL core banking and MYSIS EQUATION core banking.

I lead development team in technical tasks. Follow up SDLC with development team.

Gather user requirements and make analysis & design for any development request.

Manage the UAT (User Acceptance Test) and training for new applications.

Write documentation and user manuals for development programs.

Day to day support for end-users.

Data migration from/to AS400 and oracle

Work in data migration from legacy system to new database.

Managerial Tasks

Responsible for setting employee goals, assessing employee performance, providing feedback, and making pay recommendations.

I do a lot of meetings with business to discuss business needs.

Work over official documents for development like Change Request (CR) and User Acceptance Test (UAT).

Determine development scope, objective, and solution for development team in the projects.

Supervise the development, testing, documentation and implementation of those applications or other technical solutions and the maintenance of existing applications.

Worked over skills matrix for development team members.

Dividing project objectives into tasks, assigning them to programmers based on individual skills.

Follow up programmers in their tasks to meet required output during task period.

Follow up release for programs from development to production and programs documentation.

I do meetings with internal and external audit to answer audit questions and cover any audit remark if exist.

ORACLE Programming Tasks

Create and maintain tables, views, indexes, sequence, …., etc.

Write programs in Oracle database using (SQL/PLSQL) to build new applications and reports which are integrated with iMAL core banking.

Using Jaspersoft studio to build reports over iMAL.

Convert Oracle tables to XML file and reverse operation.

Write Oracle PLSQL procedures, function, packages and triggers.

Experience in iMAL Database, Modules, Reporting, Dynamic files, Dynamic screens, …., etc.

JAVA Programming Tasks

Experience in Java SE and write java programs like file watcher, file encryption & decryption, …., etc.

Reporting Tool

Using TIBCO Jaspersoft in reports.

AS400 Programming Tasks

Create and maintain DB2/400 for physical files, logical files, journal files, triggers, …, etc.

Write programs in AS400 using (CLP, RPG, RPGLE, SQLRPGLE, COBOL, JAVA) to build new applications and reports which are integrated with MISYS Equation core banking.

Using AS400 tools such as Query400, SDA, RLU, SQL, …, etc.

Convert Physical File data in AS400 to XML file and reverse operation.

I write many programs in Al_Baraka such as:

All the following application and reports are developed over AS400 using (RPG, RPGLE, SQLRPGLE, COBOL, CLP) to integrate with MISYS Equation core banking and over ORACLE using (SQL, PLSQL) to integrate with iMAL core banking.

Sample of my developed Applications and integration with Core Banking:

Save boxes application.

Customers stock goods application.

Central archiving application.

Credit Card application.

SMS application.

Acids Depreciation Application.

Integration interface between core banking and other application such as SAS (FTACA), and Siron (goAML, AML, KYC, and FTACA).

Financial inclusion for retail and corporate customers for Central Bank of Egypt (FIH).

Risk rating for Central Bank of Egypt (Gadara).

SMEs for Central Bank of Egypt.

I-SCORE.

Finance duty stamp estimation and position for loans every quarter for Egyptian Government.

Sample of developed Reports over Core Banking:

Statement of account (Arabic and English).

Balance confirmation (Arabic and English).

Credit Portfolio.

Unearned profit.

Delayed loans details.

Audit users create/authorize transactions

MENAFATF report for Central Bank of Egypt.

Compliance reports.

Many other reports.

PROJECT MANAGER ESMARTSOFT (IBM ADVANCED BUSINESS PARTNER), EGYPT APRIL 2009 – JUNE 2013

Update and provide project status reports, risk assessment, statement of work organization chart for project, project management plane, and any other required documents or reports.

Responsible for preparing plans for all management objectives, including risks, schedules, requirements and scope, human resources, integration and changes.

Assemble and coordinate project staff. Manage project resource allocation and make sure that all resources are fully utilized. Define project tasks and resource requirements.

Coordinate with the customer technical manager for the use of internal resources.

Responsible for identifying risks and issues and updating plans accordingly

Monitor the progress of all the works conducted in order to ensure that any possible delays or issues are dealt with in a timely manner.

Coordinate with Senior Management should any issues or problems arise on project.

Check and review the project invoices.

Cooperate with quality assurance team to manage my projects by CMMI processes.

I lead AS/400 team in technical tasks.

I manage projects in different:

platforms (Mainframe, iSeries, pSeries, PC server)

operating systems (OS/400, Unix, Linux, Windows)

databases (Oracle, DB2, Informix, MS SQL)

archiving solutions (CM, FileNet)

Programming language & Tools (Java, .Net, C#, WebSpere, Louts, Tivoli, UML, RPG, CLP, COBOL, 4GL, EGL, etc.).

AS/400 TEAM LEADER (ADMINISTRATOR/ANALYST/PROGRAMMER) JERAISY COMPUTER & COMMUNICATION SERVICE (JCCS), SAUDI ARABIA DECEMBER 2005 – APRIL 2009

Worked as AS/400 Team Leader (Administrator/Analyst/Programmer) in a project in JCCS part of Eastern Province Municipality project.

AS/400 administration (jobs, devices, communications, storage, security, performance, backup, etc.)

Analyze, write programs using (RPG, RPGLE, COBOL, and CLP) on AS/400 platform.

Database design, implementation and maintenance.

Write documentation to database and applications.

Solve problems which appear when transfer Arabic data from AS/400 to PC. It is useful to work with this data on PC and useful when make data migration from BD2 for AS/400 to other database engine for any table on AS/400 platform. I make troubleshooting for users problems. Repair connection among AS/400 machines or AS/400 machine and any other device.

Application which I built it there are:

oPayment in Bank System (Sadad).

Everyone can do his payment not only in financial department but he can do this in Bank (cash or by his credit card). By this application we send a payment order to Bank to take money from this person and we receive the data file of payment from Bank to input this data in financial database files.

oFinancial System.

Store and control data of payment invoice, transfer for money, export check,… etc. Collect previous types of money in many account numbers. Make closing every day, every moth, and every year (end of day, end of month, end of year). This system control governmental accounting.

oRealty investment.

We make a database of land parts in industrial regions. Saudi person can make a contract to take a land part through a time interval and pay money for that. This application controls these contracts. By this application we can observe which contract was expired, whose person did not pay money,…etc.

oShop licenses.

Store data of shop locations and print shop license after he pay the money. Store movements on any shop license (renew, transfer, remove… etc).

oHealth testimony.

Store data of employee who want to work in any food shop. Transfer employee to the hospital to make checkup to determine that “this employee is suitable for this job or not”. If he is suitable for this job we will give him a health testimony (license) to work in this job. Store movements on any shop license (renew, remove… etc). This application integrated with hospital applications.

oAdvertisement plans contracts.

Store data of contracts Saudi government and Saudi advertisement company which want to take some advertisement plans through a time interval and pay money for that. This application controls these contracts. By this application we can observe which contract was expired, whose person did not pay money…etc.

oHealth Observation.

Health observer man go to shops and record any error (mistakes, food poisoning…) exists in this shop. We store this data in database of this system. Then, we have errors history of each shop. If any shop make error we can print its history error to put a penalty. We can print errors for any shop in a time interval and we can send a notification to it. We can control in shops which make more errors and put a strong penalty for it.

oShops contract System.

We make a database of land parts in industrial regions. Saudi person can make a contract to take a shop in a market through a time interval and pay money for that. This application controls these contracts. By this application we can observe which contract was expired, whose person did not pay money etc.

AS/400 TEAM LEADER (ADMINISTRATOR/ANALYST/PROGRAMMER) IBM, SAUDI ARABIA OCTOBER 2002 – NOVEMBER 2005

Worked as AS/400 Administrator/Analyst/Programmer. My job description is the same with JCCS as written above.

ADMINISTRATOR/PROGRAMMER GENERAL AUTHORITY FOR EDUCATION BUILDINGS (GAEB) (ISO 9001) NOVEMBER 1998 – OCTOBER 2002

AS/400 Administration tasks such as backup, performance, connections, DB2 for AS/400 Administration … etc.

Make analysis and write programs on AS/400 platform using RPG, RPGLE, COBOL, and CLP.

Oracle developer and UNIX (AIX RS6000) Administration.

I make database design, implementation and maintenance. I write documentation to database and applications.

Train end users and support to their application.

Taught computer courses (AS/400, UNIX (AIX RS6000), PC) in EBO education center (IBM Authorized education center in GAEB).

Application which I built it there are:

oMailing Application.

In this application every department can send any letter to other department through AS/400. Write the letter within this application by a department employee. Send it to other department which can reply it, archive it, forward it to other department… etc. This application means that “email on AS/400 platform”.

oArchitectural Application.

Design database and application for architectural works. Store anything in architectural plans. This application support architectural engineers about some useful reports. This application helps architectural engineers to do their tasks.

oCivil Application works.

Design database and application for architectural works. Store anything in architectural plans. This application support architectural engineers about some useful reports. This application helps architectural engineers to do their tasks.

oEstimate the bill of quantities for building.

From the two above application, we have a complete database about the buildings. We take a one building to make the following. From this database we can estimate the quantities of items which we will use it in this building such as cement, paint… etc. We have a price list of these items which are stored in database file. Then we can estimate the bill of quantities of this building.

oEstimate electricity plans.

We take a one building to make the following. By using the database of architectural plane, we can distribute the electricity items such as lamps, plugs... etc. in all rooms and floors of the building. By this application we can collect these items on electricity lines by roles of electricity engineering. Then the application tell user the values of load of each electricity line, and the user can change this line collection to increase or decrease line load. Then this application determine the control panel of electricity in each floor, the main control panel of electricity in the building, description of input electricity cable which enter the electricity to the building.

oStrategy planning of education in the next years.

This application has three modules. The first is estimate number of population in education age by using a linear regression from previous years and using some rates (die rate…). The second is estimate students movement by using output of previous module and some rates (success, fail, migration,… etc). The third is estimate number of classes by using output of previous module and some rates (density of students per class… etc). This in each location in Egypt for any education stage or type.

oStore Application.

In this application, we save all data of suppliers, customers, items in the store. Then, we can do any other transaction in the store as order … etc.

oEducation Buildings Application.

In this application, we save all data of all education buildings in Arab Republic of Egypt.

COMPUTER TEACHER MINISTRY OF EDUCATION, EGYPT APRIL 1998 – NOVEMBER 1998

·Teach computer in education ministry school.

AS/400 INSTRUCTOR (PART TIME) IBM EDUCATION CENTER, EGYPT OCTOBER 2000 – OCTOBER 2002

Instruct all courses of AS/400 in IBM education center, Banks inside Egypt such as: Commercial International Bank, Fysal Bank, MIBank, Oman Bank, and United Bank of Egypt, …. etc and Outside Egypt to employees of Saudi Telecom co., Saudi Stock Market, Saudi Airlines, and Syrian Interior Ministry.

COMPUTER INSTRUCTOR (PART TIME) SOLUTIONS PLUS (IBM AUTHORIZED EDUCATION CENTER), EGYPT MAY 2001 – OCTOBER 2002

Instruct the following courses:

Windows 9x, Windows 2000 professional, Microsoft Office.

System Analysis & design, Software

Engineering, Data Structure & Algorithm.

Database Concepts & Design,RBDMS, SQL, DB2, Oracle.

Object Oriented concept, Object Oriented Analysis & Design.

PLC, C, C++, Object Oriented Programming Using C++.

Network Fundamentals.

Education

BACHELOR OF SCIENCE, PURE MATH AND COMPUTER SCIENCE JUNE 1996 FACULTY OF SCIENCE, EL-MENOUFIA UNIVERSITY, EGYPT.

Skills & Abilities

I worked around 7 years in government sector through IBM & Jeraisy in Saudi Arabia. I have experience in e-government projects and electronic government payment projects (SADAD) with Central Bank in Saudi Arabia.

Oracle

Very good experience in Oracle objects such as table, index, sequence, …, etc.

Very good experience in SQL and PLSQL.

Very good experience in writing procedures, functions, packages, and triggers.

AS/400

Good experience in AS/400 operations and administration. I can make controlling for (jobs, devices, communications, storage, security… etc.).

Design the back strategy and recovery planning on AS/400 platform.

Troubleshoot for problems in AS/400 machine.

Solve problems which appear when transfer arabic data from/to AS/400 and PC. It is useful to get a file contain arabic data on PC from AS/400.

Use FTP to download AS/400 object from AS/400 to PC and we can upload it over another AS/400 machine of customer.

Develop applications on AS/400 platform using RPG, RPGLE, SQLRPGLE, COBOL, CLP, and strong knowledge in Visual RPG.

Good experience in Using AS/400 tools such as SDA, RLU, SQL/400, Query/400, Query Manager, Performance Tool, Operation Navigator …, etc.

JAVA

Experience in Java SE and write java programs like file watcher, file encryption & decryption, …., etc.

Reporting Tool

Using TIBCO Jaspersoft in reports.

Other Skills:

C/C++, HTML, XML, Java Script.

Knowledge in Unix(AIX) and Linux.

Excellent knowledge of database RDBMS.

Analysis and design steps (determine the problem, collect data, determine tools,…, etc.).

Design database and use diagrams such as (ERD, Logical Database Schema, … etc).

Application integration.

Project management.

Good experience in providing training.

Able to work under stress and able to travel.

Training Courses

IBM WebSphere Commerce suite, IBM, 9/ 2001

Network Fundamentals, IBM, 4 / 2001

Object Oriented Programming using C++, IBM, 4 / 2001

Oracle Data Base, Developer 2000 Programming, GAEB, 10 / 1999

SQL, IBM, 3 / 1999

UNIX Administration (AIX), IBM, 3 / 1999

Advanced UNIX (AIX), IBM, 2 / 1999

Introduction to UNIX (AIX), IBM, 2 / 1999

AS/400 Client Access for WINDOWS 95/NT Workshop, GAEB, 1 / 1999

Developing AS/400 Applications Using SQL, GAEB, 1 / 1999

Accessing the AS/400 Database Using SQL, GAEB, 1 / 1999

ILERPG/400 programming language, GAEB, 1 / 1999

RPG/400 programming language, GAEB, 12 / 1998

Operating System OS/400, GAEB, 12 / 1998

AS/400 Relational Database design & Coding, GAEB, 12 / 1998

AS/400 Concepts & Programming Facilities, GAEB, 12 / 1998

Oracle PL/SQL, 10 / 2019

Project Management, Engineering Syndicate, 5 / 2018

Intoduction to risk management, EBI, 3 / 2019

Introduction to AML, EBI, 10 / 2022

Finincaial Inclusion. EBI, 11 / 2023

Personal information

Nationality: Egyptian.

Date of Birth: 15/09/1974

Languages: Arabic, and English.

References

Dr. Maha Nassar

Doctorate of Business Administration

Jupiter 2000 CEO (IBM Business Partner)

http://www.jupiter2000.com.eg/

Mobile: +201*********

Eng. Mostafa Abd El_Rahman

IT Valley CEO (IBM Business Partner)

https://it-valley.com/

Egypt: 12/14 El Thawra st, Dokki, Giza-Egypt. (T: +202-********- F: +202-********)

UAE: Office 331, Building A5, P.O Box:713093, Business Park Dubai World Central. (T:+971-*-***-**** - F:+971*-***-****)

Mobile: +201********

Email: *******@********.***.**

Dr. Adel El Alem

CIO at Al_Baraka Bank, Egypt. (From 2014 to 2020)

Mobile: +201*********

Contact this candidate