Scotiabank used IBM’s MQ for mortgage requests you can fire and forget – User Case Study
Fire and forget applications are that rare half-breed between teal time and hatch processing, that need to work in a given timeframe, in a given order, but where usually, the effort to make them real time wouldn’t be worth it.
Scotiabank decided that this applied to its mortgage lending process, and set about a year-long shift from manual to automated processes to speed up the client experience and efficiency of its mortgage process.
It decided on using IBM’s Websphere MQ Workflow, which sits on top of MQ for messaging services. “We needed to replace a paper-based system of fax, paper and voicemails, linking our 1,000 branches with two central units,” Dale Hamilton, director of the Architectural Office for Scotiabank said.
“The reason we did it was to save time for both the clients and our staff, get a reliable audit trail, for the sake of accuracy and to eliminate duplication.”
Although the first application was mortgage borrowing, the way the bank approached the problem was to build a sub-structure for applications that could later he used to support other, similar processes.
“It’s especially important for pre-approval of mortgage to operate faster. This will improve the client experience with the bank and that in turn will improve our market share,” explained Hamilton.
The project took 15 internal staff and some contractors from IBM. And the bank used its own senior technical staff for mentoring the staff at the site. Much of the work was writing adapters that run on top of MQ into other applications.
“There are a lot of jobs that you still need to do on your own and we put these in an abstraction layer between MQ Series and our applications such as logging, tracking and security, auditing and recoverability were all elements of the system that we had to write ourselves,” explained Hamilton.
“MQ offers asynchronous communications, a sort of fire and forget process, so in order to be sure that transactions have completed we needed to ensure that there was a two phase process for committing transactions.”
The bank’s central database is housed on DB2 on its zSeries mainframe bat this also has to link to remote Unix servers, running IBM’S AIX, and the bank decided to put its MQ servers on AIX too. MQ then has fingers out into all the different applications on other machines. One of the reasons for picking MQ Workflow was its ability to run on almost any other Unix machine, including Solaris and HP-UX and even Microsoft Windows 2000 and 2003 servers.
“On the old system, fax traffic in particular was very messy,” says Hamilton. “You’d get incomplete fax messages, or faxes with scribbled, handwritten notes on them. People would then send a fax of the fax back with more notes and then voicemails would trail round the bank trying to iron out problems. The mission was to put in place a solid foundation for dealing with all this data online and in the process eliminate a lot of non-value adding activity.”
“Approval of a mortgage is a fairly lightweight decision in terms of processed data, but completion of the transaction is far more complex. You have lawyers and teal estate agents in the loop, governing bodies that need document filings, and that’s a lot of detail. Lose any of it and you have to touch the client one more time to iron it out, and that uses up valuable time.
“You don’t want any of that to affect your dosing date. People don’t go back to a bank if they have a poor experience, and missing dosing dates is something that just can’t be allowed to happen.
“We talk about having built a service-oriented architecture, which is an enterprise wide approach to the organization of application programs, working alongside middleware and a process workflow engine, tied into other systems like the corporate directory and security. Effectively we’ve built a foundation and put the plumbing and technical framework and capacity in place for any number of applications.”
MQ Workflow has a tracking mechanism so that you can define all the steps in a workflow process and it will keep track of it for you. The process you’re defining might be a 10 day thing. It will produce work lists, and reports of its activity.
“We’ve had a number of other uses of MQ for what we call ‘pointed’ solutions, where fire and forget is appropriate, where you don’t need real time power. When all you need to do is reliably send data between two systems, you reach for MQ.
“We have used it for synchronous workloads, but that creates quite a layer of complexity on top of MQ to make it behave like a synchronous protocol, and we probably won’t go down that route again. Nowadays there are web services protocols like SOAP that are better suited for real time connector architecture work.” From the original decision, the foundation and framework were in place, the mortgage workflow system finished and all the branches rolled out, in just 12 months.
“The workflow engine affects all of the applications that it is going to run against. Many of the applications didn’t have hooks into MQ, and we had to modify them and provide those hooks and then phase in the new system over 1,000 branches.
“For a time there we had to support both paper and MQ version, today’s applications and tomorrows versions at the same time, while upgrading branches a group at a time,” said Hamilton.
The biggest point of concern over the whole project for Hamilton was when his team tried to build a wraparound security system using some of the more advanced MQ features, and Scotiabank just couldn’t get these facilities to work.
“There were some integration issues between the Workflow and MQ related to security, you’ll understand if I don’t talk in detail about our security, but it held us up for a couple of months until we could get a workaround,” said Hamilton, but said that apart from that there were few other sticky moments.
Scotiabank is one of the five biggest Canadian banks, offering retail, commercial and corporate financial services and a full range of domestic financial services, from household and small business banking to wealth management, as well as corporate capital investment and online banking.
It has CAN$290bn in total assets and operates in 50 countries with almost 1,000 branches, four call centers, 2,200 automatic teller machines.
Since the mortgage application was finished, MQ Workflow has also been used to upgrade the workflow processes for loans across the company.
COPYRIGHT 2003 Rethink Research Associates
COPYRIGHT 2004 Gale Group