U.S. Department of Housing and Urban Development (HUD)- Federal Housing Administration (FHA)

The Challenge

The Federal Housing Administration’s Mark-to-Market mortgage program was established to preserve the nation’s limited supply of multifamily affordable housing. The program is complex with multiple mortgages for a single property, differing repayment terms, a multi-phased payment process, evolving program rules and other unusual components. This made it difficult, and extremely time consuming, for managers to track and analyze all the elements of program performance.

While the data repository could produce hundreds of different reports, they were largely used to monitor transactional operations or report accounting results. Program managers needed to be able to write analytical and exception-based queries based on complex scenarios and get the information they needed within minutes-not days or weeks.


The Solution

Dynaxys began by asking FHA managers for the questions Congress and others frequently asked about the Mark-to-Market program. We wanted to know how data could best be used to help staff analyze program results. We then developed a business intelligence tool capable of analyzing the volumes of data stored in FHA's relational database. The tool allows FHA program managers to examine data relationships using different measures in different dimensions and to array the data in an unlimited number of views, depending on what they need to know.


The End Result

With the new business intelligence tool, the program director has information-literally within minutes-that reveals how well the program is working. Decision-makers have a clearer idea of program performance. Best of all, it is possible to quickly and confidently answer Congressional committees’ or other stakeholders’ questions.