U.S. Department of Energy

  • 8 months Project Timeline
  • Cost Savings Rapid Development Fully Integrated Remove Manual Processes Digital Transformation Collaboration
    Achievements

Summary

The U.S. Department of Energy's Loan Programs Office, is tasked with the responsibility of providing multi-million dollar loan guarantees. This agency monitors the loans and takes the borrower through the entire life cycle, from loan application all the way through to maintenance and closing of the loan. The loans in reference are highly-sensitive and require that an intricate workflow be followed in order to meet compliance. An existing system was in place but it was not adequately meeting the needs of the agency and poor performance speed was hindering employee productivity.

Challenge

  • Highly complex business workflow
  • Sensitive financial information was not being stored properly
  • Full adherence to compliance standards
  • Existing software development was inefficient
  • Existing solution was not scalable

Solution

  • Graphite GTC rapid development
  • Custom Loan Portfolio Monitoring System
  • 508 Compliant
  • Fully normalized database structure
  • Automated workflow
  • Auditable tracking of all user activity
  • Data conversion

Benefits

  • Reduced database size from 11.0GB to 1.2GB
  • Average loan summary page load went from 5 minutes to 10 seconds
  • Average system-wide page load went from 15 seconds to 2 seconds
  • Rapid speed to develop and deliver system enhancements
  • Responsive web-based solution that can be used from any device, on any browser
  • High rate of employee productivity

Project Details

The U.S. Department of Energy needed to redesign their current loan portfolio application within an accelerated development time frame. They decided Graphite GTC best fit their needs based upon the following features and benefits:

  • Rapid Application Development
  • Reduced time to implement and deploy future planned features
  • Significant Performance improvements
  • Ability to easily integrate with existing applications
  • Track record of success within the U.S. Department of Treasury

The U.S. Department of Energy has fully implemented the new Loan Portfolio Monitoring System, which is currently being used by more than 100 users and handles over 5000 business transactions on a daily basis. The solution features credit rate monitoring, disbursement tracking, project performance metric entry and reporting, communication logging and seamless integration with their document management system. The solution also orchestrates tasks with workflows among multiple departments, both in the home office and in the field.

This entire first phase, including conversion, took 8 months to complete. The Graphite GTC team has provided 400+ feature updates since phase I has gone to production. What started off as a single large application has evolved into an enterprise-wide system that provides transparency and inter-departmental communication across the entire Loan Programs Office.