LAKSHMI DASARI

678-***-****

rorbwr@r.postjobfree.com

References: Will be provided upon request

Summary:

• 10+ years of ETL/BI testing experience with extensive backend testing. Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)

• Intensive experience in SDLC, QA & Defect Lifecycle. Involved in analysis, design and quality assurance of Web applications, Client-Server and Mainframe applications.

• Experience in performing System, Functional, User Acceptance, Integration, GUI and Regression Testing.

• Created Test Plan documents, developed test strategy documents and prepared the Traceability Matrices.

• Expertise in designing the test scenarios and scripting the test cases in order to test the application.

• Experience in testing and writing complex SQL and PL/SQL statements.

• Good expertise in using TOAD, SQL*Plus. Experience in debugging the issues.

• Intense knowledge on Rational Suite (Test Manager, Robot, Requisite pro, Rational Rose, Clear Quest, Clear Case) and Mercury Tools (QTP, Quality Center, Test Director).

• Experience training the teams on the various Rational testing tools.

• Experience working with huge volumes of data, analyzing result sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL

• Actively involved in daily status meetings with the project team. Coordinated the Enhancement and Modification request issues.

• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.

• Proficient in working with UNIX shell scripts using putty Environment.

• Expertize in Health Care Business Process Testing in Mainframe, Vendor Integration and Facets Environment

• Experience in working with HealthCare, Financial, Insurance, Consumer Finance and Pharmaceutical applications.

• In the ETL QA Lead role involved in Project planning, Co-ordination and implementing various QA methodologies.

• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

Software Expertise

• Operating Systems : MS-Windows 95/98/2000/NT/XP, MVS, Sun Solaris 5.8, UNIX, LINUX.

• Testing Tools : Rational Suite Test Studio, Quality Center 7.x / 8.0 /9.2

• Languages : C, JAVA, HTML, SQL, PL-SQL

• Version Control : Rational Clearcase, PVCS

• Development Tools : VBScript, JavaScript, Shell script,

• Database : MS SQL Server 2000, Oracle 11g/10.x/9i, DB2, MS Access.

• Other : MS-OFFICE (Documentation Packages), Microsoft Outlook, Lotus Notes,

VISIO, TOAD 10.1, SQL Assistant

• Reporting Tools : COGNOS, Micro Strategy, Business Objects, SAS

Education:

BS - Bachelors in Science

MS – Masters in Science

MBA – Master in Business Administration

SAP Retail & BW Upgrade Aug 2012-Till Date

ETL QA Lead

Limited Brands Inc.

Columbus, Ohio

Objective of the functional testing effort for the SAP Retail and BW Upgrade is to design, develop, and execute the necessary tests within SAP and BW as well as all applications that integrate after the both systems are upgraded to proactively uncover functional and integration issues. Testing will focus on integration testing between SAP and non-SAP systems as well as standalone tests within SAP. Complete regression scope was chosen due to the many SAP changes.

Responsibilities

• Outline key areas (scope, schedule, timeline, milestones, resource estimation etc) for the Project at a high level

• Propose functional testing approach and communicate to the project team in order to promote awareness and provide details of the testing approach that will be followed for this SAP Upgrade project.

• Develop & Approve Testing Deliverables including Test Strategy. Co-ordinate the test strategy and plan with Project Managers. Facilitate test preparation, & execution

• Coordinate development of business scenarios, test cases, data, and test scripts

• Conduct regular review meetings and oversee the test execution. Evaluate quality of testing and measure the testing progress.

• Supervise & Lead the test team during various releases and test deployments. Ability to mentor and inspire the QA teams.

• Track the status of test case execution in Quality Center and report in the weekly status meeting (daily status meeting for FIT)

• Monitor and report progress of testing phases to testing team and leadership

• Coordinate all Defect Management activities (daily defect reporting and daily defect meeting)

• Capture defects in Quality Centre and discuss in the weekly status meeting. Regular follow up on defects with the project team until the defect closes.

Environment: SAP, Micro Strategy, Sharepoint, Teradata, SQL Assistant, Quality Center, MS Office

Excellus BCBS, Rochester, NY Nov 10 – July 12

ETL Quality Lead

Project : EDW Projects

Worked on the various CMS, Vendor Extract and Data Transformation projects.

Responsibilities:

• Analyzed the functional requirements and prepared the test scenarios.

• Drafted the Test plan document and reviewed the test cases along with the Solution Architect, Development Team and Test Manager for DIT & SIT.

• Participated in analyzing the data with the developer and Business Analyst.

• Created & managed the test scenarios & test cases using the Rational Suite.

• Developed and maintained the Traceability matrix between requirements and test cases.

• Validated the source to target mappings in different data stages.

• Prepared extensive set of validation test cases to verify the data

• Created and executed advanced SQL scripts using TOAD 10.1 to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

• Performed the functional and regression testing in Test, Development and Production environments

• Wrote SQL*Loader script file for reading data from text file and loading into Oracle tables.

• As a Quality Lead - Coordinated with the Project team on the test schedules, discussed the test outputs, created & managed the defects, perform load & reload of the test data in order to meet the project timelines until the project deployment to PROD environment.

• Ensured the test team meets the deadlines with adherence to the project requirements and updating the project manager with the day to day activities.

• Created and managed the defects using the Rational defect management tool.

Environment:

Rational Suite, TOAD, Oracle 10g, Informatica, UNIX, MS-OFFICE, Test Manager

Regence BCBS, Seattle, WA Oct’ 08 – Nov 10

Senior QA Tester.

Tested the Facets application for the Regence BCBS. Tested the Eligibility, Membership and Claims processing applications.

Responsibilities:

• Analyzed functional requirements from Business requirements.

• Prepared Test Plan and Test Scenarios document

• Participated in Risk analysis with dev team and BA.

• Test Case management using Rational Test Manager.

• Participated in functional testing of Facets application.

• Tested the Inbound / Outbound Interfaces to Facets and XML files.

• Tested Custom Reports and Facets Extensions.

• Tested the data mapping to/from legacy to facets through XML that will be used to populate the oracle database.

• Tested adding/updating/deleting of the providers, members, groups, facilities, hospitals in Facets.

• Tested the EDI/X12 transactions (270, 271, 276, 277, 837, 835, 997).

• Tested the Medicare and Medicaid claims.

• Loaded Claims on facets and checked the claims.

• Developed and maintained the Traceability matrix between requirements and test cases.

• Participated in system and functional testing manually and automatically with Rational Tools.

• Automated the reusable functionality using Rational Robot.

• Executed the System Testing, Integration Testing and Regression Testing.

• Attending Bug meetings and design development meetings

• Worked with SQL Queries to validate the data in Oracle database.

• Documented the manuals, user training and reports.

• Performed all phases of end-to-end testing which includes Functional, Regression, GUI, System and Smoke testing.

• Tracked defects using Rational Clear Quest

Environment:

Mercury Tools (Quality Center, Test Directory, QTP), Rational Clear Case, Facets 4.3, Facets 4.5, XML, Mainframes, SOAP, VB script, Windows 00/XP, MS-OFFICE.

Cigna Healthcare, Raleigh, NC Sept’ 06 – Oct’ 08

Senior QA Tester

Cigna Healthcare is one of the largest healthcare companies which provide individual health and small employer group health insurance. Worked as a QA Tester in testing the Web applications, Eligibility, Membership and Claims processing applications.

Responsibilities:

• Managed requirements using Rational RequisitePro.

• Documented Test cases corresponding to business rules and other operating conditions in Rational Test Manager.

• Involved in Developing Test Plans, Test Cases and Test Scripts.

• Performed End-to-End testing manually.

• Responsible for GUI Testing, API Testing, System Testing, Regression Testing and Acceptance Testing.

• Tested the backend database (DB2 / Oracle) using SQL queries.

• Extensively used UNIX shell scripts.

• Tested the Eligibility applications by verifying Eligibility Request (270) and Eligibility Response (271) applications.

• Tested the HIPAA EDI Transactions 837/835 and 276/277 also worked on Medicare Claims.

• Conducted Interface tests and validated the API (Application Program Interfaces).

• Worked with XML/SOAP (web services).

• Worked with Rational ROBOT for Functional and regression testing

• Worked with JCL to Schedule and execute jobs.

• Responsible in providing regular test reports to the management.

• Reported the defects to the developers using Rational Clear Quest.

• Investigate software defects and interact with developers to resolve technical issues.

Environment:

Rational Tools 2003 (RequisitePro, Test Manager, Clear Quest, ROBOT), Facets 2.90, Facets 4.31, Facets 4.5 XML, Mainframes, SOAP, VB script, Windows 00/XP, MS-OFFICE.

Quantros Healthcare, Milpitas, CA Apr ‘05 – Sept’ 06

QA Tester

Project: Quantros the market leader in preventable medical errors data management decision support solutions, to offer HCPro's rich and expansive quality, compliance, and patient safety educational and service offerings through Quantros Knowledge Share channel. Quantros Adds Physician Reporting Module to its Regulatory Reporting Management (RRM) Suite of Solutions and Safety and Risk managements (SRM).

Responsibilities:

• Actively Involved in Software Development Life Cycle and Test Life Cycle, Test strategies, Methodologies and processes.

• Wrote and executed Test plan, Test cases and followed Test Plans to ensure efficient coverage within budget.

• Responsible for creating Traceability Matrix to ensure all requirements are covered by Test cases.

• Worked with Object repositories, functions, data tables and descriptive programming in QTP.

• Developed and executed SQL queries for back-end testing in Oracle.

• Used Quality Center to track and report system Defects and Bugs, writing modification request for the bugs in the application.

• Actively participated in weekly meetings, conferences and walk-through to understand the business and testing requirements and to plan the testing process on a regular basis.

Environment:

QTP, BugZilla, Quality Center, Oracle 9i, 11i, VB Script, HTML, SQL, Unix, WindowsXp.

IBT (Investors Bank & Trust), Boston, MA Jan’ 04 – Mar’ 05

Senior QA Analyst

IBT is one the largest investment bank, Involved in testing the Fund Management applications, Securities, Fixed Income and Portfolio management applications.

Responsibilities:

• Writing and executing software System test plans and Test cases.

• Managed requirements using Test Director.

• Documented Test cases corresponding to business rules and other operating condition in Test Director.

• Involved in Developing Test Plans, Test Cases & Test Scripts.

• Tested the browsers under specific conditions, such as with Java script enabled and disabled.

• Involved in the functional testing of web pages using Winrunner

• Conducted Performance test for web applications using LoadRunner.

• Performed End-to-End testing manually.

• Tested the backend database using SQL queries.

• Extensively used UNIX shell scripts.

• Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing using Winrunner.

• Prepared status summary reports with details of executed, passed and failed test cases.

• Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.

• Responsible in providing regular test reports to the management.

• Conducted browser compatibility test of application

• Reported the bugs, Email notifications to the developers using the Test Director.

Environment:

Oracle 8.1.x, Mainframes (DB2), Windows NT, Test Director, Winrunner, Loadrunner, UNIX.

GEICO, Falls Church, VA Mar’ 02 – Jan’ 04

QA Tester

Tested various Property & Casualty insurance applications. Tested the Under writing, Membership, Claims processing applications. Also tested an application which provides information regarding the services and its policies offered by GEICO. The Home Page incorporates the basic options like available policies and their benefits, terms and conditions and new schemes etc., Links are provided to navigate to different types of policies like Auto Insurance, Life Insurance, Home Insurance and Health Insurance according to the User’s Interest.

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis for application developed in Java

• 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 Rational Test Manager.

• Managed the requirements using Rational RequisitePro.

• Developed Test Cases and Test Design using Test Manager.

• Automated the functionality using Rational Robot

• Developed SQABASIC scripts, used various verification points and developed reusable functions using Robot

• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).

• Created Traceability between Requirements in RequisitePro and Test Cases in Test Manager.

• Worked with Use-Cases (UML) in Rose and tested the hyperlinks of the application using Rational Site Check.

• Created data pools to test various sets of data using Robot.

• Conducted Load/Performance testing by creating VU scripts, Virtual Users and scenarios using Robot.

• Worked with UNIX Shell Scripts.

• Tracked the defects using Rational ClearQuest and generated defect summary reports.

• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.

• Configuration management was done using ClearCase.

Environment:

Rational Test Manager, Rational Requisite Pro, Rational Robot, Rational ClearQuest, Rational ClearCase, MS Office, Oracle 9i, TOAD, MS-Project, Windows 2000/NT, UNIX, Crystal Reports 8.0

Hewlett-Packard, Bangalore, India Jan’ 01 – Feb’ 02

QA Tester

Responsibilities:

• Discussed the Project Requirements with the core team.

• Involved in Functional Study of application.

• Involved in Test cases design, Execution and Defect reporting.

• Involved in GUI and Functional testing of the application.

• Involved in team meetings and KT sessions.

• Tested the Compatibility of Application on different platforms.

• Reviewed the Functional Test cases.

• Involved in the preparation of Release Documents.

• Interacted with developers and discussed technical problems.

• Used IBM Rational Clear Quest to Track and Record the Bugs during all phases of the project.

Environment:

Clear Quest, SQL, XML, DB2, Windows XP, UNIX, Oracle

Contact this candidate