What lies beneath - the unseen risk in our data

Helping Internal Audit Meet the Demands of the FSA Data Audit / ‘External’ Review for Solvency II

As part of the Solvency II external review, the FSA have made it clear that they expect to be able to rely on an independent Data Quality Assessment having been performed by each firm to confirm that the correct control environment exists for all Internal Model data. However, they are aware that substantial data operations take place outside core systems in locations such as spreadsheets and CSV extracts. The challenge, explored in this presentation, is "How can Internal Audit meet the requirements of the FSA Data Audit when the reviewers need to demonstrate the “Appropriateness, Accuracy and Completeness” of Actuarial data management‟

Click here to download the full presentation

Overcoming the data hurdle for Solvency II

The FSA Data Audit for Solvency II has brought data management and data assurance to the top of the agenda for Internal Audit departments. This means working with the actuarial community to find ways of ensuring compliance while minimising the cost of administration.

Click here to download the full presentation

Spreadsheet Data Management – Solvency II

Under the Solvency II regulatory regime insurers will be expected to manage the data risk inherent in spreadsheet systems. This presentation addresses these and other regulatory requirements affecting the use of spreadsheets in insurance operations, and illustrates how ClusterSeven can assist you in meeting them.

Click here to download the full presentation

Spreadsheets and Access Databases – The Role of Continous Validation

This is the presentation given to the European Spreadsheet Risks Group in July 2010. This explores how continuous validation can rapidly highlight business integrity issues without requiring users to conduct lengthy searches through an audit trail.

Click here to Download Slides

Spreadsheet Control Webinar Hosted by Morgan Franklin

"We haven’t had any significant spreadsheet errors. Therefore, we probably have reasonable spreadsheet controls; and I have other important things to focus on." This hypothesis works until you wake up and find that you are a headline on Google.

You should listen to this recorded webinar if you say yes to any of the following questions:

• Have you ever detected an error after the spreadsheet was distributed?
• Do you utilize spreadsheets to support critical business decisions or reporting?
• Are you concerned that the controls in place to mitigate spreadsheet risk are not effective or properly evidenced?

Managers and supervisors need a process that helps their organization easily assess risks in their spreadsheet environment, as well as help to align consistent controls to mitigate assessed risks.

Click here to link to Morgan Franklin Site for the Recorded Webinar

Click here to Download Slides

Addressing the Spreadsheet Problem in Energy Trading Hosted by Protiviti

Spreadsheets are pervasive throughout the energy trading process. This is because energy trading markets are frequently changing - new products, instruments and derivatives. User expectations for agility and "real time" information mean that IT cannot react quickly enough. Indeed in many cases a spreadsheet is the right solution if it can be controlled.

Click here to Download Slides

The Plague of Spreadsheet Fraud & How to Address It

This is the presentation given to the ACFE (Association of Certified Fraud Examiners) in early May, 2010. This documents the main groups of spreadsheet fraud, with many examples, and shows how ClusterSeven technology can detect these behaviors.

Read the full presentation

Spreadsheets Anonymous - only you can decide if they can help you

A light-hearted approach to test your addiction to spreadsheets. Enjoy the presentation and come chat with us about the realities of spreadsheet management.

Read the full presentation

Spreadsheets - and why we use them

An introspective and compelling presentation by Stephen Ashton, Dresdner Kleinwort Bank, on the history of spreadhseet usage. Including contemplative notes on when does a spreadsheet actually 'becomes' an application.

Read the full presentation

Operational Spreadsheets - a growing awareness

The importance of spreadsheets in the operational and regulatory landscape has grown significantly over the past few years. Corporations have paid more attention and increased investement in the protection of this intellection property to their overall benefit.

Read the full presentation