Professional Summary:

• 7 years of IT experience in Software testing on data warehouse, client-server, web based and Database applications.
• Experience in all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Excellent understanding of SDLC. In depth knowledge of development methodologies.
• Highly skilled in ETL testing with Informatica, Ab Initio, DataStage, UNIX Shell Scripts, Teradata, Oracle, SQL, PL/SQL, SQL Loader, SQL Server.
• Enormous technical and functional expertise in Data modeling using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data modeling and OLTP systems
• Superiorly well versed in the art of oral communication in coordinating technical issues between Testers and Developers.
• Diversified experience in Manual and Automated testing extensively used automated Testing Tools such as Mercury Interactive Test suite in both Windows and UNIX environment Win Runner, QTP, Quality Center and Test Director .
• Involved with risk categories for SOA including Testability, Functionality, Interoperability, Performance, Security and Compliance
• Proficient at performing data analysis and Excellent understanding of data management
• Experience with implementing and operating software control management, automated build management and automated testing
• Experience with Agile Methodology.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports.
• Very strong knowledge of RDBMS and Data Warehousing Design Concepts
• Expertise in understanding Business Requirements, Functional Requirements, decomposing them into HLD's and ETL Specifications into Test Cases for positive and negative test conditions.
• Experienced in writing Test Plan, Test Scripts and working with Quality Center.
• Vast Experience in various testing techniques including system, parallel, data base, performance, smoke and User acceptance testing.
• Involved in Sprint Planning meetings, Requirement Review meetings, weekly Bug tracking meetings and Status meetings
• Worked on complex SQL queries for data validations and data verification for both ETL and BI testing.

Skills Summary:

• Toolsets: Informatica 8.6.1/8.1/7.1/6.X, SQL DTS, Telelogic Synergy, Mercury Test Director
• Database: Oracle 8i/9i/10g, SQL Server 7.0/2000/2005, Teradata 6x/5x, MS Access
• Tools/Utilities: TOAD, SQL Plus, MS Visio, Teradata SQL Assistant, Erwin, VSS, Autosys, Control-M
• Languages: SQL, T-SQL, PL/SQL, Visual Basic 6.0, VBA, Excel, Access, C/C , XML, XSLT, XSD
• Platforms: Windows, IBM AIX, HP-UX, Linux
• BI Tools: Business Objects 6.5/XIR2, Cognos 7.3/8.0 Series, SQL Reporting Services, Crystal Reports

Professional Experience:

Confidential

DW Test Analyst

Roles Responsibilities:

• Participated in Daily Standup Meetings, Defect Review Meetings and Monthly Business Meetings.
• Participated in Business Analysis, Technical Requirements and High level System Design Document Reviews.
• Worked closely with the Source System team Claims team to understand the scenarios to test the production defects.
• Used HP Quality Center as the Test Management Tool to create and execute the test cases and to track and report defects.
• Worked in Agile environment and Lean Application Maintenance.
• Participated in defect prioritizing meetings with downstream partners and source system team.
• Involved in testing the production defects in monthly releases.
• Used Teradata SQL Assistant to query data in stage and target databases in Data warehouse.
• Written SQL to validate the scenarios for each production defects.
• Verified if the Expected Results match the Actual Results and if not opened up defects in HP Quality Center.
• Involved in the preparation of Test Plan, Defect Status Reports and Flow Tracking Document.
• Involved in doing the Post- production validations on the data ware house and also supported the production support teams during the production implementation of various projects.
• Prepared Traceability matrix document mapping with requirements and Test cases using Quality Center.
• Review the scenarios given by source system team and if needed request additional scenarios to test the production defects.
• Prepared test data based on exact definition of defect for positive testing and exact opposite definition of defect for negative testing .
• Verified that a new fix does not break or impact existing functionality
• Identified and log defects when a test fails and used SQL to narrow down the root cause of the problem for efficient investigation by the development team
• Attended weekly project update meetings to discuss about the progress of the testing.
• Ensure that the test cases are designed in compliance with established quality standards and meeting the requirements.
• Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data ware house.
• Developed Positive and Negative Test Data based on business requirements and Source to Target S2T mapping document to make sure all the business rules are covered.

Environment: Informatica 9.0.1, HP Quality Center 11.0, SQL, Teradata SQL Assistant 13.11, SQL Plus,SQL Developer, MicroStrategy 9, MS Office 2007, Windows 7

Confidential

ETL/Integration Tester

Roles Responsibilities:

• Responsible for reviewing documents like test plan, Functional document, Technical Document and requirements Document to analyze the user requirements.
• Responsible for writing test cases for the interfaces based on the Specification document and the Source to Target Mapping Document.
• Usage of HP Quality Center to write test cases, to execute the test cases and to track the defects opened.
• Participated in Formal Reviews and walkthrough for preparing test cases.
• Written test cases for BCOE validations, Count Validations, Data Element Validations, Scenario Validations and Scheduling Validations for each interface and execute these test cases in HP Quality Center.
• Keep track of the defects opened in HP Quality Center and retesting the defects once they are fixed by the developer.
• Validate the data from the various source systems like RDBMS, XML files,text files and CSV files.
• Written queries and executed them in Oracle SQL Developer and Teradata SQL Assistant to validate data from Source systems to Target Systems.
• Analyzed the tables in Source database and validated the tables in the Target database as per the Transformation Rules mentioned in the Mapping Document.
• Involved in testing both Initial loads and Incremental loads for different interfaces.
• Worked on creating test data for both positive and negative scenarios.
• Participated in requirements review meetings, weekly defect tracking meetings and status meetings.
• Responsible for creating mock up files in EDI format ,apply the files in GIS Inbound folder and validate the translated CSV files as per the Mapping Document.
• Validate if the attributes in EDI files are populated properly in ODS as per the Mapping Document.
• Validate if the data in EDI files generated in the GIS outbound folder are matching with data in ODS as per the Mapping Doc.
• Validate the data in Target database systems like ODS and EDW.
• Validate the stage tables, error tables and master tables for different interfaces.
• Responsible for testing the changes to the interfaces.
• Written test cases scenarios for informatica Upgrade.
• Responsible for creating test data using front end applications and validate if the same data is sent to the backend databases.
• Worked on different retail domains like Sales,Inventory, Purchase Orders, Product and Location.

Environment: Informatica, HP Quality Center 9.2, SQL, Teradata SQL Assistant 13.10, SQL Developer 6.0, SQL Plus, XML, GIS, EDI,MS Office, Windows XP

Confidential

ETL/Data Warehouse Test Analyst

Roles Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed and kept track of Requirement Traceability Matrix
• Involved in writing the Test cases and Test scripts based on Source to Target Mapping documents and Data Model diagrams.
• Prepared testing strategy, testing schedule, test Cases depending upon the Requirement documents for integration and system testing.
• Wrote Test cases for Enterprise Data Warehousing EDW Tables and Data Mart Staging Tables.
• Written test cases and tested several test cases for SSIS Packages and for data flow.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• 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.
• Experience testing data conversions and migrations in cross platform scenarios with Informatica power center.
• Tested stored procedures and compared the results against ETL workflow.
• Verified results to ensure that they are aligned with the business objectives.
• Performed high-end data analyst with very strong database skills and SQL.
• Strong usage of HP Quality center management tool for a centralized control over entire project.
• Performed Functional, Screen flow and Work flow test scripts as per the user requirements.
• Tested Informatica mappings and workflows, PL/SQL procedures and worked extensively with Informatica for data sourcing, data transformation and data loading.
• Tested reports in Web Intelligence XIR3. Security implementation for WebI.
• Coordinated with the Developers regarding the Defects raised and Retested them against the application
• Developed data integration scripts and resolved data related issues during initial loads from different sources.
• Developed Excel models and templates to verify results and performed extensive data analysis and reconciliation.

Environment : Informatica 8.6.1, HP Quality Center 10.0, Putty, SQL PL-SQL, SQL Server 2008, SSIS, TOAD, Business Objects XIR3.1, MS Office, Visio, Perl, Shell Scripts, XML, XSD, Maestro 8.5, XML Spy 2010, Windows 2000/XP, UNIX, Shell Scripting

Confidential

ETL Test Engineer

Roles Responsibilities:

• Experience in documenting Functional, Technical Specifications and Test Cases.
• Responsible for developing test plans, testing strategy, test cases and execution of the complete test cycle for the backend for ETL and BI needs.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Tested complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Performed backend testing in Oracle /SQL Server My SQL database and analyzed the log files for different error codes for ETL processing.
• Wrote many SQL/PLSQL scripts to verify data in the DB and verify consistency with ETL mapping
• Wrote many SQL/PL-SQL scripts to verify data in the DB and verify consistency with Web Portal BI reports.
• Involved in testing Business Objects universes and reports for correct mapping of the objects and data correctness.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports

Environment: Informatica PowerCenter 8.1, Informatica Power Exchange, Oracle 9i, MS SQL Server 2005, windows, Mainframe, Quality Center 9.0, Rational Clear Quest, XML Files, XSD, XML Spy, Business Objects XIR2

Confidential

Roles Responsibilities:

• Designed and executed the test cases on the application as per company standards
• Written Test Cases for ETL to compare Source and Target database systems.
• Create Test plan and Test Cases to cover overall functionality of the application.
• Prepared ETL Test Data based on ETL mapping document
• Testing of records with logical delete using flags
• Interacting with senior peers or subject matter experts to learn more about the data
• Modified XML files to manipulate the data to fake the web services
• Provided excellent support during QA/UAT/Beta testing by working with multiple groups.
• Optimized the SQLs and Tested Informatica mappings which handled millions of records.
• Parameterized the automated scripts for running multiple sets of data
• Tested different ETL mappings and transformations
• Done database testing on Oracle, SQL Server, Teradata and MYSQL databases using SQL queries.
• Tested different Cognos cubes dimensions, measures by creating analysis on front end and verifying with SQL on backend
• Preventing occurrences of multiple runs by flagging processed dates
• Performed Black Box testing for testing all the business requirements and the System functionality
• Created test data in source application to run approved test cases
• Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.
• Read and understand the Log files to verify the processes for debugging and/or test data verification purposes.
• Regression Test Plan and Production Acceptance test plan for the test releases.
• Prepare and execute Test Cases for end-to-end functionality testing.
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed Functionality and Regression testing of source application , Cognos and Data integration
• Performed Ad-Hoc Testing for Cognos tool upgrades and ETL tool upgrades.
• Performed tests on various browsers for Cognos ReportNet reports.

Environment: Informatica 6.1, Cognos 7.0 Series, Mercury Quality Center 8.0, MS SQL Server 2000, Oracle 8i SQL, PL/SQL , TOAD, MS Access, QTP 8.0, Teradata V2R5, Teradata SQL Assistant, XML, J2EE, UNIX, Shell Scripting