Component #1 : Feed Normalization

Objective: Create vendor agnostic solution. This component will translate any vendor feed layout in to a common layout that the app will use. In order to onboard any new vendor feed, only this component needs to be created - specific to the feed.

Defining common Layout: The common layout should have the following attributes defined -

1. Vendor Name [Use 3 Byte code to represent the vendor feed]

2. Vendor code [Primary key of the Vendor - Optional]

3. Legal Entity Name [Official Issuer name]

4. Issuer Country of incorporation

5. Country of Risk.

6. LEI Code

7. List of Issuer Cusips.

8. List of Issued ISIN codes

9. Issuer Address

Filtering Issuer Records:

1. Filter dummy Issuer records, if any, created by a vendor.

Input: Vendor records for Issuer data

Output: Normalized record per Issuer record with only the fields defined in the common layout