SUMMARY

• Possessing 8+ years of Professional Experience in IT Industry
• Over 8+ years of rich experience in Data Warehousing/ETL/Report/Database Testing on Ab - initio, Datastage, Informatica, Cognos, Business Objects (BO),Teradata, Oracle, SQL server & DB2
• Experience in writing Test cases based on Business Requirements and Technical Specifications
• Good experience on Insurance, Banking (AML), Healthcare (claim) and Telecom (billing) domains
• Experience in writing complex SQL queries for data validation of bothETLand BI Reports testing
• Proficient in developing SQL queries for Oracle, Teradata and DB2 databases to conduct DB testing to perform data driven tests and involved in back-end testing
• Strong knowledge of working with Data Warehouse and Data Marts
• Extensive experience in reviewing and understanding Business & Testing requirements and writing detailed Test Plans, Test Cases, and Test Scripts for Smoke, System, Regression, End to End and User Acceptance Testing
• Have strong knowledge in Quality Center in writing test cases, plans, uploading test cases etc
• Generated Test Reports and Defect Reports from the QC/ALM for the Test Summary Reporting
• Involved in test data management activities and extensively worked on mapping documents
• Performed Positive and Negative testing
• Good experience with Data profiling
• Involved in extensive data validation using MS SQL queries and back-end testing
• Worked on validating data counts and Referential Integrity running SQL server scripts
• Extensive experience working with Slowly Changing Dimensions
• Good experience in AML (Anti Money Laundering) projects
• Sound understanding of Dimensional Modeling - Star and Snowflake Schemas
• Experience in Functional Testing, System Testing and Regression Testing
• Good experience in Agile SDLC, Continuous Integration, and Continuous Deployment
• Good experience in Performance testing, Functional Testing and Reports Testing
• Familiarity with Business Intelligence multi-dimensional modeling concepts
• Experience in Co-coordinating testing activities with Onsite QA Team during different testing phases like Smoke testing, System integration and UAT Testing
• Good experience in defect tracking tools like Rational ClearQuest and Quality Center
• Good knowledge on programming technologies like C, C++,Core Java & HTML
• Good amount of knowledge on Netezza database
• Extensive experience in validating the pre-run, Adhoc reports and Cubes in Cognos
• Strong knowledge on SAP tools like SAP BODS and HANA
• Good knowledge on Salesforce
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat)
• Good experience in delivering complex enterprise application systems, distributed systems
• Good experience in managing onsite and offshore resources and coordination with multiple stakeholders
• Excellent analytical, problem solving, communication, technical, multi-tasking and a motivated team player with excellent inter-personal skills
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products
• Good communication and good personal relationship with Client

TECHNICAL SKILLS

ETL Tool: Ab-initio 3.0,DataStage 7.5x2,Informatica 7.1, BODS 4.1

Reporting Tool: Cognos 10, Business Objects XI R2

Database: Oracle 9 & 10g, Teradata 14.0, db2, SAP HANA SP5SQL Server 2005/2008/2012 , MS Access, Netezza

Software Tools: Teradata SQL Assistant, dn Director, Control M, Autosys

Defect Tracking Tool: Quality Center 10.0, Rational ClearQuest, ALM 11.5

Operating Systems: Unix/Linux, Windows Vista/NT/XP/2000

PROFESSIONAL EXPERIENCE

ETL Test Lead

Confidential

Responsibilities:

• Involved in project meeting and identify testing scope
• Provided test estimates based on the requirement
• Developed test cases for various lines of businesses based on Business Requirement Document (BRD), ETL mapping document and also covered the linkages and relationships between various source systems
• Prepared a test plan and given a walk through to the Managers, business and dev teams
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files using Informatica and provide technical support
• Developed Test Cases and PerformedManualTesting like Positive Testing, Negative Testing and Black Box Testing.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Writing the SQL queries to validate the Aggregate data.
• Performed data validating in BO reports
• Given walk through on test result documents to application support team before deploying the project in production
• Facilitated integration testing for various configuration, designed user test scripts and documents for UAT.

ETL/BI Tester

Confidential, NY

Responsibilities:

• Developed test cases for various lines of businesses based on Business Requirement Document (BRD), ETL mapping document and also covered the linkages and relationships between various source systems
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files using Ab-initio and provide technical support
• Developed Test Cases and PerformedManualTesting like Positive Testing, Negative Testing and Black Box Testing.
• Generate the source extracts by using dn:Director and validate the source extracts
• Executed AbInitio Graphs from the back end for Data extraction, transformation and loading process.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Writing the SQL queries to validate the Aggregate data.
• Performed data validating in Cognos reports
• Facilitated integration testing for various configuration, designed user test scripts and documents for UAT.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab-initio graphs
• Tested the ETL Ab-initio graphs and other ETL Processes (Data Warehouse Testing)
• Involved in validating the records after successful completion of jobs.
• Executed the test cases and reported bugs through defect tracking tool
• Involved in defect review meetings with the development team

Environment: Ab-initio 3.0, Cognos 10, Teradata 14.0, UNIX, Quality Center 10.0,dn:Director

ETL/BI Tester

Confidential, NY

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Analyze the data in EDW and all the Systems in Information systems area where BI Analysis and Reporting is performed.
• Create clear and concise QA test documentation and status reports.
• Identification of scenarios for the Requirements.
• Create test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered.
• Run the dn:Director jobs to generated the source extracts in UNIX
• Validated source extracts files generated in UNIX by using dn:Director
• Executed AbInitio Graphs from the back end for Data extraction, transformation and loading process.
• Involved in System Testing, Integration and Regression testing for executing scripts (built in Ab Initio tool) through UNIX environment
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source extract.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Checked the naming standards, data integrity and referential integrity
• Performed data validating in Pre-run, Adhoc Cognos reports
• Performed Cognos cubes validation for Aggregate tables.
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in validating the records after successful completion of jobs.
• Executing the Test cases and reporting the bugs through defect tracking tool.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Involved in defect review meetings with the Development team.
• TEMPEffectively communicate testing activities and findings in oral and written formats

Environment: Ab-initio 3.0, Cognos 10, Teradata 14.0, UNIX, Quality Center 10.0, dn:Director

ETL/BI Tester

Confidential

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Identification of scenarios for the Requirements
• Prepared the test conditions and test cases as per the requirements
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs
• Run the UNIX script from the back end to load the data into the Teradata target tables
• Involved in the error and duplicates checking post successful completion of ETL script.
• Involved in validating the records after successful completion of script.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in Pre-run, Adhoc Cognos reports
• Performed Cognos cubes validation for Aggregate tables
• Responsible for running and analyzing quality check reports to ensure system is functioning properly
• Executing the Test cases and reporting the bugs through defect tracking tool
• Involved in defect review meetings with the Development team

Environment: Cognos 8, Teradata 12.0, UNIX, Quality Center 10.0

ETL/BI Tester

Confidential

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Analyze the data in EDW and all the Systems in Information systems area where BI Analysis and Reporting is performed.
• Prepared test schedules with inputs from Project manager and development team
• Create test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Identify automation opportunities for all phases of the project.
• Validate source extracts files generated in UNIX by using dn:Director
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs
• Execute AbInitio Graphs from the back end for Data extraction, transformation and loading process.
• Check the naming standards, data integrity and referential integrity.
• Validated the data files from source to make sure correct data has been captured to be loaded into the target tables.
• Verify the alerts are generated as per the BLU rules present in the Fortent system
• Executed the test cases and reported the bugs through defect tracking tool
• Involved in validating the records after successful completion of jobs
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in Cognos reports
• Responsible for reporting and escalating data issues arising from project or daily support
• Assisted in creating test data and test cases and execute function system tests as needed
• Performed Black box Testing, Regression and end-to-end testing
• Involved in defect review meetings with the Development team

Environment: Ab-initio, Fortent, UNIX, Quality Center 10.0, dn:Director, Cognos 8

ETL/BI Tester

Confidential

Responsibilities:

• Analyzing the system and customer requirements
• Understanding the billing details and generate flat files from telecom billing application
• Identifying business rules and processing logic and creating and defining requirements to be used across all inbound interfaces.
• Prepared several test scenario for the work flow of the entire ETL cycle
• Prepared test conditions and Test Cases for modules assigned
• Executed DataStage jobs for Data extraction, transformation and loading process
• Executed Abinitio jobs for Data extraction, transformation and loading process
• Validated the reject and duplicate records post successful completion of DataStage and Abinitio ETL jobs
• Involved in validating the records after successful completion of jobs.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in BO reports
• Execute Test cases and reporting the bugs through defect tracking tool
• Involved in different test execution - Smoke, System, Regression and End to End
• Traced many critical defects in different testing phase(Smoke, System, Regression and End to End)
• Performed detailed analysis of data issues encountered during User acceptance testing
• Involved in defect review meetings with the Development team

Environment: Ab-initio, Datastage 7.5, Teradata 14.0, Business Objects XI R2

ETL Tester/Support

Confidential

Responsibilities:

• Understand business model and customer requirements
• Designed Informatica mappings for validating and loading data
• Created test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Extract data from sources such as oracle, Flat files to transform and load into target databases
• Designed and developed the ETL mappings in Informatica for moving data from legacy systems to Data Warehouse
• Developed jobs for incremental loading
• Validate the data which is loaded into the target tables after the successful completion of Informatica ETL jobs
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Used Control M to monitor the Informatica jobs in production
• Involved in unit testing of Informatica mappings
• Responsible for reporting and escalating data issues arising from project or daily support

Environment: Informatica 7.1, Oracle 9i, QC 9.2

ETL Tester

Confidential

Responsibilities:

• Understanding the client requirements related to healthcare plans by studying functional documents
• Created test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Executed Informatica and DataStage jobs for Data extraction, transformation and loading process
• Executed the test cases and reported the bugs through defect tracking tool
• Involved in validating the records after successful completion of jobs
• Wrote SQL queries to validate the Aggregate data
• Involved in defect review meetings with the Development team

Environment: Informatica 6.0, DataStage 7.5x2, SQL Server 2005, Oracle 8, QC 9.2

ETL Tester

Confidential

Responsibilities:

• Understood the business process that included sales processes, Rating methodology, different Products, Group Renewals and Enrollment process
• Performed Smoke Testing, End to End Functionality Testing, Regression Testing, Integration Testing and user Acceptance Testing (UAT)
• Designed and documented Test Procedures, Test Requirements, Test Scenarios and Test Cases for End to End functionality testing
• Extensively involved in testing Subscriber, Billing, Claims and Dental modules
• Validated source extracts files generated in UNIX
• Executed Informatica and DataStage jobs for Data extraction, transformation and loading process
• Executed the test cases and reported the bugs through defect tracking tool
• Verified bug fixes, generated and written clear and concise defect reports
• Involved in validating the records after successful completion of jobs
• Written SQL queries to validate the Aggregate data
• Involved in defect review meetings with the Development team

Environment: Informatica 6.0, DataStage 7.5x2, SQL Server 2005, Oracle 8, QC 9.2