SUMMARY QUALIFICATIONS
20 years professional experience in Information Technology and Banking Sector
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-2008
Analyzed requirements for Credit facilities department and other departments
Developed, tested & implemented software for credit facilities applications to
maintain, inquiry, print reports & perform Cycles using AS/400 languages & tools
17+ 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:
1- 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.
2- 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
3- Electronic Clearing Cheques System(ECCS) : Integration programs between Core
system (Equation) on AS/400 and ECCS on Oracle to receive and send on-line
messages between both systems using TCP/IP which apply transactions on customers
accounts directly.
4- 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.
5- 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- Build BRIO queries on AS/400 balance sheet tables using ODBC to summarize
the details and the totals of the loans, deposits, LTD, interest income, interest
expense, NII, net revenue in the bank worldwide, segment, region, area and the
branch.
V- Build BRIO queries on Oracle tables to list high 20 customers in the Deposits
in the bank and in each area in local and foreign currencies, portfolio of each
customer in loans and deposits, summary of bank/area portfolio in loans and
deposits for borrower/non-borrower customers.
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
|
