application modernization – CONSULTING
Global consulting firm captures data at the speed of business
Overview
Businesses make better decisions with easily accessible analysis of real time data
Our client, one of the top five consulting firms wanted to improve one of their internal sales reporting systems that was using aging technology. In particular, the organization was unable to achieve real-time data capture, aggregation and analysis with its existing sales dashboard.
Enlisting the help of One Six Solutions, company leaders set out to replace slow internal systems and processes with a near real-time modern web application to view financial and operational metrics in a user friendly and performant way.
They wanted the application to be an internal showcase of the underlying technologies and something they could demo to clients.
Our Solution
Supporting real-time reporting and analysis
The One Six Solutions team worked alongside our client’s development team to architect a solution that could support sub-second response times. Together, our teams built out the service and caching layers to improve performance of data from downstream systems. ElasticSearch provided the ability to store vast quantities of unstructured data from numerous slower systems, as well as filter and aggregate the data at incredibly fast speeds using custom developed ElasticSearch plugins. The data was then displayed to the user using custom graphs and charts built in D3.
The teams also built complex business logic to do financial calculations, real time currency conversion and helped set the standard for modern single page applications within the group.
The application backend was built using .NET Web API and OData
The front-end was built using AngularJS
Non real-time data was stored in elastic search for efficient filtering and aggregation
Real-time data was processed using an enterprise service bus
Graphs and charts were built using D3
The Results
One Six Solutions’ contributions to this project helped streamline data aggregation and reporting, enabling our client to dynamically respond to market changes in real time. In addition, the solution our team developed helped set the standard for modern single page applications across their internal organization. Our team was subsequently called back for additional application build outs.