Test Cases Developer

SUMMARY

Decisive, goal oriented and result-focused IT professional having around

8+ years of hands-on experience in all aspects of Software Development

Life Cycle and Software Test Life Cycle. Seeking assignments in IT Program

with a growth oriented organization.

HIGHLIGHTS

. Around 8+ Years of extensive experience in Software Testing and

Development.

. Rich experience on using HP Quality Center/Application Life cycle

Management (ALM) for creation and execution of test cases and for

tracking defects and requirements.

. Experience in testing Web applications including GUI Testing, Regression

Testing, White Box Testing, Database Testing, Integration Testing, System

Testing, Performance Testing, Stress Testing, Functional Testing and Unit

Testing.

. Experience in Agile and waterfall methodologies.

. Rich experience on using SQL queries on Oracle and SQL Server.

. Experience in OBIEE regression testing. Validating the Oracle Business

Intelligence reports against the database.

. Successfully coordinated various teams on requirement elaboration, user

story development, prioritization of requirement and successful

implementation of the project.

. Proficient in all phases of Software Test Life Cycle from test planning

to defect tracking and managing defect Life Cycle and also.

. Planned and executed Software Development Life Cycle starting with

requirement study, Analysis, design, development, testing, implementation

and production support.

. Expert in Functional Analysis, Gap Analysis, software QA processes

Business Process Re-engineering and good exposure to quality practices.

. Proven expertise with entire QA life cycle activities such as

requirements analysis, design, development and implementation of Test

scripts/Test cases, entry and exit criteria's, defect tracking and

documentation.

. Detail oriented with strong analytical and troubleshooting skills.

. Mentoring the resources about the project, technology and process.

. Strong aptitude for learning and understanding business process and

needs.

. Ability to work in a team environment or independently.

. Good at multi-tasking and working well under tight deadlines with high

efficiency.

. Strong verbal and written communication skills.

EDUCATION

. Master of Computer Applications from Osmania University, India

. Bachelor of Commerce (with Computers) from Osmania University, India

TECHNICAL SKILLS

. Testing Tools : HP Quality Center / HP ALM, Quick Test Pro

(QTP)/UFT

. Database : Oracle 10g and 11g(SQL/ PLSQL), OBIEE 10g and 11g

. Scripting Languages : HTML, JavaScript, VB Script, PLSQL Web Tool

Kit.

. Reporting Tools : OBIEE.

. Source Control Tools : Visual Source Safe(VSS), Team Foundation

Server(TFS)

. Other Tools : Toad, SQL Developer, Putty, Winscp

. Operating Systems : Windows, Unix,

. Microsoft office suite

CERTIFICATIONS

. HP Accredited Integration Specialist Application Life cycle

Management(ALM) 11.x

. Oracle Business Intelligence Foundation Suite 11g Certified

Implementation Specialist.

. Oracle PL/SQL Developer Certified Associate.

WORK EXPERIENCE

Care First Inc, Owings Mills, MD Dec

2013 to Present

QA Engineer

Care First is the largest health care insurer in the Mid-Atlantic region.

Claim Processing system is a web application which comprises member

benefits and claims which obtains the data from Member Portal Database.

Member Portal UI consists of Member data pertaining to benefits coverage

and Claim Details such as Member account details, Member Plan--Benefits,

Claims, Deductible etc. Scope of the testing includes testing of Benefits

of the member, Claims of a member (3 year history), Cost Estimator, Find

Provider, Quick Links, Communication Center, view/request ID Cards etc.

Contribution:

. Validated the member data that is displayed in the UI portal against the

Member Portal database (Using Oracle Queries on SQL Developer).Involved

in Claims and Membership validation

. Regression Testing after redesign of the UI layout.

. Generated test procedures from Business Requirements Documents, Software

Design Documents, Use Cases, User Stories.

. Built requirements/stories into test scenarios.

. Identified the Test Cases and documented them in Quality Center/ALM.

. Used Quality Center to store all testing results, metrics, implemented

Test plan Document, created Test Cases, Defect Tracking & Reporting.

. Developed Test Scenarios, Test Plans, Test Cases and Test Logs and

customized scripts.

. Mapped requirements to test cases using QC/ALM.

. Documented and communicated defects, fix success, failures and status

updates in QC.

. Worked with development team to resolve defects, testability issues.

. Actively participated in review and user group meetings for quality

assurance.

. Involved in creating the Traceability matrix based on Functional

requirement in each module.

. Analyzed test results against requirements.

. Participates in root cause analysis for defects.

. Review the test cases written based on the Change Request document.

. Performed testing based on Change Requests and Defect Requests.

. Creation of Test Data for Member data according to the scenarios.

. Prepared and Presented weekly and monthly QA Defect and Status Reports to

the different Stake holders of the project using Quality Center.

Technologies Used: .Net 3.5, Oracle 11G, HP Quality Center/ HP ALM, Oracle

SQL Developer.

Wyndham Worldwide, Parsippany, NJ

Nov 2012 to Aug 2013

QA Analyst - BI

Global Credit Card (GCC) project is to obtain the data from different

sources like Cybersource, EVS, DBL and TDR from different regions like

North America, Canada and Europe, load the data into datawarehouse using

Informatica and to produce the reports using OBIEE 11g.

Contribution:

. Analyzed systems and applied technologies to effectively develop and

execute sufficient tests.

. Customized reports and the OBI repository as per customer requirement.

. Involved in repository testing.

. Tested several complex reports generated by OBIEE including Dashboard,

Summary Reports, Master Detailed, Drill Down and Score Cards.

. Testing the data present in fact tables and dimensions tables.

. Extensively involved in writing and designing templates for the Test

Plans and Test cases to

. Validate the access to the System - Security

. Validate the navigation to a particular screen, dashboard, page, and

report

. Validate access to the right data, screens, dashboards, pages, and

reports

. Validate the response time to access a particular dashboard, page and

report

. Validate the capability and ease of using prompts to select data on a

report with specific attributes

. Validate the use of drill down and navigation on Reports

. Validate that the metrics on the Reports provide helpful and valuable

information to help them measure and manage their business processes.

. Involved in Regression testing.

. Involved in testing the OBIEE reports by writing complex SQL queries.

. Interact with Offshore team update their status to Client team.

. Assist business users in defining User Acceptance Testing, test cases and

plans.

Technology Used: OBIEE 11.1.1.6.10, Oracle 11G, HP Quality Center/HP ALM,

Oracle SQL Developer.

Journal Sentinel, Milwaukee, Wisconsin

Dec 2011 to Oct 2012

Automation Tester

The Milwaukee Journal Sentinel is a daily morning broadsheet printed in

Milwaukee, WI. It is the primary newspaper in Milwaukee, the largest

newspaper in Wisconsin and is distributed widely throughout the State. The

Milwaukee Journal Sentinel is a subsidiary of Journal Communications, which

is publicly traded on the New York Stock Exchange.

Journal Sentinel Project has around 70 odd applications which manage their

print and publication activities. This project involves the application

support and maintenance of various newspaper related products.

Contribution:

. Automated the Web based Application using QTP 9.5. Involved in test case

design, test tool usage, test case execution and defect management.

. Written Automation Test scripts using VB script in QTP

. Developed and maintained QTP test scripts to support regression testing

whenever a Change Request is completed.

. Create, execute and maintain automated test scripts to verify application

GUI and functionality.

. Enhancing the QTP scripts with Checkpoints, Synchronizations,

Parameterized the scripts for data-driven testing and.

. Involved in writing test scripts, reusable actions and functions in Test

Script Language using QTP for automated testing.

. Involved in Defect Management in HP Quality Center.

. Supported day to day Quality Center activities such as creation of user

IDs and management of permissions (assigning user to a user group).

. Actively participated in Status reporting meetings, and interacted with

Development team to discuss the technical issues.

. Worked closely with developers and other staff members to form a unified

team.

. Participated in Daily Standup meetings, Weekly Status meetings.

Technology Used: Quality Center, QTP 9.5, MS-Office, VB 6.0, VB. Net, SQL

Server 2005, Oracle 10g,Newspaper related vendor products, Crystal Reports,

Ghost Script.

Cognizant Technology Solutions, Hyderabad, India

Feb 2005 to March 2010

Associate

FASTR, Maritz, St. Louis

Oct 2008 to March 2010

Fulfillment Accounting System Transaction Registry (FASTR) is a Rule based

application, which facilitates the Project Accounting, Billing for Awards &

Fulfillment system and General Ledger. These rules are stored in a series

of database tables. This application interface with the Order Processing

(OP) subsystem, the principle scope shall c register accounting

transactions for:

Orders (shipments) that have been initiated to "participants (PAX)" and

Returns of those shipments

Contribution :( Test Lead)

. Conducted White Box Testing.

. Written test cases that ensure the complete coverage of the program

logic.

. Exercise independent paths within a module or unit, logical decisions on

both their true and false side

. Execution of each conditional branch in the code component

. Execution of paths with boundary and out-of-bounds input values and

internal data structures to ensure their validity.

. Executed stubs and drivers.

. Verification of Database design and structure.

. Created and executed test cases that included: software functionality,

negative, boundary, Integration, and regression testing.

. Entered all discovered issues in the Bug Database, tracked, regressed,

and closed those defects.

Technology Used: HP Quality Center, Oracle 11G, TOAD, HTML, JavaScript,

PL/SQL Web Tool Kit.

PROFNET, PR News wire, New York

April 2007 to Sept 2008

PR Newswire's ProfNet Experts service connects spokespeople in

organizations to journalists who are looking for expert commentary on a

particular subject. Available 24/7, the service e-mails queries from

journalists including detailed topic and contact information to

organization spokespeople. Using filter options, organizations can select

from more than 300 subject areas and receive only those queries that apply

to their industry or specialty. When a query arrives that fits the

organization expertise, they respond to the journalists directly,

immediately.

Contribution: (PLSQL Developer)

. Involved in (Database related) Development.

. Involved in creation of most of the complex stored procedures related to

batch jobs in the project and in testing.

. Creating and executing unit test cases.

Technology Used: Oracle 11G, PLSQL Developer, UNIX, TOAD, HTML, JavaScript,

PL/SQL Web Tool Kit

OMAR, Maritz, St. Louis

Feb 2005 to March 2007

OMAR, Oracle Maintenance Access Request deals with the Customers and

Suppliers of Maritz. It keeps track of a new customer, customer's sites,

modification of details of the existing customers and modification of sites

of existing customers. Similarly the Suppliers of Maritz, Supplier's

Modification, Supplier Sites, modification of the existing Supplier's

Sites. OMAR is an interface between the user and Oracle Apps modules like

Accounts Payable and Accounts Receivables. Instead of directly loading the

data into Oracle Apps database, the entered data is first taken by OMAR and

then sent to Oracle Apps. It tracks the request through the approval

hierarchy and the users will be intimated through an e-mail. When the

request is approved completely, the data from OMAR is loaded into Oracle

Apps.

Contribution: (PL SQL Developer)

. Analyzing and developing new requirements using SQL, PL/SQL, and

PL/SQL Web Tool Kit.

. Using SQL*Loader for importing the data into intermediate tables.

. Bug-Fix, Enhancement.

. Participated in internal audits.

Technology Used: Oracle 11G, PLSQL Developer, TOAD, HTML, JavaScript,

PL/SQL Web Tool Kit.

Contact this candidate