The claim data/ Account data is stored in to various tables for reporting. We sit on the top of the data to produce various reports according to the BA’s requirements. These reports are submitted to State Government/Federal Government.

The reports are produced to the state or end user for the Claims filed.This project was to generate the reports. We used to handle many types of claims like PPO, HMO, DENTAL, PHARMACY and many more. It is categorized in four major ELIGIBILITY, CLAIM, PROVIDER and PHARMACY. Eligibility used to provide the detail of the eligible persons based on the criteria. Claim used to get the corresponding claim details for those members. Provider will add the provider details and the same pharmacy use to add pharmacy details.

Then generally we used to generate the Access DB for our internal review and analysis and one external file which will hand over to end user.

DADM is built on top of Digital data from various applications like clickstream, omniture, P2C and GCT.As part of this built we need to parse the source/in stream data and do further data transformations to store the data. On top of Datamart we need to create user specific reports and send across SFT to the end users.

Inclusion of the ability to delete data that is no longer required by the business.

This process can delete historical data which is older than 3 years from the PAM tables at a time.