Introduction

This article will serve as a guide for architects who want to design, enhance, or augment existing workflows from within the loan-origination channel. It is part of a series of articles that describe the Loan-Origination Reference Architecture Pack (RAP). This article will focus solely on the workflow and orchestration capabilities of the RAP.

The guidance in this article will aid architects in unifying multiple loan-origination systems (LOS) and corresponding workflows. An LOS depends heavily on both loan processes and other services from within the enterprise. Unifying multiple loan workflows is a key concern for many lenders. With increasing acquisitions, and the respective increase in legacy systems, unification will give the necessary agility to be competitive in the banking industry.

Additionally, we will highlight how to automate the manual steps in the loan-origination process. As shown in Figure 1, oftentimes the largest bottleneck in the lending process is the manual steps. Between fax machines, paper-based forms, and manual data entry, this can get rather costly for lenders. Automation will ultimately shorten this process, referred to as the "application-to-close" process. Lenders can then process more loans with the same amount of infrastructure and personnel.

Figure 1. The current state of loan processing includes a blend of manual tasks and legacy systems.

The scope of this article is in the context of the Loan-Origination Reference Architecture Pack (RAP). Links to all the corresponding articles and downloadable binaries will be provided in the References section.

Today, the loan-origination process is fragmented and inconsistent between different lenders. This is due to workflow complexity. To stay competitive, lenders use varying business processes to derive decisions on loans.

To aid in the development of this architecture we chose to break the loan-origination process down into a set of basic capabilities that the higher order business capabilities depend on. Surprisingly enough, this process comprises four core capabilities.

Loan origination is composed of the following basic IT capabilities:

  • Long-running workflow
  • Approval processes
  • Orchestration of consistent business rules
  • Semi-static calculations

We will describe how to create enterprise-scale workflows that enable your loan-origination process to run more effectively, reduce the amount of redundancy in the process, eliminate manual processes, and automate paper-oriented processing.

Enabling Technologies

Described here are the enabling technologies that are used in our scenario:

  • BizTalk 2006—By using BizTalk, banks can now orchestrate their business processes in a dynamic and fluid way.
  • .NET Framework 3.0—Windows Presentation Foundation (WPF), Windows Communication Framework (WCF), and Windows Workflow Foundation (WF).
  • Orchestration of consistent business rules
  • WPF can reduce the training time of loan executives, officers, underwriters, and secondary marketing personnel. This is increasingly important in high-turnover areas.

    WCF will reduce the increased complexities of the integration needs. For example, it will cover integration of broker, correspondent bank, flood, mortgage insurance (MI), appraisal, credit, verification of funds, and cross-sell services.

    WF provides banks the flexibility to create workflows around documents, such as Office Excel, Office Word, and Office PowerPoint.

  • Microsoft Office SharePoint System 2007 (MOSS)—For Office SharePoint, Office Excel Server, and documents.
  • Office SharePoint can host your loan documents in a centralized, versioned, and secure environment, while also adding functionality, such as approval workflows and communications using Office Communicator 2005.

    Office Excel Server can host your Office Excel data in a centralized SQL Server information store. This robust relational database provides data protection, centralized backup procedures, a single version of the truth, and security around sensitive data. This also provides the Office Excel user experience for multiple services without cross-training on other applications.

    Document formats have been changed to Open XML, an open document format. This ensures cross-platform compatibility, robust integration, document manipulation opportunities, and controlled data integrity checks from within the documents themselves.

  • Microsoft SQL Server 2005—The repository of choice for storing all of the sensitive loan data needed for this solution. Additionally, SQL Reporting and Analytical Services will provide robust Web Parts to plug into our MOSS portal.

Loan-Origination Scenario

As mentioned in the introduction, we will be showing workflow in loan origination. For this scenario, we want to demonstrate the core capabilities of WF and BizTalk Orchestrations. We will walk you through a wholesale brokerage scenario, from the application process through the underwriting decision.

Please note that document-preparation and loan-closing processes have been excluded. The capabilities demonstrated within the architecture will show you how to build document-preparation and closing-document capabilities. The remaining capabilities will be addressed in forthcoming publications.

Figure 2. Business process that we will model in our scenario

We will model our workflow after the business process shown in Figure 2. The purposes of these stages in the loan are as follows:

  • Registration—When the customer enters the proper qualification information for a loan product.
  • Select product and rate—The process in which personnel at the lender will analyze the secondary market and apply the proper pricing to the products (for example, 30-year fixed) or their portfolio products (products that the bank funds and usually does not sell to other banks or the secondary market).
  • Locking loan—When a customer agrees to a specific product and rate, and "locks into a commitment." This stage kicks off many subprocesses that gather extended information on the customer, to prepare the underwriters to make a decision on the loan.
  • Processing—This stage is where lender personnel known as "processors" gather the necessary documentation and prepare data for an underwriting decision. Processors are the data-entry point of the process.
  • Underwriting—The process in which an underwriter makes a decision on the loan for approval.

We will automate the majority of these stages in the workflow. As shown in Figure 1, there are many manual processes that hinder the process. To automate these steps, we have to look at the core capabilities that we want to expose from the loan process. We will be deriving the previously mentioned capabilities from the macro level and diving more into the details around the human workflow capabilities.

  • Document management and routing—Documents are routed, consumed, verified, and filed throughout this process.
  • Content management—Loan status, comments on loans, and rate bulletins are needed for both internal and external users.
  • Information security—Information that is required for a loan—for example, borrower's assets, liabilities, employment, and personal data—is of the utmost importance. It must be protected at all points in the process.
  • Automated data retrieval—Data is gathered from multiple sources both internally and externally through third-party services.
  • Document preparation—Documents are prepared in multiple stages in the process, such as before underwriting and when a loan is fulfilled for the borrower.
  • Unifying multiple loan systems—In many cases, lenders have many loan systems for both Point-of-Sale (POS) and Loan-Origination Systems (LOS). Choosing the right one for the right loan or loan product can be confusing and time-consuming.
  • Automated approval processes—Approval is often manual and requires individuals to hand-deliver or e-mail documentation for an approval. This is yet another bottleneck in many loan processes.
  • Electronic Interface for Brokers—In some cases, brokers have only manual means to interact with a lender. This can be time-consuming and can affect the relationship between the lender and the brokerage firm.

Breaking down these capabilities, it is easy to see why it takes lenders so long to approve and fund loans. We will focus on these detailed capabilities mentioned previously, and automate many of them—through the use of the Windows Workflow Foundation workflow automation capacities, BizTalk system orchestrations, and MOSS—to provide our core set of application services that will facilitate our process.

Human Workflows and System Orchestrations

Before we dive into the solution, it is important that we understand some basic principles of our architecture. The terms workflow and orchestration have been used throughout this article. These types of flows are similar but very different.

  • Workflow—Workflow is a style of computing in which a process is decomposed into a series of steps or events. These events flow from one step to the next based on conditional evaluation. The majority of the time, workflow is composed of activities that are carried out by humans.
  • System orchestration—Orchestration is a specific type of workflow that is generally applied to the construction of business services from business processes. Orchestrations do not include human-performed activities.

Perhaps the most well known Microsoft implementation of workflow today is in BizTalk Server (although BizTalk Server uses the term orchestration, instead of workflow). BizTalk Server lets developers create system workflows for business-process management (BPM), enterprise application integration (EAI), and business-to-business (B2B) integration. The next release of Microsoft BizTalk Server will add support for creating WF workflows targeting these areas.

Figure 3. Human workflow versus system orchestration

BizTalk Server and Windows Workflow Foundation have some obvious similarities. To a developer, for example, the BizTalk Server Orchestration Designer looks much like Windows Workflow Foundation's Workflow Designer. This commonality is no accident; the same group at Microsoft is responsible for both technologies. For the most part, however, deciding which one to use for a particular problem is not hard. What follows are some guidelines to help you make this decision.

Use Windows Workflow Foundation When:

  • An application itself will host workflows. Windows Workflow Foundation lets workflow be built into an application, allowing the workflow to be deployed and managed as a native part of the application. Conversely, because it's focused on integrating diverse applications instead of providing a general workflow framework, BizTalk Server always runs orchestrations within the BizTalk Server process that is external to the application.
  • The business process being implemented requires human workflow. BizTalk Server addresses system workflow, and so it lacks Windows Workflow Foundation's support for things such as state-machine workflows and dynamic update. A scenario that requires both human workflow and more complex system-integration services could be addressed by using Windows Workflow Foundation and BizTalk Server together, however. For example, the Microsoft Office 2007 support for document-centric workflows, based on Windows SharePoint Services, might be used for the human aspects of the problem, while BizTalk Server handles the system integration aspects. The two can interoperate using the BizTalk Server Adapter for Office SharePoint.
  • The workflow will execute on a client system. BizTalk Server is a server-focused product, and so it's less well-suited to run on desktop machines.

Use BizTalk Server When:

  • Solving an EAI problem that requires communication with diverse applications on diverse platforms. Because of its focus on cross-platform integration, a large set of adapters is available for BizTalk Server that allows communication with a range of other software. Windows Workflow Foundation is focused solely on workflow, not EAI, and so it does not provide these things.
  • B2B services are required. Windows Workflow Foundation does not address this area, while BizTalk Server provides tools for working with trading partners, accelerators for Mortgage Industry Standards Maintenance Organization (MISMO), Society for Worldwide Interbank Financial Telecommunication (SWIFT), and other industry standards.
  • BPM services, such as Business Activity Monitoring (BAM), are required. While the Windows Workflow Foundation tracking infrastructure can be used to create these services, BizTalk Server provides important extras, such as tools that let information workers define their own BAM views.
  • A complete management infrastructure and support for increased scalability are required. Unlike Windows Workflow Foundation, BizTalk Server includes a full set of tools for administering and scaling a production environment.

Enabling Enterprise Workflows

For this reference architecture, we want to architect this solution in such a way that the workflows and orchestrations can interact and manage other external workflows. To enable these capabilities, we will rely on BizTalk's usage of industry-standard Business Process Execution Language (BPEL).

Figure 4. BPEL usage within the enterprise

A common thread within the process is the information that it uses. Throughout the loan process, data is gathered, manipulated, and sent to other systems. If we have a centralized loan-information store, business processes can work together more efficiently.

Figure 5. Centralizing information

For our scenario, we are only looking at origination and underwriting. However, we want to ensure that we provide mechanisms that can automate the downstream processes, too.

At the center of Figure 5 is a store of common information, such as borrower, assets, liabilities, and property. Aligning the information with the process areas containing information common to loan processing will also provide an information model for both process and information consolidation.

Using open standards for consumer mortgage is also helpful when interoperating with other system workflows. For example, MISMO has organized the business-process areas across the mortgage industry under four broad categories: Origination, Servicing, Secondary, and Real Estate Services. Processes under Origination include Mortgage Application, Underwriting, and Closing; Servicing includes Loan Setup and Transfer, Investor Reporting, and Default Reporting; Secondary includes Securitization, Bulk Pool Transfer, Funding, and Pricing and Discovery; and Real Estate Services include Appraisal, Credit Reporting, Flood, Mortgage Insurance, and Title.

MISMO aligns directly with the business process that we are enabling. However, RAP can support multiple loan channels, such as commercial. Organizations considering consolidating or augmenting multiple channels must ensure that they employ the right standard. For example, MISMO is a U.S. consumer-mortgage standard and would be inappropriate with other channels.

Architecting Human Workflows for Loan Origination

The human workflow aspect of the architecture will be controlled by Windows Workflow Foundation. WF will be running in conjunction with MOSS. Our architecture can now interact with several key areas:

  • Document libraries—Standardized MISMO XML will be saved to document libraries, to be versioned and to trigger key events in the lending workflow.
  • Web services—Because the key to our architecture is extensibility with XML, Web services will be used throughout, thus loosely coupling each layer that provides a rich interoperability story between our varying workflows. In turn, Web services provide the flexibility in the communication between workflows and orchestrations.
  • Tasks—Tasks are assigned within MOSS to accomplish specific workflow duties. This helps with the asynchronous behavior of the master loan workflow (MLF).
  • E-mails—Underwriters can receive their loan pipeline right to a familiar Office Outlook client, thereby providing rich collaboration and information rights management features.

For the loan application, we created several workflows, including:

  • Master Loan Workflow (MLF)—This is the workflow that manages the entire life span of the originated loan, from registration to closing.
  • Products and Pricing (PPF)—Enabling Office Excel to interact with a products-and-pricing workflow that enables approval processes and alerting mechanisms.
  • Office InfoPath Form Flows (IFF)—This is not a WF workflow, but instead a set of views within the registration and underwriter entry forms. Because Office InfoPath takes care of the flow and presentation validation automatically, there will be a dramatic drop in UI development time.

Figure 6. Global workflow within the Loan-Origination Reference Architecture

As shown in Figure 6, there is a bit of intersection between the workflows. There are a variety of types and styles in which these workflows are used. Different personas and activity requirements drive the design of the workflow architecture. We are exposing the best-of-breed workflow solutions for each of these.

Products and Pricing Flow (PPF) is the mechanism that allows for the loan products and pricing process to occur. Because of the serial behavior of this process, we choose to use a sequential workflow.

However, for the Master Loan Flow (MLF), a state-machine workflow was used. The interactive nature of this workflow drove this decision. Documents are consistently updated and are working through various approval processes in a non-serial fashion. Additionally, this is a long-running workflow that will potentially last for several weeks.

The InfoPath Forms have their own sequential flow built in. By using the view feature of Office InfoPath, we can simulate multipage groups of forms. As an InfoPath form is iterating through the update of XML stored in the document library, the changes in the file trigger events in the MLF. Thus, Office InfoPath does not internalize any of the workflow, but rather indirectly invokes the workflow.