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.

The project enables Design and Development of a new TP system named Razor for few countries and building a data support system for downstream reports extraction.

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Three World Financial Center, Manhattan, New York City. AMEX has initiated a process called GCT to track and record the events namely Landing, Application start and submit events from entry points like Natural search, URL through campaigns.

Conversion of 2 years CLPR data to PAM model. Before CLPR model occupies 36TB space and then it is replaced with PAM model which occupies 12 TB only which saves 24TB space in bank enterprise data warehouse.