Sqa Analyst Resume
Centennial, CO
SUMMARY
- 7 Years of diversified IT experience in Quality Assurance, Validation, Testing Client-Server and Web based applications.
- Experience in functional, regression, UAT, Back End/Database Testing and stress / load / performance testing of web-based and client-server applications using Mercury Interactive Test Suite:, Load Runner, QuickTestPro and Quality Center
- Excellent experience in Defect Management and Bug Reporting using bug-tracking tool such as HP Quality Center (QC) and JIRA.
- Proficient in Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
- Extensively worked on various Testing Models like Waterfall, RUP, Agile, v-Model, Scrum.
- Expertise in developing automation test scripts using QTP, by creating Actions, checkpoints, Data table, Parameterization, Descriptive Programming and by adding User Defined functions.
- Extensive experience in Functional testing, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, System Testing, Build Verification Testing, User Acceptance Testing, Performance Testing, Load Testing, Stress Testing as a Black-box Tester.
- Proficient in Testing methodologies ,Test Matrices and Traceability Matrix
- Proficient in writing test plans for the functional and system testing, execution of test cases to verify actual results against expected results.
- Involvement in Project Planning, Coordination and implementing various QA methodologies.
- Extensively worked on Performance testing and analysis by monitoring run time scenario status and analyzing different graphs & reports generated in load runner and also analyzed the average CPU usage, Response Time for each scenario.
- Experience in analyzing Business requirements, use case and design specification documents and developing Test Plans, Test scripts and Test Cases for both functional and automated testing.
- Experience in doing Compatibility Testing for multiple browsers such as IE , Mozilla, Safari , Opera
- Executed Intermediate/Complex SQL queries to perform back-end database testing
- Expertise in Back-end testing using SQL queries on relational database systems (RDBMS) like Oracle, SQL Server, SYBASE and DB2 etc.
- Experience working on Unix Shell and testing Log files
Tools:
Win Runner 8.2/7.0, Load Runner 9.5, HP Quality Center 11.0,Quick Test Pro 8/9.2, Requisite Pro 7, Test Manager, Clear Quest 7.0, Rational Functional Tester, Sub version, Rational Robot, BOXI Reports, Microsoft Visual Source Safe 6.0.
CM Tools:
PVCS Version Manager 8/7, Clear Case 7.0
GUI/Languages:
TOAD 11.0, SQLPLUS, TSQL, HTML, JAVA, VBscript, ASP, XML, Developer 2000 (Forms 6i, Reports 6i), Visual basic 5.0/6.0, Business Objects 5.1,, MS SharePoint2010,C/C++,C#.Net,ADO.NET,ASP.NET.
Web Server:
Web logic 5.0, MS IIS 5.0/6, JBOSS, APACHE.
Databases:
Oracle 10g/9i/8i, MS-Access, MS SQL Server 2005/2008, DB2
Software:
MS-Office 2003/2007, MS Word, MS Excel, MS Power Point
Operating Systems:
Windows XP/2003/Vista/7, MS DOS 6, Sun Solaris UNIX 10, RH Linux ES3
EDUCATION:
B.Tech (Computer Science), Confidential,University, India.
PROFESSIONAL EXPERIENCE:Confidential,Centennial, CO April 2011 till Date
SQA Analyst
SPICE, CARE
SPICE is a fully scalable, customizable, and dynamic index calculator capable of real-time and historical multi-currency calculations.
Responsibilities:
- Understand the requirements and formulate the test specifications including test plan and test scenarios based on requirements.
- Worked with Business Analyst regularly for developing test cases from the Business Requirements and ensured complete test coverage
- Analyze use cases and detail system designs for testing scenarios
- Developed traceability matrix to map Business and Functional requirements with test cases
- Define test strategy and test plans based on product requirements and functional specifications
- Worked with SQL queries for data manipulations
- As a Scrum Team member contributed significantly to the new development methodology (Scrum) and planning for future releases.
- Involved in steps 2–4 for every iteration (Sprint) until the goals of the project were met, or the product owner determined that sufficient product backlog items have been delivered.
- Involved in defect Triage meetings with developers and entered the bugs on the basis of the severities in the Quality Center
- Developed Shared Object Repository and VB Script Function Library file using Parameterization, Regular Expressions, Checkpoints, Recovery Scenarios using QTP
- Identified test cases to be automated and involved in developing Test Automation Framework using Quick Test Pro .
- Develop, Enhance, and Maintain automated testing scripts with Quick Test Pro for Regression Testing
- Designed and scripted detailed test cases in Quality Center for regression scenarios
- Prepared test strategy and test plan documents for new enhancements.
- Executed the scripts with different sets of data using Data Driver Wizard in Quick Test Pro (QTP)
- Used TOAD for querying and testing the data which is retrieved from development database
- Produce detailed UAT and System test cases that are still used
- Collect test metrics and report them in a systematic fashion
- Experience in configuring and administrating Quality Center for creation of workspace, user management and customization
- Managed the automation of the test cases for Regression Testing, GUI and Functionality testing
- Responsible for automating new applicable tests into the automation framework
- Coordinate testing activity wherever required for both onsite and offshore team
- Manage Defect Management Process in Quality Center and interact with the developers to resolve technical issues/ incidents
- Participated in daily scrums to effectively communicate the progress and road blocks in order to deal with the constantly changing requirements.
- Responsible for uploading test plans, test scripts into Quality Center
- Involved in tracking, reviewing, analyzing and comparing defects using the Quality Center
- Developed SQL queries and executed them in Oracle and SQL Server to perform backend testing
- Analyze and identify potential problems, and work closely with development and systems engineering teams to identify and resolve technical issues
- Prepare detailed Test Summary Reports
Environment: Windows 7, Oracle 9i, UNIX, SQL Server 2008, Quick Test Pro 9.0 , Quality Center 11.0, Bug Tracker, .Net, ASP.net, MS Project, UML, Visio, MS Office Suite, Agile/scrum methodology
Confidential,Wheatridge CO Feb 2010 – March 2011
SQA Analyst
Broadridge is a leading full-service outsourcing provider to the global financial industry, capable of meeting the most demanding requirements for efficient, secure and scalable operational support. Penson Financial inc, Canada bought Broadridge’s ridge solutions and the project is to accommodate the changes requested by Penson CAN. The Project is called “Provisor to Aspire”, The Brokerage desktop applications are developed in Java.
Responsibilities:
- Performed Negative Testing and Positive Testing manually.
- Develop and execute manual and automated test scripts that test the functionality, interfaces, performance, and data integrity of the system
- Prepared Load test cases/scenarios and executed for the key functional areas.
- Updated Test Cases and Re-tested the application after requirements changed.
- Mapped the requirements with the Test Cases
- Performed System Testing, Regression Testing, Function Testing and Load Testing.
- Reviewed many BRD’s for key functionality like Account activity, Order status, Profile, Mutual funds, Snapshot modules etc.
- Performed GUI testing as well as back end testing for Sybase database to check the data flow and data validation.
- Prepared the load test scripts and performed Load testing for the key functionality to make sure the applications perform to the standards before system went live
- Involved in preparing QTP scripts and executed to make sure the functionality works as expected
- Contributed to post-implementation and production support when required.
- Worked on various front end and back end web application clients like Aspire , Provisor, Homba, Davidson, Banker, Edwards Jones , Blainr, BarClays , Penson Canada , Possi , FMS Bonds and Peoples.
- Backend Testing of the application was performed by writing SQL queries for Sybase.
- Created and documented the Test Designs for each functional area mentioned in Test Plans
- Reviewed the Test Designs with QA team members and technical analysts
- Developed Test Cases and verified actual results with expected results
- Created and maintained the QC Plan & Test Strategy document
- Defect reporting and tracking was done using Quality Center.
- Closely interacted with developers to fix bugs, track changes and modifications and/or enhancements.
- Involved in documenting various testing reports and results using Quality Center.
- Actively participated in project meetings and discussions
- Involved in verification of the GUI, Functionality and Usability Testing of the Web application manually.
Environment/Tools : Quality Center, HP Load Runner, QTP, Java, SYBASE, MS Office, UML, Visio
Confidential,CT Aug 2009 – Feb 2010QA Analyst
Priceline.com is the leading travel service for value-conscious leisure travelers. Priceline.com travel service gives customers more ways to save on their airline tickets, hotel rooms, rental cars, vacation packages and cruises. Online travel shoppers frequently bounce between multiple Web sites before making a purchase. Even customers that use only one OTA often run similar searches over multiple sessions before buying. On the Priceline site, for example, air and vacation packages customers typically perform three searches per browser session. Hotel and rental car customers perform two searches. When a customer returns to the site after a session, he or she will see the prior session’s searches, and perhaps a few earlier ones, as well. By remembering the customer’s last few searches, we can reduce the time and effort required for the return customer to repeat or modify a search. This will increase user satisfaction, increase search volume, and should ultimately increase overall purchase volume.
Projects: Rental Car Conversion to JSP, DINC, Priceline Price Breakers, Rental Car Conversion from ASP to Java Technologies (JSP).
- Analyzed Business, Functional Requirements and automated test cases for both positive and negative tests.
- As a part of AGILE team I was involved in Project planning session for Estimating of the time and labor for executing the test cases
- Built the QC 9.2 Architecture for better understanding the Capability and Sub Capability structure
- Worked on creating Keyword driven automation framework for testing web application.
- Created QTP Driven scripts which executes all or selected manual test cases in Quality Center or Excel sheets.
- At the end of each sprint participated in Sprint Review Meetings where the team delivers the product backlog items they committed to.
- Participated in Sprint Planning meetings with everyone working on the project, including the business-focused team members and the development team members.
- Developed Shared Object Repository and VB Script Function Library file using Parameterization, Regular Expressions, Checkpoints, Recovery Scenarios
- Customized Classes, created new methods, override existing methods as required for automation.
- Developed & updated automation scripts using Quick Test Pro on different functionalities of the application
- Performed Data Driven Test using the test Data from Data files, Excel files etc
- Used Quality Center as a central repository to store manual test cases, automated QTP generated scripts
- Developed and maintained automated test scripts using Quick Test Pro on different functionalities of the application
- Identified all the Properties of Object Repository to ensure that each object is recognized by the script using Object Spy in QTP
- Involved in development of test cases for Java application. Automated test cases for each valid transaction and reported bugs.
- Performed System Testing, Regression, Integration Testing.
- Used customized and built-in Exception Handlers to make sure the scripts work in unattended mode
- Created Classes and Methods in order to work with Custom Objects as well as standard Objects.
- Wrote Automation scripts in order to perform back-end testing by running SQL queries on Oracle Database.
- Created Scripts which can dynamically create the Queries based on the mapping document and executed them.
- Responsible for validating the quality of data in the reporting mart for campaign purposes.
- Responsible for testing and sending out the status reports on weekly basis.
- Responsible for updating and maintaining the Keyword Driven Automation scripts and Quality Center for all the defects found during functional and regression testing and following up the bug life cycle.
- Conducted meetings to turnover test cases to Regression team.
- Performed Integration testing to validate integration between sub modules of the application.
- Tested the Quality Center 10.0 Beta version to know how it affects the testing process.
Environment: Quick Test Professional 9.5, Quality center 9.2, Quality center 10.0, SQL, Oracle SQL PLUS, Java, J2EE, Exceed 2008(UNIX Solaris), MS Excel
Confidential,Billerica, MA Jan. 2009 – July 2009Senior QA Analyst
Description: Protection of personal identities and assets demands a better way to verify that an individual is who they claim to be and that the credentials presented as proof of identity are valid.
Responsibilities:
- Setting up the QA environment by installing all the hardware devices and software applications.
- Define and write program specifications and Test Plans.
- Review Use Cases and Create Test Cases based on it.
- Create UAT Test Specs based on the BRD documents.
- Involved in Database testing and executing SQL Test Scripts.
- Writing T-SQL queries to fetch the data from the database and validating the data.
- Followed Scrum Methodology through the programs.
- Interact with the Business Analyst and Developers from the project.
- Maintain Functional and Technical documentation.
- Identify inefficiencies in, and recommend changes to, IT practices, procedures, and approach to customer service.
- Testing the Database, Web Services and Smart client applications.
- Testing Capture and Document Authentication software.
- Testing Facial Recognition software.
- Verifying printed cards based on the Card design document.
- Verifying all security features for printed cards(Digital water marking)
- Reviewing defects with the project team.
- Worked on Domestic and International programs.
- Experience with Configuration management tools like Tinderbox and Perforce(source control)
- Developing Test Coverage report to QA Manager.
Environment: Asp.Net, C#.Net, AJAX, SQL Server 2008, SQL, Agile/Scrum Methodology, Oracle 11g, Web Services.
Confidential,NJ May 2008 – Jan. 2009
Software QA Analyst
Automated Case Management System (ACMS).
The Automated Case Management System (ACMS) is a case tracking and case management computer System utilized by the Civil Courts within the State of New Jersey. ACMS is designed to store and process information about the various cases that are placed on Civil Court Docket. The system is designed to follow a case from the receipt of the initiating document (Usually complaint) through the stages of filing subsequent documents, associating attorneys to the parties, recording monies received and scheduling. Since now ACMS is being converted from IDMS to DB2/CICS so I am responsible to test all the screen using the automated tools as well as check the business rules manually.
Responsibilities
- Developed the test plans and test procedures used for manual Testing.
- Performed functional, Web, Database and regression testing using Win Runner.
- Involved in project coordination and implemented QA methodology.
- Wrote Test Cases for more than 50 screens in according with the business logic.
- Involved in review of the Business Requirement Specification Document and the Technical Specification of the application.
- Reviewing various Business Applications of ACMS: Extensive interactions with the Subject Matter Experts and creating Test Matrices and Test Plans for various levels of testing.
- Interaction with developers, discussing the Specifications provided by the Analysts and also the changes and the discrepancies in the application.
- Using Load Runner analyzed the response times of the business transactions under load. Developed reports and graphs to present the stress test results to the management.
- Involved in writing data load automation scripts using WinRunner Terminal Emulator add-ins.
- Performed Load and Stress Test Using Load Runner.
- Experience in identifying the performance bottlenecks using load Runner
- Analyzed various graphs generated by Load Runner Analyzer including Database Monitors, Network Monitor graphs, User Graphs, Error Graphs, Transaction graphs and Web Server Resource Graphs.
- Performed Load /Performance testing by Load Runner & manually by making the large number of users logging into the system and thus tested the performance of the application under load at various times.
- Involved in performance testing of the security modules- created and executed load tests against the application using the Load Runner tool and analyzed the stress behavior of the application.
- Capturing key business transactions to verify Key components of applications such as response from database tables, links, Images, view multiple browsers like IE 6, Mozilla Firefox 3.
- Executed GUI and functional tests of statistics application.
- Involved in testing the performance of the Application using Load Runner.
- Tested various links of Home Page, text-hyperlinks, image-hyperlinks and Web based applications.
- Developed and executed automated regression scripts / test scripts using WinRunner Terminal Emulator.
- Checking the processing and handling of cases in different courts: Civil law, Criminal, General Equity, Special Civil Part and Foreclosure statewide, understanding the business side and checking the working of the application according to that.
- Creating the Automated Scripts using WinRunner 7.6 on Mainframes (Terminal Emulator) 3270 IDMS version.
- Running the Automated Scripts on DB2/CICS version.
- Used Test Director 8.0 to log all the defects.
- Checked all the DB2 screens against IDMS screens and kept the tracks of inconsistencies.
- Analyzed test data, Prepare test data, Perform actual testing, check and verify outputs.
- Transmission of File. Validating the data and Running the file in production.
- Performed manual testing, functional testing, performance testing and regressing testing.
- Prepared the Statistical Analysis Report with data.
Environment: Windows XP, Windows Server 2003, UNIX, VBScript, QTP 10,Quality Center9.2, SQL, PL/SQL, J2EE, JRE, HTML, XML, MS ACCESS, Microsoft Visual Source Safe 6.0,Load Runner
Confidential,Bangalore, India Jan. 2007 – Mar. 2008
Software QA Analyst
Description: HMS is basically an Intranet application. The aim of this system is to provide the latest information and update the services throughout the network in the various departments existing in hospital premises. This Hospital consists of more than 500 employees providing almost all the services which are necessary for the in and out patients. This project manages all the aspects of the data management in a Hospital including billing. The objective of this Intranet application is to help the Hospital employees to keep track of Hospital database which included Doctors, Patient information and customer’s details throughout an Intranet.
Responsibilities:
- Conducted Distributed and multi-user testing.
- Analyzed user requirement document and developed test plans, which includes the objectives, testing strategies, test environment and others.
- Attended Change Request meetings to document changes and implemented procedures to test changes.
- Wrote test cases and test scripts for the functionality testing.
- Closely worked with developers and System Engineers to nail down the technical problems.
- Tested Application with Development, Staging, and Production Environments.
- Prepared and authored various user levels, system level documents.
- Prepared Various System and interface Documents for Updated QA Process
- Coordinated with development and functional teams regarding releases and bug tracking system.
- Coordinated training for users with latest releases and change requests.
Environment: HTML, JavaScript, VBScript, Oracle 8.1, Win Runner, Test Director, Windows XP
Confidential,Chennai, India June 2005 – Dec. 2006
Software QA Analyst
Bajaj Allianz is a Multi-line insurance company which offers auto, home, commercial and life insurance through a network of independent insurance agents. The application generates quote and allows application and endorsement of insurance policies. It can be accessed by Employees and Agents. It provides enhanced support for Agents for policy maintenance like adding customers, banks, performing policy searches, renewals etc.
Responsibilities:
- Analyze the Functional Business requirements and Design documents, Developed Test Plans for different Testing stages
- Prepare Test Cases for Modules like Bodily Injury Liability, Property damage Liability, Personal Injury Protection, Uninsured Motorist Coverage, and Comprehensive Damage
- Perform Manual Testing for the modules mentioned above
- Participate in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues
- Conducted Navigational testing by clicking on various hyperlinks and verifying that it is redirected to the correct page
- Performed backend testing by executing SQL queries with TOAD for data base authentication
- Involved in User Acceptance Testing (UAT)
- Extensively used Win Runner for functional and Regression testing
- Performed regression testing on the application after modifications were made
- Maintain Defect Report using Test Director and sending weekly status reports showing the issues to be resolved across the team
- Make schedules for system and integration testing for each release
- Prepare detailed Test Summary Reports
- Perform Load/Performance, Regression Testing using Win-Runner
- Interact with developers for Spec Reviews, technical problems and to resolve critical bugs
Environment: Test Director, Win Runner, Quality Center, Windows XP, SQL Server, ASP, HTML, TSL, MS Office