Twelve years of professional diverse experience in Quality Assurance, Manual, Automated and GUI Testing. Worked extensively on database, data warehouse, ETL and reporting technologies. Developed strength in all phases of Software Design and Development life cycle and QA Automated tools QTP and Selenium WebDriver prepare and deliver progress/status reports, both written and oral, to senior management. Possess a strong analytical, verbal, inter-personal skills that helps in communicating with Developers, team members, writing the reports and test documentation.

Work Summary

Confidential

Sr QA Analyst / Release Management

• CIDW is a Line of Business Oracle data warehouse with trading books and portfolio information.
• Corporate Investment Data warehouse
• Created QA Test templates, to support UCAL and SOX Compliance Application.
• Worked in Global Funding Inter Company Loans.
• Created Test Plans for Windows to Linux Migration of Autosys and Informatica Workflows.
• Built an automated regression suite for testing the Dynamic data load functionality developed in Perl.
• Automated code deployment of SQL scripts, Informatica Workflows , Autosys, Perforce file sync both in QA and UAT Environments using Excel.
• Created and setup Autosys Jobs and Perl Scripts for data loads in all environments, as part of an agile team.
• Provided test estimates and gathered information from planning meeting for every Sprint.
• Developed SQL, VB scripts for data validation to compare UAT and Production data.
• Identified issues during testing, Investigated the Autosys and Informatica Job failures in UAT.
• Scheduled release planning meetings with Scrum and Kanban teams and documented a release plan with instructions for Production deployment.
• Generated Release and Test reports from Version One, conducted RCA meetings.

Confidential

Senior QA Engineer

• Worked in Agile project development methodology.
• Provided test estimates and gathered information from planning meeting for every Sprint.
• Created positive/Negative test cases, build complex SQL using joins and analytical functions.
• Proficient in creating complex validation SQL on Oracle 11g.
• Automated executing of SQL statements, Created VBA scripts in Microsoft Excel.
• Tested the web application, calculations on reports using data from SQL server and Oracle databases.
• Automated repeatable tasks, smoke test using QTP.
• Setup Eclipse, Created Maven Project, added Selenium WebDriver and built and automation hybrid framework.
• Implemented the Page Object Model, Data Driven, Modular Driven, Log4j and TestNG Reporting.
• Automated existing manual test cases for functional and regression testing. Promoted the use and acceptance of test automation tools.
• Provided daily updates to project management in stand up meetings.
• Participated in go/no go meetings, worked closely with development to ensure defects are fixed for successful story completion.
• Worked closely with development, DBA and app deployment teams during implementation for every release.
• Communicated test progress, test results, and demo application and relevant information to project stakeholders and management.
• Lead efforts to identify defects and direct defect management and tracking to ensure proper follow-through and resolution of issues.

Confidential

Senior QA Analyst

• Reviewed the business requirements with Business Analyst and Developers.
• Created test cases and obtained Business Owner sign off.
• Conducted daily test team meetings, to complete testing in a Quality way.
• Performed web service testing using SOAP UI.
• Executed UAT test cases and reported the results to Business.
• Shared responsibility with UAT to validate results from executed test cases.
• Ran jobs and setup scenarios to test the application.
• Provided a go/no go production release notification to Project team.
• Coordinated adding code to various test environments.
• Conducted regression and smoke test for project releases.
• Informed gating testing concerns to Quality assurance Team Leader.

Confidential

Senior QA Analyst

• Reviewed the Functional requirement, SSD's and business requirements.
• Worked on various projects in agile project development methodology within the organization.
• Involved in migrating the VEC program/Contract onto SMART/ PEGA platform.
• Created Test Plans, Test Cases to test the Claims functionality for various products.
• Tested the VEC claims/invoice Functionality, Verified the outbound, inbound feed files and their statuses.
• Worked extensively on uploading and processing sales files on UNIX, Verifying file formats, mock up and create test data.
• Documented, created RTM, to enable traceability of business requirements throughout the program lifecycle.
• Worked closely with the project team members and business subject matter experts SMEs .
• Actively participated in analyzing requirement and provided feedback to requirements analyst and project manager.
• Validated the ETL functionality, Created test Data sets, ran the process, ensured data is populated as expected.
• Participated in code, design, and database schema design reviews in oracle 10g to 11g migration.

Confidential

Senior QA System Analyst

• Acquired knowledge of the application and created and AID document.
• Transferred Knowledge to offshore team by scheduling through Net meeting Sessions and discussed on variety of processes that are repetitive in the existing Manual testing process and reviewed the Automation approach document prepared by the offshore team.
• Reviewed the High level design HLD , A D's, Functional requirements, System Impacts and discussed the new functionality Implemented in team meetings and A D walkthroughs.
• Involved in reviews with business, development and user teams and reported bugs and third party issues.
• Created, implemented, and promoted plans to identify and mitigate risk and to ensure continuous process improvement
• Created QA plans and procedures focused on IST, End-End and user acceptance test efforts for every release by thoroughly understanding the requirements and design documents.
• Created test data, includes of both data inputs and expected outputs/results.
• Participated in review meetings and walkthroughs with development and Business Analysts and made sure the A D documents are updated.
• Effectively reported project status, issues, and dependencies on check point calls to the higher management, E2E teams, UAT project teams and project stakeholders.
• Performed back end testing by executing complex SQL queries with conditions that are derived from business rules.
• Participated in End to End testing for every release and ran shell scripts that load data from feed files to Source database.
• Involved in testing 40 interfaces, which includes extracting XML messages using web service utility programs and verified the data mapping into main tables.
• Verified XML messages sent to EOM via SOA.
• Used Data Stage Director to run scheduled jobs and as well monitored server jobs.
• Received training on agile development methodology, Involved in pilot projects with this methodology.

Confidential

QA Analyst

• Involved in preparing test plans based on Business Requirements Document BRD .
• Manually tested the User Interface data flows and its compliance with the UI Requirements.
• Designed and Developed Test Cases for automated testing using Q.T.P.
• Identified test cases for automation and regression testing and prioritized the same.
• Analyzed the results from the Regression test cases executed in Silk Test 7.1.
• Ensured that no Commission is paid to Advisors who were not in compliance with NASD and Securities and Exchange SEC rules and Regulations.
• Developed test scenarios that require multiple cycles to test the functionality point.
• Manually performed Ad-Hoc, Integration, End-to-End, System and Functionality testing.
• Identified and documented application defects to communicate them to the developers.
• Tracked Defects, reviewed, analyzed and compared using Test Director.
• Performed back end testing by executing SQL queries with conditions that are derived from business rules.
• Maintained all the Requirements, Test Plans, Test cases and Defects in the Test Director.
• Effectively reported project defect statuses, resolutions, and ETA on calls to UAT project teams and project stakeholders.

Confidential

QA Analyst

• Reviewed system requirements and product specifications adhered to SDLC methodology and standards.
• Prepared and reviewed functional test plans detailed test strategy and high level test design documentation.
• Created and executed test cases as per the schedule in a multi-platform environment that includes UNIX and Web based operating systems Oracle databases and other technologies.
• Conducted and assisted with the creation, execution and maintenance of feature and regression test suite.
• Created and maintained test data, record test results, tracked and worked with developers towards resolution of issues.
• Created Test Plans, Test Scripts and manually executed Test Cases and performed detailed validation.
• Designed and executed manual and automated test cases, developed checklists to perform functional, regression, and system test.
• Executed test cases and test conditions in a testing environment for Integration and System Test.
• Created new or modified existing Test Scripts based on specification and requirements documents.
• Created window declarations, added user defined methods and developed Data Driven Test cases.
• Tested the web and client/server applications.
• Developed and maintained test specifications, test scripts, test data, and troubleshooting test issues, recorded test results, and tracked defects.
• Involved and identified the business process for load testing.
• Recorded user transaction actions using Vuser generator and generated Vuser Scripts.
• Created and managed scenarios using loadRunner controller that controlled Vusers.
• Automated Scripts that were Reusable, Robust, and Maintainable and were data Driven.
• Verified Transactions and broken links and performed System, Usability and Configuration Testing to make sure application compliance to the QA standards.