Summary

Senior-level Information Technologies Professional with expertise in Mainframe, Client Server, and UNIX scripting. I have over 30 years experience in mainframe development. I also have extensive experience with Solutions Development Life Cycle SDLC project management methodologies including systems analysis and systems design. I have knowledge and practical work experience with a diverse array of industries including health care, retail, insurance, government, transportation, and Law Enforcement.

Specialties

• Keywords: Mainframe, COBOL, PL/I, CICS, MVS JCL, DB2, SharePoint, VSAM, Development, Analysis, Testing, IBM Mainframe, IMS, TSO, SQL, UNIX Korn Shell, Table- Base, SAS, Oracle Databases, PL/SQL, and UNIX Scripting.
• Analysis - Provided technical and functional specifications for both batch and online mainframe and client server applications. Held technical and functional reviews to ensure accuracy of specifications. Oversaw program development and unit testing. Followed up with customers after implementation to address concerns or problems.
• Development - Wrote programs according to specifications. Enhanced, developed and maintained applications, both online and batch, using PL/1, SAS, COBOL, RPG, CICS, IMS, DB2, Oracle databases, UNIX Scripting and SQL Server. Supported systems by taking on-call responsibility. My years of experience in I.T. have provided me with a strong background working with both hierarchical and relational databases as well as Tables, Views and Schemas.
• Testing - Tested applications, both online and batch, using such tools as Expediter, File-AID, IBM File Manager, and IBM DB Manager, QMF, Rational Clearquest and Rational Test Manager. Have done manual testing using test and use case scenarios, ad hoc testing, positive and negative testing and regression testing.
• System Upgrades and Implementations - Provided application development and analytical support for system conversions and applications upgrades including CICS to SQL, and AS400 ISERIES RPG conversion to SQL. I have also written functional requirements for data conversions and created DB2 database extracts as part of the

Conversion process

I n d u s t r i e s

• Government
• Healthcare
• Health Insurance
• Law Enforcement
• Life Insurance
• Transportation
• Retail
• Finance

A r e a s o f E x p e r t i s e

• Analysis/Design
• Applications Development
• Maintenance
• Testing
• Implementation/Conversions

E x p e r i e n c e a n d S k i l l s

• UNIX
• SAS
• PL/I
• CICS batch and Online
• IBM Mainframe
• IMS batch and online
• Oracle DataBase Access
• DB2
• SQL
• Hierarchical Databases
• Relational Databases
• COBOL390/370,II
• File Manager/DB Manager
• Windows/NT,Windows/XP, Windows 7
• Lotus Notes
• Serena Changeman Version Management
• Microsoft Outlook, Word, Excel,Visio
• Rational Clearquest, Rational Test Manager
• VSAM File Management
• MVS JCL
• Query Management Facilities for SQL
• SPUFI for SQL
• VI-editor for UNIX
• Websphere
• Sun Solaris

C h r o n o l o g y o f E x p e r i e n c e

Confidential

Position: Senior Systems Programmer Public Trust Security Clearance

Environment: DB2 IBM Mainframe, CICS, IDMS, WebSphere and Sun Solaris, Unix z/OS Responsible for the migration of SSA application code to support the backend legacy system as well as the front-end Java code for the SSA intranet and Internet applications. Responsible for administration of the UNIX file system and WebSphere internals. Perform DB2 binds and implement CICS and IDMS changes on the z/OS mainframe operating system. Implement JAVA application code on the Sun Solaris z/OS UNIX servers. Shell scripting used to load code as an executable.

Confidential

Position: Mainframe/Unix Designer and Developer

Environment: Unix, IBM Mainframe, DB2, Oracle, Cobol, Unix Scripting,

• Query Management Facility, PL/SQL, Windows, Client Server
• Prepare design documents supporting the UNIX and Mainframe processes for Kohls update to MPX-Inforem Merchandising project.
• These designs include documentation of the existing Merchandising System, including processing flows, database layouts and associations, batch and online processes. The dinesigns provide a step by step document of applications changes, updates to transaction, Item and Store tables, Cobol programs, and Unix Scripts.

Confidential

Position: Database Analysis

Environment Unix, SAS 9.1, EXCEL 2007, MS SQL Server

Prepare statistical analysis as wells ad-hoc reports in support of foreclosure processing. Use SQL queries and SAS 9.1 to access data. Provide reports using EXCEL Pivate tables, graphs, comparisons, trends functions.

Confidential

Position: Programmer/Analyst

Environment: Windows XP, Mainframe, PLI, DB2, SQL, UNIX,

• Tools: PVCS Version Control, File and Database Management, SAS, Unix Scripting, Vi-editor
• Completed an assignment in the Mutual Funds Accounting department, which
• consisted of writing Unix Scripts to generate messages of successful or non-successful completion of daily Funds Reports.
• Also assisted with a Financial Applications project to add new sub-companies and disbursement codes for the NIMCO Project, changing DB2 tables, flowcharting and writing of Unix scripts, and SAS applications supporting both batch and online. Assisted with research, analysis, documentation, and financial applications updates.

Confidential

Position: Programmer/Analyst

Environment: Windows XP, PLI, DB2, SQLTSO

• Tools: Changeman,File and Database Management, Word,
• Excel, SAS, SPUFI, MVS JCL
• Worked in Annuities Department on Phase I of the Income Solutions Project. This involved coding of PL/I DB2 and SQL applications, both batch and online. Used Changeman to manage checkout and movement of source code, compiling, and promoting of source. Wrote report programs using SAS.
• Responsible for making table changes, PL/I application updates, and unit testing.

Confidential

Position: Systems/Analyst

Environment: Windows XP, COBOL/390, DB2, SQL, CICS, Oracle,

• Tools: QMF, File Manager, IBM Debug, SPUFI, TSO, SharePoint
• Performed program updates for the E-Fulfillment/E-Commerce project.
• Developed new CICS screens to facilitate access to new databases.
• Performed Unit Testing on updated and newly developed applications, using SharePoint for all documentation. Used MQseries to access transaction queues. Used IBM Debug, File Manager to problem solve and debug applications. Used QMF Quality Management Facility and SPUFI to manipulate and access database data. Updated, MVS JCL, and procs to test batch code.

Confidential Position: Programmer/Analyst Compuware assignment

Environment: Windows XP, IBM DB2, CICS, COBOL/390, SQL Server

• Tools: Rational Test Manager, Rational Clear Quest, TSO, FileAid
• Worked as a Quality Assurance Analyst on Assurant's ACES Claims Discount Update project. Wrote test case requirements using Rational Test Manager. Tracked testing problems using Rational Clear Quest. Used QMF to query databases, tables. Built test claims in the ACES Claims System using Data Capture and EDI processes. Mentored testers that were not educated in mainframe processes. Responsible for teaching the fundamentals of VSAM, DB2, JCL, and SQL.

Confidential Position: Programmer/Analyst Compuware assignment

Environment: MVS, IMS/DB2, COBOL II, VSAM, Windows/XP, SQL

• Tools: TSO, Endeavor, Xpediter, QMF, File-AID, Abend-AID
• Wrote applications for the claims and premiums systems using Cobol and IMS. These programs were used to retrieve back generations of claims and premium files, create new VSAM files, and eliminate any duplicate claims. This allowed the customer to make one run instead of multiple runs to bring Claims files current.
• Wrote programs to extract data from IMS GRASS databases and populate newly created DB2 tables. These applications were written using COBOL II, IMS. QMF was used to query our populated tables and File-AID was used to view our data input files. The environment was mainframe with Windows XP. Endeavor was used to move applications from development to production libraries.

Confidential

Position: Systems/Analyst Compuware assignment

Environment: Windows XP, AS400 ISeries , RPG/LE

• Tools: AS400 Development System, SQL, Word, Visio, Excel
• Wrote requirements defining RPG/AS400 processes for SQL developers who were in the process of converting AS400/ RPG to SQL. Used Word and Excel to document processes.
• Defined table layouts, field parsing and size, input sources, output files, reports generated and dispositions of reports. Worked closely with developers to answer questions or concerns that came up. Used AS400 utilities to view files and databases. Used Visio to flowchart application processes and SharePoint to track and document our work.

Confidential

Position: Programmer/Analyst Compuware assignment

Environment: Windows XP, Mainframe, PLI

• Tools: TSO, Changeman, IBM File and Database Management, Excel
• Provided maintenance support for Benefits and Title applications. This involvedmaintenance of PL/I, DB2, and SQL applications batch and online . Responsible for writing project estimates. Was also involved in problem solving of incident tickets. Used Changeman to manage checkout and movement of source code,compiling, and promoting of source from staging to production. Participated in peer reviews for fellow team members.

Confidential

Position: Programmer/Analyst Compuware assignment

Environment: Windows XP/Novell/Cerner

• Tools: Zenworks, ConsoleOne, Citrix, Rapid Application Transfer
• Installed new desktop pc's throughout the hospital as well as in several clinics and ancillaries throughout the hospital. Copied existing desktop applications and software to the new pc's using Novell's Zenworks and 'Rapid Application Transfer'.
• Updated inventory databases with new software and hardware information.
• Wiped data from the old pc's that were removed from inventory.
• Tested Desktop applications by ensuring that each application opened properly.

Confidential

Position: Programmer/Analyst Compuware assignment

Environment: Windows XP, COBOL/390, N-Tier

• Tools: QMF, File Manager, IBM Database Manager, SQL
• Performed maintenance on Kohl' s Associate Discount and Store Value processes that were to be updated in preparation for Kohl's upcoming 'Next Gen' software upgrade. This involved coding program changes using DB2, COBOL, updating and accessing Oracle data bases with SQL.
• Parsed data files for input to new newly developed applications.
• Used QMF and SPUFI utility to query and update tables and databases.
• Wrote extracts and reports, using DB2, for Kohl's 'Transfer System', which involved pricing, store inventory and item transfer between stores. N-Tier platform process was used for connection between Mainframe and final end user applications. Endeavor used to move source to production libraries.

Confidential

Position: Programmer/Tester Compuware assignment

Environment: Windows XP

• Tools: CadQuest, MediaMaster, Microsoft Word, Microsoft Excel
• Performed ad hoc testing on CadQuest software applications to include standard, professional, and do-it-yourself decks, garages, and pole buildings.In addition to building these decks, garages, and pole buildings responsible for tracking problems encountered during design using Excel and Word.

Confidential

Position: Mainframe Programmer/Analyst

Environment: MVS, COBOL 390, CICS, VSAM, Windows/XP

• Tools: TSO, Xpediter, Endeavor, Avaya Change Management
• Created extracts, using Cobol DB2 for the new 'TrustDesk' package. Created screens and updated existing screens for clients using CICS. Active in developing CICS online transaction support programs.
• Used Xpediter for program debugging tool. Used Endeavor to move programs through development and testing libraries. Avaya change management was used to move production status. INSYNC was the tool used for file display and editing.

Confidential

Position: Systems Analyst

Environment: Windows/XP, CICS, COBOL/370, MVS, VSAM, DB2

• Tools: TSO, QMF, Microsoft Word, Microsoft Excel
• Technical Management Inc. was an outsourcing company for life and health insurance companies from across the United States.
• Developed and maintained applications for HIPAA mandates for health insurance applications. This involved coding changes using CICS COBOL, building files and converting applications to DB2 format. These files were transferred to WebMD to be queried by providers and insurance companies.
• Updated life insurance applications to meet federal and state mandated changes using both DB2 and CICS/batch/online.

Confidential

Position: Programmer/Analyst Analyst International assignment

Environment: COBOL/370, IMS, DB2, MVS, Windows/98

• Tools: TSO, Visio, QMF
• Provided analysis and documentation for the installation of a new Records Management System for the Omaha Police Department. This facilitated the migration toward independence from the Douglas County mainframe, which was an IMS database system. The new system was a DB2, SQL accessed system.
• Diagrammed the IMS database layout and the new Records Management System using Visio. Wrote file extracts and interface programs to support the transfer of new files data to the Omaha Police Departments databases.

Confidential Programmer/Analyst Analyst International assignment

Environment: CICS, MVS, Windows NT, Cobo/370

• Tools: Microsoft Word, Microsoft Excel, Visio
• Assisted in writing a study and proposals for an electronic accident reporting system for the Nebraska Department of Roads.
• Interviewed law enforcement agencies statewide to document each agency's method of submitting accident reports to the state. Incorporated suggestions for improvement to the Accident Reporting System that would ease the process of accident reporting.
• Recommended ways the state could go to a paperless environment.
• Met with the Department of Roads from other states that already had a paperless systems.

Confidential

Position: Programmer/Analyst Analyst International assignment

Environment: MVS, IMS, COBOL/370, DB2, Windows/NT, SQL, Oracle

• Tools: TSO, ProEdit, Abend-Aid, File-Aid, Word, Excel
• Developed, maintained, updated, and enhanced applications to improve the Supply Support process using IMS batch and online, as well as DB2. Wrote
• Extracts to access and build tables from Oracle databases.
• Performed on-call duties to correct issues affecting the night cycle, including updates, DB backups, and printed reports for the Sales Ordering, Fuel, and Supply Systems.
• Developed screen defaults to the Supply Warehouse Information System to expedite purchase order processing using DB2/SQL.
• Panvelet was used to move applications from development to production libraries.ProEdit was used to query and edit DB2 tables.

Confidential

Position: Web Developer Analyst International in-house

Environment: Client Server

• Tools: HTML, Microsoft Word, Notepad, FrontPage, SmartDraw
• Converted the 'Omaha Corporate Cup Run History Overview' to HTML format to allow access to history through the Internet.

Confidential

Position: Programmer/Analyst

Environment: MVS, IMS, COBOL/370, CICS, VSAM, Windows/95

• Tools: Roscoe, TSO, Smartest, APS Screen Painter, Easytrieve
• Analyzed, designed, coded, tested, and implemented updates and enhancements to the BCBS Claims Payment and Administration System and the Federal Employee Program using IMS batch and online, as well as several CICS applications.
• Participated in the implementation of a Provider-Select process in the Claims Inventory area that would allow quick reference of claims data. This allowed the user to access provider information by entering a partial last name or Tax ID Number.
• Used Easytrieve to develop reports for claims and accounting staff.
• MVS/JCL was the job control language.

Confidential

Position: Programmer/Analyst

Environment: MVS, CICS, COBOL, VSAM, ADS

• Tools: TSO, Abend-Aid, File-Aid, Microsoft Project
• Analyzed, designed, coded, tested, and implemented hospital software, including inventory, medical records, pharmacy, and nurse order entry systems. These applications included both CICS online and batch as well as ADS software applications.
• Served as the technical lead for the installation of a major upgrade to the hospital's patient care and pharmacy order entry change system.
• Supported patient billing, admission and discharge systems.
• Worked directly with physicians and nursing staff before, during and after implementation of new systems.