The Solution
Phase One – Intelliflo Integration
Transparity built the integration for Courtiers’ on-premises system to send information to Intelliflo via its API. This is daily for the valuations, continuously for the transactions and quarterly for statements. It uses a combination of Logic Apps (to retrieve the Oracle data) and Function Apps (to upload the data to Intelliflo) and runs in the Courtiers Azure tenancy.
Phase Two – Desktop App Development
Transparity created a new web application (PFP Extension App) deployed as an Azure Web App in the existing Courtiers Azure tenancy. The app provides a place where Courtiers can continue to extend the PFP application where required.
The new app contains the Transaction History page with the facility for users to organise their policies into logical groups so that transactions for policies within the groups, as well as for individual policies can be viewed. Though superior in functionality it is similar in design to the legacy supplier for an easy client transition.
Users access the PFP Extension App via a link in a widget from the PFP application. The user’s authentication is silently maintained between PFP and the PFP Extension using a signed URL generated by the PFP widget, providing a seamless experience for users.
To further enhance the user experience, the PFP Extension Portal was designed as mobile-friendly. This allows the users to see as much clear data as possible depending on the device’s screen real estate.
Phase Three – Portfolio Assets
Since launching the PFP Extension Portal additional functionality has been added to provide a breakdown of the client’s portfolio assets.
Using another custom widget on the PFP application, the user can navigate directly to the new Asset Allocation page. On this page, the user can view their holdings broken down by asset type, currency, county or region. The data is displayed as charts or geography (where appropriate) and the user can drill down to see the value or the percentage of the assets in the funds.
The fund asset allocation data is generated daily by Courtiers. A new Azure Function App was developed to pick up this data from a file store and load it into the PFP Extension Portal’s Azure SQL database. The asset breakdown chart/map data is generated by extracting the client’s fund-holding data from the Intelliflo API and calculating the percentage/value using the asset allocation data.
