Capital Markets Data & Systems Consulting
Independent advisory for asset managers and capital markets firms — from security master and market data architecture to SimCorp Dimension, IBOR/ABOR, risk, and performance attribution.
Services
Senior business analysis and data consulting for the workflows that run your portfolio — delivered hands-on, not from a slide deck.
Design and remediation of security master and market data architectures — vendor feed evaluation, data quality controls, golden-source strategy, and governance that holds up under audit.
Senior hands-on expertise across the SCD platform: implementations, upgrades, configuration, and optimization of front-to-back investment workflows.
Investment and accounting book of record design — position keeping, reconciliation strategy, multi-basis accounting, and the data lineage to trust every number.
Practical risk frameworks for asset managers: exposure monitoring, limit frameworks, market and counterparty risk data pipelines, and regulatory reporting readiness.
Attribution model selection and implementation — Brinson, fixed income, and multi-asset — with returns methodology that portfolio managers and clients can rely on.
End-to-end trade lifecycle analysis and straight-through processing: from order capture through confirmation, settlement, corporate actions, and post-trade compliance.
Projects
A sample of the work. Client names sit under NDA — these are the shapes that tend to show up on a first call.
Asset Manager
Two competing security reference sources, no clear owner, and a reconciliation queue that never cleared. Consolidated to a single golden source with automated quality gates and named data ownership.
One golden source, daily automated checks, and far fewer manual breaks.
Investment Platform
A mature SCD estate running well below its capability — manual workarounds in the middle and back office, and configuration drift across book structures. Re-mapped the front-to-back workflow and closed the gaps.
Fewer manual steps, cleaner book structures, and a supportable configuration.
Multi-Asset Manager
Position keeping and accounting books had drifted apart, so month-end depended on a handful of people who knew where the adjustments lived. Rebuilt the reconciliation strategy and data lineage between the books.
Month-end that holds without heroics, with audit-ready lineage on every number.
Risk & Performance
Exposure limits and attribution reports were built from spreadsheets the risk team could not explain to the desk. Designed the source-to-report pipeline and the returns methodology behind the attribution model.
Risk and performance numbers the desk and the client both accept.
Approach
A focused diagnostic of your data, systems, and workflows — where the breaks are, what they cost, and what to fix first.
A pragmatic target architecture and roadmap, grounded in how your teams actually work — not a vendor brochure.
Hands-on delivery alongside your team: configuration, data remediation, testing, and knowledge transfer that sticks.
About
Toronto, Ontario, Canada
Senior business analyst and data consultant specializing in capital markets and asset management. I help investment firms untangle the data and systems problems that slow down the front, middle, and back office.
My work sits at the intersection of the business and the platform: market data and security master design, SimCorp Dimension, IBOR/ABOR, risk management, performance attribution, and the full trade lifecycle.
Engagements are senior-only and hands-on — you get the person who did the analysis doing the delivery.
Contact
Whether it's a security master cleanup, an SCD implementation, or an IBOR that reconciliation teams have stopped trusting — the first conversation is free.