Swedish School of Economics and Business Administration Program in Advanced Financial Information Sy

1
Swedish School of Economics and Business
AdministrationProgram in Advanced Financial
Information SystemsCOMPRE NORDIC OYDATA
WAREHOUSING AND DATA MININGCOMPANY CASE

• Juha Nora
• Jukka Hirvonen
• Olga Kleerova
• Triin Kadak

Autumn 2006 Helsinki
2
Agenda

• Overview of Compre Group
• Services Provided by Compre Nordic OY
• Presentation of the Financial Information Systems
  
• Positive Sides of the Systms
• Issues for Further Attention
• MRP
• Suggestions

3
Compre Group

4
Compre Nordic Oy

• Independent operator in (re)insurance run-off
  market as service and solutions provider and
  investor

5
Finacial Information Systems

• OpusCapita
• SunSystems
• ReSys

6
Positive Sides

• Modern IT infrastructure and FISs
• ReSys
• - data warehouse for reporting
• OpusCapita
• - most popular electronic banking
  system in Finland
• SunSystems
• - versatile financial accounting system
• - Vision Excel and Vision Executive

7
Issues for Further Attention

• Quality of the connection to servers
• Competencies for developing ReSys
• Amount of manual work
• Creation of management reporting package
• Making changes in ReSys

8
MRP

• Importance of the reporting activity
• Reporting is essential for an insurance company,
  since the insurance liabilities are protected by
  law and are monitored by Insurance supervisory
  authority (ISA).

9
Current MRP Compilation Process
10
Suggested MRP Compilation Process
11
Suggestions

• Develop competencies within the Company related
  to ReSys
• Having the server of SunSystems in Finland?
• Electronic link between Opus Capita to
  SunSystems
• CrystalReports/QlikView and predefined MRP report
  templates
• Error analysis, user training, automated check
  scripts and protocols
• Workflow Management System (WFMS).

12

• THANK YOU
• QUESTIONS?