Resume

Sign in

Data Quality Assurance

Location:
Mason, Ohio, United States
Posted:
November 05, 2018

Contact this candidate

Resume:

Professional Summary

Around * years of experience as Quality Analyst with emphasis on Quality Assurance, Manual testing of ETL, Database, Client/Server and Web based.

Worked closely with Development and Product Marketing to analyze technical and business requirements and offer technical feedback for numeral projects in aggressive biweekly agile lifecycle.

Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and using Oracle, DB2, and UNIX.

Experience in all phases of Software Testing life Cycle (STLC), Software Development Life Cycle (SDLC) methodology likel, water fall and agile methodologies such as Sprint and Scrum.

Extensively worked with integration testing, functional testing, regression testing, data-driven testing, back-end testing, end-to-end testing, UAT, Stress testing and Performance Testing.

Executed System Integration testing (SIT) and Regression testing for all critical healthcare transactions.

Strong background in Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing.

Tools

TOAD, WinSQL, SOAPUI, Putty, Postman

Database

Oracle, SQL Server, MS DB2, Teradata, Netezza,

Testing Tools

ALM,HP Mercury Tools (QTP9.0, Win Runner, Test Director, Quality Center9.0),

Data Warehousing Tools

Informatica, Data stage, Teradata, Business Objects XI R2/3.1

Test Strategies

System, Functional, Regression, Black Box, UAT, Integration.

Client: Grange Insurance Group April 2017 till date

Role: Quality Assurance

Expertise in database querying, data manipulation and population using SQL & PL/SQL in Oracle and SQL Server.

Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications and GUI-less SOA Web Services.

Executed backend data-driven test efforts with a focus on data transformations between various systems and a data warehouse.

Responsible for designing and implementing QA/Test best practices in an agile environment using proven quality assurance techniques, test automation, white and black box testing, and operate in a continuous integration build environment.

Worked on REST methods and SOAP based Web services testing.

Posted the different message to MQ queues and monitor the Q depth and verify in the data base events are updated.

Attend daily scrum calls with customers and provide status on testing progress and provide Test status & Defect status reports.

Client: BankAmerica, TX Oct 2014 to Jan 2017

Role: Sr. Quality Assurance Analyst

Designed & Created High level test cases based on the BRD Also referred Technical Design document, Source to Target Detailed mapping document & Transformation rules document to derive test cases for functional testing.

Designed traceability matrix that helped perform impact analysis to changed requirements and ensured traceability of business requirements to Test cases.

Extensively worked as SOA testing and followed by Agile/Scrum methodology.

Extensively worked in stand-alone application using XML Schema, XML Messaging and XML based Web Services using SOAP.

Involved in testing during migration phase of different applications and database.

Responsible in planning the entire Load test process based on the performance requirements document of the Application.

Developed complex SQL queries using joins, sub queries to test data tables against the source and target

Execute of the regression tests for the various testing cycles using HP ALM.

Tested services level for Rest (GET/POST/DELETE)

Client: American Airlines, TX Jan 2014 to Sep 2014

Role: Quality Assurance Analyst

Tested tracking for flight information with AWB (create an awb, accept awb, setup the in ternary, build the pieces for out bound and inbound.

Tested US Airlines acquisition code merge with ticket processing and Line processing.

Interacted with Business analysts and Development team to review design documents, developed Identity Management test plan, Use cases and test results summary documents.

Validated data and performed database testing using SQL queries and Joins

Conducted Smoke (environment readiness check), System Integration (End-to-End) and Regression Testing.

Did reports validation by checking backend data using SQLs.

Actively participated in all agile ceremonies (release planning, sprint planning, user stories refinement, scrum meetings, retrospective, sprint review)

Analyzed business requirements, Functional Specifications and Use Cases to create test plan.

Interacted with designers to understand the application functionality and navigational flow.



Contact this candidate