290 likes | 448 Views
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.
E N D
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
Project Background • FX trading • Spot credit limits • Broker services systems • Reuters • Electronic Broker System (EBS) • Credit Work Station (CWS)
PROJECT OVERVIEW Estimated Total Manual Time: 2:40
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.
RESULTS: Understand the Current Process • User meeting notes • Research on systems involved • Research on credit limits and FX trading • Documentation of current process
RESULTS: Design the New Process • Functional requirements • Use-case and Sequence diagrams • Proof of Concept • Database structure • Interface prototype
RESULTS: Implement REBS FX • Database structure • Views/Stored procedures • Application layer
OVERVIEW OF NEW PROCESS: Steps Estimated Total Manual Time: 1:55
CONCLUSIONS • Requirements met: • User • Technical • Informational
RECOMMENDATIONS • Post Project • Long Term • Automated feeds • Readily available CRM implementation standards • REBS FX extension • Global use of REBS FX • WPI project continuation
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
Demonstration (1) First screen shows possible reports. The default is the unlinked entities (that have been imported from Retuers/EBS systems)
Demonstration (2) Second screen shows a list of possible reports (from the reports table) When a report is selected, it is queried for viewing.
Demonstration (3) Third screen shows the “existing limits” report corresponding to limits related to all CWS counterparties
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.
Demonstration (5) Below the associated accounts are the sub-entities (or branches) related to the counterparty.
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.
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.
Demonstration (8) The user searches CWS for the counterparty name and then updates the link to the counterparty once one is found.
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.
Demonstration (10) This is an example of an unlinked entity. This will occur for new clients and clients that do not exist in CWS.
Demonstration (11) This is an example of a changed limit when importing from Reuters/EBS systems.