Project Overview
Custom fund software was developed by Transparity for Ipes after off-the-shelf systems proved too inflexible. The brief called for real-time investment and banking views, configurable client/investor portals, reporting and document storage, plus full bookkeeping and reconciliation across funds.
Through team augmentation and App Innovation, Transparity designed CapitalTracker.com on the Microsoft stack, with an app-based, web architecture and deep data connectivity aligned to Application Integration practices. Outcomes included branded client portals, 95% straight-through processing via SWIFT data, reduced transfer pressure, and growth evidenced by winning the Hermes GPE account; ongoing support aligns with Application Managed Services.
The Challenge
Many of the firm’s competitors relied on off-the-shelf software packages, which Ipes found lacked the flexibility to fully meet client demands. In 2010 and doubting that suppliers of existing software systems would be willing to provide the required enhancements, Ipes decided to invest in the development of their own platform, which would offer significant benefits to clients and to their internal operation.
In the spring 2012 edition of CIO Connect Tim Andrews, Director of Development at Ipes said, “We realised that if we used all the standard systems, they would be too inflexible and would not actually support the processes we use, so we decided to build all our own systems.”
Ipes wanted to enable their own staff, their clients and clients’ investors to have real-time views of investment activity, transfers, and multi-national bank transactions. The platform specification needed to include customisable live data views, reporting and document storage and provide the ability to deal with all internal book-keeping and reconciliation functions. For the first-time clients would have web-based access to live banking information without the need for uploading to a presentation system. Client portals could also be customised depending on individual requirements to include different levels of access and accommodate preferences in terms of layout and presentation. The platform would lead the way, compared to competitor capability.
The Solution
With proven expertise in delivering custom enterprise software development to mid-size and large organisations, Transparity was brought in to design and deliver the system to Ipes’ precise requirements.
Transparity provided a full development team. Initially this was as an external project based at our own offices, and, once the first system version was completed and live working as an embedded team within Ipes, but still based at our HQ and with the proactive guidance of Transparity.
They conceived and designed the system, and with their deep experience of the Microsoft Application Platform they were a key factor in the architecture design and its implementation. The result was CapitalTracker.com, the first entirely web-based system in the field, with an app-based architecture enabling customised views of data in real-time to all users. Investors could now see live valuations, transfer information and obtain up to the second reports; clients could view the information for all their investors; and Ipes staff now had access to the same information across all funds being managed.
The technology behind CapitalTracker is primarily ASP.NET, C#, SQL Server and T-SQL.
- The user interface was based on apps that are developed as ASP.NET controls with JavaScript, JQuery and AJAX.
- .NET Server-side security ensured that each user could only request certain pages and apps.
- Data requests were made over REST primarily to WCF Data Services and Entity Framework.
- LINQ to Entity Framework was used extensively for server-side data requests.
- The more advanced apps made use of Knockout.js.
- A unique and proprietary Data Widget software layer enabled power users to design their own Apps using a drag and drop forms designer and a data configuration file. Most of the apps have been developed successfully using this toolset.
The Outcome
All banks subscribe to the SWIFT system for transfers, and Ipes became the first and only independent private equity fund services provider to join. Capital Tracker therefore directly accesses the same information as the banks. Capital Tracker is also flexible enough to allow for branding by Ipes clients, who can then not only offer their investors financial statements and information relating to transactions but also document storage, partnership agreements and KYC (Know Your Customer) compliance information. Additionally, it handles secretarial work such as registration with local regulators. It is a single system with many views, all live.
Traditionally two-thirds of transactions benefit from straight-through processing, the remainder requiring manual intervention within the banks. SWIFT membership and CapitalTracker now enjoy 95% straight-through processing. In turn, this means the banks allow later cut-off times, and Ipes has been able to negotiate lower rates for clients. Transfers are liable to high pressure from investors and this has been much reduced. CapitalTracker.com was launched in the latter part of 2011 and was instantly popular with all stakeholders. The Transparity relationship continues and two developers remained with Ipes under long-term contract to support the system and develop further enhancements.
Highlighting the continuing success of this project, in 2013 Ipes won the major UK fund manager Hermes GPE account due in a large part to Capital Tracker. Karen Sands from Hermes GPE said, “We felt Ipes was a good fit for us and our investment style…We wanted to make our information-sharing process as smooth as possible and work with a depositary whose technology facilitates electronic record keeping. Capital Tracker ticked those boxes and enables us to see the activity when it occurs.”
