Test Cases Quality
Resume:
Prakash Reddy
Phone: 361-***-****
Email: ************.**@*****.***
Started my career as a manual QA tester involved in testing web
applications. Eventually, I was exposed to SQL wherein I worked with
different databases and continued my career as data warehouse tester where
I also gained exposure to automation testing which encompassed writing
scripts and maintaining the test scripts for applications. I am currently
working with SOAP web services in my present project.
SUMMARY:
. 10 years of diverse experience in Information Technology with emphasis
on software quality assurance, software testing on desktop and web-
based applications
. Good understanding of quality assurance testing methodology relative
to the Software Development Life Cycle (SDLC) as well as Software
Testing Life Cycle (STLC) including waterfall model and agile
methodologies
. Extensive experience in reviewing and analyzing FRS (Functional
Requirement Specifications) and SRS, and writing detailed test plans,
test cases, and test scripts
. Extensive experience in automation testing using HP Unified Functional
Tool (UFT) in development, maintenance and execution of automation
scripts, creation of automation framework and standards
. Used Gherkin script to write scenarios for Behavior Driven Development
to cover UAT
. Extensive experience in planning and test execution and post test
result analysis
. Thorough understanding of structured testing methodologies working to
implement, particularly from testing team perspective and user
perspective
. Experience in backend testing using SQL statements to check whether
the changes which are made in the front-end are affecting the back-end
. Excellent problem solving skills and experience in working on group
projects with a desire and ability to learn and apply new technologies
. Highly self-motivated, responsible, reliable and resourceful team
player with a set of strong technical skills and a positive approach
to problem resolution
SOFTWARE SKILLS:
Languages C, C++, Java, SQL, VB Script, PERL, Ruby, Gherkin, HTML,
XML
Testing UFT/QTP 11.53, ALM/Quality Center, Bugzilla, Jira, Rally
Tools
Databases Oracle 9i/10g/11g, SQL Server 2008, MS-Access, DB2,
Teradata,
Database MS Query, Putty, SQL Developer, TOAD, Rapid SQL, MySQL,
Tools SQL PLUS, Web focus 8, Teradata SQL Assistant 13.0, IBM
Data Studio 3.1, DB Visualizer 7.1.5
Software Microsoft Office, MS Visio 2010, Putty, Altova XML Spy,
Beyond Compare, LDAP Browser, ADSI Edit
Web services SOAP UI
ETL Tools SAP BODS 14.0.1, Talend 5.1.1, DataStage 8.5, Informatica
8.6, SSIS/SSRS 2012
Platform Windows NT/2000/98/XP/7, Linux, Unix
PROFESSIONAL EXPERIENCE:
Erie Insurance Group, Erie, PA Feb'14 to
Present
Quality Assurance Lead
Authentication & Identity Management
Responsibilities:
. Getting finalized requirements about Request For Change (RFC) from
business analyst for the monthly release
. Simultaneously gather the requirement document for the actual project
while analyzing them and preparing for the test scenarios
. Create the test strategy for all monthly releases and test case
document for testing the RFC's.
. Create a separate folder for every release in HP ALM Quality Center
. Write Gherkin scripts based on the requirements to cover Behavior
Driven Development
. Validation of web services using SOAP UI and validating the response
of the service
. Creating test strategy document for the project for web application
and for ETL migration from stored procedure to DataStage jobs for the
initial load
. Work with ETL validation for SSIS jobs for claims in Claim center
project. Validation of data flow from source to target data bases
. Evaluate manual test scripts to verify whether they can be automated
and built proof of concept to prove Agent Identity web application can
be automated through QTP/UFT
. Created BPT components and worked with SME and QA to execute manual
test scripts and updated BPT components as per the SME and QA
requests
. Develop BPT components for each transaction used in the manual test
script or scenario utilizing QTP
. Work closely with the project team in planning, coordinating and
implementing BPT framework
. Perform cross-browser testing on Internet Explorer, Chrome and Firefox
to ensure the compatibility of the UI application according to the
requirement specifications
. Validate the reports generated in Web Focus tool for the agents based
on the requirement document
. Retest defects once they are fixed and reopening them based on
necessity as per the validation results followed by regression testing
after resolving the issues to ensure the existing functionality is
working as expected
. Writing complex SQL queries on various source and target databases
such as Oracle, Microsoft SQL Server and DB2 by retrieving the data
using various kinds of joins
. Work extensively with the release manager by attending release
meetings and coordinating for the production release of the
corresponding release.
. Provide updates to the QA Manager once the release is completed and
discuss how the release went, ways to improve the process and fill the
gaps (if any) and discuss QA resources when necessary
Environment: UFT/QTP 11.53, Quality Center 11.0, Rally, Microsoft Visio
2010, Microsoft .Net, ADSI Edit, Altova XML Spy Tool 2007, Mainframe,
Oracle 11g, LDAP browser, SQL Developer, MS Access Database, MS Query, SDE,
Web Focus 8, Beyond Compare, IBM Datastage 8.5, SSIS/SSRS 2012, Microsoft
SQL Server 2008 R2 and Windows XP
Auto-Owners Insurance, Lansing, MI
Jan'13 to Jan'14
Quality Assurance Lead
Guidewire Claim Center
Responsibilities:
. Analyzed business requirements and worked with the business analyst to
define the acceptance criteria and design the test scenarios.
. Created user stories and sub-tasks in Jira to track the development
and testing tasks
. Managed the overall testing effort, including coordination of testing
personnel and test resources
. Worked on mapping documents which were developed by the business
analyst to develop test cases
. Designed test cases for the fields in claim center relational database
tables using mapping documents
. Validated the data of source tables with the target tables by using
complex SQL queries and validated the data flowing from target to
other tables which were used to create different reports
. Executed automated scripts for creating claims in Guidewire Claim
center using QTP
. Validated the Java based web applications by entering data and
validating the database
. Logged and tracked defects in Jira and linked the defects to
corresponding test cases in test lab.
. Retested defects once fixed and reopened based on necessity as per the
validation results
. Retested and performed regression testing after resolving the issues.
. Participated in bug triage meetings during the test execution phase to
facilitate smooth QA process and working with developers and tech
leads to review and identify the defect root causes.
. Attended the release status meetings and update the team about the
status of the defects
. Closed the opened stories and tasks once the defects are resolved
. Daily and weekly status updates from team members
Environment: Quick Test Pro 11.0, Quality Center 11.0, Guidewire Claim
Center,Java, Microsoft Visio 2010, Altova XML Spy Tool 2007, IBM Data
Studio 3.1, MS Access Database, MS Query, Beyond Compare, Business Objects,
Microsoft SQL Server 2008 R2 and Windows XP
Aviva Life Insurance, West Des Moines, IA
Apr'11 to Dec'12
Quality Assurance Lead
Projects:
Data Exchange
Solvency- II
Finance Transformation Project
Responsibilities:
. Analyzed business requirements and module-specific functionalities to
identify test requirements and formulate an effective master test plan
. Involved in writing Test Plans, Test cases and developing Test scripts
using Quality Center
. Maintained requirements and created Traceability between Requirements
and Test Cases
. Validated the data of source tables with the target tables by using
complex SQL Queries
. Performed and maintained documentation on different types of Testing
(Regression, Integration, System, Functional and User Acceptance
Testing/UAT)
. Communicated inconsistencies between system specifications and test
results to development and/or analyst team
. Performed regression testing of application for every new build
released
. Managed the overall testing effort, including coordination of testing
personnel and test lab resources
. Developed detailed Test Plans and Test Cases and provided the
documentation
. Executed the Test Cases by moving into Test Lab in Quality Center
. Validated and verified data flow from staging area to R12
. Retesting and Regression Testing after fixing the problems
. Executed automated scripts responsible for Regression Testing using
QTP
. Extensively used Quality Center for Defect Tracking
. Tracked and reported software defects and interacted with developers
to resolve technical issues
. Attended the release status meeting and updated the team about the
status of the defects
. Coordination of onsite/offshore team members to ensure the team stays
on task and completes assigned work in a timely manner
. Took daily and weekly status updates from offshore team members
Environment: Informatica Power Center 8.1, Quality Center, Quick Test
Professional, Microsoft Visio 2010, SQL Developer, Windows XP, R12, Java
Virtual Machines, SQL Server 2005, DB Visualizer, AS400, Teradata, Oracle,
DB2
Roche NimbleGen, Madison, WI
July'10 to Apr'11
QA Tester
Responsibilities:
. Analyzed Business Requirements documents for iMAS and
NimbleDesign application.
. Performed requirements review and manual test verification
. Extensive performance of manual testing for Java/J2EE Windows
and Web based applications
. Creating test run plans, test run reports, test plans, test
cases and test scenarios based on customer and product software
requirements, Use cases and Functional Specifications in the Quality
Center and Excel
. Conducted smoke testing in Java IDE in eclipse before the release of
version and also conducted smoke test as soon as the version is
released to ensure that the version is ready to test.
. Performed system, functional, integration, regression,
compatibility, GUI, UAT, end-to-
end and sanity testing for each iteration
. Participating in unit test using JUnit
. Created the SQL queries to perform the testing against the Oracle
database
. Wrote defects using Quality Center tool, Bugzilla and Jira then
followed-up with developers, to retest defects and ultimately close
the defects
. Attended CCB (Change Control Board) meetings, participated in bug
review meetings with the software development team throughout the
testing phase
. Worked with the whole project team during go-live and production
testing, problem resolution
. Performed multi-OS testing with Windows XP/Vista/7, Linux 2.6 and Mac
10.6
. Created traceability of test cases to requirements, test metrics and
participated in status meetings and reported the progress to the
manager
. Validated data by executing PERL scripts
. Extensive use of Linux/Unix command to perform data comparisons
. Tested DAU tool in Red Hat Linux environment
Environment : Java/J2EE, JDBC, Servlets, JSP's, Java Beans, Spring, J2EE
Design patterns, Tomcat, Quality Center tool, Bugzilla, Oracle 10g, Virtual
Machines, JUnit Toad, Windows XP, Vista and Windows 7, Linux/Unix and Mac
10.5 and 10.6 Operating Systems
AMFAM, Madison, WI
Nov'08 to July'10
QA Tester
Responsibilities:
. Analyzed business requirements and module-specific functionalities to
identify test requirements and formulate an effective master test plan
. Expertise in developing test scenarios, test procedures, test cases and
test data
. Conducted manual tests meticulously and exhaustively for entire
application using manual scripts designed specifically for this
purpose
. Strong experience in manual testing and automated testing tools,
client/server and web based applications in a mature process framework
. Validated source data against the target data by writing complex SQL
queries on both databases
. Expertise lies in functional, manual, automated, regression, system,
integration, white box, black box, interface and User Acceptance
Testing (UAT)
. Executed test scripts from Quality Center test lab on local and remote
machines
. Developed SQL queries to test the database functionality of the
application
. Documented test execution results and prepared reports
. Conducted regression testing for the fixes and enhancements in the
application
. Worked with QA Manager and Project Managers to prioritize and schedule
testing and
resolve scheduling conflicts
. Reported and tracked defect in defects tab in Quality Center
. Responsible for weekly status meeting to gather the progress of manual
testing
. Updated team lead about daily and weekly testing status
Environment: Quality Center, Oracle 10g, JAVA, Informatica power Center,
SQL Developer, MS Excel, MS Word 2003, Java Script, HTML, DHTML, Agile,
Windows Server 2003, MS Outlook 2003, QTP, UNIX, and Windows
Chase Manhattan Bank, Brooklyn, NY
Jun'07 to Oct'08
QA Tester
Responsibilities:
. Analyzed the business requirements and specifications.
. Designed and developed test plans and tests scripts for manual testing of
all the modules.
. Developed test cases after analyzing the specifications document.
. Tested the website for all the functionalities.
. Performed extensive regression testing for subsequent versions of the
application
. Writing and enhancing test scripts with every release of the product.
. Experience in writing SQL queries for database manipulations.
. Participating in unit test using JUnit.
. Performed end-to-end testing on the release version of the software
application and detected
GUI bugs.
. Reported and tracked defect in defects tab in Quality Center.
. Monitored performance of web based
application. Extensive Parameterization and correlation of
VuGen scripts to ensure the real time load conditions.
. Facilitated defects call between Business, Production team, Developers,
QA Team, System
Integration Testing team and User Acceptance Testing team
. Set up of performance lab with multiple machines, networks and simulated
environments.
. Knowledge in Analysis of Defect severity, Defect tracking System and
Defect reporting
Environment: Load Runner 8.1, Java, J2EE, Servlets, JSP, Java Script,
Junit, HTML, XML, SQL Server 2000, HTML, MS SQL Server, Oracle, Windows NT
Application for Sprint Mobiles, Motricity, WA
Aug'06 to Apr'07
QA Tester
Environment: ASP.Net, C#, VB.Net, Quality Center 9.0, QTP, VBA, SQL Server
2000, HTML
Rite Aid, Inc., Austin, TX
Nov'05 to Jun'06
QA Tester
Environment: HTML, Java, J2EE, Servlets, JSP, Java Script, Junit, HTML,
XML, SQL Server 2000 Oracle 9i, Test Director 6.0, UNIX and Windows NT
Citibank, INDIA
Dec'04 to Sep'05
QA Tester
Environment: UNIX, VB 6.0, MS-Access 2000, SQL Server7.0, Test Director
6.0, MS Word, WinNT/98/2000/XP
Library Management System, INDIA May'04
to Nov'04
QA Tester
Environment: JAVA/J2EE, Junit, MS-Access 2000, SQL Server 7.0, Test
Director 6.0, Win 2000/XP, UNIX
EDUCATION:
. Bachelors in Mechanical Engineering
[pic][pic][pic][pic][pic]
Contact this candidate