Professional Summary:

• 6 years of professional experience in manual testing on web based, Client/Server and data warehousing applications.
• Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate business reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC files, legacy data, and heterogeneous relational database systems.
• Experienced in working with Business Users, Business Analysts, IT leads and Developers in identifying and gathering Business requirements to further translate requirements into functional and technical design specifications.
• Worked extensively in UNIX AIX and Linux environment, used Shell Scripts for automating batch transfers, table space management, automated backup, user group maintenance, security and custom report generation. Database/ ETL/Reports testing -- Validated the data derived in the target table is adhering to the standards and business rules. Played major role in Test Data Creation and Maintenance. Verified if there are any downstream impacts in the warehouse
• Comprehensive knowledge of Ralph Kimball's data modeling concepts including Dimensional Data Modeling and Star/Snowflake Schema Modeling.
• Worked on Scripting languages like VB script and Python.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Procedure and sessions scheduling
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, SSIS, Data Stage Ab Initio
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded into staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Good experience in Cognos and Business Objects report testing

Technical Skills:

Confidential

ETL/DWH Test Analyst

Responsibilities:

• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Tested the messages published by Informatica and data loaded into various databases
• Tested the data load process using the Informatica Power Center.
• Generated/Tested reports using free-hand SQL which had complex Business Logics for testing environment.
• Was involved in analyzing scope of testing the application.
• Test Strategy was created to test the all modules of the Data Warehouse.
• Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly.
• Created the test data for interpreting positive/negative results during functional testing.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database.
• Ran various Batch jobs using telnet service Unix
• Automated the entire Aggregation module using Win Runner, for Regression Testing.
• Used Bugzilla and HP Quality Center for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in Oracle environment.
• Worked autonomously within a team of Data Analysts, to analyze, review, update, edit, clean, translate and ensure accuracy of customer data.
• Worked with Data Extraction, Transformation and Loading ETL .
• Performed System Integration Testing and Integration Testing between different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Developed Test Plan and Test Cases for the entire module of Data mart.
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Ran test cases for the warehouse in Oracle.
• Worked with drill down, prompts, hierarchies, calculations, formulas, sorts, drop down list, breaks etc in reporting and validated the same.
• Worked with business team to test the reports developed in Business Objects
• Tested whether the reports developed are as per company standards.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6/9.x, Oracle, SQL, PL/SQL, DB2, TOAD, , Windows XP Professional, Business Objects, Win Runner, Bugzilla, XML, XSD,Python,ALM Quality Center 11.0

Confidential

Sr. ETL/QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, data archiving, error log creations and log file cleanup process.
• Written complex PERL scripts for text processing, data parsing and database connectivity
• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading ETL .
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6.1/8.1, MLOAD, FLOAD, FEXPORT, BTEQ, TPUMP , Teradata SQL Assistant 7.0, Teradata V2R6.2, PERL, SQL, PL/SQL, DB2, Java, Cognos 8.0 Series, XML, XSTL, XSD, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra Editor, Quality Center 9.2, VSAM Files, MVS

Confidential

Sr. ETL Tester

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Extracted certain column of data from a number to files using PERL.
• Used PERL for automating all the types of modules at a time.
• Worked with PERL control structures Regular Expressions for substitutions based on matches.
• Worked with PERL for file manipulations
• Converted SQL queries results into PERL variable
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Informatica 7.1, XML, XSLT, XML Spy, Shell Scripting, PERL, Teradata V2R6, SQL Assistant 6.0.0, SQL, PL/SQL, Sybase, HTML, TOAD, UNIX, Clear Quest, Quick Test Pro, Quality Center, Load Runner

Confidential

QA Engineer

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Performed quality assurance reviews on all System Development Life Cycle.
• Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Developed automated test scripts using QTP to perform Functional and Regression testing.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Expertise in SQL queries for the cross verification of data.
• Tuned database and SQL statements and schemas for optimal performance.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Ab Initio GDE V1.12, Co>Operating System V2.12, Oracle 10g/9i, MainFrame via Web3270, Cognos 7.0, DB2 UDB, SQL, PL/SQL, UNIX AIX , Linux, PuTTY, WinSCP3, Mercury Test Director, Tivoli Workload Scheduler TWS for z/OS, XML, XSLT, XSD, PERL, Shell Scripting, VSAM