We provide IT Staff Augmentation Services!

Quality Analyst\ Etl\data Warehouse Tester Resume

0/5 (Submit Your Rating)

West Palm Beach, FL

SUMMARY

  • Around 8 years of experience in IT with emphasis on Software Quality Assurance.
  • Extensive software testing exposure of stand - alone, client-server and web based applications.
  • Experience in Mortgage, Trading, Insurance, Banking, Network Management Systems and Healthcare.
  • Experienced in manual and automated testing using Mercury Testing tools like Quality Center, Test Director, Quick Test Professional, WinRunner and LoadRunner.
  • Proficient with methodologies that ensure good Quality Control as per the Business requirements.
  • Expertise in performing requirement Analysis and preparing Used Cases.
  • Experience in writing and developing the Test Plans, defining Test cases of the given Requirements.
  • Experience in planning the Test Strategy as per Functional Specifications.
  • Experience in creating, modifying and enhancing both manual test scripts and test scripts Created by automation tools - Quick test professional, WinRunner, LoadRunner.
  • Experience in performing Back end testing by writing and executing SQL queries.
  • Analyzed Modification Requests (MR) and Enhancement Requests (ER).
  • Expertise in Bug Reporting, Tracking and Documentation using Test Director.
  • Excellent understanding of entire SDLC including the Waterfall, RUP, AGILE and Spiral Models.
  • Ability to identify tasks which require automation and automate test cases.
  • GUI testing, functionality testing, compatibility testing, and Back end testing.
  • Specialized in Unix Commands, Complex database Queries, SQL and ANSI SQL Syntaxes SQL procedures, Functions and packages.
  • Expertise in conducting Smoke, Functional, Regression, Integration, Database, System and User Acceptance Testing.
  • Architect and implement Agile testing practices for globally distributed teams
  • Experience in interacting with Business Analysts, Developers and Technical support to help them base line the requirement specification.
  • Excellent communication, issue finding, solving and learning skills.

TECHNICAL SKILLS

Testing Tools: Quick Test Professional (QTP), WinRunner, TestDirector, Quality Center, LoadRunner, Rational Clear Quest, Rational Test Manager

Programming Languages: C, C++, Java, SQL, Visual Basic 6.0, and COBOL.

Scripting Languages: JavaScript, VBScript and TSL.

Databases: Oracle, Sybase, MySQL, SQL Server and MS Access.

OS/Platforms: Windows NT, Sun Solaris, HP-UX, Unix/Linux

Packages: MS Word, MS Excel and MS Power point.

GUI / Application Servers: AWT/Applets/SWING, VB.NET, ASP.NET,C#, and Developer 2000, Toad, CuteFTP, Eclipse,JBoss,Tomcat,Websphere

Web Tech /Frame Works: HTML, DHTML, Ajax, XML, JSP, ASP, Servlets, Struts, Spring

Network Protocols: TCP/IP, SOAP, SNMP, FTP and HTTP.

Data Access Tools: Hibernate, ODBC,JDBC,SQL

PROFESSIONAL EXPERIENCE

Confidential, West Palm Beach, FL

Quality Analyst\ ETL\Data warehouse Tester

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Involved in writing the test cases and Test plans based on Source to Target Mapping documents and Data model diagrams.
  • Wrote the Test cases for Enterprise Data Warehousing (EDW) Tables and Data mart Staging Tables.
  • Involved in all stages of the Software Development Life Cycle (SDLC) to develop necessary test strategy
  • Compared Report Generated in Excel sheet to data in Database.
  • Wrote the SQL queries on EDW tables and Data Mart Staging Tables to validate the data results.
  • Wrote the SQL queries for each test case and Executed in SQL Plus to validate the data between EDW and Data Mart Staging Tables
  • Analyzed the result and generated defect report using QC for detected defects and tracked it to development team, and worked closely with developers to track and fix defects.
  • Updated the test cases on based on the requirement changes and executed the test cases.
  • Involved in executing the test cases for EDW and Data Mart Staging Tables.

Environment: Windows 2008 R2, MS-SQL Server 2012/2008R2, SSIS, SSRS, Log Shipping, Replication and Erwin3.5.2/4.0.

Confidential, TX

ETL\Data warehouse Tester

Responsibilities:

  • Prepared TestPlan, Usecases, Testcases based on the requirement specification document.
  • Performed WhiteBox, BlackBox and Regression Testing for the different stages of the claim process.
  • Monitored Test Director to close the bugs as and when developers fix the bugs.
  • Formulated and executed test queries using SQL on Oracle and Microsoft SQL Server Databases.
  • Conceptualized and visualized client-server architecture and middleware technologies(TIBCO) for cross platform message and Data transfer(data in XML format)
  • Involved in modifying the scripts for existing system requirements by incorporating various user defined functions. Created and stored functions in global files to ensure the re-usability of these functions in other scripts.
  • Used Mercury Quality Center (QC) to maintain the test scripts and deploy in the project.
  • Analyzed the result and generated defect report using QC for detected defects and tracked it to development team, and worked closely with developers to track and fix defects.
  • Produced timely testing metrics and summary reports throughout the testing life cycle using QC.
  • Performed load and performance tests using LoadRunner and analyzed the response times of the business transactions under load.
  • Wrote SQL queries to verify GUI front-end results and used TOAD to retrieve data from Oracle database to satisfy requirements /test cases.
  • Worked with SQL and PL/SQL to test database integrity.
  • Performed some sort of gap analysis, business risk analysis and documented.
  • Created test plans, test cases and test scripts and provided progress reports to the management.
  • Extensively used Database and XML checkpoints while testing the provider look up and directories online applications.
  • Logged the issues found during the testing process, using a QA’s issue tracking system, and through Test Director. Once issues are marked as fixed by developer, the tests were rerun to verify and close the issue.
  • Wrote SQL queries to verify the data from the SQL Server database using Query Analyzer.
  • Performed end-to-end testing after bug fixes and modifications
  • Actively involved in the project kick-off meetings
  • Worked on multiple simultaneous projects, and periodically worked on call.

Environment: Test Director 8.0, SQL Server, Java, SQL, MS Query Analyzer, MS Enterprise Manager, J2EE (Java 2.0, EJB 2.0, JSP 1.2, Servlets), XML,TIBCO

Confidential

ETL\Data warehouse Tester

Responsibilities:

  • Crested Test Strategy document, Test case document on each release for testing the business rules
  • Perform end to end, functional testing, regression testing after fixing defects
  • Wrote and documented detailed test cases, test plans and test scripts.
  • Used Quality Centre for the management of Test cases and tracking the defects in each testing cycle
  • Documented the test results and the test data
  • Developed Automation scripts to fix and repair live system orders that failed due to Human error or system errors
  • Enhanced the script by inserting check points for checking the objects, pages, text and tables in the website using QTP
  • Automated Test scenarios for GUI, Functional and Regression Testing using QTP
  • Created different types of scenarios to run with the available virtual users
  • Developed User scripts using virtual user generator for performance/load/volume testing
  • Implemented iterative testing using AGILE methodologies
  • Performed data base testing for checking the data integrity by executing the SQL statements and Database checkpoints
  • Performed bug tracking and reporting using the Test Director

Environment: WinRunner 7.01, Test Director 7.2, Java, JSP, Web Sphere, SQL Server, Oracle 8i, HTML, Java Script, XML Linux, Unix, Windows NT/2000

Confidentia

QA Analyst \ ETL tester

Responsibilities:

  • Involved in the Testing process in identifying the Business Cases, Test Requirements, and Testing Techniques and procedures bases on the project requirements.
  • Responsible for the creation of Manual and Automated Test Plans, Test Scenarios, Test Cases and also ran baseline tests.
  • Performed all types of commands in Linux environment
  • Verified various XML files and the parsed values in system to ensure data integrity.
  • Also involved in designing and running SQL queries and SQL procedures against the SQL Server and Oracle Databases and testing the results with the Web page Displays.
  • Tested application functionality using WinRunner by creating different types of check points like GUI, Bitmap and Database.
  • Created Custom Functions and also performed Regression Tests using QTP for each subsequent builds.
  • Performed Load Tests using LoadRunner for Load Testing by creating automated Job Schedules involving test scripts. Also tested the performance by calculating Throughput, Turnaround and Response Times.
  • Tested the application by ramp up and ramp down of the load on the Web pages and also performed weekly performance testing using LoadRunner.
  • Performed Integration Testing by synchronizing different test scripts running on different modules of the application.
  • Involved in reporting the bugs to the developers and QA Manager using Test Director. Also maintained Modification Reports for the bug fixes in consecutive builds.
  • Actively participated in product walk through and weekly defect report meetings.
  • Agents tested for WMI, SNMP, JMS, Log VIEW,URL Monitor, Oracle, Application Servers
  • Configured and tested with actual system values of WMI,JMS,SNMP Trap, Active Logs, Oracle and Sybase Agents
  • Participate in AGILE / SCRUM process

Environment: Win Runner, Load Runner, Test Director, JBoss, Portlets, Spring, Hibernate, EJB, Messaging Server, Java Agents, Oracle 10g,Tomcat,XML, Linux

Confidential

QA Analyst

Responsibilities:

  • Initially performed Manual Testing of the application using numerous Test Scripts.
  • Analyzed Business Requirements and technical specifications for creating and implementing a test approach with effective test strategies.
  • Created and executed test cases by analyzing the Business Functional specifications and Functional Design Document (FDD) to test new builds and QA releases.
  • Participated in technical Walkthrough sessions and defect report meetings periodically.
  • Performed Functional testing for Referral module to check best process is attributed to the new vertical were accommodated in Resolution module.
  • Designed and developed Functional test cases, User Interface test cases and test steps in Test Director for putting the application on automated testing using Mercury WinRunner.
  • Involved in carrying out functional, regression, component and integration level testing.
  • Developed system test plans for testing future releases of the web based software applications.
  • Maintained and debugged various test sets in weekly regression sessions.
  • Verified to make sure all the relevant data is available through SQL queries.
  • Utilized TestDirector for Defect management, created, prioritized, and tracked defects.
  • Performed defect tracking and bug reporting using Mercury Test Director and coordinated defect fixes in specific product releases with the development and project management teams.

Environment: WinRunner 7.6, Test Director 8.0, SQL Server, SQL, MS Query Analyzer, MS Enterprise Manager, J2EE (Java 2.0, EJB 2.0, JSP 1.2, Servlets), MS-Office 2000, Windows 2000.

We'd love your feedback!