Database Analyst Programmer Resume
4.00/5 (Submit Your Rating)
Fort Lee, VA
SUMMARY:
- Information technology professional with over 15 years of experience.
- More than 15 years of experience supporting financial systems on an Oracle Database.
- Performed analysis and translated business needs to create high - quality business requirements and functional specifications documentation.
- Experience in full circle application programming, testing, implementation and support.
- Experience database designing and tuning process.
- Proficient working with relational databases.
- Oracle backend programming experience writing stored procedures, functions, packages and triggers.
Confidential, Fort Lee, VA
Database Analyst Programmer
Responsibilities:- Heavily involved in development of financial systems in PowerBuilder.
- Performed maintenance and enhancements for applications utilizing PowerBuilder.
- Created scripts using SQL, PL/SQL and Unix shell scripts for transferring data.
- Created tables, views, indexes, triggers, Oracle stored procedures, functions, packages, PL/SQL scripts using Oracle 10g.
- Communicated with users in order to collect requests for improving data quality.
- Created technical and user’s documentation.
- Created and made enhancements to Unix scripts.
- Heavily involved in migrating PowerBuilder systems to Oracle Forms.
- Made enhancements, created new forms and modules for existing projects using Oracle Forms.
- Created scripts to automate sending encrypted reports to users in email.
- Maintained and modified C++ programs to parse text files and populate database tables.
- Performed tuning of PL/SQL scripts and SQL statements optimization for large database.
- Created triggers, database procedures and functions utilizing PL/SQL.
- Created reports using SQL*Plus.
- Performed unit testing for financial applications.
- Provide third level support to financial systems using Oracle Forms, PowerBuilder, Unix, Java, SQL, C++, PL/SQL, Oracle RDBMS, Windows, Microsoft Excel, Microsoft Access, and Microsoft Word on a Remedy ticketing system.
Confidential, Fort Lee, VA
Associate Member of Technical Staff
Responsibilities:- Made enhancements, created new forms and modules for existing projects using Visual Basic.
- Travelled to client sites worldwide to assist with software and hardware upgrades.
- Created and maintained documentation for various types of software installations.
- Provided technical assistance and desktop support for end users.