Sql Server Testing

Swathi Reddy

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

Ph: 609-***-****

SUMMARY

• Over 2 years of extensive experience in the analysis, development and testing of software applications.

• Extensively worked on Financial, Banking and Insurance Applications.

• Experienced in QA methodologies and Software Development Life Cycle (SDLC) from Requirement

analysis to User Acceptance Testing.

• Extensively involved in creation of Test Plan, Test Cases and Test Scripts.

• Highly Proficient in testing Client/Server and multi-tier Web applications.

• Solid Experience in automation tools SoapUI, QuickTestPro and Manual tools TestDirector,

QualityCenter.

• Developed Traceability Matrix as a part of QA Process development.

• Proficient in writing Quick Test Pro VB Scripts.

• Experience in Unit, Build Verification (Smoke), GUI, Web, Security, Interface, Compatibility,

Functionality, Regression, Integration, System, Performance, User Acceptance and End to End Testing.

• Testing experience in both UNIX and Windows platforms, including troubleshoot and resolve issues related to

client/server and web applications.

• Experience working with the Agile (Scrum) methodology.

• Experience in database testing like Oracle, Sybase, SQL Server and MS Access 2000.

• Experienced on Java, JavaScript, C, VB, VBScript and Shell Scripting Languages.

• Expert in Back-End testing using the tools TOAD for Oracle, SQL Query Analyzer for SQL Server and

SQL Explorer for DB2.

• Experienced with Ms Project and Ms Office Tools like Ms Word, Ms Excel and Ms Access.

• Experience with Document Object Model (DOM).

• Ability to interact with developers and product analysts regarding testing status and Defect tracking.

• Strong interpersonal, analytical, communication and organizational skills with the ability to work

independently or in a group.

TECHNICAL SKILLS

Languages C, JAVA, SQL, PL/SQL, Transact-SQL, Shell Scripting,

Platforms MS-DOS, UNIX, Sun Solaris8.0/7.x, Windows 9x/NT/2000/XP

Testing Tools Test Director 8.2, WinRunner 8.2, Load Runner 8.0/11.0, Quick Test

Pro 9.5/10.0/11.0, Rational ClearQuest, Rational Functional Tester,

Quality Center 9.2/9.5/10.0,SoapUI 3.0

Domain Knowledge Financial, Banking, Health Care and Insurance

Databases Oracle 8i/9i/10g, Sybase, MS SQL Server 2000 and DB2

Web Technologies HTML, HTTP, XML, ASP, VB Script, J2EE, Java Servlets, JSP, Java

Script

DWH Tools Informatica Power Center7.1/6.2/5.1.2, Cognos 8.1/8.2

EDUCATION

Bachelors in Computer Science, JNT University, Hyderabad, India.

CERTIFICATION

OCJP – Oracle Certified Java 6 Programmer (IZ0-851)

Candidate ID: OC1199789

WORK EXPERINCE

TD Bank, Mt Laurel, NJ April 2012 – Dec 2012

QA Analyst

Project: Research Analysis Application

RAA is Research Analysis Application which offers Money Managers Research information and

Report generation for the TD Research Analysts. This consist of a web based J2EE application (RAA)

and Java based Feeder Engine tool, which receives money managers information every month, such as

performance (Risk /Returns), market cap, revenues, strategies, asset class and holdings for different

financial institutions (Money Managers) from some of financial vendors (Vestek, Russell, Bloomberg,

Reuters, Merrill etc) in various formats such as CSV, Microsoft Excel, XML files. This system was

designed to simplify and automate the Research Analyst Workflow. These files are fed into the RAA

Sybase database through Feeder Engine tool from where Research Analyst uses the Money Managers

information through RAA web application to evaluate and report their performances.

Responsibilities:

• Reviewed the Business Requirements document with the business and development team to understand the

architecture and functionality of the application.

• Responsibility included Preparing Test Plan, Test Cases and Test Scripts.

• Derived test cases from Use Cases and Design Document.

• Created Test Scripts for Regression testing using QTP.

• Automation Framework experience with Keyword driven Approach for QTP.

• To Speed up the test execution, developed generic scripts using descriptive programming.

• Generated Data Driven scripts that access the backend database.

• Accessed all the HTML elements (Input elements, Hidden elements, Inner Text and DIV) in the

web page using the DOM (Document Object Model).

• Integrated QC and QTP to run scripts from QC.

• Developed test cases and debugged the Java Code.

• Made extensive use of Quality Center to log the defects in the Defect tab and to manage the Test

Scripts in Test Plan Tab and Test Run Status in Test Lab.

• Extensively used Quality Center to manage requirements and map those requirements to Test

Cases.

• Performed Cross verification of logs in UNIX by using putty.

• Performed Web Services testing.

• Extensively used SQL Queries to retrieve data from databases.

• Worked closely with Developers by following the Agile (Scrum) methodology.

Environment: QTP 10.0/11.0, QC 9.5, Load Runner 8.0, Java/J2EE 2.0, JSP, EJB, HTML, VB Script,

Sybase, Web Services, SoapUI 3.0, SOA, XML, Windows XP Professional and UNIX.

TCS-JPMC, Bangalore, India Jul 2009 – Jan 2010

QA Analyst

Project: Enterprise Shared Services

Enterprise Shared Services deals with Wells Fargo Credit Card Services. This application enables users

to check their activity, statements, pay bills, Chargeback disputes for damaged goods paid for with credit

card, dispute billing errors and fraudulent purchases, check their Rewards and Redeem them, Balance

transfers, Cash back on purchases.

Responsibilities:

• Analyzed Functional Requirements, Use Case documents and created the QA artifacts test

plans, test cases and test scripts.

• Responsible for testing modules Chargeback, Fraud and billing errors, Rewards and Redeem,

Balance Transfers and Cash back.

• Responsible for executing manual and automated testing, identify and report application defects.

•Worked closely with development and business teams to ensure the requirements are consistently

met.

• Developed the Traceability Matrix in QC.

• Involved in test cases review to score the test cases coverage.

•Created and Executed Automation Test Scripts for Functional and Regression Testing using QTP.

• Parameterized the scripts in QTP to run the scripts for multiple sets of data.

• Automation Framework experience with Keyword driven Approach for QTP.

• Accessed all the HTML elements (Input elements, Hidden elements, Inner Text and DIV) in the

web page using the DOM (Document Object Model).

• To Speed up the test execution, developed generic scripts using descriptive programming.

• Generated Data Driven scripts that access the backend database.

• Performed Calculations and Validations on %Cash back for purchases made on bonus

categories, online purchases and all other purchases.

• Used QC to invoke the scripts and initially performed the baseline testing and organized all the

scripts systematically and generated reports.

• Performed Unit Testing in Java.

• Prepared daily summary report for tests executed.

• Participated in Walkthroughs and Review Meetings.

• Identified and documented all the defects to ensure application software functionality for present

as well as future builds using Quality Center.

Environment: QTP 10.0, QC 10.0, Java, J2EE, HTML, TOAD, Oracle 9i, VB Script, Windows 98/NT, UNIX.

TCS-Aviva, Bangalore, India April 2008– Jun 2009

Role: Test Analyst

Description:

AVIVA is one of the leading insurance companies in UK. The application helps the field agents of the

company to enter prospective customer’s data. The application also calculates the amount of premium

required, cash value and benefit amount for the years in consideration. In this system, registered

members with AVIVA can get details of their LTC (Long Term Care) insurance, change the term of their

coverage and also use the premium calculator to determine the new premium.

Responsibilities:

• Reviewed and analyzed Business Requirements and Functional design documents, and derived Test cases

from them.

• Extensively involved in writing the Test cases and Test scripts to perform Manual Testing.

• Responsible for testing a web-based portal that enables customer to calculate the amount of

premium required, cash value and benefit amount for the years and ensured functionality, design

conforms to User requirements.

• Developed and exported test cases to Test Director and mapped all test cases to the business

requirements/rules.

• Performed Java Unit Testing.

• Developed and executed SQL queries for back-end testing in SQL Server.

• Documented test results and SQL outputs and provided daily execution status to Team Lead.

• Conducted Sanity Testing, Documentation Testing, Browser Compatibility Testing, Installation

Testing, and System Testing.

• Participated in the team meetings to discuss the issues arising out of testing.

Environment: Test Director 8.2, Java, Web Server Services ( IIS) 5.0, SQL Query Analyzer, SQL

Server 2000, Windows 2000/NT

Contact this candidate