Carolyn Smith
Phoenix,AZ
Summary
Experienced z/OS Mainframe Developer with 30 years in COBOL, DB2, and CICS programming, focused on application architecture and development. Skilled in engineering batch programs, integrating complex systems, and leading testing efforts. Proficient in developing technical specifications and user documentation, with a strong commitment to managing software programs and troubleshooting issues.
Overview
38
38
years of professional experience
1
1
Certification
1
1
Language
Work History
Senior Developer
American Airlines
Tempe
05.2015 - Current
- Architecting, developing, and maintaining applications to deliver business benefits.
- Contributed to projects for Usage, Interline, Sales, Payments, and currently Refunds, enhancing cross-functional collaboration.
- Supported Refunds domain with stored procedures, DB2, and multi-environment development and testing, ensuring reliable application performance.
- Handled on-call duties while collaborating closely with MFOPS to resolve production issues efficiently.
Senior Programmer Analyst
US Airways
Tempe
10.2009 - 05.2015
- Developed programs and processes for data migration and data auditing for the Single Frequent Flyer Program (SFFP), recognized as the world's largest Loyalty Experience program.
- Executed modifications to programs, tables, flight posting, member account updates, tier level movements, and billing processes for integration with Oneworld Alliance, enhancing operational alignment.
- Enhanced programs, tables, and processes within the Dividend Miles program to meet STAR Alliance requirements.
- Engineered batch DB2 programs to process Dividend Miles flown data for US Airways Frequent Flyer members.
- Developed programs to support marketing promotions, increasing engagement among Frequent Flyer members.
- Modeled tables and designed batch process for updating and reporting audit information on file exchanges with other airlines, improving data integrity and compliance.
- Authored comprehensive test plans and scenarios for inter-airline testing and internal team validation.
Senior Programmer Analyst
Salt River Project (SRP)
Tempe
11.2006 - 10.2009
- Operated within a COBOL DB2 Mainframe environment for SRP’s ‘Pre-Paid Meter (MPower)’ project.
- Developed technical specifications, wrote new programs, and implemented enhancements to existing programs in CICS and batch processing.
- Authored String Test Strategy document and created string test cases to ensure comprehensive testing coverage.
- Led team of programmers in executing string test cases, validating results across DB2 tables, reports, and online screens to ensure data integrity.
- The team developed 130 test scripts, identifying 45 defects.
- Developed new processes for replacing legacy CICS and batch programs, integrating MQ Series for efficient data transport between applications.
- Developed programs to generate electronic letters for customers utilizing the IBM AFP custom print language interface.
QA Analyst
Salt River Project (SRP)
Tempe
05.2006 - 11.2006
- Managed testing activities for SRP’s ‘Smart Meter’ project.
- Developed and executed test cases for a web-based application, deriving test cases from the functional design document.
- Planned the sequence of test case execution over five logical days and documented failures in an Access database.
- Verified and gathered test data, validating results through GUI screens, SPUFI queries in DB2 tables, mainframe flat files, and reports.
- Collaborated with other QA Analysts, developers, and business experts to identify and resolve defects in SRP's Billing enhancements.
- Provided input for Test Case planning and documentation for subsequent User Acceptance Testing (UAT) activities.
Lead Programmer Analyst
State Compensation Insurance Fund (SCIF)
San Francisco
04.2001 - 05.2006
- Oversaw the support for downloading DB2 Policy Data to the AMS ORACLE Server.
- Provided data mapping, overall system design to facilitate downloads from the Policy and Claims systems, and DB2 Reporting System design, coding a total of 34 new programs and modifying 97.
- Performed data modeling of new tables and recommended changes to the DB2 version of vendor tables.
- Rendered QA support, debugged issues, and proposed solutions.
- Functioned as the lead programmer analyst on various projects within the Policy financial, reporting, and auditing subsystems.
- Participated in on-call production support for the nightly execution of the DB2 Policy System, resolving abends, DB2 issues, CICS problems, promotion issues, scheduling conflicts, JCL syntax errors, and COBOL coding errors, escalating to IT subject matter experts when necessary.
Senior Consultant
Charles Schwab
San Francisco
08.2000 - 04.2001
- Managed Quality Assurance Testing for Oracle extracts to the Mainframe across three interfacing systems, and for changes to nightly batch updates from Mainframe to the Oracle database.
- Reviewed business requirements, project test data and plans, Mainframe CICS screens, the DB2 data model, client-server GUI screens, and the Oracle data model.
- Utilized SQL Navigator to query the Oracle database and created Unix shell scripts to extract data for shipment to the mainframe, updating DB2 tables.
- Collaborated closely with developers for hands-on application testing.
- Employed SPUFI to query and verify mainframe DB2 tables.
- Developed test scripts to validate CICS transactions, nightly batch updates to the Oracle database, and batch updates to DB2 tables from Oracle batch extracts.
- Spearheaded the End-to-End Validation effort, tracing data flow from mainframe to DB2, Oracle, updates via GUI screens, and back to the mainframe.
- This involved executing numerous mainframe jobs and Unix scripts.
Senior Consultant
CSAA
San Francisco
08.1999 - 08.2000
- Coordinated and led the Quality Assurance Testing for the Homeowners Insurance software package on Windows NT Workstations, Citrix Servers, and an Oracle database.
- Gathered and reviewed business requirements.
- Evaluated package software documentation and the Rate Filing with the Department of Insurance.
- Developed the Statement of Work.
- Prepared test cases.
- Established project schedules.
- Identified costs and resource requirements.
- Managed test case and script preparation, result tracking, and issue resolution.
- Collaborated with users on additional requirements and prepared project documentation.
- Liaised with users, actuaries, and the CSAA internal audit team.
Consultant
State Compensation Insurance Fund
San Francisco
07.1998 - 08.1999
- Contributed to the Y2K Project by inspecting code, aging files and DB2 database tables, developing test scripts and plans, correcting programs, testing and validating results, and updating relevant documentation.
- Systems supported included Claims, Policy/Premium, and Insurance Prospects, encompassing both batch and online components.
Consultant
Wells Fargo
San Francisco
10.1997 - 07.1998
- Supported the Y2K Project by performing Year 2000 COBOL and Easytrieve program code updates for the SUS Statement application.
- This involved code inspection, file aging, and extensive coordination and testing of interfacing applications.
Lead Programmer/Analyst
CSAA
San Francisco
06.1988 - 10.1997
- Managed projects and tasks, defined requirements, and executed analysis, design, and implementation of improvements for legacy online and batch Homeowner and Automobile Insurance Systems.
- Successfully resolved issues pertaining to data transmission, storage, retrieval, and updates from external sources.
- Performed data modeling, collaborating with users to define data element rules and usage.
- Designed screens, reports, test plans, and detailed project and task management strategies.
- Served as Team Lead and Programmer/Analyst for the Emergency Road Service Application, a 24/7 client-server application operating across 12 sites and supporting over 200 workstations, utilizing data stored in indexed files on a file server and a remote DB2 database server.
- Functioned as an analyst to convert original COBOL programs to Micro Focus COBOL II, architecting a new system and developing GUI screens using Micro Focus GUI Screen Developer.
- Acted as Senior Programmer Analyst for CSAA’s Homeowners Policy application, responsible for enhancements and maintenance.
Education
Project Management Certificate - Computer Information Systems
University of California, Santa Cruz Extension
HaywardInformation Systems Management - undefined
Chabot College
HaywardSkills
- COBOL programming
- COBOL
- DB2
- SQL
- CICS
- z/OS platform
- Web Development
- JCL
- TSO
- MQ SERIES
- Microfocus COBOL
- EASYTRIEVE
- SYNCSORT
- FILEAID
- IBM Utilities
- QMF
- SPUFI
- UNIX
- ORACLE DB
- SQL SERVER
- Data Engineering
- Data Analysis
- Big Data Processing
- Cloud Solutionsnuous Integration
- AZURE
- Project management
- Systems analysis
- Software Development
- Quality assurance
- Programming analysis
- User Interface Design
- Analytical thinking
- Problem solving
- Self-directed work
- Decision-making
- Team management
- Customer relations
- Vendor relations
- Communication
- AFP
- CA Scheduler
- SCLM
- PANVALET
- LIBRARIAN
- XPEDITER
- FTP
- VSAM
- SAS
- Web Development
Certification
- Project Management Certificate
- University of California, Santa Cruz Extension
LANGUAGES
English
Timeline
Senior Developer
American Airlines
05.2015 - Current
Senior Programmer Analyst
US Airways
10.2009 - 05.2015
Senior Programmer Analyst
Salt River Project (SRP)
11.2006 - 10.2009
QA Analyst
Salt River Project (SRP)
05.2006 - 11.2006
Lead Programmer Analyst
State Compensation Insurance Fund (SCIF)
04.2001 - 05.2006
Senior Consultant
Charles Schwab
08.2000 - 04.2001
Senior Consultant
CSAA
08.1999 - 08.2000
Consultant
State Compensation Insurance Fund
07.1998 - 08.1999
Consultant
Wells Fargo
10.1997 - 07.1998
Lead Programmer/Analyst
CSAA
06.1988 - 10.1997
Information Systems Management - undefined
Chabot College
Project Management Certificate - Computer Information Systems
University of California, Santa Cruz Extension