We provide IT Staff Augmentation Services!

Qa/etl Tester Resume

3.00/5 (Submit Your Rating)

Phoenix, AZ

PROFESSIONAL SUMMARY:

  • Over 6 years of experience in Software Quality Assurance and Quality control in Healthcare, Pharmaceutical, Automobile and Banking domains following Agile, Waterfall and Rational Unified Process (RUP) methodologies.
  • Excellent understanding of Software Quality Assurance techniques and complete knowledge of the Software Development Life Cycle (SDLC).
  • Extensively involved in quality assurance, testing methodologies, specification analysis and enhancement of applications in several key technologies i.e., client server, .NET applications, data warehouse and relational databases.
  • Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web applications with HP test suite (Quick Test Professional, Quality Center/Test Director) and Manual Testing.
  • Expertise in analysis of User Requirements, Functional Specifications, Use Cases, Business Requirements and design of Test Cases, Test Scripts, Test Data.
  • Experience in developing Test strategies, Test scripts, Test cases, Test plans, Test procedures and testing standards for Various UI applications and also have good experience in testing back end functionality.
  • Good knowledge about testing life cycle including Functionality Testing, Integration Testing, GUI Testing, Performance Testing, Regression testing, User Acceptance Testing, and Back End Testing.
  • Ability to verify and troubleshoot defects using various Defect Tracking Tools.
  • Expertise in Database Testing - Data Manipulation, Database Scripting, Back-End Testing.
  • Strong skills in back end testing using SQL statements, generating reports to ensure data integrity and to validate business rules
  • Experience in ETL Logic Testing, Transformation Testing and, Source to Target Testing with the Help of Mapping Documents.
  • Strong experience in testing applications on Windows platform.
  • Proficiency in applying automated testing tools like WinRunner, LoadRunner, Quick Test Pro and test management tool like Test Director/Quality Center.
  • Extensive documentation skills and proficiency in utilizing Test Director/Quality Center as a test management and defect tracking tool.
  • Ability to embrace new tools and technologies with ease and to seamlessly integrate skill set into the project implementation lifecycle.
  • Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
  • Quick learner with quest for knowledge and excellent team player with the ability to meet tight deadlines under pressure.

TECHNICAL SKILLS:

Operating System: Windows, UNIX

Language: SQL, PL/SQL

Testing Tools: WinRunner, Quick Test Pro 6.5/8.0/9.x, LoadRunner

RDBMS: Oracle, DB2, SQL Server 2005

ETL Tools: Informatica Power Center

Defect Tracking Tools: HP Quality Center, Test Director, ClearQuest, ClearCase

Web Technologies: HTML, XML, Java Script, ASP, VB Script

Others: Toad, SQL Loader, SSMS, MS Office, QTP, SFTP Reflection, SSRS, Soup UI, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

QA/ETL Tester

Responsibilities:

  • Responsible for Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
  • Writing of high level Test Plans, Test Cases, Test Scripts, and Test Scenarios.
  • Developed Test Plans and overall Test Strategy for the applications.
  • Participated in Data Analysis.
  • Extensively tested EDI 270 and 271 for Eligibility and Coverage Inquiry and Response.
  • Extensively Tested EDI 276 and 277 for Claims status Inquiry and Response.
  • Participated in testing various interfaces (Inbound and Outbound) of Facets.
  • Involved in validation of HIPAA for 837 and 835 claims used for Professional, Institutional and Dental Claims by Writing Test cases, Test Plans.
  • Tested the COB, benefits, facilities and reports in Facets.
  • Extensively worked on Benefits application (Grids, Booklets and Summary)
  • Tested the integration of sub-systems to Facets
  • Extensively worked on EDI 834 for Benefits, Enrollment and Maintenance applications.
  • Tested the loading of Claims data into Facets.
  • Tested the conversion of Members/Subscribers and Financial Claims.
  • Tested the adjudication of Claims and Migration Process.
  • Data mocking for different Claim file formats.
  • Conducted HIPAA Gateway Testing
  • Used Informatica and tested extraction from legacy and oracle based sources.
  • Tested the source, Target databases and Transformations.
  • Validated the data in Oracle databases by writing SQL Queries in TOAD.
  • Used Informatica Workflow monitor to see the work flows running and get the session properties and session log.
  • Tested the reports generated using SSRS.
  • Test Data preparation for both Institutional and Professional Claims.
  • Scheduling of XML Batch jobs in testing environments.
  • Validated the back-end data by using SQL and Stored Procedures extensively.
  • Conducted various Batch Processing tests successfully.
  • Loaded and maintained test cases and test datasets in Quality Center.
  • Defect tracking and defect management on Quality Center for different projects.
  • Generating daily defect reports from QC and presenting in daily client meetings.
  • Developed UAT Test Summary Reports and participated in GO / NO-GO meetings.
  • Participated in regular project status meetings related to testing.

Environment: Windows NT / UNIX, EDI, HIPAA, Quality Center, HTML, Toad 8.5, TFS, Informatica Power Center, SQL Assistant, Oracle 11g, SFTP Reflection.

Confidential, Scottsdale, AZ

QA Analyst

Responsibilities:

  • Designing and delivering Test Plans, Test Cases, Test scenarios, Test Scripts.
  • Worked closely with software developers, business analysts, system admin, and other project management personnel involved in Software Development Life Cycle (SDLC).
  • Developed Integration Level Test Plan, Test Cases, Test Scenarios and Test Data according to Specifications.
  • Conducted Functional, Integration, System, Regression, Performance and User Acceptance Tests.
  • Prepared test conditions according to functionality of the application and executed them manually.
  • Created Test Data for Functional, Regression, System, Integration.
  • Tested all the applications under different Operating Systems.
  • Responsible for System, Regression, User Acceptance, Back-end and Product Testing for the new releases using Quick Test Pro (QTP).
  • Designed, developed and executed reusable and maintainable automated scripts for Regression tests.
  • Verified web objects and checked differences in the standard properties of each page.
  • Executed Test Scripts through Quality Center by invoking QTP scheduled tests both locally and on remote machines, exported test results from Quality Center.
  • Coordinating and monitoring the process of testing of defects, bugs, releases and monitoring the smooth transition of them into production.
  • Created and executed test conditions for the application to ensure all the requirements meet properly.
  • Identified software errors and interacted with developers to resolve technical issues.
  • Worked on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Maintained communications between teams. Provided input to, and answered queries from the Quality Assurance Team.
  • Used Quality Center to store all testing results, metrics, implemented Test Plan Document, created Test Cases, Defect Tracking and Reporting.
  • Executed the transactions manually and verify the back end functionalities and data exploitation.
  • Involved in developing Test Condition and Documented for further Testing.
  • Verified Web components as part of Web Testing.
  • Involved in Regression Testing for every changes in modules.
  • Carried out data validations and verified the Business Logic Implementation by constructing and executing several SQL statements.
  • Conducted functional tests and executed test cases.
  • Participated in Enhancements meeting to distinguish between Bugs and enhancements.
  • Participated in daily status calls during each release to update about the day-to-day activity and issues to Project Manager and QA Lead.
  • Motivated team towards set goals. Mentored and aided in the continuing development of team members and new trainees.
  • Proactively interacting and collaborating with Business Analysts, Technical Analysts, and developers to identify and understand the appropriate data required for testing and sharing the same among our testing team for designing the test cases and to achieve the goal within the stipulated time.
  • Delivering the status reports like testing status, defect-tracking status, and weekly status reports to the Test Manager.
  • Prepared Standard testing documentation and user manuals.
  • Involved in maintenance for Weekly/Bi-weekly Beta/Production push releases.

Environment: ASP, XML, HTML, Web Services, Soap UI, QTP, Quality Center, TOAD, SQL server, Oracle 10g Windows, UNIX, WinSCP.

Confidential, Detroit, MI

QA Tester

Responsibilities:

  • Identified and documented test requirements to assure the quality of the product using Test Director.
  • Developed test procedures, test plans and scripts.
  • Validated the user and database requirements for the system.
  • Conducted Regression, performance, volume and stress testing on Automotive Trading and Financing applications.
  • Involved in cross browser testing using Netscape Navigator and Internet Explorer for Web based applications.
  • Developed Test Plan and created Test Cases as per the business requirements in Test Plan Manager of Test Director
  • Performed Regression testing using the WinRunner tool.
  • Created test scripts using WinRunner and enhanced scripts by adding functions in TSL Script.
  • Developed Test scenarios for loan approval and validation process.
  • Inserted Synchronization points and check points in TSL scripts whenever necessary
  • Developed test scripts for Performance and data driven tests using WinRunner.
  • Measured the system, application server, web server and database server resources with the help of Load Runner online monitors. Analyzed the resource graphs.
  • Validated the interactive middleware interfaces between the VISUAL BASIC programs and the mainframe.
  • Performed automated regression testing using WinRunner throughout the project
  • Used SQL queries for Database Testing
  • Collected metrics for software defects and reported these to management using Test Director
  • Tested executable Stored Procedures and Functions on Implementation Data later on a production data simulated test environment.
  • Applying the SQL scripts to the test database and execution of the scripts on the database.
  • Responsible to Create detailed problem reports in defect tracking database of ClearQuest using SoDA.
  • Monitored ClearQuest to close the bugs/cases as and when developers fix the bugs.
  • Analyzed all the bugs in the ClearQuest reported by the users during the UAT.
  • Trained test team members in the proper use of WinRunner and Test Director
  • Interacted with client user personnel to ensure continuing adherence to requirements and user standards.

Environment: Test Director, WinRunner, LoadRunner, VB, ASP, ClearQuest, JavaScript, Oracle9i, PL/SQL, Web sphere, IBM MQ Series, TOAD, XML, Visual Source Safe, UNIX Shell Scripts, MS Access, Windows XP

Confidential, Ann Arbor, MI

QA Tester

Responsibilities:

  • Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
  • Performed Smoke Testing of the application as an entrance criteria for development builds
  • Analyzed system requirements and developed test plans, test cases for Functional, GUI and Regression testing using Test Director
  • Executed manual and automated test cases and verified results with expected results.
  • Carried out data validations using stored procedures and SQL scripts.
  • Performed database testing by passing SQL Queries to retrieve data.
  • Written SQL statements to obtain test data and test results for weekly status reports.
  • Written SQL Loader scripts to load data into Oracle tables for further processing.
  • Used Test Director to organize the TSL Scripts and developed test suites.
  • Bug tracking using Test Director and working towards resolution.
  • Responsible for System Testing, Integration testing, Data Validation and UAT.
  • Worked with software development team to find the best solution of software and GUI problems.
  • Worked extensively with Unix Shell Scripts
  • Performed Risk Analysis based on Defect Severity and Priority
  • Tested User Interface inconsistency and application functionality
  • Developed Reports and Graphs to present the Stress Test results to the management

Environment: WinRunner, Test Director, LoadRunner, PL/SQL, Visual Basic, SQL*Plus, TOAD, PVCS, Windows

Confidential

QA Analyst

Responsibilities:

  • Involved in defining, and analyzing the testing requirements based on the application functionality.
  • Gathered test data requirements for data conditioning from Business units to test total application functionality.
  • 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.
  • Used test director as a central repository for all the test activity.
  • Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
  • Responsible for writing the SQL queries to verify GUI front-end results and to extract and to manipulate the data to satisfy test cases/ requirements.
  • Tested web page presentation manually for different browser compatibility.
  • Tested broken links and inter application links in development, test, and production environments.
  • Executed test cases before and after bug fixes for each build for user acceptance testing.
  • Performed Back-end testing using TOAD.
  • Tested the application for third party vendor confirmation and client reports as per use cases.

Environment: Test Director 8.0, Win Runner, J2EE, Tomcat, HTML, UNIX Oracle and Toad

We'd love your feedback!