SUMMARY:

• 8 + years of experience as softwareQA Analyst / Tester in Software Testing/Quality Assurance.
• Experience in testing of Client Server, Web applications, N - tier, SOA based applications and Web services using Automation tools and Manual testing methodologies.
• Expertise in complete Software Development Life Cycle (SDLC) models/frameworks using Agile Process, Waterfall, Rational Unified Process (RUP), test management and testing life cycle methodologies.
• Expertise in analysing functional and design specifications and experience in preparing Test plans, test schedules, designing and executing test cases, test matrices, document process management and maintaining check lists.
• Experienced in maintenance of Requirements Traceability Matrix .
• Expertise in conducting Functional, Integration, User Acceptance, Regression, Stress, Performance, Load, Production and System testing following best testing practices, testing strategies and Methodologies using automated testing tools and well versed with the use of defect tracking tools.
• Adept in reviewing Test Procedures, Test plans, Test Scenarios, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing.
• Maintenance and executing detailed Test scripts for User Acceptance Testing (UAT), analysing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production testing.
• Experience in writing SQL queries and PL/SQL scripts to validate the database systems and involved in data manipulation and database testing on Oracle using SQL scripts .
• Expertise in testing of Client-Server, N-Tier, Service Oriented Architecture (SOA) based applications using Automation Tools QTP, Win Runner, Quality Center, Test Director, Load runner, Selenium IDE, Selenium RC, Apache JMeter and SOAP UI.
• Expertise in developing automated regression test scripts, automating processes and Setup .
• Expertise in gathering requirements for Load Testing, developing performance test scripts, preparing the Scenarios to fulfil the project specific needs, analyse the test results and report the bottlenecks.
• Specialized in QA Methodologies, testing of software components for build/release testing and end user focused. Good exposure to six sigma quality concepts.
• Involved in gray box testing of WCF based Web services and web applications.

TECHNICAL SKILLS:

Languages: C++, C#, Java, .Net, ASP .Net, HTML, XML, Unix Shell, SQL and PL/SQL

Testing Tools: QTP, Quality Center, Rational tools, Selenium, Apache JMeter, Mercury Tools Win Runner, Test Director and Load runner, SOAP UI.

Bug reporting tools: Quality center, IBM Rational Clear Quest 6.2, Jira and Mantis.

Scripting Languages: Java Script, VBScript

Databases: Oracle 10g/11g, DB2, MS-SQL Server 2005/2008, MS - Access

Database editors: SQL Developer, TOAD, SQL*Plus, SQL Server management studio.

IDE: Eclipse 3.4/3.6, Visual Studio 2008/2010

Web Technologies: HTML, XML, XSLT, ASP.Net, Servlets, JSP, STRUTS.

Application Servers: WebSphere5.0, Web logic 8.1/10.3, IIS 5.1/7

Version Control tools: PVCS, CVS, Rational Clear case and TFS.

Operating Systems: Windows NT/2000/XP/7, UNIX and Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo grove, IL

Sr.QA Analyst

Responsibilities:

• Analyzed Business Requirements, functional requirements to prepare the Test Plan and Test Strategy.
• Verified and reviewed the web Service Specification documents, Mapping Documents and Interface Specification and prepared Test Cases and Test Scenarios.
• Analyzed the Testing Requirements to identify and create Test Data.
• Responsible for creating SOAP and RESTful web Services Test Suites based on WSDL and End Point URI’s in SOAP UI.
• Created Services, Resources and Methods (PUT, POST, GET, and DELETE) for RESTful Web Services using the End Point URI’s or WADL.
• Created Interfaces, Operations for SOAP Web services using the WSDL.
• Good understanding on creating MOCK web services.
• Automated the Test Steps in SOAP UI(Free Version) and SOAP UI(Pro) for SOAP and RESTFul services.
• Created Reusable Regression Test Suites which can be run for every Pre Production Release across CVS using SOAP UI and LISA.
• Validated Test Steps for the web services using Assertions.
• Automated the Results and populated the Data from External Sources in SOAP UI Free Version using Groovy Scripts.
• Connected to external Data source in SOAP UI Pro using Data Source and Data Sink Test Steps.
• Good understanding in XML and JSON formats used in SOAP and RESTFul web services.
• Tested Web services (SOAP and JSON Request & Response)and Orchestrated Web Services by creating test suites, test cases and test steps in SOAP UI.
• Executed the Mass Production Regression Suites using Test Utility Tool.
• Documented the Test Results and shared the Knowledge across team.
• Responsible for walkthrough of the Design Documents and provided Signoff for Test Artifacts.
• Logged defects, Tracked Requirements, Maintained Test Cases and Results using QCandALM(Application Life Cycle Management).
• Analyzed the Defect in the Data Power Logs and the IIB Logs and also in the Unix Servers.
• Validated the Test Case results by executing SQL queries in AS400, DB2, Oracle, SQL Server Databases.
• Performed Smoke testing, Functional Testing, Integration Testing, System Testing, End To End testing, Sanity Testing, Regression Testing. Provided support for the User Acceptance Testing(UAT)
• Validated Data power logs and IIB logs to check the SOAP error codes and descriptions are writing in.
• Responsible for Demonstrating the Test Results on Test Completion to all the stakeholders interested in the Project.
• Good Understanding of Medicare (Med D) Webs services and also tested and consumed them as part of CVS Web Services.
• Expert Knowledge on Retail, PBM, Specialty and Digital Services in Health Care Domain.
• Expertise in Waterfall, Iterative Incremental SDLC Models.
• Analysis and validation of DataPower and Splunk logs.
• Day to Day interaction with offshore team of 10 for the status, Issues, Clarifications and all Testing Related Activities.

environment: Java, J2EE, SOA, Web services, SOAP5.0, JSON, HTML, Splunk, Data Power Logs, Java Script, UNIX, Oracle 11g, AS/400, QC, LISA, Oracle web logic 10.3, SQL Developer.

Sr.QA Analyst

Responsibilities:

• Followed Agile Methodology (Scrum) in implementation of this Project.
• Interacted with Business Analysts, Developers and other QA team members in gathering functional requirements, analyzing business requirements and developed Test Plans and Test Cases for Testing and documented them along with the test results.
• Communicating with developers in Defects reporting and tracking them to Close.
• Wrote and executed SQL queries for testing database integrity and for data analysis.
• Used JIRA for logging, document, and tracking and escalate issuesas appropriate.
• Wrote and execute complex SQL queries and stored procedures using Rapid SQL to retrieve and to verify the data.
• Conducted Functional and Regression Testing. Tested the Interfaces and various web services using SOAP UI.
• Testedthe Web services (SOAP Request & Response files) by creating test suites, test cases and test steps in SOAP UI.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Support application deployment during off off-hours for validation testing.
• Executed all the test life cycle, documented the successful or unsuccessful completion, defects raised and each test condition.
• Performed UI testing, functional testing based on user requirements and functional specifications.
• Performed Browser Compatibility testing using different browsers like IE, Firefox and different operating systems windows and Unix.

environment: Java, J2EE, SOA, Web services, HTML, Java Script, DB2, Informatica, JIRA, RFT8, Soap UI, Oracle web logic 10.3, Rapid SQL, PVCS.

Sr.QA Analyst

Responsibilities:

• Followed Agile Methodology in implementation of this Project.
• Coordinated with business Analysts and end users in gathering functional requirements, analyzing business requirements and developed Test Plans and Test Cases for Testing and documented them along with the test results.
• Coordinating with offshore Team and communicating with developers in Defects reporting and tracking them to Close.
• Tested the Web services (SOAP Request & Response files) by creating test suites, test cases and test steps in SOAP UI.
• Performed load testing the web services using Apache JMeter.
• Executing the Performance scenarios with Data base upgrades and compare the Performance reports and Percentile Reports.
• Creating the Re-Usable Components for Automation test Cases.
• Developed and executed SQL queries for testing database integrity and for data analysis.
• Used Quality Center for defect tracking.
• Involved in testing of the XML, XSLT transformations.
• Executed different scenarios like compatibility, scalability, and load test to identify bottlenecks on every component of the system
• Wrote and execute complex sql queries and stored procedures using SQL developer to retrieve and to verify the data.
• Copying of the data in to spreadsheets to generate the results based on the existing financial engine formula and validating the web service results against the generated results.
• Developed Test Plan and overall Test Strategy.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Conducted Functional and Regression Testing. Tested the Interfaces and various web services.

Environment: Java, J2EE, SOA, Web services, HTML, JavaScript, Oracle 11g, Quality center, SOAPUI, Weblogic 10.3.2, Linux, SQL developer, TFS.

Sr.QA Analyst

Responsibilities:

• Worked as QA analyst for Application Interfaces, Forms and Core Application modules.
• Coordinated with business Analysts and end users in gathering functional requirements, Analyzing business, working on Gaps between Business requirements vs. Functional Requirements and Test cases.
• Coordinating with offshore Team and communicating with developers in Defects reporting and tracking them to Close.
• Created Test Data for testing various kinds of test Scenarios.
• Performed User Acceptance Testing (UAT) on web based applications.
• Performed Integration Testing in Vendor Development environment and System Integration Testing in SIT environment and UAT in Pre-production Environment.
• Involved in Testing Reports using SQL queries.
• Logged Defects and tracked them till Closure.
• Performed Regression Testing when the build comes with defect fixes.
• Performed Back-end testing by preparing SQL queries and testing the database records.
• Identify test cases to be run for regression testing and conduct the regression testing.
• Performed the compatibility testing with different operating systems and different Browsers.
• Used Quality Center as a defect tracker.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Extensively involved in the Backend / Database testing using SQL queries.
• Interacted with Business Analysts, Developers in offshore team and QA team members in different defect raising situations.
• Involved in performance and stress testing using JMeter.

Environment: OBIEE, ETL, .Net, ASP, WCF Web services, SOAP UI, Clear case, Quality Center, QTP, SQLserver2008, Toad, JMeter.

QA Analyst

Responsibilities:

• Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and understanding of the requirements, non-functional specifications and end-user needs.
• Prepared and executed System test cases and tested different modules and their functionality.
• Performed Functional Testing, UAT and End to End Testing.
• Efficiently performed black box testing and User Acceptance Test (UAT) to meet the end product requirements.
• Involved in writing Test plans, Test Cases, and Static reports for Integration testing (IT), User Acceptance Testing (UAT) and System Testing (ST), in accordance to the Use Case and Technical Design Specifications
• Provided weekly updates through status report.
• Conducted Regression Testing, System Testing and Integration testing internally LCS integrated With LOS.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Extensively involved in the Backend / Database testing using SQL queries.
• Interacted with Business Analysts, End Users, Developers and other QA team members in different defect raising situations.
• Used SQL and SQL joins for verification and retrieval of data from database and for testing of database integrity.
• Used Rational Clear Quest System for defect tracking and reporting, also followed up with the development team to verify defect fixes and updated defect status.
• Worked closely with Developers in resolving the issues and understanding the functionality for future reference.

Environment: Rational Clear Quest, RPT, RFT,.NET, C#, ASP .Net, Visual Studio 2008, SQL-Server 2005, XML, XSL, HTML, DHTML, MS Excel, Windows 2003.

QA Analyst.

Responsibilities:

• Analyzed software requirement specifications (SRS) to understand the business requirements and reviewed master test plan.
• Involved in developing test plan, designing the test steps, writing Test Cases and running test scripts using Test Management Tool Quality Center.
• Ran manual tests in QC and “passed” them in the “Test Lab”.
• Conducted End-to-End and Black box testing.
• Implemented Mercury Quality Center for Requirement Management, Test Design, Test Execution, Defect logging, Requirement Mapping with Test cases.
• Automated test cases using Quality Center and monitored the defect tracking process, trouble shooting and generating customized graphs and reports for the client.
• Developed Requirement Tractability Matrix (RTM) to track the requirements during the QA testing Phase using Quality Center.
• Executed all the test life cycle, documented the successful or unsuccessful completion, defects raised and each test condition in the Quality center.
• Tested the Application using SQL queries generating reports to ensure data integrity.
• Developed and tested different XML documents and Applications.
• Involved in extensive Data Validation using SQL queries.
• Wrote bug description and track bug record in Team Track.
• Verify Actual results against Expected results investigate discrepancies and report any defects in the Quality center defect mechanism.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Used SQL Queries to verify the data from the Oracle database.
• Coordinated the testing effort towards End-to-End testing to verify the proper functioning.

Environment: Quality Center, QTP, Java, J2EE, XML, HTML, JSP, JUnit, IRise, Rational Clearcase, WebLogic, Web Services, Java Script, Microsoft Visio, Oracle, SQL.

QA/SQL Tester

Responsibilities:

• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Designed and developed Test Plans and Test Cases and executed them.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Heavily interacted with database operation by writing SQL queries.
• Heavily interacted with ETL team for testing data Quality and data Validation.
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
• Work with other QA Team members to develop test strategies and test scenarios. Also help clarify specific requirements to other System Tester/s to help develop test cases.
• Extensively used PL/SQL queries to perform operations such as joinsin the databases
• Testing of records with logical delete using flags
• Created Test cases and Test scripts using QTP for Stress and Performance Testing and Descriptive Programming using VB Script.
• Conducted Back end testing using DB2 and SQL queries.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Test scripts developed in QTP and maintained in HP Quality Center
• Wrote and executed SQL queries in the TOAD and ensured Correct Data Retrieval
• Ensured that the mappings are correct
• Conducted data validation testing

Environment: Informatica 9, UNIX, Toad, SQL, PL/SQL, XML, XSLT, DB2, Quality Center, QTP, SQL Server 2008, Shell Scripting

QA Tester

Responsibilities:

• Developed test cases, test scenarios, expected results and prioritized tests.
• Extensively followed RUP methodology and involved in complete project life cycle.
• Experience working in an Items Processing Operations room, and of the workflow associated with deposits in clearing and out clearing
• Designed the data for interpreting the positive/negative Scenarios.
• Executed test Scenarios and verified actual results against expected results.
• Extensively involved in using Test Director to report bugs.
• Monitored Test Director to close the bugs as and when developers fix the bugs.
• Involved in development of Test Specifications as per Business requirements.
• Analyzed the Performance Testing Results.
• Reported the bugs using Test Director.
• Interacted with developers to report software bugs and re-tested the fixed issues.
• Deleting the target data before processing based on logical or physical primary key
• Written Test Cases for ETL to compare Source and Target database systems.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Developed regression test scripts for the application
• Involved in metrics gathering, analysis and reporting to concerned team

Environment: IMPACS, Test Director 6.0, PERL, SQL, Java, J2EE, XML, HTML, JSP, Oracle, Windows 2003, Unix.