Foreign Future Variation Margin Reconciliation: Automating a Manual Reconciliation ProcessPublic
Downloadable Contentopen in viewer
The operations team at J.P. Morgan reconciles the balances of their foreign future holdings on a daily basis. For many years the reconciliation process has been completed manually. The process is inconvenient for the operations team because it requires a large amount of time to be completed and is prone to human error. Through analysis of the process, the MQP team came up with several features that could be built into an existing internal application in order to automate this process. These include features to upload excel files into the database. After uploading the files, users will be able to view a new unified report that allows them to quickly see any problems. The resulting product reduced the time needed to complete the reconciliation process from about two hours to five minutes.
- This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.
- Date created
- New York
- Resource type
- Rights statement
- In Collection:
Permanent link to this page: https://digital.wpi.edu/show/1c18dh42p