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!