SUMMARY:

• Around 7 years of experience in IT industry with an emphasis on Software Quality Assurance, GUI, System and Integration Testing, Functional/Regression Testing, Data Migration, Interface, Data Upload, Data Integrity/End to End testing of Web and Client/Server based applications
• Domain competency includes Credit Cards, Banking & Finance and Retail sectors
• Experienced in the creation of use cases and the development and maintenance of test specifications, test cases, test scripts and test data
• Proficient in both Manual and Automated Testing Tools.
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Experience in working with agile methodologies and active participant of SCRUM meetings.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Ad Hoc Testing, Positive and Negative Testing, Security Testing, Stress Testing, Load Testing and Regression Testing of Standalone, Web Based and Client - Server applications
• Involved in maintaining Test Matrix and Traceability Matrix(TTM) and performed Gap Analysis
• Have vast exposure to Data warehousing Testing for projects using DataStage and Cognos.
• Have good exposure to modern Agile methodologies such as SCRUM, TDD (Test Driven Development)
• Participated in design review meetings with production team of Business Analysts, SMEs, PMs and developers in order to understand the critical business functions of the project applications
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Excellent understanding of all modules of Quality center such as Requirements, Release, Test BPT, Test Plan, Test Lab, Defects and Analysis feature.
• Working knowledge of creating different types of test reports through Quality center such as Test Execution Status/Summary, Defect Status/Summary, Defect Injection rate etc..
• Participated in design walkthroughs and verified Quality center Test Scripts and results.
• Effective Time Management Skills and consistent ability to meet client deadline.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Project Methodologies: RUP, Waterfall, Agile, SCRUM, V

Languages: C#, C, C++, VBasic, SQL, ASP.Net, Java, PL/SQL

Web Technologies: HTML, XML, JavaScript, VBScript

Defect Tracking Tools: Test Director, Quality center, Team Track, Clear Quest

Operating Systems: UNIX, Windows, Mainframe

RDBMS: MS SQL Server, Oracle, DB2

Query Tools: TOAD, MS SQL Server Mgmt Studio, My SQL, Autosys

Business Applications: Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook, MS VisioTesting Tools: Win Runner, SOAPUI

WORK EXPERIENCE:

Confidential, Birmingham, AL

Software Quality Assurance Analyst

Responsibilities:

• Participated in Business Analysis, Requirement review and Technical Specs Inspection.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Expert in writing test scripts manually.
• Created and managed system testing schedule.
• Provided test team status reports on weekly basis to the project manager.
• 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.
• Experience in testing Credit Cards Originations, Acquisitions and Authorizations
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Planned and executed backend testing using numerous SQL Queries to verify the dataflow from the database.
• Performed Database testing using SQL queries
• Conducted GUI, Backend, Data Driven and Security Testing.
• Conducted regression testing on new builds/versions.
• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr. Created the performance testing, Quality center deployment, and QTPimplementationschedules using MS Project.
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Wrote complex SQL queries for database validation using TOAD also tested stored procedures and triggers
• Performed Back End Testing by executing SQL queries on Window and UNIX platform.
• Used SQL queries to validate the data between the backend and the front end
• Uncovered multiple issues related to the data population in the backend database using QTP.
• Performed Regression Testing, Functional, UAT and Ad-hoc testing.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Tested DataStage parallel jobs to load data from complex flat file, sequential files, flat files and MS SQL Server.
• Involved in coordinating with developers and business owners.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands.
• Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.
• Reported difference when confirmed as issues in Quality center from SME’s.
• Extensively used the Quality center tool for all thetestmanagementactivities like Release Planning, TestPlanning,Testcase Execution, Requirement Traceability and Reporting.
• Performed backend testing using SQL queries to validate data.
• Detected, reported and tracked defects using Quality center.
• Conducted the defect report in Quality center.
• Interacted with the developers to report and using Quality center.

Environment: Quality center. SQL, ETL, DataStage, Windows, Oracle, Java, QTP, Html, SQL, UNIX, Toad, MS Office, Etc

Confidential, Cranston, RI

QA Tester / ETL Tester

Responsibilities:

• Analyzed Business Requirement Document and Technical Specifications Document and scripted the test cases.
• Provided the test summary report to the QA Lead and coordinated with the fellow QA to plan the test execution.
• Performed manual and functional testing on various parts of the application and used Quality center for defect tracking
• Worked with different modules of Quality center such as Requirements, Test Plan, Test Lab, Defects module.
• Responsible fortestingall new and existingETLData Warehousecomponents.
• Scheduled the DataStage ETL batch jobs on a daily, weekly and monthly basis through Autosys
• Performed Database testing using SQL queries
• Prepared various test reports from Quality center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Coordinated with Business Users and Development for setting up Test Environment, Test Data and Backend Interfaces
• Used SQL queries to validate the data between the backend and the front end
• Created test cases for various modules in MS Excel and exported them to Quality center for Test Case Management.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Created and maintained SQL Scripts and Unix Shell scripts to perform backend testing on the oracle database.
• Wrote complex SQL queries in TOAD to perform Backend testing.
• Tested the SSRS reports to verify the data is accurate.
• Uncovered multiple issues related to the data population in the backend database using QTP.
• Worked with ETL group for understating mappings for dimensions and facts
• Automation test withQTPrecord and playback, data driven the scripts.
• Conducted system health tests and regression tests after every new build.
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Conducted GUI, Backend, Data Driven and Security Testing.
• Created and maintained SQL Scripts to perform backend testing on the oracle database.
• Performed Database testing using SQL queries
• Automated the Backend testing for reusability by writing Unix Shell Scripts
• Set-up, co-ordinate & conduct system & UAT testing with Business Analysts and end-field users after the applications were all set.
• Conducted reviews with clients and User Acceptance Testing teams
• Involved in reports that were created in SSRS were testing by running the SQL statements against the tables SQL Server Database
• Performed Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Actively participated in Walkthroughs and Daily status report meetings.

Environment: Quality center, ETL, DataStage, UNIX, Autosys, Quick Test Professional (QTP), ASP.Net, SSRS, JavaScript, SQL Server, Windows, Oracle, Etc

Confidential, Wilmington, DE

QA Tester

Responsibilities:

• Analyzed Business Requirement Document and Technical Specifications Document to identify
• Performed manual and functional testing on various parts of the application and used Quality center for offshore defect tracking and QC for onsite defect tracking
• Responsible for Manual Testing and Automation Testing.
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
• Participated in projectimplementationand deployment planning
• Worked with different modules of Quality center such as Requirements, Test Plan, Test Lab, Defects and Dashboard module.
• Prepared various test reports from Quality center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Created Test data for testing various scenarios involving the creation of Packages, Customers, Accounts for Deposits, Loans, Credit Card applications
• Used SQL queries to validate the data between the backend and the front end
• Created test cases for various modules in MS Excel and exported them to Quality center for Test Case Management.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Conducted Backend testing manually for the purpose of Database Integrity.
• Performed backend testing using SQL queries to validate data.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Set-up, co-ordinate & conduct system & UAT testing with Business Analysts and end-field users after the applications were all set.
• Conducted reviews with clients and User Acceptance Testing teams
• Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Performed Database testing using SQL queries
• Executed the Test Scripts in Quality center.
• Defects are logged using Quality center and follow up with Business and Developers to discuss about the issues.
• Actively participated in Walkthroughs and Daily status report meetings.

Environment: C#, .NET, Java, Windows, UNIX, SQL Server, Quality center, XML, HTTP, Etc

Confidential, Pasadena, CA

QA Analyst

Responsibilities:

• Involved in developing detail Test Plans for different benefit packages according to Business requirements documentation.
• Involved in discussion with the Subject Matter Experts (SME) during creation of test plans and clarification of business requirements.
• Coordinated with the Test Manager to review the Scope Items and the Test Execution Status before handing over to the UAT Team.
• Involved in scripting Test Cases and executing through the Test Director.
• Interacted with Business users and Technical team in providing clear solutions to requirements and script the test cases based on that.
• Executed the Regression Test cases to validate the existing functionality.
• Performed Smoke/Sanity test to validate the application after new build or defect fixes.
• Worked closely with the customers to get the priority for the defect and assign them to proper Dev Team.
• Involved with business user and stake holders and performed UAT.
• Performed User Interface testing bases on the UI Test cases.
• Performed Regression testing to make sure there are no loss functionalities.
• Developed the functional test cases from the functional requirements.
• Worked with the customer to identify the checklist for UAT Testing.
• Tracked the requirements through HPQC and executed the test cases using test lab module.
• Interacted with developers to report and assign bugs using Test Director
• Detected and reproduced the defects, and logged defects using Test Director.
• Participated in defect triage meeting with the developers, managers and business people and presented the Defect reports in the defect review Meetings.
• Involved in testing different functionality for a Java based web portal (Web Service).
• Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
• Run complex SQL queries to determine the data inconsistency.
• Checked database and with application queried result is being equal, SQL queries is being extensively used to check the data from the data base using Toad.

Environment: Test Director, Java, TOAD, Oracle, PL/SQL, Windows, Etc