SUMMARY:

• 8 years of experience in Quality Assurance wif ETL flows, Business Intelligence Reports, Web based, Client/Server applications using Manual and Automated testing tools.
• Experience in all phases of teh Software Testing Life Cycle (STLC) and good exposure to Software Development Life Cycle (SDLC).
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Strong SQL experience.
• Proficient in SQL query and testing RDBMS such as SQL Server, Oracle, MySQL for data validation. Expertise in Microsoft office (Word, Excel, Power Point, Outlook & Visio)
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for data base.
• Experience testing Cognos Reports.
• Experienced wif ETL tools like Informatica, SSIS, Abinitio and Datastage.
• Responsible for creation and maintenance of SQL Server Analysis Services (SSAS) objects such as cubes, dimensions and queries.
• Strong experience in testing ETL applications and BI reports.
• Sound Knowledge and experience in Star schema/Snowflake schema.
• Excellent communication skills and team player.

TECHNICAL SKILLS:

Defect Tracking Tools: HP Quality Center 10/9.0/9.2, IBM Clear Quest 9.0, QTP, Bugzilla and Jira

ETL Tools: Informatica 9.0, Data Stage, Ab Initio 1.15, SSIS

BI/Reporting Tools: OBIEE, Business Objects, SSRS, SSAS, Crystal Reports XIR4, Cognos 8.4

Operating System: Windows 98/XP/2000, UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML, java, C, Perl scripting, VB,

RDBMS/ Database: SQL Server, Oracle, IBM DB2, Teradata 12.0,

GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. ETL QA Test Lead

RESPONSIBILITIES:

• Designed and executed various Test scripts for System testing based on teh Functional Design Document.
• Assisted in gathering teh business requirements, ETL test and design of teh flow and teh logic for teh Data warehouse project.
• Wrote complex SQL queries between source and target for validating ETL jobs.
• Reported bugs and tracked defects using HP ALM/Quality Center.
• Automated and scheduled teh Informatica jobs using UNIX Shell Scripting.
• Tested SQL queries to validate teh data and performance of teh database.
• Executed SQL queries using TOAD to query Oracle database. Prepared test strategy to validate Teradata reports against Oracle reports.
• Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document.
• Used DWH ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Wrote SQL Statements in database to make sure whether teh data is populated in Data Mart/Data warehouse According to Business Rules.
• Used multi-dimensional models - Star and Snow Flake Schemas- for developing tables.
• Tested reports from Cognos data warehouse system and used HP ALM/Quality Center for test cases execution and defect tracking.

Environment: Informatica, Oracle 11g/10g, HP ALM/Quality Center 10, Sql server 2008, UAT, TOAD, SQL, SQL*Developer, UNIX, Agile, Cognos, Jira 1, Windows

Confidential, LLC

ETL QA Tester

• Analyzed teh Business Requirements and Rules and worked wif business Analysts and Business Users in preparing Test Plans.
• Developed Test cases, Test scripts from teh data mapping documents, functional Specification documents and mapped teh test cases wif teh requirements for generating teh Requirement Traceability Matrix (RTM).
• Closely went through and worked on all teh stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Tested several packages developed using SSIS.
• Extensively worked on designing various output and management reports Using SQL Server Reporting Services (SSRS).
• Used TOAD Software for Querying ORACLE. And Used SQL Server Management studio for Querying SQL server
• Validated many SSAS cube data against teh dimension and facts.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Involved in testing teh OBIEE reports by writing complex SQL queries
• Analyzed teh data mapping and developed scenarios to verify teh data migration. Validate teh Data Mart tables to check teh data TEMPhas been populated correctly.
• Tracked teh progress of teh defects till end of teh defect life cycle, used HP Quality Center for defect tracking and maintained teh workflows and trail history of bugs using HP Quality Center.
• Performed Data Verification, data Validation, and Data Transformations on teh Input data (Text files, XML files) before loading into target database
• Used TOAD Software for Querying ORACLE. Executed SQL queries for Data Migration and Data testing.
• Tested report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Written several test cases for SSIS Packages and for data flow.
• Manually performed Back-End testing by writing SQL queries and validating teh database using Complex SQL Joins and Functions.
• Tested several SSRS reports and SSAS OLAP cubes for multiple projects and used RDL and XML for testing teh same.
• Worked under development method Agile (Methodology) and SDLC
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Used HP Quality Center as test management and defect management tool.
• Prioritized teh test cases based on teh projected metrics and project deadlines.
• Worked wif Developers on Defects until teh test case is passed.
• Extensively written SQL to confirm teh data transfer from source to target.
• Written several complex SQL queries for validating OBIEE Reports.
• Involved in testing teh UI screens, reports which was used by teh business team.
• Written and executed teh functional and regression test script using Test Script QTP.
• Used multi-dimensional models - Star and Snow Flake Schemas- for developing Cubes.
• Tested teh list, cross tab, repeater and Drill-through reports in different formats like PDF and HTML.

Environment: Informatica 9.1,SSIS, SSRS, SSAS, OBIEE, Oracle 11g/10g, SQL Server, HP Quality Center 10, Sql server 2008, UAT, TOAD, SQL, SQL*Plus, UNIX, Agile, Flat files, XML, XML Spy 2010, Windows

Confidential, Minneapolis, MN

ETL QA Tester

• Analyzed teh existing system and process gaps in context of new conversion of Flagstar and bank changes.
• Conducted JAD sessions wif management, SME’s, Business users and other stakeholders for open and pending issues to develop specifications.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh SSIS Packages.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Written SQL queries manually and also built SQL queries using TOAD to validate teh Customers ' addresses and accounts level data .
• Tested teh SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Used Quality Center as repository for maintaining test cases, UAT test plans and tracking teh defects.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested all OBIEE Dashboards according to teh requirement. Experienced in creating teh SSIS packages, DTS packages.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested OLAP cubes and SSAS reports for various business needs
• Extracted data from various sources like flat files and SQL Server.
• Ensured that migrated data is complete, accurate and correct from Oracle database.
• Performed Data Verification, data Validation, and Data Transformations on teh Input data (Text files, XML files) before loading into target database
• Agile Methodologies. Experienced in teh use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Performed manual back end testing while retrieving teh data from teh Oracle database for financial applications like DDA, SVG, IRA, CDS, and DCA.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate teh data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Tested Designed and Developed OLAP Cubes using SSAS.
• Tested teh reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Worked wif SSRS XML export on teh reports and wif ranking values in teh XML.
• Extraction of test data from tables and loading of data into SQL tables.
• Written Test Cases for ETL to compare Source and Target database systems.

Environment: Informatica 8.1,SSIS, SSRS, SSAS, OBIEE, SQL Server, SQL, TOAD, Quality Center, MS Office 2007, Oracle 10g, Windows XP/2003, UAT, QTP, Agile, Ration Tools, Clear Quest, VB Script, Excel.

Confidential , Windsor

ETL QA Analyst

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all teh ETL process that was developed to fetch teh data from various feeds into teh data warehouse.
• Written SQL scripts for validating teh data loaded by teh ETL processes.
• Tested teh reports generated by SQL Server reporting services (SSRS) and checked as they are as per teh Organization standards.
• Perform manual testing and created various test results to track teh testing results.
• Writing complex SQL queries for data validation for verifying teh SSIS Packages and business Rules.
• Export requirement, test cases into teh Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up wif standard software testing life cycle (STLC) to perform different types of testing for teh projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Tested OLAP cubes developed using SSAS and Tested several data mining functionality for various BI needs
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Tested and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Participated to create Test Analysis reports (TAR) and stored them into teh Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in teh UAT environment prior to notify to teh customer to start performing UAT testing.
• Tested Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
• Worked in a team adopting Agile software development methodology
• Writing complex SQL queries for data validation for verifying teh SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met wif client to present future functionality of teh application, gather information from them to know about their need and send this information to test manager.
• Worked closely wif teh application development and design and testing team to resolve technical issues and interacted wif them to ensure overall quality of teh software.

Environment: SSIS, SSRS, SSAS, SQL Server, Quality Center 9.2, Web Services/Web methods, XML, HTML Oracle, SQL,ALM, TOAD, Agile, Windows 2003/2007, UNIX.