Professional Summary:

Having 2 years of experience in BIDW Testing.
Proven experience in software testing processes which includes Test Planning, Test case preparation, Peer review of test cases, Executing tests and Bug reporting & Tracking.
Experience in defect reporting and tracking of defects using HP Quality Center.
Having domain knowledge in Investment Banking and Health Insurance.
Having experience in OBIEE report testing.
Knowledge in SQL queries.
Sound knowledge in analysis of functional issues.

Work Experience:

Working as a Software Engineer in Hexaware Technologies, Chennai, since October 2007
Worked as a lecturer in P. S. G. College of Arts and Science, Coimbatore from July 2006- Feb 2007
Worked as a lecturer in K. S. R. College of Arts and Science, Tiruchengode from July 2007 to Oct 2007

Awards:

Won Hexawares Ace award for the Outstanding Performance recognized by Dean Health.
P. S. G. College of Arts and Science Awarded First Rank Holder in Master of Statistics.
P. S. G. College of Arts and Science Awarded Third Rank Holder in Bachelor of Statistics.

Technical Skills:

ETL & BI Tools : Oracle Warehouse Builder, OBIEE.
RDBMS : MS SQL Server 2000/ 2005, Oracle 10g
Defect Tracking Tool : HP Quality Center 9. 0.
Operating Systems : Windows XP/ 2000/ NT/ 98/ 95

Details of Projects:

Project # 1
Project title DEAN Health Plan BIDW Testing
Client Dean Health Insurance Inc, USA.
Organization Hex aware Technologies
Duration Sep 2008 till date
Environment HP QC 9. 2, Rapid SQL, HP Quality Center.

Project Description:
Dean Health is multi-specialty integrated healthcare delivery system based in Madison, Wisconsin, which provides: Medical and Health services through a network of Dean or St. Mary's/ Dean-owned clinics throughout southern Wisconsin, Health Insurance services through Dean Health Plan/ Dean Health Insurance, Inc,.
The independent testing of the Project ARMOR is primarily focusing on verification and validation of the ARMOR DWH target db, ARMOR Analytics Reports and ABC implementation against the CDMA (Code and Data Migration Application) portal, Physical data model and Error & default rules specifications.

Responsibilities:
Responsible in Understanding requirements
Prepared SQL queries based on transformation rules specified in CDMA portal
Involved in Test Script Execution
Involved in test case review against physical model and transformation rules and error rules specified in CDMA
Involved in defect tracking in HP Quality Center
Responsible for analyze the impact on test cases design and execution phase for each CR logged in QC

The key objectives of the Projects are as follows:
Test extract, transform and load (ETL) processes to assure that the data has correctly moved from point A to point B.
Confirm that information is up-to-date in Data warehouse
Check for bad records into Data ware housing-data that do not comply to business rules.
Verify the application under test functions as designed and meets the business requirements for Reporting purposes.
Data validation between Business Integration & Data warehouse environments.

Project # 2
Project title Dolphin Data Ware house BIDW Testing
Client Deutsche Leasing, Germany.
Organization Hexaware Technologies
Duration Oct 2007 - Sep 2008
Environment Oracle Warehouse Builder, OBIEE, HP Quality Center.

Project Description:

Deutsche Leasing Group aims to grow aggressively in Germany and other parts of Europe and considers Information Technology support as critical for its strategic growth plans. DL is currently using different systems to manage information in different vertical of business.

Dolphin is an application to handle recovery of dues from Debtors and the Collection business is carried out by BHI. This phase involves loading of the data from Dolphin to DWH. This interface will bring data from Dolphin system in full load or in partial load. The main process of testing, which is being performed, is the Extraction, Transformation and Loading. The process on the warehouse system executes and loads the data from existing source. In the first phase of the project we move the data from sources to Update Views. In the second phase we move the data from Update views to Staging Area of the warehouse system. In the third phase of the project we move the data from the staging area to the warehouse system. After completion of the DWH, the reports testing which are generates from the DWH using the Oracle BI Answers.

Responsibilities:
Responsible in Understanding requirements
Prepared SQL queries based on transformation rules specified.
Involved in Test Script Execution and Test case review against physical model and transformation rules and error rules specified in Requirement document.