Insight Dashboard Execution and Automation (IDEA) for GSE

This broad MSA covers departmental and corporate-wide initiatives: model applications, databases and platforms for model infrastructure and integrating analytics tools. This MSA supports several corporate-wide initiatives being led by the business area we support- a Big Data platform transformation and analytics engines for new accounting and regulatory requirements such as Earnings at Risk and Current Expected Credit Losses (CECL.) The Insight Dashboard Execution and Automation (IDEA) forecasting model platform is one of many application tools our staff have worked on. This work occurred under a Master Services Agreement akin to an IDIQ, with over 10 years, demonstrating Oakleaf’s experience managing multiple IDIQ-type task order contracts. 

 

The work scope includes assisting economists and risk managers responsible for complex models, and developing tools and products to report and graphically display complex information.  

 

The Oakleaf engagement with the Finance Business Analytics group has involved years of engagement with their teams supporting their model infrastructure responsibilities, where the company’s principal forecast and historical statistical models are executed, including the runs and reports of outcomes. These reports support analysis and research by sophisticated users without technical programming skills. Oakleaf’s efforts resulted in the models executing faster and therefore their large volumes of statistical data had understandable and accurate metrics, reports and graphical dashboards and displays, which the risk management and economists used in their key decision-making.

 

One application is the Insight Dashboard Execution and Automation (IDEA) project, a forecasting model platform utilizing SAS, Netezza, Tableau, Java, Python and on an Oracle Database, designed to make forecasting tools easier in the hands of non-technical users. The platform automates the modeling process and incorporates modeling lifecycle management. Users without knowing SAS or R are able to access its expansive reporting capability through Graphical User Interfaces, generating sophisticated runs with multiple scenarios. Models are profiled as cases, run through this interface and the resulting risk data is displayed in charts and graphs, helping to identify the issues with the run or the data or other issues.

 

The architecture for IDEA was utilized in other major department applications- a Single Family Forecast Framework and a Housing and Recovery Act framework. Our documentation directly supported this effort. 

 

Oakleaf’s intimate knowledge of the analytic environment, tools and models at Fannie Mae has allowed us to hit the ground running on many new assignments. Our strong command of the datasets and model output analytics on the IDEA project directly contributed to its effectiveness and success, saving the time of many individuals.

 

Many sets of different-origin data are brought together into the IDEA platform. This massive amount of data was cleansed and scrubbed. Oakleaf helped the client’s teams to develop and make reports that compare the models, improve sampling, compare outputs and develop sensitivities.  Using newer processes with core SAS functionality produced reconcilable results using newer, automated processes. This included reusable chains of automation runs and an architecture that could be leveraged for other projects.