acgogs@r.postjobfree.com

Aruna Makala

QA Analyst

972-***-****

PROFESSIONAL SUMMARY

Over 8 years of IT experience as a Quality Analyst in Manual, Automation and backend

Testing. IT experience ranges Health Insurance, Telecom and Auto Insurance with strong

functional knowledge. Experience in the Software Development Life Cycle (SDLC) using

the Waterfall Model and Agile Methodology.

Experienced in preparing Test Strategy, Test Planning, creating test data and building

automation framework using soapUI and QTP.

Expertise in creation and execution test cases using Quality Center, Rational Manual

Tester.

Implemented Agile and Waterfall methodologies and participated in sprint planning and

daily scrum meetings and defect Triage meetings.

Performed various kinds of Black-Box/White Box testing like User Interface testing,

Functional Testing, Integration, Regression testing, Security, compatibility, web services

and backend testing.

Experienced in analyzing the requirements and communicating the testability of the

requirements to the Business Analysts, thus helping them in providing testable

requirements to the project team.

Performed Back end Testing-using SQL queries, generating reports to ensure data

integrity and validate the inserted and updated data.

Experienced in developing test cases by understanding and working with Use Cases.

Implemented test Scripts and ran the test cases in UAT environment.

Used HP Quality Center and Rational Manual Tester for writing and executing test cases.

Experienced in data base testing using MS SQL Server and Oracle.

Experienced in understanding WSDL, schemas and Testing Web Services.

Created Test Suites, Test Cases, Data Driven tests and prepared text execution results

reports using soapUI.

Participated in various reviews and meetings with the development team.

Strong experience in documenting existing process, analyzing business requirements,

working with requirements traceability matrix, re-engineering business processes and

designing.

Experienced in testing application in Windows, MAC OSX and UNIX environments.

Experienced in compatibility testing using IE, Mozilla Firefox, Google Chrome and Safari.

Experienced in testing web based applications based on Java and .NET frameworks.

Experienced in planning, executing, monitoring, analyzing and documenting of all testing

related activities.

Ability to handle multiple tasks and work independently as well as in a team.

Ability to meet deadlines and handle pressure coordinating multiple tasks in project.

Team player and self-starter with excellent communication, coordination, documentation

practices which proven to coordinate with team to get efficient results and also capable to

adopt and learn new tools, techniques and approaches.

TECHNICAL SKILLS

Automation Tools : Win Runner, QTP 11, Test Director, Rational Clear Quest,

Rational

Clear Case, Transact-SQL, Quality Center 11, soapUI 4.5

Defect Tracking Tools : JIRA, Rational Clear Quest, HP Quality Center, Rational Team

Concert, Bugzilla

Agile Tool : Rally, TFS

Databases/Tools : MS SQL Server, Oracle, Transact-SQL, TOAD and SQL Developer

Languages : Java, SQL, PL/SQL

Web Technologies : HTML, XML, Java, VB Script, Java Script, ASP, .Net, Visual

Studio.

Operating Systems : Windows, Sun-Solaris, UNIX, Linux, MAC OSX

Utility Tools : MS Project, MS Office, MS Visio

PROFESSIONAL EXPERIENCE:

Interstate Batteries, Dallas TX May14 to Nov14

To Purpose of this project is to give the Distributors the ability to view, sort, edit and print their

recommendations by sales parts, Dealers and various other filters to give the distributors a way to

capture the RSM assignment and activity. And Tracking Master Specification is to be able to measure

the success of the different recommendations and execution of those recommendations.

Environment/Technologies: Windows XP, Micro Strategy, Integrity manager, Informatica, Oracle,

SQL Developer, Microsoft .Net, XML, Test Case Migrator, Microsoft Test Manager, Microsoft Outlook,

Visual Studio, WebEx live meeting, Microsoft Scheduler, SharePoint 2010, Quality Center 11.0, TFS

and Web Services.

Environment/Technologies: Windows XP, Micro Strategy, Informatica, Oracle, SQL Developer,Test

Case Migrator, Microsoft Test Manager, Visual Studio, Microsoft Scheduler, SharePoint 2010, Quality

Center 11.0, TFS and Web Services.

Responsibilities:

Sprint planning, Backlog review, Sprint Review, Sprint Retrospect, Daily Scrum.

Created Manual Test Plans and Test Cases for testing of windows desktop, Web, and

mobile .Net applications.

Created SQL queries and SQL stored procedures to test the ETL Process in the target

database against the source tables.

Worked with TFS to create the Test plans and Test cases and logged defects to management

life cycle of testing.

Worked with Business users to gather requirements for developing reports and dashboards

using Microstrategy BI tool.

Assisted users on running the dashboards and helped with understand the functionality of the

reports.

Co-ordinated with development team to understand the datasets and the reports to write the

test cases and SQL queries to testing the reports.

Blue Cross Blue Shield of Texas (HCSC), Richardson TX Oct 11 to April 14

HCSC Blue Cross Blue Shield is a health insurance company. Healthcare ON/OFF exchange 2014

implementation for IL, TX, NM, OK and MT divisions.

Environment: QTP, SoapUI, VB Script, MS SQL Server 2008, XML, Quality Center 11, Rational Clear

Quest 8.0, Rational Team Concert, web services

Responsibilities:

Implemented Agile/Scrum methodology.

Worked closely with Actuaries to understand the semantics as how to come up with factors after

analyzing the hundreds of claims data containing billions of records.

Configured different types of factors for generating rates.

Designed and developed Test scripts using soapUI and validated rates for different plans.

Used Quality Center for creating Test Plans, Requirements, Test Cases, Reporting defects and

generated reports.

Performed Functional, Smoke, Usability, System Testing, Regression Testing of FMA, RFRF and

RVA web applications.

Prepared the traceability matrix and mapped the requirements to the test cases.

Prepared soapUI test suite, test cases and validated soapUI responses using assertions.

Responsible for identifying testing risks, dependencies by elaborating the testing assumptions,

and developing mitigation procedures, contingencies.

Performed database validation using Toad for Oracle database.

Extensively wrote SQL Queries to verify that the data is populated from the Database matches

with the front end screens.

acgogs@r.postjobfree.com

Involved in compatibility testing using different browsers and operating systems.

Involved in testing mobile web applications and apps testing in apple (IPhones and Tablets) and

android (Touch screen) devices.

Involved in set of activities from monitoring and troubleshooting mobile application, content and

services on real handsets.

Involved in verification and validation of hardware devices and software applications.

Generated performance comparison charts and documents with each build release.

Executing daily automation scripts and generating defect reports using RTC and Quality Center.

Involved in defect Triage meetings and daily testing touch point meetings.

Chase, Chicago IL Jan 08 to Aug 11

The purpose of the project is to consolidate all warehouses into a unified warehouse. Data is reported

differently, with varying levels of accuracy, and with significant duplication of effort. The goal of this

initiative is to create a unified repository of data for all applications that require warehouse and

tracking data spanning multiple systems. The consolidation will reduce inconsistencies in reporting,

better define sources for specific data sources, and improve data quality. The environment consists of

.NET applications along with java script. Applications are Web based TCP/IP and UDP running in a

custom framework. The architecture consists of Windows 2000 Server, IIS6.0, and Actuate Reporting

Server; People soft, SQL Server, and ORACLE.

Environment: JAVA, J2EE, Web Sphere, Visual studio, VB Script, MS SQL Server 2000, DB2, VC++,

Oracle, .NET, HTML, DHTML, Unix, XML, Quality Center.

Responsibilities:

Analyzed wireframes and stories and performed sanity testing.

Implemented Agile/Scrum methodology.

Extensively involved in developing use cases for UAT.

Developed scripts based test cases and use cases to automate the execution process for running

the reports and cubes.

Proactively communicating ideas and process and being productive within a complex project.

Test Result evaluation, documentation, and reporting in UAT environment.

Testing status reporting.

Defining entrance and exit criteria.

Determining test resource needs and needs to Build Test Environment.

Identifying risks, dependencies, mitigations and contingencies.

Identifying test tools and/or automation techniques.

Involved in preparing System and Acceptance Test plan.

Involved in writing various test cases for System, Implementation and Acceptance Tests.

Reviewed test cases, test data prepared by the testing team.

Involved in documenting the test log and test defects.

Involved in creating requirements for environmental set up for various types of testing.

Identified Automation and manual test scenarios.

Extensively used SQL queries for validating data using SQL Server.

Prepared test execution reports and defect reports.

Interacted with team members to identify and resolve technical issues.

Aetna Health Insurance Co, Hartford CT Feb 07 to Dec 07

Claims Management System (CMS) is an enterprise wide system to process and disburse payments

to healthcare professionals/providers and also manage the clients claim history. The system allows

healthcare providers to submit claims via a multitude of options like manually by mail, or electronically

from their billing systems and also by fax/email services.

Environment: FACETS, Rational Manual Tester, Test Manager, Clear Quest, HIPAA.

Responsibilities:

Responsible for reviewing the Business Requirements and Design specifications

for clarity and testability.

Responsible for communicating the need of testing resources to project managers and requested

dedicated environments/data for testing.

Responsible for designing the Test strategy in UAT.

Responsible for developing Test Inventory Coverage Matrix to ensure that the test cases

encompass all the business/functional requirements.

Responsible for developing test scripts for automation using Rational Robot/Rational Functional

Tester.

Responsible for execution of Test Cases.

Responsible for capturing the test metrics and develop status reports on test execution coverage

for the management.

Responsible for tracking of defects using Rational Clear Quest.

Responsible for the defect management by following up with the concerned parties on the

resolution and implementing the fixes based on priority and severity.

Analyzed and translated the business requirement documents into test scenarios.

Created Test Cases and modified existing test cases in Rational Manual Tester.

Created extensive Data Driven Test scripts for reading data from Data Pool.

Interfaced with developers to resolve technical issues and investigated software faults.

Cablevision, long island NY Mar 06 to Dec 07

The Enterprise Data warehouse project(HR and Billing) for cablevision will focus on the design,

construction and implementation of an enterprise data warehouse (EDW) that will include a data

warehouse environment consisting of a populated staging area, an enterprise data repository, subject

area data marts, enterprise metadata repository and design of appropriate governance processes and

organizational changes. The enterprise reporting tool of this data ware house is Cognos tool.

Environment: JAVA, Mainframes, J2EE, Web Sphere, VB Script, MS SQL Server 2000, DB2, VC++,

Oracle, .NET, HTML, DHTML, Unix, XML, Jira.

Responsibilities:

Analyzed business requirements and system specifications to understand the application.

Participated in requirements gathering meetings.

Prepared Test Strategy, Test plan, Test Scenarios and Test Cases as per the requirements.

Responsible for execution of Test Cases.

Responsible for capturing the test metrics and develop status reports on test execution coverage

for the management.

Responsible for tracking of defects using Rational Clear Quest.

Responsible for the defect management by following up with the concerned parties on the

resolution and implementing the fixes based on priority and severity.

Responsible for documentation of the results by updating the test logs.

As the test lead, responsible for monitoring of all testing related tasks and coordinating the testing

team activities.

Used Clear Case tool for revision controlling by working on snapshot views.

Responsible for identifying testing risks, dependencies by elaborating the testing assumptions,

and developing mitigation procedures, contingencies.

Prepared test execution and defect analysis reports.

Perform backend testing using SQL Server.

Involved in Integration testing of various different modules.

Attending meetings with QA Team, Development Team and Project Management Team.

Responsible for documentation of the results by updating the test logs.

As the test lead, responsible for monitoring of all testing related tasks and coordinating the testing

team activities

Contact this candidate