SUMMARY

• Over 7 years of Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Solid analytical and dynamic troubleshooting skills
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client-server and web based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
• Experience in Mainframe Testing
• Proficient in SQL queries.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

Database: Oracle, SQL Server 2005/2008, IBM DB2, Teradata, Sybase

Change Mgt Tools: Test Director 8.0, Quality Center, Rational Clear Quest

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Manual Tester

Responsibilities:

• Wrote PL/SQL stored procedures for certain data validations
• Used Quality Center for test planning and execution and Rational Clear Quest was used for defect tracking.
• Validated the interface from Frontend to backend tables
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Was involved in executing the Regression testing on new Builds
• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Developed test scripts using QTP for Functionality and Regression Testing
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Prepared reusable function in QTP to use across the automation scripts
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
• Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.

Environment: MS Access, QTP, ALM/HP Quality Center 11, Manual Testing, Teradata 13.0, XML, XSD, XML Spy, Rational Clear Quest, MS SQL Server 2008, Oracle 11g (SQL, PL/SQL), TOAD.

Confidential, Wilmington, DE

QA Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Reported the defects in Quality Center and documented the report queries
• Tested several reports and automated using Quick Test Pro.
• Managed test environments and schedules
• Created, updated and ran the QTP scripts.
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Trained the users for the User Acceptance Testing (UAT) and explained about each link, tab and search functionalities to the users.
• Prepared manual test scripts covering different scenarios and documented in Quality center
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Autosys, MS Office Suite, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Manual Testing, UNIX, Oracle 10g, Teradata 12.0, SQL Server 2008, SQL,QTP, PL/SQL, Stored Procedures, Quick Test Pro 8.0, HP Quality Center 10.0

Confidential, Cleveland, OH

QA Tester

Responsibilities:

• Performed Database Testing using SQL queries for testing reports.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center
• Worked with QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Used Quality Center to log defects and monitored the defects for successful resolution
• Provided training and mentoring to offshore QA team.
• Wrote PL/SQL stored procedures for certain data validations
• Worked closely with the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.

Environment: PL/SQL, SQL, Quality Center, UNIX, QTP, Shell Scripting, MVS, JCL, VSAM Files, XML Files, Autosys, Crontab, Oracle 10g, Sybase 12.3, TOAD, WinSQL

Confidential, Irving, TX

QA/SQL Analyst

Responsibilities:

• Used TOAD to write SQL and validate the backend
• Used SQL Teradata Assistant for data retrieval from Teradata
• Identified bugs and interacted with team lead and developers to resolve the bugs
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database
• Maintained the test matrices and reported bugs using Rational Clear Case
• Created Test Strategy and Test plan for the testing effort
• Conducted Smoke, Non Functional, Functional, System and Integration testing.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Worked with QTP for Regression Testing
• Participated in weekly meetings with the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Autosys, SQL, T-SQL, SQL Server 2000/2005, QTP, Teradata V2R4, Test Director, MS Office Suite, IE, ASP, Crystal Reports,, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000, Rational Clear Quest/Clear Case

Confidential

Software Engineer

Responsibilities:

• Worked on gathering requirements for loan level and pool level amortization process.
• Prepared detailed business requirement documents.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed System Testing and Integrity Testing using WinRunner.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Performed extensive database testing.
• Performed Load Testing, Stress Testing and Performance testing using LoadRunner.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.
• Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, Autosys, Test Director, JSP, Java Script, HTML, Windows NT/2000, UNIX