SUMMARY:

• Solution - focused senior software QA tester and QA Lead with 7 years of experience in Web-Based, database QA and Testing practice, strong knowledge all the phases of SDLC and strong knowledge of software testing (Functional, Integration, Performance, Quality Metrics).Involved in review of FRD and BRD with Business teams.
• Expertise in Test Strategy, Test Plan, Test Scenarios, Test Environment Setup, Test Cases Design, Test Data Setup, Defect Management and expertise in bug tracking tools like HP Quality Center, ALM, Bugzilla, and Jira.
• Possess excellent skills in Sanity Testing, Functional Testing, GUI Testing, Regression Testing, Integration Testing, and User Acceptance Test (UAT) and system Validation.
• Excellent experience of working with Agile Methodologies.
• Proficient in analyzing business requirements and Risk associated that.
• Good exposure of working in onsite - offshore team model
• Expert knowledge of Business Analysis methodologies and excellent experience of working for the data warehouse projects in agile framework and handing multiple projects.

TECHNICAL SKILLS:

Database: Teradata, Oracle, DB2, MS SQL Server, MS Access

Test Management Tool: QUALITY CENTRE (9.2 & 10.0), ALM, RTC, Team Foundation Server(TFS), Jira

Bug Tracking Tool: QUALITY CENTRE (9.2 & 10.0), ALM, Bugzilla

ETL/BI Tool: Informatica MDM, IBM MDM, Informatica Power Center, IB Data Stage, Qlikview, Tableau

MS Office: Word, PPT, Excel and Visio

Other: Web Services, Data Warehouse, MDM, SAS, UNIX, Mainframes, Passport PC to Host, Text pad, Notepad++, WinScp, Zena Scheduler, Infogix, Tidal

Testing Types: Windows Server 2000/2003/2008 R2, Windows XP/Vista/Windows 7 Web Based Testing, ETL / MDM / Data warehouse, BI Report / Data migration Testing, Regression testing, Negative Testing, User Acceptance Testing, Smoke Testing

PROFESSIONAL EXPERIENCE:

Confidential, BOSTON, MA

QA Lead

Tools: Oracle SQL Developer, Toad, Squirrel, ESP in-house ETL tool, QC/ALM, IRD in-house Report development tool, RTC

Responsibilities:

• Responsible to represent QA team within Agile based project
• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Perform effort estimation on test activities
• Prepare Test automation tool to automate report testing
• Use automation tool to perform ETL testing
• Create Test plan, Test strategy, review test cases and test results.
• Use ALM to manage test and defects.
• Perform functional, performance and regression testing.
• Utilize strong knowledge of Agile Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, and Support) in Project and coach other QA team members.
• Participate in Requirement Walkthrough’s, Defect Triages, Stand up calls to represent QA Activities as a QA Lead.
• Coordinate within Onshore/Offshore testing/application teams.
• Prepare Traceability Matrix, QA Summary and Defect Summary Report documents

Confidential, Cambridge, MA

Senior Software Quality Assurance Tester and lead

Tools: Qlikview, Oracle SQL Developer, ALM, Tableau, Jira, Cloud based ETL

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Identified the Test Cases and documented them in ALM.
• Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process.
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Base-line and Regression tests were scheduled and performed on every Release and build.
• Supported End-to-end testing for downstream systems.
• Creation of Test Data for Member data’s according to the scenarios.
• Loaded the Test Data into the ALM to prepare for the execution of Test Cases
• Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication among Onsite and Offshore Team Members.
• Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
• Coordinated user acceptance testing with final users. Prepared end user documentation for the new system
• Used ALM to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using ALM
• Expertise in generating the daily defect detailed report using ALM for the other project stake holders and the project Management
• Maintained bug lists for critical issues using ALM.
• Perform BI report testing using Qlikview and Tableau
• Test data on cloud based systems.

Confidential, Dayton, Ohio

Quality Assurance Analyst

Tools: Informatica Power Center, Teradata, ALM, Tidal, SAS

Responsibilities:

• Created company’s comprehensive database of documented test defects and procedures to enable accurate replication and ensure compliance with standards. Accelerated average QA testing turn-around time by 25% or more, allowing company to accept more testing projects without increasing staff and reported defects involving program functionality, output, online screen and content to software developers. Performed rigorous defect analysis and classified based on Risk and Severity.
• Designed and implemented macros for testing addressing data comparisons.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• Creation of Test approach, Test Plan, Test Scenarios, Test Cases, Test and Defect Summary reports, Test metrics.
• Data sub setting, Data masking, Synthetic data creation as part of Test Data setup resulting in maximum test coverage.
• Testing the reports based on the Risk Analysis by involving in Business Requirement Analysis.
• Performed Data mockups.
• Wrote extensive SQL Queries in SQL Server and Teradata and helped other team members in writing SQL
• Testing of SAS EG reports for ICD10 Changes.

Confidential, Columbus, Ohio

QA Lead

Tools: Informatica Power Center, ALM, Zina Scheduler, Bugzilla, IBM MDM, SQl Server, DB2, MS Access, Infogix, Winscp

Responsibilities:

• Understanding of Business Requirements from BRD by walkthroughs and Brainstorming sessions.
• Validation of Existing Defects in the system also involved in planning of Defect validation
• Involved in Defect Validation Summary reports
• Testing in DV, QA and Prod Environments
• Involved in Implementation Plan and in Post Implementation activities
• Involved in Data Setup activity, Defect validation in downstream systems and impacted application
• Co-ordination with the teams of impacted applications
• Job runs using Zena Scheduler.
• Tested MDM match and merge rules.
• Involved in Creation of Testing dashboard using QC to provide clear picture of testing status and to help the team in planning the testing activities.
• Performed Process improvements by creating file compare tool using excel sheet to reduce the manual effort in file comparison and by using Access for Test Data setup
• Tested mapping of the Source Fields to Target Fields and validated the transformation rules.
• Perform regression and system testing to find defects, used QC tool to manage and log defects
• Wrote extensive SQL Queries in DB2 and helped other team members in writing SQL Queries.
• Run the job using Data stage or Zena scheduler and Tested the Data threshold using Infogix controls Validated
• Executed multiple Extract Transaction Load (ETL) tests of the application using DB2 and Data Stage tools and made suitable changes to improve the overall quality of the application and data warehouse
• Handled Bugs and Error existing in Data Warehouse of multiple applications
• Worked in the form of sprint team with business analysts and developers in agile methodology. Performed tests on various sprints of Agile/scrum SDLC process.
• Reviewed business requirements and technical specification documents.
• Performed specification analysis, created test cases, test plans, tested software applications, and logged defects, worked with development team in resolving defects and assisted in production issues resolution & retesting.
• Collaborated with business analysts to understand and help clarify requirements and assess testability.
• Defects were tracked, reviewed, analyzed and compared using HP ALM/Quality Center.
• Assisted Business analyst by providing test cases for use at the User Acceptance Test Level.
• Created Test Plan, RTM Matrix, QA Summary Reports and Defect Matrix and Defect Analysis Reports.

Confidential, Columbus, Ohio

QA Lead

Tools: IBM Data stage, SQl Server, DB2, Oracle, QC, Infogix, Zena Scheduler, Winscp, Putty, Mainframe, TFS

• Understand the Credit Admin and CCAR systems
• Plan, Execute and Monitor a detailed integration test cycles for the CCAR IT Program.
• Develop a detailed integrated test plan, including environment and data strategy and scope negotiation
• Tracking of project effort, milestone tracking, tracking of risks, issues and dependencies
• Ensure test plans are agreed upon, signed off and executed across all work streams in a timely manner
• Wrote extensive SQL Queries in DB2 and helped other team members in writing SQL Queries.
• Run the job using Data stage or Zena scheduler and validated Data Warehouse using SQL queries.
• Executed multiple Extract Transaction Load (ETL) tests of the application using DB2 and Data Stage tools and made suitable changes to improve the overall quality of the application and data warehouse
• Handled Bugs and Error existing in Data Warehouse of multiple applications
• Detailed study of the SRS, FRS and user manuals before creation of any plan for applications and modules.
• Developed Test Cases on the user stories (functional and technical requirements), based on SRS documents and Mapping documents from Business analyst and technical design documents from Developers.
• Bug/Issue reporting on missing/conflict functionalities, functionalities which are not working as expected with bug severity and priority in JIRA.
• Maintained issue trackers to track requirement and business clarifications.
• Involved in Data warehouse testing of the System using DB2, Oracle, and SQL Server Databases.
• Participated in weekly meeting with the management team and walkthroughs.
• Created Test Plan, RTM Matrix, QA Summary Reports and Defect Matrix and Defect Analysis Reports.
• Impact analysis of the proposed changes to the existing system.
• Collaborate with various other interfacing systems teams to ensure proper connectivity and data transfer.

Confidential

Software tester

Tools: SQL Server, TFS, Bug Zilla

Responsibilities:

• Detailed study of the SRS, FRS and user manuals before test plan, test case preparation
• Involved in writing test cases, executing the test cases according to test coverage requirements
• Tested the functionality and usability of web applications on different testing environments throughout the software development lifecycle.
• Wrote use cases and test cases based on the software requirements, content model, and/or business rules. The test cases ensured the thorough testing of each component in the web application prior to final delivery.
• Documented changes to requirements and tested their implementation in new versions of web applications.
• Documented software defects and performed additional testing to verify all issues were fixed before final delivery.
• Execution of manual test cases and updating the current test status report release wise
• Detected bugs & classified them based on the severity and preparation of system test summary reports
• Performed Smoke Testing on full application
• Prepared an exhaustive list of test cases covering all the requirements and all possible scenarios.
• Installing the Build and launching the Application.