A European banking client required a single platform to view all Front-to-Back MIS related to their equity derivative business. There were large datasets from multiple sources. The data were inconsistent and unstructured.
Fast turnaround by a small project team of a very large data challenge into a visual dashboard. Effective data analytics to model each layer of the process flow. Clean and standardised view of data across the hierarchy: front office trading, middle office CCA (Cancel-Correct-Amend), and back office reconciliation and P&L systems. Data views presented by product, location, desk, client and process.
Comprehensive visual display of MIS data viewable by management at book or desk level and by sales at client or salesperson level. The final delivery offered a single MIS platform for the equity derivatives business, as well as a flexible and scalable framework for other business lines.