SUMMARY

• 7+ Years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
• Experienced in testing data in data warehousing application and also in reports in Client/Server and Web Based environment
• Well experienced in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using Quality Center test management tool Quality Center/HP ALM based on functional specifications.
• Excellent QA experience in all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies like AGILE, Scrum and Waterfall.
• End - to-end defect management of assigned projects. Identify defects, assess root cause, and prepare detailed information for developers and business stakeholders
• Experienced in Data Validation and Backend testing of databases to check the integrity of data. Used extensively SQL Queries to retrieve data from database.
• Used Quality Center for Test Management, Defect Management and save/manage the automation scripts created using QTP
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes. Good understanding of Object Oriented Programming languages.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, Hadoop, DB2, and UNIX. Ability to evaluate ETL/BI specifications and processes.
• Work closely with the Documentation team to insure the content is meaningful and correct
• Experience in RDBMS, Microsoft SQL Server, Hadoop, Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Experienced in Black Box, White Box, Integration, Regression, Sanity, Functional, Front End and Back End Testing.
• Designed and implemented fully automated Hadoop Integration testing system.
• Responsible for Analysis and Defect Tracking using HP Quality Center/ALM, Test Director, JIRA, IBM Clear Quest.
• Business Intelligence tools like SAP BODS, Micro strategy, Business Objects, Cognos and OBIEE
• Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side
• Experience with different databases like Oracle, Mainframes, Hadoop, Teradata, and MS SQL Server to extract and load data.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing. Expertise in Defect Reporting and Tracking using Test Director/ HP Quality Center. Extensive experience in testing applications on UNIX environment.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Quality Assurance Tools /Test Management: HP ALM 11/HP Quality Center 10, QTP, Test Director 7.5, QTP, IBM Clear Quest, Selenium.

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

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

RDBMS: Oracle 8i/9i/10g/11g, Hadoop, SQL Server 2000/2005/2008 , Teradata, Sybase, DB2

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: SAP BODS, Business Objects, Cognos, Microstrategy, SSRS and Hyperion

Job Scheduling tools: Autosys, ASG Zena.

SDLC/ STLC: Agile, SCRUM, Waterfall, Rapid SQL, V model.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. ETL QA DWH Test Analyst

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing
• Participated in Regression testing after each build.
• Extensively worked in agile environment, with daily scrum meeting, stand up meetings, presentations and review
• Worked on Web-services applications, using SOAP UI tool, to create a Web Service Test from SOAP request and validate the response against the database.
• Performed data analysis and data profiling using SQL and ETL Informatica Data Explorer on various sources systems including Hadoop, Oracle and Teradata
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Datastage.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• I was also involved in debugging issues on Core Hadoop, faced by other Hadoop services teams like - Oozie, Pig, Hcat, Hadoop Integartion
• Wrote Complex SQL queries to validate the standard reports, Dashboards and BI Business objects Universes.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Loading Flat file Data into database tables using Unix Shell scripts.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries
• Performed data quality analysis using advanced SQL skills.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• Developed and implemented template driven test framework for Hadoop components like pig, hive, and map reduce hdfs etc.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects
• Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).

Environment: ETL Informatica 9.6, BI Business Objects XIR4, Hadoop, Quality Center/ALM (HP Application Lifecycle Management 11.0), QTP, SQL Server 2012, UNIX, Oracle 11g, SQL, PL/SQL, Oracle 11g, Agile, MS Office, Teradata 12, DB2, XML, HTML, Windows and Unix, Shell Scripting.

Confidential, Atlanta, GA

Sr. ETL QA SQL Test Analyst

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Perform both manual and automation testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center/ALM, run manual and automation test cases from test lab and log defects from defects module.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
• Tested Business Objects reports and Web Intelligence reports
• Testing functionality, integration, and stress testing on client and web based application.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Performed extensive Data Integrity testing by executing SQL Statements on Oracle & SQL database
• Developed UNIX shell scripts for the purpose of parsing and processing data files. Maintained and did trouble shooting for batch processes for overnight operations.
• Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work. se Business Objects OLAP Intelligence to natively access and analyze OLAP servers
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance divisions and across geographies.
• Tested ad hoc and canned reports for Business objects.
• Performed data analysis and data profiling using SQL and ETL Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Wrote SQL queries to test Data Integrity and performed Database Testing for the Application
• Validated data in between source and target after running Mappings by the Informatica developer team.

Environment: DWH ETL Informatica 9.1, BI Business Objects XIR3.1, Hadoop, ALM, QTP, Agile, PL/SQL, IBM, IBM DB2, Web Services/Web methods, XML, HTML Oracle 10g,, SQL, TOAD and UNIX

Confidential, Madison, WI

ETL SQL QA Tester

Responsibilities:

• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Used webMethods deployer to migrate webMethods components from one environment to other.
• Conducted HIPAA gateway testing. Validated HIPAA EDI transactions
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Used Quick Test Professional (QTP) for regression testing and running the automation suite.
• Used Data Stage Director and the runtime engine to schedule and test the server jobs, monitoring scheduling and validating its components.
• Tested batch Job Controls for automation of Execution of data Stage Jobs.
• Extensively tested with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities and Triggers.
• Written several complex SQL queries for validating Business Objects Reports.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive Data validation using SQL queries and back-end testing.
• Extensively usedRational Clear Questto track defects and managed them.
• Tested whether the reports developed in Business Objects are as per company standards.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Datastage 8.1, BI Business Objects XIR2, Oracle 10g, SQL Server 2008, SSIS, SSRS, QTP, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Microsoft Visio 2003, XML, XSLT, .Net, Web Logic, Clear Case, Netezza, Teradata, Clear Quest, TFS, DOORS, Autosys, Windows XP, PuTTY, UNIX.

Confidential

ETL QA Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Managed multiple OLAP and ETL projects for various testing needs.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested the entire data reconciliation process for multiple source and target systems.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• Designed and prepared scripts to monitor uptime/downtime of different system components

Environment: Informatica 8.1, Business Objects, WinSQL, QTP 9.2, Quality Center 9.2, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2

Confidential

ETL Tester

Responsibilities:

• Started with validating the requirements from the users and testing the documents for the specifications.
• Tested the Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Tested metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.
• Created and reviewed test case and test plan based on the data mapping documents for ETL front and based on BRD for reporting end.
• Customized the QTP Test as per the Test Case by using the VB-Script.
• Tested reports with various object prompts to validate data of various Ad hoc reports.
• Involved in Testing of reports and worked with development team to optimize the Intelligence Server for better performance.
• Involved in testing complexTime Dimension and worked closely with data analyst team to help identify data relatedissues and analysis.
• Worked with Test Director to open the defects for the project.
• Tested multiple projects pointing to staging, testing and production data warehouse.
• Tested various Narrowcast reports, subscriptions and schedules.
• Tested various Report services and Dashboard documents on sales sent monthly to vendors.
• Validated various alert based services and Page Personalization Subscriptions.
• Performed data validation for Teradata Mload script and OLE Load for loading data into Teradata from various sources.

Environment: Data stage, WebSphere, Microstrategy, Oracle 8i, SQL Server 2005, QTP, Teradata, and JIRA, QC.