AS/400 System Analyst/Designer & Developer ,consultant

AS/*** System Analyst/Designer & Developer ,consultant

******.**@*****.***

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

Contact this candidate