SUMMARY:

• Around 9 years of Software Quality Assurance (QA) experience performing Manual, Automated, Functional, Regression & UAT Testing on Web and Client - server applications using leading tools & software testing techniques.
• Having experience in Performance, Automation using Load Runner.
• Having good experience in Software Automation using QTP.
• Proficient in various Defect tracking tools like Quality Center, ALM, Bugzilla, and Test Director.
• Proficient in Functional Testing tool Quick Test Professional (QTP/UFT) and the various frameworks in QTP/UFT.
• Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, and Selenium Web Driver), JUnit, Eclipse and preparation of automation test framework.
• Solid Back End and Front End Testing experience by writing and executing SQL Queries
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Having experience in White box testing methods for performance increase.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, WinSQL, PL/SQL Developer, SQL Navigator, Perl, UNIX and Korn Shell Scripting.
• Experience in using Oracle Databases and SQL Server.
• Experience in Web Service Testing.
• Proficient in writing advanced DML and DDL SQL Queries like to retrieve data from databases for Backend Testing using tools like TOAD to check and analyze data integrity and validation.
• Strong skills in Back-end testing using SQL queries, triggers and DTS tools.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Performing Functional Testing, Regression Testing, System Testing, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC). Involved in all phases of Testing Life Cycle.
• Knowledge of various software testing methodologies like waterfall, iterative and agile (Scrum).
• Good hands on experience working on functional and business work flow validation.
• Experience in Writing Test Summary Report, Preparation of Bug Severity Chart.
• Contributed in designing core testing documents like Master Test Plan, Test case design and System Test Report.
• Proficiency in Testing Client-Server and Web Applications.
• Good communication skills and interpersonal skill and consistently being organized by management and peer for producing high quality works.
• Ability to communicate effectively with onsite/offshore teams.

TECHNICAL SKILLS:

QA/Testing Tools: HP QTP/UFT, Selenium

Version Control Tools: Rational ClearCase, CVS, TFS, GitHub

RDBMS (Databases)

Oracle 11i/10g/9i/8i, MS SQL Server 2003/2005/2008, MS Access, DB2, Teradata

RDBMS Query Tools: SQL*PLUS, Query Analyzer, TOAD, Oracle SQL, SQL Navigator

Programming Languages: C, C++, Java, .Net

Scripting Languages: SQL Scripts, UNIX Shell Scripts

Web services: Soapui, Rest API Calls

Microsoft Windows Family, UNIX: Sun Solaris

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook

Defect /Project management Tools: Bugzilla, Iconnect, Rational ClearQuest, HP ALM, Jira, Rally

Other Tools: Putty, Text Pad, Compare IT, SnagIt, WinSCP, Data Flux, GS Data Generator

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr QA Analyst

Responsibilities:

• Worked with the project team to estimate user stories and define the scope for testing. Created the corresponding test strategies, test plans, and test cases as needed.
• Reviewed requirement specifications and technical design documents to provide timely and meaningful feedback in an Agile Application Development environment.
• Worked effectively within the scrum team, across scrum teams, and with other members on the product team.
• Work within established standards in the QA organization
• Create and maintain test environments and test data.
• Manage and maintain test cases in Rally based on user stories.
• Detect defects as early in the life cycle as possible.
• Troubleshoot problems, find the root cause of issues and defects. Report defects accurately in iconnect and manage any discovered defects to resolution.
• Prepare progress reports and provide other metrics to management as needed.
• Actively contribute to development and implementation of Quality Assurance best practices and in process improvements throughout the department. Work with the project team to estimate user stories and define the scope for testing. Create the corresponding test strategies, test plans, and test cases as needed.
• Work effectively and collaboratively within the scrum team, across scrum teams, and with other members on the product team.

Environment: Rally, Agile Methodologies, SharePoint, FTIS - Up Stream Application.

Confidential, NJ

Sr QA Analyst

Responsibilities:

• Worked on different modules like Document Process and Plan Holder List, GPD, Source Prep Tool etc.
• Worked on Agile scrum environment.
• Worked on Rally - Agile Management Tool.
• Wrote test cases for the user stories under Acceptance Criteria.
• Ability to craft business requirements into positive and negative functional tests.
• Extensively worked on Rally for writing test cases, execution and defect reporting.
• Tested REST API web services by ingesting requests through POSTMAN.
• Worked MongoDB queries to verify the JSON data.
• Extensively used SQL queries for back-end testing.
• Automated all REST API calls with SOAPUI, Wrote Groovy scripts. Created Automated Framework or Soapui Scripts library.
• Provided Weekly stats. HTML reports of Soapui Automation regression for each build.
• Participated in Integration of Soapui scripts with Jenkins integration tool.
• Maintained all automated scripts in GitHub repository. Worked with both GitHub shell commands and Desktop app.
• Prepared and validated test data using an internal web application.
• Regularly interacted with BA’s and Developers to discuss various problems and issues.
• Prepared weekly and monthly status reports.
• Attended daily scrum meetings, bi weekly sprint planning, demo and retrospective meetings.
• Good experience in handling multi-tasking.

Environment: POSTMAN, Rally( CA agent), Confluence, Java web services, MongoDB 0.9.0-RC8, SQL Developer 4.1.3, Ready API (SOAPUI automation), GitHub.

Confidential

Sr. QA Engineer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved throughout the business solution Software Development Life Cycle (SDLC).
• Worked with Quality center to document test results and validate test scripts.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Regression Testing & reviewed their consistency with the business requirements.
• Wrote Test Cases in MS Excel and uploaded in ALM.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Tracked and reported the bugs in Quality center.
• Tracked bugs using Quality Center/ALM and performed regression Testing of the entire application once the bugs are fixed.
• Involved in RTM Preparation.
• Extensively used Selenium webdriver for functional and regression testing.
• Create Test Cases using Element locators and Selenium WebDriver Methods.
• Enhance Test cases using Java Programming and JUnit / TestNG Annotations.
• Execution of Selenium Test cases and Reporting defects.
• Executed automation scripts on different browsers/environments & reported defects/results to the team.
• Conducting Data driven testing, cross browser testing and parallel test execution.
• Enhancing the Test Scripts for Global Execution.
• Extensively used Web-debugging tool like fire path and firebug for finding elements locator.
• Good knowledge in writing unique XPath using firebug and firepath to identify web elements.
• Generated Detailed HTML reports.
• Reviewing the Test Reports and Preparing Test Summary Report.
• Coordinated offshore and onshore team activities.

Environment: HP Quality center 11.0, Selenium Webdriver, UNIX Shell Scripts, Teradata V2R6, SQL Assistant 12.0, SQL server, PL/SQL, Rational Robot, Rational ClearQuest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational ClearCase, IBM Mainframes, Oracle 10g, SQL Plus, ASP.Net, Agile, MS Access, MS Office, XML, XML Spy, SharePoint, Jira

Confidential

QA Engineer

Responsibilities:

• Participated in sprint planning and retrospective sessions.
• Test the complicated max load used was ‘100 million data set’ includes with hundreds of tables relations and constraints.
• Also wrote many functions and procedures as a PL/SQL developer to manage large data set which in turn helped the team a lot.
• Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
• In depth knowledge of SDLC, Agile methodology and Quality Assurance methods.
• Created manual Test Cases in HP Quality Center/HP ALM for various User Stories based on Release and Sprint Plan
• Develop the Test Recommendations for each test pass and test results.
• Experience working in Windows and UNIX Environment.
• Involved in the testing of claims module and Network module of Facets.
• Worked on different modules of Facets such as Members/subscriber, commissions, provider, billing, plan and Case management.
• Used QTP to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Configured QTP with Quality Centre and Maintained the project information in Quality Center.
• Called WinRunner scripts into Quick Test Pro.
• Migrated scripts from QTP 11 to UFT 11.5
• Developed automation test framework for HPT QTP / HP UFT, SoapUI
• Used Quality Center for bug reporting.
• Wrote complex SQL scripts using joins, subqueries and correlated sub queries.
• Tested the entire data reconciliation process for multiple source and target system.
• Provided input into project plans for database projects providing timelines and resources required.
• Wrote Pl/SQL scripts for the usage in Performance testing.
• Implemented Agile Development Methodology for quick solutions.
• Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
• Escalate the issues about project requirements (software and hardware) to Project Managers.
• Preparing the metrics regarding Test progress.
• Planning and scheduling release Dates along with the Team Lead.
• Coordinated and assisted offshore team on day to day testing activities.

Environment: HP Quality Center 10.0, HP QTP 9.2, HP ALM 11.0, UFT-11.5, UNIX, Shell Scripts, TOAD, SQL server, PL/SQL, Java, J2ee, Team Track, Silk Central, Visualvm, SQL.

Confidential, TX

QA Engineer

Responsibilities:

• Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
• Provided input into project plans for database projects providing timelines and resources required.
• Utilized Quality Center for directing, tracking and outlining needs during a project SDLC.
• Wrote Pl/Sql scripts for the usage in Performance testing.
• Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
• Documented the business requirements for the developers.
• Maintained and kept track of stakeholders requests for enhancements and changes using Rational ClearQuest
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Wrote Test Cases in Quality center that would test various Test scenarios.
• Written test cases to test the application in Quality Center 10.0 and 11.0(ALM)
• Used UML notations for Object Oriented Design and Documentation.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Manually tested and GTS modules using Quality Center.
• Executed regression tests at each new build in QTP.
• Inserted Synchronization points in the script using QTP.
• Performed Data Driven Testing using QTP for testing the application for multiple data.
• Using QTP & UFT in automation testing based on waterfall mythology.
• Importing VB scripts to UFT and running test cases calling functions and procedures.
• Defect Reporting & Defect Tracking using Quality Center.
• Used SQL extensively to conduct backend testing.
• Created and added tables to SQL database when needed and extensively used SQL queries for data validation.
• Developed database tables using SQL. Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Wrote and Executed SQL Queries to ensure data accuracy for the data.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
• Performing Functionality tests, System Tests, Regression Tests, and Compatibility Tests on different versions of Web WORKS Foundation.
• Configuring the Servers (Windows and UNIX servers) with the latest builds and make it ready for the use of team as required worldwide.
• Participated in Agile iteration meetings and QA activities for all releases of the Project.
• Manage onsite and offshore resources.

Environment: HP Quality center 10.0, HP QTP 9.2, HP ALM 11.0, UFT 11.0, SQL server, PL/SQL, Oracle 10g, Java, J2ee, UNIX, Shell Scripts, TOAD, Team Track, and Silk Central, Agile, MS Office.

Confidential, Phoenix, AI

QA Engineer

Responsibilities:

• Involved in User story walk-through.
• Client interaction for queries clarification
• Designed and developed test cases for Smoke, Functional, Integration, Negative, Regression test suites.
• Reviewing the test cases and executing the same.
• Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Managed Test cases Design, Defect Tracking and Requirements traceability in HP Quality Center.
• Writing QTP Scripts and running the tests. Created and Modified automation scripts using QTP
• Tracking the results of the tests.
• Analyze and if possible fix the defects raised on the XML files as well as the database level.
• Defect tracking and logging the defect with complete details.
• Created/Maintain CR document which contains test status with the path to the CR details and understand the CR and help the team to understand the same.
• Created requirement matrix
• Participated in discussions for prioritizing work, developing time estimates and work plans and assisting team members.
• Conduct client demo along with creating documents for the same
• Helping other project teams with inputs on domain knowledge
• Created a system flow document pertaining to different modules within the project that has greatly helped the team as whole and also received client appreciation for the same.
• Created and executed SQL statements to retrieve data for testing analysis and test case validations.
• Wrote complex SQL queries to validate Target and source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Performed backend testing using SQL queries, generated the reports to ensure the data integrity and validated the business rules.
• Extensively used SQL queries for data validation.
• Created and Maintained complex SQL queries.
• Verified Test data validity with SQL queries.
• Wrote and executed SQL queries to update and extract data from the back-end databases.
• Executed functional test cases for the application.
• Wrote SQL queries for database testing.
• Performed Database testing for performance
• Worked closely with Developers and Functional Architects by following the Agile (Scrum) Methodology.

Environment: HP Quality Center 9.2, HP QTP 8.2, TOAD, Team Track, NET/Java, Rational Test Manager, SQL Developer,, Windows NT/2000, MS SQL, PL/SQL, UNIX, Manual Testing, XML, Agile, Scrum, IBM DB2, Test Director9.0/8.0, Win SQL, Test link, Bugzilla, Oracle.

Confidential

QA Tester

Responsibilities:

• Reviewed and analyzed functional requirement specifications, workflow documents, and Use Cases.
• Performed System Testing, Integration Testing, Functional and Regression Testing.
• Created Data Driven Tests to validate test scenario with different sets of data using parameterization.
• Closely worked with the Business Analyst, Developers and UI team to resolve the requirement issues, deployment issues, change management etc., during the course of the QA testing and actively participated in Review meetings and walkthroughs.
• Prepared test data to verify different types of scenarios.
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP Quick test Professional (QTP)
• Extensively used HP Quality Center as defect tracking system to log, close and generate reports and tracked through to resolution.
• Extensively involved in the Backend / Data base testing using SQL queries.
• Interacted with developers in resolving the defects found in the application during testing.
• Working closely with team members to ensure status and schedules are communicated
• Extensively performed manual testing activities using Quality Center.
• Participate in peer reviews of functional specification, application previews, and test plans/test cases.
• Create and execute SQL queries to fetch data from Oracle database to validate Data.
• Interacted with business analysts and developers to resolve the technical issues so as to meet the client’s requirement for a better quality software product.

Environment: HP Quality Center 9.0, MS SQL, Oracle 10g, TOAD, HTML, XML, Windows. SQL Server