Senior Programmer Analyst - Cobol, DB2, Vsam, Jcl, Cics

PAMELA J. YEAGLE-KEYSER

Hillsboro, OR ***** H: 503-***-**** C: 503-***-**** ***********@*****.***

SENIOR PROGRAMMER ANALYST

Diligent, driven, and resourceful Senior Programmer Analyst with over 20 years of experience within the IT industry, working with various mainframe and server environments. Analytically-oriented leader with superior innovative abilities, excellent communication skills, and proven experience in documenting processes.

Project Expertise

• Retail Systems

• Health Care Systems (Medicare, Medicaid, Contracts, and Membership Systems)

• Telecom Messaging Systems

• Daily Sales and Reconciliation

• Health Care Exchange (Rating and Premiums)

• Teller Systems

• Mainframe Extracts for Downloads to Servers (SFTP)

• Business and Systems Analysis

PROFESSIONAL EXPERIENCE

KAISER PERMANENTE Lake Oswego, OR

Senior Programmer Analyst/Technical Analyst 2000 – 2014

• Managed and performed systems analysis and created physical solution designs for the Common Membership System for regions outside of California, including Georgia, Ohio, Colorado, Washington, Oregon, and Hawaii.

• Optimized business requirements into flexible and adaptable solutions that were cost-effective and met the needs of the business.

• Researched, consulted, and provided estimates for modifications and new development in Common Membership.

• Created functional requirements, physical design requirements, and component specification documents for batch and online programs for membership and billing

• Analyzed Medicare requirements and designed programs that interfaced with the Medicare system.

• Designed interfaces which collected member demographic and pharmacy information to be interfaced with third party systems that were HIPAA compliant.

• Formatted interfaces in HL7 format to be interfaced to Health Connect.

• Created Data Mapping documents for interfaces sent to third party systems

• Ensured all documents and development processes were SOX compliant.

• Collaborated with DBAs to create DB2 tables and designed SQL queries to be used by the Common Membership system.

• Performed consultations with groups outside of Common Membership - Data warehouse, Pharmacy and Foundation Systems.

• Gained knowledge of HIPAA Electronic Data Interfaces using 834, 270, and 271 formats.

• Mentored and coached analysts and programmers using COBOL and DB2.

Environment: MVS, COBOL/COBOL/COBOLII, DB2, VSAM, CICS, JCL, EGL, VAGEN, XML, HL7, SAR, FILE-AID, TSO/ISPF, XPEDITER, ABENDAID, VISIO, Changeman, Lotus Notes, EZTrieve+, QMF, SPFUI, MQ, MS Office, Word Excel, Access, SDLC

FRED MEYER Portland, OR

Senior Programmer Analyst 1997 – 2000

• Analyzed, provided support, and developed daily sales and reconciliation applications and the teller applications.

• Partnered with accounting department to design teller and daily sales reports and on-line screens.

• Created solutions documents defining requirements and the technical solutions for the requirements of COBOL and VAGEN programs.

PAMELA J. YEAGLE-KEYSER – PAGE 2

PROFESSIONAL EXPERIENCE (CONTINUED)

• Developed programs that fed the reconciled daily sales into the general ledger system; maintained programs for the teller system that reconciled cashier’s cash drawers and created reports for cashier overages and shortages.

• Provided detailed and customer-oriented support for the daily sales and teller systems.

Environments: MVS, COBOLI & II, DB2, VSAM, CICS, JCL, SAR, TSO/ISPF, VAGEN, XPEDITER, AND ABENDAID.

PACIFIC TELECOM Vancouver, WA

Programmer Analyst 1993 – 1997

• Supported and developed the Telecom Messaging System; managed programs that translated messages from point of presence into a format utilized by a Bell Standard Messaging System.

• Collaborated with accountants and business partners to determine requirements and design reports.

• Created solution design documents defining the requirements and physical solutions to fulfill business needs; developed and created test plans for client requirements.

• Produced programs which created the customer billing for Pacific Telecom.

Environments: JCL, TSO, SAR, DB2, EasyTrieve +, BRACKETS, ABENDAID, ISPF, and COBOL

EDUCATION

Associate of Applied Science – Computer Information Systems

Portland Community College, Portland, OR

Bachelor of Science – Health and Physical Education

University of Delaware, Newark, DE

TECHNICAL SKILLS

Hardware

IBM Mainframe, IBM Compatible

Data Structures

DB2, VSAM, Access, Excel

Program Migration Tools

Librarian, Changeman

Data Management and Testing Tools

FileAid, Xpediter, Abend Aid, TCP/IP, StarTeam, Microsoft Visual Studio

PC and LAN Experience

MS Office, Word, Excel, Outlook, Viso, Lotus Notes

Operating Systems

TSO/ISPF, MVS, Windows

Languages/Tools

COBOLII, SQL, JCL, EGL, VAGEN, SPUFI, QMF, Visual Basic, EasyTrieve,

Familiar with C++,JavaScript

Contact this candidate