Reconciliation Engine of Equity erivative Middle Office for a Banking Client
Client
One of the largest asset managers in the world. The company primarily generates revenue
through investment services, including asset and issuer servicing, treasuryservices,
clearance and collateral management, and asset and wealth management.
Accurate Reconciliation for
Indicatives, Cash flows and
Resets for OTC Options,
Vol Var Contracts and Equity
Swaps for all regions.
Build the Custom GUI that is highly
flexible and can be dynamically
manipulated to help investigate
and resolve breaks.
Need the ability to overnight
reconcile between the
two systems.
Ability to categorize breaks, attach
notes, action breaks and
dynamic filtering.
Provide client (limited)
entitlements based
on Desk and role of the user.
The Reconciliation System should
maintain a log of all actions performed
in the system and all audit related
information should be available
for reporting.
Generation of pre canned
Break Summary reports
and Break Detail reports.
Scope of Services:
1.
The functional design and impact analysis being delivered to address the business
needs for Reconciliation engine.
2.
Custom User Interface was design which will include Actioning Items, Break Review,
Adding Notes / Comments, Manual Matching, Excel Downloads, Dynamic configuration
of views, Summary Reports, and Detail Reports functionality.
3.
Define ETL layer to process & validate Positions and Transactions (Indicative and
Cash flows) data to feed Reconciliation engine.
4.
Audit Trail implemented to capture user information, data and time and action
performed on each item that was processed or modified.
Results:
1.
Smaller turnaround time
2.
Scalable solution to support the increasing volumes of data
