ADRM Software: Helping Banks Transition to a Modern Data and Analytics Architecture, On premise and in the Cloud

After weathering twenty-five years of banking data analytics evolution, ADRM Software has developed a robust set of integrated banking data models that CEO Kevin Schofield describes as “three to four times the size and level-of-detail” as that of other competitive offerings on the market. Their years of relentless testing and innovation have resulted in collaborations with Microsoft and Amazon Web Services to bring banking data and analytics to the cloud, in addition to more traditional large-scale on-premise data warehouses and managed data lakes.

“We’ve seen an increasing number of our customers shift first from traditional data warehouses to more of a hybrid managed data lake, which typically includes unstructured storage in combination with more traditional relational, and often MPP-based, data infrastructures,” explains Schofield. “Now we’re beginning to see some of our banking customers shift portions of that new infrastructure into the cloud or to a hybrid architecture including on-premise and cloud data and that is requiring many banks to revisit their information architectures to ensure they have the flexibility to maximize the return on their analytic investments.”

By using combinations of new technologies, such as Microsoft’s Azure SQL Data Warehouse and Azure Blob storage, or perhaps Amazon Web Service’s Redshift with their S3 object storage, banks are able to transition to a modern data architecture. Whatever deployment architecture a bank chooses, ADRM helps banks deploy a comprehensive information architecture faster, with less risk, and while benefiting from best practices and lessons learned by other large and mid-sized banks.

A common challenge Schofield’s team helps banks to overcome is to integrate data from disparate sources in a way that allows banks to achieve a unified information architecture. “A very common use case for our banking customers is that they often have a wide variety of analytic assets, ranging from multiple data marts to one or more data warehouses and perhaps even a separate reporting database for BASEL compliance, so they are struggling with integration issues and the need to update the same information in multiple places,” says Schofield.