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.

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. Enterprise data warehouse will be expecting the same information to be captured from the new system and the data model is remaining unchanged.

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.

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.

Citi group has set up the centers in India to perform back office work. Thousands of customers application are scanned and sent to India for processing. Citi group has also call and capturing information like number of calls, contacts, idle time taken to call etc. They are supporting many processes like life and annuity, Medical Systems, Plastics, Finance. Transactional processing Data Mart has been developed to integrate data from multiple, processes for generating analytical reports.

QBIS (Quest Business Intelligence Systems) provides enterprises metrics and information in the functional area of out of region Product Activity. QBIS contains service order data from and corporate dimensional data from the crts systems. The main achievement of this project is to determine if the business is on track, identify where the things are going wrong, take and monitor corrective action and spot trends.

Sales analysis provides information about the key performance indicators identified as critical for the Business. Various reports are generated to review the performance of the business. The sale data is from various platforms was brought into oracle. Using INFORMATICA Tool the data is extracted from source database and cleansed and transformed the data using the transformations. Finally, the data is populated into dimensions and facts. The project focuses estimating and analyzing the companys performance for the past few years. It also helps to analyze sales in different areas and different seasons

This banking corporation with more than 150 branches and 4 zones located all over Serbia. This application captures data into flat files, where as application pumps huge amount of data into the production database, which makes it impossible to maintain it beyond 90 days, which is stored in a database. Each location at the end of the day has to pump data into central zones. Each location daily generates reports for different purposes.