SUMMARY

• 8.10 years of experience in ETL Testing Responsible for ETL Testing, OBIEE Reports and RPD Testing as part of BI Testing.
• Automation Script Design, Test Development/Scripting, Review of Test Scripts, Test Script Execution, Test Script Maintenance, Defect reporting, Review of Test Artifacts as part of Automation Testing.
• Expertise in DB testing and constructing complex SQL queries. Working on DWH ETL(Informatica) Testing and OBIEE Report Testing and RPD testing
• Experience in Test Management Tools like ALM, JIRA
• Good Experience in ERP Application like Oracle Apps.
• Prepared SQL Scripts and validated data loaded into the data warehouse.
• Strong experience in Defect linking, Requirements mapping and Preparation of Test bed in the Quality Center.
• Experienced in Automation testing using QTP tool.
• Testing Oracle BI Interactive Dashboards,Prompts,Oracle BI Answers, Reports and RPD as part of OBIEE Report testing.
• Risk Identification and Management, Effectively raising red flags, issues and concerns.
• Track Suite execution results and send the results in Daily status Report
• Sending weekly status reports and metrics
• Coordinating with the development team/onsite leads to get the clarifications on the requirement.
• Participated in defect triage meetings, proactively tracked the defects for early closure.
• Understand the priorities correctly and make sure that the tasks are completed accordingly.
• Performed the Integration Testing, as part of integration testing validated the table’s data at the various layers of DWH for both incremental load and full load.
• As part of full load validated the complete table data for a particular time interval between Source and staging and staging and Target.
• Ensure client confidence by thoroughly understanding the customer needs and find appropriate solutions to the problems.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS

Operating Systems: Windows, R2, Linux

Web Technologies: HTML 5, CSS 3, JavaScript, Rails

Database: SQL Server, SQL Developer, Toad with Oracle, MYSQL

Management Tool: QC 10.0, Version One

Functional Test Tools: UFT

PROFESSIONAL EXPERIENCE

Confidential

Environment: ODI, UNIX, SQL, OBIEE, Oracle Golden Gate

Responsibilities:

• Worked as a Quality Assurance for Analytics Products of Utility Industry.
• Involved in setting up of processes, creating test plan, QA Strategy, test scope, test design and execution plan, estimating the time lines of QA for releases, focus on Automation for each release.
• Technologies used - ODI as ETL tools, OBIEE for analytics, Open Script for QA Automation, Oracle 12c as database, Oracle Golden Gate.
• Collecting test scenarios and use cases.
• Designing, Reviewing and executing test cases.
• Creating test data for various scenarios from source applications.
• Logging/tracking/testing the defects/bugs.
• Applying Builds on Test Environments and performing End-to-end sanity of every build.
• Develop/Improve automations to increase test automation scope and speedup processes.
• Support the Issues reported by product customers.
• Suggest improvements required in the product to enhance performance.
• Experienced in ETL testing, manual and Automated.
• Well-versed in ETL process flows & standards and good knowledge of Data-ware house modelslike Star schema and Snow Flake schemas.
• In-depth knowledge of writing medium and complex SQL queries using Joins and to use them totest data in Data Warehouse schemas.
• Good understanding of Software testing life cycle activities from start to closure of a Product release.
• Experienced in the test process including writing Test plans, Test Case preparation, Test Execution and Bug/Defect tracking.
• Experience in understanding the Product requirements and deriving quality Test scenarios/Conditions based on the requirements.
• Experience of performing Accessibility testing for products using various tools.
• Experience of working in Agile methodology and actively participating in Sprint Planning/Review meetings, at times leading them.
• Complete End-to-End knowledge of Product, from creating data at Source and the flow of thedata to be displayed on the Reporting tool.

Confidential

Environment: Informatica 9.5, UNIX and SQL

Responsibilities:

• My responsibilities include in all stages of the project Testing.
• Prepared data validation scripts and validated data loaded into Source Systems to the Target System.
• Performed the Integration Testing, as part of integration testing validated the table’s data at various levels .
• Preparing Test Evidence sheet.
• Created defects for bugs identified in the Integration Testing.
• Coordinating with the development team to get the clarifications on the requirement from onsite and Conducting Weekly calls with client and Updating the Status of Testing and Data Validation to the client.
• Participated in defect triage meetings, proactively tracked the defects for early Closure.

Confidential

Environment: HPQC, Informatica, OBIEE, SQL Developer/TOAD,QTP

Responsibilities:

• Prepared data validation scripts and validated data loaded into the data warehouse.
• Testing and Creating RPD and Report test cases for OBIEE Reports and RPD.
• Identify and develop Automation Test Script for ERP Application
• Performed Data Validation, OBIEE Report Testing and RPD for Break Fixes,Mini releases, Change Requests Fire fixes and Enhancements.
• Automation Script Design, Test Development/Scripting, Review of Test Scripts, Test Script Execution, Test Script Maintenance, Defect reporting, Review of Test Artifacts.
• Performed User Interface (UI) Testing, Functionality Testing, System Testing and Regression Testing as part of OBIEE Reports Testing.
• Performed the Integration Testing, as part of integration testing validated the table’s data at the various layers of DWH for both incremental load and full load.
• Testing Oracle BI Interactive Dashboards, Prompts,Oracle BI Answers,Reports and RPD as part of OBIEE Report testing.
• Preparing Test Evidence sheet.
• Created defects for bugs identified in the developed reports.
• Participated in defect triage meetings, proactively tracked the defects for early Closure.
• Coordinating with the development team to get the clarifications on the requirement from onsite and Conducting Weekly calls with client and Updating the Status of Reports and Data Validation to the client.
• Create or maintain object repositories and following best naming conventions for the objects identified.
• Review scripts by considering coding standards and performance parameters.
• Identify/Understand ERP application Automation needs/Automation feasibility study, Resolve technical problems with the automation tool
• Defining Test Deliverables, Task Planning and Scheduling
• Generating of Automation Test Execution Reports.

Confidential

Environment: Informatica, OBIEE, SQL Developer/TOAD,QC and QTP.

Responsibilities:

• Prepared the Utilities to minimize the team working hours.
• Implemented the test management skills in the team and delivered Quality work.
• Performing the ETL Testing, as part of ETL Testing validating the data at the various layers of DWH.
• Performing Unit Testing, User Interface (UI) Testing, Functionality Testing, System Testing and Regression Testing as part of OBIEE Reports Testing.
• Training to the new resources and helping team in preparing manual test cases and automation test cases applying test design techniques in an effective manner.
• Analyzing the requirement documents.
• Identify and develop automation framework suitable for Business Requirement Catalogue and Time Rule functionality.
• Create or maintain object repositories and following best naming conventions for the objects identified.
• Review scripts by considering coding standards and performance parameters.
• Daily status reporting and Build closure report.
• Performed Failure analysis on automation failures.
• Perform ambiguity testing on Requirement specifications.
• Reviewing effectively the manual and automation test cases authored by team to derive the quality of test cases.
• Preparing DSR, WSR, Test Summary Report, Defect Summary Report, Defect Tracking Reports.

Confidential

Environment: LDMS Tool, Informatica, MS SQL Server 2008, IBM Synergy & Change, HP Quality

Responsibilities:

• Understanding of business and functional requirements.
• Involved in Test case authoring based on functional requirements.
• Performed Test case execution, Regression testing, Browser compatibility testing & Ad-hoc testing.
• Defect reporting & verification.
• Target IFF(Intermediate Flat File) Design and Development
• Source Extraction through DTS(Data Transformation Source) and Informatica.
• XML Generation (Meta Data, Validation Rules Creation) through XML Generator tool.
• Writing validations using SQL Queries, Expressions
• Writing Stored Procedures.
• Loading the extracted data using LDMS(Lorenzo Data Management Studio) and validated data loaded into the data warehouse.
• UI Testing on the migrated data.
• Giving KT (Knowledge Transfer) on the application for the new joiners in the team.
• Worked as DataMigartion-Developer on Lorenzo with the help of LDMS Tool, MS SQL, Informatica.