SUMMARY:

• 8 years of experience in QA Tester with Data warehouse ETL flows, Business Intelligence Reports, Web based, Client/Server applications using Manual and Automated testing tools.
• Experience in all phases of the 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 with 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, VBRDBMS/ Database: SQL Server, Oracle, IBM DB2, Teradata 12.0GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QA Tester/ELT Tester

Responsibilities:

• Designed and executed various Test scripts for System testing based on the Functional Design Document.
• Assisted in gathering the business requirements, ETL test and design of the flow and the logic for the 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 the Informatica jobs using UNIX Shell Scripting.
• Tested SQL queries to validate the data and performance of the 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 the 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

Database Tester (SQL)

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with business Analysts and Business Users in preparing Test Plans.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Closely went through and worked on all the 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 the 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 the OBIEE reports by writing complex SQL queries
• Analyzed the data mapping and developed scenarios to verify the data migration. Validate the Data Mart tables to check the data has been populated correctly.
• Tracked the progress of the defects till end of the defect life cycle, used HP Quality Center for defect tracking and maintained the workflows and trail history of bugs using HP Quality Center.
• Performed Data Verification, data Validation, and Data Transformations on the 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 the 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 the 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 the test cases based on the projected metrics and project deadlines.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Written several complex SQL queries for validating OBIEE Reports.
• Involved in testing the UI screens, reports which was used by the business team.
• Written and executed the functional and regression test script using Test Script QTP.
• Used multi-dimensional models - Star and Snow Flake Schemas- for developing Cubes.
• Tested the 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

ETL QA Tester

Responsibilities:

• Analyzed the existing system and process gaps in context of new conversion of Flagstar and bank changes.
• Conducted JAD sessions with 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 the functionality of the 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 the Customers ' addresses and accounts level data .
• Tested the 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 the defects.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested all OBIEE Dashboards according to the requirement. Experienced in creating the 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 the Input data (Text files, XML files) before loading into target database
• Agile Methodologies. Experienced in the use of Agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Performed manual back end testing while retrieving the data from the 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 the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Tested Designed and Developed OLAP Cubes using SSAS.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Worked with SSRS XML export on the reports and with ranking values in the 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.
• Written cases to test application manually in Quality Center and automated using QTP
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Followed up with standard application testing process to perform different types of testing phase for the FLAGSTAR and RBCB projects.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Involved in developing UNIX Shell wrappers to run various SQL Scripts.

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.

ETL QA Analyst

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards.
• Perform manual testing and created various test results to track the testing results.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the 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 the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the 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 the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the 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.