Quality Assurance Team Lead

DAVID G. STERNQUIST

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

RALEIGH, NC 27607

*****.*.**********@*****.***

http://www.linkedin.com/in/DavidSternquist

***- ***-**** [C]

SENIOR PROGRAMMER / ANALYST TEAM LEAD QUALITY ASSURANCE TESTER technical excellence / team leadership / customer service

Provide quality services as a Senior Programmer, Team Lead, Programmer/Analyst or QA Analyst. Expertise in managing and/or directing high level projects, leveraging 20+ years of experience supporting various IBM Mainframe applications in their design, development, testing, and maintenance. Primary client interface and project consultant ensuring the highest standards of quality, service, and productivity. Able to serve as Team Lead, Business Analyst, Senior Programmer or Quality Assurance Analyst.

TECHNICAL SKILLS SUMMARY

Applications / Software:

PL/I, COBOL, Rexx, CLIST

JCL, PROCS

Databases DB2, SQL, DDL, SPUFI, QMF

Jira

TSO, ISPF/PDF, RACF

IMS, CICS, VSAM

File Master, File Aid

IBM SCLM & CA Endevor

TWS (OPC), Control M, Zeke

Agile Development

And more!

Operating Systems:

z/OS (MVS) Mainframe, z/VM, Windows, Unix

PROFESSIONAL PROFILE

Key technology team member with a track record of delivering major development projects and implementations, solving complex IT system/application problems, and supervising technical teams. Experience at increasing levels of strategic, logistical capability, and technical project leadership. Over fifteen years’ experience providing database management support, coordinating development, integration, and maintenance of database and electronic system architectures at the component level.

Experienced in Agile Software Development. Innovative problem-solver with management level leadership experience. Experience performing analysis to identify and take corrective action for areas that impact batch production operations. Fully qualified to serve on team involved with legacy conversion projects that require expertise in reviewing existing application for rules and interfaces, ensuring that new/replacement applications work in a similar or duplicated fashion. Experience working with production applications involving mainframe & distributed systems.

Senior Mainframe Quality Assurance Engineer performing manual QA testing on Investment Brokerage Services applications and batch reporting. Solid understanding of the QA methodologies and Software Testing Lifecycle, including test planning and reporting. Assisting in the automation of testing where applicable. Developing system test strategies, plans, and scenarios. Used bug-tracking systems to submit, track, and manage defects. Exposed to Selenium for Automated Testing. Experienced in using data extract tools like SQL to create test data and to analyze test results.

Project leader directing all phases of testing including unit, system, integration, Regression and user acceptance testing. Over 10 years’ experience and expertise serving as the primary client (user) interface for project requirements and design as well as for problem management. Thrives in an environment that requires extensive problem investigation, programming, and team leadership.

Broad understanding of database management concepts, operations, design principles, methodologies, and approaches used in the development, testing, implementation, and maintenance of software and database systems, including knowledge of processing standards, component interrelationships, and effective assessment methods that support sound decisions and problem solving.

Operate on a foundation of trust and communication, treating people with respect and dignity. Encourage a collaborative approach to project management and supervision. A hands-on leader who expects the highest standards of personal and professional performance from associates. Outgoing personality, decisive decision maker, and innovative problem solver, effective communicator of complex technical terms in non-technical language, team motivator and leader by example.

FORMAL EDUCATION

Bachelor of Science, Computer Science (1989) State University of New York Institute of Technology, Utica, NY

Associates of Science, Computer Science (1986) Broome Community College, Binghamton, NY

Continuing Education (1998-present) IBM, Fidelity Investments, Credit Suisse, Lenovo, NCSU and Wake Tech

DAVID G. STERNQUIST

Page 2

CAREER ADVANCEMENT

Semi-Retired since March 2024

Took a break due to Family health issues, long term care planning.

NC DHHS Work from Home Office Raleigh NC

Programmer/Analyst/QA Tester (Nov 2023 – March 2024))

Supported NC DDHS ACTS System. Making minor modifications, documenting system flow, external system interfaces.

Tested many of the Conversions of CA Easytrieve code within NC DHHS set of Mainframe applications.

Involved with modifying the schedule for routine application maintenance, working with System support and programmers for z/OS subsystems like CICS, DB2, DB2/SQL, IMS, TSO, JCL and Zeke Batch Job Scheduler.

System interfaces include Medicaid and Medicare

Took several online classes and instructional training courses related to Privacy, PII, HIPPA and Social Security

IBM (Contractor with StreamFoundry Inc.), Working with several NC State Government Departments and Agencies; Work from Home Office Raleigh NC

Easytrieve to COBOL Conversion Programmer Analyst

IBM Migration Utility Subject Matter Expert (SME) (Jan 2023 – Nov 2023)

Project for State of North Carolina involving work with several different state government agencies.

Instructed clients on how to use the IBM Migration Utility, consulted on their conversion efforts.

Convert CA Easytrieve code to standard COBOL using the tools of the IBM Migration Utility.

Test converted code to ensure compatibility on client’s mainframe z/OS systems. Tested applications that interfaced with CICS, IMS, DB2, VSAM JCL, CLIST, Rexx and ISAM.

Several State Agencies/Departments had System interfaces with Medicaid and Medicare

Remote and on client site work performed depending upon client (Government Agency) requirements.

IBM, Work from Home office Raleigh NC

IBM Z APM Automation Tester (Feb 2021 – June 2022)

Part of a highly focused, self-managed Agile team who worked closely with developers to understand the user experience, workflows, and expected outcomes.

Test program changes made to the IBM Z Application Performance Management Connect (Z APM Connect) product.

Work in a collaborative team-driven environment with a group of experienced software engineers who want to deliver great technology

Extensive use of mainframe subsystems, System Automation, DB2, CICS, IMS, and WebSphere.

Expand testing to include Instana APM solutions in addition to our current AppD solutions.

Develop a testing automation approach that addresses all aspects of the software solution. Exposure to Selenium.

Analyzing business needs, working with IT professionals to translate business requirements into IT solutions, and testing to validate the quality of these solutions

Designing, building, testing, and deploying complex testing solutions

Provide relentless focus on quality and continuous improvement.

Bank of America (Contractor with Pyramid Consulting Inc., Accenture), Work from Home Raleigh

Mainframe Quality Assurance Tester, Onshore Team Lead (June 2020 – Jan 2021)

Test program changes made by team in Mainframe z/OS Batch environment.

Create Test plans, Test Cases of components, Integration & Regression testing using HP ALM / QC for documentation.

Coordinate with team(s), other Testers, Production Support Analysts, and customers to test and approve code changes.

Involved with Sprint Planning and tracking in an Agile environment using Jira. Participated in all Agile Sprint processes.

Oversee installation, perform smoke and other validation testing of changes performed.

Lead a team of offshore contractors in India. Help coordinate, train in specific technologies used by the team, and act as a go-to person when they run into issues. Update and Clarify Onboarding documents and procedures.

DAVID G. STERNQUIST

Page 3

Fidelity investments (Contractor with Leapfrog Systems), RTP NC

Principal Software Engineer (February 2019 – October 2019)

Analyze and make code changes to existing programs and processes to eliminate Mainframe specific elements (VSAM).

Coordinate with team, Testers, Production Support Analysts, and customers to stage, test and approve code changes.

Oversee installation and perform validation testing of changes performed.

Perform manual QA testing on Investment Brokerage Services applications and batch reporting (changes made by others)

Involved with Sprint Planning and tracking in an Agile environment using Jira. Participated in post-Sprint retrospectives.

Collaborated to create data extracts and reports to feed downstream AWS and MS Azure Cloud environments.

Wrote SQL queries to create test data as well as to analyze the results of the tests performed.

IBM (Contractor with ARTECH INFORMATION SYSTEMS), RTP NC

Senior Mainframe Application Developer (December 2017 – July 2018)

Review Existing code written in PL/1, JCL, Rexx, SQL and Pipes. Modify code for project enhancements.

Liaise with key stakeholders, customers, programmers and other support staff.

Participating in sessions to collect requirements from the business and end user groups.

Mentored new team members in the system environment serving as a coach, trainer, and troubleshooter.

Review Code, DB2 tables and other objects for GDPR compliance.

Used Jira to maintain current sprint projects and issues backlog.

Exposed to some of the system testing using Selenium

Performed post-install verification testing.

First Citizens Bank (Contractor with Apex Systems Inc), Raleigh NC

Senior Mainframe QA Engineer (February 2017 – September 2017)

Participate from beginning to end in the systems development life cycle and/or the operations support model.

Responsible for testing modifications to ensure they meet defined requirements.

Prepare, distribute, and present system documentation to end users in addition to preparing ad hoc reports.

Participating in sessions to collect requirements from the business and end user groups.

Use bug-tracking systems to submit, track, and manage defects.in ALM and Jira.

Define system test scenarios, create system test plans, design and author test cases and participate in the definition and execution of manual and/or automated system test scripts. Develop and maintain regression test cases in Quality Center.

Performed post-install verification and regression testing. Worked with Q2 and FCB technical staff to address post install issues, communicate with management to have Go/No-Go decisions provided and communicated.

Assist in account, balance, and data reconciliation in situations where customers are being impacted and production is being delayed and assist in notifying technical staff.

Fidelity investments (Contractor with Ettain Group), RTP NC

Senior Mainframe QA Engineer (2015 – 2016)

Perform manual and automated QA testing on Investment Brokerage Services applications and batch reporting.

Primary focus was on Testing but lead Design and Code reviews of enhancements to internal applications.

Review, analyze and translate business and systems requirements into functional test scenarios.

Collaborate with project team resources, including development and business partners, to understand and prioritize efforts

Define system test scenarios, create system test plans, design and author test cases and participate in the definition and execution of manual and/or automated system test scripts.

Document and report identified defects in Quality Center; lead defect triage and test status meetings; ensure that development groups address all open defects in a timely manner.

Provide input into Go/No-Go decisions on software readiness for production release.

Assist in analysis of current processes, and recommend improvements for processes, best practices, and standards.

Develop and maintain regression test cases in Quality Center.

Ran previously developed Selenium scripts

Jira started being used near the end of my contract work.

DAVID G. STERNQUIST

Page 4

Credit Suisse, Morrisville/RTP NC

Production Support Programmer Analyst (2012 – 2015)

Provide near-shore production support in the Production and Test Group.

Production support analyst for mission-critical Credit-Suisse back-office mainframe applications and batch schedules.

Performed minor code and JCL changes in support of applications. Scheduled and lead in Code Reviews.

Liaise with key stakeholders, customers, programmers, and other support staff.

Work in conjunction with legal, business units, and the federal government to address and prioritize critical trade issues.

Fed-White Paper test, disaster recovery planning, investment platforms, reconciliations, and end-user training.

Coordinated efforts to reduce nightly mainframe batch cycle.

Investigate problems with programs written HPS, PL/1, COBOL and JCL, interfacing with CICS, VSAM, DB2, WebSphere and PowerBuilder.

IBM (Contractor with Apex Systems Inc.), RTP NC

Easytrieve to COBOL Conversion Programmer Analyst

IBM Migration Utility Subject Matter Expert (SME) (2009 – 2011)

Convert CA Easytrieve code to standard COBOL using the tools of the IBM Migration Utility.

Test converted code to ensure compatibility on client’s mainframe z/OS systems. Tested applications that interfaced with CICS, IMS, DB2, VSAM and ISAM.

Perform Proof of Concept trials for clients. Gave product demonstrations and overview of product to external IBM Clients.

Instructed clients on how to use the IBM Migration Utility, consulted on their conversion efforts.

Remote and on client site work performed depending upon client contract requirements.

Worked on Client projects for governments like State of Ohio, City of New York and State of Nebraska as well as businesses like Avis-Budget Group and American Express.

Work with the State of Ohio and City of New York involved Medicaid and Medicare system interfaces and data.

IBM, at various IBM Locations including at Owego & Endicott NY, Burlington VT, Research Triangle Park, NC, and Poughkeepsie NY

IT Specialist, Sr. Programmer, Business Analyst, Team Leader (1989 - 2009)

Directed new project analyses, developmental enhancements and collaborating with cross-functional technical teams on the design and implementation of developmental and functional enhancements, end user support, and internal troubleshooting for IBM applications in NY, Burlington VT, and RTP, NC.

Serve as key interface with cross-functional teams regarding application function, troubleshooting, and maintenance.

Primary interface between clients and programmers for the US Dealer Sales / eMARS / eMariner applications, communicating complex technical details in an understandable and concise manner. Communicate with clients and programmers dealing with application enhancement and continued support, maintenance, and training issues.

Supported the US and later the WW Dealer Sales application that takes dealer reported EDI Data and performed basic edit checking of data as well as supporting user application updates to that data. The EDI data related to Sales, Inventory and Consumer information supplied by various distributors within the IBM Personal Computer Division (PC Co) network.

Internal IBM Applications created and enhanced that were written on or communicated with z/OS (MVS), OS/2, Windows and AIX systems. Web based (EDI) Dealer reporting application written and supported by eMariner sub-team.

Documented and implemented advanced security procedures for internal audits.

Extensively involved in the Lenovo segmentation project, focused on separating IBM PC Co Division data and interfaces from that of IBM. Processed $16+ billion yearly in combined sales reporting into IBM systems.

Programming in PL/1, Rexx, ISPF, DB2, SQL, QMF, JCL, C, C++, CICS, IMS DB, IMS DC, COBOL and some Assembler.

Contact this candidate