Following their purchase of another broker, our client had multiple data feeds. These included legacy broking systems in addition to their strategic broking platform. Combining these disparate systems into one reporting system was our main task.
The new platform utilised Microsoft SSIS for data integration and their SQL server for the data warehouse. We used the AWS database migration service and SAS visual analytics for data exploration, reporting and model building.
The environments were built using Cloudformation for the VPC and SAS EC2. The automation was achieved using Ansible, enabling rapid and repeatable deployment.
A modern, secure and scalable platform that achieved 44% annual cost saving compared with existing platforms. Data integration was achieved within a few days giving confidence quickly in the new system.
The reporting was quicker (20% quicker than existing) and the interface now allowed bespoke data exploration. The businesses were able to integrate quickly with a unified business intelligence platform.
See how we’ve used the best technologies available to help our customers achieve success.
Our client (BrightGen) is a Salesforce Platinum Partner who has successfully managed over 1000 Salesforce projects. They’ve been working solely with Salesforce since they were founded over 12 years ago. And they provide unrivalled knowledge of the platform to ensure their clients get a return on investment, fast.
Our client is an IT Consultancy who partners with many leading technology companies to deliver business critical IT solutions to a variety of organisations.
In 2018, a leading provider of education management software approached Alscient to assist with the setup of a virtualized desktop environment to support their development team. Following a strategic review, AWS was chosen as their platform of choice and our client was keen to validate the use of Amazon WorkSpaces.
