Cash Manager Project

Analyst Developer

2007-2008 Prudential/ M&G

Summary:

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.

Goal Result
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
 

In Depth:

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.
Phase II
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.

Skills

  • ASP 
  • MS SQL sophisticated
  • Excel 
  • DOM 
  • Javascript/ VB Script 
  • XML 
  • AJAX 
  • Bespoke

Share with:

FacebookTwitterLinkedIn


Published by

Craig Lambie

Creating more people like Elon Musk in this world is my aim. Big thinkers, limitless believers like the universe we live in, always expanding. I work with people on expanding their horizons and working through the little things so the big things can grow.

Leave a Reply

Your email address will not be published. Required fields are marked *