Ahmed Shehab REQUEST RESUME

Programer/Analyst ((RPG, RPGLE, COBOL, CLP)

AVAILABLE   |   Permanent   |   Contract   |   Remote Only   |   Recruiters OK   |   EGY   |   Posted on Jun 28, 2017

I am AS400 programmer(RPG, RPGLE, SQLRPGLE, COBOL, CLP). I  have 21 years experience in RPG, RPGLE, SQLRPGLE, CLP, COBOL, and MYSIS – Equation. I am working in a leading bank in Egypt.

I write programs over AS400 using (RPG, RPGLE, SQLRPGLE, CLP, COBOL) for new application, and other programs which integrated with MYSIS – Equation.

Yours, Ahmed Shehab.
Mobile: +201004129157
E_mail: ah_shehab4@hotmail.com


My Specialties

RPG, RPGLE, SQLRPGLE, COBOL, CLP, C, C++

MYSIS – Equation

DB2/400, Query400, SDA, RLU, SQL, …, etc.

 

Ahmed Mohamed Khalil Shehab El-Deen

Email: ah_shehab4@hotmail.com

Address: Egypt, Cairo, Nasr city, Abas El_akaad st., 7 B, first May buildings.
Telephone (Egypt): +201004129157, +201006492617  or +2048 3661340

Telephone (Saudi Arabia): +966 562786527

 

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.

 

WORK EXPERIENCE

 

  • Software Development Manager & AS400 Consultant, Al_Baraka Bank, Egypt, from 23/6/2013 till now. 

 

  • Responsibilities:

 

Managerial Tasks

  • 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.
  • 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 Senior Management should any issues or problems arise on project.
  • I lead AS/400 team in technical tasks.

 

AS400 Programming Tasks

  • Write programs over AS400 using (RPG, RPGLE, CLP, COBOL) for new application, and new reports which integrated with MYSIS – Equation.
  • Bulid database and write programs over AS400 using (RPG, RPGLE, CLP, COBOL)  to do integration between MYSIS – Equation and SAS FATCA.
  • Using AS400 tools such as Query400, SDA, RLU, SQL, …, etc.
  • I am working in a technical project in core banking (MYSIS – Equation) over AS400.

 

I write many programs in Al_Baraka such as:

 

Sample of my developed Applications integrated with Equation Core Banking:

  • Integration with SAS FATCA.
  • Save boxes application.
  • Customers stock application.
  • Central archiving application.
  • Card application.
  • SMS application.
  • Many other applications.

 

Sample of developed Reports over MISYS Equation Core Banking:

  • Statement of account (Arabic and English).
  • Balance confirmation (Arabic and English).
  • Users transactions.
  • Users authorizations details.
  • Observation over limit transactions.
  • Account Tax Reports.
  • Risk rating.
  • Compliance reports.
  • Many other reports.

 

 

  • Project Manager, eraTech (IBM Advanced Business Partner), Egypt, from 1/5/2011 till 22/6/2013. 
    • Responsibilities:
  • 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.)

 

 

 

  • Project Manager, eSmartSoft (IBM Advanced Business Partner), Egypt, from 1/1/2010 to 30/4/2011. 
    • Responsibilites:
  • The same as above in eraTech.

 

  • AS/400 Team Leader (Administrator/Analyst/Programmer), Jeraisy Computer & Communication Service (JCCS) in Saudi Arabia, From 1/12/2005 to 1/12/2009. 
    • Responsibilities:
  • Worked as AS/400 Team Leader (Administrator/Analyst/Programmer) in a project in JCCS part of Eastern Province Municipality project.
  • 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.

 

  • AS/400 Team Leader (Administrator/Analyst/Programmer), Saudi Business Machines  (SBM), Saudi Arabia, From 29/10/2002 till 30/11/2005. 
    • Responsibilities:
  • Worked as AS/400 Administrator/Analyst/Programmer. My job description is the same with JCCS as written above.

 

  • Programmer/Analyst, General Authority for Education Buildings (GAEB) (ISO 9001), from 16/11/1998 to 15/10/2002.
    • Responsibilities:
  • Make analysis and write programs on AS/400 platform using RPG, RPGLE, COBOL, and CLP.
  • 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).

 

  • AS/400 Instructor, IBM education center,   Egypt, from 1/10/2000 to 22/10/2002.
    • Responsibilities:
  • 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.
    •       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 Saudi Business Machinery (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
  • Develop applications on AS/400 platform using RPG, RPGLE, 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.
  • Good experience in AS/400 operations and administration. I can make controlling for (jobs, devices, communications, storage, security, FTP, backup … etc.).

 

 

  • ORACLE
  • Good experience in Oracle database.
  • Experience in SQL, PLSQL, and Oracle Developer (Form builder & Report builder).

 

 

  • Other Skills:
  • VB, C/C++, HTML, Java Script UNIX(AIX), 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

         

PERSONAL INFORMATION:

  • Nationality: Egyptian.
  • Date of Birth: 15/09/1974
  • Place of Birth: Egypt, El-Menoufia, Menouf city.
  • Languages: Arabic, and English.

 

REFRENCES:

 

Motaz Yaish, PMP
Delivery Manager
Network Solutions & Services (NSS) Department
Saudi Business Machines, Ltd. (SBM)
GENERAL MARKETING & SERVICES REPRESENTATIVE OF IBM WTC
Phone : 966-3-849 5000 Ext. 5151
Direct  : 966-3-849 5151
Fax      : 966-3-882 9898
E-mail : myaish@sbm.com.sa

Mobile: 966-504946352
 

Maha Nassar

Doctorate of Business Administration

Jupiter 2000 CEO (IBM Business Partner)

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

5 Makrem Ebaid St, Nasr City,Cairo, Egypt.
Tel : (+202) 22756020 - 22741484
Fax : (+202) 22756020

Mobile: 00201223112394

 

Mostafa Abd El_Rahman

Managing Director

IT Valley (IBM Business Partner)

http://www.itvalley.com.eg/

Address :6 Boles Hana St., AbdelAziz Hegazi Managerial Tower, Front of Korea Culutre Center, Dokki,
Giza, Egypt.

Tel & Fax : (+202) 374 866 93 - (+202) 333 706 12 - (+202) 333 785 57.

Mobile: +20127999759

Email: mostafa@itvalley.com.eg

 

DEVELOPED APPLICATION in IBM, Saudi Arabia

 

  • 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 (ISO-9001) 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 Oracle Developer).
    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.