Quality Analyst\ Etl\data Warehouse Tester Resume
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.