PROFESSIONAL SUMMARY

• Around 8 years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications.
• Experience in using DQE (Ab Initio>>Express IT) tool for validating issues in the input data against the data quality metrics such as Completeness, Conformity, Consistency and provide data quality results to Business.
• Creating validation rule sets based on the key data elements (KDES) provided by the subject matter experts related to the project.
• Has knowledge in defect tracking tools JIRA, TFS,
• Experience in Back End Testing by writing and executing SQL Queries.
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Having good Experience on DVO  in informatica 
• Extensive experience with Reporting Tools like OBIEE , Cognos, Business Objects 
• Experience in data visualization tools (Tableau, QlikView, Birst, and/or Crystal Reports).
• Extensive ETL testing experience using Informatica 8.6.1/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience on working with different models such as star and snowflake and strong working knowledge in dimensional modeling.
• Experience in testing Dimension and Fact tables in a data warehouse.
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE and Micro strategy.
• Experience in data analysis and data testing and verifying fields present in the reports are as agreed in the ETL specification.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Extensive experience in testing reconciles (initial) and delta (daily) loads.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.
• Worked on issues with migration from development to testing for different data loading jobs.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in all phases of Software Development life cycle.
• Experience in Data warehousing projects related to Banking, Pharmaceutical and Insurance.
• Performed Unit, Integration and System Testing.
• Good analytical and problem solving skills.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter, Informatica DVO, Ab Initio CO>OP 2.14, GDE 1.14, Robort job Scheduler, Data Stage 8.x.

Reporting Tools: OBIEE 12.2.1, Micro strategy 9.5.x, Business Objects6.5, Cognos 8 Suite

Testing Tools: Test Director, and Mercury Quality Center 10.0, ALM, Clear quest defect tracking (CDTS)

RDBMS: Teradata, Oracle 9i/8i/7.x, DB2, MS SQL Server 6.5/7.0, 2000, SQL Server 12.0/11.x, MS Access 7.0

Query tools: Teradata SQL Assistant, Advanced Query tool(AQT),SQL developer.

Web Technologies: JavaScript, HTML 4.0, and DHTML, Jmeter, Java, J2ee

Other Tools: Harvest, Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prarie, MN

Data Quality/ETL Tester

• Utilized DQE (Ab Initio>>Express IT) tool for validating issues in the input data against the  Data quality metrics such as Completeness, Conformity, Consistency and provided data quality results to Business
• Created validation rule sets and specified input dataset and the issue codes based on the Key data elements (KDEs) provided in the FSD for data quality validation.
• Created, tested and ran the application configuration to compile the list of data quality issues and compute data quality metrics.
• Published the results of the run to the Metadata hub.
• Documented the steps for simple and complex business rules validation using DQE tool.
• Prepared extensive sets of test cases based on the mapping document for validating the data for different transformation rules as well as straight moves for ETL testing.
• Validated the mapping document for its completeness.
• Executed the test scripts utilizing the Terada sql Assistant tool and verified the actual results against the expected result.
• Used Clear Quest Defect tracking system (CDTS) to log, track and report the defect for ETL testing.
• Performed DDL, Smoke, functional, retesting, regression testing and production testing in the Mart as well as Semantic layer for data load from source to target with different transformation rules.
• Attended day to day status update meeting and co-ordinated with the ETL development team, Semantic development team and representative from business to resolve any issues and discrepancies.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in communication with different team members regarding any issues found for the identification of root cause, its analysis and resolution.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Validated the potentially impacted downstream data mart for any upstream Code changes for a project.
• Performed different validation for Home lending valuation data, divested loan data and Express >>IT tool.
• Provided the results for the data quality validation using DQE tool to the Business on a monthly basis.

Environment: Teradata, Teradata SQL Assistant 15.0, Ab Initio, Ab Initio>>Express IT 3.0.1(ACE, BRE), Metadata hub, Control-M, Clear Quest Defect tracking system (CDTS), Harvest, SQL.

Confidential, Indianapolis, IN

ETL/QA Data Warehouse Tester

• Prepared extensive set of validation test cases to verify the data
• Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
• Validating OBIEE  dashboards based on business requirements and sharing results with users during UAT. 
• Written Test Plan, Test Strategy, Test Summary Reports, Governance report, Test Script, Test Cases, Reported bugs and tracked defects using Microsoft visual studio TFS.
• Used automation tool Informatica DVO to perform data validation of all the columns while migration/regression. 
• Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
• Performed the Extract Transform and Load (ETL): source to target, utilizing Informatica Power center and Data Validation Option (DVO).
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Tested -reports, Dashboards and other functionality within the OBIEE  suite. 
• Involved Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems.
• Execute and analyze complex test cases and compare the results with expected results and product requirements.
• Execute testing as per test plan. Document, maintain and communicate process, procedure, findings and test results in TFS/Test Manager
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Tested all OBIEE  Dashboards according to the requirement 
• Tested the different sources such as Flat files, Tables to load into the Teradata data warehouse.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Used Informatica DVO to perform same-to-transformed Validation (i.e., before and after an ETL move/transformation) and production data validation testing (nightly updates of applications and data warehouses) 
• Involved in data warehouse testing by preparing and executing ETL scripts.
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested application and filed defects using Quality Center/ALM and TFS. 
• Experience in loading from various data sources like Tables, Fixed Width and Delimited Flat Files.
• Involved in Data Extraction from Teradata and Flat Files using Sql assistant.
• Involved in extensive DATA validation using SQL queries and back-end testing

Environment: ALM/HP Quality Center, Informatica, Informatica DVO, OBIEE, PL/SQL, TFS, MS SQL Server, UNIX, Oracle, SQL, Flat Files, Teradata, Teradata SQL Assistant 12.0, UNIX.

Confidential, Wilmington, DE

Data Warehouse Tester

Responsibilities:

• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Developed test plans based on test strategy. Created and executed test cases based on test plans and based on ETL Mapping document.
• 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.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Promoted Informatica(DVO) application releases from development to QA and to UAT environments
• Involved in validating the reports layouts in OBIEE based on Report Layout Document 
• Involved in test planning, writing test cases/scripts and test execution.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases. Verify defects and Perform database functional, integration and regression testing as needed to minimize defects.
• Performed data validation on Teradata using SQL Assistant and BTEQ. Improved query performance.
• Design and execute the test cases on the application as per company standards.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Written SQL queries to validate the reports generated from OBIEE. 
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.
• Interacted with Customers and Associated Organizations, documented for UAT.
• Ensured that the mappings are correct and effectively communicate testing activities and findings in oral and written formats.
• Validated data moving from different sources to target using Informatica data validation option (DVO)
• Performed extensive data validations against Data Warehouse
• Worked with ETL group for understating mappings for dimensions and facts.
• Performed database validation by executing SQL queries. Interacted with Developers as needed to isolate the main cause of defects and performed SQL backend testing too.
• Worked on issues with migration from development to testing.
• Extensively tested several OBIEE reports like pivots, charts, tabular and ad hoc reports.

for data quality, fonts, headers & cosmetic.

Environment: Oracle 10g,SQL, Quality Center, Informatica, Informatica DVO, PL/SQL, OBIEE Reports, Jmeter, MS SQL Server, Teradata 12.0,TFS, Teradata SQL Assistant, Flat files, UNIX.

Confidential, Madison, W

ETL /QA Tester

• Involved in developing detailed test plan, test cases and test scripts for Data warehouse and ETL testing.
• Developed test scripts using SQL queries to validate data.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Extensively performed both the functionality and backed testing as a QA tester.
• Extensively executed SQL queries using AQT in order to view successful transactions of data and for validating the data.
• Logged and tracked defect using Quality Center and communicated the defect status to the team.
• Worked closely with the members of ETL development team to identify the root cause of the issue and retested to make sure the issue is fixed.
• Involved in functional testing, retesting, regression testing, UAT testing for all the ETL process.
• Used Robot job scheduler to run the jobs and validated the status of the job run.
• Validated the archival of the input file post job run.
• Validated the error reporting process to see if the rejected records are recorded into the reject file with proper reject reasons.
• Involved in testing the UI application for the same project.
• Analyzed the functional requirements for the UI application and prepared and executed the test scripts for the same.
• Used ALM to track and report defects and provide the defect status.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Attended daily status meeting and on demand STT review meeting.
• Prepared test data and test scenarios based upon the requirements.

Environment: DB2, Robot job Scheduler, API, SQL, UNIX, Oracle, SOAP UI, Advanced Query tool (AQT), UNIX, .Net, Quality Center, XML, Windows XP, Flat files

Confidential, Oakbrook, IL

QA/SQL Tester

• Involved in Preparing Test Plans, Test Scenarios and Test scripts for ETL and Reports testing.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Used Informatica workflow manager to run the workflows and workflow monitor to check the status of workflows.
• Written complex SQL queries for each level of data validation.
• 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, and Regression Testing.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Involved in day to day meetings both on site and off shore teams providing the day to day updates on the testing schedule.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Have tested historical and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Performed Data Comparison, Database Validation, Report Validation and System testing as part of QA validation.
• Involved in logging and review of defects in CDTS for defect prevention and analysis.

Environment: Oracle, CDTS, OBIEE, JIRA, Informatica, Windows 2007, TOAD, SQL, SQL Server, Excel.