A automate system and scalable system is required to support the manufacturing from end to end for all locations, this will help the media device manufacturing to achieve group synergy to implement single system in order to achieve operational efficiency.

Building new processes to load UTS. The main objective of the new Unit Trust System is to provide straight through passing capabilities for UT fulfillment between front end, backend and Fund Houses. It will improve operating efficiency, optimize use of resources and eliminate the functional gaps prevalent in the current Singapore UTS operating model and current Malaysia AS400 UT System by providing the functions not presently supported.

XC3: Building new processes to load HPS, DW Feeds into Wellmark EDW STG layer. The Wellmark EDW consists of several layers like Staging Layer (STG), Common Record Format Layer (CRF), Atomic Data Layer (ATM), Presentation and Performance Layer (PRF). The sources consist of FEP files (Flat Files). These FEP files are staged into a single staging level in Teradata called STG_LR (Stage Load Ready). ETL of the data from Staging Layer to CRF, ATM and PRF level are done. Applied CDC (Change Data Capture) while loading the data from CRF to ATM layer. Applied the principle of Incremental loading for capturing the delta data. ABC (Audit Balance and Control) is used to control the overall process.