SUMMARY

• Around 10+ years Professional Experience as QA Analyst in Airlines and Retail/ Ecommerce domain.
• Strong experience in Quality Assurance and Software Testing.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Extensive knowledge of SDLC methodologies.
• Extensive experience performing Manual Testing.
• Experienced in testing Client/Server and Web - Based Applications.
• Experience in Black Box, Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
• Extensive experience in Manual and Automated testing using Mercury Interactive Tools like QTP and Quality Center and Rational Tool Suite like Rational Clear Quest, Rational Manual Tester, etc.
• Performed Sanity testing, Smoke testing, Usability testing and Security testing of various applications.
• Experienced in Regression and Functional Testing.
• Proficiency in interacting with Oracle, SQL Server and DB2 databases using SQL.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Experience in writing queries/scripts for Data analysis and QA report testing.
• Used Clear Quest/Quality Center for Bugs reporting and communicating to developers, product support and test team members.
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Able to work individually as well as a team to meet the deadlines.
• Possess Analytical and Problem-Solving skills.
• Excellent in verbal and oral communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Testing Tools: QTP, Rational (Manual Tester, Functional tester)

Bug Reporting Tools: Rational Clear Quest, Quality Center

RDBMS: MS SQL Server, Oracle, MS Access, DB2

Languages: MATLAB, C, C++

Operating Systems: INUX, UNIX, Windows 2000/XP/NT/ 7

Other Tools: MS (word, Excel, Power point, Visio)

Web Browser: Internet Explorer, Netscape Navigator, Mozilla Firefox, etc.

PROFESSIONAL EXPERIENCE

Confidential

Sr QA Tester

Responsibilities:

• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Expert in writing test scripts manually based on BRDs, FRDs and SRSs.
• Created and managed system testing schedule
• Provided test team status reports on weekly basis to the project manager.
• Tested manually as per the specification documents.
• Performed Functionality testing during the various phases of the application and analyzed the results manually using Rational Manual Tester.
• Automated web based GUI test cases
• Conducted GUI, Backend, Data Driven and Security Testing.
• Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP
• Tested processesand methodologies used to deliver Customer order application(Web Application) for quality standards interface to meet customer expectation.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created and maintained back-end testing on the oracle database.
• Executed test cases and reported defects in Clear Quest.
• Conducted regression testing on new builds/versions.
• Developed and executed test cases test Scenarios and followed-up defects using Clear Quest.
• Tracked defects using Clear Quest.
• Performed Defect Management activities to prioritize and resolve any issue/bug found during various software testing cycles such as SIT, UAT, Smoke Tests etc..
• Generated various reports such as Test Execution Status/Progress, Defect Status for project stakeholders and submitted them on daily and weekly basis.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Conducted Defect Status meeting to discuss resolution of issues.

Environment: Windows, Rational Clear Quest, SQL, Oracle, Rational Manual Tester, PL/SQL, XML, J2EE, MS Office (Excel, Office, Outlook, Visio)

Confidential, Framingham, MA

Sr. QA /Database Tester

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan.
• Help review and contribute to product documentation
• Work closely with development team to resolve various issues.
• Responsible for GUI and functional testing, using black box testing
• Preparation of GUI Test Cases, Functional Test Cases and testing with timely delivery against aggressive deadlines and QA process.
• Manually tested the web application to ensure the flow of the application functionality
• Developed and maintainedTest & Traceability Matrices
• Generated GUI maps files using WinRunner and involved in performing Data Driven testing.
• Performed Manual Testing.
• Performed validation of the values that are entered on the front side is passing to the back end.
• Black Box, Negative, Regression, and Integration & Security Tests.
• Developed Reusable Components, keywords and Methods and enhanced numerous test scripts to handle changes in the objects of the GUI and in the testing environment using QTP
• Backend Testing using SQL and Unix Shell Scripts
• Assisted in developing test plans for testing the functionality, GUI, and security.
• Participated in weekly meeting with the management team and walkthroughs
• Tested applications and documented results and bugs including documentation of information useful in the debugging process
• Performed Sanity and Smoke Testing manually
• Maintained the Test Matrix and Traceability Matrix.
• Performed Data Driven testing.
• Tested user interface and navigation controls of the application.
• Clear Quest was used to create the test plan, store test cases and run the test sets.
• Interacted with developers to report and track bugs using Clear Quest.
• Detected and reproduced the defects, and logged defects using Rational Clear Quest web version.
• Generated the test execution report in Clear Quest to be reviewed by the QA Manager and development team
• Participated in release meetings.

Environment: Oracle on UNIX, Windows, Rational Clear quest, Clear quest Web, .Net, PL/SQL, MS Office (Excel, Office, Outlook, Visio)

Confidential, Newark, NJ

Quality Analyst

Responsibilities:

• Analyzed business process workflows and critical business functions through walkthroughs and requirement documents.
• Involved in manual and automated testing of the applications usingQTP.
• Involved in Backend Database validation for Oracle using SQL.
• Executed testing methodologies which will include both GUI testing and database Validation testing.
• Wrote Test Plan and Test Cases according to business requirement.
• Creating and updating test cases based on new and/or /updated functional or interface requirements
• Extract data from an MS SQL Server and create MS Excel and reports for business specific data validation.
• Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Test Director.
• Wrote various SQL queries to validate data inserted, deleted and updated in the Oracle database
• Performed Functionality testing, System testing and Regression Testing
• Performed Development Integration, Functional, Regression and End to End User Acceptance testing for the data services.
• Performed various types of testing such as sanity/smoke test, features testing, functionality, interface, regression, integration, GUI, performance, data validation, back end(TOAD), Reports testing (Business Objects)
• Wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration from back-end to front end.
• Develop, review and execute End-to-End Test Plans, Scenarios and Test cases according to product specification and track the test coverage through requirements traceability matrixes
• Performed requirement traceability by setting automatic alerts for tracing changes in the requirements and system maintenance
• Imported test cases from MS Excel, MS Word to Quality Center.
• Participated in weekly meeting with the management team and walkthroughs
• Performed functional testing of the application throughQTP
• Tested applications and documented results and bugs including documentation of information useful in the debugging process
• Conducted Functional, Integration, System and Black Box Testing of the application.
• Performed backend testing to validate the data using SQL queries
• Generated the test execution report in Quality Center to be reviewed by the QA Manager and development team.
• Performed the Backend integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Database.
• Interacted with developers to report and track bugs using JIRA.
• Attended weekly defect report meetings and presented progress update status.
• Participated in walkthroughs and meetings with business analyst, developers, team lead and QA manager on regular basis.
• Provided modification and enhancement request as needed to correct the defect and make the software more useable.

Environment: s: Java, Web logic, J2EE, Winrunner, Loadrunner, MS SQL Server, QTP, Quality Center, JIRA, Business Objects, SQL, MS SQL Server Management Studio, Etc.

Confidential

QA Analyst

Responsibilities:

• Analyzed system requirements and developed detailed test plan and test cases for testing.
• Performed Manual testing prior to Automated Testing of the application
• Performed functionality, Data integrity and Data validation testing manually.
• Performed system testing and logged results.
• Performed manual testing for usability testing.
• Tested the properties of the tables using table checkpoints using Quick Test Pro.
• Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
• Supports direct connect h remote multiple site capability using DOORS software.
• Conducted Parameterization to data tables using Quick Test Pro.
• Created Multiple Actions using Quick Test Pro.
• Involved in analyzing Business requirements, studying the application and collecting information from developers.
• Tested user interface and navigation controls of the application manually.
• Performed Sanity and Smoke Testing.
• Detected and reported defects using Mercury Quality Center.
• Performed customization in Mercury Quality Center.
• Participated in Walkthroughs and Inspections.
• Investigated Bugs and reported using Mercury Quality Center.
• Performed Regression testing to ensure that bugs fixed did not generate new bugs.
• Interface with developers to solve software problems.

Environment: Oracle on UNIX, Windows, Quality Center, QTP, DOORS, MS Office (Excel, Office, Outlook, Visio)

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Participated in setting up testing environment.
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Reviewed and updated Test Plan and Test Scenarios.
• Manually test each and every module of the application and verify against expected results.
• Performed Sanity and Smoke Testing of the application manually after each build.
• Performed Functional, Security, Positive and Negative Testing.
• Performed rigorous manual testing before a release.
• Manually performed Back-End Testing of the application for SQL-Server 2000 and Oracle databases.
• Performed Back End Testing by extensively using SQL queries to verify the integrity of the database.
• Modified previously existing Test Cases that were driven by the manual testing effort so that they are more appropriate for future automation testing.
• Conducted result analysis and interacted with developers to resolve bugs.
• Report the bugs by using Microsoft Excel Sheet.
• Participated in the project meetings.
• Attended to daily reviews, walkthroughs and meetings for Verification and Validation of the project.
• Met with the developers and technical content writers on a daily basis to update the test documents.
• Followed up with developers on defects status on a daily basis.

Environment: Windows, DB2, UNIX, SQL, Manual Testing, Reporting, MS Office (Excel, Office, Outlook, Visio)

Confidential, Houston, TX

QA Analyst

Responsibilities:

• Performed backend testing using SQL queries to check backend data and data integrity.
• Assigned the projects to the QA team and provided the LOE's for the projects to the PM's.
• Worked closely with build team to get the code deployed in the test environments.
• Attended the requirement meetings, test case review meetings, status calls and worked closely with the manager to provide the necessary QA team updates
• Resolved the environment issues when QA environments are changed and verified if all the code got deployed in the testing environments.
• Worked on multiple projects and supported the end users during the UAT testing.
• Analyzed the issues by looking at the UNIX log files, able to read.
• Worked on executing the SQL queries to verify the data in the database
• Worked on Agile Methodology.
• Attended the high level business meetings and analyzed the functionality impacts to other related projects.
• Attended the daily status call to update the QA status.
• Performed Regression Testing.
• Prepared the Test Metrics (End of Test Report)
• Helped to troubleshoot complex development and production application problems and supported technical and production support on an on-call
• Worked with build team to deploy the builds, able to debug and analyze build or code issues and Worked with associated team to fix the issues.
• Worked on Functional testing/Smoke Testing/System Integration Testing.
• Worked on documentation and reporting of bugs found in testing process.
• Logged the issues in internal bug tracking tool JIRA and QC as well.
• Worked on testing multiple mobile application projects.
• Worked with users during the UAT testing and provided the QA sign off for the projects.

Environment: Windows, UAT, JIRA, UNIX, SQL, Manual Testing, Reporting, MS Office (Excel, Office, Outlook, Visio)

Confidential, Austin, TX

QA Analyst

Responsibilities:

• Followed up with developers on defects status on a daily basis.
• Requirement analysis and impact analysis for the proposed change to system.
• Understand the High Level and Low level design and propose improvements.
• Develop Test plan and perform effort estimates and resource needs to execute the project.
• Static testing through Reviews and inspection.
• Test Design and test Execution by setting up the required environment which includes setting up of JCL's, monitoring the job flows in Control M, solving JCL abends.
• Test validation by validating various db2 tables using SQL queries, validating mainframe files, validating the bills.
• Defect Tracking & Status reporting.
• Identifying pain areas and proposing process improvements/value additions.
• Test Metrics Collection, Analysis and sharing it with stakeholders during Governance meetings.
• Worked in CDE - Conversion Discount Engine that calculates the discounts for the customers based on various plans
• Performed entire validation of invoice.

Environment: HP Quality Center, CaliberRM, Informatica, Control-M Desktop, Enterprise manager, Metavante PDF comparison Tool, COBOL, JCL, REXX, ISPF, NDM, INSYDB2 and TOAD