Senior Mainframe Programmer Analyst

Teresa M. Barton

PO Box ***, *** Chestnut Hill Road, Dayville, CT 06241

860-***-****

ke6uzr@r.postjobfree.com

Summary:

Have over 25 years experience working in all phases of systems and application development and as a member of production support teams for multiple systems. Performed user interfacing, analyzing, designing, developing, testing, implementing, and documenting functions. Worked on IBM, RS6000(UNIX) and SPERRY Mainframes. Strong technical expertise in structured COBOL/DB2, COBOL/CICS, OS/MVS/JCL, Sybase SQL and Stored Procedures, VSAM/IDCAMS, IDEAL/CICS/DB2 & DATACOM, PL/1, OS/MVS, HTML ver. 4, CSS, Javascript and additional experience with UNIX commands and Korn Scripts. Also have experience using tools and utilities Rumba, TSO/ISPF, Platinum DB2, SPUFI, Fileaid, FTP, RapidSQL, Endeavor, Xpeditor, Intertest, Smarttest, Panvalet, MS Word, MS Excel, VISIO, Adobe Dreamweaver and MS Frontpage. Currently own a Gateway FX530XV with Windows Vista Ultimate operating system. Extensive experience in the mutual fund pension system and in the insurance industry's billing and collection systems. Outstanding customer service skills, excellent communication skills and ability to work individually and in a team environment and with all levels of management in both Systems and Business.

Experience:

Principal Systems Services & January 2, 2001 to December 31, 2008

Support Analyst

Fidelity Investments Marlborough, MA

 Assigned as primary Senior Programmer Analyst to Fidelity's Customer Service Training Department to help them use the Training Environment to train customer service phone representatives on Fidelity's Defined Contribution Recordkeeping Application, Defined Benefit and Prelude applications. Purpose of the Training Environment was to give CSS phone reps hands-on experience using Fidelity's Recordkeeping system so that they can serve Fidelity's customers effectively and efficiently.

 Coordinated and managed changes and enhancements to the Training Environment's infrastructure, code base and databases.

 Investigated end user questions and problems with the Defined Contribution Recordkeeping Application, the Defined Benefit and Prelude applications in the Training Environment.

 Worked with appropriate Systems groups to research and resolve application bugs and enhancements.

 Eliminated most data errors by converting the original Mainframe Data Extract & Load process from File-Aid jobs to a semi-automated COBOL/DB2 Data Upgrade Process that ran twice a year.

 Created Sybase Stored Procedures to mask, replicate, and load data in the Defined Benefit and Prelude application Sybase databases. Used RapidSQL tool to create these processes and linked these processes to the Mainframe programs and tables.

 Worked with DBA to create program to mask replicate and load customer alert data in the MS SQL Server database and then worked with DBA to convert it to Oracle.

 Created Training Case Report programs and jobs using COBOL/Batch/DB2 and JCL to produce reports that list the training cases available to trainers for Defined Contribution, Defined Benefit and Prelude cases. These reports were ftp'd from the Mainframe to a desktop where they were converted to MS Word or MS EXCEL. These were produced after every Data Upgrade process completed.

 Documented the Data Upgrade Processes using MS EXCEL and Monthly code install procedures using MS Word and VISIO for the Training Environment.

 Created and maintained a Training Environment Technical Support web site using MS Frontpage 2000 to store information about how to support the Training Environment.

 Coordinated and worked with Production install groups to have them update the code base with Production level code during the scheduled monthly Production code install. Performed the initial test of the application and if there were problems I worked with the appropriate Systems groups to resolve them. Code installed was on the mainframe, Sybase, MS SQL Server, and Oracle platforms.

 From 2001 - 2003, functioned as backup Production Support to Fidelity's DB Express application, which updated Defined Contribution plan, fund, and fund price information from the mainframe to the Sybase databases. Used COBOL/DB2/VSAM, UNIX, some Korn scripts, and Sybase SQL and Stored Procs.

Software Consultant -- Senior January 19, 1996 to December 31, 2000

Programmer Analyst

Renaissance (originally called The Registry) Newton, MA

From February 4, 1998 - December 31, 2000,

 Assigned to be primary support and developer for the new Defined Contribution Training Environment. Took over the File-aid Data Extract and load process.

 Worked with the mainframe DB2 DBA's to create a job to refresh selected DB2 tables in the Training Environment from a baseline or backup file. Trainers wanted to reuse cases so the data had to be refreshed from a baseline file every business morning before training classes began.

 Created mainframe jobs to refresh selected VSAM files in the Training Environment from a baseline backup. Worked with Production Management to get this VSAM refresh job to run off of the Production job initiator because the Training and Test Environments did not have a tool to automatically submit jobs to run in the early morning hours before training classes began.

 Used COBOL/Batch/DB2, COBOL/CICS/DB2, Smartest (Mainframe Batch debugging tool), IDCAMS, DB2/SQL, Rapid SQL and MS Frontpage 2000 to support the Training Environment.

 Assigned as primary Production support contact for DBXPRS, an in-house developed application to copy changes to specific plan, fund and fund price information from the mainframe DB2 and VSAM databases to the Sybase SQL databases used by the workstation GUI front-end. Used mainframe COBOL/batch/DB2, Sybase SQL, IDCAMS, IBMFTP, Unix commands and Korn scripts.

 Developed DBXPRS Support web page using MS Frontpage 2000 for production support and developers who need to change DBXPRS modules.

 Assigned as mainframe programmer analyst to Fidelity's Defined Contribution Workstation support team. Helped debug, fix and enhance mainframe COBOL/CICS modules called by the Workstation GUI front-end.

 Assigned to be onsite support contact for the Y2K (Year 2000) project.

From January 1996 - February 1998

 Developer for Fidelity's International Group Pension Recordkeeping System. This system was a copy of most of Fidelity's domestic Defined Contribution recordkeeping system to meet Fidelity's Canadian Defined Contribution recordkeeping needs and to be a prototype for a Fidelity international recordkeeping system.

 Responsible for developing ad-hoc or short term (1-3 months) user request enhancements, like the GPRS Mailing Label Request function. This function had to produce a participant demographic extract file and FTP it to a LAN server where an outside vendor would retrieve it. Used MS Mail, MS Word and ABC Flowcharter to create technical specs. Application changes were done in COBOL/DB2 and Korn shell Script.

 Assigned to be programmer analyst for United Kingdom Gap Analysis team to determine if GPRS could be reused or if a new application had to be developed. Used MS Mail, MS Word, and ABC Flowcharter to document changes.

Project Consultant/Senior Programmer November 1989 to December 1995

Analyst

Connecticut Mutual Insurance Company Hartford, CT

 From January 1995 - December 1995: Monitored and modified the Client Management Facility's (CMF) critical but inefficient $10 million Mid Month Draft Check Service System Jobs. Worked with DBA and CMF team to determine where problems were and fixed them. In Sept. 1995, implemented application changes that reduced the Authorized withdrawal job's 9 hour execution time to under 4 hours. Uses S.A.S. to report and chart the Drafting jobs' execution and CPU times. Application changes were done in COBOL2/DATACOM. Used MS Word to document the results of the changes for the business users and management.

 From June 1994 - February 1995: assigned as Systems Consultant for the CMF Check Service Systems. Implemented changes to the CMF system to interface to a new policy administration system. Application was coded in COBOL2/DATACOM and IDEAL/DATACOM. Used RFFlow tool to flow chart the batch systems.

 From March 1994 - June 1994: assigned as Technical project leader for the Consolidated Group list Bill project, the purpose of which was to combine the billing data of multiple policy administration systems. Responsibilities included analyzing and documenting current Group/Franchise billing systems and proposing to client various solutions and recommending to them the best option. Assisted manager with interviewing consultants and recommended the best candidates to staff the project.

 From May 1992 - March 1994: assigned as technical project leader for the Electronic Billing & Reconciliation (EBR) project. Responsibilities included analyzing, designing, developing, testing, and implementing a system coded in IDEAL/DB2 and COBOL2/DB2 that would allow the company to combine two policy administration systems and to manage large salary deduction franchises. The system was a prototype of the Consolidated Group List Bill project.

 From November 1989 - May 1992: assigned as Senior Programmer analyst for the CMF Check Service System. Responsibilities included maintaining current and developing new IDEAL/DATACOM on-line dialogues.

Programmer analyst March 1988 to November 1989

Advo-Systems, Inc. Windsor, CT

 Assigned as lead Programmer Analyst for the Label Orders and Client Profile dialogues of the COBRA(Customer Order Billing Revenue Accounting) system. Responsibilities included defining system requirements to upgrade from Sperry 1100 to IBM 3090 reviewing consultant's implementation of the Client Profile dialogue using IDEA.L/DB2.

 Assisted in the Sperry 9080/IBM 3090 conversion project. Converted and tested COBOL programs from the Sperry to the IBM machine and created OS/JCL and TSO Clists to execute them.

Programmer Analyst-Consultant March 1986 to March 1988

Comptech, Inc. Glastonbury, CT

 Assigned as programmer analyst to the Textron Lycoming DB conversion team; interacted with Lycoming's Commercial and Military engineering analysts to redesign the Engine History All Time report; coded and tested the batch COBOL/DB2 program that produced the report.

 Assigned as programmer analyst to the Torrington-Fafnir Bearings Division Conversion team in Torrington, CT. Converted, modified, and tested OS/JCL and COBOL source code to Fafnir standards.

 Assigned as programmer analyst to the Torrington-Fafnir Bearings Division Conversion team in New Britain, CT. Designed, coded, and tested JCL and COBOL source code for two projects on the SPERRY-UNIVAC system.

 Assigned as programmer analyst to the DOS/MVS conversion team at the Torrington Company in Torrington, CT. Converted, modified, and tested OS/JCL, COBOL, and PL/1 source code to standards and debugged VSAM access problems.

Programmer Analyst March 1983 to March 1986

Travelers Insurance Companies Hartford, CT

 From June 1985 - March 1986: assigned as programmer analyst to the Employee Benefits Group. Developed upon user's request programs written in COBOL, MARK IV and ISPF Dialog Management to produce Employee Benefit reports to client companies. Designed and developed a Check Reconciliation System for the Group Insurance Department.

 From March 1983 - June 1985: assigned as programmer to the VTAM/Network Communications Group. Maintained VTAM tables and gens for the Network Communication Controllers.

Education:

University of Notre Dame Notre Dame, IN

Bachelor of Arts in History and Computer Applications

References: Available upon request

Contact this candidate