PROFESSIONAL SUMMARY:

• Over 13 years of Testing experience in Data Warehouse ETL, Reporting tools and Manual Testing on web based, Client/Server applications.
• Extensive knowledge of testing and validating Data warehouse data.
• Emphasis on GUI Testing, SOA Testing, Manual Testing, Black Box Testing, Backend Testing and
• Web based applications with various domains like Financial Services ( Confidential & Confidential )Public Sector, Telecom, Healthcare and Retail.
• Extensive knowledge of testing and validating Data warehouse systems
• Experience in all phases of Testing Lifecycle (SDLC and STLC) with expertise in the Integration and Functional, Input domain, Load Testing, User Interface, Sanity testing, Regression and Re - testing
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements
• Worked with Agile and Scrum methodology
• Experience in preparing test reports from ALM/Quality Center and prepared daily test status reports to communicate the test status with project team
• Hands on experience with DW- ETL Testing, BI Reporting tools Business ObjectsCognos and Microstrategy
• In-depth knowledge of Data warehousing concepts like Data Mart and Enterprises Data Warehouse(EDW)
• Worked with large scale Enterprises Data Warehouse(EDW) and Data Mart
• Expertise in Testing BI Reporting using tools Business Objectsand Cognos and knowledge on Microstrategy
• Extensive working knowledge in UNIX/Linux operating systems
• Extensive experience in developingSQLscripts to validate the databases tables and reports data for backend database testing
• Expertise in Testing ETL application using tools Informatica, Data stage and Abinitio
• Experience of ETL testing process including Type1 and Type2 and Type 3 changes
• Strong OLTP and OLAP Testing experience good knowledge on Star schema and Snow flex schema

TECHNICAL SKILLS:

Testing Tools: HP Quality Center (QC), TFS, Test Director, QTP(Test Automation) JiraDatabases: Oracle 8i/9i, 10g, SQL Server, Teradata

ETL Tools: Informatica, Data stage, Abinitio

Reporting Tools: Cognos, Business Objects and Microstrategy

Scripting Languages: JavaScript, Shell Script, Perl Script

Languages: C, C++, Java,.Net, VB

GUI Tools: Erwin, TOAD, Teradata SQL Assistant

Operation Systems: Windows, UNIX, Linux, Solaris.

EXPERIENCE:

Confidential

ETL Test Lead

Responsibilities:

• Understood the Mapping Requirement Document and System Requirement Specifications
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including DB2 and Flat Files and XML files
• Executed the ETL jobs sessions and workflows
• Test planning, writing test cases/scripts, for automation and test execution
• Validated the server logs for Ex stream server errors which are running on UNIX boxes by using Putty
• Followed proper STLC process and prepared Test Strategy and Test Plan documents
• Worked onWeb ServicesTesting usingSOAP UI
• Automated and scheduled the Informatica jobs by executing UNIX Batch jobs
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
• Perform Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes Wrote Complex SQL queries to verify report data with the source and target system (data warehouse)
• Preparing the SQL queries to fetch the data from databases using Informatica
• Involved in SOAP and Restful web services using SOAP UI
• Working with Fact and Dimension tables and Surrogate keys and version numbers
• Worked with Agile and Scrum methodology
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Validated the data against staging tables and warehouse
• Functionality, Interface, and Regression testing
• Installing and configuring QTP testing tools
• Identified test case for automation and developing automation test plans
• Tracked and managed defects usingQuality Center
• Extracted Loan level data from mainframe system and generated Loan level file
• Validated around 10 Million Loans and provided to CSS via Gateway
• Extracted data from multiple data bases and generated XML files (1.13.1C and 1.13.2C)
• Validated PC’s and SCR’s and provided to CSS via Gateway
• Used Autosys to execute the ETL jobs
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing activities
• Executed theAutosys jobs to generate XML files
• Connected remotely to UNIX servers using PUTTY and FTP files across different test environments
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables
• Reviewed Error log files in UNIX box when order fails to load into SQL tables
• Used HP Quality Center and ALM for storing, maintaining the test repository, bug tracking and reporting

Environment: DB2, Informatica Power Center, DB Visualizer 6.5.12, HP-ALM, UNIX, SOAP UI, Lotus Notes 8.5, BMC Remedy, Clear Quest, Doors, Ab-initio,Sybase, Mainframe, Autosys,ALM, Putty, XML, Flat Files, TIBCO, QTP, Quality Center, Doors

Confidential

ETL Tester

Responsibilities:

• Closely worked with Business Analysts to define testing requirements to satisfy the business objectives
• Wrote complex SQL queries to verify data from Source system to Target system
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Abinitio
• Analyzed application data using the SQL to identify the ETL processes
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Abinitio
• Good Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W
• Execute theETLjobs by using Autosys command for loading the data from Source to Target system
• Experienced in retest the existing test cases with the different kind of source systems for different periods of data
• Worked with different kind of sources like Oracle, Sybase, EUC Files and CSV files
• Used HP Quality Center and ALM for storing, maintaining the test repository, bug tracking and reporting
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes
• Worked with EUC, and CSV files as part of source data
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
• Perform Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Extensively use SQL queries for data validation and back end testing
• Working with Database Testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing

Environment: Ab-initio, Oracle 11g,Sybase, Autosys, Unix, ALM,SCD, Toad, DB Visualizer 6.5.12, Putty, XML, Flat Files, BMC Remedy,TIBCO, Clear Quest, Quality Center

Confidential, Columbia, SC

ETL Tester

Responsibilities:

• Understood the Functional Requirement Specifications and System Requirement Specifications
• Gathered the requirements and preparing the case generation
• Provided review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications
• Executed theETL jobs sessions and workflows
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities
• Performed Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Validated the Business Objects Reports against Data warehouse
• Verified the Business Objects Report functionality and Layout specifications based on report requirement document
• Closely worked with clients during User Acceptance Testing to validate their findings, and report defects for resolution
• Extensively used SQL queries for data validation and back end testing
• Functionality, interface, and regression testing
• Conducted Project Domain and Internal Project Functionality Training Sessions
• Extracted data from different source systems using Data Services tools
• Created the universe based on the Reporting specification document
• Prepared the SQL Server 2008 queries to fetch the data from databases

Environment: Business Objects, Informatica, .Net 4.0, ASP.net 4.0, SQL Server 2008, Web Methods and Web Services, Quality Center, File Zilla, Gecs, SQL Server Management Studio

Confidential

ETL Tester

Responsibilities:

• Wrote complex SQL queries to verify report data with the source and target system (data warehouse)
• Prepared the SQL queries to fetch the data from databases
• Worked with Fact and Dimension tables, Surrogate keys and version numbers
• Worked with Agile and Scrum methodology
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables
• Automated and scheduled the ETL jobs by executing UNIX Batch jobs
• Error log files in UNIX box when order fails to load into SQL tables
• Preparation of test scenario’s and test cases based on Mapping documents
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Validated the Summary and detail reports with drill down options
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities
• Validating the data against staging tables and warehouse
• Performed Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Performed system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance
• Worked with Clear Quest and Quality center for logging the defects, tracking the defects and resolving the defects
• Performed Interface and Integration(SIT) Testing
• Extensively use SQL queries for data validation and back end testing
• Functionality, Interface, and Regression testing
• Monitor Testing Activities within the team and report regular progress to the Test Manager

Environment: AB Initio, JAVA, Auto sys, Oracle, Doors, Share point, Quality Center, Clear Quest, UNIX

Confidential

Reporting Tester

Responsibilities:

• Worked with Enterprise Tax Management (ETM) V2.2
• Responsible for ETL batch jobs execution using IBM Tivoli application to load data from core database ( ETM database) to Staging and Data mart tables
• Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data
• Worked with Agile methodology
• Preparation of test scenario’s and test cases based on FD and TD documents
• Execution of Generating and validating the Cognos reports based on functionality
• Validated the Cognos Reports against Data warehouse
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Verifying the Cognos Report functionality and Layout specifications based on report requirement document
• Performed Interface and Integration(SIT) Testing
• Prepared the SQL queries to fetch the data from databases

Environment: ETM, Cognos, Data Stage, JAVA, Tivoli, Oracle

Confidential, Frankfort, KY

Reports Lead

Responsibilities:

• Executed theETL jobs sessions and workflows
• Performed Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica
• Validated the Business Objects Reports against Data warehouse
• Verified the Business Objects Report functionality and Layout specifications based on report requirement document
• Validated the Summary and detail reports with drill down options
• Closely worked with Clients during User Acceptance Testing to validate their findings, and report defects for resolution
• Extensively use SQL queries for data validation and back end testing
• Built deployment activities and participate in design (spec) reviews with the Core team
• Extracted data from different source systems using Data Services tools
• Created the universe based on the Reporting specification document
• Prepare the SQL Server 2008 queries to fetch the data from databases

Environment: Business Objects, Data Integrator, .Net 4.0, ASP.Net 4.0, SQL Server 2008, Web Methods and Web services, TFS, UNIX

Confidential

Sr. Tester

Responsibilities:

• Provided review comments on Test Scenarios and Test Cases based on Functional Requirement specifications
• Prepared Test Cases and Test Scenarios based on Functional Specification Document, Use Cases
• Performed Sanity Testing, Data Driven Testing & Ad-hoc testing as required
• Performed System Testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Experience with Verification and Validation of processed data
• Performed Interface and End to End Testing
• Performed User Acceptance Testing with UAT test scenarios
• Extensively used SQL queries for data validation and back end testing
• Found and reported defects and subsequently validated the fix, repeating the process until done

Environment: Informatica, Oracle 10g, UNIX, Java, J2EE, EJB, WebSphere6.0,Quality Center 9.2

Confidential

Sr. QA Analyst

Responsibilities:

• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document
• Performed data migration activities in informatica one version to another version
• Performed System, Functional, Interface and Integration Testing
• Performed Regression and Retesting
• Validated the data Source (CARES system) to Target (EDH system)
• Source to target data validation Field to Field verification
• Performed end to end ETL testing using Informatica ETL tool
• Created SQL queries to fetch and verify the data from Source and Target (Teradata)
• Involved in Build deployment activities and ran UNIX scripts
• Ran the ETL process from CARES to EDH (Teradata) in UNIX environment

Environment: Informatica 8.0, Business Objects 8.6, Oracle 10g, Teradata, Toad, UNIX, Quality Center 9.2, Java, EJB, WebLogic Server

Confidential

QA ANALYST

Responsibilities:

• Performed Sanity Testing, Data Driven Testing& Ad-hoc Testing when required
• Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance
• Performed User Acceptance Testing with UAT test scenarios
• Extensively used SQL queries for data validation and back end testing
• Functionality, Interface, and Regression testing
• Tracking and managed defects usingQuality Center

Environment: Quality Center(9.2),Java,JSP,EJB,Teradata,Toad,WebLogic Server

Confidential

QA ANALYST

Responsibilities:

• Created Test Cases using the SDLC procedures and reviewed them with the Test lead
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references
• Validated the external data source by connecting through Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation
• Validated the reporting objects in the reporter against the design specification document
• Validated the data files from source to make sure correct data has been captured to be loaded to target tables
• Validated the load process of ETL to make sure the target tables are populated according the data mapping providing it satisfied the transformation rules
• Validated the Archive process to purge the data that met the defined business rules
• Performed data migration activities in informatica one version to another version
• Retested the modifications, once bugs were fixed after reinstalling the application
• Reported the bugs through email notifications to developers using Mercury Quality Center.

Environment: Informatica 7.1.4 and 8.1 Power Center, Oracle 8i, DB2, Toad, UNIX, Mercury Quality Center

Confidential

QA ANALYST

Responsibilities:

• Documented test scenarios and test cases
• Prepared ETL and SQL routines/code for performance ETL testing (system and Integration testing)
• Verified report data with source, field level data verification
• Experienced with data migration testing, data validation testing
• ETL tool testing & data integrity testing

Environment: Informatica 8.1, oracle 9i, PL/SQL Developer, UNIX.

Confidential

QA ANALYST

Responsibilities:

• Worked on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor
• Created the Mappings Using Transformations like Expression, Router, Filter, Normalizer, Sequence Generator, Joiner, Lookup, Sorter and Aggregator
• Derived facets by analysis of the text of an item using entity extraction techniques
• Tested the Performance of Mapping and was responsible for design, development and Test Cases

Environment: Informatica 7.1.2 (Power Connect, Power Mart, Power Center, Designer, Workflow Manager,Administrator and Repository Manager), Oracle 9i, PL/SQL, TOAD, Business Objects 6.5, UNIX.