Streamlining Refunds and Cancellations with the BHPH System

About the Client

CPI is a prominent organization specializing in innovative insurance and financial solutions. Their Buy Here Pay Here (BHPH) program focuses on providing tailored services for lenders, ensuring efficient handling of refunds, cancellations, and reporting functionalities.

Project Overview

• Objective:
  
  • Enhance the refund, cancellation, and reporting functionalities within the BHPH system.
  • Streamline the handling of refunds and simplify policy cancellations.
  • Implement comprehensive reporting capabilities for refunds and cancellations, ensuring transparency and accountability for lenders.
  • Facilitate smooth data migration from the old platform to the new one to maintain data consistency and integrity.
• Scope:
  
  • Enhancing the refunds functionality, ensuring accurate prorated refund calculations and seamless integration with cancellations.
  • Streamlining the cancellations process, ensuring smooth workflow from policy cancellation to refund processing.
  • Implementing detailed reporting for refunds and cancellations with filtering capabilities for users.
  • Migrating invoicing claims and accounting reports from the old system to ensure data consistency.
  • Adding the ability to process reissue requests and ensuring loan search cancellations work seamlessly.

Key Highlights/Deliverables

1. Refunds Reporting System:
   
   • Accurate tracking of refunds, including refund amounts, policy numbers, and dates.
   • Filtering options for reports, including policy numbers, refund dates, and lender names.
2. New Link Access for Claims and Refunds:
   
   • Role-based access for claims and refund reports tailored to different user types (admin, finance, etc.).
3. Refunds Functionality:
   
   • Prorated refund calculations based on policy duration.
   • Accurate updates to lender balances reflecting processed refunds.
   • Display of processed refunds in detailed, user-friendly reports.
4. Cancellation Process Integration:
   
   • Automatic triggering of refund processing upon policy cancellation.
   • Streamlined workflows with no pending requests between cancellation and refunds.
5. Reissue Requests:
   
   • Support for reissue requests with customizable starting dates.
6. Loan Search Cancellations:
   
   • Fully functional cancellation options within loan searches with accurate system reflections.
7. Policy Number Dates:
   
   • Accurate display of policy number dates across reports and records.
   • Automatic 30-day term setup for newly issued certificates.

Technologies Used

• Framework: .NET Core 6 with Blazor Pages.
• Database: SQL Server.

Challenges

1. Tight Timeline:
   
   • Completing the project within a short timeframe to minimize disruption during the platform transition.
2. Data Migration Complexity:
   
   • Ensuring the accurate migration of invoicing claims and accounting reports without data loss.
3. System Integration:
   
   • Integrating new workflows into the existing system to prevent process disruptions.
4. Prorated Calculations:
   
   • Managing accurate prorated refund calculations, especially with legacy data.

Results/Impact

1. Operational Efficiency:
   
   • Reduced operational delays by 30%, allowing for faster processing of cancellations and refunds.
2. Improved Accuracy:
   
   • Enhanced financial record accuracy by 25% through prorated refund calculations and detailed reporting.
3. Enhanced Client Satisfaction:
   
   • Improved client satisfaction by 20% due to real-time tracking and better visibility of refunds and cancellations.
4. Seamless Data Migration:
   
   • Achieved 100% data consistency between old and new platforms, ensuring reliability.
5. Increased Transparency:
   
   • Enhanced lender trust through detailed refund and cancellation reports.
6. Feedback Integration:
   
   • Regular client feedback during development ensured alignment with user needs and effective adjustments.

‍

‍

‍

‍