Capital markets product control workstation at a large US bank​ ​

Delivered​

• P&L and Balance Sheet, daily and aggregated over multiple periods​

• P&L sign-off process​

• Many reconciliations ensuring SORs’ Positions, Transactions, Balance, and Journals data reconcile

• Extensible platform for further business requirements and reporting

• Project time: 2 years from business requirements to go-live (the Finray platform was built during this period)

• Additional functionality build now in discussion​

Outcomes​

• 30% labor reduction​

• 75% reduction in manual control points​

• 90% improvement in processing time​

• Higher quality, more transparent reporting​

Supporting functional architecture

• A pre-defined common data model​

• Normalized transactional, master, and reference data across all financial product types​

• Metadata related to data ingestion, data quality, tasks, and reconciliation​

• Source to target data mapping 100% visual with easy rules functionality ​

• Embedded, pre-defined, and extensible data validation to ensure complete and accurate data​

• Easily configured job processor​

• Data quality dashboarding​

• Dynamic reporting embedded​

• Adjustment functionality within the Finray platform​

• User interface to maintain/update master data and reference data​

Built for continuous improvement​

• Control rules enable finance users to query, transform, aggregate, and report on data across data entities, attributes, functions, and joins

• Outputs are stored as extensions to the data model

• Rules are built without code through the interface

• Rules are assigned and ordered within tasks and workflows​

Finray approach

• Start with a pain point (every FS firm finance function has them)​

• Deliver credibly and quickly​

• Identify the road map for further improvement​

• Repeat​