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,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

Confidential,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

MConfidential, 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
Prior work history available upon request.

Education

Bachelor of Arts, Economics / Information Technology