Maual testing,sql,unix,shell script,QC

Madhavi Bangalore acqc9k@r.postjobfree.com

Objective

Seeking long term employment in an organization where I can grow professionally and further

enhance my skills, knowledge and experience to face and overcome the challenges of today’s

changing work environment

SUMMARY:

4 Years of Experience in Software Quality Assurance with emphasis on Manual and

Automation testing of Client Server & Web based applications.

Experience working with Software Development Life Cycle (SDLC) and Software

Testing Life Cycle (STLC) which includes Requirement gathering, Analysis, Design,

Development, Implementation, Testing, Deployment and Production.

Experience in developing and executing test plans, test design, test cases, test

scenarios, traceability matrix, test scripts and defect reporting based on requirements

and functional documents.

Proficient in analyzing Business, Functional and Software Requirement Documents and

Use Cases.

Extensive work experience in different types of testing like Black box, Smoke,

Functional, Regression, Integration, System, Database, Ad hoc and User

Acceptance Testing (UAT).

Expertise on working with testing tools like Quality Center, QTP, Test Director, JIRA

and Bugzilla.

Experience in testing and maintenance of enterprise applications developed in Java,

J2EE and web technologies.

Database exposure using MS SQL Server with strong backend testing experience and

data validations writing complex SQL Queries.

Experience in developing and analyzing automation test scripts.

Experience in using JIRA for defect tracking and logging.

Strong experience working on Windows and UNIX environments.

Strong communication, documentation, analytical and interpersonal skills with

leadership quality and problem solving skills.

Experience in working with various domains like Financial and Pharma.

Knowledge on Agile – scrum methodologies

SKILL SET:

Operating Systems Windows 2008 Server, UNIX, Linux

Testing Tools Quality Center, QTP, JIRA, Bugzilla

Databases MS SQL Server 2008/2005/2003, Oracle 10g/9i, MS Access

Scripting Languages VBScript, Shell Script.

Packages MS Office

FUNCTIONAL TECHNOLOGY

Testing Tools – Quality

Black Box Testing, Accessibility testing.

Center,QTP,JIRA,Bugzilla

Languages – VB Script,Shell Script

Functional Testing, Integration Testing,

Databases – MS SQL Server

GUI Testing, Regression Testing,

Database Testing, Browser Compatibility 2008/2005/2003,Oracle 10g/9i

Testing and Usability testing. Operating systems -Windows (XP,

Preparation of Test Plan, Test Vista, Win7), Mac, Ubuntu

Estimations, Test scenarios, Test Case Applications: MS-Office Suite (Excel,

and Test Metrics. Word, Power Point).

Design, implementation and maintenance Web: HTML, VBScript

of Manual test frameworks from the

scratch.

S/W development life cycle

methodologies.

Implementing projects, end to end testing

User acceptance testing.

Running Automation On daily basis &

reporting the issues.

Experience:

1. Client: HDFC Bank

Duration: May2013-Apr2014

Job Title: QA Tester

Technology: SQL Server 2005, ASP, C#, .NET, Unix, Windows server 2003, Quick Test

Professional 10, Quality Center 10

This application was developed for online transactions like accessing personal accounts,

checking balances, payment of recurring bills such as mortgages and loan payments,

transfer of funds between accounts of its customers and also between this bank and

other institutions, loan rates, and other products and services.

Responsibilities:

Involved in Manual testing using Quality Center to develop test cases, test

scripts, executing the scripts and logging the defects.

Wrote and executed test cases and bug reports for failed test cases. Performed

Black Box,Integration and Regression testing.

Tracked application errors through a bug tracking system. Coordinated with

developers for bug fixes.

After creating, canceling, and modifying accounts, checked the database using

SQL to verify that the database reflected the appropriate changes.

Responsible for documenting errors, their resolution, as well as performing

extensive regression testing.

Involved in regression testing for the application using QTP.

Involved in Functional, Regression, Performance and User Acceptance Testing

(UAT) and Access Online applications.

Performed Manual Testing on different modules of the application.

Job involved interaction with developers, users and business analysts

2. Client: Reliance Communications

Duration: Oct2012 –Apr2013

Job Title: QA Tester

Technologies Used: Quality Center, Windows NT 4.0, MFC, Oracle, MS SQL Server

2005, T-SQL, DTS, Crystal Reports, CRM, VB, Windows 2005 Server, Rational Tools,

MS Office, MS Visio, MS Project.

Reliance is one of the top Indian CDMA based Telecom Company. It has the largest

mobile users base of more than 10 million. The project I was working on was to test the

development of an application that would provide the customers to see their account

usage through web. Also as part of its wireless coverage expansion, I was part of the QA

team supposed to test the developed application to manage the database of growing

number of users.

Responsibilities:

Analyzed business requirements document and system requirements to g ain a

better understanding of the application.

Prepared test cases for functionality, positive and negative testing.

Manually executed the test cases using Quality Center

Involved in Development and execution of SQL Queries to perform backend testing.

Written automated test scripts for Functional, GUI validation, Data driven testing

using Quick Test Professional.

Identified defects and reported them using Quality Center

Documented Test Metrics, Test Logs and various reports on the weekly basis for

senior management.

Involved in meetings to identify the new structure and modify existing structure as

and when necessary.

Interacted with Development and QA Teams to ensure the overall quality of the

software.

3. Client: Novartis Pharmaceuticals

Duration: Sep2011-Apr2012

Job Title: Software Tester

Technology: Windows-XP, Quality Center 9, QTP 9.2, Load runner, Performance

Center9.0, Oracle, .Net, Asp.net, HTML, XML, Java Script,J2EE, SQL Server 2005, MS-

Office

Novartis is a Worldwide Pharmaceutical company manufacturing different types of

Products. The Project Involved in Identifying user Requirements and Analyzing the

Existing Data Source and IMS data to Build Product Platforms into Standardized Data

warehouse/Datamart

Responsibilities:

Worked with development team and test automation team to define and implement

an automated test environment suite.

Participated in defining functional and performance test objectives & test plans and

identified the bottle- neck points of the system performance.

Developed the Test plans, Test cases using Quality Center and used them for

defect tracking and update the project plan information.

Migrated the test execution results from Automation tools to Quality Center and

keep updates on day to day work of completion for easy tracing of test cases

covered.

Collected & analyzed data, prepared test reports. Analyzed & solved difficult

systems bugs.

Documented system development, designed Test cases, performance scenarios,

coding standards, review & testing guidelines.

Developed the automation script using QTP for Functional testing.

Designed the own work spaces using the different services based on the

scenarios.

Conducted the test executions on legacy data to estimate the performance

improvement during data migration.

Validated the data using SQL queries during data migration.

Performed evaluation of hardware and software strategies for Product

Management.

Participated in code review and peer review meetings frequently during Load,

stress and performance tests.

Highly involved in debugging issues whenever application code changes during

different releases and maintained the debug reports for future use.

4. Client: Aurora Bank

Duration: Aug2010-Jul2011

Job Title: QA Tester

Environment: Java,J2EE,SQlserver 2005,UNIX,XML,Quality Center.

Aurorabankfsb.com is online web based application. It consists of various products and

services. The personal service consists of Checking Accounts and Savings Accounts,

Certificate of deposits and Money Markets, balance transfers, bill payments, deposit and

withdrawals. Different types of banking services are provided online.

Responsibilities

Involved in Testing the Application Manually using the Test Cases.

Responsible for Creation and Execution of Test cases using Quality Center for

each release

Responsible for creating, tracking and testing the bug fixes.

Worked closely with Developers, Business Analysts and participated in the

requirements, design documents, bug reports reviews.

Involved in supporting Users in User Acceptance Testing (UAT)

Responsible for validating data in the Backend using SQL Queries.

Created Requirement Traceability Matrix to ensure coverage of Requirements in

terms of testing.

Generated test data and tested database to meet the functionalities deliverables

in the project documentation and specifications

Responsible for sending the testing status to the project lead.

5. Client: Pfizer

Duration: Dec2009-Jul2010

Job Title: Software Tester

Environment: QTP, Test Director, Load Runner,Oracle, SQL Server, Windows XP

Pfizer Global Pharmaceuticals (PGP) planned to migrate from its current infrastructure to

smart, optimized, next generation infrastructure. The main objective of the program was

to reduce the server count and to test the applications to ensure that the migration from

old infrastructure to new infrastructure didn’t impact the existing behavior of the

applications. It involved manual testing, functional testing and performance testing on

Client’s environment.

Responsibilities:

Analyzed user requirements and documents for Migration, Transition, Forklift and

vendor supported applications to be tested.

Performed functional, regression, integration, system, database and performance

testing.

Developed, uploaded and executed manual test cases in Test Director.

Logged and closed defects using Test Director found durig test execution.

Involved in tracking and reporting of the bugs using Test Director.

Reviewed and re-executed updated test cases received from the application

support team.

Used Quick Test Professional for performing functional and regression testing.

Worked with SQL queries for data verifications in Oracle database.

Created and reviewed functional test summary report, performance test summary

report and updated Production acceptance review report (PARR).

Used MS Excel for reporting test status.

Educational Qualifications:

Bachelors Degree in Computer Sciences

Contact this candidate