Programmer/Analyst Resume

SUMMARY:

10 years using Oracle SQL, PL/SQL, 2 years using Oracle Developer 2000 (Forms 6, Reports 6)
10years Crystal Reports 5, 1 year Visual Basic

PROFESSIONAL SKILLS:

Programming Languages: PL/SQL, VB

Databases: Oracle7.3.4/8i/9i, MS Access

Tools: Developer 2000 Forms 6.0, Reports 6.0, PL/SQL, SQL*Plus, Visual Basic/Access

Crystal Reports 5.0:

Platforms: Client/Server - Windows 98/NT/XP/Vista

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/Analyst

Platform: Client-Server (Windows 95/98/2000/XP)

Responsibilities:

Was member in a team of three who developed and maintain the finished projects: ministry payroll system, personnel system, vehicles monitoring system, and archive system, SSS system (for the retirement unit). The aim of which is to familiarize all officers and soldiers with the use of PCs and get abreast with present technology and upgrade the office procedures specially payroll, where at the click of a button the salaries for thousands of employees are calculated in a matter of minutes.
And at the click of another button separate diskettes for each bank are being prepared and delivered to the banks for crediting salaries of the entire personnel .In the Personnel system, the big guys can view and print statistics of all personnel with the use of our developed Dynamic Query. By clicking checkboxes, they can select which columns to display, which columns to use for sort order, and which columns to use for selection criteria.
Created Database objects, database triggers, stored functions/procedures Coded the main modules of all the systems.
Performed Unit tests and trained the users.
Maintains all developed systems in the ministry. Assisted in designing the databases (Oracle 7.3.4/8i/9i) Assisted in making analysis and design for projects. Design and Prepare called-on reports not included in the system Used: Oracle Developer 2000 Forms/Reports, PL/SQL, Oracle SQL*Plus, Oracle Power Objects 2.1Crystal Reports Writer, Windows 95/98/NT/XP.

Confidential

Inhouse-Programmer

Responsibilities:

Developed/maintained Personnel and payroll system, Inventory System, Product Delivery System
Designed and coded all systems Managed computerized inventory
Managed computerized payroll Prepared production forecast, raw materials budget, and stock analysis.

Confidential

Bank Staff (Acting Accountant, Check Processor, Bookkeeper)

Responsibilities:

Developed Certified Deposit System using dBase III+ for the branch and trained users.
Managed manual (GL, AP, AR, Reconciliations between Subsidiary ledgers and GL). Prepared monthly and quarterly Financial Statements and Reports.
Took cash requesitions (in millions) from the Cash Distribution Center for branch use.
Processed and encoded checks for computerized clearing. Delivered special clearing checks to the Confidential .
Consolidated and balanced tellers' transactions and inter-office transactions.
Balanced daily transactions per documents and per computer. Interviewed loan applicants, processed loan documents, managed loan ledgers, prepared loan budgets.
Prepared monthly, quarterly and annual loan reports. Prepared yearly loan budgets and comparative statements between budget and performance.