We provide IT Staff Augmentation Services!

Etl/report Tester Resume

Washington D, C

SUMMARY

  • Over 11 years of diverse experience in Quality Assurance and Software Development Lifecycle (SDLC) and Agile.
  • Experience in Manual and Automated Testing and data warehousing applications.
  • Having Good Exposure in database Query tools like TOAD, SQL Developer and DB Visualizer, SQL Server Management Studio (SSMS).
  • Involved in all aspects of testing such as preparation of Use cases, Test Plans, Test Cases, Test Reports for System Testing, Functional, User Acceptance Testing, Regression Testing, Backend Testing, ETL testing, BI report testing and Defect Tracking
  • Participate in sprint planning, task estimates and Developed Functional Test Cases to ensure quality based on Functional Requirements Specification and business scenarios.
  • Performed testing on various environments such as Client/Server and Web technologies.
  • Database testing by execution of SQL queries using Oracle and SQL Server.
  • Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.
  • Effective defect tracking and reporting using Quality Center, JIRA.
  • Experienced in testing various Business objects reports.
  • Experienced in implementation of different QA methodologies in SDLC Including Agile
  • Experienced in reviewing the Business Functional Specifications, Functional Design Specifications and Technical Documentation
  • Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate - wide-ETL solution.
  • Expertise in Data Warehouse, Data services, ETL Verification, BI reports.
  • Extensively worked with backend activities for testing several reports developed by BI tools. And written several complex SQL queries.
  • Tested Complex Reports in BI with features of Drilling options.
  • Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution. Execution of individual and workflow test cases.
  • Database manipulations using Microsoft SQL and Oracle.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Knowledge of Selenium automated tool.
  • Has very good testing experience in various domains like financial applications, on Mutual Funds, Foreign Exchange, Options, Fixed Income, Money Market and Equities. Has experience with Ecommerce application. Good business and functional knowledge of Trading Systems.

TECHNICAL SKILLS

Testing Tools: Mercury interactive Test Suites (Quick Test Pro 8.2, TestDirector7.5/7.6/8) Manual testing.

Languages: C, C++, PL/SQL, VB Script., T-SQL

GUI: Visual Basic 6.0/5.0/4.0.

Web Tools: VB Script, HTML and XML.

Hardware: IBM Compatible PC-AT 486/Pentium II & III.

Version control: Microsoft’s Visual Source Safe (VSS).

Database: Oracle 7.x/8.0/9i/10g/11i, MS Access., DB Visualizer 9.0, Server studio 9.0, SQL Server 2010/2012/2014 , TOAD,Oracle SQL developer

Defect tracking tool: Test Director, Quality Center 10.0, Clear Quest 8, JIRA

ETL Tools: Informatica Power Center 8/7.1.2, BO Data services XIR2 and 4.1.

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

ETL/Report Tester

Responsibilities:

  • Performed data validation testing writing SQL queries. Tested ETL batch processes.
  • Completed multiple project design reviews to incorporate testing cycles in the SDLC (Agile/Waterfall).
  • Validated the Business Rules and store procedures, tested the data in source and target database and successfully deployed the changes and bug fixes to PROD.
  • Discussed functional requirements and assisted in preparing User interface prototypes. Documented test plan and test cases based on the requirements.
  • Worked with the team on creating the testing specifications/ testing process which includes functional, regression and UAT testing during the project implementation.
  • Prepared test scripts in multiple program areas to validate the data accuracy, ETL design and report execution.
  • Worked on multiple Business changes request related to different program areas as part of the O&M team.
  • Worked with the ETL developers to record the development changes based on the business requirements.
  • Worked on testing and validating the data from multiple data sources like flat files, Informix and Oracle database, mainframes etc.
  • Analyzed large volumes of data in Server Studio and Oracle SQL Server for Java based Web application. Tested various business objects reports.
  • Supported end users with issues and change requests and tested data sets for multiple program areas and ensured successful Go Live.
  • Worked with the technical team to fix multiple data issues based on the testing results and reviewed the test results with the business.
  • Involved in ETL process testing using SAP B.O Data services ETL tool.
  • Developing Test Matrix to give a better view of testing effort.
  • Worked in an agile development team to deliver an end to end continuous integration, continuous delivery product in an open source environment using tools like VSTS.
  • Performing database testing to verify backend database transactions.
  • Wrote test plan and involved in testing for BO version upgrade.

Environment: SAPBO Data Services (BODS), DB Visualizer 9.0.9, Clear Quest 8.0, IBM Notes 9, Windows 7, Server studio 9.0, Oracle SQL developer, JIRA, VSTS Tool, SAP Business objects Data services XIR 2.1 and 4.1, SharePoint 2010.

Confidential, Washington D.C.

Business Analyst/ETL Tester

Responsibilities:

  • Types of Tests and Developed Test Plan, Test Cases and Test Scripts and followed Agile Development process.
  • Interacted with Designers, Developers and Project Managers to get a better understanding of the Business Processes.
  • Involved in the development of the documentation and executed the test cases.
  • Wrote test cases for various screens of the application.
  • Involved in Database testing with Oracle using SQL developer.
  • Executed various shell scripts to Brand and Trigger the events.
  • Used Quality Center as the test repository and used it for executing the test cases and scripts and logging & generating various reports and graphs for further analysis.
  • Participated in Defect calls and review meetings. Wrote Test Plan as required.
  • Involved in ETL process testing using Informatica ETL tool.
  • Involved in both manual & automated testing of the project.
  • Executing end-to-end testing with multiple backend systems, and validating data.

Environment: Quality Center 11.0, IE 8.0, SharePoint 2010, Oracle 9i, SQL Developer, ETL - Informatica Power Center 8/7.1.2, UNIX, Windows 7.

Confidential, NJ

Business Analyst/ETL Tester

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Managers to get a better understanding of the Business Processes.
  • Analyzing Functional/Business and Technical Specifications, providing input and conducting Ambiguity Reviews.
  • Performed Integration testing to test the functionality of the modules.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Performed Black Box testing of the GUI Objects.
  • Performed UI testing for all the screens according to the requirement.
  • Used Quality Center as the test repository and used it for executing the test cases and scripts and logging & generating various reports and graphs for further analysis.
  • Used the Quality Center log to view the test results, including verification point failures, procedural failures, aborts and also for defect tracking and maintained the trailing history of the defects. Quick Test Pro was used to create regression, functional, system testing. Generated critical automation test script for Regression testing Using Quick test Professional.
  • Modifying and Debugging QTP Test Scripts, used checkpoint, parameterization, and deals with dynamic data.
  • Co-operated a key role working closely with and supporting the Project Manager and associates.
  • Participated in the bug review meetings.

Environment: QTP 8.x, Rational Clear Quest, IE 6.0, Test Director, Oracle 9i, SQL Developer, UNIX, Windows 2000,SOAP UI.

Confidential, NJ

QA Tester

Responsibilities:

  • Involved in both manual & automated testing of the project.
  • Involved in the development of the system documentation and executed the test cases.
  • Wrote test cases for various screens of the application.
  • Created automated test scripts and performed data driven test-using Win Runner.
  • Creation of test data for performing all the tests.
  • Extensively involved in the System Testing of the Application. Involved in the Black box testing of the application Wrote Test Plan as required.
  • Did extensive UI testing and performance testing for the Streaming panel.
  • Developed automated test scripts to facilitate regression testing using Win Runner.
  • Defects were tracked and reported by using PVCS Tracker.
  • PVCS Tracker is used to capture, manage and communicate the many feature requests, defect reports, changes and project issues.

Environment: Win Runner 7.x, PVCS Tracker, True Change, Test Director, SQL SERVER, PL/SQL, UNIX, Windows NT

Confidential, NJ

QA Tester

Responsibilities:

  • Types of Tests and Developed Test Plan, Test Cases and Test Scripts and followed Agile Development process.
  • Executing shell scripts in UNIX for data load and unload.
  • Verifying order flow through ATG by executing SQL queries and stored procedures using Oracle PL/SQL developer.
  • Developed SOA tests for web services involving XML / HTTP / SOA / WSDL using soap UI.
  • Conducted Functional, Integration, Regression testing using soap UI
  • Involved in automation development review meetings.
  • Involved in data base testing with Oracle using SQL developer
  • Attended business reviews and walkthroughs and design meetings to evaluate the requirements
  • Worked closely with developers for understanding deep about the issue and worked together to solve the issue and fix them
  • Supported the production builds in nights to do a sanity check on the new changes across the applications
  • Verified logs for any issues on the server on a UNIX platform, transferred the data to the other servers for validation using FTP on UNIX and WINSCP on windows

Environment: ATG, ACC, BCC, Oracle 10g, Java, Unix, Oracle BRM, soap UI 2.5, QTP 9.0, QC, WINSCP, SQL developer, TOAD, Fiddler, Windows, POMS.

Confidential, NJ

QA Tester

Responsibilities:

  • Involved in gathering User requirements and test case preparation
  • Created Requirement based, and Scenario based Test Plan for Functional and Performance Testing
  • Involved in Functional Walk-Through to validate the Application Design against the Test Cases written.
  • Designed and implemented Test Plan, Test Cases and Test Strategies for the module functionality. Involved in manual testing of the Mainframe application
  • Performed data integrity testing by executing SQL statements Performed backend testing
  • Interacted with developers on any system bugs, bug fixes and responsible for logging defects in defect management system
  • Tracking defects using Test director, Preparing Bug Report and measuring the product quality.
  • Developed Test Plans, Test scripts and regression Test specifications.
  • Developed Manual Scripts that includes boundary, compatibility, functionality, usability and end-to-end testing in different Environment.
  • Created Testing (Staging), Pre-Production Environment which is replica of Production Environment to test Data Migration and Data Load.
  • Participated with Business Analyst and developers to resolve the technical issues and Defect Resolutions. Performed Regression, Manual, Control, Parallel types of Functional System Testing Techniques. Involved in the User Acceptance test.
  • Effectively used Quick Test Pro as automation tool for Smoke and Regression Testing.

Environment: XP Professional, Attachmate, .Net, Visual Basic, COBOL II, IMS/DB, DB2, Quick Test Professional(QTP 8.0,9.0), Quality Center, MS Word/Excel, Lotus Notes.

Hire Now