For over three years, Monticello Consulting has been actively engaged in the swaps industry, partnering with our swap dealer clients to remediate data quality issues and to improve the acknowledgement rates for the trades associated with real-time reporting. See how we helped one client build a suite of tactical tools to solve these issues.
Read MoreBrokerage Payables Remediation Engagement
A top investment banking client recently called on Monticello to help with a process fit for automation. The engagement called for building a suite of tactical tools to address a particularly thorny reconciliation dilemma. See how we helped them resolve the issue and dramatically reduce the need to manually fix breaks in their payments systems.
Read MoreTime-tested Data Analysis Tools, On the Go - Goal Seek
Goal Seek allows the user to set the value in a cell containing a formula by changing the value in another, helping the user find the result they want by changing a single variable. Here, MCG walks you through how to best use this powerful Excel tool.
Read MoreDodd-Frank Reporting: Live Positions Migration for Money Center Bank
As part of the Dodd-Frank Wall Street Reform legislation, our client was required to backload live position data to the DTCC's Global Trade Repository (GTR) across several asset classes. Monticello Consulting Group helped them assemble a team to coordinate and execute the backload of all live positions from various front office systems into an internal rules validation system, and further into the industry-wide trade repository. The team developed a custom process to test, execute, and validate end-to-end results of this effort for two successive compliance dates.
Read More