Make faster, better lending decisions

Jonathan Walker needed a faster, more reliable way to support risk management and marketing efforts at Local Government Federal Credit Union.

“We were trying to use Excel in a way Excel is not meant to be used,’’ recalls Walker, LGFCU’s Business Intelligence Manager. “We had big challenges consolidating our data across multiple sources.”

In particular, LGFCU needed faster, more reliable insights about the impact of loan delinquencies on the balance sheet.
Excel was slow and unreliable. Manual data entry made errors common.

“Honestly,” says Walker, “sometimes we would have to run programs overnight and just hope that something didn’t break in the process and cause us to do it all over again.’’

With SAS® Business Intelligence, analysis that once took hours now takes minutes.

“I was spending 80 percent of my time on data preparation before using SAS,’’ explains Xin Pan, a Business Analyst on Walker’s team. “Now that I spend less on data preparation, I can focus on building a credit risk management system.”

Anticipating customer needs

Because SAS makes it easier to merge internal and external data sources, LGFCU can better anticipate the borrowing needs and understand the financial circumstances of all 230,000 members.

For example, LGFCU analyzes economic conditions in each of the state’s 100 counties and merges the data with its member data for a more complete and accurate view of each community and customer.

“We’ve really been able to streamline the process using SAS,” Walker says. “We have completely automated output without the need for tools such as Excel.’’

Meanwhile, Marketing Strategy Analyst Danielle Brummitt has a better understanding of how to communicate with each member, thanks to the 360-degree customer view that SAS gives her.

“We can actually look at transactional data coming from the branches,” Brummitt says. “We could not do that before we started using SAS. It was too much data.”

Now we can work with billions of rows, and our processing time has improved, in some cases, from days to minutes.

Jonathan Walker
Business Intelligence Manager

Easing the regulatory burden

Federal regulators keep a close eye on mortgage-assistance programs that many lenders, including LGFCU, offer to struggling homeowners.

In fact, one of the required compliance reports includes more than 70 calculated fields, which caused headaches using Excel.

“SAS has streamlined the process, allowing us to provide this data faster to the lending department,’’ Walker says. “A federal regulator told me that the way we use SAS and analyze the data is something few other credit unions do and that our methods are paying off. It’s just great having these SAS resources at our fingertips.’’

Chris Koontz, the credit union’s Data Integration Architect, applauds the ease of installation and the gains in computing power.

“It took about two days to install the BI component,” he says. “Now we can work with billions of rows, and our processing time has improved, in some cases, from days to minutes.”

Visualizing data

LGFCU is implementing SAS® Visual Analytics to give senior management a way to visualize data correlations across multiple variables and billions of rows to make faster, more informed decisions – whenever and wherever they need answers.

“Right now, we provide static dashboards – either in PDF or Excel format,” Walker explains. “With SAS Visual Analytics, senior management will be able to interact with the data whether on the road through a mobile device or at their desktops. They’ll be able to make decisions based on longer historical trends. And what they discover will spawn even more questions as they dive deeper into the data.”

Challenge

Make sound lending decisions based on an increasing amount of internal and external data, and make marketing decisions that are more relevant to each member.

Solution

Benefits

Dramatic reduction in data preparation time and run time for analytics. In some cases programs that took hours – or even days – to run now take minutes.

本文中所展示的成果取决于文中所述的特定场景、业务模式、数据输入和计算环境。每位SAS客户的体验都因其业务和技术特性而不同,请勿将本文观点视为通用观点。实际的成本节约、成果和效果最终取决于每位客户的实际配置和条件。SAS不保证每位客户都能取得本文类似的成果。SAS仅对SAS的产品和服务提供保证,请参阅SAS的产品服务质保条款,本文中提及的内容不能视为质保条款。客户可以按照合约商定的条款分享SAS软件实施项目的成功案例,相应的品牌和产品名称归属相应的公司所有。

Back to Top