MARY KAY WAGNER

**** ****** ***** *****

Charlotte, NC 28226

704-***-****

actz5e@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Transitioned from Programmer Analyst to QUALITY ASSURANCE SYSTEM TESTER focusing on UAT TESTING. Currently working with HP ALM v11 (Application Lifecycle Management) and Agile Mythology. My experience and accomplishments as a Senior Programmer Analyst with over 20 years of comprehensive and well-diversified experience, provides me to be an effective Tester, interfacing with the Business Unit and Technology to assure accurate business needs. Completing projects on or before deadlines... Analytical problem solver; effectively troubleshoots systems, programs, and applications... Strong communication and interpersonal skills... Excellent project documenting abilities... Dedicated, dependable, and committed to achieving results...

Expertise in the following key areas:

UAT Testing System Design & Coding

Troubleshooting Implementation & Testing

Consulting Maintenance & Support

Documentation New Product Development

Database Management Project Management

Credit Policy Branch Automation (Banking)

TECHNICAL SKILLS

COBOL 370 JCL (CA-7, CA-11) EASYTRIEVE IMS DB/DC CICS DB2

MVS TSO/ISPF VSAM FILE AID XPEDITER APS

QMF Queryman SPUFI LIBRARIAN ENDEVOR PANVALET

Micro Focus Workbench MS EXCEL MS VISIO MS WORD MS OUTLOOK PDSMAN

SQL Server 2008 HP ALM v11 Agile

EXPERIENCE SUMMARY

Interface with the Business Unit and Technology to assure accurate business needs. Currently System Testing (UAT) of the RMD (Required Minimum Distribution) of retirement funds using COBOL-CICS_DB2, HP ALM v11 (Application Lifecycle Management) and the Agile Mythology.

Manage the execution of UAT scripts leveraging HP ALM v11.

Extensive experience in various industries, including banking, insurance, retail, textiles/manufacturing, public sector.

Generated accurate and detailed project documentation that outlined project progress, requirements, and specifications.

Designed, coded, tested, and implemented new development modifications to existing programs.

Experienced in system conversions, creation, upgrades, and maintenance.

Provided production support and troubleshooting for Y2K projects.

Training, IMS DBA in a Data Sharing/Sysplexed environment.

Created and maintained information database systems utilizing IMS, VS/COBOL II and IDH, a batch interface between CICS and the IMS database.

Training: Instructor Led - SPI CMM Overview, Advanced UNIX Data Tools and Techniques, Perl 5 Programming. Computer Based Training - UNIX 1: Introduction to UNIX, Oracle 1: Introduction to PL/SQL. Picture Talk - Introduction to Business Objects Version 6.5.1.

Mary Kay Wagner - Page Two

PROFESSIONAL EXPERIENCE

THE JUDGE GROUP, Charlotte, NC 2/2015 – 11/2015

Contract Systems Quality Assurance Analyst

The Vanguard Group, RMD (Required Minimum Distribution) Systems Quality Assurance Analyst

Took part as Lead Tester.

Analyze and review the business requirements and functional specification documents.

Interface directly with the Business Unit and Technology to assure accurate business needs.

Involved in the designing, writing and testing of new development and implementation of beneficiary RMD (Required Minimum Distribution).

New development on the Mainframe DB2 and UI to both have identical functionality.

Work with Technology and User Teams to identify, track and resolve defects and quality issues.

Responsible for System Testing of the RMD of retirement funds using COBOL-CICS, DB2, MFE, SQL with the Agile Mythology.

Attend Story development, Sprint Planning, and Pointing Sessions.

Responsible for the input of the testing, concerns, requirements and timeframe for execution.

Participate in morning Scrum sessions.

Manage the execution of Testing scripts leveraging HP ALM v11 (Application Lifecycle Management).

Currently working with the UI development team testing the interface with the Host.

BANK of AMERICA, Charlotte, NC, 6/2011 – 12/2014

Consumer Product Strategic Analyst II

User Acceptance Test Analyst SFDMS (Single Family Default Monitoring System)

Manage the execution of UAT scripts leveraging HP ALM v11 (Application Lifecycle Management).

Verify back end data using SQL Server 2008 Management Studio.

Work with Technology, Quality Assurance Team and User Teams to identify, track and resolve defects and quality issues.

Interface with the Business Unit and Technology to assure accurate business needs.

Provide prompt and appropriate escalation of UAT defects.

Provide UAT status reporting and progress analysis for management review.

Recently involved in the designing, writing and testing UAT Test Plan/Scripts for the re-write of SFDMS (Single Family Default Monitoring System). AS400 to UI.

Provide Ad-hoc reports for testing needs for SFDMS Line of Business using Microsoft Excel and

SQL Server 2008.

Continued support for the new SFDMS enhancements.

TEK Systems, Greensboro, NC, 11/2010 – 3/2011

Contract Systems Quality Assurance Analyst III

Wells Fargo (Wholesale) Systems Quality Assurance Analyst III

Responsible for creating, preparing and executing detailed complex test scripts for the backend of the PHONE/FAX System. Extensive knowledge of the mainframe.

Wachovia Connection System is being merged with the Wells Fargo System.

Test scripts were written using Quality Center and Clear Quest testing tools. Testing included regression and validation.

Worked directly with the developers and quality assurance team.

Participated in Dress Rehearsals and Production Implementation.

Mary Kay Wagner - Page Three

PROFESSIONAL EXPERIENCE con’t

TEK Systems, Greenville SC, 03/2008 – 12/2008

Contract Senior Programmer Analyst

Colonial Life (Data Warehouse, Information Technology) Senior Programmer/Analyst

Responsible for new development and enhancement of data warehouse projects: created new Business View DB2 tables to be used with the weekly performance table to provide sales by various BCN/Policy Dimensions, working closely with the business unit to insure accurate results.

Created new data base fields for the Inforce Premium data warehouse table using CASE statements and reloaded previous year and YTD tables with the data.

Responsible for creating and maintaining SQL queries (especially multi-table and summary queries and subqueries using extensive join logic). Data base indexing, join process and how query optimization works.

Concentrated in documenting sourcing and transformation data (ETL) for internal audit. Platforms included MVS, DB2, IMS and Informatica.

SAPPHIRE TECHNOLOGIES, Charlotte, NC, 04/2007 – 10/2007

Contract Senior Programmer Analyst

Bank of America (Insurance Services Group) Programmer/Analyst

Responsible for creating and maintaining a centralized information file for each line of business and product (Life and Health Insurance, Property and Casualty Insurance, Commercial Insurance & Loan Protection Products).

Utilized SAS, EZTRIVE, JCL and EXCEL to insure data and file validation, tracking specific data and creating and loading accurate files to the W, CHDB and TML databases.

Involved with the DMAIC improvement process of Campaign Management.

BONAIRE SOFTWARE SOLUTIONS, LLC, Charlotte, NC, 05/2006 – 03/2007

Contract Systems/Analyst

Wachovia (Treasury Finance Technology) Systems/Analyst

Duties performed: Mainframe production support (evening hours), problem solving, application tuning using COBOL, CICS, DB2, SQL for daily processing of the Treasury Management Portfolio System. Complete Test Directors from initial detection to resolution using the PICCT process.

Worked directly with the client to produce efficient and timely access/update to DB2 databases.

TATA CONSULTANCY SERVICES (TCS America), Charlotte, NC, 03/2006 – 04/2006

Contract Systems/Analyst

Bank of America (2006) Systems/Analyst

Active in the Bank of America acquisition of MBNA.

Responsible for creating batch traffic in the test environment to simulate the production daily activity while inserting all new MBNA accounts into the Customer Information System database so as to determine transactions per second (TPS) and not to interfere with daily activity.

Mary Kay Wagner - Page Four

PROFESSIONAL EXPERIENCE con’t

INFORMATION CONTROL SYSTEMS, INC. Charlotte, NC, 09/2005 – 11/2005

Contract Programmer/Analyst

Duke Energy (2005) - Systems Consultant

Responsible for front line application and operational support for the IT Financial applications and the Supply Chain Production applications.

Duties performed: respond promptly to applications and operational issues, analyze issues and provide solutions.

Used PeopleSoft application software to perform work tasks.

BANK of AMERICA, Charlotte, NC, 11/2000 – 06/2005

AVP; Senior Analyst-APPS Programming

Support Credit Policy for Risk Management area.

Responsible for daily/monthly support and enhancement projects, application tuning using COBOL, DB2, SQL, QMF, SPUFI, XPEDITER, CHANGEMAN.

Insert to DB2 tables of loan data from the W (data warehouse, Tera Data) for risk and trend analysis.

Used Queryman to read Tera Data database to assure quality of data extracted.

Gathered business requirements directly from the client to produce Collateral Exception Management Reporting (CEMR). CEMR provides a summarized collateral and document exception reporting for Direct Consumer loan and line portfolio (data loaded to DB2 tables for client).

Instrumental in the merger of Fleet Boston to BofA consolidation of Consumer related loan systems consisting of compiled and summarized outstandings, unused commitments, past dues and non-performing information by GL Bank, Cost Center and GL Account Level data.

Manage Test Case/Test Script development for SIT and UAT

Supported migration of the CEMR application from the 1H LPAR (Richmond, Va.) to the 3S LPAR (Dallas, TX).

Converted Specialty and Auto application data from CMIS to MAGELLAN.

BANK of AMERICA, Charlotte, NC, 04/1999 – 09/2000

Senior Analyst

Data Base Administration and Analysis

IMS Data Base production support. (24X7)

Monitored daily performance of Fast Path and Full Function Data Bases.

Prepared JCL and Scripts for Fast Path data base expansion.

Executed Fast Path data base expansions to increase area size to 4 gig.

Used BMC Software products as a data management resource.

Mary Kay Wagner - Page Five

PROFESSIONAL EXPERIENCE con’t

SPC, Charlotte, NC, 08/1992 – 04/1999

Contract Programmer/Analyst

First Union National Bank (1998 - 1999) - Systems Consultant

Project Lead/Developer – Golden Nugget Project/Consolidated Trust and Brokerage Statement.

Designed and developed using APS, COBOL II and DB2.

Mecklenburg County (1997 - 1998) - Systems Consultant

Provide programming and production support for the local government.

Instrumental in Test Case/Test Script development and execution of testing/regression testing for the Y2K project.

Facilitate arrest-processing expansion utilizing conversational CICS, VSAM; perform all system troubleshooting.

NationsBank (1995 - 1997) - Systems Consultant

Facilitated smooth and efficient transition in conversion of NCIS system from Norfolk, VA to Richmond, VA; Extensive utilization of IMS and JCL.

Executed and monitored cycle runs on new system to ensure proper performance.

Performed as project leader for the Business Banking Credit Policy project, consisting of the creation of a Commercial and Consumer Tracking Reporting System using DB2.

Acted as a mentor for fresh graduate new hires.

SPC, Charlotte, NC, 08/1992 – 04/1999 con’t

Contract Programmer/Analyst

First Union Bank (1993 - 1995) – Systems Consultant

Designed an Automated Mortgage Good Faith Estimate using APS, IMS, and DB2 (online) and document printing.

Worked in CIS Department on IMS Message Processing project using APS, IMS, and DB2.

Created an Automated Mortgage Loan Application using APCS/PC workstation, IMS, and XDB.

Utilized SDLC for development.

Wachovia Bank (1992 - 1993) – Systems Consultant

Worked on the conversion through merger phase in the Commercial/Loan Division; included extensive utilization of COBOL, JCL, ENDEVOR.

Wrote an ATM reconciliation system utilizing DB2.

Documented entire project from conception to completion.

ROYAL INSURANCE, Charlotte, NC, 09/1986 – 06/1992

System Analyst/Programmer

Wrote the first DB2 system, a fraud database for the Claims Department utilizing SDLC.

Team member to rewrite (fine tune) Claims System using CICS, DB2, APS.

Performed system maintenance utilizing IMS/DB2 (online), VSAM, and EASYTRIEVE.

Production support of daily activities.

Mary Kay Wagner - Page Six

PROFESSIONAL EXPERIENCE con’t

FIRST UNION BANK, Charlotte, NC, 11/1983 – 09/1986

Assistant Systems Developer

Began in First Union Programmer Training program; Upon completion, started in the Branch Automation Department creating, testing, and implementing branch banking systems.

Responsibilities included the maintenance and support of the Branch Automation System (IMS, DB/DC inquiry system); specifically Checking, Instant Cash Reserve and Savings.

Designed, coded, tested, and implemented new development modifications for existing systems.

Responded to user requests or emergency system changes to maintain online system availability.

Active in the First Union Bank acquisition of Northwestern Bank.

EDUCATION

GARDNER-WEBB UNIVERSITY, Charlotte, NC

B.S. Management Information Systems (1991)

CENTRAL PIEDMONT COMMUNITY COLLEGE, Charlotte, NC

A.A.S. Business Computer Programming (1987)

Contact this candidate