SUMMARY

• 8+ years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong Understanding and experience in Software Testing Life Cycle.
• Expertise in building Test Strategies, Test Plans, Test Cases, Manual and Automated Scripts and creating and maintaining Traceability Matrices.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Involved in testing teh Micro strategy reports by writing complex SQL queries
• Supported User acceptance testing (UAT) in preparing teh test scripts and test execution
• Created status reports.
• Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Strong working experience in teh Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Experienced in Defect Management using ALM, HP Quality Center
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Good exposure with databases like Oracle 10g, DB2, SQL Server 2012
• Dashboard Visualization through Tableau BI application.
• Experience in debugging teh issues by analyzing teh SQL queries.
• Good experience in working with UNIX scripts in executing and validating logs for teh issues.
• Experience with testing reporting tools (Cognos/Business Objects).

TECHNICAL SKILLS

ETL Tools: Ab Initio CO>OP 2.15,Informatica 5.x/6.x/7.x/8.x (PowerMart & PowerCenter), SSIS, DataStage

BI Tools: Tableau, Micro Strategy, Cognos 8.0 Series, Crystal Reports, Hyperion, OBIEE

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Bugzilla, Selenium, QTP/UTP

Data Modeling Tools: Erwin 3.x/4.x

Utilities: Toad, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Databases: SQL Server 2005/2008, Oracle 11i/10g/9i, Teradata V2R6, DB2, Sybase 12.5, Netezza

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Quality Analyst ETL tester

Responsibilities:

• Created Test strategy Test plans and Test scenario based on teh user stories and enabler stories and reviewed it with teh developers and Product owners.
• Experience in using SQL Server Integration Services to EETxtract, Transform and Load (ETL) data.
• Performed different types of testing like GUI testing, ETL testing, UAT testing, Functional, Regression, Integration, End to end, Backend, Positive and Negative testing.
• Involved in ETL process testing using Informatica PowerCenter ETL tool.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source;
• Written Test Cases for ETL to compare Source and Target database systems;
• Developed and implemented test cases under teh guidelines of ETL Lead using Informatica Power Center ETL tool;
• Performed ETL validation using Informatica PowerCenter Workflow Manager and Informatica PowerCenter Workflow Monitor;
• Setup teh automation framework using selenium webdriver to run test cases in multiple browsers.
• Performed, Functional, Integration, Regression, End to End testing and participated in User Acceptance Testing
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting teh defects to development team.
• Actively participated in Sprint planning, User story refinement, Daily huddles, Sprint review and Retrospective meetings.
• Experience in testing and writing SQL, T-SQL and PL/SQL statements
• Worked in an agile technology.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Experienced in giving training to teh functional testers to execute Test Cases using QTP/UFT as part of Regression Testing
• Worked with batch jobs, monitoring and scheduling of jobs as part of teh interface testing-validation of data flow between two systems as per predefined fields mapping sheet and mode of communication.
• Involved in backend testing for teh front end of teh application using SQL Queries in Teradata data base.
• Used Agile Test Methods to provide rapid feedback to teh developers significantly helping them uncover important risks.
• Developed Selenium WebDriver test cases using Java, TestNG framework.
• Implemented Page Object Model Pattern based Keyword Driven automation testing framework utilizing Java, Test-NG and Selenium Web-Driver.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Conducted Data Driven Testing using parameterization in UFT to test teh application with different sets of data.
• Developed automated test scripts using descriptive programming in UFT.
• Validated teh Autosys jil scripts for dependencies, owner, description and other attributes.

Environment: Informatica 9.1, Teradata, Quality Center & ALM 11.0,SQL, PL/SQL, UFT/QTP, UFT, Micro Strategy, MainFrame Flat Files, Autosys, Java, TestNG, Java Script, Selenium WebDriver/IDE, Agile, COBOL II, UNIX, Control-M, Korn Shell Scripting, Oracle 10G, T-SQL, DB2, TOAD9.7

Confidential, Wilmington DE

ETL QA Tester

Responsibilities:

• Involved in Design Review, Test Case Review meetings with business analysts and developers.
• Developed required SQL scripts for reports and extract generated EOD., by executing teh SQL queries. Wrote SQL Queries to extract data from teh Tables.
• Executed teh Test Scripts on different releases and validated teh actual results against teh expected results.
• Experienced in giving training to teh functional testers to execute Test Cases using QTP/UFT as part of Regression Testing.
• Used DBeaver in creating and executing SQL queries using Joins, Unions, Aggregation Functions, Cases for testing ETL process;
• Developed complex SQL scripts/queries for validating backend testing of Databases records;
• Did extensive work with ETL testing including Data Completeness, Data Transformation, Data Quality, Metadata testing for various data feeds coming from source;
• Prepared Test Cases based on ETL Specification Document;
• Tested all teh ETL processes results developed to fetch data from front office trading application DB systems to teh target Settlement Data warehouse using SQL queries;
• Tested teh ETL results for feeds received from counterparties back office and compared with teh data dat was received from Front Office for consistency;
• Involved in extensive DATA validation, data verification and data conditioning using T-SQL queries and back-end testing
• Responsible in executingSeleniumtest scripts on different browsers and checked for compatibility.
• Configured Selenium WebDriver, TestNG, Maven tool and created Selenium automation scripts in java using TestNG prior to agile release.
• Provide support for technical integration and prod controls teams for execution of ETL mappings.
• Tested and developed teh mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys.
• Created and managed UFT Test Scripts based on teh Requirements and Scenarios.
• Written Test Plan document, Test Cases, Reported Defects using HP ALM.
• Used Toad for Data Analysts to compare Oracle and Teradata databases
• Used Putty to access files and directories in UNIX environment.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to teh target database Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
• Involved in manual and automated testing using informatica data validation option (DVO) and performed source and target table validation.
• Written several complex SQL queries for validating business object reports.
• Extensively tested business objects reports for static/cosmetic errors like header, footer, logos fonts etc. which may appear in all pages of teh reports.
• Smoke testing for teh new builds for QA acceptance.
• Responsible for defect management and driving to resolution and retesting teh same.
• Wrote SQL queries to support teh test case results.
• Performed negative testing using informatica to find how teh workflow performs when it encounters invalid and unexpected values.
• Created SQL compare statements to validate actual results with teh expected results.
• Tracked and executed teh user Acceptance test cases (UAT) with respect to teh requirements to determine teh feature coverage.
• Ensured quality products delivered and installed as specified in teh statement of work (SOW).

Environment: Informatica 9.1,, Oracle 11i, TOAD for Data Analysts, MLOAD, SQL Assistant 6.0, SQL Server 2005, HP Quality Center 11, Autosys, Java, TestNG, Java Script, Selenium WebDriver/IDE, UFT/QTP, UFT, SQL/PLSQL, SOA Test, Control-M, Micro Strategy, UNIX, T-SQL, Agile, Windows XP

Confidential, SSF, CA

ETL QA Tester

Responsibilities:

• Created Test Plan and developed test strategies.
• Created Manual Test Suites for various modules.
• Tested stored procedures & views.
• Tested teh reports generated by Micro strategy and verified and validated teh reports using SQL.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Written SQL queries in order to data validation in migration as part of backend testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively used SQL to verify and validate teh data load.
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying teh tables and columns from which data is extracted
• Performed teh tests in both teh SIT, QA and contingency/backup environments
• Writing teh test scripts for manual testing.
• Test newly developed features to ensure proper functioning prior to release to QA for multiple MDM processes
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Worked with UNIX scripts in executing and validating logs for teh issues.
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Responsible for Functional, Regression and User Acceptance testing - coordinated UAT testing
• Performed SIT/Functional, UAT Testing in Web based application.
• Submitted weekly bug or issue report updates to teh Project Manager in teh form of teh QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Extensively tested several Micro strategy reports for data quality
• Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Data mart tables.
• Wrote Complex SQL queries to verify report data with teh source and target system (data warehouse) data.
• Assisted business users to execute UAT test scenarios and test data as part of Validation Testing
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating teh data against staging tables and target warehouse
• Find report defects and subsequently validating teh fix, repeating teh process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure teh validity of teh Report requirements and mitigation of risks prior to formal acceptance.
• Report testing: Extensive experience with Reporting Tools like Micro strategy
• Performed Interface and Integration(SIT) Testing
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Preparing teh SQL queries to fetch teh data from databases

Environment: Informatica Power center 8.6, IBM Infosphere MDM, Micro strategy, Oracle 9i/10g, Teradata SQL Assistant, Teradata V2R6, TOAD for Oracle, Quality Center, Windows XP, UNIX

Confidential, Irvine, CA

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created test data for testing specific membership functionality.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Used Agile Test Methods to provide rapid feedback to teh developers significantly helping them uncover important risks.
• Conducted Load testing using SOAPUI tool.
• Responsible for testing packages using SSIS (ETL) to verify Data Completeness, Data Transformation, Data Quality, Integration Testing, UAT & Regression Testing.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created teh test environment for Staging area, loading teh Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required.
• Created user defined functions to test teh specific test cases for windows applications using QTP.
• Extraction of test data from tables and loading of data into SQL tables.
• Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping.
• Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Used Quality Center for Bug reporting, tracking & generation of Test Metrics.
• Tested teh ETL process for both before data validation and after data validation process.
• Tested teh messages published by ETL tool and data loaded into various databases.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating teh data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing teh XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 7.x, T-SQL, MVS, UNIX (K-Shell Script), SOAPUI, Agile, Quality Center, QTP, Oracle, SQL Server 2008, DB2, Business Objects