Ahmed Mohamed Khalil Shehab El-Deen

Email: ad0z88@r.postjobfree.com

Address: Egypt, Cairo, Nasr city, Al_Waha, City Tours Compound, Al_Sawsan 1, floor 5, flat 20.

Telephone (Egypt): +201*********, +201*********

EDUCATION

Bachelor of Science, Pure Math and Computer Science, Faculty of Science, El-Menoufia University, Egypt.

General Grade: Good.

Graduation Project: TSR programs.

Graduation Project Grade: Excellent.

I can work in Development, Database, Core Banking, Application, Reporting, and Digital Transformation.

WORK EXPERIENCE

Software Development Manager (AS400 & Oracle), Al_Baraka Bank, Egypt, from 23/6/2013 till now.

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.

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.

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.

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) and over ORACLE using (SQL, PLSQL).

Sample of my developed Applications integrated with Core Banking:

Save boxes application.

Customers stock goods application.

Central archiving application.

Credit Card application.

SMS application.

Acids Depreciation Application.

Financial inclusion with Egyptian Central Bank.

Integration with SAS FATCA (Interface (ETL) with other system).

Integration with AML, and goAML (Interface (ETL) with other system).

Risk rating for CBE.

SMEs for CBE

I-SCORE

Many other applications.

Sample of developed Reports over Core Banking:

Statement of account (Arabic and English).

Balance confirmation (Arabic and English).

Credit Portfolio.

Loan tax for every quarter.

Delayed loans details.

Audit users create/authorize transactions

Review posting details.

Observation over limit transactions.

Compliance reports.

Many other reports.

Project Manager, eSmartSoft (IBM Advanced Business Partner), Egypt, from 29/4/2009 to 22/6/2013.

oResponsibilities:

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) in Saudi Arabia, From 1/12/2005 to 28/4/2009.

oResponsibilities:

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.

AS/400 Team Leader (Administrator/Analyst/Programmer), IBM, Saudi Arabia, From 29/10/2002 till 30/11/2005.

oResponsibilities:

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), from 16/11/1998 to 28/10/2002.

oResponsibilities:

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

Computer Teacher, Ministry of Education, from 5/4/1998 to 15/11/1998.

Part Time Jobs:

AS/400 Instructor, IBM education center, Egypt, from 1/10/2000 to 22/10/2002.

oResponsibilities:

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), from 1/ 5/2001 to 15/10/2002.

o Responsibilities:

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.

TECHNICAL SKILLS

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.

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.

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.

Other Skills:

Project management.

Very good experience in Oracle database. Experience in SQL and PLSQL. I can write procedures, function, packages and triggers using PLSQL over Oracle database

Unix(AIX) operation and administration.

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

ANALYSIS & DESIGN SKILLS

Experience in data model and process model.

Experience in steps of analysis and design steps (determine the problem, collect data, determine tools,…, etc.).

Design database and use diagrams such as (ERD, FDD… etc).

Design of screens and reports.

Application integration.

ADDITIONAL SKILLS

Good experience in providing training.

Excellent knowledge of database RDBMS.

I have experience in windows networking, TCP/IP and FTP.

I have knowlage in IBM WebSphere commerce suite, and Java.

Excellent comunication skills especially in conducting presentations and seminars.

I have managerial skills. I can work as IT coordinator.

Able to work under stress and able to travel.

TRANNING 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, 10 / 2022

PERSONAL INFORMATION:

Nationality: Egyptian.

Date of Birth: 15/09/1974

Place of Birth: Egypt, El-Menoufia, Menouf city.

Languages: Arabic, and English.

REFRENCES:

Dr. Maha Nassar

Doctorate of Business Administration

Jupiter 2000 CEO (IBM Business Partner)

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

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

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: ad0z88@r.postjobfree.com

Dr. Adel El Alem

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

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

APPLICATION IN IBM & Jeraisy PROJECTS in KSA

Title: Payment in Bank System (Sadad). (Using RPG & RPGLE for AS/400).

Description: 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.

Title: Financial System. (Using COBOL for AS/400).

Description: 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.

Title: Realty investment. (Using RPG & RPGLE for AS/400).

Description: 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.

Title: Shop licenses. (Using COBOL for AS/400).

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

Title: Health testimony. (Using RPG & RPGLE for AS/400).

Description: 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.

Title: Advertisement plans contracts. (Using COBOL for AS/400).

Description: 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.

Title: Health Observation. (Using RPG & RPGLE for AS/400).

Description: 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.

Title: Shops contract System. (Using RPG & RPGLE for AS/400).

Description: 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.

DEVELOPED PROJECTS IN GAEB in Egypt

Title: Mailing Application. (Using RPG and RPGLE For AS/400).

Description: 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”.

Title: Architectural Application. (Using COBOL and RPGLE for AS/400).

Description: 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.

Title: Database of civil Application works. (Using COBOL and RPGLE for AS/400).

Description: 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.

Title: Estimate the bill of quantities for building. (Using RPG and RPGLE for AS/400).

Description: 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.

Title: Estimate electricity plans. . (Using RPG & RPGLE for AS/400).

Description: 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.

Title: Planning of education in the next years. (Using RPG and RPGLE for AS/400).

Description: 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.

Title: Store Application. (Using RPG and RPGLE for AS/400).

Description: 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.

Title: Education Buildings Application. (Using RPG and RPGLE for AS/400).

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

Contact this candidate