Summary

• Over 7 years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support.
• Hands on experience with all phases of Software Testing Life Cycle STLC
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Ab Initio and Data stage using Oracle, DB2, Teradata and UNIX.
• Strong experience in testing Data Warehouse ETL and Business Intelligence BI 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.
• Good exposure with databases like Oracle 11g, DB2, SQL Server 2008
• Performed System Testing, Regression Testing, Performance Testing, end-end testing and Production Smoke Test.
• 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 the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Strong experience in script developing for QTP using VB script.
• Experience in maintaining Full and Incremental loads through ETL tools on different environments..
• Experienced in Defect Management using Mercury Test Director, HP Quality Center
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Worked with different data sources ranging from VSAM files, flat files, DB2, oracle and SQL Server databases.
• Experience in debugging the issues by analyzing the SQL queries.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Experience with testing reporting tools Cognos/Business Objects .
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Good expertise in using TOAD, SQL Plus and Query Analyzer.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Write, execute and troubleshoot test scripts in QTP.
• 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.
• Excellent understanding of Relational Database Management System RDBMS
• Experience in preparing reports with analyzing the defects with respect to metrics.
• Designed the Data Driven tests in Quick Test Professional QTP script to validate with different sets of test data.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Experience in release management and defect control management.
• End to End responsibility to close the defects and fixes.
• Hand on experience in testing the ETL process using ODI Oracle Data Integrator , Informatica and reporting and analysis tools such Business object, Oracle OBIEE, Hyperion.

TECHNICAL EXPERTISE:

WORK EXPERIENCE:

Confidential

Data Warehouse/BI Test Engineer

Responsibilities:

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Developed Informatica test environment for UAT testing and used all Informatica components while testing the graphs and ran the jobs on back ground.
• Reported software mismatches from the test planning , to the development team using Quality Center
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions, Totals Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Executed test cases, and test scenarios for User Acceptance UAT , Functional and Regression test cases.
• Reviewed unit test cases and test results and certified the code for Integration testing
• Tested the ETL Informatica graphs and other ETL Processes Data Warehouse Testing
• Created user acceptance testing documents and reviewed them with the customer.
• Mapped test cases to requirements using Quality Center.
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing.
• Involved in entering and tracking defects using Rational Clear Quest.
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings
• Tested initial and daily loads for various Informatica graphs.
• Work with data warehouse QA team to implement Informatica's Data Validation Option tool and adopt best practices for its use.
• Wrote various documents describing DVO functionality, and how DVO should be used by group based on discussions with team lead.
• Served as subject matter expert with regard to creating DVO tests for complex testing scenarios.
• Reviewed numerous sets of DVO tests created by QA team for correctness, completeness, efficiency.
• Validated by entering Test Data using front end Lawson Payroll System to reflect the changes made for Inserts and Update Scenarios backend as per mapping rules.
• Gained extensive knowledge on data validation option DVO
• Implemented Data Validation Option DVO for understanding on how to run tests, and evaluated the test results.
• Designed DVO informatica test cases for source and target db validation.
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools Validated several SSIS and SSRS packages to verify that they are working according to BRS.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Tested the functionality of Ab Initio graphs.
• Tested the ETL graphs and other ETL Processes DW Testing .
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• 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.
• 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.
• Executed the Test cases for Micro Strategy
• Created Test input requirements and prepared the test data for back end testing.
• Validated Cognos Standard Reports created based on Frame work manager and Cube.
• Involved in testing the reports and UI screens containing those reports.
• Provided status reports on test execution, and defects identified during testing.

Environment: Ab Initio 2.12, Micro Strategy, HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER,SSIS, Toad for Oracle, ORACLE 11g, Unix, Autosys, C , .Net, Perl Scripting, Hyperion 8.5, Java, Windows XP.

Confidential

Data warehouse Tester/ETL 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.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center 9.2.
• 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
• 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 to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• 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.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Done data validations for Business Objects reports.
• Test the data which loads Weekly and Monthly.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata,
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Written several complex SQL queries for validating Cognos Reports.
• Good experience in validating the Adhoc and OLAP cube
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Participate in weekly meeting with the management team and walkthroughs
• 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: Oracle10g, , Business Objects, Quality center 9.2, Informatica Power center 8.6 , Perl, Windows NT/2000/XP,SQL SERVER 2008,.NET,TOAD, Java, Quality center 9.2, QTP, UNIX.

Confidential

Data warehouse Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Extensively used Data Stage for extraction, transformation and loading process.
• Worked with ETL group for understating Data Stage.
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Built a library of test cases for regression testing and automated them using QTP
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing designing and development of Data warehouse environment.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Written and executed the functional and regression test script using Test Script QTP.
• Involved with ETL test data creation/Identified for all the ETL mapping rules.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested Data stage Hashed files for extracting and write data - an intermediate file in a job.
• Report testing: Extensive experience with Reporting Tools like OBIEE.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Involved in extensive DATA validation on data marts by using SQL queries.
• 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.
• Extensively tested several Hyperion reports for data quality, fonts, headers cosmetic
• Validated Business Objects reports by running the SQL queries based on the business rules.
• 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.
• Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment: Data stage 8.1.1 ETL , Oracle 9i, Toad, DB2, SQL, OBIEE, PL/SQL, Business Objects, MS Visio, SQL Server 2003/2005 SSIS, SSRS, HP Quality Center, UNIX.

Confidential

QA Engineer

Responsibilities:

• Develop test plans based on BRDs and Technical Specifications.
• Created and executed test cases based on test strategy and test plans based on business requirement documents and ETL design documents.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
• Extensively used Informatica Workflow Manager to run the workflows.
• Preparation of technical specifications and Source to Target mappings.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Strong Perl Scripting experience in writing conditionals, subroutines, Perl packages, OOP and Debugging in Perl.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Used Data Stage Director to run the ETL mappings and monitor the status.
• Creating test cases for ETL mappings and design documents for production support.
• Extensively used Informatica for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively tested several Crystal Reports and Hyperion reports for data quality, fonts, headers cosmetic.
• Participated in review meetings for defect status, priority and information exchange.

Environment: UNIX, Informatica, Perl Scripting, Mercury Test Director 6.5, SQL Loader, Crystal Reports, Hyperion Reports, Oracle 9i, SQL Server 2003, Java.