How OptiSol helped a leading commercial bank modernize its loan origination system with Appian
Key Highlights
- OptiSol collaborated with a leading commercial bank to replace their 15-year-old Oracle Form loan origination system with an Appian-based solution.
- The clients legacy system supported loan intake, risk modeling, document verification and credit approvals but created challenges with usability, maintenance and processing time.
- The solution introduced web and tablet access, automated workflows, document capture and a centralized workspace for relationship managers and underwriters.
- The bank launched the new Commercial Loan Origination system in 18 weeks, retiring more than 40 Oracle Forms screens and 25 Oracle Reports.
Problem Statement
01
Poor User Experience: Desktop based Oracle Forms screens and limited validation caused frequent data entry mistakes, incomplete applications and reduced employee productivity.
02
Complex Business Logic: Critical rules and calculations were spreaded across thousands of PL/SQL triggers and procedures, making the policy changes dependent on specialized Oracle developers.
03
Manual Loan Processing: Applications moved between departments through emails and report printouts, resulting in limited visibility and an average approval time of 12 business days.
04
Aging Technology: Older Oracle Forms versions faced support concerns, while experienced PL/SQL developers approached retirement, increasing the bank's operational and maintenance risks.
Solution Overview
01
Appian-Based Modernization: OptiSol helped the client in replacing their Oracle Forms front-end with Appian, giving the bank a modern application without requiring a larger custom rewrite.
02
Existing Oracle Data Retained: Appian connected directly to the client’s existing Oracle Database, allowing the bank to keep their historical data and use existing PL/SQL procedures where needed.
03
Web and Tablet Access: Responsive applications allowed relationship managers to start commercial loan applications from the field while working with clients.
04
Automated Loan Workflows: Appian automatically routed loan tasks to underwriters and credit committee members based on loan size, credit score and risk thresholds.
05
Centralized Documents and Tasks: Automated document capture brought financial statements, tax records and loan-related tasks together in one workspace for underwriters.
Business Impact
About The Project
This success story depicts how OptiSol helped a commercial bank modernize its 15-year-old Oracle Form based commercial loan origination system by moving it to Appian. The legacy Oracle Forms application had been supporting the bank’s loan processes for many years, but the bank needed a more modern platform to support its changing business needs. OptiSol helped the bank transition the application to Appian while continuing to work with its existing Oracle data. The new system was launched in 18 weeks, providing the bank with a modern foundation for managing its commercial loan operations.
FAQs:
Why did the bank choose Appian instead of completely rebuilding its Oracle Form application?
Appian offered modern platform without requiring the bank to undertake a high-risk, multi-year custom rewrite.
How was the bank able to move from Oracle Forms to Appian without migrating all its existing Oracle data?
Appian connected directly to the clients existing Oracle Database, allowing the bank to continue using its historical data.
What happened to business logic that was already embedded in the Oracle Forms and PL/SQL code?
The modernized application continued to use existing PL/SQL stored procedure where they were needed.
How did the new system help relationship managers work with customers outside the office?
Web and tablet applications allowed relationship managers to start commercial loan applications while working with customers in the field.
How did Appian reduce the time required to process and approve commercial loans?
Appian automatically routed loan tasks, replacing manual hand-offs and helping applications move faster through underwriting and credit approval.
Testimonials of Our Happy Clients
Ken Kisner
Global Head of Digital R&D
My experience has been incredibly positive. They were incredibly easy to work with, even with changing requirements.
They are incredibly competitive, but are only a fraction of the cost of US companies.
They are definitely the most professional of the foreign companies that we were looking into.
Nyswyn K.
Director of Software Development
Our journey with OptiSol has been nothing short of remarkable. For over 7 years, we have partnered with them on our digital transformation, and the results have been truly transformative.
Over the years, we have come to trust OptiSol Business Solutions as a reliable and strategic partner.
Al Bagiro
CTO, Auto Insurance Company
The AI engine was completed on time and trained to 90% accuracy. Their eagerness to learn new knowledge impressed us.
Their team is large to handle multiple projects at once, and likes to resolve challenges as well as learn new things. They also welcome regular communications, and of course, needless to say, develop everything in sprints.
Dan Talken
Founder, CEO, & CTO, My Equipment Library, LLC
OptiSol Business Solutions has shown youthful skill and dedication to the projects. Moreover, they have been quick to implement their solutions without sacrificing the quality of each platform.
We’re constantly impressed with their speed and quality of the development that they achieve on a consistent basis.
Dr. A.K Pradeep
CEO MachineVantage
Exceptional Collaboration and Expertise - A Top-Notch Partner for AI, ML, and Digital Applications.
I have had the privilege of working with an exceptional team of professionals from India on numerous AI, ML, and digital application projects. Their expertise in these domains is remarkable, and they consistently impressed us with their knowledge, resources, and innovative approach.
Rick Tigges
CFO, Bemodo
They are very responsive and able to shift focus quickly as we have needed it for business reasons.
OptiSol Business Solutions has been great at documenting the timeline of the project. They were very responsive and were able to shift focus quickly, as well. They discuss what they’re working on without any issues. So far, there’s no need to improve their service.