Support Analyst Manual Testing

SCOTT A. MCCLAIN

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

www.linkedin.com/in/scott-a-mcclain

Carnegie, PA, 412-***-****

Application Support Analyst

With over 15 years of IT experience, I bring a wealth of expertise in QA methodology, manual testing, and database validation. My background includes working on complex health insurance and document management systems, where I leveraged SQL, automated processes, and cross-functional collaboration to ensure high-quality outcomes. I am passionate about identifying and resolving issues efficiently, and I excel at learning new technologies quickly. Having worked in both the insurance and healthcare sectors, I possess a strong analytical mindset and a problem-solving attitude, making me an ideal candidate to help maintain top-tier quality standards across platforms.

Areas of Expertise

Functional Testing

Regression Testing

User Acceptance Testing

Test Case Creation

Defect Tracking and Management

SQL Query Writing

Agile Methodologies

Requirements Analysis

Test Plan Development

Manual Testing

System Integration Testing

Troubleshooting and Issue Resolution

Automation Process Implementation

Documentation and Reporting

Cross-functional Team Collaboration

Accomplishments

Led migration of legacy document templates to Quadient platform – This highlights my ability to handle complex system migrations and maintain scalability, which is crucial for testing multiple platforms.

Designed and implemented automated processes for document generation – Demonstrates expertise in automation and reducing manual effort, which can be applied to automation follow-up tasks.

Conducted SQL queries for data validation across multiple systems – My SQL skills are directly relevant to database validation in this role.

Performed Quality Assurance Testing for health insurance documents and systems – Extensive QA experience, including regression and manual testing, is a perfect match for the job’s testing requirements.

Troubleshot issues and provided timely resolutions in cross-functional teams – Showcases my ability to work with other departments to resolve bugs and issues, aligning with the responsibilities of collaborating across teams.

Created and documented test scenarios, ensuring accurate test results – Proven experience in test scenario creation and QA documentation, key to delivering quality products.

Parallel tested Oracle system upgrades, ensuring smooth transitions – Experience with system upgrades and ensuring high standards, directly relevant to the high-quality requirements of this role.

Conducted daily regression and unit testing in Oracle/Powerbuilder environment – My focus on regression testing aligns perfectly with the need to maintain consistent quality in multiple platforms.

Collaborated on the Aetna Drug Utilization Review program – Showcases my ability to learn and retain complex industry knowledge quickly.

Career Experience

Application Developer, Highmark Health Solutions, Pittsburgh, PA 05/2021 – 01/2024

Collaborated with cross-functional teams and customer interaction to ensure accurate and timely delivery of insurance documents, enhancing overall operational efficiency.

Designed and implemented automated processes for generating complex document templates, reducing manual effort and increasing accuracy.

Analyzed business requirements and translated them into technical specifications to meet client needs.

Conducted regular code reviews and performance tuning to ensure optimal functioning of the document generation system, including ad hoc reporting.

Provided leadership, technical support, business analysis, research and troubleshooting for issues related to document production, ensuring minimal disruption to business operations.

Led the migration of legacy document templates to the Quadient platform, improving maintainability and scalability.

Developed detailed documentation and user guides for end-users and team members, facilitating knowledge transfer and reducing onboarding time. Producing Product Demos when necessary.

Worked well under pressure with timely insteraction, priority setting, and monitoring process changes.

Sr. IT Systems Analyst/SQL Analyst, TEKsystems, Pittsburgh, PA 04/2018 – 05/2021

Working at Highmark Health Solutions

Working to produce Health Insurance documents for Groups and Members for North Dakota and Wyoming

Created and generated Summary of Benefits and Costs, Contracts, Renewal Letters and Booklets.

Created SQL queries to select data from several databases.

Used the following software Integrated Customer Information System (ICIS) (version 19.01.00), and Oracle’s Istream Author (version 6.302.11) and Oracle’s Istream Assembler (version 6.302.11).

Used the following software: Quadient Interactive and Quadient Scaler as Highmark was switching from a legacy system (ICIS and Istream) to Quadient.

Was able to drop JSON files into a hot folder to produce documents for review. Was able to perform Quality Assurance Testing with this process.

Quality Analyst Business Consultant/QA Senior Analyst, AETNA, Pittsburgh, PA 10/2008 – 11/2017

Continuation of Aetna Drug Utilization Review Program, which was brought in-house to Aetna.

Parallel tested the upgrade from Oracle 10g to Oracle 11g to Linux RHEL 7.3.

Created SQL queries to select/insert/update/delete data from any number of databases.

Worked closely with the Business Analyst, utilizing data and providing feedback, to understand, investigate, and gather the technical requirements for the business users, to create strong and robust test cases, and problem solving.

Used SQL Navigator in an Oracle environment, Unix, and Linux in support of the Aetna Drug Utilization Review (DUR) and Unattended Letter Generation (ULG) Programs to ensure programs produced the changes required.

Performed daily Regression, Unit Testing, and other Quality Assurance testing in an Oracle / Powerbuilder environment with major DUR applications released ~8-10 weeks.

Manual testing and Documentation of ~200 Items (Packages/Package Bodies, Functions, Procedures, korn shell scripts) being moved to Production annually.

Tracked issues and file bugs utilizing ClearCase for change control, and a spreadsheet called “Implementation Log” to keep track of where (DEVL, QA, PROD) the programs where currently located.

Followed HIPPA guidelines and Aetna Ethics & Values in all database work.

Used the following software: ClearCase, MS Word, MS Excel, MS Visio, SQL

Worked well under pressure with timely resolution, priority setting, and monitoring process changes.

Additional Titles Held:

Business Application Developer/QA Analyst, CVS (Pharmacare), Pittsburgh, PA

Contractor/QA Analyst, ITS, Pittsburgh PA

Contractor/QA Analyst, PYRAMID CONSULTING GROUP, INC., Wexford, PA

Contractor/Analyst, EXACTA CORPORATION, Madison, WI

Programmer Analyst II, CREDIT GENERAL INSURANCE COMPANY PRS GROUP, Beachwood, OH

Education

Bachelor of Science in Computer Science with a Math Minor

Westminster College, New Wilmington, PA

Contact this candidate