Summary

Systems/Programmer Analyst with extensive multi-industry background including Life and Health Insurance, Pharmacy, Banking, manufacturing and retail. Skilled in system design, specification development, Disaster recovery, user interface, application programming, system testing, analysis, troubleshooting, full life cycle methodology and conversions.

TECHNICAL KNOWLEDGE

CICS, COBOL, Assembler BAL , VSAM, DB2, SQL, JCL Utilities, CA7, Z/OS, Easytrieve, File-aid, Sync Sort, DFSORT, NDM, Connect Direct, FTP, DOS/VS, TSO/ISPF, Endevor, Librarian, Panvalet, Dyl280, DMS/2200, IPF, , Word, Excel, Visio, PC/SPF, INTERTEST, OS/MVS

PROFESSIONAL SKILLS

• Analyst Skills
• Created User, Functional and Program Specification
• Data Mapping
• Worked with Users to gather requirements
• Worked with in Full life Cycle Software Methodology
• Created System, Data and Program Flow Charts
• Created User Training Documentation
• Created Testing scenarios for system testing
• Designed Databases, CICS Screens
• Designed interfaces between Systems
• Analyzed programs For Flow of Data and optimization
• Programming Skills
• Wrote programs using industry standard file layouts such as NACHA and EDI
• Wrote programs for Front end processing of PEP Vendor Packages
• Created files to be sent to other systems or companies via FTP, NDM or Connect
• Wrote and Maintained both Batch and CICS programs
• Wrote and maintained Programs using, DB2, Embedded SQL, Variable and Fixed length records
• Installed new releases of Vendor Packages
• Researched Assembler Routines When Problems arose to explain how code was functioning.
• Was involved with several conversions, VSAM to DB2, Tandem Platform to AS400
• Interfaced with the user or operations group solving problems
• Created JCL
• Followed project from start to finish. Designing, estimating, coding, testing and installing software.
• Helped to solve day-to-day production problems

VENDOR PACKAGES

CheckFree PEP ACH Banking Sunrise Disaster Recovery LlFCOMM Insurance HOGAN Banking PAS Systematics Banking COPICS Manufacturing GMIS Insurance

WORK HISTORY

Technical Consultant / Mainframe Analyst

• Created Data mapping documents for a Mortgage conversion
• Reasearched Functionality of processes within the Mortgage system and wrote technical/functional specifications
• Made appropriate changes to programs and copybooks.

Confidential

Technical Consultant / Mainframe Programmer - Served on the Risk Management Process Technology team

• Wrote a Program to take files From RBC bank and Format the files into a common file layout so the data from RBC Bank could be incorporated into the Risk Management databases.
• Researched runtime of Jobs to be able to determine an SLA for the groups the files were going to
• Updated Flow charts, Researched files that were coming into the Risk Management process from other groups, Changed JCL for a new file coming into the process and unit tested the Proc This assignment is at PNC Bank

Confidential

Technical Consultant / Mainframe Programmer - Served on a team responsible for the Wire Processes in the Bank,

• Updated programs to pass new file layout to G/L.
• Verified SQL queries, insured that data selected from Oracle databases were the format and columns needed for Mainframe processing
• Researched oracle database for fields needed for mainframe processing
• Wrote programs for Batch wire process, program parsed semi- free format data to determine status of file.
• Worked on creating EDI 997 and 824 formatted files This assignment was at M T Bank

Confidential

Sr. Programmer Analyst / Mainframe

• Worked on a team that was responsible for the EPIC Drug Program
• Wrote programs to extract information to be sent via FTP to New York State Tax and Finance
• Received a file which was then interrogated and letter produced if warranted .
• Created technical and user specifications for Tax Match process
• Made changes to both batch and online programs, System tested, implemented
• Designed a new CICS screen along with databases from requirements from User
• Researched FTP jobs when migrating to new platform

Confidential

Programmer / UNISYS Mainframe

• Worked on a team that was responsible for the Child Support System.
• Made changes to both batch and online programs
• Wrote programs to fix fields on the database.
• Wrote a program to extract data to send via FTP to another agency.

Confidential

Home Business

• Created Website Of Pet Products
• Marketed the website and other online businesses

Confidential

Sr. Programmer Analyst /Mainframe

• Worked on a team that was responsible for the ACH PEP processes that entered the Bank. Duties included installing new versions of software, provided 24/7 support, creating transmission JCL, Interfacing with other applications.
• Was responsible for writing and designing the Billing modules for both ACH and wire software.
• Wrote programs to create file to interface between IBM and TANDEM for wire transfer
• Responsible for maintaining the PEP vendor package written in COBOL, VSAM, DB2, CICS
• Wrote and Maintained front end and Backend Programs using COBOL, VSAM, CICS, DB2
• Researched Assembler Routines When Problems arose to explain how code was functioning.
• Was involved with several conversions, VSAM to DB2, Tandem Platform to AS400
• Wrote embedded SQL statements for program conversion from VSAM to DB2, Also wrote Queries to verify fields in new DB2 tables
• Interfaced with the user or operations group solving problems
• Designed Databases, and solutions to Billing issues
• Created CICS Screens for the Operations Group to use for different functions of their Job
• Created JCL for clients sending information to the bank via, NDM, FTP or Mailbox
• Followed project from start to finish. Designing, estimating, coding, testing and installing software

Confidential

Technical Consultant/ Mainframe Programmer

• Served on a team responsible for preparing the company for Disaster Recovery. The team used a vender package written by Sunrise.
• Evaluated run streams
• Recommended where backups should be taken for disaster recovery purposes.
• This position required evaluating Data and creating JCL This assignment was at METLIFE

Technical Consultant / Mainframe Programmer

• Served on a team responsible for maintaining claim information for an insurance company. Worked on a team installing the GMIS vendor package. This assignment was at Blue Shield of Northeastern New York
• Wrote I/O modules and Data Manipulation routine to be used by team
• Wrote CICS data display / update screen.

Technical Consultant / Mainframe Programmer 3

• Served on a team responsible for maintaining the deposit application for a major banking institution. The team used the DSM Deposits System Manager vendor package. Confidential
• Helped to solve day-to-day production problems.

Confidential

Sr. Programmer Analyst

• Provided technical and user specifications, testing scenarios, project leadership on individual assignments, coding, testing and turnover. On team that coded and maintained Hogan Deposit and Time Deposit Applications.
• Installed and modified money wire system that interfaced between Tandem and IBM machines...
• Assisted in merger of three banks
• Streamlined report run times working on analysis of accounts, assuring production of needed reports