Cloud-Based Data Layer for Legacy System Reporting 

The client sought to develop a cloud-native automated semantic data layer with additional data handling capabilities, beyond the standard of existing products within the industry. This included the interpretation of raw, fragmented and inconsistent data across disparate systems, the translation of a unified, logic driven source and the automation of reporting-ready datasets. Following an investigation into the baseline of technology, it was determined that no system could automatically infer business logic or semantic relationships from raw, fragmented data; the underlying limitation for existing companies being the size of the data load. To resolve the uncertainties encountered the company undertook an iterative process including the development of a blueprint for the semantic layer, logic development for dynamic interpretation of meta data, the build of data ingestion pipelines, the development of cleansing logic and the integration of semantic layer outputs. This project would represent a clear stride in industry knowledge and semantic data capabilities as a result of the development of a scalable framework for financial data management.