Quality Assurance Test

Rinky Basantani

*****.*********@*****.***

Cell: 408-***-****

OBJECTIVE: To obtain a position as a Software Quality Assurance Analyst.

PROFESSIONAL SUMMARY:

. 5+ years of experience in Software Testing and Quality Assurance (QA).

. Proven skills in all phases within the Software Development Life Cycle

(SDLC) and very strong in the implementation and maintenance of Quality

Engineering Processes.

. Extensive experience in understanding the Quality Assurance Life Cycle

(QALC), QA Methodology, and QA Strategies.

. Proficient with manual testing, functional testing, regression testing

and GUI testing. Have been involved with User Acceptance testing (UAT),

ETL testing and Load Testing.

. Expertise in creation, execution and maintenance of Test Plans, Test

Specifications, Test scenarios, Test Scripts and Test Cases.

. Strong experience working with HP (Mercury) testing tools like Quality

Center, Quick Test Professional (QTP) and LoadRunner.

. Experience in development and implementation of the automation

infrastructure of client server and web based applications.

. Created and implemented VBscripts to automate tests using QTP. Used

descriptive programming to avoid maintaining object repositories and to

implement tests on complex applications.

. Supported ETL processes using the Informatica Tool.

. Involved in creating and maintaining bug reports and requirements

traceability matrix (RTM) documentation.

. Hands on experience in designing frameworks (keyword driven framework,

data driven framework and hybrid framework) necessary for automation of

the application using QTP.

. Experience working with SQL programming to generate views, create outer

joins and complex SQL queries for the test environment.

. Worked on writing, editing and testing shell scripts on UNIX servers.

. Experience with scheduling UNIX scripts for loading and executing timely

data and tests.

. Strong Knowledge of SDLC like waterfall, iterative, spiral and agile

technologies like scrum and XP (Extreme Programming).

. Excellent at communication, Self-Starter and comfortable in high

intensity and challenging work environment.

. Quick learner and excellent team player, ability to meet deadlines and

work under pressure.

TECHNICAL SKILLS:

Testing Automation tools Mercury Interactive/HP Quick Test Pro 9.0, 9.2,

9.5, 10.0 LoadRunner 9.1, Win Runner 8.0, 9.2

Defect Tracking tools Test Director 8.5, Quality center 9.2, Spira test,

ClearQuest, Bugzila

Operating Systems Win 95/98/NT/2000, XP, UNIX

Scripting Languages VB Script, Unix Shell Scripting, PERL Scripting,

TSL

Programming Languages C, C++, VB, SQL, Java, HTML, XML

Networking Knowledge of TCP/IP stack, OSI stack, LAN

technologies

Databases Oracle 9.2.0.4, 10g, 11i, DB2, MS-SQL, MS Access

App/Web Servers Apache, IIS, Web Sphere and Web logic

ETL Tools Informatica 7.x, 8.1.1, 8.6

Web Browsers Internet Explorer, Netscape Navigator, Mozilla

Firefox, Opera, Safari

Networking Protocols TCP/IP,HTTP,FTP and SMTP

EDUCATION:

Bachelor of Engineering in Information Technology, University of Mumbai,

India

WORK EXPERIENCE:

Ciber Inc, Sacramento, CA Apr 2009

- Present

Software Quality Analyst

CRIMES is a comprehensive attorney automation system, designed by and for

attorneys. CRIMES helps manage all aspects of a case and features

intelligent, automated generation of case documents and reports. CRIMES is

a web based application that not only provides the functionality required

by attorneys but also allows them to generate the legal documents that are

required in their day to day life. The main aim of the project is to

deliver the product of CRIMES to the State of Mississippi that includes all

22 District Attorney (DA) offices and Attorney General Office (AGO).

Separate modules were developed for both AGO and DA. The AGO module

includes Opinions, Civil, Criminal, Consumer and Medicaid divisions.

Responsibilities:

. Analyzing user requirements, specifications and business rules and use

cases to prepare test cases and test plan.

. Come up with several test scenarios to develop test cases.

. Extensively performed manual testing, requirements verification

testing, functional and user acceptance testing (UAT), Risk Based

testing.

. Involved in Cross browser testing - Firefox 3.0, Opera 9.2.

. Involved in backend, integration and regression testing phases of the

application.

. Performed web test using Quick Test Pro for checking page contents,

broken links, web objects, frames and tables. Parameterize the scripts

to run the scripts using varying form data.

. Developed descriptive programming and maintained Local and Global

Object Repository in QTP.

. Developed Custom Functions, Dictionary Objects, Custom Recovery

Scenarios, Driver Script, Startup Script and Utility Functions in QTP.

. Enhanced the scope, flexibility and adaptability of the Tests by using

checkpoints, synchronization points, regular expressions,

parameterization etc.

. Tracking the bugs using QualityCenter.

. Testing the complete flow of the application.

. Testing the browser compatibility of the application.

. Involved in weekly bug status meetings along with QA team and

development team.

. Maintained shared object and per action repository and changes were

made to it for every version.

. Involved in executing SQL Queries for backend testing.

Environment: C#, ASP.NET, .NET Framework, SQL Server 2008, Crystal Reports,

HTML, MS Word, Test Director/Quality Center 9.2, QTP 9.2, VB Script

Adventist Healthcare, Rockville, MD

Jan 2008 - Mar 2009

QA Analyst

TRex System is a system being developed for Adventist. This system allows

the Adventist pharmacy stores to process the prescription drugs, get the

insurance details, the payment methods, drug specifications, prescriber

(doctors) details. Once the prescription is entered into the system it

gives all the details of the drugs, their formulations, manufacturer

details, pricing, substitute medicines, branded drugs. This application is

being developed using Java Technologies.

Responsibilities:

. Involved in improving testing process, defining new automation

methodologies.

. Executed Manual test cases and scripts based on the business

requirements and for each build.

. Analyzed the complexity of the Patient, Prescriber and Rx prescriptions

under different scenarios and HIPPA regulations and automated the

application by using QTP.

. Wrote and executed test plan, test cases and test scripts, detected the

errors and retested the code.

. Conducted functional testing of entire functionality of the application

on different browsers and operating systems based upon system specs.

. Involved in multiple releases in which each release focused on new and

critical features followed Iterative development (Agile) methodology.

. Conducted database testing to check data integrity.

. Design and wrote custom functions using QTP for regression testing

during each integration phase.

. Articulated a long term test automation strategy and incrementally

delivered automated test suites and programs to support that vision in

QTP.

. Designed created and customized the most consistent and comprehensive

recovery system for the application to handle any situation during

testing.

. Performed Integration Testing for different modules in the application.

. Developed and executed Error Handling and Exception cases to run the

automated scripts uninterrupted.

. Performed Data Driven test using test data from excel files.

. Linked all the test cases to the requirements and traced all the

requirements that have been tested after each test cycle using Quality

Center.

. Used Quality Center to manage and organize activities like requirements

coverage, test case management, and test execution reporting and defect

management.

. Used VSS for version control.

. Participated in Walk-through, Peer Reviews and Defect Report meetings

weekly and periodically.

. Captured the entire business process of applications into LoadRunner

Scripts and executed test scripts for performance.

. Developed scripts to load against Web Application using Load Runner.

. Used Virtual User Generator to generate VuGen Scripts for web.

Environment: Windows XP Pro, Microsoft Office, SQL Server, Office

Communicator, Lotus Notes, Java, LoadRunner, QTP 9.2 and Quality Center 9.2

/ 10.0, MS Access

ABN AMRO - Chicago, IL Sep

2006 - Dec 2007

Project: BASEL II

QA Engineer

ABN AMRO Bank (AAB) has implemented Basel II, a mandatory international

initiative to enhance capital adequacy in the banking industry. An

essential component for Basel II Credit Risk is the Risk-Weighted Assets

(RWA) calculator. AAB chose the Fermat product to fulfill this calculator

requirement, adopting a de-centralized implementation approach for each

Strategic Business Unit (SBU).

Responsibilities:

. Overall responsible for Evaluation, Analysis, Design, Development and

Delivery of ETL Interfaces for the BUEU BASEL II project using

Informatica.

. Involved in installation and configuration of Informatica server and

migrating repositories.

. Responsible for writing test cases for each ETL mapping and uploading

the test cases using the Mercury testing tool.

. Performed Unit testing, Integration and Regression testing of

developed solution.

. Actively participated in the UAT (User Acceptance Testing) meetings

with the business/end users.

. Developed Test plan, test scripts, test scenarios and test cases for

business requirements using functional and business requirement

specification documents.

. Documented the validation rules, error handling and test strategy of

the mapping.

. Responsible for troubleshooting & production support.

. Used Debugger wizard to remove bottlenecks at source level,

transformation level, and target level for the optimum usage of

sources, transformations and target loads.

. Performed ETL Administration responsibilities for production and non

production environments.

. Test plan preparation included test estimation and setting up test

strategy.

. Configured test environment for specific test cases, created test data.

. Prepared test data by creating corps/users and assigned resource rules

to them based on the specifications and test cases.

. Manually performed complete test execution including verifying and

validating the Interface data, Functional, Regression, UAT and End to

End Testing.

. Collaborated with developers as needed to isolate root cause of

defects.

. Used Test Director for scheduling, interacting and invoking the

WinRunner scripts.

. Developed TSL for Automation using WinRunner for GUI, Functionality and

System Testing.

. Supported definition and development of automated test programs and

tools using WinRunner.

. Maintained Master GUI Map in the central repository and made changes to

it for every version.

. Performed Positive/Negative testing and created, executed test

scenarios for these testing.

. Wrote complex SQL statements to retrieve data from multiple tables to

validate the database source views.

. Participated and reported statuses in all test-related project team

meetings.

. Prepared metrics and test reporting to Senior Management and users.

. Change / Incident management using Rational ClearQuest.

Environment: WinRunner 7.6, TestDirector 8.0, Rational ClearQuest,

Informatica 8.x, IBM DB2, Microsoft Office and Windows XP.

Warner Bros (For Tata Consultancy Services) Mumbai, India

June 2005 - Aug 2006

Project: Sales Intelligence Data Mart

Informatica Developer

Warner Bros. Entertainment Inc. leads its industry worldwide in creating,

producing, distributing, licensing and marketing feature films, television

shows, home video, animation and other forms of entertainment.

WBEI had requested TCS to assist in building the Sales Data Mart for its

theatrical division. The key business objective for building this platform

is to facilitate business decisions through a single-source of analytical

data and information for business users of theatrical sales.

Responsibilities:

. Configure test environment for specific test cases, create test data,

and execute automated or manual tests, document results, and update

defect tracking systems.

. Translate functional requirements into technical specifications for

design of Data Marts/Data warehouses and Informatica Power Center

mappings.

. Involved in installation and configuration of Informatica server and

migrating repositories.

. Responsible for writing test cases for each ETL mapping and uploading

the test cases using the Mercury testing tool.

. Performed Unit testing, Integration and Regression testing of developed

solution.

. Actively participated in the UAT (User Acceptance Testing) meetings

with the business/end users.

. Performance tuned the Informatica session for large data files by using

pipeline partitioning, increasing data cache size and target based

commit interval.

. Documented the validation rules, error handling and test strategy of

the mapping.

. Responsible for troubleshooting & production support.

. Used Debugger wizard to remove bottlenecks at source level,

transformation level, and target level for the optimum usage of

sources, transformations and target loads.

. Developed SQL queries and executed them through different

transformations.

. Played major role in the Offshore / Onsite Model implementation.

. Held status meetings and conference calls with respect to requirements

gathering & technical discussions.

. Translated functional requirements into technical specifications for

design of Data Marts/Data Warehouses and Informatica Power Center

mappings.

. Carried out code walk through with developers & client teams.

. Evangelized ETL best practices within the team.

CERTIFICATIONS:

. Microsoft SQL Server - Brain Bench certification

- TCS Internal Level 2

certification

. Informatica ETL Tool - Brain Bench certification

- TCS Internal Level 1

certification

Contact this candidate