Case study for integration and customisation of an investment product solution in the investment industry
What are some important data integration issues that companies typically overlook?
The most overlooked data integration problems and challenges that we come across include:
- • Using a data profiling tool to analyse and measure data quality of both source or target environment data before developing the integration logic.
- • Establishing data acceptance criteria for an individual application system. Perfect data isn't practical; the focus should be "good enough." Moreover, the business stakeholders involved in an integration project should be able to identify usage scenarios that reflect what "good enough" looks like.
- • A data quality/accuracy review step as part of the design review step in an overall development project.
- • Establishing standard load and export interfaces for systems that provide data and take it on board on a regular basis. Most integration development follows a one-off approach even when it is common for some systems to on-board data from new systems on a regular basis.
A large diversified financial service provider with an international footprint
Our client outsourced their investment product administration to Silica. To get this working, integration and various system changes between Silica, Astute and several in-house systems were imperative. The system was developed for migration of data to the new platform, integration of services, daily imports, fund administration and commission and fee calculation.
DVT assisted our client through a skills augmentation service. DVT provided software development professional services that ensured our client had a high performing software development team that can deliver business value faster in Scrum Agile Sprints. DVT utilised Scrum Masters and Java developer consultants on the assignment.
- RESTFul Web Services
- Mule ESB
- Spring Batch
- SSIS and SQL Server