PROFESSIONAL SUMMARY:

Excellent experience as a Lead Mainframe Programmer/ Analyst with extensive COBOL/CICS/JCL/VSAM & DB2 Mainframe experience, and 10 yea rs Data Quality Analyst/Data Analyst experience. 5 years’ experience performing automated testing, as well as 15 years of manual testing to ensure data quality. 7 years’ experience verifying test data, executing test scripts, and verifying results. 10 years of experience leading test planning, and ensuring testing covers all integration points. 20 years of communicating documentation, planning, and reporting to stakeholders. 16 years of SQL experience . Ability to ensure that the data quality monitoring of SHR and confidential data is handled according to laws, regulations, and company guidelines . Complacent with JCL, TSO, and EzyTrieve and has proficient experience with CA7 scheduling and File Aid . Experience working in a UNIX environment and has solid experience with Endeavor. Superior organizational and multi - tasking skills . Ability to work independently with minimal supervision, as well as in a tea m environment . Preformed extensive programming, analysis, merging, monitoring, and testing of softwa re for big organizations to perform a variety of general tasks .

TECHNICAL EXPERIENCE:

C++, COBOL, COBOL II, COBOLII, BASIC, Assembler, FORTRAN, PL/1, RPGII, EASYTRIEVE

PLUS, SAS EXP, JCL (Job Control Language, ERWIN Modeling, Micro Focus, COBOL, Visual Basic, Visual Basic NET, ASPNET, HTML, JAVA, XML, Servlets, TOMCAT, JSP, UML

MVS, VM, DOS/VS, MCP, NOS, SCOPE, AUTOFLOW, All utilities for S/34, PANVALET, IDCAMS, LIBRARIAN, ROSCOE, TSO/SPF, EASYTRIEVE-PLUS, CA-DRIVER, OWLE, DYNAM/D, DYNAM/T, CMS, ICCF, MSA, AMAPS, CULLINET, MCCORMICK & DODGE, SAS

Software, QUICKJOB, INTERTEST, Change Man, DEBUGGING/IMS Database, CA7 SCHEDULER, CONTROL-M, SCHEDULER, SMARTEST, DUN/ BRADSTREET Payroll Package, XPEDITIOR, 082-XPERT, PLATIUM (DB 2), DB2-UTILITIES, File-AID, VIA SOFT, TOTAL IMS DB/DC, Dll, 082,IDSI, IDSII, TELON, IDMS, ADS/0, CICS, (COMMAND and MACRO), Oracle, VSAM, ISAM, SUPRA, MANTIS

MIDAS, SQL, MS Project, Visio, Compaq PC Pentium SOOMHZ Station, MultiMate, WordPerfect, LOTUS 1-2-3, POWERMENU, Norton Utilities, XTREE, Microsoft ( Word, Excel, Access, Paradox, E-Mail, PowerPoint, SQL Server 70, SQL Server 2000, COM/DCOM, VISIO, FrontPage, Dreamweaver, ColdFusion

MS Windows 31, 95, 98, 2000, NT, UNIX, DOS 50 & 60, DOSCACHE, DESKCONNECT

05390 (MQ Series), IBM 434, 13081, 3033, 3090, 370/168,158,145

BURROUGHS 3500, CDC 6000, HONEYWELL, IBM S/32, IBM S/34, IBM 3/36, IBM - PS/2, PRIME 550, AS400 (COBOL and RPG IV), ECLIPSE

Project Management

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Mainframe Programmer/DB2 DBA/Database Developer/Project Manager

Responsibilities:

• Involved in the design and programming of IBM DATAPOWER package, monitors all traffic coming into WPS thru the internet
• Performed as acting DB2 DBA for many of the DB2 changes
• Updated HIPPA into system from the updated information from the government. Also changed programs to confirm with the HIPPA rules. helped design the operation of the package and the design of the DB2 tables to store the information; wrote all report programs
• Used MS Project and Visio for project management.
• Fixed production batch and online CICS programs using MQSERIES for importing and exporting data to the queues
• Created 40 Easytrieve programs to produce many reports and merging of database information.
• Performed maintenance on AS400 systems using System Entry Utility (SEU), Screen Design Aid (SDA), Progra mmer Development Manager (PDM) and Data File Utility (DFU); used programs RPG/400, COBOL/400 and SQL/400

Technologies: 05390 (MQ SERIES), VSAM, CICS, DB2, ISPF, ENTERPRISE COBOL, ACUCOBOLL COBOL, DOLLAR UNIVERSE, AS400 UTILITIES, JAVA,MQ SERIES, CA7 SCHEDULER, FTP, CHANGEMAN, SDSF, DB2 Utilities, INTERTEST (ONLINE and BATCH DEBUGGER), MS Access, Word, Excel, Project Management

Confidential, Minneapolis, Ml

Mainframe Architect P/ A/ P M

Responsibilities:

• Updating new versions of Westla w System
• Responsible for the Westla w system which includes real time processing of transactions from users which access the Main Frame and E-commerce system; 30,000 users of this system which stores a variety of information regarding cases in the courts and related public information
• The systems consist of Tier 1Front end Presentation Layer written in ASPNET
• Wrote ASPNET functions for Westlaw
• Tier 2 The Business Logic Layer which uses JAVA J2EE, SPRING and AJAX
• Tier 3 the Database layer which are Oracle and DB2 databases
• Used MS Project for project management and tracking
• Used SQL Server Query Analyzer to create Databases and SQL Server Enterprise Manager to design new tables for the database
• Designed and coded new Web Site using XHTML, XML (XSO, XPATH, XQUER Y}, JavaScript, Script and links to internal placeholders and other web sites
• Used Easytrieve package to generate many reports.

Technologies: JAVA J2EE HIBER NATE, AJAX, MSSQL, 115, JAVASCRIPT, CRYSTAL ASPNET, REPORTS, ENTERPRISE COBOL, VSAM, MQSERIES, DB2/AIX UDB, PLATIUM, DB2/AIX UTILITIES TSO/ISPF, XHTML, XML, FTP, DEBUGGER, FILE MANAGER, FAULT ANALZER, ZOS OPERATING SYSTEM

Confidential, Iowa City, IA

Mainframe PIA/ Project Lead

Responsibilities:

• Updated new versions of Student Loan System; responsible for analysis and design of DB2 stored procedures for Student Loan System using Neon software package
• Wrote and tested 10 progra ms using batch DB2/AIX (using SQL) and VSAM
• Analyzed the CICS system and changed 12 programs for the Customer Service of Student Loan Processes
• Used MS Project for project management and tracking

Technologies: JAVA, MSSQL, COBOL, COBOLII, VSAM, DB2/AIX UDB, PLATIUM, SOFTECH, DB2/AIX UTILITIES TSO, CA7 SCHEDULER, FTP, DEBUGGER, FILE MANAGER, FAULT ANALZER, ISPF, 05390 (ZOS Operating System)

Confidential, Roanoke, VA

Programmer Analyst/ PM

Responsibilities:

• Merging of CONRAIL with NORFOLK SOUTHER N Systems; responsible for analysis and design to match Conrail pa rts with Norfolk parts in order to identify which are common to both systems and which need to be added to Norfolk system
• Wrote and tested 10 programs using batch IDMS, DB2, VSAM and Dynamic SQL
• Analyzed the CICS system which added new parts (Used X peditor to go through the code to figure out the routines and add the new part numbers) in order to write a new program to add unmatched Conrail parts inventory
• Web enabled 10 CICS programs and added JAVA front end for uses to add part numbers
• Perform analyses on Inventory system written in IDMS ADS/0 to determine the extent of the programs needed to be changed for the merger and also the new processes that needed to be added
• Changed 15 RPG programs
• Used Easytrieve to generate many reports of database detail.
• Used MS Project for project management and tracking

Technologies: JAVA (J2EE), ECLIPSE, UML XML, DOM, JDBC, MSSQL, TOMCAT, SERVETS, JSP, COBOL, COBOLII, VSAM, DB2, PLATIUM, SOFTECH, DB2 Utilities, IDMS, ADDS/0, VSAM, DYNAMIC SQL, TSO, CA7 SCHEDULER, FTP, DEBUGGER, FILE MANAGER, FAULT ANALZER, ISPF, 05390 (ZOS Operating System)

Confidential, Minneapolis, Ml

Consultant/ Project Lead

Responsibilities:

• Implementation of Treasury Reporting System; performed analysis and design for the new TreasuryReporting System which allowed bank customers to see their current cash balances to better manage their account
• Wrote 10 Stored Procedures programs to gather database data from the servers
• Changed 10 other programs in the system
• Fixed and tested changes and Implemented to Production
• System Used SQL 2005 for accessing data base for stored procedures
• Added 10 JAVA programs for front end processing using the COBOL stored procedures
• Used MS Project for tracking and reporting on projects
• Responsible for creation of online Insurance System.
• Used Easytrieve software to create many types of reports.

Technologies: JAVA {J2EE), ECLIPSE, UML XML, DOM, XPATH, XQUERY, JDBC, MSSQL, TOMCAT, SERVETS, JSP, COBOL, COBOLII, VSAM, 082, SQL2005, PLATIUM,SOFTECH, 082, Utilities, 082/AIX TSO, CA7 SCHEDULER, FTP, DEBUGGER, FILE MANAGER, FAULT ANALZER, ISPF, 05390 (ZOS OPER ATING SYSTEM)

Confidential, Minneapolis, Ml

Project Lead / Developer

Responsibilities:

• Implementation of Jewelry Price; changes and adding new items to the inventory
• Analyzed the price system to find what changes had to be made for next year's jewelry prices
• Wrote documentation and held meetings with users; changed 20 programs for price conversion in COBOL and using IDMS database and websites to add the new jewelry items
• Changed 10 programs for addition of new jewelry items in Batch and changed JCL, tested and implemented to production system
• Wrote 2 ADSO online programs using MAPC to create online maps and ADSC to generate dialogs in Support of the jewelry price change OLQ used to display database
• Analyzed batch and online programs for problems
• Fixed and tested changes and implemented to production system
• Used MS Project for project management responsibilities

Technologies: OMS, MAPC, ADSC, OLQ COBOL, COBOL/I, VSAM, TSO, CA7 SCHEDULER, FTP, DEBUGGER, File Manager, FAULT ANALZER, /SPF

Confidential, Minneapolis, Ml

Consultant/ Project Developer Lead

Responsibilities:

• Conversion of AMC ( Confidential owned company in New Jersey) to the Confidential Information Systems Group; conversion consisted of moving 1200 programs, COBOL, Assembler, Mantis programs plus database of IMS, DB2 and Supra to the Confidential System
• Worked with personnel to handle all of the application issues, handled testing the system after transfer
• Created two courses and created 3 huge documentation books to train the support people for Mantis and Supra Database
• Performed many Supra DBA functions to define system
• Wrote many conversion programs to transfer information from AMC to Confidential system
• Developed JCL and 2 programs to process EDI files in GENTRAN and then FTP files from Ta rget to AMC system
• Used MS Project for project monitoring and tracking

Technologies: CICS, 082, MANTIS, SUPRA, VSAM, TSO, CA7 SCHEDULER, FTP, DEBUGGER, File Manager, FAULT ANALZER, GENTRAN, Platinum, SOFTECH, 082 Utilities, ISPF (05390, ZOS Operating System)

Confidential, St Paul, Ml

Consultant/Lead Programmer

Responsibilities:

• Design of additional updates to the health care project for the State of Minnesota; analyzed the system to find any new additions which had to be communicated to other connecting systems
• Attended JAD sessions with the state of Minnesota personnel to clarify changes to the system; verified with users that the process was correct
• Created documentation on the new converted process
• Received approval and updated the client server screens with the new data needed to be captured, used JAVA, XML and JavaScript
• Analyzed CICS DB2 system to determine the changes necessary for conversion to the new Health Care System
• Added jobs to the batch system to create MQ Series inquiries in order to update other systems
• Worked with MS Project for managing and tracking projects

Technologies: MQ Series, JAVA (J2EE), JavaScript, XML, CICS, 082, SQL2005, VSAM, TSO, Batch Processing using JCL, CA7 Scheduler, FTP, DEBUGGER, File Manager, Fault Analyzer, ISPF (05390, ZOS Operating System)

Confidential, Kansas City, KS

Project Manager

Responsibilities:

• Merging Billing Systems added the newly acquired Roadway Freight Billing System and merged it with the Yellow Billing System
• System analysis and design (which included the creation of all documents related to the system design along with user participation) programmed and tested the modifications to the Freight Billing System for Mexico shipments
• The system consisted of multiple foreground sessions with CICS programs being started at time intervals in background tasks.
• Changed 15 CICS, batch (using Change man with Enterprise COBOL and COBOL II) and 5 Assembler programs
• Added 5 Net Express (formerly Micro Focus COBOL) and changed 15 interactive programs Used IDE to change and also test system

Technologies: CICS, VSAM, 082, INSTALL/1 PLATIUM, Assembler, COBOLII, Net Express (Micro Focus COBOL), CONTRL-M SCHEDULER, FTP, Change man for Program and JCL Control of Changes, XPEDITOR BATCH and ONLINE DEBUGGER, File Manager, Fault Analyzer, ISPF (05390, ZOS Operating System)

Confidential, Madison, WI

DB2 DBA/Project Manager/Developer

Responsibilities:

• Involved in the design and programming of many online (CICS) and batch 082/AIX database programs which updated and extracted data from the 835 and 837 HIPAA database; extracted data was used to interface with the present system
• Designed modification to the CAS (Claim Administration System) for claim processing
• Created "C" called programs for many of the calculations
• Performed as acting DB2 DBA for many of the DB2 changes
• Built JAVA screens using Web Sphere to interface with the CICS system Involved in the creation of EDI screens for capturing data; used FTP to transfer files between mainframe and client server systems
• The new HIPPA requirement was to pay the claim only when all problems have been resolved
• A claim usually consists of many pa rts (doctor, hospital, special treatment)
• Created Analysis and Design document which included changes to present system and new programs to be created
• Estimates of total hours to do the analysis, programming, testing and documentation; task list with scheduled completion dates
• Created test plans for unit regression testing and involve users with system testing
• JCL changes to current jobs
• Analysis of ramifications to other systems
• Converted Claim Payment System ( 25 programs) from Visual
• Basic 60 to Visual Basic NET and ASPNET using SQL Server database using XML, COM\DCOM, Visio, used MS Project and Visio for project management purposes

Technologies: 05390 (MQ SERIES), VSAM, CICS, 082, ISPF, COBOL II, COBOLIII, SAS, COBOL, JAVA, CA7 SCHEDULER, FTP, Web Sphere, VBNET, SQL Server database, CHANGEMAN, SDSF, 082/AIX Utilities, SQL 2005, INTERTEST (ONLINE and BATCH DEBUGGER) Erwin Modeling, Microsoft (Access, Word, Excel, Project Management), REPORTING using COG NOS

Confidential, Peoria, IL

Project Lead/ System Analyst

Responsibilities:

• Designed and programmed Order Entry and Accounts Receivable System using CICS as transaction manager and 082 database Created "C" programs for calculations
• Developed scope of project, system design, programming specifications and normalization of data
• Creation of functional unit test plans and involve the users with system regression test plans and the execution and documenting the results of the tests
• Created VSAM files to hold database
• Created base tables, primary key indexes and used va rious DB2 utilities to make database more efficient
• Wrote 25 CICS programs using SQL to select, insert, update and delete rows from DB2 database
• Created CICS maps using Basic Mapping
• Support macros DFHMSD and DFHMDI in Assemble language
• Maintenance to on line Mantis programs using Supra relational database and batch
• Converted order entry system {30 programs) from Visual
• Basic 60 to Visual Basic NET and ASPNET using SQL Server database using XML, COM\DCOM and Visio
• Performed modifications to PowerBuilder applications
• Updated DB2 database using SAS DATA, PROC, SQL Procedure and RUN commands
• Wrote 15 "C" sub programs which are called by COBOL for many calculations
• Added 4 and change 5 Micro Focus COBOL interactive programs

Technologies: 05390 {MQ Series), DEC, SUPRA, MANTIS, VSAM, CICS, DB2, SQL2005, ISPF, COBOL 11, COBOLIII, Micro Focus COBOL, SAS EXP, COBOL, INSTALL/1, C, CHANGEMAN, SDSF, CA7 SCHEDULER, FTP, DB2 Utilities, Lotus Notes, SMARTEST, PowerBuilder, Visual Basic 60, Visual Basic Net, SQL, Server Database, {ONLINE and BATCH DEBUGGER), Microsoft (Access, Word, Excel And Project Management),REPORTING using COGNOS

Confidential, Minneapolis, Ml

Project Lead/ Systems Analyst

Responsibilities:

• Designed and programmed online CICS DB2 system to allow customer service to change or answer questions about accounts
• Designed and programmed additional functionality to the Visa Authorization and Fraud system; processes over 800,000 transactions a week
• Used stored procedures to select and update customer and transaction tables it was more efficient to call a stored procedure rather than do all of the DB2 functions in a program because the access to the database in a stored procedure is done on the server
• Stored procedures allow you to access IMS, IDMS, Flat files and CICS Transactions Fixed problems on PCs using UNIX operating system Did the functions of the DB2 DBA for the system changes
• Designed and programmed a wire transfer system to allow customers to wire money to various clients
• Created all of the system documentation and programmed the system using CICS with DB2
• Performed maintenance to various check processing systems
• Created feasibility study to demonstrate the advantages of adding the new functionality to the system
• This was presented to upper management by use of visual aids {flip charts and slides)
• Detail design of project which included: Modeling of the database using Erwin package, changes to present system, new programs, estimation of total hours, create task lists, create test plans for unit regression testing and system integration testing, JCL changes to current jobs and the ramifications of the changes to other systems
• Detail design of project, presented to the users using visual aids (flip charts and slides)
• Obtained users' approval
• Wrote program specifications
• Wrote programs and changes to JCL
• Tested online and batch changes in unit testing
• User acceptance testing
• Put into production
• Post implementation review

Technologies: 05390 {MQ Series), CICS, DB2, VSAM, ISPF, ENDEVOR, XPEDITOR, FTP, COBOL, COBOL II, Assembler