SUMMARY

• Over 7 years of experience in quality assurance practices, testing, business analysis, and test development in a structured, full life - cycle development and validation environment.
• Experience in SDLC and STLC processes.
• Expertise in working in Agile, Scrum and Waterfall environment.
• Performed backend testing for database integrity by executing complex SQL queries for validating the data in the backend database.
• Experience with JIRA, Application Lifecycle Management (ALM)/HP Quality Center.
• Proficient in gathering & analyzing business requirements, and documenting SRS, FRS and Requirements Traceability Matrix (RTM).
• Current job profile also includes Requirement Analysis, creating QA estimate, project forecasting, Test Planning and Defect management.
• Quickly and efficiently adapt to new technology.
• Created Test Strategy, Test Plan, Test Metrics, Test Summary Reports, Test Cases and Test Scripts for manual testing based on the User Requirement and System Requirement documents for the Functional, System, Regression, and UAT Testing.
• Expertise in understanding business requirements, functional requirements & test cases for positive and negative test conditions.
• Expertise in performing different types of Testing: Black Box, Functional, System, Integration, User Acceptance Testing, Mainframe, Smoke, End to End, Exploratory and Performance Testing.
• Cross-platform testing/development experience - Windows, MAC, UNIX.
• QA and BA experience with expertise in Requirement Gathering and Gap Analysis.
• Experience in utilizing QC dashboard for generating project health report for seniors.
• Good Understanding in Web related technology like HTML, VBScript, and SQL.
• Outstanding People Management skills, with over 3.5 years of experience with offshore team management (team size of 10-15 members).
• Lead the team and acted as point of reference for other team members.
• Productively, interactively and proactively engage with various teams and leads on issues pertaining to deliverable, processes, issues etc.
• Product testing, UAT and Regression Testing for Procurement System (SRM).

TECHNICAL SKILLS

Tools: HP Quick Test Pro 9.5/10, HP Quality Center 10/11, JIRA

Programming languages: VB script, HTML, SQL, PL/SQL, Java

Database: Oracle, MS SQL Server, MS Access

Other tools: Microsoft Office, MS Outlook, VISIO, MS Project 6.0, Visual Studio

Configuration Management tools: IBM Rational Clear Case

Industry Skills: Consumer Banking, Test Management, Test Planning, Software Quality Assurance, Team Leadership/Motivation, Problem Solving, People Management

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

QA Analyst/ Backend Tester

Responsibilities:

• Designed and created test plans, test scenarios and test cases for testing.
• Involved in daily scrum meetings, iteration/sprint planning meetings to plan the stories that need to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Detected diverse bugs across all severity levels, and reported them usingJira.
• Communicated technical specifications with the team members.
• Sent day to day migration phase reports to higher management and kept them up-to-date.
• Performed data quality gaps anddata cleansing (Scrubbing) to ensure no missing data/duplicate data was found.
• Attended weekly status meetings with the management and offshore teams.
• Captured every requirement mentioned in the FDD and BRD with their possible variations correctly and completely during the test planning and preparation tasks.
• Identified test data for test execution.
• Incorporated SQE test standards during planning/preparation and execution tasks.
• Defect Management and Status Reporting.
• Proactively used DB visualizer tools, and SQL programming in the back-end and front-end functions, procedures, and packages to implement business rules and security.
• UsedVBScripts in QTP to access script variables.

Confidential, Buffalo, NY

Data Warehouse QA Tester

Responsibilities:

• Helped the client to improve systems and strategies to better utilize new technology and increase their compliance with new regulations.
• Involved in business analysis and requirements gathering.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested ETL mappings and worked with source in staging area to validate the Basel II multiple source system data with SQL queries.
• Reported bugs and tracked defects usingMS Excel and ALM.
• Executed queries in Oracle to validate reports and troubleshoot data quality issues.
• Learned to prepare test plan and test cases in the absence of proper project documentation.
• Solid testing experience in working with SQL stored procedures, triggers and views, and worked with performance tuning of complex SQL queries.
• Responsible for testing business reports developed by Micro Strategy.
• Tested mappings with the design documents and also performed testing for various sample data.
• Created and execution of manual test cases in ALM.
• Tested various mappings with transformations like Filter, Joiner, Sequence Generator and Aggregator.
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools.
• Involved in extensive DATA validation by writing several complex SQL queries.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Involved in writing detailed Level Test Documentation for reports and universe testing.
• Ensured weekly deliverables of the requirements as per theAgileModel.
• Attended weekly status meetings with the management and offshore teams.
• Performed Smoke test and Sanity test for New Build.
• Conducted Regression testing on various builds of the application and reported defects to the team.

Confidential, Ann Arbor, MI

QA Test Analyst

Responsibilities:

• Involved with them in gathering User Requirements and Business Requirements.
• Wrote Test plans according to business specification and design documents.
• Created Manual Test cases for each of the functionalities and automated the bug free test cases for Regression Testing.
• Installed VMware on various QA machines to test application against different operating systems
• Involved in running regression tests using Mercury QTP and preparing the results and charts for reporting purposes.
• Extensively created Data Driven test scripts in QTP to read from EXCEL files.
• Involved in testing with the full range of web browsers across a multitude of platforms.
• Used QC to track and report system defects and bugs.
• Wrote modification requests for the bugs in the application and helped developers track these problems and resolve technical issues.
• Involved in documentation, testing and maintaining the Traceability Matrix using MS Excel.
• Coordinated the walk-through and bug review meetings for developers and QA teams.
• Involved in upgrading Quality Center 10 to ALM 11.0.

Confidential, Chicago, IL

QA Tester Engineer

Responsibilities:

• Involved in developing detailedTest Strategy, Test Plan, Test Cases and Test Proceduresusing ALM for functional and regression testing.
• Performed regression testing, integration testing and documented results usingQC/ALM.
• ConductedValidationandVerificationof bug fixes.
• Extensively conducted functionality, user interface, security, and regression testing during the various phases of the development.
• DevelopedSQL queries/Unix Shell Scriptsfor data validation.
• Experience in using agile approaches, including extreme programming, test-driven development and scrum.
• Analyzed business requirements and functional specification documents and developed test strategy and test cases in HP QC/ALM.
• Created and executed detailed test plans, and verified bug fixes.
• Performed Functional, End to End, System, Regression testing and User Acceptance testing.
• Coordinated Defect Call meetings with the users.
• Communicated test status and progress of testing efforts to supervisor and project team members.
• Validated the test data in the tables by running SQL Queries.