PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC).
• Strong experience in writing the Test Plans, Test Cases & Test Scripts based on business requirements, mapping documents and system specifications.
• 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.
• Experience in Back End Testing and Data Warehouse Testing by writing and executing SQL Queries.
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate data and reports and troubleshoot data quality issues.
• Experience of using ETL tools like Informatica power center, Ab Initio, scheduling tools like Robort job Scheduler and Reporting tools like Micro Strategy, OBIEE and SSRS.
• Extensive working experience on Informatica Workflow Manager to run the workflows and monitor the status and logs in Workflow Monitor.
• Extensive experience with validating Reports generated by Tools like OBIEE and Micro strategy.
• Experience in data visualization tools (Tableau, QlikView).
• Extensive ETL testing experience using SSIS, Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7. x, (Designer, Workflow Manager, Workflow Monitor).
• 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.
• Experience in validating data against various transformation rules and straight moves by writing and executing SQL statements.
• Experience on working with different models such as star and snowflake and strong knowledge in dimensional modeling.
• Experience in testing Dimension and Fact tables in a data warehouse.
• Experience in testing Business Intelligence reports and dashboards generated by various BI Tools like OBIEE and Micro Strategy(MSTR).
• Extensively validated the BI reports for data, drilling features, filters, graphs, vendor scorecards and UI.
• 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 diverse source systems such as relational table, flat files and XML files.
• Experience in all phases of Software Development life cycle.
• Experience in Data warehousing projects related to Banking, healthcare and Insurance.
• Performed Functional, Integration, System, UAT and Production 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, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.1/8.6, SSIS, Ab Initio CO>OP 2.14, GDE 1.14, Robort job Scheduler, Data Stage 8.x.

Reporting Tools: OBIEE 12.2.1, SSRS, Micro strategy 9.5.x

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, Java, J2ee

Other Tools:: Harvest, Tortoise SVN, Win SCP.

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, MD

Data Quality/ETL Tester

• 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.
• Prepared extensive set of SQL Queries for validating data movement from Source to Target system.
• 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, Clear Quest Defect tracking system (CDTS), Harvest, SQL, Share point, Winscp, Excel.

ETL/Data warehouse/Reports Tester

• Analyzed the requirements and validated the mapping document for it's completeness.
• Prepared extensive set of validation test cases to verify the data utilizing the functional specification document (FSD) and mapping documents.
• Utilized SQL Queries to prepare test cases for direct move and transformations mentioned in the mapping document for the data movement from source to target.
• Studied and understood the Data warehouses and functionality 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.
• Used HP ALM as the test management tool for the maintenance of the test cases and to track the defects.
• 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 for the movement of data from Source to Target with different transformation rules as well as direct moves.
• Involved Extensively during UAT testing of various functionalities along with the implementation team and involved to resolve the issues and problems.
• Executed and analyzed complex test cases and compared the results with expected results and worked closely with the development team to identify and resolve any issues found.
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Tested the different sources such as Flat files, Tables and Oracle to load into the Teradata data warehouse.
• Involved in backend testing using SQL Queries in Teradata data base.
• Involved in data warehouse testing by validating ETL procedures/mappings and data for it's quality, completeness, consistency and other as per the specification.
• 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.
• Experience in validating data from various data sources like Teradata, Fixed Width and Delimited Flat Files.
• Involved in testing the Business Intelligence (BI) reports generated by Micro Strategy for data, drill down features, graphs, pie chart, vendor scorecard and cosmetic features.
• Involved in Data Validation from Teradata and Flat Files using SQL Queries and execution using sql assistant.

Environment: ALM/HP Quality Center, Informatica(workflow manager, workflow monitor), Cognos, SQL, PL/SQL, XML, Flat Files, Teradata, Teradata SQL Assistant 12.0, UNIX,, Micro Strategy, Winscp, Excel, Sharepoint.

ETL/Reports Tester

Responsibilities:

• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Developed test plan based on functional specification document(FSD) and Business requirement document(BRD) and communication with the project team.
• Created and executed test cases based on test plans and based on ETL Mapping document.
• Executed the SQL queries using teradata sql assistant for validating the test cases against expected result.
• Utilized SQL Developer to execute the queries for validating the data for reports generated by OBIEE.
• Validated OBIEE dashboards based on business requirements and shared results with users during UAT.
• Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool
• 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.
• Validated the data in both the integration and semantic layer.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Retested the defects after fix from development team and Perform functional, integration and regression testing as needed to identify and minimize defects.
• Tested -Reports, Dashboards and other functionality within the OBIEE for data, filter conditions, graphs, drill down features, print and download options and other cosmetic features as per the specification.
• 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.
• Compared Source and Target database systems for counts, duplicates, primary keys and other aspects of data validation.
• Logged defect using ALM for any discrepancies and worked with the development team to identify the root cause of mismatch.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Interacted with Customers and Associated Organizations, documented for UAT.
• Ensured that the mappings are correct and effectively communicated testing activities and findings in oral and written formats.
• Tested all OBIEE Dashboards according to the requirement.
• Performed extensive data validations against requirements and transformation rules for data load into 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.

Environment: Oracle 10g,SQL, Quality Center, Ab Initio, OBIEE, MS SQL Server, Teradata 12.0,Teradata SQL Assistant, Flat files, UNIX.

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.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document.
• 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.
• Written SQL queries to validate the reports generated from OBIEE.
• 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.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Tested different reports, graphs and pivot reports in OBIEE dashboards.
• 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, SQL, UNIX, Oracle, OBIEE, Advanced Query tool (AQT), UNIX, .Net, Quality Center, XML, Windows XP, Flat files

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, Windows 2007, TOAD, SQL, SQL Server, Excel, Share point, Winscp.