Test Cases Sql Server

Location:

Posted:

February 02, 2015

Payal Arora

Email:************@*****.***

Legal Status: Citizen

Summary

• Manual Tester with around 3 years of QA experience in testing IT projects in different environments like

Client/Server applications and Web applications.

• Good Experience in testing of web-based and client/server applications in areas like GUI, functional,

performance, regression, integration/system and user-acceptance testing.

• Experienced in coordinating with functional and technical teams in developing test cases/scenarios.

• Experience in analyzing Functional/Technical requirements and develop Test Plans, Test Strategies,

Test Scripts, Test Cases and apply them as per the company standards.

• Possess good interpersonal skills with Strong communication, analytical and learning skills.

• Dedicated and committed team player.

• Good Understanding of SDLC.

PROFESSIONAL EXPERIENCE:

Feb 2012 – to date (Prudential Financial, Newark NJ)

QA Analyst

Working on Annuities Valuation System (AVS) which is a Database centric application used for Statutory

and Tax Financial Reserve Reporting.

It also has MS ASP web interface for displaying admin data, run results and summary reserve reports.

AVS is used by our actuaries for financial reporting for Statutory and Tax purposes and also future

projections. AVS also has 5 different Whatif Regions for our actuaries to test various market projections

and scenarios.

Roles and Responsibilities

Attending Functional and Technical walkthrough’s for Test Planning

•

• Creating and Executing Test Cases as per Functional Design Document

• Testing and documenting the Defect for the application with follow-up on closure of defect

via retesting. Logged the defects in HP-ALM.

• Co-ordination with Developers on reporting defects.

• Testing the flash and summary report on the web.

• Creating SQL queries & Joins on tables to ensure valid data in the database.

• Support testing on 5 AVS-Whatif regions used for whatif projections and scenarios.

Environment: Sql Server 2005, Autosys, Microsoft ASP 2.0, HTML, Javascript, Windows Batch

programs, HP-ALM.