SUMMARY

• Seeking a position where me can use my skills to halp teh company achieve their overall goals. me have over 7 years’ experience on Z/os Mainframes using JCL, TSO/ISPF, SPUFI, QMX, and various other mainframe tools.
• Security Clearance: Previously held a Public Trust Security Clearance

TECHNICAL SKILLS:

• Confidential 3090/ Confidential 3270
• DB2 Version 9,10, IMSDatabase AnalysisCOBOL (me & II)
• SQL
• Teradata
• JCL
• Visual Basic
• EASYTRIEVE Plus
• Micro Focus Cobol
• CA - RC Secure, RC Migrate
• BMC-Catalog Manager
• Confidential Catalog Tools
• Confidential Guardiam Encryption
• Job Scan
• FTP
• File Aid
• RACF
• IN Sync
• VSAM
• CHANGE MAN
• SYNCSORT
• Compare X
• Pan Valet
• Expeditor
• Flat Files
• CA7
• TCP/IP
• TSO/ISPF/SDSF
• Project Management
• Agile
• VISIO
• Lotus Notes
• Confidential 3270
• OS/MVS
• Windows NT/XP
• System Analysis
• Flowchart
• Modular Planning Development
• Test Script
• UAT Test Plans
• Manual/Automated Testing
• Medical/Clinical Billing Records
• Skills Cont’d:
• Functional Testing
• Integration Testing
• Unemployment Insurance
• Accounts Receivable & Payable

PROFESSIONAL EXPERIENCE

DB2 DBA Admin

Confidential Moline, IL

Responsibilities:

• Created and maintain DB2 tables for client.
• Use BMC DB2 Utilities to perform Run stats, Image copies, do Reorgs ect.
• BMC Catalog Manager to create Foreign, Primary keys and Indexes.
• BMC Change manager to plan and deploy migrations from Development to QA, Certification and finally Production.
• Experienced in zOS mainframe environment. Currently use application tool File Aid to browse DB2 Tables in teh effort of building SQL queries.
• Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases
• Use BMC Apptune to tune SQL queries that have performance issues.
• Use z/OS DB2 Native Mainframe daily to perform DB2 DBA functions (Display database).
• Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Created and reviewed SQL queries in TOAD.
• Load Plus and Recovery Plus for Db2.
• Reorg Plus, UnLoad Plus and Copy Plus for Db2.
• Teh BMC Suite of Utilities for DB2 10 & 11.
• Performed DBA security functions using Computer Associates RC/Secure tools.

Confidential

DB2 DBA Admin

Responsibilities:

• Monitor Databases for reliability and performance.
• Use Confidential ’s DB2 Utilities to perform Image copies, Reorgs, Display teh claimers to a Database.
• Use Confidential 's SPUFI and QMF to write SQL queries.
• Perform Image Copies, Recovery, REORG, and RUNSTATS.
• Experienced in z/OS mainframe environment using JCL and SQL including DDL, DML, and DCL.
• Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases
• Use Omegamon to review teh health of teh Databases.
• Use Content Manager to design databases and its objects.
• Use Confidential 's Guardium Encryption software to encrypt DB2 Databases so Hackers cannot access Mainframe files.
• Perform Backup and Recovery using SQL to recover Databases.
• Experienced wif physical and logical data modeling, database normalization and de-normalization, etc.

Confidential St. Louis, MO

DB2 DBA

Responsibilities:

• Research, design, develop, and/or modify enterprise-wide systems and/or applications software.
• Performed Data Analytics on Confidential mail to determine teh effectiveness of direct mailings to teh clients.
• This was a position of Public Trust wif Sensitive Information.
• Create Tables/Database Schemas in z/OS Mainframe environment wif DB2 using both SPUFI and BMC's Catalog Manager.
• Create Tables/Database Schemas in a LUW environment on a Windows system then moved developed product to Mainframe zOS Sandbox site for further testing before deployment to Production system.
• Be involved in teh planning of system and development deployment as well as responsible for meeting software compliance standards.
• Develop and maintain database schemas to include normalization and de-normalization
• Monitor Databases for reliability and performance
• Used DML to Insert and Update data into Test region so Java & Spring Developers can test their updates to Confidential webpages.
• Wrote JCL to run NATRAS system when updates are need.
• Use Confidential ’s DB2 Connect to write SQL queries to perform critical Legal requests from Washington D.C
• Created VIEWs and TABLES in test region using BMC Catalog Manager

Confidential, Columbia, MO

DB2/IMS DBA

Responsibilities:

• Updated and maintained DB2 tables for multiple clients. Experienced in zOS mainframe environment using JCL and SQL including DDL, DML, and DCL. Performed Image Copies, Recovery, REORG, RUNSTATS, Load, Bind, Explain, SPUFI, and QMF in support of DB2 Databases. Used DB2 to create, alter and drop tables.
• Created and updated JCL so jobs can be tested before they go into production. Use Zos Mainframe daily to perform DB2 DBA functions.
• Performed Data Analytics on DB2/IMS Databases to keep track of percentage used for storage requests.
• Issued Grants and Revokes of users and Table as part of my Computer Security role using DCL in QMF.
• Wif IMS used Mainview/Omegamon for running IMS PSB Gens.
• Run reorgs and Pointer checkers on IMS Databases. Performed Database Security for main client Caterpillar to grant access for users/jobs to Tables, Views and Lids. On-call for 3 clients wif their own unique systems.
• Received Letter of commendation from Caterpillar praising my work as a DBA.
• Used z/OS 2.0 Mainframe Operating System. Trained in LEAN methodologies thru Confidential classes
• Use Maximo tool to update, create and close my tickets. Updated Excel spreadsheets for my Manager.
• Trained offshore Database Administrators in teh maintenance of Tables, Table Spaces, Views, and Indexes.
• Received a rating of 2+ on my PBC's (Personal Business Commitment).
• Trained co-workers on performing DBA security functions using Computer Associates RC/Secure tools.
• Was On-call 4 week rotation for three years wif multiple clients,. Including one client who required response wifin 15 min of being paged.
• Performed unit testing and QA testing on programs written by myself and other associates. Developed and executed system test plans for teh purpose of performing full system integration. Tested on-line mainframe screens for correct functionality
• Reviewed code wrote by fellow consultants. Used VPN soft token to remote into client's system.
• Developed code for Unemployment agency.
• Trained in LEAN methodologies thru Toyota classes. Learned Japanese style of Management principals.
• Installed parts on a Vehicle while on a moving conveyor belt.

Confidential, Jefferson City, MO

Programmer Analyst

Responsibilities:

• Developed programs using COBOL and DB2(SQL) languages to enhance and trouble-shoot production systems.
• Performed Quality Assurance Tests on Mainframe programs and JCL before they were given to users for signoff.
• Performed Data Analytics on Unemployment Benefits for state of MO.
• Knowledge of CICS 3.0 used in programming tasks.
• Created and updated VSAM files for various projects. Created JCL to run tests on my JCL and other co-workers.
• As a consultant, me conducted research for local and out-of-state companies that have older outdated computer systems and presented recommendations to them.
• Used Microsoft “Expressions” in teh development of web pages. Helped design Web-pages for Non-profit organization.
• Created Micro Focus Cobol application programs wif Visual Studio to train colege students.

Confidential, Jefferson City, MO

Programmer, Analyst

Responsibilities:

• Performed unit testing and QA testing on program written by myself and other RKV associates.
• Updated and wrote new programs for State of Missouri's Unemployment agency.
• Developed and executed system test plans for teh purpose of performing full system integration.
• Did monitoring of system utilization, trending and performed efficiency testing.
• Up-loaded data from flat files to web based Unix Sun system for comparison of teh Legacy system. Transferred business requirements from documentation to written technical specifications.
• Developed JCL so jobs can be tested before they go into production.
• Wrote business rules to list reason codes for unemployment denials to be loaded in database. Tested CICS screens to insure programs written by RKV staff will function properly. Used tools like IN Snyc and File-Aid for data validation.
• Utilized software tools like TSO/ISPF to access JCL and files and ISPF to print out reports and completed programs.
• Researched Legacy code to understand business rules to be used in programming

Confidential, Columbia, MO

Information Systems Specialist

Responsibilities:

• Made updates to SQL code to improve Legal Database.
• Performed maintenance to files on a system that used teh Linux operating system.
• Tested SQL queries before they were encoded into teh database. Performed research when need for different departments upon request. Interacted wif customers while trying to request payments to be made for client.
• Dispatched work to new employees in teh Mail system.
• Transferred data from legal document into Q-LAW legal Database.

Confidential, Duluth, MN

Project Coordination Lead

Responsibilities:

• Coordinated multiple projects involving system integration testing of health care systems for Health Insurance clients
• Experienced in creating and executing system integration, and UAT test plan
• Managed teh testing of medical records on a client server mid-range system before implementation changes requested by teh client were made.
• Developed/tested CICS screens using Micro Focus COBOL workbench. Tested COBOL programs using Expeditor’s Code Coverage and proofed 80% to 100% of program code
• Attended classes on HIPP privacy laws and their impact on business.
• Worked closely wif clients to identify business needs and teh costs and benefits of implementing a computing system.
• Devised and documented general system designs based on teh client's anticipated requirements.
• Experienced in installing, troubleshooting, operating, testing, planning and configuring relevant technologies. Wrote COBOL programs from business guidelines.
• Developed extensive reports for HIP and performed final review of many projects before they were placed into production.

Confidential, Evansville, IN

Programmer Analyst

Responsibilities:

• Developed programs using COBOL, DB2, and EASYTRIEVE languages to enhance and trouble-shoot production systems. Performed Quality Assurance Tests on Mainframe programs and JCL before they were given to users for signoff.
• Implemented QA Test case studies to compare two different program versions.
• Did regression testing on Mainframe systems before they were put into production.
• Used 3270 terminal to input all of my programs.
• Integral part of a team that increased revenue ($8 mil) to teh company through acquisitions.
• Made updates to both teh account receivable and payable systems. Created and updated VSAM files for various projects. Lead team member for creating and sending special data to branches. Contributed too many new development projects, wif (SDLC).
• Updated and maintained DB2 tables in order to closely monitor and close unprofitable branches. Updated Excel spreadsheets when me closed down a branches’ AS400 (Unix) midrange system. Trained offshore programmers in teh development of portfolio acquisitions and majority of my work.