The Monetary Authority of Singapore (MAS) has issued revised regulatory requirements which set out the revised reporting standards for banks in Singapore. These changes will take effect on 1 October 2020. This is in line with MAS’ objectives to collect data in machine-readable format and to reduce duplicate data submissions by financial institutions (FIs).

The key changes to the regulatory requirements include:

(i) Collecting more granular data of banks’ assets and liabilities by currency, country and industry. Greater granularity allows better identification of potential risks to the banking system;

(ii) Rationalizing the collection of data on RMB business activities and deposit rates. The standardized requirements will provide greater consistency and reusability of the data; and

(iii) removing the Domestic Banking Unit and Asian Currency Unit1and for banks toreport their regulatory returns in Singapore dollar and foreign currency instead.

PRDS (Party Referential Data Store) is a ADS (Authorized Data Store) for Client/Customer data in Bank. It holds the customer/client, Customer to Account linkage and aml-kyc information received from multiple Upstream and sends to multiple Downstream applications. PRDS is a component of the Master Reference Data Strategy which serves as a data store to support enterprise initiatives and repository for combined wholesale and retail customers.

CODS Transactions module contains all different types of transaction details done by the customers in North America. As part of this project we get the source data in terms of Cobol Copybook files from different servers. After performing the basic cleansing process and other transformations specific to the client requirement and load into the Stage, Target table which is the ODS. Further, based on Cobol program logics, we generate outbound files. This project main intension is to migrate of Mainframe to ETL.