Qa Analyst

Anureet Kaur

Quality Analyst / ETL Tester

E mail: a ******.****@*****.***

Mobile: 240-***-****

Professional Summary

5+ years of extensive experience in Software Quality Assurance in web based applications as well as

backend testing.

Worked in both Agile Methodology as well as Water fall Approach of Software design.

Extensive experience in Backend testing involving Database and ETL Testing and verification.

Extensive experience in reviewing Business Requirement Documents, Software Requirement

Documents and preparing Test Cases, Test scripts and Execution.

Extensive experience in Functional testing, Integration/System testing, Regression testing and User

Acceptance testing.

Involved in developing and maintaining Test Matrix and Traceability Matrix as well as performing

Gap Analysis

Expertise in Backend Testing and Data Driven Testing

Experience in Oracle and Postgres database manipulation using SQL, PL/SQL.

Ability to effectively analyse a variety of Performance and Summary Reports

Strong knowledge of Software Development Life Cycle (SDLC), Quality Assurance Life Cycle

(QALC) and Defect Management Life Cycle Methodologies.

Experience in Analysing and Documenting Business Requirement Specifications and System

Requirement Specifications using use cases, gap analyses.

Developed Test Strategy, Test Plan, Test Cases (Functional and Non-Functional) Test Scenarios from

System Requirement Specifications according to the Business requirement.

Possess excellent skills in GUI Testing, Functional Testing, Regression Testing, Stress Testing,

System Integration Testing (SIT), User Acceptance Test (UAT).

Experience in Database testing by using Oracle database Server, SQL, and PL/SQL Queries.

Generation of Bug (Defect) Reports, tracking the status of defects and analysing the bugs using QC

and other tools.

Maintaining the Traceability Matrix, Test Data Matrix and Status reports related to project.

Technical Skills:

Testing Tools : Quick Test Pro10.0, Quality Center 10.0

Defect Tracking Tools : JIRA, Quality Center

Web Technologies : JSP, HTML, JQuery, Web Services

Databases : Oracle 10/11g, Postgres

Operating Systems : Windows, LINUX

Languages/Tools : Java, Informatica 9.1/9.5, SOAP UI, SQL, HTML

Web/ Application Servers : IIS, Apache, Weblogic 9.2, JBoss 5.1

Technical Experience

Edaptive Systems, Owings Mills MD Dec’13 - Till Date

QA Analyst/ETL Tester

Project Description:

CMS is establishing a Transformation-Medicaid Statistical Information System (T-MSIS). T-MSIS

provides development and system support for the ongoing efforts to work with states to improve

Medicaid and Children’s Health Insurance program (CHIP) data and data analytic capacity through the

Medicaid and CHIP Business Information Solutions (MACBIS) initiative. The project utilizes agile

methodology using Informatica as the development tools

Responsibilities:

• Work closely with development and business analysts to develop test cases

• Participate in an Agile Scrum development environment

• Execute test scripts utilizing HP Quality Center/ALM and provide Test Summary Reports for

review

• Identify test scenarios and create sample files.

• Creating set of reusable valid/invalid files and corresponding SQL queries for QA team that can

be used for defect verification/regression testing.

• Track and report defects from discovery to successful correction, validation and verification

• Coordinate work activities with other project team members

• Participate in requirement and test case peer reviews

• Develop test cases and execute scripts for data validation/ Business rule validations.

• Test issues of varied scope and complexity

Environment: Informatica Power Center 9.5, Linux, XML, Shell Scripts, Oracle, Agile Methodology

VetStreet.com, Silver Spring MD Feb’13 - Oct’13

QA Analyst/Backend Testing

Project Description:

Vetstreet’s mission is to serve the 10,000 strong veterinary communities by connecting pet owners to their

local vets, resulting in better client relationships and better health for pets. Vetstreet provides the

veterinary community with client acquisition and online communication tools designed to strengthen the

bond between the pet owner and their veterinarian. The range of services that are offered by Vetstreet

includes clients (and their pets) management for VET hospitals, targeted marketing campaign

management for hospitals, online store networks supported by big distributor networks. It consists of

separate portals for Admin, hospitals and clients.

Responsibilities:

• Review Business Requirements documents and create Test plan and test cases for functional

testing.

• Conducted functional testing and backend testing for various campaign.

• Conducted End to End UAT testing for various campaign including UI, ETL jobs and

communication components.

• Interacted with the Developers and design team for technical design and problem resolution

• Creating Testing walkthrough and test plan for UAT/Business team.

• Involved in Bug Review meetings and participated in weekly meetings with Business/PMO team.

• Provided testing results and weekly status reports to the QA Manager

• Verified the Web screens against the creatives(mockups) provided by business team.

• Validated the data on screens against the database

• Maintained Metrics and participated in weekly status updates showing the progress of the testing

effort and open issues to be resolved.

Environment: .NET, Postgres, Windows,JIRA, XML, Informatica, Agile Methodology

HNS, Germantown, MD Sep' 11 to Feb’13

QA Analyst

Project Description:

This project is related to broadband internet service for market covering Africa and Middle East. This is

for a Client based in Abu Dhabi to provide satellite based high speed internet connection in parts of Africa

and complete middle east. Complete solution for this is provided and hosted by Hughes.

Responsibilities:

• Reviewed the Requirements documents and created the Test plan and test cases for functional

testing.

• Conducted functional testing for ordering module.

• Conducted End to End UAT testing for system that includes Ordering, Billing, CRM and Gateway

modules.

• Interacted with the Developers and design team for defects and problem resolution

• Worked with transactions and validated the data by using SQL.

• Generated Bug Reports and Test case coverage reports for status meeting and also involved in

resource planning for test cases coverage

• Involved in Bug Review meetings and participated in weekly meetings with management team.

• Provided testing results and weekly status reports to the QA Manager

• Verified the Web screens against the mockups provided by client.

• Tested the SoapUI Web services for Provider and Member portals

• Performed regression testing by repeated execution of test cases in each build by logging defects

in Defects tab in Quality Center.

• Validated the data on screens against the database

.

Environment: JBoss 5.1, SQL Developer, Oracle 11g, UNIX, FTP client, Java, Quality Center,

DETS(Inhouse Tool), XML

WA MMIS State Project, Gaithersburg, MD Dec'09 to Sep'11

QA Analyst/ BACK END TESTING

Project Description:

WAMMIS will provide a higher standard of health care coverage and improves the quality of care for

every member. It sets the standard for outstanding quality health care, service and value. It is the leader in

access, affordability and quality in the competitive health insurance market.

Responsibilities:

• Reviewed the Requirements documents for X12 Transactions and created the Test plan and test

cases for HIPAA EDI Transactions for Iteration Testing, Integration Testing and System Testing.

• Conducted functional, system, data and regression testing.

• Interacted with the Developers and BA for defects and problem resolution

• Wrote SQL statements to extract data from Tables

• Worked with transactions and validated the data by using SQL.

• Generated Bug Reports and Test case coverage reports for status meeting and also involved in

resource planning for test cases coverage

• Involved in Bug Review meetings and participated in weekly meetings with management team.

• Provided testing results and weekly status reports to the QA Manager

• Verified the Web screens against the mockups.

• Tested the SoapUI Web services for Provider and Member portals

• Performed regression testing by repeated execution of test cases in each build by logging defects

in Defects tab in Quality Center.

• Involved in testing HIPAA EDI Transactions

• Involved In loading the flat files into Oracle Database and involved in writing Complex SQL

Queries.

• Involved in writing Complex SQL Queries using TOAD to validate the loads.

• Validated the data on web screens against the data points and database.

• Validated the data on screens against the database

Environment: Websphere, Jboss 5.1, TOAD, Oracle 11g, MS Office, UNIX, FTP client, Java, Quality

Center, QTP, XML

Contact this candidate