We provide IT Staff Augmentation Services!

Etl/ Qa/ Bi Tester  Resume

Charlotte Nc - Jersy City, NJ

SUMMARY:

  • Software Test Engineer with over 7+ years of experience in Software Testing, IT support, Test automation development and testing ETL, Data warehouse, Client/Server and web applications.
  • Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
  • Extensively used HP Quality Center and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
  • Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate - wide-ETL solution using Informatica & SQL Server Integration Services
  • Experience in Testing BI applications using OBIEE, SSRS.
  • 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.
  • Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
  • Experienced in dealing with clients to gather requirements, understanding the Business requirements, product demonstrations and providing product support.
  • Experience in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
  • Experience in data analysis and problem solving with large amounts of data
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
  • Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
  • Experience with software change management tool Rational ClearCase for versioning the documents and maintaining the document repository.
  • Familiar with the use and working of Rational RequisitePro for requirements management.
  • Expertise in Data Warehouse, ETL Verification, BI reports.
  • Experienced in web and client/server applications QA testing.
  • Experience in Database performance tuning and optimization.
  • Expertise in QA Testing in distributed Unix Environment and Oracle databases as back end, Performed end-to-end testing & back-end testing.
  • A self-motivated, responsible and reliable team player with a set of strong technical skills.

TECHNICAL SKILLS:

Testing Tools: Mercury Test Director 8.2/7.2, HP Quality Center

Operating Systems: UNIX, Windows 98/ NT/2000/XP

Reporting Tools: SSRS 2005/2008, OBIEE 10.0.3, Business Objects XIR3

ETL Tool: Informatica 9.1/8.x/7.x, SSIS,R2, Ab Initio, Data Stage

Database: DB2 8/7/5.1, Oracle 10g/9i, SQL Server, Teradata

Version Management: Rational ClearCase

Programming Languages: PL/SQL, T-SQL, C, C++, Java, SQL

Other tools: Remedy (ARS) Trouble Ticketing, Rational RequisitePro

PROFESSIONAL EXPERIENCE:

Confidential, CHARLOTTE, NC - JERSY CITY, NJ

ETL/ QA/ BI Tester

Responsibilities:

  • Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
  • Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
  • Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
  • Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
  • Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
  • Experience in manual testing which involves web-based application testing for provider and claims system.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Tested the ETL mappings from Source to Target.
  • Written test cases for checking the populated data correctly into fact and dimension tables.
  • Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
  • Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
  • Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
  • Coordinated with development team in system integration test and services level unit testing.
  • Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
  • Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
  • Extensively used SQL Queries to verify and validate the Database Updates.
  • Actively participated in creating requirements Traceability matrices and Test plans
  • Prepared test requirements, test plan approach document and test cases.
  • Performed Unit and functional testing for all the Mappings and Sessions.
  • Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: Informatica 9.1, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008), SQL server SSRS (2008), PL/SQL, Toad, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server

Confidential, Worcester, MA

ETL QA Tester

Responsibilities:

  • Verified the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
  • Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
  • Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality
  • Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables
  • Tested the application for web functionality, and verified the online modules for broken links.
  • Performed SQL validation to verify the data extracts and record counts in the database tables.
  • Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
  • Performed usability testing frequently to ensure continuous availability of online services to personal clients.
  • Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
  • TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
  • Writing SQL Queries to retrieve data from data base.
  • Divided the graphs into various phases and used checkpoints to avoid Dead locks.
  • Extensively worked on debugging ETL process graphs.
  • Used Rational ClearCase to maintain the versioning and change management for the test document repository.
  • Developed and tested transformation functions and record formats for various input data files.
  • Prepared test data to verify the functionality of the Informatica.
  • Performed Data validation to verify the data extracts and record counts in the database tables.
  • Conducted weekly batch testing to in corporate changes in new builds.
  • Provided the management with weekly QA documents like test metrics, reports, and schedules.
  • Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere .
  • Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution.

Environment: Informatica 8.6, HP Quality center9.2, QTP 9.2 Oracle 9i/10g, PL\\SQL, OBIEE 10.1.3, SQL server (2005), Teradata V2R6, Windows 2000, SQL, SQL Plus, UNIX, Rational Clear Case,, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential, Hartford, CT

BI Quality Engineer

Responsibilities:

  • Involved to create Business Risk Levels to determine Test Priorities.
  • Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, involved in both Manual and Automation Testing.
  • Performed Regression testing using Test Director.
  • Extensively used SQL Queries to verify and validate the Database Updates.
  • Used Test Director a workflow automation tool for defect tracking and product automation.
  • Created User Defined Functions and procedures in Test Director Library to re-use them in different tests.
  • Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
  • Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
  • Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
  • Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
  • Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
  • Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
  • Responsible for Reviews and documentation for reporting the status to the project manager.
  • Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
  • Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment: Informatica 8.x, Test Director 8.0, Win Runner 5.0, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Confidential, Philadelphia, PA

ETL Quality Engineer

Responsibilities:

  • Projects were in different methodologies like Waterfall and AGILE, well versed with both methodologies of SDLC.
  • Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
  • Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
  • Involved in unit testing and integration testing of the developed work Analyzed production support issues.
  • Designed detailed test plans, test case and executed test scripts and diagnose problems in Informatica mappings based on Business Requirements.
  • Gathered UI specifications and analyzed business process and established test strategies.
  • Tested the values for test, Component parameters in Quality Center.
  • Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
  • Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
  • Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other database objects.
  • Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
  • Logged issues in Test Director and tracked them to see whether the bug is fixed in the next version.
  • Communicated with Developers regarding technical issues.
  • Used Remedy in trouble ticketing and moving projects from testing to pre-production environments. VSS to upload track and manage scripts and documents.

Environment: SQL server 2005(SSRS) Informatica 8.x, SQLServer, DTS Packages, Remedy, Teradata V2R5, Windows NT, UNIX, MS Excel, VSS(Visual SourceSafe), Quality Center 8.2, QTP 8.2

Confidential, PHONEIX, AZ

Database Tester

Responsibilities:

  • Coordinated and controlled testing projects at every step of the quality cycle from test planning through execution to defect management.
  • Reviewed system use cases and functional specifications with the appropriate business analyst.
  • Generation and documentation of test cases from functional requirements and design documents.
  • Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
  • Reporting to Test lead and a daily basis on the new bugs filed, status of old bugs and follow up the developers.
  • Performed Integration, System tests and Customer acceptance testing. Created new tests based on the review of the customer in the acceptance test phase.
  • Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
  • Performed manual tests in cases the functionality was not covered in the automated test suits.

Environment: Oracle 9i, PL/SQL,Load runner, TOAD, SQL server 2000, Windows 2000 and QTP.

Hire Now