Settings for your viewing comfort
Close settings

Case Study Sun Life Financial

Waterloo, Ontario
Financial Services

Complex application screens for potential fraudulent activities

Sun Life Financial is a leading international financial services organization providing a wide range of wealth accumulation and protection products and services to individuals and corporate customers. Tracing its roots back to 1871, Sun Life and its partners today have operations in key markets world-wide, including Canada, the United States, the United Kingdom, Hong Kong, the Philippines, Japan, Indonesia, India and Bermuda.

Sun Life Bermuda needed to establish a central repository of client data and information about their Annuities and Life business applications. This repository would be used to feed the Anti Money Laundering (AML) process and to generate reports about the quality and volume of sales for certain client types such as Financial Planners, Brokers, etc.

FD Solutions was approached by Sun Life to design and develop a system to capture insurance policy application data and client case information to be used as a repository for screening against AML systems and for producing on-demand predefined reports.

Read Details

Challenge accepted

Develop and implement a system that captures insurance policy data and client case information for screening against an anti-money laundering database and produces predefined reports on demand.

Solution delivered

FD Solutions created a web-based application entry system that allows Sun Life staff the ability to screen for potential money laundering activity and offers flexible ad-hoc reporting capabilities. The system uses roles-based permissioning to control access to sensitive data, and provides duplicate check functionality to detect against applicants using aliases or other fraud tactics.

Technologies

  • .NET
  • SQL Server
  • SSIS (SQL Server Integration Services)
  • ASP .NET MVC
  • MS SQL Report Builder
  • SSO (Single Sign-On via Siteminder Authentication)
  • .NET
  • SQL Server
  • SSIS (SQL Server Integration Services)
  • ASP .NET MVC
  • MS SQL Report Builder
  • SSO (Single Sign-On via Siteminder Authentication)
  • .NET
  • SQL Server
  • SSIS (SQL Server Integration Services)
  • ASP .NET MVC
  • MS SQL Report Builder
  • SSO (Single Sign-On via Siteminder Authentication)
  • .NET
  • SQL Server
  • SSIS (SQL Server Integration Services)
  • ASP .NET MVC
  • MS SQL Report Builder
  • SSO (Single Sign-On via Siteminder Authentication)

Benefits of deliverable

Integration with Sun Life's single sign-on Siteminder technology.

Ability to screen for potential money laundering activity.

Sophisticated business logic to identify relationships of up to five degrees of separation between entities, to detect potential fraudulent activity.

Robust search capabilities including "sounds-like" functionality, to minimize data entry of duplicate entries.

Roles-based permissioning, to control access to sensitive data.

Flexible ad-hoc reporting capabilities.

Ability to track sales of policies across various lines of business.

Variety of robust administrative features.

Scalable solution that can grow with the expansion of Sun Life's business.

Solution details

FD Solutions developed a solution that involved the creation of a web-based application entry system that allows Sun Life staff the ability to screen potential clients against an anti-money laundering database. The system was implemented with roles-based permissioning to control access to sensitive data, and has a robust search engine and duplicate check functionality for detecting potential money laundering activity by applicants using aliases or other fraud tactics.

Sun Life screenshot of the Administration panel and the Roles & Permissions tab

The system was also built to provide flexible ad hoc reporting capabilities using MS SQL Report Builder. This allows Sun Life operators to track sales of policies across various lines of business and to track performance by various third-party General Agents and Financial Representatives who submit client insurance applications to Sun Life.

Sun Life screenshot of filling out entity information when creating a case

The system offers a suite of sophisticated administrative features that let authorized users manage and maintain drop-down value lists, edit the display labels used throughout the User Interface, manage system configuration details and parameters, and create and manage roles and user permissions.

The system is now used by Sun Life staff in Bermuda, Ireland and the United States.

A few words about the project

Feedback

We were looking for a creative and usable database solution to our front end client data gathering processes. You helped us realize this by first providing excellent mock-ups, then delivering a user friendly, working .NET application from these mock-ups.

— Manager at Sun Life Financial

Back to top