top of page
Collier & Associates brand mark featuring the core services: Business Transformation; Enterprise Systems; AI-Enabled Execution.

Multi-Asset Investment Management Firm — $2B+ AUM · Project 2 of 2 · Interim CIO, 3 Years 4 Months

Client Challenge

  • 20+ year-old legacy systems could not support growth or the new product model

  • Front- and back-office operations were fragmented; an underperforming third-party consultancy had the implementation off course

Client Solution

  • Project Recovery: Terminated the underperforming third-party consulting firm and redirected the implementation

  • Data Architecture: Architected future-state master and transactional data taxonomies; converted 20 years of Access/Excel data to the new platform

  • Bolt-On Suite (C#/.NET): Designed and developed the LedgeX add-on suite — data-integrity rule engine, NAV returns and Modified Dietz performance calculations, AWS-hosted manager due-diligence survey middleware, a portfolio/performance/manager reporting suite, and an extensive expansion of LedgeX’s IRM module into a full CRM

  • Capability Transfer: Implemented Agile DevOps and trained a client employee to own future development and support

Client Impact Results

  • LedgeX Portfolio Management implemented in under 1.5 years on a centralized, fully integrated multi-asset platform supporting fund-of-fund investments, client and investor relationship management, and manager due diligence and monitoring

  • ~95% improvement in data quality and accuracy

  • 42 report sets consolidated to one integrated reporting platform

  • Internal staff prepared for long-term system ownership on Agile DevOps

Client Technologies

  • LedgeX Portfolio Management Software

  • C#/.NET with Silverlight and LightSwitch front ends; T-SQL/SQL Server; SSRS

  • AWS-hosted MySQL → SQL Server due-diligence survey middleware; ETL data conversion pipelines

Andy Collier worked with us as our consultant to help us restructure our data management processes to help align them to better fit our company strategy, better serve our clients, and maintain high standards of compliance with investment industry regulations. Andy worked closely with us to understand our business and the variety of options we had, including third party software and build-your-own. We opted for a hybrid solution, taking advantage of commercial software while maintaining a high degree of flexibility for development and growth in the future. Andy was instrumental in helping us launch our transition into a new system and reengineered significant portions of our database to fit our strategy and our needs. Because of Andy’s experience, he was able to help us in developing high-level strategic solutions as well as the detailed work of coding. Our end result is a data processing system that is the equal to our most sophisticated peers, allowing us to track our clients’ performance across a variety of investments, including mixtures of private equity, hedge funds, and mutual funds. In addition, Andy helped establish a platform for investment analysis that allows us to quickly perform proprietary manager analysis and helps lead us toward selecting the best funds and investment managers. Andy continues to work with us on specific projects and is a valued resource.

Joel Mangham Principal and CIO

bottom of page