SUMMARY

• Over 7 Years of diverse experience as a Quality Assurance (QA) Analyst in Financial/ Mortgage, Insurance, and Banking Sector. Familiar with automation tools like QC, HP ALM, Winrunner, LoadRunner ETC
• Performed Manual and Automated Testing of applications on Client/Server as well as Web - based Application
• Strong experience in developing testing strategies under different Software Development Life Cycles (SDLC) environment such as Agile (SCRUM), Waterfall, RUP
• Valuable experience in reviewing Business Analysis deliverables like Business Requirements Document (BRD), Functional Specifications Document (FSD), Use Cases, Business Rules, and Data Specifications Document to scope out the testing objectives, testing scenarios and testing timelines
• Strong working experience in implementing End-to-End Testing Lifecycle (STLC): Requirement Analysis, Test Planning, Test case Development, Environment Setup, Test Execution, Test Cycle Closure
• Proven expertise in software testing for quality assurance process - creating Test Plan; Test Scenario; Test Cases; Defect Tracking
• Significant experience in formulating Test Cases Document capturing different scenarios, action steps, and expected results, after thoroughly inspecting end users needs and several use cases
• Extensive experience in all level of testing such as Positive testing, Negative testing, Stress testing, functional testing, Compatibility testing, Regression testing, Integration testing, Smoke testing, User Acceptance testing(UAT), System testing, Performance testing and Back-end testing
• Proficient in managing defect tracking lifecycle - logging defects, prioritization, estimation, follow-ups, and generating summary reports using Test Director/Quality Center, BugZilla, JIRA
• Hands-on experience in creating SQL/PLSQL for data validation and data analysis on RDBMS such as Oracle, MS SQL Server, MS Access
• Hands-on experience in database testing to confirm database as per Entity Relationship (ER) model - verifying entities, relationships, integrity rules, database constraints
• Profound knowledge of Web Services testing using Service Oriented Architecture (SOA) Test and SOAP UI
• Well versed with managing offshore QA team and coordinating with development team throughout the application testing phase to ensure a defect-free product
• Strong analytical, troubleshooting skills with the ability to quickly learn new technologies and meet stringent deadlines
• Worked closely with the development team and Business Analyst for change management

TECHNICAL SKILLS

Defect Tracking Tools: IBM RQM,, Quality center, HP ALM, Mercury Test Director, BugZilla, JIRA

Operating System: Windows NT/2000/2003/XP/Vista/7, UNIX

Databases: Oracle, MS SQL Server, DB2, MS Access

Programming Languages: .NET, C#, HTML,XML, PL/SQL, Java script, VBScript

ETL Tools: InformaticaPower Center, Autosys

Other Tools: Snagit, UltraEdit, Crystal Report, SharePoint, Putty, Ms Office, MS Project, MS Visio, AtTask,, PULSE, Wilma, Letters2.0

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. QA Analyst

Responsibilities:

• Analyzed requirement specification document and use cases for developing Test Plan which includes the Objective, Scope, Testing strategy and others.
• Functional testing, database testing for the new requirement and enhancements in the system on various modules.
• Regression and Integration testing based upon the functional enhancements
• Developing test plan and test strategy. Update regression test suite based upon new enhancements.
• User acceptance testing for the final deliverables
• Writing Test Cases, Executing Test Cases and generating Test Results to validate the functionality of the Application in HP ALM
• Worked on SSRS to generate the reports with my MSBI (SQL and Data warehouse) developers.
• Assisted data entry and verification by doing SQL injections during Manual Test execution to reduce human error
• Performed Functional, Regression, System, Security, Database Testing. Created and tested scenarios using positive and negative test data.
• Did SQL injection, SQL validation, Database testing, Performed high SQL operation to verify data.
• Investigated Software Bugs and interacted with Developers including database developers to resolve Technical issues through HP ALM
• Actively Conducted Test Team meetings with fellow Test Engineers and other groups for reviewing the issues.
• Bugs Reported were evaluated in bug triage meetings to evaluate the progress and performance of the project
• Coordinating with project team personnel in achieving project goals through status meetings, weekly updates and tracking the defects
• Write and configured the requirements into the system. Write the various coverage formula and validations like age, commission, premium, tolerance into the system.

Environment: Windows NT/XP, SQL Server, .Net, SQL, LoadRunner, Java Script, HP ALM

Confidential, OH

QA Analyst

Responsibilities:

• Extensively worked in Agile SCRUM environment, with Actively involved in daily scrum meeting, sprint planning meeting and retrospective meeting
• Executed test cases/procedures and accurately and concisely report both progress and defect status, including gathering and reporting on project quality metrics
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Pro-actively worked with Development and Support staff in problem analysis, reproduction, and resolution
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in MS SQL Server management studio
• Wrote SQL queries to validate that actual test results match with expected results check the naming standards, data integrity and referential integrity
• Validated data in source and target databases using SQL scripts
• Involved in integration testing for comparing the results from source data to the target data
• Performed Functional, Regression, System, Security, Database Testing. Created and tested scenarios using positive and negative test data.
• Investigated Software Bugs and interacted with Developers to resolve Technical issues
• Experience in testing XML files and validating the data loaded to staging tables
• Investigated Software Bugs and interacted with Developers to resolve Technical issues
• Facilitated defects review meeting, JAD sessions, status meetings, and created periodic progress reports for development team, QA team, PMO team, and business team

Environment: IBM RQM, UNIX, PULSE, HP ALM, SQL Server Management Studio, LoadRunner, Putty, XML, Crystal Report, Snagit, UltraEdit, Wilma, Letters2.0, SharePoint, MS Office Suite, Windows 7, DINO, At Task, .Net

Confidential, TX

QA Analyst

Responsibilities:

• Analyzed business requirements, functional specifications, and use cases to understand the application functionalities and determine the testing objectives, timelines, and scope
• Analyzed user requirements by interactive with business users, developers and business analyst
• Responsible for documenting Test plan/ Test cases/ Test scripts as per Business rules for each release
• Coordinated with offshore QA team in test planning, test designing, test development, test execution, and test evaluation
• Involved in developing Entry & Exit criteria and defined the pass and fail standards
• Conducted Functional testing, Integration testing, System testing, GUI testing, performance testing, Regression testing, Compatibility testing,
• Conducted sanity testing for each new build delivered
• Generated SQL queries to retrieve data from database for conducting back-end testing, data validation, and data analysis
• Designed test plan and test cases and generated test scripts to perform System testing
• Managed the Defect Tracking lifecycle using HP Quality Center - documenting defects, maintaining test metrics, generating status reports and following test schedules
• Identified defects, logged defects and re-tested the fixed ones using the Defect tab in QC
• Documented the bug report and categorized them based on severity and generated summary report
• Interacted & coordinated with development team to fix different bugs/defects
• Conducted Change Requirements Meetings and maintained Change Request Documents
• Created daily progress report for the team and performed formal defects review meeting
• Comprehensively contributed in User-Acceptance Testing (UAT) by closely assisting business users/ developers
• Involved in Daily/Weekly Project status Meetings

Environment: HP Quality Center, Selenium, Java Script, Oracle, Windows, JAVA, J2EE, HTML, XML, MS Visio, MS Office Suite

Confidential, NY

QA Analyst

Responsibilities:

• Followed and applied Agile methodology for application development process
• Participated in analysis of the requirements, functional specification, and use case specifications of reporting and data warehouse development; thereafter converted them into Test Cases
• Implemented complete testing lifecycle - Test Planning, Test Designing, Test Development, Test Execution, and Test Evaluation for quality assurance process
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix according to requirements
• Conducted Sanity Testing, Integration Testing, Functional Testing, Regression Testing, System Testing, Integration Testing and Performance testing
• Performed GUI testing for data entry screens
• Defects were identified and classified based on Severity and Priority
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Worked with Unix Shell Scripts for loading test data
• Detected, Tracked and Reported bugs using Quality Center
• Created and executed automated test scripts using automation Mercury Testing Tool QTP
• Interacted with Business Analysts, Developers, and QA team members in different defect raising situations

Environment: QC, QTP, Windows XP/2000, HTML, JAVA, Load runner, Oracle, MS Project, UML, MS Office, Informatica

Confidential, Atlanta, GA

Jr. QA Analyst

Responsibilities:

• Analyzed user requirements and design documents to test software from a system perspective.
• Reviewed existing interface design and recommended a number of modifications that would assure data integrity.
• Involved in creating test plans, test templates and test cases and conditions for manual and automated testing.
• Generated Test Reports and graphs to assist in analyzing test plan data performing regression testing and confidence testing of applications.
• Involved in all QA testing process by following organization standard methodology
• Established connections between the application and the eID verifier (Electronic Identification Verifier) and Mainframe database
• Wrote and tested complex SQL (DDL, DML and DCL) queries for back end validations.
• Identified test scenarios and prepared test data for Functional and System testing.
• Facilitated formal review meetings with users and developers to report, demonstrate, prioritize, and suggest resolution to issues discovered during testing life cycle
• Created and maintained the defects using Jira defect tracking tool.
• Prepared the test data for the User Acceptance Testing (UAT).
• Tested functionality, alignments, and broken links using various instances
• Tested applications on different servers in development, staging and production Environments.
• Authored and updated test plans and test cases.
• Performed system testing with configuration changes for required specifications.
• Tested whole application to make sure with the free flow of application.
• Reported detailed software problem reports, defect tracking and verifying Corrections using Jira
• Involved in decision making with development, design and management teams
• Interacted with Business Analysts, Developers, and QA team members in different defect raising situations

Environment: Jira, Windows XP/2000, HTML, JAVA, Load runner, Oracle, MS Project, UML, MS Office