PROFESSIONAL SUMMARY:

• Over   8 years   of IT experience in Analysis and Testing of Business Intelligence solutions using Data Warehouse /Data Mart Design, Manual,   ETL , Web, UAT, Automation, OLAP, Backend, Client/Server applications.
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries and Oracle PL/SQL stored procedures to perform back - end testing.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Data stage using Oracle, DB2, Hadoop, MongoDB, Marklogic, NoSQL, Hadoop, Teradata and UNIX.
• Strong experience in testing Data Warehouse ETL tools (Informatica, Datastage, Ab Initio, SSIS and Mainframe) and Business Intelligence (BI) (Business Objects, Cognos, SSRS, SAS, Microstrategy, SAP and Hyperion) applications.
• Expertise in creating Test plan documents and Test strategy documents. Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Performed System Testing, Regression Testing, Performance Testing, end-end testing and Production Smoke Test.
• Planned, developed and conducted unit, function, integration, data quality and UAT tests
• Worked under various testing methodologies like   Agile-SCRUM   and   Waterfall Model .
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Experience in testing Full and Incremental loads through ETL tools on different environments.
• Expertise in   Defect management ,   Bug tracking ,   Bug Reports   and generating the graphs using Test Management Tools such as   Quality Center .
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes.
• Proficient in performing Smoke, Ad-hoc, Exploratory, Functional, Negative, Regression, Integration, System, Database, User Acceptance Testing (UAT), Security, Browser Compatibility, Installation, Participate Volume, Load, Stress and Performance testing.
• Involved in preparation of Traceability Matrix  based on High/Detail requirements and Test Cases.
• Experience in maintaining support documents, QA Sign off  Documents and maintaining Weekly status  Reports.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases.
• Have a good experience in functional testing tools such as SOAP UI testing & QTP Automation testing
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Created the test instances for the project in the Test Lab and Test Plan module of Quality Center.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Proficient in preparing reports with analyzing the defects with respect to metrics.

PROFESSIONAL EXPERIENCE:

Confidential, FL

Sr. QA Tester/Analyst

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested various ETL Informatica transformation rules based on log files, data movement and with help of SQL.
• Maintained the test logs, test reports, test issues, defect tracking using Quality center/ALM.
• Performed Web Services Testing and XML validation by creating test suite using SOAP UI for Security Application communication.
• Created and executed SQL and PL/SQL queries to perform Data Integrity testing on different Databases
• 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.
• Have a good experience in functional testing tools such as SOAP UI testing & QTP Automation testing.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Performed Functional, Negative, Smoke & Regression tests as per design specs.
• Coordinating with UAT for validation supporting Service Oriented Architecture (SOA).
• Tested several complex reports generated by Business Objects including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Verified the SOAP message delivery to the web services and verified the XML formatted response using the SOAP UI.
• Experienced in Business process testing (BPT) and automation testing using QTP UFT
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Written several complex SQL queries for validating Business Objects Reports.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center/ALM and generated the defect reports for review by the client and the management teams.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Business Objects
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: ETL Informatica, SQL, PL/SQL, SOAP UI, XML, Web Services, UAT, Oracle, Teradata, Teradata SQL Assistant, SAP FICO, Business Objects, Quality center/HP ALM, Selenium, MongoDB, Hadoop, Perl, Shell Scripting, SQL SERVER, TOAD, Java, QTP, DB2, UNIX.

Confidential, NC

 Sr. QA Tester

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Validated Data Stage logic by executing ETL Wrappers and Autosys jobs by using SQL and Unix Shell scripts
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Maintained the test logs, test reports, test issues, defect tracking using Quality center/ALM
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database, DB2, SQL Server to validate and test data using TOAD.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Performed   Functional, Negative, Smoke & Regression   tests as per design specs.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Tested   Full load & Incremental load   by entering the sample test data to couple of entities and making sure   Inserts & Updates   of loading the data is done correctly.
• Develop automated web service test scripts with SOAP UI to perform web service testing.
• Written several complex SQL queries for validating Cognos Reports.
• Tested Data stage Hashed files for extracting and write data - an intermediate file in a job.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: Oracle 11g, Cognos8.1, Quality center, Data stage 8.1.1, Selenium, Perl, UNIX, Agile, UAT, SOAP UI, XML, Web services, SQL SERVER, TOAD, Java, Quality center, Teradata, DB2, UNIX.

Confidential, NC

 Quality Assurance Test Engineer

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested various ETL Informatica transformation rules based on log files, data movement and with help of SQL.
• Maintained the test logs, test reports, test issues, defect tracking using Quality center/ALM.
• Created and executed SQL queries to perform Data Integrity testing on Teradata Database to validate and test data using Teradata SQL Assistant.
• 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.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Performed Functional, Negative, Smoke & Regression tests as per design specs.
• Tested several complex reports generated by Business Objects including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Written several complex SQL queries for validating Business Objects Reports.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center/ALM and generated the defect reports for review by the client and the management teams.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Business Objects
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: Oracle 11g, db2, Quality center 11, SQL SERVER,TOAD 11.0, Java, DB2, OBIEE, TAP, Guide wire, XML SPY, Informatica 9.5.1, Actuate reporting, Mainframe, File manager

Confidential, MA

QA Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata,
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Promoted Unix/Informatica application releases from testing to QA and UAT environments
• Strong Perl Scripting experience in writing conditionals, subroutines, Perl packages, OOP and Debugging in Perl.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Used TOAD Software for Querying ORACLE.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Tested all OBIEE Dashboards according to the requirement
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment: Informatica Power center 8.6 (ETL), OBIEE, HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER,SSIS, Toad for Oracle, ORACLE 10g, Unix, Autosys, Perl Scripting, Hyperion 8.5, Java, Windows XP.

Confidential, Atlanta, GA

Test Analyst

Responsibilities:

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Ab Initio components.
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.
• Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Mapped test cases to requirements using Quality Center.
• Involved in entering and tracking defects using Rational Clear Quest.
• Involved in communicating with support, business and development teams to resolve issues during test execution.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Tested the ETL graphs and other ETL Processes (DW Testing).
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Done data validations for Business Objects reports.
• Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
• Provided status reports on test execution, and defects identified during testing.

Environment: Oracle 9i, Toad, DB2, SQL, Ab Initio 2.12, PL/SQL, Business Objects, MS Visio, SQL Server 2003/2005, HP Quality Center, UNIX.