https://store-images.s-microsoft.com/image/apps.37615.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.d11dc324-4040-4efc-8c5e-6f94835f337d

ULDD - Automate & Optimize Mortgage Process

by Brimma Tech Inc

Accelerate borrower engagement, cut costs & securely bulk upload loan documents to Fannie Mae

Process

Accelerate borrower engagement, cut costs & securely bulk upload loan documents to Fannie Mae.

Overview

Using Microsoft Power Automate, the - Brimma Uniform Loan Delivery Dataset (ULDD) bot can help you download loan documents quickly and securely from the Encompass Loan Origination Software System (LOS) and then upload them to Fannie Mae’s web portal.


What is Brimma-ULDD

The Uniform Loan Delivery Dataset (ULDD), part of the Uniform Mortgage Data Program (UMDP), is the common set of data elements required by Fannie Mae .

The automation bot exports the loans from the Encompass system based on the commitment number and then import them to a local drive before uploading them to Fannie Mae's web portal

How it works?

  1. Bot logs into Encompass

  2. If there are loans available in the pipeline:

  • The bot exports loans from the pipeline to Excel
  • Identify the Commitment # of the first loan in Excel

  • Filter pipeline for the identified Commitment #

  • Select up to a maximum of 5 (this should be a configurable value) loans and export ULDD XML for the selected loans

  • Click “Export” button on the “Export Problem” popup if displayed

  • Name the exported XML as “FannieExport-{datetime}-{commitment#}.xml”

  • Identify the loan numbers of the loans in the XML

  • Log into FNMA portal and upload the XML file

  • Retry uploading the XML one more time if it fails the first time

  • Update the loans in the XML as Successful / Failed on the “Automation Testing” screen in Encompass, via API

  1. Exit Encompass


At a glance

https://store-images.s-microsoft.com/image/apps.259.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.160269b3-a9bb-47c7-b7f7-ee958036bce9
https://store-images.s-microsoft.com/image/apps.46089.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.5c167f34-4682-4375-9c6a-9e168a4d2c81
https://store-images.s-microsoft.com/image/apps.53088.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.512d6477-24a6-4d5d-82e0-7f9bcf7612d2
https://store-images.s-microsoft.com/image/apps.48011.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.07de4ba8-db64-4296-8f51-24d9e9cefb17
https://store-images.s-microsoft.com/image/apps.42959.27356e23-7409-4acc-8411-74a9da7ae6be.af3fb08d-a68b-48f0-9e0e-2b680c63567b.d6591614-1770-4249-ba44-39344b1fafe2