SUMMARY QUALIFICATIONS

• Over 20 years professional experience in Global Information Technology in Banking sector, Confidential
• Excellent experience in AS/400 languages (RPG(LE),CLP,SQLRPG(LE)), tools (SQL,DFU,RLU,SDA…), OS/400 and DB/400
• Excellent experience in Project management
• Excellent experience in Oracle (Database, OWB, Discoverer)
• Confident and skilled at organizing the start-up phase and during the life time of the project
• Maximize the team\'s effectiveness by monitoring the progress, workflow and communications
• Minimize problems by full analysis of the business requirements
• Team member in IT hiring committee

EXPERIENCE

AS/400 Analyst/Designer & Developer 1990-Present

• Analyzed requirements for Credit facilities department and other departments
• Developed, tested & implemented software for credit facilities applications to maintain, inquiry, print reports & perform Cyclesusing AS/400 languages & tools
• 20+ years experience with AS/400 languages RPG(LE), CLP, SQLRPG(LE) & tools as SQL, DFU, SDA, RLU…etc
• Maintained existing software by making modifications as required
• Identified and communicated technical problems, processes and solutions
• Prepared reports, manuals and other documentation on the status
• Provided input to Team Leader on existing technologies for approval.
• Provided time line estimates to Project Managers for development tasks.
• Followed industry standard application development techniques & practices
• Followed industry standard testing practices for unit, integration & stress testing
• Provided input for new ideas in applications development
• Provided appropriate training both technical & user

PROJECTS:
I- Studying business requirements, analyzing, developing and testing programs on AS/400 using RPG(LE), SQLRPG(LE), CL(LE) languages (applying SDLC cycle). Preparing documentation, user manuals and implementing the following systems:

• Credit Facilities Reports System:
• Collect data from all operational systems in the bank which is Equation (Overdraft & Deposits), Eximbills (Letter for Credit, Letter for Guarantees, Bills for Collections) and Loans System.
• Inquiry on screens & reports.
• Data entry screens for non-available data.
• Loans System: Analyze, Develop, Test, Train, Implement for Entry/Maintenance screens, Inquiry screens & reports.

Loans system deal with different types of commissions (issue, renew, amend, reschedule…) & interests (monthly & delay where both calculated on daily basis, monthly depend on daily balance while delay interest calculated upon highest balance during the month)
Its cover all types of loans corporate loans (term / revolving) & retail loans (auto, personal, housing).
Maintenance screens contains many screens for entry, update & delete loans and related installments (disbursement) schedule, withdrawals, collaterals in addition to inquiry about any of the previous items.
Inquiry screens and reports related to loans matured (will be matured during), installments delayed, loans granted for specific customer, overdrawn loans…
Security system: define the authority for the users to work on the system.

• Management Information System : Data Entry, Inquiry on screens and Print reports for the following modules:
• Potential Credit Clients
• Black Listed Customers
• Current Credit Clients
• Legal department follow-ups
• Electronic Clearing Cheques System (ECCS): develop integration programs between Core Banking System (Equation) on AS/400 and Oracle ECCS to send messages and get reply for the messages from and to the core banking system using TCP/IP which apply transactions online (Credit/Debit) on customer accounts directly.
• Trade Finance Amortization System: calculating the accrued commissions for each month from each LC & LG and posting transactions on core system to move these figures from assets into income accounts.
• Oracle GL: work with team to map core system tables into Oracle GL system to produce segmented Balance Sheet for the bank.

II- Build MIS Oracle database using OWB tool to contain all data for the bank from all areas into one database, build complex reports, manage users have access to inquiry about data, administration database, train users and provide support for the users to use reporting tool as BRIO to build their ad-hoc reports.
III- Test, setup, train users and implement Profitability system which is module from Equation System on AS/400 that calculate the profit of the customer, branch, segment (business line), bank and the banks’ products.
IV- Working on BRIO with the following roles and responsibilities:

• Created OCEs for the various data Sources (AS/400, Oracle, Access,…).
• Responsible for analyzing business requirements and developing queries and reports.
• Worked closely with Business Analyst, discussed and gathered the functional requirements from different user groups.
• Designed and developed various types of Reports (Pivot, Tabular, Chart Reports).
• Extensively worked on developing complex reports according to the user requirements, standardizing the report format according to the user for different division in the business.
• Developed and Customized Dash Boards to accomplish launching various Reports.
• Extensively used BRIO suite of products for reporting.
• Exported the reports to web, Excel,..
• Tested the reports before moving in to production database.

SKILLS

• Excellent in dealing with OS/400 & Windows.
• Excellent in Oracle, DB/400 & SQL databases
• Experience in MS-Office tools, OWB, Discoverer, MS-Project & BRIO
• Able to multi-task under pressure
• Self motivated
• Excellent communication skills (written & oral)
• AS/400 training programs : Facilities, Operations, Relational Database Coding & Design, CL Programming, Security Concepts & Planning, RPG/400 Interactive Programming, Clients Access/400, DB2/400 Coding & Implementation, RPG/ILE Programming, SQL Programming Workshop, Developing i-Series Applications Using SQL
• Training programs in: Project Management Skills, Effective Project Management, MS Project, Time Management
• Oracle 9i training programs : Developer track, Discoverer & OWB

EDUCATION
Bachelor degree in Computer Science