Objective

Leverage new technology to enhance IT systems and applications resulting in increased productivity. In the process, pass on the knowledge of my years of experience to my colleges.

Skills Inventory

• Operating Systems – IBM Z/OS, IBM Z390, HP9000,HP3000, UNIX, MS Windows, IBM 390/MVS/VSE)
• Database – DB2 V7.1, Oracle, MS Access, Turbo/Image, DBMS
• Database Software – BMC, CA Insight
• Access Methods – SQL & QMF for DB2, IAM, VSAM, PL SQL/ORACLE
• Programming Languages – COBOL OS/VS & COBOL II, ProCOBOL, DB2 Application Design and Development, IBM & HP Job Control Language, IBM Utilities, DFDSS, IDCAMS, SYNCSORT, CICS Application Development, SAS, REXX, and CLIST, Oracle Application Development
• Programming Software – TSO, SPFPC, ISPF, FILE AID, OMEGAMAN, XPEDITER, MICRO FOCUS COBOL, ENDEVOR, PANVELET, QEDIT, TMON, Intertest, ACF2, Abend-Aid
• Email – MS Outlook, Internet, Lotus Notes
• Design Methodologies – Structured Analysis, Structured Design, Structured Programming,, DB2 Database Design, Application Development Life Cycle
• PC Software – DB2/UDB, MS Word/MS Office, MS Excel, XDB/DB2, Quattro Pro, Impromptu, Service Matrix, Lotus Notes

Work History

• Confidential- Charleston WV - 11/2003-10/2007

DB2 Database Administrator / DB2 Systems Programmer

• Participated in setting up the data center, and six DB2 subsystems
• Set up performance/tuning monitoring for DB2 using TMON, CA Insight, and BMC
• Responsibilities included 24 x 7 on call, problem ticket resolution for all DB2 issues
• Supported development teams on numerous new design and maintenance projects
• Reviewed database requests to determine system resource requirements
• Responsible for security, backup, recovery, modifications, and new DB2 databases
• Participated in an upgrade from IBM Z/390 to IBM Z/OS
• Installed and maintained database software including CA Insight and BMC
• Assumed additional responsibilities as space management and OPS. Specialist
• Automated pack backups and refresh processes, reduced the times from days to hours

Technologies – TMON, CA Insight, BMC, DB2 V7.1, IBM Z390, IBM Z/OS, SAS, REXX, CLIST, Job Control Language, IBM Utilities, MS Access, SQL & QMF, & COBOL II, TSO, SPF, FILE AID, DFDSS, IDCAMS, SYNCSORT, CICS, MS Word/MS Office, MS Excel, Lotus Notes, OPS commands

Confidential- Rochester NY - 05/2001-08/2002
Sr. Programmer Analyst

• Returned as a member of the Claims Processing support team
• Applied modifications, tested and implemented COBOL programs from problem reports
• Participated in several new development projects
• Maintained Oracle stored procedures and table updates

Technologies – HP9000, ProCOBOL, Oracle, Quattro Pro, Impromptu Quattro Pro, Impromptu, Oracle stored procedures, Job Control Language, MS Access, SQL , MS Word/MS Office, MS Excel

Confidential- Rochester NY - 07/2000-05/2001
Sr. Programmer Analyst

• Assumed lead production support for the Marketing team, working on problem reports
• Worked with customers and accurately resolved each request.
• Redesigned the Marketing application using the application development life cycle.
• Assisted the DBAs with the design and implementation of the new Marketing database.
• Monitored the new UNIX application environment and periodic project lead.

Technologies – IBM 390/MVS/VSE, Job Control Language, IBM Utilities, MS Access, SQL & QMF, COBOL II/CICS/DB2, TSO, SPFPC, FILE AID, IDCAMS, SYNCSORT, CICS, MS Word/MS Office, MS Excel, FILE AID, XPEDITER, ENDEVOR, UNIX

Preferred Care - Rochester NY - 10/1999-07/2000
Sr. Programmer Analyst

• Became a member of Accounts Receivable, and Enrollment, support team
• Quickly became a contributor, modifying, testing and implementing programs
• Accurately resolved each request resulting in high customer satisfaction
• Worked on a development project by designing new processes for the Enrollment application
• Worked with the DBA on several occasions to resolve database issues
• Maintained Oracle stored procedures and table updates

Technologies – HP3000, ProCOBOL, Oracle, Quattro Pro, Impromptu Quattro Pro, Impromptu, Oracle stored procedures, Job Control Language, MS Access, SQL , MS Word/MS Office, MS Excel
Marine Midland Bank - Buffalo, NY - 07/1982-07/1998
DB2 Database Administrator - 01/1992-07/1998

• Performance/tuning monitoring for DB2, security, backup and recovery
• Logical and physical analysis, space requirements, and referential integrity.
• Reviewed project requests to determine database requirements, time estimates, constraints, as well as data conversions and table loads
• Implement the first distributed applications using DB2/UDB
• Participated in the upgrade of DB2 from V5 to V6

Sr. Programmer Analyst - 07/1982-07/1998

• A senior member of several development and maintenance teams
• Used structured charts and data diagrams, and followed the app. development life cycle
• Credit Card, DDA, Mortgage, Customer Profitability, Consolidated Extract, Property Management, Product Profitability, and General Ledger.
• Assumed project lead on two small projects, carried out on time, and under budget

Technologies – IBM 390/MVS/VSE, Job Control Language, IBM Utilities, MS Access, SQL & QMF, COBOL II/CICS/DB2, TSO, SPFPC, Abend-Aid, IDCAMS, SYNCSORT, CICS, MS Word/MS Office, MS Excel, FILE AID, XPEDITER, ENDEVOR, MICRO FOCUS COBOL,XDB., SAS, DB2/UDB, OMEGAMAN, ACF2

Education

Bachelor of Arts, Economics / Information Technology – Confidential University