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 client wanted the application to be an internal showcase of the underlying technologies and something they could demo to clients.

Dot Net logo full color
AngularJS logo full color
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.