To be complaint with Laws & Regulations passed by US Government and Risk assessment the Wells Fargo choose DataStage for reporting. Combining both, out of box reports are developed with the help of ETL and BO reporting as per the Business needs for decision making.

GTM is a system in which data is received or sent to the interfaces on the basis of business requirement. Basis, Bermudian swaption, European Swaption, European Swaption Cancel etc are some of the interfaces involved in GTM. Data is generated into GTM is processed through Datastage tool and then reports are generated in BI. Control M scheduler is used scheduling the jobs. Data receiving form interfaces is sent to staging DB and then to data warehouse DB. The data in data warehouse DB is processed using Datastage tool. This processed data is used for reports generating.

The purpose of the project is to address the current regulatory gaps in our designated client money act (DCMA) offering to the customers. These gaps relate to the money laundering & tax reporting regulations and exist in our current boarding systems & do not capture, validate maintain the correct info about the underlying beneficiaries of these accounts.

Generating the report for for customers who crosses the age limit

Migration of the data from one server to other server