The newly developed system was destined to replace former product with new one, based on the innovative web technology and ability to cooperate with other applications under one portal. This initiative served three purposes:

• enhance usability and workflow processing for analysts, risk managers and closers,
• extend the work progress reporting service to other regions, hence providing business users with global reporting,
• reduce operational risks since audit trails and daily backups will be available.

The Solution:

The new system allows the Asia DPG business users (Analysts, Risk Managers and Closers) to report work progress with credit names on a weekly basis. Information about current state of credits (single assets and portfolios) was previously captured through individual analyst excel files. A master MS Excel™ application was also used for collecting and redistributing this information to and from analyst’s spreadsheets. Closers status update information was entered directly into the master application. The master MS Excel™ application provided regional and global management with Business Activities, and other types of weekly reports.

As the reporting requirement is getting more complex, the credit/portfolio under management are increasing and more participants are using the master spreadsheet application; the spreadsheet based platform is becoming less efficient to meet all needs. The ability of further maintenance of the spreadsheet based platform is sufficiently reduced due to the limited expandability and low security.