Sushma K. Qaanalyst***@gmail.c

om

U.S. Work Authorization: Yes 732-***-**** (Cell)

973-***-**** (Home)

SR. QA SOFTWARE TESTER

• Solutions-focused QA tester with six years of experience; high-level proficiency with

Quality Center tool; and a foundation in SQL, Shell Script, Linux/Unix.

• Excelled in creating test plans and wri ting/running test scripts to pinpoint software

defects, t rack bugs, close open defects and validate functionality. Serve as a value-

adding member of QA teams with experience in both waterfall/Agile processes.

QA EXPER IENCED SUM MARY

Testing Methodology Use of UN IX Utili ties GUI/Back End Testing

Test Plan/Test Cases IT Business Knowledge SQL/Data Validation

Agile Methodology Defect Analysis/Tracking QA Gap Analysis

Real-Time/Batch Testing Process Management System SIT/System/UAT

Testing Strategy Change Control System Multi-

Agile Methodology Release Managements Tasking/Interactive

Automation –Shell

Script

TECHNOLOGY & TEST ING PROF IC IENC I ES

• Platforms: UN IX, Linux, Windows (NT, 2000, XP, 2003, Vista), Macintosh, MS-DOS.

• Programming languages: Perl, SQL, JavaScript, Java, UN IX/Linux shell, VBScript,

P L/SQL, HTM L, XML.

• Database systems: O racle, M icrosoft SQL Server

• Web Server : I BM Web sphere, Data power(IBM), Web logic

• Defect-t racking software : Mercury Quality Center, JIRA

• Source-control software: CVS, Visual SourceSafe, Accurev.

• Tools and Utilities: M S Office, HTM L, Confluence, Microsoft Exchange, Accurev,

Toad, SOAPUI

QA TEST ING EXPER IENCE

Citizens Bank, R I 2011 – Cu r rent

Senior QA Software Tester

Page 1 of 7

P roject Description: Citizens Financial Group, Inc. is a Bri tish-owned American bank

headquartered in Providence, Rhode Island. RBS Citizens Financial Group, Inc. is a $120

b illion commercial bank holding company.

I nvolved in Testing of Bill to Pay application for valid Citizens Bank‘s Business and

consumer customer to generate new vendor to pay bill, configure frequency and alert of

payment with confirmation, payment schedule and Report Capability of all payment

h istory. Used SQL script in Oracle to validate data and debug process using Unix command.

Responsibilities:

• Responsible for analyzing system requirements and developing a test plan for the

p roject based on SDLC by performing G ap Analysis and major and minor functionality.

• Wrote and executed T est Cases and Test Scripts a fter reviewing the business

requirement document and technical specifications.

• Solid experience in performing Black box testing, In tegration testing, System testing,

data validation testing, e nd-to-end testing of the application and involved in white box

testing .

• Supported kick off meeting to comprehend the basic expectation of upcoming release,

i dentified data set up, r oles and responsibilities and L OE of projects.

• Interacted with Business Analysts, Developers and QA team to understand Business,

design of code, r elease notes and system demo.

• Created a Test Standards Document and maintained. Presentation of the QA Status

report and the D efect Status reports i n the weekly meeting

• Performed queries to the database using SQL to check successful Transaction & to

validate particular test cases. Developed complicated SQL queries using Toad for both

f ront end and back end validation.

• Involved in system integration testing, where all the components of the system were

tested from end-to-end.

• Used SOAPU I t ools to validate web service functionalities of application for different

API calls.

• Review QA Test Plan (System, SIT) with cross functional team, updated test plan,

baseline test plan and updated in each release and make baseline.

• Identified R egression and acceptance test cases and edited details in test case using

test script (SQL or shell script).

• Performed r egression and r etesting i n each fix of defects to move all test cases fur ther

execution.

• Executed Test cases for Sanity Testing, a nalyzed problem, if sanity testing failed,

P lanned Test cases based on Test Plan and identified discrepancies.

• Used U nix Utilities t o validate test cases and identified code problem using log file to

narrow down search.

Sushma K. Qaanalyst900@gmail.c

om

U.S. Work Authorization: Yes 732-***-**** (Cell)

973-***-**** (Home)

• Created defect report, test result status and discussed with upper management in staff

meeting to resolved b locking defects.

• Key learning support in major release, discussed key issues to improve process.

Environment: H P U N I X, JAVA, P L/SQL, Websphere, Quality Center, X ML, Java Script, Shell

Script,etc

Blue Cross Blue Shield of North Carolina, NC 2009-

2010

Senior QA Analyst

P roject Description: I nvolved in testing of Claim Level Rejection application, which is

basically reject Invalid Claims Based on IG Edits, Business Edits and SRM Edits.

A pplication has capability t o find doctors in insurance network with multiple search criteria

to supports complicated business criteria like doctor location by name, address, zip code,

speciality,language support and Report capability. E2E System Testing with validation with

SQL Scripts, Debugging application log using UN IX utilit ies and API testing. Participated

i n UAT, Production Launch support in each release.

Responsibilities:

● Interaction with Business Team, Business Requirement G ap Analysis, Customer

E xperience and Impact Analysis of application.

● Contributes to and monitors test planning, t est preparation and scripting, and t est

execution according to defined best practices, standards and procedures.

● Interfaces regularly with peers and management regarding test related topics including the

coordination of test related initiatives with QA Test Leads, Project Managers, Development

M anagers, and other QA Core team members.

● Assess r isk to quality service based upon results of verification and validation. Monitor

adherence to established t est standards and procedures. S tandardized QA Process using

T esting Methodology and involved in Process Improvement.

● Expertise in Back End Testing and use of U N IX Utilities l ike awk, grep, sed, vi, network,

p rocess, file level, directory level, automation with Shell Scripting in data file validation

testing. (Unix Log File Testing, P rocess validation, running process in background, etc).

● Manages verification and validation activities for production modifications in p roduction

e nhancement, interact with user support in production testing.

● Maintain document template libraries and internal project documentation like QA Test

P lan, L ocal procedure, QA Test Results, etc.

Page 3 of 7

● Organize and/or facilitate team member t raining sessions in each new application to

i mplement process.

● Participates in both internal and external process improvement projects like Q A, SIT, UAT

T esting w ith business & Marketing and External Vendors team.

● Strong Project Management skills like Test planning with LOE, t est estimation and

resource plans, Set up test environment

● Expertise with testing tools like Quality Center and third party tool Toad.

● Knowledge of relational databases like Oracle Database 11g to validate data testing in back

end using SQL script using Oracle functions.

● Ability to mult i-task effectively, excellent verbal and writ ten communication skills and

a ttention to fine detail.

Environment: T est Di rector, SharePoint, MS-word, MS-excel, Java, JSP, J2EE, Java Script,

SQL, exchange, Power M HS, AIX(U N IX), X ML, Oracle, SQLDEVELOPER.

Verizon Communications, A rlington, VA

2007-2008

QA Tester

Project Description: Responsible for Testing of Archiving Batch Process, executed by JAVA

based back end process to extract multiple records from Oracle Database to t ranslate data

i nto data file storage to local database. Responsible for testing of process using U N IX

u tilities with SQL script . Developed basic Test script in Shell script to automate process

Responsibilities:

• The project testing strategy creation of a QA environment i ncludes creating execute

t ests scripts, verification of test results, t roubleshoot the bugs and t rack t ill it closes.

• Involved in screen oriented testing with m anual function testing w ith object testing

and maintained business f low.

• Extensively used U N IX t o validate process oriented testing like variable length data file

validation.

• Used Mercury T est Di rector for managing the overall testing effort to define and store

i nformation about test documents, requirements, scripts, schedules, and sessions.

• Developed and reviewed SQL script w ith use of sub query, join, Oracle function, group

by and order by clause to validate all Front end t ransaction (Insert, update, delete) for

data validation.

• Automated basic testing process in back end testing using shell script and understood

developed script by developer.

• Participated in requirement G ap Analysis, t racked d efects, retested defects and

performed regression testing in each release.

Sushma K. Qaanalyst900@gmail.c

om

U.S. Work Authorization: Yes 732-***-**** (Cell)

973-***-**** (Home)

• Used testing methodology to develop test cases using positive, negative, boundary

testing and used sanity, E2E testing a fter each installation code process.

• Interact with cross-functional team to install software, understand application

f unctionalities, resolved daily defects, blocking defects, etc.

• Involved with t raining of newly hired, staff meeting and testing of user guide and

i nteract with user in SIT.

• Participate in w alk-through i nspections, reviews, and user group meeting.

• Participate in C hange Control meetings, provide QA signoffs and implement the

p roduct into production as needed.

• Provide customer support in critical production issue and maintain production software

as needed.

• Monitor and r esolve testing issues w ith internal team and contribute effort to

u nderstood problems.

• Involved in testing of User Guide, installation guide, and release notes for each

deliverable of software.

• Frequent communication and collaboration with stakeholders to be a constant driver for

quality.

Environment: H P U N I X, JAVA, P L/SQL, Websphere, Quality Center, X ML, Java Script, Shell

Script, Toad, X M L SPY etc.

TARGET CORPORAT ION, NJ 2005-2007

QA Analyst

P rovide lifecycle management of testing projects on software and large database application

l ike Managing USA wide Store Location Management System (SLMS). Application is JAVA

based GUI with complicated functionalities to handle Target Role based user access,

Capability, Role Hours Management, Store Capability, Location information. Application

t ransaction is fetched with Real-t ime ht tp XML Request/Response Transaction from web

server to application to Oracle database. Application is tested with SQL validation and

debugging process with U N IX utilities. E2E testing includes System, SIT and UAT testing

i nvolvement with Agile Process.

Performed Parallel Testing for SLMS for migration of application from HP UN IX to SUN

U nix.

R ole & Responsibilities:

Page 5 of 7

• Interact with the project team to gain an understanding of the business environment,

technical

Define, identify, collect, and organize detailed information relating to testing

requirements.

• Analyzed E2E f low of application with cross functional team to identify key

f unctionalities of application.

• Review business requirements, participate and validate requirement and specifications

change of requests

Design testing scenarios and test cases to demonstrate conformance to all functional

and non-functional requirements as defined in business or technical specifications

• Test case reviews and sign-off with development teams to implement QA testing process

and get feedback from cross functional team.

• Data setup for testing and involved in testing strategy of release application includes

environment selection with tools.

• Performed sanity testing w ith acceptance test cases and execute test cases from Quality

Center. Daily testing team meetings with lead to identify gaps, defects and discussion

w ith upcoming changes.

• Write basic SQL queries for database testing mapping of data, verifying incoming and

outgoing data.

• T racking testing coverage, defect identification and reporting, and defect prioritizing

and t racking

• Support business users during the execution of user acceptance testing by providing

data and monitor defects and interact with team to sign process.

• Collaborate with project team members on development and customer issues; i dentify

gaps and retest and regression testing.

• Perform problem analysis and resolution, defect researching, and resolution analysis of

test results to resolve discrepancies escalate issues.

• Adhered to established standards and methodologies. U tilized tools and methodologies

to improve individual effectiveness and to increase efficiencies in the QA process.

• Involved in key learning process a fter each release to implement process in future as a

part of QA process Management.

• Conducted manual testing using the standards, guidelines an structured methodology

i n testing the application with use of SQL scripts and UN IX utilit ies like AWK (AWK

f unction), grep, sed, vi editor, process and network utilit ies.

• Report, provide testing project feedback and archive testing assets in order to verify

completion of testing. Highly motivated, detailed oriented, ability to work independently

as well as a team member with excellent technical, analytical and communication skills.

Education:

Sushma K. Qaanalyst900@gmail.c

om

U.S. Work Authorization: Yes 732-***-**** (Cell)

973-***-**** (Home)

Bachelor’s Degree in Technology.

Page 7 of 7

Contact this candidate