Description:Aligned Health is an insurance Company that provides Health Insurance. The main aim of the project is find Various Premiums paid by the policyholder, Claim paid to the policyholder, Commission paid to the Agents. We can track the premium by channels, Marketing type and Location. The database design is based on data warehousing concepts in order to support the development of the business intelligence reports. It will enhance the decision making capabilities of a Brand manager by various reports and graphical charts. Responsibilities: • Understanding the requirements based on the requirement document. • Designing and developing Test cases, Test scenarios and execution plan. • Preparing test cases and execution of test cases and scripts. • Scheduling workflows and matching the data between source and target. • Validate the test cases and document the test results. • Share test results to the quality review team. • Tracking the defects in HP ALM. • Actively involved in status calls with onsite clients. • Preparation of daily and weekly activities. • Ensure timely project deliveries, report test metrics to the client. • Daily & Weekly status report. • Working closely with Development and BA team. Environment: Oracle SQL Developer Tool, Teradata SQL Assistant Tool, Informatica Power Center, HP-ALM, UNIX

Description:ASDA Retail Stores, which is one of the organization that sells various numbers of products. ASDA have various stores across UK, which maintains Sales, Profits with lots of historical data. This project was to create Sales Data Warehouse and generate reports using Reporting services. The aim of sales data Warehouse is to analyze the sales and profit in month wise and year wise. This Data warehouse plays a major role in enabling various stores to view the reports and help them to make decision to bring more revenue to company with new policies.Responsibilities:• Analyzing the solution document and understanding the requirement documents.• Understanding Logical flow of the Application from Business Knowledge.• Preparing the test cases as per Test Plan.• Uploading the test cases and execution documents in QC.• Writing the SQL queries for data validations.• Compare data for all columns between source and target to report mismatch data.• Understanding the business functionality.• Creating Test Scripts to validate source and Target data.• Responsible for reviewing the test cases for team members to ensure high quality deliverables.• KT sessions to team members on application functionality.Environment: SQL Server Management Studio,Oracle SQL Developer Tool, Informatica Power Center, HP-QC, UNIX