# Senior Managers & Certification Regime Presents an Opportunity for IT Transformation to Insurers Author: Pal Sinha, Barnali Author URL: https://financedigest.com/author/pal-sinha-barnali Published: 2018-01-20 Category: INVESTING Category URL: https://financedigest.com/category/investing Meta Title: SM&CR Compliance for Insurers: IT-Led Actuarial Transformation Meta Description: Explore how insurers can use technology to automate reporting, manage data, and modernise modelling platforms to ensure compliance and minimise operational URL: https://financedigest.com/senior-managers-certification-regime-presents-an-opportunity-for-it-transformation-to-insurershtml ![undefined](https://prod.superblogcdn.com/site_cuid_cm5qst7v3003gwirgwqtxn8i8/images/fd200118-10-1736843058070-compressed.jpg) - _By **Henry Umney**, CEO, ClusterSeven_ The Prudential Regulation Authority (PRA), via its recently [published](http://www.bankofengland.co.uk/publications/Pages/news/2017/049.aspx?utm_source=Bank+of+England+updates&utm_campaign=2ae84dc208-EMAIL_CAMPAIGN_2017_07_25&utm_mediumhttp://www.bankofengland.co.uk/publications/Pages/news/2017/049.aspx?utm_source=Bank+of+England+updates&utm_campaign=2ae84dc208-EMAIL_CAMPAIGN_2017_07_25&utm_medium=email&utm_term=0_556dbefcdc-2ae84dc208-113373637=email&utm_term=0_556dbefcdc-2ae84dc208-113373637) proposals to extend the Senior Managers and Certification Regime (SM&CR) to insurers, is looking to put the insurance industry under the same level of scrutiny as the banking sector. ![Henry Umney](https://prod.superblogcdn.com/site_cuid_cm5qst7v3003gwirgwqtxn8i8/images/henry-umney-200x300-1736843057989-compressed.jpg) Henry Umney It aims to enforce individual accountability on underwriters and actuaries in an attempt to protect customers and minimise market abuse.The regulatory framework is also looking to ensure that the individuals who run [insurance organisations have defined responsibilities and that they manage](https://www.financedigest.com/improving-risk-management-in-the-insurance-industry.html "Improving risk management in the insurance industry") their business with integrity and honesty. Additionally, the rules are looking to proportionately enforce the Solvency II requirements, the harmonised EU insurance regulatory regime, for the smaller [insurers](https://www.financedigest.com/different-countries-different-insurance-cultures-how-insurers-can-adapt-their-products.html "insurers") who fall outside the latter’s scope. **SM&CR – an** [opportunity for IT-led actuarial transformation](https://www.financedigest.com/sql-server-transformation-market-advanced-research-growth-opportunities-in-global-industry-by-2029fmi.html "SQL Server Transformation Market advanced Research & Growth Opportunities in Global Industry by 2029|FMI") While at this stage, the proposals are in consultation (until 03 November 2017) with the final rules expected to be published in 2018, actuaries should be proactively reviewing their processes to prepare for the SM&CRcompliance in the near future. This is a great opportunity for insurers to take an IT-led transformation approach to modernising and standardising modelling platforms, managing data and [automating reporting](https://www.financedigest.com/increasing-industrialization-and-industrial-automation-to-fuel-growth-of-combination-filler-machine-market-fact-mr-report.html "Increasing Industrialization and Industrial Automation to Fuel Growth of Combination Filler Machine Market: Fact.MR Report") to minimise operational risk and ensure compliance. A recent [report](http://www.theactuary.com/news/2017/08/quarter-of-largest-insurers-disclosing-solvency-ii-requirements-incorrectly/) revealed that over a quarter of the top 100 non-life insurers in the UK and Ireland have published quantitative reporting templates containing errors for Solvency II compliance.Inaccurate reporting is undermining the objective of the Solvency II directive, whose key aim is to ensure greater transparency. **Spreadsheet – the actuaries’ system of choice** A [key element within this transformation programme is the Actuaries’ system](https://www.financedigest.com/vehicle-speed-monitoring-system-market-key-players-swot-analysis-key-indicators-and-forecast-to-2026.html "Vehicle Speed Monitoring System Market Key Players, SWOT Analysis, Key Indicators and Forecast to 2026") of choice, the spreadsheet. [Insurance organisations deploy multiple systems to manage and ensure the accuracy and integrity of data in the business](https://www.financedigest.com/business-insurance-what-does-it-cover.html "Business Insurance: What does it cover?"). However, insurers universally rely very heavily on [spreadsheet](https://www.financedigest.com/institutions-need-to-consider-spreadsheet-management-to-meet-the-pras-latest-stress-testingexpectations.html) [applications for their day-to-day business processes](https://www.financedigest.com/chemical-process-mixers-industry-2021-includes-the-major-application-segments-and-size-in-the-global-market-to-2028.html "Chemical Process Mixers Industry 2021 Includes The Major Application Segments And Size In The Global Market To 2028"), complex calculations and financial manipulations. Due to the complexity of the calculations performed by Actuaries, these files can be numerous with data being collated from a variety of internal and external sources. Often, knowledge of the existence of these files and the information they contain is not widely understood outside of the Actuarial function. Transparency of the supervision and [management of these complex spreadsheet files for data quality](https://www.financedigest.com/healthcare-quality-management-market-is-expected-to-register-highest-cagr-of-12-during-the-forecast-period-2021-to-2031.html "Healthcare Quality Management Market Is Expected To Register Highest CAGR Of 12% During The Forecast Period 2021 to 2031") and integrity is essential to ensure compliance with the SM & CR and Solvency II. **A technology-led approach** [Chief Actuaries should consider](https://www.financedigest.com/eu-will-consider-making-countries-fill-gas-storage-energy-chief.html "EU will consider making countries fill gas storage – energy chief") adopting automated spread-sheet monitoring and management. This will provide the visibility and deliver an in-depth understanding of the [spreadsheet](https://www.financedigest.com/institutions-need-to-consider-spreadsheet-management-to-meet-the-pras-latest-stress-testingexpectations.html) landscape actuaries are dependent on in running their day-to-day operations, to the rest of the organisation. With technology, actuaries can create an inventory of spreadsheets, which is tiered based on criticality, to gain complete visibility of the business-critical files. Thereafter, technology can routinely automate the analysis of the data flows, identify the data lineages across the landscape; and continuously track and monitor data usage via precise change management processes. For data sources in spreadsheet applications, [automated validation can also check the integrity of operational processes](https://www.financedigest.com/the-aquaculture-feed-and-pharmaceutical-market-to-move-ahead-on-rpa-robotic-process-automation.html "The Aquaculture Feed And Pharmaceutical Market to move ahead on RPA (Robotic Process Automation)") (e.g. timely spreadsheet submission), functionality (e.g. changes to formulae) and data (e.g. alerts on changes to static triangle data). This will [ensure full transparency of the critical spreadsheet environment; the process of spreadsheet usage and management is streamlined end to end is routine; and the accuracy and integrity of information is maintained at all times](https://www.financedigest.com/france-demands-twitter-ensure-it-can-preserve-safe-environment.html "France demands Twitter ensure it can preserve ‘safe environment’"). Additionally, the management information that will become available will be hugely beneficial for decision-making. In the absence of such processes, even a single error in a critical spreadsheet can potentially invalidate the accuracy of actuarial financial models and reports. In fact, technology can help present early sight of anomalies in the [data sources](https://www.financedigest.com/exclusive-tiktok-nears-deal-with-oracle-to-store-its-data-sources.html "Exclusive-TikTok nears deal with Oracle to store its data-sources") that underwriters and actuaries are reliant on, saving hours of manual checks and paperwork.Actuaries will be able to truly focus their efforts on the more vital [aspects of their job such as modelling and analysis](https://www.financedigest.com/acne-scar-treatment-market-current-trends-and-future-aspect-analysis-2021-2031.html "Acne Scar Treatment Market Current Trends and Future Aspect Analysis 2021 – 2031"). [Automation will also provide the evidence of controls](https://www.financedigest.com/the-automation-control-system-market-to-see-through-the-probable-sea-change-through-digitization.html "The Automation Control System Market to see through the probable sea change through digitization") actuaries currently have in place, which is required under SM & CR. For instance, actuaries can [see the current previous values](https://www.financedigest.com/delivery-hero-sees-higher-gross-merchandise-value-in-third-quarter.html "Delivery Hero sees higher gross merchandise value in third quarter") in their spreadsheet applications; and track changes to every defined attribute such as drop-downs, data-pickers and Boolean fields. It’s worth [noting that transparency of the spreadsheet landscape will contribute to insurers’ wider model](https://www.financedigest.com/the-humanized-mice-model-market-to-grow-on-a-satisfactory-note.html "The Humanized Mice Model Market to grow on a satisfactory note") governance initiatives too such as BCBS 239 and SR11 -7. SM & CR and Solvency II aren’t one off processes and non-compliance has [personal implications for the Chief Actuary and other senior managers](https://www.financedigest.com/personalized-digitization-to-drive-the-scoliosis-management-market.html "Personalized digitization to drive the Scoliosis Management Market"). They [apply the Individual Conduct Rules](https://www.financedigest.com/britain-to-be-among-first-to-apply-new-climate-disclosure-rules.html "Britain to be among first to apply new climate disclosure rules") to all staff, barring administrative employees, and a failure to comply can potentially lead to action against senior actuary executives. It’s not to be taken lightly. By adopting a technology-led approach to compliance, insurers can achieve a [sustainable methodology to establishing appropriate data and function checks and without compromising the business](https://www.financedigest.com/metal-cans-and-glass-jars-market-demand-from-food-industry-to-grant-sustainable-business-prospects.html "Metal Cans and Glass Jars Market – Demand from Food Industry to Grant Sustainable Business Prospects ") need to retain the flexibility to use and develop spreadsheet models, which is the preferred tool for complex calculations and risk assessments. --- This blog is powered by Superblog. Visit https://superblog.ai to know more. ---