2007-2008 Prudential/ M&G
This project involved understanding the needs of the Treasury desk; current processes and systems, then specifying, planning and developing a new system that was paperless, efficient, tracked changes and as fluid and quick as Excel, but a Database based web interface system.
Cash Manager allows the Treasury to place £8 Billion on the overnight markets daily without over exposing to high risk banks.
|Reduce Paper||50% reduction|
|Increase efficiency||Reduced FTE by 75%|
|Reduce errors||Errors to clerical only|
|Track changes||Every entry recorded|
|Reduce Risk of overexposure||Tracks exposure and credit rating for every bank on the fly, with warnings and notifications|
Cash Manager – CM – Managing £8B daily
This system was built based on Analysis and understanding of the PruCap Treasury desks excel, paper and quill and ink based systems.
By connecting to the many sources of data (Excel, Oracle, HSBC data feed, Reuters Data Feed, Email) and putting the “days work” into the CM system, then allowing a fully controlled workflow system to evolve where each “deal” was tracked from order to execution to settlement inside the CM allowing for management to have a view of the days position anytime of the day. CM also incorporating exposure limits and user/ role limits for financial instruments or institutions.
CM Phase II involved adding the entire Currency Deposits to the GBP only system, also adding several new bespoke reports and calculation tools for daily dealing across different funds, fund groups and legal entities groupings.
FX Manager – FXM
The FXM was designed with similar tracking and order management systems as the CM but for the highly complicated FXM market. Two way pricing and tracking for counter parties. Full reporting for Non liquid currencies. Tools for “building” a cross currency pair. Tools to group together similar orders based on criteria and trade larger deals in the market, then allocating them back as per deals done.
- MS SQL sophisticated