QA Engineer Resume , Denver, CO - Hire IT People

SUMMARY:

I have worked in the Quality Assurance (QA) industry for the last 9 years. As a Senior QA Lead, I have led major project initiatives one of which was leading 20 offshore and 15 onsite resources on a two year conversion project for our primary annuity application system. The conversion project successfully launched on the projected target date and came in under budget with minimal production defects. I have used both Agile and Waterfall methodologies on my projects in conjunction with various automation tools including Selenium and Quick Test Pro (QTP).
I am proficient in SQL coding and have worked on Extract, Transform and Load (ETL) and Data Warehouse projects using SSIS SQL Server Integrated Services and Informatica for the last two years. I am proficient in Transact - SQL ( T-SQL ) as well as Oracle .
I am in the process of learning VB Script as well as Pl/SQL. I am a Certified Software Test Professional Practitioner Level (CSTP-P) with the International Institute for Software Testing (IIST).

TECHNICAL SKILLS:

Database Tools: Oracle Express DBVisualizer Toad SQL Server SSIS SQL Server Management Studio

Automation Tools: Selenium QTP VBScript

Defect Tracking Tools: Quality Center Jira

PROFESSIONAL EXPERIENCE:

QA Engineer

Confidential, Denver, CO

Responsibilities:

Weekly validation of core loads into our EDW.
Implemented a trending tool for database elements.
Utilized TFS (Team Foundation Server).
Utilized SQL Server Management Studio.
Utilized Visual Studio 2013.
Utilized SSIS (SQL Server Integrated Services).
Created reusable test suite.
Started defect tracking on the data side.
Writing complex SQL for backend testing, ETL testing and data warehouse testing.
Certified Software Test Professional Practitioner Level (CSTP-P).
Implemented peer reviews of QA test cases.

Senior Quality Assurance Lead and Backend Tester

Confidential, West Des Moines, IA

Responsibilities:

Leading projects with teams as large as 15 to 20 people both on and offshore.
Implementing waterfall and agile methodologies.
Using Quality Center (QC) to trace test cases back to requirements and run metrics for upper management.
Utilizing Quality Center for 9 years and am proficient in all its capabilities.
Creating test plans and test strategies for large testing efforts while leading concurrent test initiatives.
Guiding requirement walkthroughs, analyzing business requirement documents, evaluating test cases, creating structured test plans, and constructing reusable test scripts.
Delivering time estimates and resourcing estimates based off the analyzed data of the business requirement document.
Working toward the time frame goals, assuring that QA projects are completed in a timely manner with thorough testing.
Using a risk based approach if timeline is unattainable.
Leading defect triage meetings.
Building interpersonal relationships while leading meetings with senior vice presidents and executive vice presidents.
Writing complex SQL for backend testing, ETL testing and data warehouse testing.
Certified Software Test Professional Practitioner Level (CSTP-P).

Quality Assurance Analyst

Confidential, West Des Moines, IA

Responsibilities:

Business Operations Analyst

Confidential, West Des Moines, IA

Responsibilities:

Automation Analyst

Confidential, Des Moines, IA

Responsibilities:

Worked on the automated application order entry systems of AnnuityNet and Affirm, which are online tools for agents to submit their policies for straight through processing (STP).
Used ADM Server to create PPfAs (product profiles for annuities) to use on both annuity systems. The PPfAs are built using XML and maintained on ADM Server.
Maintained PDF tags and XML conditions for PDFs to generate for the online tools.
Supported the National Securities Clearing Corporation (NSCC) feed for variable annuity licensing.
Set up broker dealers on the National Securities Clearing Corporation (NSCC) feed and worked to fix the errors and rejects that would occur on a day to day basis.
Managed Broker dealer mergers and selling agreements.
Utilized Financial Industry Regulatory Authority (FINRA), National Insurance Producer Registry (NIPR), and state insurance websites.