Database Analyst resume

SUMMARY

A Database Analyst with expertise in DB2. Known for helping people solve their technical problems. Effective communicator able to explain complex technical concepts in simple language.

TECHNICAL TOOLS:DB2 UDB for OS/390, IMS, Windows, Cobol, JCL, CLISTs, REXX, TOOLS Endevor, Xpediter, Syncsort, Platinum Database Tools, TSO, SPF, QMF, SPUFI, BMC Database

EXPERIENCE

Confidential,
Database Analyst 2005 - current

Provide database maintenance and support for the development and production of DB2 and IMS environments. Design, implement and reorganize databases. Provide 24x7 off-hour coverage support for all mainframe DBMSs installed.

DB2 stored procedures, identity columns, sequence IDs, triggers, partitioning, LOBS

Confidential,
Database Analyst 2004 - 2005

Provided database maintenance and support for the development and production of DB2 environments. Design, implement and reorganize databases. Provide 24x7 off-hour coverage support for all mainframe DBMSs installed.

Confidential,
Technical Analyst 2003 - 2004

Maintained and tested application programs for agency billing system. Provide 24x7 off-hour coverage support for application department.

Senior Technology Specialist 1998 2002

Provided database maintenance and support for the development and production of DB2 and IMS environments. Designed, implemented and reorganized databases. Provided 24x7 off-hour coverage support for all supported DBMSs installed, which included SQL Server.

Acted as ‘Help Desk’ analyst responding to a wide variety of programmer questions and provided technical solutions that enabled programmers to complete tasks.
Tested the new version of IMS prior to implementation ensuring functionality and data integrity
Created and documented standards and guidelines for programming applications presented in both printed and HTML formats that were easily accessible to all peers and provided cost efficient document maintenance. These standards and guidelines saved time and money by increasing programmer efficiency and reduced demand for service desk assistance.

Senior Information Specialist 1993 1998
Provided general technical support for application department of 80 programmers.

Acted as focal point and coordinator of conversion and production moves that enabled programmers to have one point of contact that was knowledgeable of changes. This function enhanced the smooth implementation of conversions and moves and reduced interruption of services.
Wrote and maintained dialogs using REXX and CLISTs, enabling consistent compiling of program changes and making end users jobs easier.
Participated in the implementation of Microfocus Workbench that gave the applications developers a more sophisticated testing tool. Conducted initial testing of the product and created dialogs that allowed uploads and downloads between PCs and mainframes.
Enhanced and maintained application purge and archive jobs that increased data integrity and made batch and online processing run more efficiently.
Data steward for data security rules that resulted in fewer rules and easier to understand.

Information Systems Specialist 1984 1993
Maintained and tested application programs for a purchased program package. Provided 24x7 off-hour coverage support for application department.

Received the Chairman’s Award for consistently providing quick and accurate service on a wide range of projects, including providing quote information on a $2 million policy which was subsequently booked.

EDUCATION: Associate Degree in Computer Programming

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship