Hari Katragadda

Ph: 571-***-**** E-mail: acdl97@r.postjobfree.com

Visa Status : EAD

PROFESSIONAL SUMMARY:

** + years of IT experience as a QA Lead /Analyst/Tester using automated

testing tool QTP, WINRUNNER and Manual testing applications developed in

.NET, Java, Delphi, VB, Access and Oracle, SQL Server on Windows and UNIX

platform. Involved in development of several test cases, test scripts and

test procedures. Performed various types of testing that include

Integration, Regression, Functional, System and Performance Testing.

. Several years of experience as a QA Analyst/Engineer in testing Web

and Client\Server applications using both manual and automation

testing techniques.

. Expertise in testing various applications on multi platforms using Win

Runner, QTP well versed in Black box and White box testing.

. Experienced in VSTS2010 test tools( Microsoft Test Manager and TFS)

. Experiencd in writing documentation and training manuals

. Experience in testing Mortgage, Financial and Healthcare, Legacy, E-

Commerce, CMS Applications

. Experience in testing web services

. Experience in Integration, Performance, System, Navigational and Unit

testing.

. Knowledge of SEI Capability Maturity Model (CMM) and questionnaire.

. Implemented Quality Assurance Life Cycle.

. Knowledge of Software Development Life Cycle (SDLC)

. Knowledge of Agile and Waterfall methodologies

. Wrote SQL queries to test SQL Server and Oracle databases to verify

the data with the GUI.

. Worked individually as well as a team player.

. Specialized in testing of both WEB applications and Client/Server

applications.

. Specialized in testing on both WINDOWS and UNIX environments.

. Created and maintained Requirement Traceability Matrix

. Excellent interpersonal and communication skills

. Ability to work with multiple projects simultaneously

. Exposure to various defect tracking and reporting systems

. Experience in setting up the UAT environment, like UAT Labs, UAT

Database, User Profiles etc.

. Generation of Test Scenarios for UAT of business processes

. Expert in RUP methodology

Technical Skills:

QA Tools : QTP, Win Runner 7.5, Test Director 7.5, Load Runner 7.5,

Rational Robot, Test Manager, Rational Clear Quest, Manual

testing, Serena Team Track

Quality Standards : SPEG, CMM, CMM Questioner

Languages : HTML, DHTML, Java, VB Script, Java Script, Visual Basic,

.NET, Delphi

Development Tools : ASP 2.0 (IIS 4.0), FrontPage 98/2000 and Visual

Inter Dev

Database : Oracle, MS Access, Informix and MS SQL 7.0/2000

Documentation : MS Word, MS Excel, MS PowerPoint, MS Projects,

Visio, MS TFS

Reporting Tools : Crystal Reports, SQR Reports

Operating Systems : UNIX, MS-DOS and MS-Windows 95/98/NT 4.0/2000

Hardware platforms : IBM, PC Compatibles.

Education: Bachelors in Mechanical Engineering from Gulbarga University

Gulbarga, India.

DirecTV, LLC, El

Segundo, CA Aug 2013 to till date

Test Delivery Lead -

About Program: Business Process Testing Team is a team focusing on the

strategic planning of all DirecTV projects. Planning includes impact

analysis, leading the team, estimation of the level of efforts (LOE) for

various impacted applications, test strategy and supporting application

team during test planning and execution.

Roles and Responsibilities:

. Reviewed and analyzed business requirement documents, technical

requirements and functional specification of various

functionalities

. Co-ordination with application SQA, tracking the deliverables and

managing SQA deliverables using HP Application Lifecycle Management

. Lead the teams in India and Brazil

. Wrote test Plans and test cases

. Tested DirecTV sales channels such as DWS, RIO and OMS

. Validate the DB to verify the data is correctly stored or not

. Participated in daily Status meetings

. Coordinated UAT joint reviews and reviewed the test cases with them

. Involved in requirement verification using SMART technique and

involved in Non0-funciton requirements reviews as well

. Involved in estimating the SQA level of efforts for all the

impacted application for various projects

. Documented functional requirements and loaded them into HP

Application Lifecycle Management

. Have good working experience with HP Quality Center/ALM on

Customizing the User privileges and various module labels

. As a Quality Analyst responsible to plan and priorities of daily

and weekly deliverables and status update to QA Manager and Project

manager and actively participate in team meetings, status meetings

and work progress meetings

. Worked on Agile Methodology framework with respect to the change in

application requirements so as to achieve the target in stipulated

time

. Involved in the test enhancements analysis, issues tracking and

issues resolution fixes in the production environment

. Involved and trained offshore team to improve QA process and

establish strong QA Team

. Took part in the creation of QA metrics and Graphs to help the top

management to keep update with the QA Team progress

. Involved in Production Planning and Implementation check list

meetings / reviews

. Involved in SQA process improvement initiatives

Environment: HP ALM, Java, Informatica, Oracle

Taco Bell, Irvine

Jan 2012 to Jul 13

Test lead

Taco bell implementing their new e*restaurant POS

system and configured with existing EP systems

. Prepared test case and test plans using quality center

. Participated in implementation of e*restaurant and configured

with Financial modules such as AP, AR, GL

. Tested the conversion of Linux POS system into Windows

. Tested e*restaurant HR modules in the POS system

. Tested the vendor's configuration and check cutting in AP

. Tested the workforce management from the POS management

. Tested creating the entries for clients in AR

. Extensively tested OracleHR modulesHR

. Tested the back end against both the POS and ERP systems

. Tested the management of customer ledger account

. Tested the distribution of Taco bell's inventory

. Tested fusion middleware

. Tested the mobile application on Android and Apple devices

. Tested the both Back office and front office systems

. Worked with offshore team to resolve the bugs

. Used Ralley to log the bugs

. Tested the DB by writing queries

. Participated in writing training manuals and UAT test cases

for the business users

. Participated in regression testing and defect tracking

meetings

Environment:

Quality Center, Rally, E*Restaurant, SAAS, XML, SQL Server, Oracle

Equator Financials, Irvine, CA

April 2011 to Dec 2011

Sr QA Analyst

Domains worked for GMAC LOB on a) REO module b) Deed-in-Lieu Module c)

Settlement Module d) Short sale Module. These modules need to be tested in

public site and Work stations

Responsibilities:

. Prepare Test cases and testing categories by reviewing Project

Specification and Business Requirement documents

. Write queries to verify the business rules against the database

. Daily Status Reporting

. Performed System testing by executing the test scripts.

. Perform System, End-to-End and regression tests

. Worked with appropriate team leaders to ensure quality of test

deliverables & timely completion of individual test plans

. Involved in various kinds of testing like Unit Testing, System

Testing, Integration Testing, Regression Testing during the entire

life cycle

. Performed cross browser testing (Both I.E and Firefox)

. Wrote test cases using HP Quality center

. Send out the daily test progress reports

. Create and update automated test scripts to support future

regression tests

. Used selenium to perform the regression testing

. Used MKS system to log the defects

. Ran Selenium scripts and logged the results

Technical Environment:

Cold fusion, ALM/ Quality Center 10, Cloud computing, SAAS, Selenium IDE,

MKS, Share Point

World Vision International, Monrovia, CA

09/10 to March 2011

Sr.QA Lead

World Vision is a Christian relief, development and advocacy

organization dedicated to working with children, families and communities

to overcome poverty and injustice. Involved in a project PMIS R2.2 where

the global users run their programs, projects and grants

Responsibilities:

. Provide leadership in working with project Managers and business

partners to provide effective and efficient quality assurance of

deliverables, testing, measurement, and continuous process improvement

. Involved in Scrum methodologies from requirement gathering to release

. Prepared detailed Test plan and Deliverable time lines for the project

. Participated in UI, Integration and UAT Testing, Regression testing

. Wrote test cases using Microsoft Test manager

. Documented company's defect management workflows and test Process and

shared them within the team using SharePoint

. Installed TFS and MS Test Manager and helped BA's how to use both the

tools

. Created Traceability using TFS and logged unscripted bugs using TFS,

Used MTM to log the scripted bugs

. Wrote bug work item queries to manage the bugs in TFS and developed

the bug reports from TFS

. Worked with developers in Australia and kaulalumpur to resolve the

bugs

. Worked with WVI business users all over the world and set up the UAT

environments for them

. Developed the UI test principles within the Test process

. Tested the streaming videos added to the world vision global site from

different region users and also documented the process how to add and

delete the videos

. Tested the videos to watch or downloading in different environment or

platforms like windows media player, silver light

. Managed the bugs for all the releases using MTM/TFS. Assigned the

defects to developers based on their scope using MTM and TFS

. Helped BA's to upload their defects into TFS using Excel, Navigate

different bugs within multiple teams and updated the bugs status in

the bug

Environment: VSTS 2010, MTM 2010, TFS 2010, SQL server, web 2.0, .NET,

silver light, Share point, Lotus notes 6.5

Pacific Life Insurance, Aliso Viejo, CA

12/09 - 08/10

Sr. QA Analyst

Offering insurance since 1868, Pacific Life provides a wide range of

life insurance products, annuities, and mutual funds, and offers a variety

of investment products and services to individuals, businesses, and pension

plans. Pacific Life counts more than half of the 100 largest U.S. companies

as its clients.

Responsibilities:

. Involved in Agile methodologies from requirement gathering to release.

. Gathered requirement from the scrum meeting as part of Agile methodology

. Tested the Transformation of mainframe data to SQL server 2005

. Worked in a project where complete design change is happened from

Mainframe technologies to Microsoft Technologies

. Tested the Bothe designs i.e Mainframe and Microsoft

. Participated in developing/executing detailed test plan and test cases

for testing the different components of the Data migration project.

. Performed Database testing, ETL testing, and Integration and Regression

testing for the Non Financial data migration to the downstream

applications.

. Involved in testing the Extract, Load, Transform and Validation from the

Source and Target Databases.

. Used SharePoint bug tracking system to log the bugs

. Tested the both Mainframe systems and the UI to where the data loaded

from Mainframes

. Experienced in testing the mainframe apps in TSO using file aid

. Tested the business logic of the extract files from the source and feeds

to the downstream application.

. Validated the data format testing of data in the Database and performed

data integrity check at the database level in SQL server..

. Validated the data transformation from ETL to AR and AP

. Compare the mainframe data against Account receivables and .AP entries

. Created the reports for AR and AP as per the customer requirements

. Performed the data comparison of extract files to the Database data and

database data to output files using Access and Win merge.

. Executed the test cases using MS tool, logged and tracked the defects

using the Share Point

. Coordinated, supported the offshore team and provided the necessary

information on time for the offsite testers.

. Provided the necessary support for the completion of the project and

received appreciation from the management for the enthusiasm,

coordination and overtime work for successful project.

Environment: SQL Server, .NET, SSIS Framework, Access and Mainframe, Share

point, File Aid, TSO, People Soft

Hot Topic City of Industry, CA

Feb 08 to 11/09

Sr QA Analyst

I was involved in a project called Distribution systems upgrade

.Distribution system is the part of the Hototpic Warehouse supply

Management system. I was involved in both functional and database testing

of the application. Through this application they looks for the sales

inventory and the shipment status. I am also involved in testing their

merchandise and music sales website www.shockhound.com

This is a B2B application

. Review the documents and created the Test indexes

. Participated in Agile Development cycle

. Participated in Face to face communications with other members as a

part of the Agile Methodology

. Participated in Testing the Manhattan Warehouse supply Management

system

. Created detailed test plans and Test cases related to the WMS system

upgrade, and Participated in testing efforts related to DC system

changes

. Created different shipment and carton data for the Testing efforts

. Participated in data base testing using DB visualizer

. Participated in Testing the EOD store reports and End of the month

reports

. Participated in testing social networking website Shock Hound

. Tested the web application on different Browsers such as IE6, IE7 and

Mozilla

. Extensively participated in WEB TESTING

. Participated in testing Hot topic retail website called

www.shockhound.com

. Tested HTML Tags

. Created sales orders using cash order management system

. Tested the CMS system which built on using Drupla

. Does haves trong understanding in Java.net technologies

. Tested the web applications which built on using AJAX technologies

. Managed and tested the content using admin accounts

. Participated in testing the migration of content from one to another

using customized template within the organization

. Tested the content pattern and styles

. Participated in testing applications like selling music, Merchandise

and Videos

. Participated in testing applications like selling one click downloads

and online talk shows

. Participated in testing transactions through piggybank, credit cards

and also using Gift cards

. Participated in testing the application like adding play list from

other users and create new play lists which is like iTunes

. Participated in testing music downloads and buying stuff using online

carts

. Wrote SQL queries

. Participated in testing the Database against the front end

transactions

. Participated in testing the sales application with different rate

sheets

. Monitored Batch processing for every day sales and for the end of the

month sales

. Participated extensively in Functional and Database testing

. Participated in testing XML data transformations

. Compared XML data against the Database

. Created the Test cases for the UAT testing using Mercury quality

center

. Using Mercury quality center Traced the test cases back to the

Business requirements

. Ran testing reports using Mercury quality center

. Created the Test Data for UAT testing

. Logged the bugs using BugZilla

Environment: .NET, Java,, XML, SQL server, BugZilla, Manhattan WMS

system, Unfuddle, Crystal reports, Oracle, UNIX, MS Share point Server,

Drupla, WEB 2.0, Ajax

Standard Insurance, Portland OR

May07 to Jan08

Sr QA Analyst

Involved in CTA project involves the data transformation of 500,000 records

from the earlier Insurance provider database to Standard Database.

Standard used the ETL process to merge the data and upload into the Target

systems and make its in synch with the other integrated systems.

. Participated in scrum development cycle

. Participated in integration, GUI, System and Functional testing

. Lead the QA team made of Functional and Database testers

. Lead the team in defect meetings and knowledge discussions

. Used Team foundation server to Track the Iterations

. Used TFS to create new items on Project Basis

. Used TFS to manage the Business requirement documents for each project

. Managed different Test documents using TFS

. Participated Extensively in Database testing

. Participated Extensively in web testing such as creating a new profile

for the new member and creating insurance quotes for the existing and

the new ones

. Tested the ETL extract against the Source and the Target Database

. Tested the ETL extract against the business merge rules

. Validated the data merge from the source to the ETL extract

. Validate the Data transformation from ETL to XML out put file and to

the Target systems such as SAGE CRM for the marketing and campaign

Data

. Participated in testing the XML schemas

. Participated in testing the Translation of Data using XML

. Validate the Delta loads back to the Source and the Validate the

source

. Validated the business rules for the Data Transformation

. Validated the reject files and Trace back to the source for the

validation and business requirement documents for the Structure of the

files

. Wrote test plans and test cases using Quality center

. Logged the Defects using the Mercury quality centre

. Used SQL navigator for the Data validations

. Used SQL queries to validate the Data bases

. After running the ETL scheduler validated the Data properly updated

into target tables

. Participated in functional testing of web enrollment and check those

are properly updated in database

. Used XML SPY to read the xml files and validated the structure and

Data

. Monitored Batch processing

. Monitored Batch queuing system for schedulers that plans the execution

of jobs

. Validate Batch process logs and Error notifications for the different

servers

Environment: Quality centre 9.0,Rational clear quest, clear case Web sphere

5.0.2, MQ Series, Sage CRM 5.0, Oracle9i, Main frames, Java, ASP.NET, XML

SPY, Ultra edit -32, Informatica Power center, IBM Data stage, SQL server,

Serena Team Track, Microsoft Team foundation server

Mercury Insurance, Brea CA

Jan '06 to Apr'07

Sr QA Analyst.

Involved in the conversion project called currentgen which is the

agent/customer tool for the auto Insurance where the customer can get the

quotes and the premium rates for his auto insurance.

Responsibilities:

. Reviewing Business Requirement Documents and the Technical

Specification Set up a QA process and ensured it was effective project

wide.

. Documented test cases corresponding to business rules and other

operating conditions.

. Participated in Gap analysis and Let business team knows my

observations

. Administered & Developed Test Plans using Test Director to ensure that

test cases reflect user needs for the functional, User Interface,

Performance, Usability and Security requirements.

. Logged defects using Test director

. Wrote test cases and test plans using Mercury Test director

. Participated in testing online quotes application for the Web users

. Participated in testing online Claims application such as retrieving

the claims by searching with the claim number and see the updates

. Create the policies for the different agent codes for different states

. Participated in parallel testing for both the Nextgen and Currentgen

systems

. Participated in testing of converting database into DB2 created the

report for different policies for different sates

. Wrote automated scripts for the data driven testing using Quick Test

Pro. Checked for navigational flow and broken links

. Analyze the log files to verify data transferred properly and check

the flat files if there is any data missing while calling to the third

party applications

. Participated in System Testing

. Automated the some of the manual scripts to test the functionality of

the Application for different states

. Create the claims using the different policies and submitted the

claims for different sates

. Participated in change management process

. Participated in productions support

.

Environment: Java, HTML, XML, DB2,ASP,.NET, MS Office, Test Director, QTP,

IBM Mainframes, Cobol, Rational rose,AS400

Ameriquest Mortgage/, Citi Group ORANGE CA

Nov 2004 to Dec 2005

Sr QA Analyst

Ameriquest Mortgage Company (City group) is one of the nation's oldest and

largest home-equity lenders today, with over 250 branch offices serving 46

states; this is the nation's largest privately held retail mortgage lender.

Ameriquest uses an Eastern Software product, Empower to originate loans,

Ameriquest at this time is also moving towards its own LOS called ASAP.

Both the Loan Originating System's are interfaced with the wires

application.

Responsibilities:

. Reviewing Business Requirement Documents and the Technical

Specification Set up a QA process and ensured

it was effective project wide.

. Documented test cases corresponding to business rules and other

operating conditions.

. Administered & Developed Test Plans using PVCS Tracker to ensure that

test cases reflect user needs for the functional, User Interface,

Performance, Usability and Security requirements.

. Created Test input Data Requirements and prepared the test data for

data driven testing.

. Created and executed Test scripts to verify complex system

requirements.

. Performed Regression testing for User interface

. Work closely with sox Team, Prepared the test case for SOX team with

SOX related scenarios

. Tested the SOX related securities in the project

. Manually created the loans using Empower

. Well versed with Empower LOS

. Manually tested the Workflow of empower

. Participated in testing the Underwriting and Pricing functionalities

for the Loan Origination system

. Manually tested the Wires Application integration with the Empower LOS

. Participated testing the batch files which are processed every hour

and end of the day

. Intensively participated in the IWIRES project where as all the wires

has been sent through this application instantaneously

. Involved in the functional testing of PeopleSoft Accounting entries

. Created sales orders

. Created cash orders using PeopleSoft

. Participated in testing PeopleSoft AP and PO account modules

. Participated in testing SOAP based web calls

. Pointed the SOAPUI to WSDL to test the particular web calls

. Participated in testing the SOAP headers for the data which has been

sent and returned

Environment: Windows, Java, Delphi, HTML, XML, ORACLE, People soft, MS

Office, PVCS Version Manager, PVCS Bug Tracker, Clear Quest, Win Runner,

PeopleSoft8.4, Lotus notes, Informatica, Niku

Wells Fargo, CA

Oct 2003 to Oct 2004

Sr QA Analyst

. I was involved in the testing of Online Brokerage Application which

allows the customer to View the Account status, Asset allocation chart,

order status, account holdings and current market indices. I worked for

three different teams namely, Functional QA Performs functional/regression.

Systems QA core project team, which performs the end-to-end testing.

Performance QA Performs Load/score card testing for all projects in the

eBusiness department.

Responsibilities:

. Reviewing Business Requirement Documents and the Technical

Specification. Set up a QA process and ensured it was effective

project wide.

. Documented test cases corresponding to business rules and other

operating conditions.

. Administered & Developed Test Plans using Test Director to ensure that

test cases reflect user needs for the functional, User Interface,

Performance, Usability and Security requirements.

. Created Test input Data Requirements and prepared the test data for

data driven testing.

. Created and executed Test scripts to verify complex system

requirements.

. Developed test scripts using Quick Test Pro to perform functional and

regression testing.

. Created the Test Data .The scenarios were run for Vuser load of 1000,

1500 and 2000 respectively

. Included various Load runner monitors for monitoring Application

servers and Database servers

. Developed re-useable code to share functionality with different tests,

there by providing easy to maintain and modular test scripts.

. Responsible for monitoring the server by running the scripts under

load conditions and to identify the bottlenecks.

. Monitored Test Director to close the bugs/cases as and when developers

fixed the bugs.

. Reviewed the functional and operational specifications and prepared

work plans for UAT testing.

Environment: Windows, UNIX, XML, HTML, J2EE, .NET, Web logic, C++,

Oracle, MS Project, Win Runner 7.5, Quick Test Pro 6.0, LoadRunner7.5 and

TestDirector7.5.

PRUDENTIAL FINANCE, NY

Oct 2002 TO Sep 2003

QA Analyst

Responsibilities:

* Prepared Detailed Test Plan and Test Cases by understanding the

business logic and User Requirements for Manual and Automated testing

* Wrote Test Plans, identify Test Strategy and Objectives, Develop Test

Cases, Test Procedures, Automation Scripts and Generic scripts

* Identified defects and interacted with developers to resolve issues

Environment: Win Runner 7.0, Test Director 7.0, Oracle8i, SQL, Java, JSP,

Struts, EJB, HTML, JavaScript, Windows NT and Web logic., Drupal

PINNACLE PLC HEARTFORDSHIRE UK Aug

2001 to Sep 2002

QA Tester

Responsibilities:

. Involved in analyzing functional and system specifications and

developed detailed System Test Plan.

. Involved in writing and implementation of Test cases for various

modules using Test DirectorEnvironment: Win Runner 6.5, Test Director

6.5, Oracle8i, SQL, Java, JSP, Struts, EJB, HTML, JavaScript, Windows

NT and Web logic.

NATWEST BANK, LONDON

QA Tester

June 2000 to July 2001

Responsibilities

. Worked with Business analysis team to prepare a detailed Test plan of

the application.

. Involved in writing and implementation of Test cases for various

modules using Test Director.

. Performed Manual Testing.

.

Environment: Manual testing, Test Director 6.0, Load Runner 6.0, Oracle8i,

SQL, Unix Java, Swings, JSP, Struts, EJB, HTML, JavaScript, Windows NT and

Web logic.

LYNX, LONDON

April 99 to may 2000

QA Tester

Responsibilities:

. Participated in Manual Testing

Contact this candidate