Enterprise Database Solutions
Backed By Technical Excellence
Home   Contact   Site Map

Marketplace - Reinsurance

Application Overview

Procase Consulting Inc. has developed a Reinsurance application that is universal, and can be re-applied to the Reinsurance general industry with significant benefits. Our initial development was completed for the Global Reinsurance Company (GRC) in Toronto using their extensive reinsurance expertise and our extensive technical expertise. Procase plans to leverage our reinsurance application expertise and the reinsurance business expertise provided by Global Reinsurance to reapply this application to new clients.

Our reinsurance application was developed based on Property and Casualty (P&C) reinsurance. However, the rules engine developed is universal to reinsurance concepts and can be applied equally to Life Reinsurance.

Using the rules engine the application calculates the applicable reinsurance cash and outstanding recoveries, allocating them by contract (by year of contract), participant, line of business and territory. Using this data source, reports are generated for operations accounting and regulatory filing purposes. Some entries (general ledger cash balances and movements on outstanding cession values) can be automatically loaded into a GL system to assist in recording and tracking this important accounting aspect. A feature of this automation is the ability to review and modify entries prior to posting. The data derived can also be used to create reports on overall participant results which can be used to assess the value relationship for each participant.

Additional to this comprehensive range of reinsurance calculations, the application can also produce reports tracking the direct insurance operation results for management review or regulatory filings by, using the data aggregations needed for reinsurance.

 
Features
  • Integration with current data sources
  • Universal Reinsurance Rules Engine
  • Exception screen for Manual intervention
  • Integration with existing Financial/Billing systems
  • Standardized regulatory reporting
Benefits
  • Significantly Faster monthly/quarterly closing
  • Reduced errors due to human intervention
  • Reduced uncollected balances by participant
  • Customized application to meet your specific needs
  • Automated reporting
Functionality Overview
  • Data Acquisition and Mapping
    • Input Client Data (Client, Treaty, Facultative etc)
    • Maps data and business processes to Application setup tables
    • Normalization for application of Calculation engine
    • Note - Requires Needs Analysis and Requirements Study prior to implementation
  • Calculation of Reinsurance Recoverables
    • By Participant, by Treaty etc.
    • Calculation engine
      • 1st Calculation - Facultative Excess
      • 2nd Calculation - Facultative Prorata
      • 3rd Calculation - Surplus
      • 4th Calculation - Gross Quota Share
      • 5th Calculation - Excess of Loss (on Gross)
      • 6th Calculation - Net Quota Share
      • 7th Calculation - Underlying Excess of Loss
      • Adverse Loss / Stop Loss Calculation
    • Calculation of Reserve movement and applicable taxes
    • Manual adjustment
  • Interface to Financial system
    • Billing/Payment system
    • Accounting
  • Reporting
    • Regulatory reporting
    • Corporate reporting
    • Financial Record report
    • Summary of Ceded Reinsurance Detail by Participants by Treaty
    • P&C 60.20 - Premiums and Claims
    • P&C 60.30 - Claims and Adjustment expenses
    • P&C 60.40 - Net Claims and Adjustment expenses - Run-off
    • P&C 67.10 - Provincial and Territorial Exhibit of Premium Written
    • P&C 67.20 - Provincial and Territorial Exhibit of Premium Earned
    • P&C 67.30 - Provincial and Territorial Exhibit of Claims Incurred Including Adjustment Expenses
    • P&C 70.10 - Premiums and Claims - Reinsurance Ceded
    • Quarterly Treaty Record
    • Non-Resident Tax and Interest Exhibit
Technology Overview

Our Reinsurance application has been developed using an Oracle database and application server (PL/SQL) on a Microsoft Windows server platform. This platform offers exceptional technical capabilities as well as simplified interfacing to the Oracle Financial system Implemented by Procase for GRC.

Procase feels the technology platform is not core to the application functionality and can therefore be re-implemented on an alternate platform as preferred by the client. Procase has significant development capabilities on most major technology platforms, including Oracle, .Net, Java and IBM Websphere.

 
Business Approach

Procase offers clients the proven ability to develop a complete reinsurance recovery calculations and regulatory reporting application customized to your specific needs. We offer 35 years of Reinsurance expertise, proven application development expertise and a proven production system.

Procase offers our services to complete a Needs analysis and requirements definition study on a time and materials basis. The application development would be completed on a fixed price basis. Upon completion the client will own the (non-exclusive) intellectual property rights to the application. Procase also retains the intellectual property rights to reuse any developed code, designs and concepts for resale to other clients.

 
For more information, please email Eric Farquharson (efarquharson@procaseconsulting.com) or call him directly at 416-352-1334.
 
Back to Marketplace page



 

Home   Contact   Top
Canada (905) 856-7479, US (415) 845-0260
Copyright © 2008 Procase Consulting Incorporated