1 / 29

FX SPOT CREDIT LIMIT CONSOLIDATION SYSTEM

Confidential. FX SPOT CREDIT LIMIT CONSOLIDATION SYSTEM. December 13, 2005 Presented by: William Hays Amy Jackson. PRESENTATION OUTLINE. Background Overview Goals Methodology Results Overview of new process Demonstration of new system Conclusions Recommendations.

layne
Download Presentation

FX SPOT CREDIT LIMIT CONSOLIDATION SYSTEM

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Confidential FX SPOT CREDIT LIMIT CONSOLIDATION SYSTEM December 13, 2005 Presented by: William Hays Amy Jackson

  2. PRESENTATION OUTLINE • Background • Overview • Goals • Methodology • Results • Overview of new process • Demonstration of new system • Conclusions • Recommendations

  3. Project Background • FX trading • Spot credit limits • Broker services systems • Reuters • Electronic Broker System (EBS) • Credit Work Station (CWS)

  4. PROJECT OVERVIEW Estimated Total Manual Time: 2:40

  5. PROJECT GOALS • View of the total FX limit allocation for each client. • Log of the clients. • Clean-up of sub-entities. • System’s interface integrated into CRM website. • Internal Technology team member to maintain and update system. • Knowledge of FX trading and credit limits.

  6. METHODOLOGY

  7. RESULTS: Understand the Current Process • User meeting notes • Research on systems involved • Research on credit limits and FX trading • Documentation of current process

  8. RESULTS: Design the New Process • Functional requirements • Use-case and Sequence diagrams • Proof of Concept • Database structure • Interface prototype

  9. RESULTS: Implement REBS FX • Database structure • Views/Stored procedures • Application layer

  10. RESULTS: Move REBS FX To Production

  11. OVERVIEW OF NEW PROCESS: Steps Estimated Total Manual Time: 1:55

  12. OVERVIEW OF NEW PROCESS: Demo.

  13. CONCLUSIONS • Requirements met: • User • Technical • Informational

  14. RECOMMENDATIONS • Post Project • Long Term • Automated feeds • Readily available CRM implementation standards • REBS FX extension • Global use of REBS FX • WPI project continuation

  15. Lehman Brothers: Ayoob, Mahvish Burton, Scott Chang, Scott Eisen, Daniel Fox, Andrew Girard, Jocelyn McConnon, Thomas Moeller, Christian Murphy, Brendan Tan, Ford Wilkins, Simon Wong, Leesan Worcester Polytechnic Institute: Abraham, Jon P. Ciaraldi, Michael Gerstenfeld, Arthur ACKNOWLEDGMENTS

  16. QUESTIONS

  17. DatabaseStructure

  18. Demonstration (1) First screen shows possible reports. The default is the unlinked entities (that have been imported from Retuers/EBS systems)

  19. Demonstration (2) Second screen shows a list of possible reports (from the reports table) When a report is selected, it is queried for viewing.

  20. Demonstration (3) Third screen shows the “existing limits” report corresponding to limits related to all CWS counterparties

  21. Demonstration (4) When a user clicks on a CWS client code in the reports window, the details for that counterparty are shown. Shown are the associated Reuters/EBS accounts.

  22. Demonstration (5) Below the associated accounts are the sub-entities (or branches) related to the counterparty.

  23. Demonstration (6) Below the sub-entities is a log of the history for that client. History entries are changes to the database as well as user-entered history items.

  24. Demonstration (7) Wherever an entity ID is shown, the entity detail page can be opened. Shown on this page is linking/unlinking to CWS counterparty functionality.

  25. Demonstration (8) The user searches CWS for the counterparty name and then updates the link to the counterparty once one is found.

  26. Demonstration (9) Further down on the entity detail page you will find similar sub-entity and history information as found on the client detail page.

  27. Demonstration (10) This is an example of an unlinked entity. This will occur for new clients and clients that do not exist in CWS.

  28. Demonstration (11) This is an example of a changed limit when importing from Reuters/EBS systems.

More Related