We provide IT Staff Augmentation Services!

Qa Tester Resume

Denton, TX

SUMMARY:

  • 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.
  • Experience includes both manual and automation testing of web based and client / server applications and Mainframe applications
  • 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.
  • Expertise in End-To-End testing
  • 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:

Testing Tools: Mercury tools ( Quality Center, Win Runner, Load Runner, Test Director) Rational Suite (Rational Clear Quest, Clear Case, Requisite pro, Test Manager) and QTP (Quick Test Professional), Microsoft Visual Studio 2010

Databases: Oracle 10g/9i/8i, SQL Server 2008/2005//7.0/6.5 , MS Access and SQL

Languages: SQL, PL/SQL, C, C++, and JAVA

Operating Systems: UNIX, Linux, Windows 95/98 and Windows NT/2000

Tools: ERWIN 4.0, Toad, Test Director 8.0, Korn Shell

Web Related: HTML, XML, Java Script, Java, Servlets, JSP, ASP, SharePoint Services

Application & Web Servers: Apache Tomcat, IIS, Web Logic, Web Sphere

Suite: Front Page '2000, MS-Office,MS Project

Data Warehousing Tools: Informatica, Business Object 6.5/XI, Loyalty CRM, SSIS and SSRS

Telecom/Energy Billing System: Atlas, CorDaptix

PROFESSIONAL EXPERIENCE:

Confidential, Denton, TX

QA Tester

Responsibilities:

  • 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.
  • Processed Orders status jobs and verified Order confirmation and Ship Confirmation emails
  • 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 .
  • Run the SSIS packages to update SKU PAV in database tables.
  • Executed MDX queries and worked on SSRS Executive Summary reports, Sales reports Monthly and Quarterly.
  • Worked closely with developers and business users to discuss defects and participated in bug scrubs / review / Status
  • 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
  • Verified pricing on the web site based on customer groups
  • Conducted Functionality testing, and Regression testing during the various phases of the development.
  • Actively participated in regular weekly status meetings and discussed about enhancements and change requests
  • Responsible in providing regular test reports to the management
  • Logging new defects and linking defects to the test steps if any test steps failed
  • Verifying the Fixed Defects and Closing the Retested Defects
  • 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.
  • 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.
  • 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, Richardson, TX

QA 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.
  • Reviewing the Business requirements, System requirements and Detailed Design Specifications.
  • Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
  • Extensively worked on Rx Claims.
  • Created the Pharmacy networks, Plans and attached Pharmacies to network.
  • Created the Account, Group and Member for Carrier and attached plan to the group.
  • Crated Benefit Pricing Profile by attaching Pharmacy networks, Pharmacy Price Schedule and Client Price Schedule.
  • Created the Drug rule based on the Preferred NDC List.
  • 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.
  • 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, Dallas, TX

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.
  • Reviewing the Business requirements, System requirements and Detailed Design Specifications.
  • Discussing Test requirements, Test Plans, Test cases in Team walk-through meetings.
  • 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.
  • 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.
  • 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, Plano, TX

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
  • Developing and executing Test cases in Mercury Test Director
  • 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.
  • 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
  • Verify the Defects after development Team resolved or fixed the defects.
  • Interacting with various development Teams, Business Analysts, and Project Leaders including QA teams.
  • Involving in setting up data and required environment for User Acceptance Testing.
  • Generated various Test Reports such as Test completion, Test execution, Defect reports.
  • 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, Confidential, Test Director, and MS-Office.

Confidential, Groton, CT

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.
  • Created in-depth reports and graphs to check where performance delay occurred: network, client, server delays, CPU performance, I/O delays, database locking.
  • Analyzed results and analyzed Oracle data base connections, Sessions, Web logic log files.
  • Actively participated in BUG meetings to resolve the defects in efficient and timely manner.
  • 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, Boston, MA

QA Tester

Responsibilities:

  • Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
  • Developing and executing Test cases in Mercury Test Director
  • 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.
  • 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, Confidential .

Confidential, Boston, MA

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, Indianapolis, IN

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.

Hire Now