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.”


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.



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.

Los resultados que se ilustran en este artículo son específicos a las situaciones, modelos de negocios, datos aportados y entornos de cómputo en particular que se describen aquí. Cada experiencia del cliente de SAS es única basada en variables de negocios y técnicas y todas las declaraciones se deben considerar no típicas. Los ahorros, resultados y características de desempeño reales variarán dependiendo de las configuraciones y condiciones de los clientes individuales. SAS no garantiza ni augura que todos los clientes lograrán resultados similares. Las únicas garantías aplicables a los productos y servicios de SAS son aquellas que se estipulan en las declaraciones de garantía explícitas en el contrato por escrito relativo a dichos productos y servicios. No se debe considerar que nada de lo aquí mencionado constituye una garantía adicional. Los clientes han compartido sus éxitos con SAS como parte de un intercambio contractual convenido o resumen de éxito de proyectos tras una implementación exitosa de software de SAS. Los nombres de marcas y productos son marcas comerciales de sus respectivas compañías.

Back to Top