SUMMARY:

• Senior - level Information Technologies Professional with over 35 years experience in mainframe development and application testing as well as UNIX Scripting and Python development.
• I also have extensive experience with Solutions Development Life Cycle (SDLC) as well as Agile project management methodologies, 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.
• 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.
• Wrote programs according to specifications. Enhanced, developed and maintained applications, both online and batch, using PL/1, 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.
• Tested applications, both online and batch, using such tools as Expediter, File-AID, IBM File Manager, and IBM DB Manager, QMF, Rational Clearquest, and InterTest. Have done manual testing using test and use case scenarios, ad hoc testing, positive and negative testing and regression testing.
• 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.

SKILLS SUMMARY:

UNIX and VI-editor, JOE

RPG

PL/I

CICS (batch and Online)

IBM Mainframe, UNIX

DB2

SQL

Python

Hierarchical & Relational Databases

COBOL390/370, II

Intertest, Expeditor, Abend-Aid

SharePoint, JIRA

TSO, PUTTY for UNIX

File Manager and DB Manager

Windows/NT, Windows/XP, Windows 7, Windows 10

Endeavor

Rational Test Tools

VSAM File Management

MVS JCL

Query Management Facilities for SQL

Platinum Database Manager for SQL

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Technical/Analyst

Environment: Mainframe IMS

Tools: JIRA, COBOL, IMS, MVS JCL, Endever, Insight

Responsibilities:

• Provided maintenance and update support for Confidential and Loan System applications.
• Worked on FRB History Expansion Project.
• This project involved research and changes to Loan Systems applications to allow for extension of the Confidential History record.
• These programs updated and inserted history segments in Loans Databases.

Confidential, Omaha, NE

Programmer/Analyst

Environment: UNIX Ksh

Tools: Citrix, JIRA, Python, Unix Scripting, Visual Studio, COBOL, Oracle DB

Responsibilities:

• Installed, updated and documented applications to the Output Mailing System for Confidential .
• Updated python, Cobol and Unix Scripts. Using tools such as JIRA job tracker and documenter, JOE and Vi editors for Unix, PUTTY session manager, and Citrix for database access. Confidential uses Agile to manage their projects.
• Added field changes to Customer, Item, and Billing tables.

Confidential, Omaha, NE

Applications Analyst

Environment: IBM Mainframe, z/OS, CICS, DB2, COBOL, SQL, MQSERIES, TSO

Tools: Intertest, Platinum Data Base Manager, Spufi, Endeavor, File Manager

Responsibilities:

• Installed and applied application updates to COBOL and CICS programs, used to store data for the Electronic Federal Tax Payment System.
• Converted text data stored on DB2 tables to an encrypted format to protect data being transmitted to and from the I.R.S.
• Inserted calls to Hewlett Packard Voltage Software facilitating data encryption.
• Generated WEB sockets in CICS programs to aid in the encryption of data being passed to and from the Internet users accessing the EFTPS tax payment process.
• United tested programming changes using batch and online tools such as Intertest, Spufi and Platinum Database Manager. Documented test plans using Word.
• Documented updates using Sharepoint and Visio Flow Charting.

Confidential, Baltimore, MD

Senior Systems Programmer

Environment: DB2 IBM Mainframe, CICS, IDMS, WebSphere and Sun Solaris, UNIX, z/OS

Tools: Intertest, QMF, Vi-Editor, Endeavor Change Management

Responsibilities:

• Responsible for the testing and 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, Milwaukee, WI

Programmer/Analyst

Environment: UNIX, IBM Mainframe, DB2, Oracle, COBOL, UNIX Scripting, PL/SQL

Tools: Query Management Facility, Abend-aid, Expediter

Responsibilities:

• Prepare design documents supporting the UNIX and Mainframe processes for Confidential ’s 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 designs provide a step by step document of applications changes, updates to transaction, Item and Store tables, COBOL programs, and Unix Scripts.

Confidential, Milwaukee, WI

Database Analysis

Environment: UNIX, EXCEL 2007, MS SQL Server

Tools: QMF, File Manager

Responsibilities:

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

Confidential, Milwaukee, WI

Programmer/Analyst

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

Tools: TSO, QMF, Vi-Editor, PVCS Version Control

Responsibilities:

• 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, Milwaukee, WI

Programmer/Analyst

Environment: Windows XP, PLI, DB2, SQL,TSO

Tools: Changeman File and Database Management, Word, Excel, SAS, SPUFI, MVS JCL

Responsibilities:

• 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, Milwaukee, WI

Systems/Analyst

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

Tools: QMF, File Manager, IBM Debug, SPUFI, TSO, SharePoint

Responsibilities:

• 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, Milwaukee, WI

Programmer/Analyst

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

Tools: Rational Test Manager, Rational Clear Quest, TSO, File Aid

Responsibilities:

• 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, DB2 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, Milwaukee, WI

Systems/Analyst

Environment: Windows XP, AS400 (iSeries), RPG/LE

Tools: AS400 Development System, SQL, Word, Visio, Excel

Responsibilities:

• 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 Visio to flowchart application processes and SharePoint to track and document our work.

Confidential, Milwaukee, WI

Programmer/Analyst

Environment: Windows XP, Mainframe, PLI, TSO

Tools: Changeman, IBM File and Database Management, Excel

Responsibilities:

• Provided maintenance support for Benefits and Title applications. This involved maintenance 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, Burlington WI

Programmer/Analyst

Environment: Windows XP/Novell/Cerner

Tools: Zenworks, ConsoleOne, Citrix, Rapid Application Transfer

Responsibilities:

• 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.