Test Cases Management

OBJECTIVE:

Over *+ years of experience as a QA Analyst in preparing Test Plan, Test Cases, Test Scenarios, Test Scripts, Test Execution along with hands on experience using testing tools, Defect Management and Defect Tracking tools, HP Quality Center, Quick Test Pro, Jira, TOAD, SQL Squirrel, MS Management Studio, DB Visualizer and SOAP UI in Client/server, Stand alone and Web based applications within Banking, Finance and Insurance domain.

PROFILE:

Over 5+ years of experience as a QA Tester in preparing Test Case Design, Test Cases, Test Scenarios, Test Scripts, Test Execution, Test Tool Usage, Defect Management and Defect Tracking, reporting and documentation in client server and web based applications for delivering utmost Quality Product.

Complete understanding of Software Development Life Cycle (SDLC), Software Testing life cycle (STLC) and defect life cycle along with waterfall and agile methodologies.

Expertise in creating test plan, test scenarios, test cases and traceability matrix.

Performed end to end system and integration testing to support quality deliverables and ensuring that the application adheres to established methodologies.

Conducted different levels of testing including but not limited to: Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Release/Production validation/deployment testing, Database Testing

Expertise in using configuration management tools like HP Quality Center and JIRA.

Hands on experience of Relational Database Management Systems (SQL Server and Oracle)

Experienced with most popular applications like Microsoft Office Project, Word, Excel, and PowerPoint

Versatile team player with good communication and problem solving skills with all management levels

Excellent analytical and problem solving skills with ability to understand and analyze complex issues

Team player with strong interpersonal, organizational and communication skills – both written and verbal with ability to interface with internal and external business and technical units

Ability to work independently with a minimum of supervision and be able to manage multiple project assignments and competing priorities under aggressive deadlines and pressure

TECHNICAL SKILLS

Operating Systems : Windows 98/2000/XP/Vista, W7

RDBMS : SQL Server, MS Access database management system, PL/SQL

Languages : MS Visual Basic, XML ASP, VBScript, Java Script, HTML

Others : MS office, Lotus Notes, Microsoft Visio, Microsoft Project

Server : MS Exchange, Windows server 2003

Databases : Oracle, MS SQL, DB2, MS Access

Testing Tools : Quality Center, Quick Test pro, Jira, Test Director, Selenium

PROFESSIONAL EXPERIENCE:

Client: Riverside Publishing (HMH), Itasca, IL January 2015 – Till Date Title: QA Analyst

Project: Online and Paper Testing and Reporting (Data Manager – online testing & Catalog E/7 – Paper base test)

Project involved testing of Data Manager which is a Web-based online testing, data and assessment management system, which puts a fast, powerful decision-support system at your fingertips. Designed to help educators meet the needs of every student and improve student performance, and allows wide range of data to provide longitudinal tracking and reporting of student assessment data, student demographic data, and program/event attendance, as well as professional development activities, paraprofessional activities, student grades and teacher data.

Responsibilities:

Involved in all phases of Software Development Life cycle throughout the project by designing and developing documentation for test strategy and test plan.

Worked in Agile environment with 3 weeks of sprint duration.

Worked closely with Systems Analysts, Architects, Developers, Testers and Project Managers.

Actively involved in analyzing business requirements and technical specifications for clarity, completeness, and gaps.

Created test plan, test strategy, test case, test scenarios, test data and expected result in HP Quality Center.

Executed Test Cases to check the Functionality, Database and Regression Testing.

Executed the test cases and compared the expected results with actual results.

Extensively involved in the Validation of mapping between Source and the Target data being loaded into data warehouse.

Involved in System Analyst Meetings to understand the physical and logical data modeling.

Involved in the validation of transformations rules applied on source data to load target tables

Extensively used SQL for retrieving data used for the data warehouse, Data Driven Tests to validate the same scenario with different test data

Wrote SQL queries for database verification and validation of tables which were loaded through ETL process.

Extensively used SQL to retrieve the suitable data from database and validate the data quality

Performed webserivce testing using SAOP UI tool.

Modified and maintained automation test script, and supported full end to end automation suit in selenium.

Executed regression suite after each hotfix/releases to test the existing functionality of an applications.

Conduct multiple review and walk-thru meetings for test deliverables.

Used Quality Center for developing and maintaining Requirements Traceability Metrics.

Performed UAT planning & execution with functional testing, regression testing and system integration testing.

Tested User Interface fields and various other functionalities as well as integration of different system as per the requirement.

Extensively used HP Quality Center for test management and execution of test cases and tracking, reporting and verifying of defect.

Created Custom SQL query to test the integrity of database.

Technical environment: ASP.NET, Java Script, HP QC & QTP, SOAP/UI, Windows 7, MS Office, Selenium

Client: Career Education Corporation, Schaumburg, IL February 2013 – December 2014

Title: QA Analyst

Performed manual testing for web-based application called AIU, CTU, and career schools that offer associate degree, bachelor’s degree, and non-degree program in career-oriented disciplines.

Responsibilities

Worked with the cross-functional teams to understand the data transfer from their application to our application

Participated in various meetings and discussed Enhancements and Project Change Requests

Used Quality Center as a repository for Test Plans, Test Cases and Defect Tracking all Scenarios and requests handled during application testing phase.

Performed black box manual testing of specific non-functional and functional test cases

Validated the data between sources to staging area and staging area to the targets

To ensure the correctness and quality data, created SQL queries to compare between source and targets after the data is loaded into the application

Performed smoke testing to validate the application for further testing

Performed integration testing between the cross-functional modules

Performed system testing to evaluate the system’s compliance with its specified requirements

Created reusable function using QTP/VBScript to enhance regression suite

Validated testing scenarios by implementing custom text checkpoint, image checkpoint, database checkpoint, and property checkpoint within keyword driven framework

Performed regression testing to verify program changes didn’t cause any unintended consequences

Decomposed requirements into test objectives and test conditions using Black box testing techniques such as equivalence class partitioning and boundary value analysis

Made extensive use of MS word and MS excel to prepare documents, generate reports and also document test procedure used in executing the test cases.

Technical Environment: HP QC, Win XP, Microsoft SQL Server, HTML, ASP.NET, VB, IE, Firefox, Microsoft Excel.

Client: State Farm Insurance Company, Bloomington, IL July 2011 – December 2012 Title: Software QA Tester

Project: Property & Casualty – Risk Analysis System – Workload Management for Referrals

The work that is scoped within the PAS initiative's Portfolio Management is the starting point for building the policy-by-policy portfolio management processes. The review of policies based on the claim trigger is the main focus of this project

Responsibilities:

Worked in Agile environment with monthly release and involved in Sprint planning, daily stand up and QA Test planning meeting.

Involved in all phases of testing process from test strategy, test planning, writing test case, executing test case, regression testing till deployment to Production as well as blockers discovered during deployment process.

Planed, Scheduled and Co-ordinated testing tasks in HP QC

Created test data based on the test conditions and business rules to be covered

Reviewed requirements and created different functional test cases based on FRD.

Involved in defects logging and status meetings with different project members.

Coordinate with developers for resolution of defects.

Involved in system and integration testing for multiple applications.

Coordinate with developers for resolution of defects.

Prepared status summary reports with details of executed, passed and failed test cases.

Created traceability matrix to ensure coverage between requirement and test cases.

Performed End-to-End testing manually.

Technical environment: HP QC, Win XP, Microsoft SQL Server, HTML, ASP.NET, VB, IE, Firefox, Microsoft Excel.

EDUCATION:

Master of Computer Applications, Gujarat, India April ‘13

B.Sc. in Bioinformatics, Gujarat, India May ‘11

Contact this candidate