System Analyst/Programmer Resume OK, USA - Hire IT People

SUMMARY

10 years using Oracle SQL, PL/SQL, SQL Plus, 3 years in Toad, Oracle Discoverer Admin/Plus, 2 years using Oracle Developer 2000 (Forms 6, Reports 6), 10years Crystal Reports 5, 1 year VB

TECHNICAL SKILLS

Programming Languages: PL/SQL, VB

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

Tools: SQL*Plus, Toad, Oracle Forms 6.0, Reports 6.0/10g, Oracle Dicoverer 11 Admin, Discoverer Plus 11, Visual Basic/Access, WinSCP, MobaXterm, VSS, Serena.

PROFESSIONAL EXPERIENCE

System Analyst/Programmer

Confidential, OK, USA

Responsibilities:

Analyze root cause of report issues and apply FAA rules/standards in making corrections/solutions to issues.
Was member of Oracle Applications 11i to R12 (Federal Finanacials) Upgrade project till successful completion.
Oracle Apps R12 production support for Web Reports and Discoverer including views, functions and packages.
Unit testing SQL, PL/SQL scripts used in views packages, functions, & procedures for integration wif Oracle Apps.
Debugging of SQL and PL/SQL scripts (following standards) for correction, tuning, and performance improvement.
Unit testing of web reports and discoverer workbooks/worksheets.
Analysis of discoverer reports to isolate teh discrepancies of data between UAT and production for solution to issues.
Retrofitting of web reports and Discoverer workbooks/worksheets.
Technical Documentation of web reports and discoverer folders/workbooks.

Sr. Programmer

Confidential

Responsibilities:

Created Database objects (tables, views, synonyms, roles), database triggers, stored functions/procedures
Lifecycle development of HR and Payroll system, Budget system and Transport monitoring system from requirements gathering, design, coding, testing, implementation and production support.
Was teh project lead in teh budget system.
Performed Unit tests and trained teh users.
Did production support for all developed systems in teh government ministry.
Assisted in designing teh databases (Oracle 7.3.4/8i/9i)
Assisted in making analysis and design for projects.
Design and Prepare called - on reports not included in teh system

Used: Oracle Developer 2000 Forms/Reports, PL/SQL, Oracle SQL*Plus, Oracle Power Objects 2.1Crystal Reports Writer

Confidential

Responsibilities:

Life cycle development/production support of “HR 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.

Bank Staff

Confidential

Responsibilities:

Life Cycle Development of “ Certified Deposit System” (using dBase III+) for teh branch and trained users. Financial/Banking Related:
Managed manual (GL, AP, AR, Sub Ledgers, and Reconciliations between Sub ledgers and GL).
Prepared monthly and quarterly Financial Statements and Reports.
Took cash requesitions (in millions) from teh Cash Distribution Center for branch use.
Processed and encoded checks for computerized clearing.
Delivered special clearing checks to teh Central Bank.
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.

We provide IT Staff Augmentation Services!

System Analyst/programmer Resume

Ok, UsA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship