SUMMARY:

• 7+ years of experience in Quality Assurance in Information Technology, in both Manual and Automation testing of Client Server, Web applications, Mobile applications, Data Warehousing and ETL testing.
• Expertise in analyzing Business Requirement Documents, Functional Specifications and Technical Specifications.
• In depth knowledge and understanding of Data Warehousing, Data Validations in SQL Server, DB2, Oracle 10g,11g,12c databases.
• As a QA Analyst and QA Lead worked in various industry verticals - Auto Insurance, Health Care Retail and Utility Domain.
• Strong work experience in Waterfall and Agile (Scrum) methodologies.
• Expert knowledge in Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the Business requirements.
• Proficient in Functional, Integration, Regression, User Acceptance Testing, Smoke Testing
• Proficient in System Testing, Database Testing and GUI Testing.
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support)
• Extensive knowledge on all phases of Defect Life Cycle including Defect Tracking, Defect Triage & Defect Report activities.
• Experienced in Manual and Automation testing using HP Quality Center, ALM 11.0, UFT 12.01/12.53
• Proficient in performing Back End Testing by extensively using SQL queries to verify the Database Integrity
• Experience in testing Oracle Business Intelligence RPD and Dashboard reports.
• Experience in writing SQL queries to validate Database accuracy and used SQL Statements to extract Data from Tables to verify the output Data of the reports on SQL Server & Oracle databases.
• Created and maintained the Test Matrix and Requirements Traceability Matrix.
• Provided Cross-functional Training on various applications to onshore and offshore team members to get them up to speed with QA Testing.
• Strong problem solving skills, quick learner, excellent communication skills and ability to work as self-directed team member under little or no supervision.
• Experience as an Agile Advocate for a Scrum team.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix

QA Analyst / Agile Advocate

Job Responsibilities:

• Collaborate with Product Owner, development team to streamline quality assurance activities.
• Coordinate with Client and prepared test plan, test cases and ensured that the testing phase meets quality standard.
• Assist Project team to define the project scope and schedule for QA activities.
• Responsible for testing Service Level Reporting OBI RPD and OBIEE Dashboard.
• Hands-on testing experience for Manual, Functional, System, Integration, Regression, End-to-end testing. Experience working with automation team for regression and functional areas, maintaining automation test scripts in Visual Studio 2013 and documents to improve QA process.
• Analyze and review Data Stage mappings to understand the implementation of Business rules.
• Regularly interact with Management and Product Owner on project status, priority setting and sprint timeframe.
• Administrate project review, escalations, quality assurance, tasks completion, project deliverables & project status reporting for the project.

Environment: Agile, SharePoint, sqldeveloper, VersionOne, WinSCP, SQL, Visual Studio 2013, Oracle 11g, 12c, IBM Datastage 8.7.

QA Lead / Automation Lead

Job Responsibilities:

• Manage end-to-end testing work (source to ETL testing and ETL to UI testing) for the DW distribution portfolio and lead offshore team of 5 members to assign module/activity/tasks/deliverables.
• Provide technical know-how, support, mentoring & coaching offshore team members on technology, business & other project specific aspects.
• Analyze and understand testing requirements from business requirement document, technicalrequirement specs.
• Analyze and review Informatica (ETL) mappings to understand the technical implementation ofbusiness rules.
• Design and document Data warehouse (EDW) testing strategy covering the test cases forvalidating the data completeness and correctness of the ETL processes etc.
• Prepare Test Plan and Effort of Estimate.
• Prepare the Test Scenarios for Summary/Detail Testing, Functional Testing, Regression Testingand End-to-End Testing
• Schedule and Monitor the Test Cases execution
• Scheduling Defect Triage meetings to keep track and level of severity defects and communicating it with Project Manager with Execution Score Card and defect Status.
• Log and publish the test results and raise the defects to the mantis defect/change managementsystem.
• Used Data Validation Option DVO to design Informatica test cases, run tests and evaluate the test results
• Used DVO for Source and Target DB validation
• Reporting the Validation errors to ETL team.
• Send daily Test Status reports to Project team.

Automation Lead

Job Responsibilities:

• Author Automation Project Test Strategy / Test Plan.
• Define the standards for the Framework.
• Coordinate schedule and scope for the project and include the information in the Test Plan.
• Decide the number of offshore resources required and communicate it with Team Manager.
• Review and Decide effort for completing Feasibility plan.
• Review the Feasibility Plan and provide adequate information wherever required.
• Review User Guide for the project.
• Timely review of the code and provide feedback in the code review document.
• Conduct daily meetings with offshore for tasks review.
• Review the scripts and execute if needed.
• Define bug-tracking process, provide all necessary information to the Automation team, and communicate the same with the project team.
• Demo the automation scripts to the project team whenever required.
• Provide Test Strategy/Test Plan, Feasibility, Framework & Guidelines, Lessons learned, Impact Analysis, Effort of Estimate, Naming Convention, Test Coverage Matrix, User Guide, Code Review template document to team.

QA Analyst

Job Responsibilities:

• Reviewed test specifications and cases, written by others for coverage and completeness in order to improve test quality and effectiveness of the whole Software Development Life cycle
• Performed planning and execution, defect reporting and fix verification using manual and automated techniques to have test plans in place and executed according to our release schedules.
• Lead initiative for proper detailed documentation of QA reports.
• Participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration meetings.
• Participated in User Stories inspections to identify ambiguity and inconsistency as well as improve UI/UX design based on currently used aps.com website.
• Worked as a liaison between UI dev (BrushFire) and dev team (APS) along with testing team to meet the business requirements and site roll out.
• Used Confidential (proprietary project management and bug tracking Scrum software) and Basecamp (a leading web-based project management and collaboration tool) during the project.

QA Analyst

Job Responsibilities:

• Analyzed Functional Requirements and Business Specification as part of mobile Testing on earliest stages of SDLC
• Collaborated with all teams within the agile environment
• Responsible for creation, design and execution of test strategies, including writing test plans, test cases and test scenarios.
• Identified, analyze, and document defects using TFS defect tracking system. Triaged mobile device applications issues
• Developed and implemented QA Methodologies for the department. This included, but is not limited to development of test case standards, requirements traceability matrix, and testing metrics.
• Acted as liaison between development and business teams - provided visibility and clarity into business requirements to the development teams, and provided design and architecture insights to the business teams.
• Coordinated QA and UAT sessions and executed UAT scenarios with end users for final approval and user signoff.

QA Analyst

Responsibilities:

• Involved in reviewing the Business requirements document and Technical specifications document.
• Developed Effort of Estimate for development of test cases and execution.
• Involved in developing test scenarios, test cases and test execution
• Developed RTM to map requirements with test cases
• Used Microsoft Visual Studio 2013 and Test Manager to upload test cases, assign test cases to the team as per Lead’s direction and used visual studio for test execution tracking purposes.
• Responsible in providing regular daily test reports to QA Lead and Project Manager and weekly status updates to the project team.
• Tracked defect status in TFS by scheduling Defect Triage meetings with the project team and offshore team.
• Work closely with Release Configuration Management team in setting up and maintenance of New Projects.
• Responsible for creation and maintenance of user accounts and authentication via LDAP/Active Directory
• Ensure Users have correct permissions within a project
• Provide support, demos and maintenance to all the user groups as needed, ALM point of contact with other groups related to current project.

QA Analyst / Automation Analyst

Job Responsibilities:

• Performed Integration, System/Functional, Regression and documented the Test Results.
• Involved in Defect Triage meetings.
• Created Test data and Test suite and generated Daily/Weekly Status reports on Test Execution
• Performed Front-end Testing as part of the web - application Testing.
• Created Requirements Traceability Matrix.
• Extensively used HP - ALM (Application Management Lifecycle), for running Manual Test scripts.
• Created an inventory of all project documents on the QA SharePoint.
• Created and constantly updated the Query tracker for every release/enhancement.
• Scheduled review meetings with the Business, to discuss the Project Execution status, Timelines, Key Deliverables, Metrics.
• Review product requirements, functional and design specifications to determine and prepare automated test cases.
• Work closely with other project team members to automate the Smoke Test Scenarios that are required to run with every new patch/release.
• Supported in design of the Automation Framework.
• Prepare Reusable functions, which improve the robustness, re-usability, and maintainability of the smoke testing scripts.
• Support Dev/QA teams with issues using the tool.

Environment: Agile, Waterfall, SharePoint, Visual Studio 2010/2012, Microsoft Test Manager 2013, Informatica 9.6.1, DVO, Sql, Unix, pgAdmin III, VBScript, HP ALM 11.0, HP UFT 12.01/12.53, Confidential, MS SQL.

QA Lead

Responsibilities:

• Managing QA deliverables and assignments on schedule and within defined test cycles ensuring test design and defect documentation in par with QA standards.
• Project planning; working with project team to define/design test scope for each project assuring testing alignment
• Analyzing QA Capacity and work estimates of stories during pre-sprint planning.
• Working collaboratively with QA team to create and update test cases to ensure accurate and productive test execution
• Preparing and presenting status updates for various projects: documenting and reporting systems defects (including defect summary, steps to recreate, expected and actual result).
• Creating and maintaining test data for test execution scenarios, ensure data setups are accurate and appropriately stored in test database.
• Supervising functional, regression test execution deliverables.
• Check for timely delivery of different milestones
• Generating Defect Status Report and sending updates to the PM’s when a project is in Red status or when the delivery date has moved from its original gate date.
• Organize meetings to keep a track and report upon activities, test results and any defects with the team and providing a report of the same to PM and the Business.
• Creating generic library functions and reusable actions, which could be used across all the scripts.
• Created automation assets and scripts for the specific modules of the TPMS (Third Party Management System) application.
• Creation of the regression suite for the TPMS Application using QTP Scripting.

Environment: HP QC 10.0, HP Quick Test Professional 10.0, SQL, IBM AS/400

Test Analyst Technical

Responsibilities:

• Attended daily Standup Sessions with the Team in order to update progress on stories and impediments.
• Attended Grooming Sessions every sprint in order to estimate the work effort needed for each story.
• Raised impediments in company specific application so that the Scrum Master/Product Owner could readily assist in removing impediment.
• Lead Scenario Review Sessions with Business every sprint in order to review Scenarios to be tested and get Business Approval.
• Active participant in Story Boarding Sessions, Detailed Planning and Regression Sessions.
• During Hardening Week, ran Regression Test Cases in QC for all of the stories completed in a sprint.
• Reviewed the Requirements with the Business units and created Test Scripts for the various scenarios (Integration and System Test Cases).
• Created a Requirements Traceability Matrix (RTM) for the project.
• Ensured that the scripts created have a high degree of modularity in them so that they are reusable for other scenarios.
• Tested the GUI (Frontend) to ensure the authenticity of the data retrieved from the database.
• Validated the Data population in the Tables in Backend by writing complex SQL queries.
• Defect logging was done using HP ALM 11.0 and were tracked in daily scrum meetings.
• Created Test cases for Regression testing and ensured the application was working as expected.
• Worked with the Off shore Dev team to understand the finer intricacies of the process and to track the status of defect fixes.
• Attended bi-weekly meetings to report the Test Execution status to the QA Manager.
• Mentored new members on the team on the application path flow and assisted them in setting up the required tools and access lists, in order to do their project tasks.

Confidential

SQL Developer

Responsibilities:

• Coordinate with the SMEs to gather the business requirements.
• Prepare a technical requirement document based on the gathered business requirements.
• Validate if the Informatica mappings as per the technical requirement document.
• Verify UNIX scripts as required.
• Mentor and co-ordinate onsite - offshore ETL team for Group 4(Financial functionalities) related ETL efforts.
• Consolidating deliverables from onsite-offshore team.
• Ftp the data from Unix Server to DB2.
• Raise the defects if any, for each of the implementation run.
• Co-ordinate with the Implementation Coordinators to restart/stop Control - M jobs in case of any failures.
• Writing complex SQL as a part of Row counts testing.
• Involved in team meetings to review and understand the client requirements and identified testing tasks and resources, and scheduled and documented it into a formal test plan.
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.
• Analyzed the user/business requirements and functional specs documents.
• Used the State Farm Proprietary Automation tool(CAVE) to execute the test cases.

Environment: HP Application Lifecycle Management 11.0, HP Quick Test Professional 10.0, SQL, FTP, SFTP, SQL Assistant, Quality Center 10, UNIX

Intern Test Engineer

Responsibilities:

• Reviewing the business requirements document, and technical specifications document.
• Involved in tracking defects, planning the test cases on QC.
• Uploading test cases, requirements, test plan, test data in Quality Center.
• Experience in execution of Test Cases using the Quality Center.
• Responsible for monitoring the test matrix and communicating status and issues to Test manager.
• Created all requirements from Requirements finalized doc.
• Written SQL statements for data validation.
• Involved in Test Estimations to develop test cases and execution.
• Test Case status reports and defects reported weekly in status meetings.
• Involved in Developing Test Cases, Test conditions and strategy.
• Traceability Matrix developed to map Requirements with Test cases.