GSE: Datamart Design and Build
The Problem
A government-sponsored enterprise needed a centralized data solution for its forecasting process, which involved cross-functional teams from different business lines.
The firm also sought a cloud-based data warehouse to host forecasting outputs for reporting purposes with faster querying and processing speeds.
The firm also needed assistance migrating data from legacy data sources to new datamarts. The input and output files and datasets had different sources and were often in different formats. Analysis and transformation were required prior to designing, developing and loading tables.
The Solution
RiskSpan built and now maintains a new centralized datamart (in both Oracle and Amazon Web Services) for the client’s revenue and loss forecasting processes. This includes data modeling, historical data upload, and the monthly recurring data process.
The Deliverables
- Analyzed the end-to-end data flow and data elements
- Designed data models satisfying business requirements
- Processed and mapped forecasting input and output files
- Migrated data from legacy databases to the new sources
- Built an Oracle datamart and a cloud-based data warehouse (Amazon Web Services)
- Led development team to develop schemas, tables and views, process scripts to maintain data updates and table partitioning logic
- Resolved data issues with the source and assisted in reconciliation of results

All of these features are built into RS Edge, a cloud-native, data and analytics platform for loans and securities. The RS Edge user interface is accessible via any web browser, and the processing engine is accessible via an application programming interface (API). Accessing RS Edge via the API allows access to the full functionality of the platform, with direct integration into existing workflows in legacy systems such as Excel, Python, and R. To tailor RS Edge to the specific needs of a CRT investor, RiskSpan is rolling out a series of Excel tools, built using our APIs, which allow for powerful loan-level analysis from the tool everyone knows and loves. Accessing RS Edge via our new Excel templates, users can:
The images are examples of a RiskSpan template for CRT deal comparison: profile comparison, loan credit score distribution, and delinquency performance for five Agency credit risk transfer deals, pulled via the RiskSpan Data API and rendered in Excel. ______________________________________________________________________________________________



