Northdoor Actuarial Application Industrialisation

How Northdoor helped an insurance client industrialise its compliance-related application with SQL Server Integration & Reporting Services

Are you ready to get in touch?

Request a Call back

Download this resource

This resource is available for immediate download

Please click the button below

Northdoor Actuarial Application Industrialisation

A Northdoor insurance client had built a compliance-related application (Solvency II Technical Provisions) using a combination of Microsoft Excel workbooks and Access databases. This worked in a limited way, but required huge manual intervention and would not scale as the organisation required.

This client’s application process involved a large number of manual steps and significant allocation processes in order to produce the final data.

Northdoor industrialised the process by replacing the current Microsoft Excel/Access solution with a series of Microsoft SQL Server Integration Services (SSIS) packages executed from a set of SQL Server Reporting Services (SSRS) reports.

Latest Blog Articles

Insurance

The ongoing challenges of Blueprint Two

Navigate Blueprint Two challenges in the London Market’s digital transformation. Find ways to bridge EDI message support gaps.

Banking and Finance

Strengthening operational resilience in preparation for DORA with clean rooms

How financial institutions are preparing for upcoming new regulation, DORA, using clean rooms as a recovery approach for their critical IBM Power Systems

Banking and Finance

How lax financial sanctions screening can cost millions

Learn why Starling Bank was fined £29m for financial sanction failures and how banks can improve their financial sanctions screening.

See all blog articles

Our Awards & Accreditations

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em;}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none;}:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1) 0%,#9b51e0 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,#7adcb4 0%,#00d082 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1) 0%,#cf2e2e 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,#eee 0%,#a9b8c3 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,#4aeadc 0%,#9778d1 20%,#cf2aba 40%,#ee2c82 60%,#fb6962 80%,#fef84c 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,#ffceec 0%,#9896f0 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,#fecda5 0%,#fe2d2d 50%,#6b003e 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,#ffcb70 0%,#c751c0 50%,#4158d0 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,#fff5cb 0%,#b6e3d4 50%,#33a7b5 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,#caf880 0%,#71ce7e 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,#020381 0%,#2874fc 100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:.44rem;--wp--preset--spacing--30:.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px 6px 9px rgba(0,0,0,.2);--wp--preset--shadow--deep:12px 12px 50px rgba(0,0,0,.4);--wp--preset--shadow--sharp:6px 6px 0px rgba(0,0,0,.2);--wp--preset--shadow--outlined:6px 6px 0px -3px rgba(255,255,255,1),6px 6px rgba(0,0,0,1);--wp--preset--shadow--crisp:6px 6px 0px rgba(0,0,0,1);}:where(.is-layout-flex){gap:.5em;}:where(.is-layout-grid){gap:.5em;}body .is-layout-flex{display:flex;}.is-layout-flex{flex-wrap:wrap;align-items:center;}.is-layout-flex > :is(*,div){margin:0;}body .is-layout-grid{display:grid;}.is-layout-grid > :is(*,div){margin:0;}:where(.wp-block-columns.is-layout-flex){gap:2em;}:where(.wp-block-columns.is-layout-grid){gap:2em;}:where(.wp-block-post-template.is-layout-flex){gap:1.25em;}:where(.wp-block-post-template.is-layout-grid){gap:1.25em;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}:where(.wp-block-post-template.is-layout-flex){gap:1.25em;}:where(.wp-block-post-template.is-layout-grid){gap:1.25em;}:where(.wp-block-columns.is-layout-flex){gap:2em;}:where(.wp-block-columns.is-layout-grid){gap:2em;}:root :where(.wp-block-pullquote){font-size:1.5em;line-height:1.6;}.ubermenu-main{border:1px solid #fff;}.ubermenu-main .ubermenu-item-level-0 > .ubermenu-target{font-size:16px;color:#303d45;}.ubermenu-main .ubermenu-nav .ubermenu-item.ubermenu-item-level-0 > .ubermenu-target{font-weight:normal;}.ubermenu.ubermenu-main .ubermenu-item-level-0:hover > .ubermenu-target,.ubermenu-main .ubermenu-item-level-0.ubermenu-active > .ubermenu-target{color:#fff;background-color:#00a5d9;background:-webkit-gradient(linear,left top,left bottom,from(#00a5d9),to(#00a5d9));background:-webkit-linear-gradient(top,#00a5d9,#00a5d9);background:-moz-linear-gradient(top,#00a5d9,#00a5d9);background:-ms-linear-gradient(top,#00a5d9,#00a5d9);background:-o-linear-gradient(top,#00a5d9,#00a5d9);background:linear-gradient(top,#00a5d9,#00a5d9);}.ubermenu-main .ubermenu-item-level-0.ubermenu-current-menu-item > .ubermenu-target,.ubermenu-main .ubermenu-item-level-0.ubermenu-current-menu-parent > .ubermenu-target,.ubermenu-main .ubermenu-item-level-0.ubermenu-current-menu-ancestor > .ubermenu-target{background-color:#f7f7f7;background:-webkit-gradient(linear,left top,left bottom,from(#f7f7f7),to(#f7f7f7));background:-webkit-linear-gradient(top,#f7f7f7,#f7f7f7);background:-moz-linear-gradient(top,#f7f7f7,#f7f7f7);background:-ms-linear-gradient(top,#f7f7f7,#f7f7f7);background:-o-linear-gradient(top,#f7f7f7,#f7f7f7);background:linear-gradient(top,#f7f7f7,#f7f7f7);}.ubermenu-main .ubermenu-submenu .ubermenu-item-header > .ubermenu-target,.ubermenu-main .ubermenu-tab > .ubermenu-target{font-size:15px;text-transform:none;}.ubermenu-main .ubermenu-nav .ubermenu-submenu .ubermenu-item-header > .ubermenu-target{font-weight:600;}.ubermenu.ubermenu-main .ubermenu-item-normal > .ubermenu-target:hover,.ubermenu.ubermenu-main .ubermenu-item-normal.ubermenu-active > .ubermenu-target{color:#00a5d9;background-color:#f7f7f7;}.ubermenu-main .ubermenu-item-normal.ubermenu-current-menu-item > .ubermenu-target{color:#00a5d9;}.ubermenu-main .ubermenu-item-normal > .ubermenu-target{font-size:14px;font-weight:normal;}.ubermenu-main .ubermenu-submenu .ubermenu-divider > hr{border-top-color:#e8e8e8;}.ubermenu-responsive-toggle.ubermenu-responsive-toggle-main{font-size:20px;font-weight:600;padding:20px;}.ubermenu .ubermenu-submenu.ubermenu-submenu-id-2354{width:250px;min-width:250px;}.ubermenu .ubermenu-submenu.ubermenu-submenu-id-93{width:250px;min-width:250px;}.ubermenu .ubermenu-item.ubermenu-item-18592 > .ubermenu-target{background:#f8b121;color:#fff;}.ubermenu .ubermenu-item.ubermenu-item-18592.ubermenu-active > .ubermenu-target,.ubermenu .ubermenu-item.ubermenu-item-18592 > .ubermenu-target:hover,.ubermenu .ubermenu-submenu .ubermenu-item.ubermenu-item-18592.ubermenu-active > .ubermenu-target,.ubermenu .ubermenu-submenu .ubermenu-item.ubermenu-item-18592 > .ubermenu-target:hover{background:#00a5d9;}.ubermenu .ubermenu-item.ubermenu-item-18592.ubermenu-active > .ubermenu-target,.ubermenu .ubermenu-item.ubermenu-item-18592:hover > .ubermenu-target,.ubermenu .ubermenu-submenu .ubermenu-item.ubermenu-item-18592.ubermenu-active > .ubermenu-target,.ubermenu .ubermenu-submenu .ubermenu-item.ubermenu-item-18592:hover > .ubermenu-target{color:#fff;}body:not(.rtl) .ubermenu .ubermenu-submenu-id-94 > .ubermenu-column + .ubermenu-column:not(.ubermenu-clear-row){border-left:1px solid #f7f7f7;}.rtl .ubermenu .ubermenu-submenu-id-94 > .ubermenu-column + .ubermenu-column:not(.ubermenu-clear-row){border-right:1px solid #f7f7f7;}.ubermenu .ubermenu-submenu.ubermenu-submenu-id-30316{min-width:1px;}.page-id-25104 .hero_intro,.page-id-25104 .hero{display:none;}