We provide IT Staff Augmentation Services!

Sr Qa/ Etl Tester Resume

Warren, NJ

SUMMARY

  • 7 years of diversified experience as a Quality Assurance Engineer in QA testing of various Application Systems using both Automated and Manual testing techniques.
  • Extensive experience in all phases of Software Development Life Cycle (SDLC)
  • Documenting and Reviewing Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) and coordinating with developers in writing Test Plans and formulate Test Cases
  • Verifying code fixes and coordinating testing efforts with peers and QA Lead.
  • Good Knowledge in design, development and testing of applications in AIX, UNIX, Linux and Windows environments.
  • Working knowledge of ETL tool Ab Initio.
  • Experience working with Agile, RUP, Scrum, Waterfall testing methodologies
  • Have extensive knowledge of building test frameworks for n - Tier Architectures and Object Oriented Applications.
  • Proficient in the developing scripts using Win runner and Load Runner for mainframe and client server application testing.
  • Proven experience with Manual and Automated Testing Tools such as Win Runner, Mercury Quality Center, Test Director, Load Runner, Quick Test Pro.
  • Proficient in backend testing with using Oracle & SQL on Windows operating systems.
  • Extensive experience in different architectural applications such as Web (N-Tier) and Client/ Server (2-Tier) Applications.
  • Extensive experience in functional testing, unit testing, integration testing, regression testing, black box testing, white box testing, GUI testing, back-end testing, browser compatibility testing, in different stages of Software Development Life Cycle (SDLC).
  • Exceptional Analytical, Programming and Debugging Skills.
  • Hands on experience in writing test plans, test cases, developing and maintaining test scripts.
  • Experience working with open source testing tools and technologies
  • Excellent Communication and Leadership skills. Self-motivated, quick learner.

TECHNICAL SKILLS

Technologies: XML, XSL/XSLT, UML, Hibernate, SQL, SOA and Web Services

Project Methodologies: Agile, RUP, Scrum, Waterfall

Testing and bug tracking: Mercury Quality Center, Quick Test Pro, Test Director, Load Runner, Bugzilla, SoapUI, SOAP Scope, Clear Case, Clear Quest, and JIRA, Autosys

Scripting Languages: VBScript, Shell Script, JavaScript

Databases: Oracle 10g, Oracle 8i/9i, MS SQL Server, MySQL and MS Access

Web Servers: Apache, IIS

Operating System: Linux/Unix, Solaris, Windows NT/XP/server 2003

ETL TOOL: SSIS, Ab Intio(GDE1.15 Co>op 2.15)

PROFESSIONAL EXPERIENCE

Confidential, Warren NJ

Sr QA/ ETL tester

Responsibilities:

  • Reviewed System Requirement Specification documents, Functional Specifications forpreparing the Test Plan and Test Case development.
  • Involved in the complete QA Lifecycle activities like Pre-testing phase, acceptance testing phase and testing phase.
  • Analyzed system requirements, developed and executed detailed Test plan, Test cases, and Test data for testing the functionality, GUI, security, and usability of the application. Assigned priority for several test cases.
  • Identified the GUI objects of the application, mapped the custom objects to the standard objects, where necessary, and inserted GUI, Bitmap and Text checkpoints, where needed, for regression testing using Quick Test Pro.
  • Developed and executed test cases for functional, application, regression and integration testing for various modules and maintained documentation of test results.
  • Coordinated and managed testing activities as per the Agile methodology followed by project team members
  • Performed Database Testing to validate database using TOAD, Checked Data Integrity and Constraints by SQL Queries.
  • Performed ETL Testing to reconcile source files with and target GOLD
  • Performed ETL Testing to reconcile the existing futures DB system with GOLD
  • Designed and executed 2000 plus test cases.
  • Created 50 plus defects with thorough testing of the ETL process.
  • Documented complex steps in performing tasks in navigating the user interface and attach files during bug submission.
  • Wrote several SQL queries for testing data integrity on the backend and Used UNIX commands for finding bugs
  • Coordinated and participated on Execution of UAT with BA and selected business users.

Environment: Ab Intio, Mercury Quality center, Windows-XP, HTML, Java Script, Sybase IQ, Sybase Central 6,LINUX,Autosys, QTP

Confidential, IL

QA Analyst

Responsibilities:

  • Reviewed System Requirement Specification documents, Functional Specifications forpreparing the Test Plan and Test Case development.
  • Developed and executed test cases for functional, application, regression and integration testing for various modules and maintained documentation of test results.
  • Developed QA Test Plan and test cases based on the business specifications requirements and user requirements as specified in Quality Center by the BA team.
  • Associated requirements to one or more test cases using the Test Manager and analyzed the end to end functionality by testing the application manually.
  • Documented test cases, performed Manual Testing and Added, Reviewed and Traced defects till completion using Quality Center
  • Automation of test scripts using Quick Test Pro for the data driven testing.
  • Detecting Bugs & classifying them based on the Severity.
  • Manually performed integration, system testing and executed regression testing to identify errors in each modified build in the process of testing.
  • Performed Sanity and smoke testing at the initial stages of the build
  • Involved in preparation of Requirement Traceability Matrix.
  • Participated in Defect analysis & Client meetings and prepared weekly status report
  • Test Cases to test the backend Database by retrieving the data from tables using T-SQL
  • Conducted and coordinated user acceptance testing and performed Confidential analysis to compare the actual and expected results of the test
  • Maintained all the documents which we require for internal as well as external audit for SEI CMM level 5
  • Understanding business requirement and explain specifications to developers.
  • Identify user solution needs and translate them into functional requirements

Environment: Informatica,Ab intio,Mercury Quality center, QTP, Windows-XP, HTML, Java Script, .Net, SQL server 2008 R2, TFS, ASP.net, QTP, SSIS.

Confidential, Philadelphia

Manual Tester

Responsibilities:

  • Analysis of Business and Requirement Specifications. Designing Test Lab and formulation of Test
  • Strategy, Test Plans and Test Cases in TestDirector for the Functional, Integration, End-to-End,
  • Usability, Security, Regression and Smoke testing.
  • Wrote test plans for positive and negative scenarios for functional, GUI and security testing
  • Wrote SQL queries to validate the database and extract data
  • Developed QA Test Plan and test cases based on the business specifications requirements and user requirements as specified in TestDirector by the BA team.
  • Associated requirements to one or more test cases using the Test Manager and analyzed the end to end functionality by testing the application manually.
  • Documented test cases, performed Manual Testing and Added, Reviewed and Traced defects till completion using TestDirector
  • Automation of test scripts using QuickTestPro for the data driven testing.
  • Installed and configured TestDirector, QuickTestPro and LoadRunner tools for automated functionality and performance testing.
  • Prepared test data for the entrance and exit criteria in integration testing
  • Back-End Sybase Database verification manually and using QuickTestPro to automatically verify
  • Database with the values entered during automated testing by inserting Runtime Record Database
  • Created Bitmap check points to ensure the functionality of viewing checks images worked correctly
  • Performed Data Driven Testing using Data Files to test the scripts and to verify functionalities of the
  • Determine test strategies based on requirements and architecture, create
  • Provided management and vendor with analysis reports and recommendations, which resulted in a redesign of the architecture by the vendor.
  • Performed regression testing for incremental versions of the application using LoadRunner
  • Executed Performance Tests using Load Runner.
  • Generated Vuser script to emulate real user behavior and created and executed different Scenarios for the
  • Used Correlation to parameterize dynamically changing parameters.
  • Carried out stress testing by introducing rendezvous points in the script.
  • Conducted Performance testing by creating virtual users and Scenarios using Load Runner.
  • Analyzed various graphs generated by LoadRunner Analyzer and communicated problems to the System
  • Administrators to tune the application.
  • Maintained the “BUG” reports for internal evaluation of the product using Rational Test Manager
  • Upgraded and maintained QA databases and automation scripts.

Environment: J2EE, UDB DB2, QTP, Load Runner, Mercury Quality center

Confidential, VA

Manual Tester

Responsibilities:

  • Complete knowledge of Life-Cycle Development including Requirements, Analysis/Design, Development and Testing.
  • Extremely experienced in Devising and Implementing Software Testing Methodologies.
  • Involved in all phases of the testing process which includes Test planning, Test development, GUI and load testing, Defect tracking, and Client load testing for multi-user systems confirming the quality standards.
  • Specialization includes Performance testing, Functionality Testing, Regression Testing, GUI Interface, Integration/System Testing, User acceptance testing on both Web and Client/Server based applications.
  • Created databases for manual and automated tests, built test cycles, executed tests, and tracked and reported defects using Test Director.
  • Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.
  • Experienced in backend testing process involving various data retrieving queries, views, PL/SQL stored procedures for systems using Oracle database

Environment: Microsoft Windows 2000, VB, HTML, XML, ASP, Oracle, Test Director, Win Runner and Load Runner.

Confidential

Manual Tester

Responsibilities:

  • Reviewed, executed and maintained Test Plans and Test Cases for various internet services
  • Facilitated meetings to determine validity and priority of issues found within products both internally as well as reproduce issues logged through Technical Support
  • Evaluated and analyzed the product specification and functionality of Web based application
  • Managed Quality Assurance assets using Test Director
  • Primarily involved in Functionality Testing on HTML Pages.
  • Constructed and executed numerous SQL queries and verified the data integrity and quality.
  • Prepared defect reports using Test Director for walkthrough sessions to help promote the application

Environment: Windows NT/XP, JAVA, HTML, VBScript, SQL, ORACLE, TOAD, Test Director, MS-Word, MS-Excel.

Hire Now