Login     Register

        Contact Us     Search


Safety National

Safety National needed an easy-to-implement and powerful solution to improve its loss and premium modeling process – they found it in XLeratorDB

Safety National

EXECUTIVE SUMMARY

  • Safety National wanted to improve one of its loss and premium models to run faster and support greater volumes of data.
  • Safety National found XLeratorDB easy to use, even for non-coders, and more efficient than their Excel-based models.
  • Safety National benefited from detailed XLeratorDB documentation and great support from Westclintech.

 

Safety National (http://safetynational.com) provides insurance solutions, including alternative risk funding products such as excess workers’ compensation, loss portfolio transfers, and reinsurance. As part of its continual process-improvement focus, Safety National was looking to improve one of its actuarial models. They were trying to enhance their Excel-based models, ultimately requiring a format that would run in Microsoft SQL Server. The company’s criteria included a system that was easy to implement, cost-effective, and more efficient than their current models.

As David Wolf of Safety National described it, his group performed loss and premium modeling that utilized random number generation and statistical distributions in Excel. Safety National already had certain processes running in Microsoft SQL Server and they wanted to leverage SQL Server more to help speed up the overall modeling process.

XLeratorDB provides in-database analytics for SQL Server and included all the familiar statistical functions from Excel that David was currently using. Safety National downloaded a trial version and, within a few days, had XLeratorDB running smoothly in their environment. Less than a week later, David had confirmed the results between the Excel and SQL Server / XLeratorDB models. According to David, "the ease of incorporating XLeratorDB into their model was pretty close to a no brainer.”

Not only were the XLeratorDB functions simpler to use than the comparable native SQL Server functions, the detailed documentation available provided examples on how to incorporate them. As an actuary with no formal coding background, David found the XLeratorDB functions intuitive given their similarity to Excel functions; he could basically ‘copy / paste edit’ examples straight from the XLeratorDB documentation into the code for his models. XLeratorDB also removed the need to create work-arounds in SQL code in cases where SQL Server functionality was limited, as with certain statistical distributions. David was impressed that the XLeratorDB was so easy to implement and the software immediately proved its worth.

In addition to the ease of implementation, David was very pleased with the significant performance improvements the company achieved by using XLeratorDB’s functions natively within SQL Server. The original Excel-based model (incorporating Visual Basic macros) supported 50,000 simulations, with each simulation generating up to 1,000 data points. These models took more than six hours to run and could not run unattended because they would not always run to conclusion. With the addition of XLeratorDB, he was able to move the models over to SQL Server where he could take advantage of its computing power. He could increase the number of simulations and the model would complete in a more-efficient 1.5 hours with no fear of system crashes. This meant he could run multiple iterations of a given model in a single day. Without the XLeratorDB functionality, the performance advantage of using SQL Server would diminish significantly.

The ease of implementation and performance improvements led to a quick transition to using the XLeratorDB product in production.

Safety National has proven for over 75 years that they are an industry leader who takes their responsibilities to their clients very seriously. Safety National is a trusted partner to its customers who rely on their expertise and risk management resources. All of this is underpinned by Safety National’s risk modeling. Safety National found an effective partner with Westclintech and its XLeratorDB solution. For a small investment in licensing fees and less than two weeks of work, Safety National was able to significantly improve their loss and premium modeling, which helped the business make better decisions.



Featured Client List

XLeratorDB has rapidly built a broad global customer base spanning more than 40 countries and 30 US states, including innovation leaders such as:


Financial Services

Government

Software/Consulting

3Point Asset Management
Access Capital Advisors
Alchemy Capital Management Pvt. Ltd.
AlixPartners LLP
Ally Bank
Alphametric Research, LLC
AEW Capital Management
Alpha Card Services
AMBIT Capital Pvt. Ltd.
American Capital
AnaCap Financial Partners LLP
Annaly Capital Management
Apollo Global Management
AutoCont SK
Avenue Capital
Axis Bank
Babson Capital Management LLC
Bain Capital
Bankers Healthcare Group, Inc.
Barclays Securities India Pvt. Ltd.
BBR Partners
Bessemer Ventures
Birla Sun Life Asset Management
Black Diamond Capital Management
BOCI-Prudential
California Republic Bank
Centerbridge Partners LP
Citigroup (IND)
Cliffwater LLC
Convergence Investment Partners
Crews & Associates, Inc.
DBI Capital Market Services Ltd
Desjardins (CAN)
Eastwood Bank
EBS Asset Management
Ellington Management
Emirates Investment Bank
Enam Securities
Entente Fund Accounting Services
Eton Advisors, LP
Fir Tree
First Gulf Bank
Fred Alger
Fusion Ventures  (case study)
GARANTI BANK SA
GEPL Capital Pvt. Ltd.
Gimv (BEL)
Golden Tree Asset Management LP
Goldman Sachs Securities India Pvt Ltd.
GRAMIT S.A.
Hamilton Lane
Harbourvest Partners, LLC
Harvest Investments
Henderson Global Investors
Henninger Investments
Highland Capital
HighVista Strategies LLC
Horizon Credit Union
Hudson Advisors
Hyuandai Securities
ICICI Bank
IIFL (IND)
IndexUniverse, LLC
Infoweaver Services AB
ING Vysya bank
Jasper Ridge Partners
Javlin Capital
JM Financial Pvt. Ltd.
Karma Capital Advisor Pvt. Ltd.
Keytrade Bank
Killik & Co
Kotak Mahindra Bank Ltd.
L&T Capital Company Ltd.
Landmark Dividend LLC
Landsdowne Partners
Liberties Investments Limited
LPL Financial
Mariner Investment Group
M. B. Commercial Company Limited
Mid Atlantic Capital Group
MidAtlantic Trust
Moneta Group
Morgan Stanley
Morgan Stanley (I) Financial Services
Neue Aargauer Bank
Nilta Corp
Nordea Investment Funds S.A.
North American Savings Bank
Notz & Stucki (CHE)
PanAgora
Postbank
Prescott Securities
Prime Broking Company Ltd.(IND)
Principal PNB Asset Management
Principal Retirement Advisor Pvt.Ltd
Professional Capital Services
Profidebopt, s.r.o.
PT Otto Multiartha
MTAG Services LLC
Oak Hill Investments
Oaktree Capital
Prescott Securities (AUS)
Qatar Development Bank
RDV Corp
Republic Mortgage Home Loans
RMB (ZAF)
Samuel E Ramirez & Co.
Santandar (BEL)
Santandar Consumer Finance Benelux B.V.
SAR Capital Pvt. Ltd.
Sarasin-Alpen (India) Private Limited
Saunderson House Ltd
Savant Capital
SBAB (SWE)
The Sentient Group (AUS)  (case study)
Sequoia Heritage
Sontag Advisory
Sprism Investment Services Pvt. Ltd.
Standard Chartered (IND)
Sunrise Capital Partners
Taom Capial UK Ltd.
Titan Advisors
TPG Credit Management, LP
T. Rowe Price Associates, Inc.
Trustline Holdings
Tufton Oceanic
Turner Acceptance Corp
United Acceptance
Value Prolific Investment and Consulting
Vericrest Financial Inc
Von Braun&Schreiber (DEU)
Watts and Associates
WealthTouch
Wedbush Securites
Westdale Capital
Central Bank of Iceland
City of Toronto (CAN)
DBC Onderhoud (NLD)
Lee County Schools
NSW Cancer Institute (AUS)
PSP Investments (CAN)
Reserve Bank of Fiji
State Teachers Retirement System - Ohio
SPAWAR System Center Atlantic
US Department of the Interior
US Navy

Insurance/Healthcare

Advisory Board Company
Aegis London (GBR)
Aeolus Re (BMU)
Alterra Capital Services
Ameritas
Arch Reinsurance Ltd.
Capital & Coast District Health Board
Cathedral Underwriting Ltd
Child Health Corporation of America
Dr.Foster Intelligence
Goss Re
KaufmanHall
MetLife
Oil Insurance Ltd (BMU)
Oil Management Services
Starr Companies
XL Group
XL Insurance

Energy

Chevron
Consolidatd Edison
SPARQ Solutions Pty Ltd (AUS)
Unit Corporation

Real Estate

CapMan Oyj (FIN)
Helios AMC
iStar Financial  (case study)
Landmark Partners
London & Quadrant (GBR)
Newland Communities  (case study)
Northstar Realty Finance Corp
Townsend Group
Alpha Kinetic (GBR)
AssetLabs
Autocont SK
Bits Software
Cadis EDM (GBR)
CPACINC
Cybercom
DataAgent
Derive Technologoes
Enerpact LLC
EvalSolutions  (case study)
Farsight Consultancy Services
Ferman Automotive Management Services
Fortigent
Genpact
Hewlett Packard India Sales Pvt. Ltd.
Ingram Micro
Kenexa
Milessoft (IND)
ModelLogic
Netage Solutions
Pangea3 Legal Database Systems Pvt. Ltd.
Paylink Payment Plans
Portfolio Pathway
PSD Solutions
Rehfeld Partners A/S
Respec
SAIC
Software Guru
Sterknetwerk BV (NLD)
Supply Chain Strategy Services
Surehits
Tata Consultancy (IND)
Venture Allies
Verde International  (case study)
Via Binary

Other

BlueSun Inc.
CreditMax Auto Group
Firebrand Technologies
GRAINGER
HarperCollins Publishers
Houghton Mifflin Harcourt
The High Companies
Kemper Valve & Fittings Corp
LeahMaya Limited
Optionline
right stuff detailing
West Pak Avocado
West Valley Construction

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service