Prakash Reddy

Phone: 361-***-****

Email: acozaf@r.postjobfree.com

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