Software Qa Analyst Resume
WI
Professional Summary
- Around 10 plus years of IT experience as a QA Tester involved in test design, test development and implementation of test procedures in manual and automation testing.
- Expertise in Entire Software Development Life Cycle and Test Development Life Cycle.
- Extensive experience in testing of large client server applications, Web based applications, E-Commerce Applications and Middleware applications on various Window and UNIX Environments.
- Extended knowledge on various domains like Banking, Insurance, Telecom, Health Care, Retail and Marketing on Windows, Mainframes, AS400 and UNIX Platforms.
- Exposure to different types of testing like Automation testing, System testing, Functional testing, Regression testing, Integration testing, Smoke testing, Database testing, Performance testing, GUI testing and User Acceptance Testing.
- Well versed with SQL, PL/SQL queries to run the data integrity tests.
- Experience in automation testing using mercury tools like Quick Test Professional and Win Runner.
- Experience in of use software Management Tools like Quality Center, Test Director Clear Quest, All Fusion Harvest and PVCS.
- Exposure to Agile process and methodologies
- Performed ETL (Informatica, Data Stage) testing on DWH and Data Migration projects.
- Involved in Business Intelligence (BI) data/reports validation on Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence) and Cognos.
- Involved in XML data verification and validations.
- Good experience in testing Web Methods, TIBCO based middleware applications and database back-end systems.
- Involved in preparation of test plans, test strategies and test methodologies.
- Extensive experience in creation and maintenance of automated test scripts.
- Implemented Quality Center for test planning, test case development, test case execution and test results analysis.
- Effectively involved in Defect tracking, reporting and analyzing test results using Quality Center.
- Developed automated test scripts using VB Script (Quick Test Professional), Test Script Language (Win Runner).
- Performing Data Driven test for testing the application with multiple set of data.
- Knowledge in Performance testing, Stress testing, Load testing and Volume testing.
- Interacted with developers to assure quality of testing.
- Good judgment skills while reporting and prioritizing software bugs in conjugation with the development and QA managers.
- Ability to work with all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player.
- Excellent analytical, communication, documentation and interpersonal skills.
- Highly motivated resourceful team player that takes a positive approach to problem resolution.
Technical Skills
Testing Tools
QTP 9.2/8.2, Win Runner, Load Runner, SOAP UI
Data warehousing tools
Informatica Power Center 8.1/7.1, IBM Datastage 8.1,
Business objects 6.5, Cognos 8.0
Languages
C, C++, Java, COBOL, SQL, PL/SQL, TSL, VB Script, Java Script
Web
ASP 3.0, HTML, XML, DHTML
RDBMS
Oracle 10g, 9i/8i, MS SQL Server, DB2 8.0, MS Access
GUI
Toad, File-Zilla, SQL Navigator 4.5, F-Secure, Shadow Studio 1.2
Version Control Tools
PCVS, MS Visual Source Safe, All Fusion Harvest
Bug Tracker
Quality Center 10.0/9.2/8.2, Test Director, Rational Clear Quest
Operating System
MSDOS, UNIX (Solaris, AIX, and HP), Windows 95/98/2000, Windows NT/XP
PROFESSIONAL EXPERIENCE
Confidential,
Madison, WI Mar ’11 – Till date
WEA Trust provides insurance, retirement and investment services to Wisconsin public school employees and their families. Application has Web Enrollment, On-line Enrollment, Batch Enrollment, Account Management and Claims management for subscribers.
Roles & Responsibilities:
- Understanding the business document and participated in walkthrough and review meetings.
- Involved in preparation of eligibility enhancement Test Plans for different work packages, On-Line green screen changes, Web Enrollment and Batch enrollment.
- Actively involved in testing the application, manually and automation.
- Participated in the System Test Plan, Test Scenarios and Test Cases Reviews
- Gather the relevant test data necessary for the test cases, based on the Business specifications, Requirement specs, Scenarios, Transactions and Test Conditions.
- Tested the HIPAA EDI Transactions and worked on Medicare Claims.
- Involved in testing the integration between the Claims application and other applications like Providers, Drugs, Eligibility and Member Client Services applications.
- Generated and validated various reports like Clinical, Hospital and Dental Claims reports.
- Involved in testing the Informatica Transformations, Mappings and Mapplets using Informatica Designer and managing the Workflows, Worklets using Informatica Workflow Manager/Monitor.
- Generated SQL queries to validate various reports, loads and extract processes.
- Involved in loading the flat files into DB2 Database and involved in writing Complex SQL Queries.
- Involved in generating Reports using Business Objects and testing the reports
- Developing Automated Test Scripts in QTP to perform functional testing and regression testing for web enrollment and online enrollment modules.
- Prepared and executed automation test scripts using QTP.
- Created parameterization templates and test data to run the test cases for different data.
- Prepared and executed automation test scripts using excel macros.
- Involved extensively in user acceptance testing phase along with the end users
- Attended weekly Review meetings to review and follow-up the status of defects. Also attended Team review meetings to notify status updates.
- Developed and executed SQL queries extensively for backend testing using SQL Navigator.
- Reported defects using Quality Center and interact with developers to resolve defects.
- Tested Web services using Soap UI tool and validated the responses.
- Develop templates perform Parameterization to run the test cases for different data.
- Prepared and executed automation test scripts using excel macros.
- Involving in testing various backend jobs developed ETL Tool (Informatica) and UNIX
- Responsible for Running Batch Jobs
- System developed using the Scrum/Agile Development Methodology.
Environment: Java servlets, JSP, COBOL, JCL, AS400, RPG, I-Series SQL Navigator, Windows XP, MS SQL Server 2005, SharePoint, XML Spy, SOAP UI, Spec Builder, X-Engine, Control M, MACESS, Quality Center 10.0, QTP 9.2, Web sphere, Informatica, Business Objects, J-Boss.
Confidential,
Warren, PA Jan ’08 – Feb ‘11
Orchard Brands is a leading, multi-channel marketer of apparel and home products. Orchard Brands provides quality products to consumers through the direct channels of catalog, Internet and retail. Orchard Brands consists of the brands Express Fashions, Blair, AMO, Appleseed\'s, Tog Shop, Drapers and Damon’s, Winter Silks and Linen Source.
Roles & Responsibilities:
- Understanding the business document and participated in review reports.
- Actively involved in testing the application, manually and automation.
- Preparation and modifications of automation scripts for creating different type of orders for regression test.
- Creation of the System Consolidation Test Plan and creation of required test data
- Participated in the System Test Plan reviews, Test Scenarios, Test Cases Review and modified the documents with respect to the review comments
- Gather the relevant test data necessary for the test cases, based on the Business Analysis, Requirement specs, Scenarios, Transactions and Test Conditions.
- Involved in System testing, Functional testing, Regression testing, Smoke testing, GUI testing and UAT Support.
- Involved in Data migration testing, Production support testing, Database testing, New Business Ventures testing.
- Preparation of data conversion test cases using SQL
- Involved in Front end testing using FRY site admin
- Involved in testing the application after CWDirect integration with web applications and PKMS
- Executed AS400 jobs, validated the log file results and generated reports.
- Prepared and executed automation scripts for validating the orders using VBScript and QTP.
- Involved in create user defined functions and function Libraries in QTP.
- Involved in identify and creating regression test suites using QTP.
- Involved in Mainframe Testing, MQ Packets and Flat File validation
- Testing a large part of the consolidation effort. Data conversion and DWH testing involves validation of mapped data from the Legacy system (source system) to the OB CWDirect (target system) and the assurance that converted data is still able to be manipulated.
- Verified the dependencies among workflows between sources to staging, staging to staging and staging to core.
- Involved in doing extensive database testing for various extract, transfer and load processes validations of Data Stage.
- Executed Data Stage jobs and validated various reports, loads and extract processes.
- Validation of OB business reports using Cognos Reportnet reporting tool.
- Involved in End to End testing for web applications, CWDirect and PKMS.
- Involved in Web services testing
- Involved in testing web methods, validated the generated XML messages.
- Involved in testing real time messaging services on the WebMethods middleware boxes for the request/response XML’s by using SOAP interface.
- Defect management through Quality Center, Team track, Problem tracker and SharePoint.
- Conduct defect Triage meetings with developers and entered the bugs on the basis of the severities in the defect-tracking databases.
- Conduct status meeting with offshore team.
- Involved in testing Production Support Issues
- Involved in New Business Ventures AEGON, Encore, Synapse, Free Shipping.com and Discount Health Benefits implementation and testing
- System developed using the Scrum/Agile Development Methodology.
- Actively participate in the Scrum Process
Environment: Java servlets, JSP, J2EE, SOAP, COBOL, VSAM, JCL, AS400, RPG, CWD 11.0/5.5, EJB, XML, Data stage 8.1, Cognos 8.0 Reportnet, DB2, ISERIES, IBM-AIX, Web Methods, Web Sphere, Windows XP, QTP 9.2, Quality Center 10.0/9.2, Share Point, Site Admin.
Confidential,
Wilmington, DE JUL ’07 – Dec ‘07
JP Morgan Chase is a leading financial services firm with investment, banking, finance, insurance, and Credit card Services. Enterprise shared service development system having different Credit Card Services likes CPS, E-pay, CRDM, Feature Manager, and ECMS.
- Involved in testing the application for regression builds, manually and automation.
- Participated in the System Test Plan reviews, Test Scenarios, Test Cases Review and modified the documents with respect to the review comments
- Gather the relevant test data necessary for the test scripts, based on the Transactions, Test Conditions documents and updated in the property files.
- Involved in the preparation of automation Scripts for CPS Rewards method and E-Pay initiate payment and make payment methods.
- Involved in maintaining and uploading the QTP Scripts to Quality Center.
- Involved in Create Test Suite in Quality Center and execute them from QC.
- Involved in the execution of test scripts of the property files using Test Harness Suite for CPP and Java Clients. Validated the test results generated in log files with corresponding databases table values and TSYS Screen values.
- Involved in validating the back-end DB2 database against the Mainframe flat files
- Involved in create user Defined Functions and function Libraries
- Involved in Creating Reusable Actions and called them into external Actions.
- Involved in testing Mainframes CICS green screens
- Modified JCLs and submitted the jobs
- Performed Database Validations using SQL Navigator, Toad and Shadow Studio.
- Involved in Unix Batch execution for ECMS service using F-Secure Client/FTP to import files.
- Used Quality Center to prepare Test cases, procedures and Requirements Traceability Matrix
- Involved in System testing, Functional testing, Regression testing and Smoke testing.
- Involved in middleware messaging testing on the Tibco boxes for the requests/responses.
- Validating the messaging request/response XML files based on the test data setup.
- Validating the log files and starting/stopping of Tibco engines.
- Involved in the preparation of Test Analysis Reports and defect profile document.
- Executed CPS Regression automation scripts and analyzes the test results.
- Involved in CRDM, ECMS and Feature Manager Sub-systems Regression testing
Environment: QTP 9.2/8.2, Quality Center 9.2/8.2, TSYS, CPP, JAVA, Servlets, EJB, JSP, HTML, XML, Shell script, J2EE, COBOL, JCL, DB2, Web Logic, Oracle 9i, F-Secure, TIBCO, Toad, MS SQL Server 2005, Documentum, Test Harness, Shadow Studio, Windows NT, UNIX, WebTop.
Confidential,
- Mount Laurel, NJ APR ‘06 – JUN ‘07
- Senior Test Engineer/Automation Test Engineer
GMAC Insurance application related to wholesale Insurance designed for GMAC Wholesale Administration System. GMAC is a subsidiary of General Motors. GMAC application related to different modules Polices, Quotes, Interfaces and Claims.
Roles & Responsibilities:- Actively involved in testing the application, manually and automation.
- Understanding the business document and participated in review reports.
- Participated in the System Test Plan reviews, Test Scenarios, Test Cases Review and modified the documents with respect to the review comments
- Gather the relevant test data necessary for the test cases, based on the Business Analysis, Requirement specs, Business process Procedures, Scenarios, Transactions and Test Conditions.
- Performed Database Validation Testing and manipulations using SQL.
- Performed manual testing on Mainframe and web applications.
- Tested Mainframe batch and online systems
- Involved in Interfaces testing using FileZilla to import and export files.
- Used Quality Center to prepare Test cases and Requirements Traceability Matrix.
- Modified JCLs and submitted the jobs
- Involved in the preparation of Test Analysis Reports and defect profile document.
- Performed Data-Driven tests by passing different sets of data and checked whether the valid information entered is updated into the database.
- Created batch test scripts by calling another internal or external actions
- Manipulated Recovery Manager Steps.
- Prepared Unix Shell Scripts and modified scripts to verify the log files data.
- Experience over performance testing to monitor throughput of the various systems. Worked with Performance Testing team for Load/Stress testing so as to predict system behavior and performance using Load Runner.
- Developed user defined functions using QTP for testing database and validating the conditions.
- Environment: QTP 8.2, Quality Center 8.2, Load Runner 8.0, IBM Mainframe, COBOL, JCL , CICS, DB2, JAVA, Servlets, EJB, JSP, HTML, XML, Java Script, shell script, J2EE, Web Sphere, Oracle 9i, Toad, File-Zilla, Windows NT, UNIX.
Confidential,
Denver, CO JAN’05 – MAR’06
Roles & Responsibilities:
- Involved in Manual and Automation testing.
- Worked with application development architects and developers, business analysts to understand process requirements.
- Understanding the business document and participated in review reports.
- Assisted in the preparation of test plans, which specify testing overview, testing approach, testing strategy, roles & responsibilities and scope of testing.
- Preparing System Test Plans, Test Scenarios and Test Cases using specifications document.
- Execution of the test cases.
- Involved in inserting various checkpoints (database, bitmap, and text) to ensure test script’s reliability and validity.
- Performed Functional Testing, System Testing and regression testing.
- Work with the users to have the test result approved.
- Assisting in user acceptance testing to support software releases and project implementation.
- Responsible for creating and managing automation scripts using QTP.
- Prepared Unix Shell Scripts and modified scripts to verify the log files data.
- Logging, tracking, reporting the defects using Test Director.
- Preparation of the test scripts and checked the functionality of the application.
- Interacting with developers for assisting them in Identification and resolving bugs.
- Performed Regression testing as and when the bugs got fixed and checked whether the application is free from bug.
Environment: Quick Test Pro 8.0, Test Director 7.6, UNIX, EJB, Java, J2EE, Web Sphere, Oracle 9i, MQ Series, MS-Office, Windows XP/2000/NT.
Confidential,
Goodland, KS MAR’04 – DEC’04
- Understand the business requirement and technical specification documents
- Reviewed change request documents and defect description and attendant meetings to document the required changes.
- Developing test cases, test procedures and test data from requirement document
- Involved in test plan and test case review meetings
- Updating the test cases document according to review comments
- Executing test cases.
- Performed Smoke, System testing, Database testing and Regression testing.
- Used Test Director to prepare Test cases, Bug Tracking, and reporting bugs.
- Updating status report daily basis and weekly basis.
- Involved in writing of modification reports for errors identified in testing and clearly communicated with development via defect tracking system using Test Director
- Conducted system testing to ensure requirements are meet and defects are managed.
- Involved in Database testing to verify data integrity tests.
- Extensively interacted with developers to analyze and resolve the issues that were encountered while testing the application.
Environment: Test Director7.6, UNIX, NETframework2.0, VB.NET, Visual Studio .Net, COM, COM+, XML/XSLT, IIS 5.0, SQLServer2000, Crystal Reports and Windows 2000.
Confidential,
NewYork DEC’03 – FEB’04
- Understanding the business requirement and system requirement documents and involved in the review meetings.
- Developed Test Scenarios for Manual and automation testing.
- Prepared traceability matrix
- Performed Functional testing, System testing, database testing and regression testing.
- Extensively used PL and PL/SQL query statements to verify the data integrity and validation between the front-end values with the backend database values of the application.
- Prepared Test data and check list in order to ensure the test coverage
- Scheduled test execution using Test Director.
- Responsible for documentation of defects using Test Director.
- Prepared the Final test summary report
- Involved in Browser compatibility testing using different browsers.
- Used Win Runner for functional testing GUI checkpoints, Bitmap checkpoints, and Database checkpoints
- Developed test scripts using Win Runner for regression testing.
Environment: Win Runner7.0, Test Director7.0, Oracle, HTML, Java Script, J2EE, UNIX, SQL, Internet Explorer and MS Windows.
Confidential,
UK MAR’02 – NOV’03 Test Engineer This Project is Web based management system for Berry Bros and Rudd’s Winery. Berry Bros and Rudd’s Winery is the world’s leading most profitable spirits and wine company. The project involves development of web site for Orders, Stocks, Sales, Shipment of products. Roles & Responsibilities:- Understanding the business requirements and system
- Participated in manual testing.
- Participating in developing and executing test cases.
- Bug Tracking and Bug reporting using Rational Clear Quest.
- Identified the bugs and interacted with the team lead and developers.
- Involved in performing Black Box testing.
- Performed Functional & Regression testing
Environment: Rational Clear Quest, Oracle, HTML, JavaScript, PL/SQL, Apache Web Server, HP UNIX and JAVA
Confidential,
India MAY’01 – FEB’02 Test EngineerThis is a premier hospital. The customer can look into the facilities that the hospital offers, the panel of doctors available, the diagnostic tests undertaken, the different departments that are there in the hospital and consultant medial staff information, the different health check up with links to know the information about the check ups and various insurance details.
Roles & Responsibilities- Performing extensive manual testing of each module.
- Created Test Scenarios and Test Cases according to the business and system requirements
- Executed test cases.
- Bug logging, Bug tracking and Bug Reporting.
- Involved in regression testing for the modified builds.
- Performed Positive and Negative Testing.
- Involved in SQL database backend testing
Environment: PVCS, HTML, JavaScript, SQL, Window98, Ms-Word and Oracle.
Academic Profile- Master of Computer Applications, Nagarjuna University, India.