Lakshma R Tatiparthi

561-***-****

ably8s@r.postjobfree.com

Summary:

. 8 years of diverse experience in Quality Assurance (SQA) and Software

Development Lifecycle (SDLC).

. Experience in writing Test plans, Test Cases, Test Scripts, Test Data,

Traceability Matrix and Test Summary Reports.

. Extensive experience in running various kinds of tests such as Unit,

Functional, Regression, Integration, System, Performance, Load, Stress,

Backend and User Acceptance Test (UAT) for Web (N-Tier), Mainframe,

Datawarehouse (ETL) and Client/Server Applications.

. Experience with Mercury Suite (Quality Center, QTP, Winrunner and

Loadrunner).

. Experience in writing SQL queries on Oracle, SQL Server and DB2

databases.

. Highly motivated individual with demonstrated analytical and mature

decision-making and problem-solving skills.

. Strong knowledge of corporate organizations and policies and a

comprehension for business, technical, and functional processes.

. Provide overall technical leadership to the QA team.

. Design, build, and manage the QA environment comprising of systems on

Linux, Windows, routers/ switches.

. Work with development team to design different types of testing for Linux

based software.

. Design, write, and execute test-scripts to exercise business logic of the

core application.

. Manage bug database, report and file bugs into the database, and

interface with engineering/operations team for bug-fixes.

. Possess excellent communication skills along with verbal and written

skills.

. Good team player and have ability to work independently

Technical Skills:

Operating Systems : UNIX, Windows (XP/NT/2000/98/95).

RDBMS : Oracle, SQL Server, MS-Access,

DB2.

Test Tool : QTP, Win Runner, Load Runner, Quality Center,

Test Director, Rational Tools (Clear Quest, Clear

Case, Requisite Pro, Test Manager), PVCS

MS-Suite : Word, Excel, Visio

Languages : C, C++, JAVA, SQL, PL/SQL, TSL.

GUI Tools : ASP, Visual Basic, Developer/2000.

Web Technologies : VB.NET, ASP.NET, XML, DHTML, VBScript,

JavaScript and JDBC.

Middleware Technologies : WebMethods6.0, MQ Series 5.0

Reporting Tools : Business Objects XI

r2/6.5.1/6.1b/5.x, Cognos,

Certification: Brainbench Certified for Software testing.

Education: Masters in Information Systems, Australia.

Professional Experience:

Dycom Industries, LLC. West

Palm Beach, FL Oct'09 - Present

Sr. QA Tester/ Analyst

Field Check 2.1.5..0/2.1.8.3

Field Check is also known as Image Approval System. Once the Locator is

done marking their facilities, they close the Ticket - Ticket is then

transferred to Database and it could be viewed through Field Check

application. Supervisors can approve the ticket; can send a ticket to QC or

Coaching. Supervisors can see the different reports and history of the

Ticket.

This application also let upper management to view their Hierarchy and

tickets information of the reporting subordinates.

Responsibilities:

. Involved in Manual Testing of the application

. Tested all modules of the application

. Updated and added new Test cases in HP Quality Center

. Coordinated with other members of QA Team, to understand the

application

. Went through the old test cases and old defect in Quality center to

better understand the application

. Assigned defects to developers after discussing the issues with them

. Performed the Security testing of the application i.e. only

supervisors and management can access the application, and only

manager can access and approve the ticket for their subordinate's

level.

. Updated QA Lead and ITS manager about the progress of testing

. Tested the ETL process for both before data validation and after data

validation process. Tested the log messages published by ETL tool and

data loaded into various databases

. Tested the ETL progress, to make sure, all different types of ticket

along with all the images are passing to Field Check Application.

. Runs the ETL job each time when ticket transferred to SQL DB.

. Tested the reports prepared with Microsoft reporting tool and observed

the results of the report with correct data population.

. Knowledge of web debugging tool Fiddler.

. Worked with business team to test the reports developed in Microsoft

Reporting tool SSRS.

. Performed thorough regression testing after each build/patch.

. Executed the different stored procedure to make sure, all the

Hierarchical information is appearing as in Database SQL Server

. Designed and executed SQL Queries to verify the Data

. Compared the Data of Utiliquest QManager admin to Field Check

application.

. Verified and tested the Production Issues.

. Make sure, all the RFC's go through QA Environment first.

Environment: Window XP SP3, Microsoft Visual Studio, Asp.Net, C#, Microsoft

SQL Server2008, HP Quality Center 10, Mercury Quick Test Pro 10, ETL, Web

Services, TFS (Team Foundation Server ), MSMQ, Microsoft Reporting tool

SSRS.

Gentiva Health Services, Tampa, FL

Oct'07 - Aug'09

Sr. QA Analyst

Life Smart Technologies is based on the re-platform of Home Care Home

Base's PDA (HCHB) and workflow-driven application and is designed to

replace the current Gentiva front end application, UNITY, and provide the

technology needed to support Gentiva growth.

The project is two Phases 1.Adm/ops. 2. PDA

1. Adm/Ops: This is backend office application that maintains all patient

care services and employees details including all administration details.

2. PDA: This is windows based mobile application. LST application that is

installed in PDA to record patient data and send it back to Adm/Ops using

synch.

. Developed Test Plan for the ADM/Ops project.

. Developed test cases and traceability matrix for the application.

. Managed tests using Mercury Quality Center.

. Writing functional test scripts, workflow test scripts. Review/Update

functional specifications, Prototypes, Requirement documents etc

. Perform functional test to verify that all functionality of the hand held

device (PDA) works according to the functional specification and fulfills

all requirements

. Perform functional test of the Back Office WEB application to verify that

all functionality works as designed and according to the functional

specification.

. Testing the Back Office Web application includes verifying functionality

and data integrity of Worker Information, Patient Information, Physician

Information, Clinical Input, Payer Source (Medicare, Medicaid, and

Commercial Insurance etc), Visit episodes, Reports and Billing.

. Used SQL and UNIX scripts extensively to validate the data.

. Involved in testing the application at unit level, module level and

system level for quality of the software. Performed integration testing

for the system compatibility.

. Tested the ETL Workflows and other ETL Processes (Data Warehouse Testing)

. Reviewed and analyzed ETL specifications and conducted ETL tests.

. Used QTP for automating the application.

. Developed Test cases for UAT testing and performed UAT tests.

. Involved in monitoring test execution and system resource monitoring of

different host machines.

. Created the test data for interpreting positive /Negative results during

functional testing.

. All the defects detected were reported using Quality Center.

Environment: WINDOWS NT/XP, AIX, DB2, SQL, JAVA, J2EE, JSP, WEBSPHERE,

QUICK TEST PRO (QTP) 9.0, Quality Center 9.0, ETL, Informatica, Cognos,

Unix, MS-Office.

UHG (United Health Care Group), Minneapolis, MN Jun'06 -

Sep'07

Sr. QA Analyst

Diamond is a Client/Server System to enter and process of claims submitted

by providers and members. Claims that enter electronically do so through

EDI, the scanning and imaging of paper claims, or through manual entry by a

Vendor. EDI is the system through which healthcare providers, health plans,

and other healthcare stakeholders communicate electronically with UHG. All

commercial electronic transactions must be sent to UHG through EDI. Claims

manually entered by a vendor are equivalent to electronic claims from

scanning or received through EDI. Claims manually entered into Diamond must

pass Diamond edits in order for the entry to be complete. Electronically

submitted submitted claims may pass many other edits, but not necessarily

all of the Diamond edits which would cause EE case. Once a claim has

entered into Diamond, it must pass additional edits in order to be priced.

Responsibilities:

. Developed Test Plan, Test Cases and Test Scripts and followed RUP.

. Responsible for Creating, Enhancing and Executing test cases using

Mercury Quality Center.

. Prepared Test Data as per the functional specifications.

. Participated in Weekly Project status meeting and updated the testing

Progress.

. Identified tests that are most appropriate for automation, created and

maintained both automated and manual tests, and applied techniques that

insure maintainable test assets.

. Used SQL queries to verify the data integrity.

. Created and executed automated test scripts using QTP 8.2 for regression

testing.

. Tested the EDI (270, 271, 276, 277, 835 & 837) transactions.

. Validated the claims and claim adjudication via Diamond.

. Validated the data and worked with JCL jobs on Mainframes.

. Worked with XML and SOAP web services.

. Wrote reusable functions in QTP and created a Library Files.

. Created and used Shared Object Repository for QTP tests.

. Created Recovery Scenarios for QTP tests.

. Tracked defects using Mercury Quality Center.

Environment: Diamond 950, Windows XP, QTP 8.2, XML, SOAP, Quality Center

8.2, Mainframes, Oracle 9i, UNIX, ASP.NET, and VB.NET, MS-office.

IHC Health Services Inc., Salt Lake City, UT

Jan'06 - May'06

Sr. QA Analyst

Intermountain Health Care (IHC), this application accepts different claims

like Dental claims, Pharmacy claims and vision claims from different

vendors and route the claims into Batch Adjudication System and Online

Adjudication. Here the Batch Adjudication System automatically adjudicates

the claims and sends the files to Payment department.

Responsibilities:

. Involved in preparing High Level Test plans based on user requirement

documents.

. Involved in defining Test objectives and performed Manual Testing.

. Involved in cross browser testing using Netscape Navigator and Internet

Explorer.

. Created test scenarios and test cases for the functionality and

integration testing.

. Involved in developing Integration Test Plans and System Test Plans for

the applications.

. Extensively used QTP 8.2 scripts for claim submission and claim

validation.

. Created XML files using XML SPY.

. Validate the claims data on Mainframes using QMF

. Used File-Aid on Mainframes to create test data.

. Involved in testing HIPAA EDI Transactions.

. Created and executed automated test scripts using QTP for regression

testing.

. Involved in measure response time at different pages using LoadRunner.

. Responsible for preparing User Manuals.

. Used SQL Queries and Unix shell scripts.

. Tracked defects suing Test Director.

. Participated in regular project status meetings related to testing.

Environment: Java2.0, J2EE, Oracle 8i, TOAD, Mainframes (COBOL, JCL, CICS,

FILE-AID, QMF), MS-Project, Windows 2000/NT, UNIX, XML, XML SPY, Test

Director, LoadRunner, QTP 8.2.

Sisters of Mercy, St. Louis, MO

Aug'05 - Dec'05

Sr. QA Tester

As a Senior Tester for Mercy Plans, I was involved in testing EPIC (ADT,

Prelude, Resolute and Cadence) applications, HL7 Messages and

Membership/Benefits applications.

Responsibilities:

. Participated in Requirement Analysis, Business Analysis, Use-Case

Analysis and Gap Analysis.

. Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test

Beds, Test Data and Traceability Matrix.

. Rational Unified Process (RUP) was followed through out the project and

all artifacts are generated for each discipline.

. Conducted Integration, System, Functional, GUI, Regression, Smoke,

Database Integrity, User-Acceptance (UAT) and Performance testing.

. Test Management was done using Test Director.

. Developed Test Cases and Test Design using Test Plan Manager (Test

Director).

. Developed and executed manual tests using Test Director for system

testing of the application.

. Conducted End-End testing.

. Worked with SQL, PL/SQL and functions to test the database integrity

(Oracle).

. Created Traceability between Requirements and Test Cases.

. Tested various HL7 messages for In-Patient (ADT) and Resolute modules of

EPIC.

. Tested the scenarios of Hospital Billing and professional billing in EPIC

Resolute.

. Tested the Admit Patient, Discharge Patient and Transfer patient

scenarios in EPIC ADT.

. Involved in testing billing and claims in Resolute

. Tested various encounters in EPIC.

. Worked with EDI/X12 transactions and tested the claims in Mainframes.

. Worked with UNIX Shell Scripts.

. Tracked the defects using Test Director and generated defect summary

reports.

. Tested the data on Mainframes and tested the interfaces to Mainframes.

. Worked with batch files and batch jobs (JCL) on Mainframes.

. Created test data using File-Aid on mainframes.

. Involved in various sign off meetings with the lead developers, Business

analysts, Managers and Team leads

. Responsible for giving the status of the defects in the daily meetings

. Participated in bug triage meetings with developers to validate the

severity of the bug and responsible for tracking of the bug life cycle

using Test Director

. Involved in knowledge transfer of the application.

Environment: EPIC Suite 2006 (ADT, Prelude, Resolute, Cadence), Test

Director 8.0 / Quality Center 8.2, QTP 8.0, Java, J2EE, WebSphere, Oracle

9i, TOAD, Mainframes (Cobol, CICS, DB2, TSO, JCL), Windows XP, UNIX and MS-

Office

All State Insurance, Chicago, IL

Jan'04 - Jul'05

QA Tester

Worked as a System Tester for All State Insurance. The application was

developed in Oracle and consisted of three main modules: 'Query', 'Policy'

and 'Rate Quote'. The 'Query' model was the interface with the insurance

agent to query the database and generate customizable reports. The 'Policy'

module concerned the various insurance sectors including, Auto, Life and

Fire insurance. The 'Rate Quote' module provided rates and payment terms,

funding and protection options, and coverage details for the various types

of insurance.

Responsibilities:

. Involved in System Testing, creating and running scripts

. Manually implemented several test scripts and documented the results

. Performed Functionality Testing and GUI testing.

. Involved in testing applications developed using Dotnet framework.

. Tested XML applications.

. Tested Web Services which is used for accessing Remote Applications Using

SOAP protocol.

. Conducted the Unit Testing of .NET applications.

. Automated the VB.Net, ASP.Net applications using Quick Test Pro.

. Developed XML test files based on XML schema.

. Wrote and enhanced test cases and test scripts by adding the required

functionality as per the business requirements.

. Used Test Director as the bug reporting tool.

. Developed Test Plan, Test Procedures and Process for UAT testing and

involved in Installation Testing.

Environment : VB.Net, ASP.Net, ADO.Net, C#, XML, SOAP, VB, VB script, HTML,

IIS, Web Services, ORACLE, Microsoft Visualstudio.Net, Windows NT/2000,

Test Director,MS-Word, Ms-Excel, MS-Project.

AT&T, IL

May'02-Dec'03 QA Test Engineer

Worked as a software-testing consultant on project "ICES System" that

maintains transactions and updating related to order processing and also

the software records sale orders received from the customers and records

the deliveries made against the orders.

Responsibilities:

. Analyzed system requirements and wrote test cases for testing the

application.

. Worked closely with business analyst, Developers and database architects

in identifying the outstanding issues and contradictory statements

in User requirements.

. Involved in testing of database using SQL queries.

. Investigated software bugs and interacted with developers to resolve tech

issues.

. Analyzed user requirements and documented them using Quality Center.

. Utilized Quality Center for tracking requirements and communicating them

to the team during the test Process and integrated this capability with

e-mail, ensuring that all the communication about a Requirement is in a

single location.

. Performed Functionality and Regression Testing on new builds of the

software.

. Involved in the End-To-End test and responsible for the Quality Assurance

of this application to Complete in record time.

. Contributed to the product documentation, including online help.

. Developed test cases and scripts for Stress and Performance Testing of

the application by creating Virtual Users.

Environment: WinRunner, Quality Center, Windows NT, Unix, Visual Basic, SQL

Server, and Oracle.

Medi Bank Private, Australia

Jan'01- Mar'02

Developer / QA Tester

Responsibilities:

. Developed test cases by decomposing use cases for specific functional

requirements

. Interacted with Business teams and Developers to understand business

requirements and bug fixes

. Created and maintained traceability matrices. Used this matrix in

performing impact analysis for changing requirements

. Created Objects for web page in VB and Java

. Wrote the test cases and scripts for functionality testing

. Involved in data migration from legacy database (Mainframe) to Oracle

database.

. Wrote SQL queries to validate the data in Oracle Database

. Reported all the bugs to the developers using Test Director

Environment: WinRunner, Test Director, Load Runner Java, JSP, Web Logic,

XML, VB, Oracle, and Windows NT

ANZ Bank, Melbourne, Australia

Mar'00- Dec'00

QA Tester

Responsibilities:

. Analyzed user requirements and functional design specification and

reviewed the Test plan.

. Prepared detailed document of test cases using User Requirement Document.

. Developed automated test scripts using WinRunner and performed both

Functional and Regression testing.

. Parameterized the script with spreadsheet, which is generated in test

case data section. And created Compile modules for reusability.

. Extensively conducted database testing using SQL Queries to verify the

database updates and create reports.

. Extensively used Test Director for detecting and tracking defects.

Environment: WinRunner, TestDirector, VSS, Java, JSP, HTML, XML, Oracle,

Windows and UNIX.

Contact this candidate