We provide IT Staff Augmentation Services!

Etl/report Tester Resume

Washington D, C


  • 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 teh 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 wif backend activities for testing several reports developed by BI tools. And written several complex SQL queries.
  • Tested Complex Reports in BI wif 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 teh 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 wif Ecommerce application. Good business and functional noledge of Trading Systems.


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.


Confidential, Washington D.C

ETL/Report Tester


  • Performed data validation testing writing SQL queries. Tested ETL batch processes.
  • Completed multiple project design reviews to incorporate testing cycles in teh SDLC (Agile/Waterfall).
  • Validated teh Business Rules and store procedures, tested teh data in source and target database and successfully deployed teh changes and bug fixes to PROD.
  • Discussed functional requirements and assisted in preparing User interface prototypes. Documented test plan and test cases based on teh requirements.
  • Worked wif teh team on creating teh testing specifications/ testing process which includes functional, regression and UAT testing during teh project implementation.
  • Prepared test scripts in multiple program areas to validate teh data accuracy, ETL design and report execution.
  • Worked on multiple Business changes request related to different program areas as part of teh O&M team.
  • Worked wif teh ETL developers to record teh development changes based on teh business requirements.
  • Worked on testing and validating teh 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 wif issues and change requests and tested data sets for multiple program areas and ensured successful Go Live.
  • Worked wif teh technical team to fix multiple data issues based on teh testing results and reviewed teh test results wif teh 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


  • Types of Tests and Developed Test Plan, Test Cases and Test Scripts and followed Agile Development process.
  • Interacted wif Designers, Developers and Project Managers to get a better understanding of teh Business Processes.
  • Involved in teh development of teh documentation and executed teh test cases.
  • Wrote test cases for various screens of teh application.
  • Involved in Database testing wif Oracle using SQL developer.
  • Executed various shell scripts to Brand and Trigger teh events.
  • Used Quality Center as teh test repository and used it for executing teh 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 teh project.
  • Executing end-to-end testing wif 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


  • Gathered Business Requirements, interacted wif teh Users, Designers and Developers, Project Managers to get a better understanding of teh Business Processes.
  • Analyzing Functional/Business and Technical Specifications, providing input and conducting Ambiguity Reviews.
  • Performed Integration testing to test teh functionality of teh modules.
  • Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Performed Black Box testing of teh GUI Objects.
  • Performed UI testing for all teh screens according to teh requirement.
  • Used Quality Center as teh test repository and used it for executing teh test cases and scripts and logging & generating various reports and graphs for further analysis.
  • Used teh Quality Center log to view teh test results, including verification point failures, procedural failures, aborts and also for defect tracking and maintained teh trailing history of teh 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 wif dynamic data.
  • Co-operated a key role working closely wif and supporting teh Project Manager and associates.
  • Participated in teh 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


  • Involved in both manual & automated testing of teh project.
  • Involved in teh development of teh system documentation and executed teh test cases.
  • Wrote test cases for various screens of teh application.
  • Created automated test scripts and performed data driven test-using Win Runner.
  • Creation of test data for performing all teh tests.
  • Extensively involved in teh System Testing of teh Application. Involved in teh Black box testing of teh application Wrote Test Plan as required.
  • Did extensive UI testing and performance testing for teh 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 teh 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


  • 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 wif Oracle using SQL developer
  • Attended business reviews and walkthroughs and design meetings to evaluate teh requirements
  • Worked closely wif developers for understanding deep about teh issue and worked together to solve teh issue and fix them
  • Supported teh production builds in nights to do a sanity check on teh new changes across teh applications
  • Verified logs for any issues on teh server on a UNIX platform, transferred teh data to teh 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


  • 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 teh Application Design against teh Test Cases written.
  • Designed and implemented Test Plan, Test Cases and Test Strategies for teh module functionality. Involved in manual testing of teh Mainframe application
  • Performed data integrity testing by executing SQL statements Performed backend testing
  • Interacted wif 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 teh product quality.
  • Developed Test Plans, Test scripts and regression Test specifications.
  • Developed Manual Scripts dat 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 wif Business Analyst and developers to resolve teh technical issues and Defect Resolutions. Performed Regression, Manual, Control, Parallel types of Functional System Testing Techniques. Involved in teh 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