Name Chaitra Patil

Phone +1-703-***-****

Email adba1c@r.postjobfree.com

Over 6+ years of experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.

Strong experience working in Siebel CRM (eCommunication and ePharma), OBIEE (Answers, Dashboards and Disconnected) and ETL testing experience.

Ability to write and understand complex SQL queries.

Good understanding of OTLP, OLAP and DW concepts.

Diversified experience in Integration, GUI, Functional, Regression, end to end, User Acceptance (UAT), and Ad hoc testing.

Experience in Manual Testing of ETL and BI applications in Functionality Testing, Regression Testing and Report Testing.

Coordinated On-site and Off-site Test teams and guided during the entire testing phase.

Expertise in use of HP Quality Center for Defect Reporting and defect management.

Proactive Team Player, excelling in problem solving, adaptable to new environment and good communication skills.

PROFESSIONAL EXPERIENCE:

Employer : 3k Technology Solutions, USA.

Project - Verizon Digex Siebel Migration to PremiSys

Duration : October 2014 To August 2015.

Tools: Siebel Analytics 7.8.5, Siebel eCommunication 7.8, Mercury Quality Center 9.0 and SQL Developer.

Responsibilities:

Analyze Business Requirements, Functional Specifications and Business Rules to identify Test Requirement, Test Plan, Design test cases and Test data.

Developing SQL’s to the source (Siebel OLTP DB), to test the count related columns (facts) in Siebel Analytics.

Participated in daily meetings to update the team with work that was completed with any impediments that are blocking the work.

Responsible for creating System Test Environment and the associated test data.

Executing the Queries at the source (Siebel OLTP DB) to check the ETL process.

Managing and monitoring- the test case creation, execution and defects using Mercury Quality Center 9.0.

Created Test Plan, Test cases and Test Summary reports for every sprint and shared it with the team and other audience when appropriate.

Performed Functional, System Integration (SIT) and User Acceptance (UAT) testing and updated the results accordingly.

Tested the applications response for positive and negative sets of data with data-driven testing procedures.

Attended Review/Retrospective meeting for all the sprints in addition to Business Review sign off meetings with Business.

Tracked and updated tasks in Quality Center.

Employer : Cognizant Technology Solutions, India.

Project Title – GSK

Duration : May 2011 To March 2012

Tools: Oracle Business Intelligence 10.1.3.4.1, Siebel ePharma 7.8 and 8.1, Mercury Quality Center 9.0 and SQL Developer.

Responsibilities:

Responsible for preparing Traceability Matrix report using Mercury Quality Center.

Creating test data in Siebel ePharma application and validate the same in Analytics after the Load (Full/Increment).

Involved in OBIEE answers testing.

Responsible for logging and tracking the defects using Mercury Quality Center.

Executed Functional, Integration, Regression, End to End and User Acceptance Tests (UAT).

Worked with Business Analysts and users to gather testing requirements/planning.

Executing and Debugging the Test scenarios.

Responsible for data validation and data count testing.

Project - Pfizer - Wave 3 R3-4 Siebel Analytics Testing

Duration : March 2008 - April 2009

Tools: Oracle Business Intelligence 10.1.3.3.2, Oracle Business Intelligence Disconnected, Mercury Quality Center 9.0 and TOAD.

Responsibilities:

Worked as Onsite and Offshore coordinator.

Understanding the data schema used in the SRMW for writing the SQL’s.

Tracked and maintained bugs and maintained all the Test Artifacts in HP Quality Center.

Responsible for delivering the Test Deliverables to the client as per project schedule.

Driving Daily status calls, weekly sync-up calls.

Involved in OBIEE dashboard Testing & UI Testing.

Executing the Queries at the source (Siebel) side to check the ETL process.

Application comparison across Disconnected – Connected Analytics.

Tested the navigational flow of the drilldowns in the dashboards.

Project - CBeyond Analytics phase II Testing

Duration : January 2008 to March 2008

Tools: Oracle Business Intelligence 10.1.3.2, Informatica, Cognizant internal tool Prolite, TOAD and Siebel Analytics Administration Tool

Responsibilities:

Writing and reviewing Test Cases for OBIEE Answers testing.

Analyzing the Informatica mappings in Informatica Power center 7.1.2 to understand the logic used for facts and also to find the source relation for combination testing.

Involved in development of Test Plan, Test strategy, Requirement Traceability Matrix.

Developed Test scripts and Test cases from Use cases, Requirements including business rules.

Logging and tracking the defects using Cognizant internal tool Prolite.

As Siebel analytics tester understood the business process and functionality.

Involved in knowledge transfer of the learning gathered from the project.

Querying the Data base using SQL for data base testing.

Worked with Siebel Analytics Administration Tool to understand the business layer.

Mentored Junior QA Engineers in the team. Involved in training of users (administrators) regarding the effective utilization of the application.

Working as Onsite-Offshore coordinator, representing QA during all Client meetings.

Project - Pfizer Wave 3 R3-4 Siebel Analytics Testing

Duration: May 2007 – December 2007.

Tools: Siebel Analytics 7.7.1,Siebel Analytics Disconnected, Mercury Quality Center 9.0 and TOAD.

Responsibilities:

Analyzing the requirements change.

Understanding the data schema used in the SRMW (Siebel Relationship Management Warehouse) for writing the SQL.

Involved in development of Test Plan, Test strategy, Requirement Traceability Matrix.

Developed Test scripts and Test cases from Use cases, Requirements including business rules.

Developing SQL’s using ETL mapping and ERD diagrams.

Defect management using Mercury Quality Center 9.0.

System Testing using Mercury Quality Center 9.0 for 5 country applications.

Querying the Data base using SQL for data base testing.

Functional Testing & UI Testing.

Executing the Queries at the source side to check the ETL process.

Working as Onsite-Offshore coordinator, representing QA during all Client meetings.

EDUCATION:

Degree: Bachelor of Engineering in Electronics & Communications Engineering

University: Visvesvaraya Technological University

College: Dayananda Sagar College of Engineering, Bangalore, Karnataka, India

Contact this candidate