Summary

• Expertise in End-To-End testing
• Experience includes both manual and automation testing of web based and client / server applications and Mainframe applications
• Over 7 years of professional experience in Quality Assurance, Software Development Life Cycle SDLC analysis, design and development of Test Strategy, Test Plans and Test Cases with an emphasis on testing complex Real processing applications with multiple Interfaces, Data warehouse, Data Conversions, Client Server and on o/s Unix, Windows 95/98/2000/XP.
• Industry experience includes Retail, HealthCare, Telecommunications, Pharmaceuticals, Insurance, Banking and Financial
• Experience in System Testing, Integration Testing, and End-to-End testing of complex multiple Interfaces, Black Box Testing, White Box Testing, Regression Testing and User Acceptance testing UAT.
• Extensively worked on SKU Testing, Atlas and CorDaptix Billing Systems.
• Extensively worked on SKU's with different Vendors / Product line and Category
• Experience in Review Business / Functional Requirements.
• Proficient in manual testing, E-Commerce Web testing, and database migration testing, ETL BI Testing.
• Proficient in Writing, Updating, Reviewing and Executing the Test Cases to test the entire application functionality against requirement specifications
• Expertise in conducting User interface, Usability, Functional, Black box, Performance, Regression, Sanity, Smoke and User acceptance testing.
• Strong ability in communicating with various Project Development Teams, able to prioritize workload and able to work concurrently on multiple projects.
• Experience in RDBMS and writing complex SQL Queries.
• Proficient in working with PL/SQL including Procedures, Functions, Cursors and Packages.
• Expertise in Front-end and Back-end testing of Java, .Net, Data Warehousing applications and Business Intelligence.
• Experience in Web Application Servers like Tomcat, Web Sphere and Web Logic
• Experienced in executing shell scripts developed in UNIX
• Involved in testing Java, J2EE, Informatica, Business Objects, Oracle and PL/SQL.

Technical Skills:

Professional Experience:

Confidential

QA Tester

Responsibilities:

• Conducted Functionality testing, and Regression testing during the various phases of the development.
• Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.
• Verifying the Fixed Defects and Closing the Retested Defects
• Logging new defects and linking defects to the test steps if any test steps failed
• Actively participated in regular weekly status meetings and discussed about enhancements and change requests
• Verified pricing on the web site based on customer groups
• On the web site register as a new customer with multiple cards BCC, PRO and School card and verified correct information is sent to loyalty database and Business manager on the save
• Worked closely with developers and business users to discuss defects and participated in bug scrubs / review / Status
• Executed MDX queries and worked on SSRS Executive Summary reports, Sales reports Monthly and Quarterly.
• Run the SSIS packages to update SKU PAV in database tables.
• Processed Orders status jobs and verified Order confirmation and Ship Confirmation emails
• Reviewing the Business requirements, System requirements and Detailed Design Specifications.
• Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
• Write the SQL queries to verify SKU's with Regular, Discount model and Sale Price displayed on website along with Shipping Chargers based on Zones and DSC.
• Apply the Terms Code which decides the method of payment as credit card / on account on the web to place an order.
• Set up the consolidations on existing/available accounts and created master logins.
• For an Ecommerce web site as an Admin set up the new Portal Company with approved Vendors / Product line / Category / SKUs along with valid Banners .
• Conducted Functionality testing, and Regression testing during the various phases of the development.
• Responsible in providing regular test reports to the management
• Involving in setting up test data and required environment for User Acceptance Testing.
• Generated various Test Reports such as Test completion, Test execution, and Defect reports etc
• Tracked the defects and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status.
• Excellent communication skills, analytical skills, understand business requirements in various domains, Self-learning ability and leadership quality.

Environment: Microsoft Visual Studio 2010 Test Manager , MS-SQL Server 2008, SSIS, SSRS, Business Manager, Windows 7, MS-Office, SharePoint Services, AS/400.

Confidential

QA Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status.
• Tracked the defects and generated defect summary reports.
• Generated various Test Reports such as Test completion, Test execution, and Defect reports etc
• Involving in setting up test data and required environment for User Acceptance Testing.
• Responsible in providing regular test reports to the management
• Conducted Functionality testing, and Regression testing during the various phases of the development.
• Created the Drug rule based on the Preferred NDC List.
• Crated Benefit Pricing Profile by attaching Pharmacy networks, Pharmacy Price Schedule and Client Price Schedule.
• Created the Account, Group and Member for Carrier and attached plan to the group.
• Created the Pharmacy networks, Plans and attached Pharmacies to network.
• Extensively worked on Rx Claims.
• Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
• Reviewing the Business requirements, System requirements and Detailed Design Specifications.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios and Traceability Matrix.
• Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.
• Conducted Functionality testing, and Regression testing during the various phases of the development.
• Extensively involved in Data imports and exports across databases
• Validating all Data extractions, Data transformations and Data Integrity process.
• Executing SQL and UNIX scripts for validating Business Rules and verifying accuracy of data.
• Excellent communication skills, analytical skills, understand business requirements in various domains, Self-learning ability and leadership quality.

Environment: AS/400, Windows 2000, MS-Office, Test Director, TOAD, Oracle and SQL Server 2008.

Confidential

UAT Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios and Traceability Matrix.
• Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
• Reviewing the Business requirements, System requirements and Detailed Design Specifications.
• Test Cases were designed based on Use-Cases and Requirements in Test Director.
• Maintained requirements in Test Director and requirements are traced to Test Cases in Test Director.
• Responsible in providing regular test reports to the management.
• Tracked and Reported Defects using Test Director.
• Extensively worked on Billing Systems Atlas and Cordaptix Move In and Move Out, SWAPS, Run billing Jobs, Run Format Jobs, etc.
• Comparing Different Rate plans using Atlas and CorDaptix.
• Executing SQL and UNIX scripts for validating Business Rules and verifying accuracy of data
• Comparing the different rate plans into the CDX and Atlas.
• Generated various Test Reports such as Test completion, Test execution, Defect reports, Requirements traceability metrics etc.
• Involving in setting up data and required environment for User Acceptance Testing.
• Involved in Test Data preparation for System and Integration Testing
• Involved in Database Testing by creating SQL queries
• Involved in the preparation of Test plan document.
• Prepared traceability matrix to map the test cases to requirements.
• Tracked the defects and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status.

Environment: Oracle 10g, Test Director, TOAD, AS/400, Windows 2000, Atlas, Cordaptix, Siebel CRM.

Confidential

UAT Tester

Responsibilities:

• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing in Software Development Life Cycle SDLC .
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix.
• Test Cases were designed based on Use-Cases and Requirements in Test Director.
• Maintained requirements in Test Director and requirements are traced to Test Cases in Test Director.
• Conducted Functional Testing, Usability Testing, Server Side Interface Testing
• Business Logic Testing and Regression Testing
• System Integration Testing and System Testing
• Executing SQL and UNIX scripts for validating Business Rules and verifying accuracy of data.
• Validating all Data extractions, Data transformations and Data Integrity process.
• Extensively involved in Data imports and exports across databases
• Developing and executing Test cases in Mercury Test Director
• Responsible in providing regular test reports to the management.
• Tracked and Reported Defects using Test Director.
• Developed Unix Shell Scripts to automate tasks.
• Validated the mapping and integrity of data populated in the database using SQL queries.
• Worked extensively with complex mappings using expressions, aggregators, filters, joiner, lookup, rank, sequence generator and procedures to develop and feed Data Marts
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Developed UAT Test scripts and created test data for UAT.
• Prepared Test data for system testing
• Generated various Test Reports such as Test completion, Test execution, Defect reports.
• Involving in setting up data and required environment for User Acceptance Testing.
• Interacting with various development Teams, Business Analysts, and Project Leaders including QA teams.
• Verify the Defects after development Team resolved or fixed the defects.
• Tracked the defects and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status.

Environment: Informatica, Oracle 10g, SQL Server 2005, TOAD,UNIX, Windows 2000, CVS, Test Director, and MS-Office.

Confidential

QA Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Defined the test criteria and project schedules, and the Test Plan with the help of project meetings, walkthroughs.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Involved in System/Integration Testing, End-to-End Testing and Regression Testing.
• Developed Test Strategy, prepared Track Sheets to keep track of the tasks assigned to the Jr. Testers, and resolved issues.
• Actively participated in BUG meetings to resolve the defects in efficient and timely manner.
• Analyzed results and analyzed Oracle data base connections, Sessions, Web logic log files.
• Created in-depth reports and graphs to check where performance delay occurred: network, client, server delays, CPU performance, I/O delays, database locking.
• Assured that all QA Artifacts are in compliance with corporate QA Policies and guidelines.
• Used Test Director to detect defects, communicate to the developers and tracking the defects.
• Coordinated and communicated the whole QA effort by effectively working with different teams.

• Generating, Analyzing and interpreting the reports post the performance test execution
• Involving in setting up data and required environment for User Acceptance Testing.
• Generated various Test Reports such as Test completion, Test execution, Defect reports, Requirements traceability metrics etc

Environment: Informatica, Oracle 10g/9i, SQL Server, Sybase, TOAD, SQL Database Query tool, AIX/ UNIX, Windows NT 4.0, Windows 2000, VSS, Quick Test and Test Director, MS-Office.

Confidential

QA Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Executing SQL and UNIX scripts for validating Business Rules and verifying accuracy of data.
• Validating all Data extractions, Data transformations and Data Integrity process.
• Extensively involved in Data imports and exports across databases
• Developing and executing Test cases in Mercury Test Director
• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing in Software Development Life Cycle SDLC .
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix.
• Developed UAT Test scripts and created test data for UAT.
• Test Cases were designed based on Use-Cases and Requirements in Test Director.
• Maintained requirements in Test Director and requirements are traced to Test Cases in Test Director.
• Conducted Functional Testing, Usability Testing, Server Side Interface Testing
• Business Logic Testing and Regression Testing
• Tracked and Reported Defects using Test Director.
• Developed Unix Shell Scripts to automate tasks.
• Validated the mapping and integrity of data populated in the database using SQL queries.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Prepared Test data for system testing
• Verify the Defects after development Team resolved or fixed the defects.
• Tracked the defects and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status.

Environment: Java, Java Beans, Servlets, XML, Web Logic, Windows 2000/XP, UNIX, Win Runner, Load Runner, Test Director, SQL server, CVS.

Confidential

QA Tester

Responsibilities:

• Involved in preparing Test Plan and Test Cases based on functional requirements.
• Conducted Test Plan walkthroughs and meetings.
• Created test scenarios for System testing and Regression testing.
• Prepared Test Plans, Test Cases for both positive and negative scenarios and mapped the same to requirements.
• Executed test scripts and analyzed the test results.
• Track defects and attended meetings with developers in resolving the defects update the status of bugs once they are fixed.
• Participate in all meetings planned for particular release and obtain necessary technical automation requirement. Such meetings includes, design review, test execution timeline etc.
• Good experience in Test Planning, Functionality testing, System Testing, Regression testing, and Defect Management.
• Used TOAD for accessing the Data base tables
• Responsible for updating the status to Client on daily basis with the entire Test results.

Environment: UNIX, Windows 2000, Oracle9i, Web/Application Server, Java, J2EE, HTML, JavaScript, Rational Test Manager, Clear Quest, MS Project, Internet Explorer and Netscape.

Confidential

QA Tester

Responsibilities:

• Prepared detailed Test Plan and Test Cases by understanding the business logic and user requirements
• Managed requirements using Test Director.
• Interacted with System Analysts to enhance Test Plan and Test Scenarios in Test Director.
• Manually tested the Extensions in the application.
• Created Test Plans and Test Cases for application under test AUT .
• Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.
• Conducted Functionality testing, and Regression testing during the various phases of the development.
• Set-Up and executed test scenarios for the Regression testing as and when new builds were rolled-in.
• Preparing the Test Plans, Test cases and Test Scripts from the requirements and from Use cases.
• Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
• Involved in System/Integration Testing, End-to-End Testing and Regression Testing.
• Developing and executing Test cases in Mercury Test Director.
• Extensively involved in Data imports and exports across databases and FTP files.
• Validating all Data extractions, Data transformations and Data Integrity process.
• Build test scenarios and test cases negative / positive to validate expected outcome
• Implement tests and document results

Environment Java, Java Beans, Servlets, XML, Web Logic, Windows 2000/XP, UNIX, Win Runner, Load Runner, Test Director, SQL server, Visual Source Safe.