Confidential client, name withheld under NDA

Simplifying Annuity Rate Management for Complex Calculations

Quick answer: An annuity rate management platform calculates rates, benefits, bonuses, rollups and withdrawal amounts and turns large rate datasets into client-ready reports. Bacancy Technology built this on Ruby on Rails for a US annuity rate data firm.

Outcomes deliveredDelivered November 2019 to March 2020 by a team of 5 developers
40%

Faster rate report generation

SSIS packages process large datasets

35%

Less time finding annuity rate data

Search across consolidated rate data

30%

Less manual effort exporting rate sheets

Built-in export for client rate sheets

Client name withheld under NDA. To honour our non-disclosure agreement and compliance obligations, we describe this client by industry and region only. The project scope, technology and outcomes are shared without details that could identify them.

About the Client

The client is a US firm that maintains fixed, indexed and variable annuity rate data. It serves many clients at once, each with its own rate sheets. Its data warehouse tracks contract features, rates, fees, expenses, living and death benefit riders and product sales.

Bacancy Technology built a Ruby on Rails platform that runs complex rate, benefit, bonus, rollup and withdrawal calculations. SSIS packages generate reports from the large datasets, and users can search and export rate data directly.

Industry
BFSI
Location
USA
Team
5 developers
Timeline
November 2019 to March 2020
Project size
Non-disclosable

Challenges & Solutions

Our Ruby on Rails developers worked with the client every day to get the calculations right.

Challenge 1: Handling complex annuity calculations on large datasets

Rates, benefits, bonuses, rollups and withdrawal amounts each needed complex calculations across large volumes of data.

Solution: Our developers met the client daily to demo progress and help with data exports. They used SSIS packages and dedicated libraries to generate reports from the large rate datasets.

How the Platform Works

The client annuity rate management platform

Core Features

  • Annuity profile navigationUsers move through annuity profiles and contract details quickly.
  • Complex calculation engineRate, benefit, bonus, rollup and withdrawal amounts calculated in-app.
  • Consolidated rate data presentationFixed, indexed and variable rates shown in 1 place.
  • Search and exportFind rate data fast and export it for each client's rate sheet.

The stack behind the platform

Frontend
HTML | JavaScript | SCSS
Backend
Ruby on Rails
Database
Microsoft SQL Server
Reporting
SSIS

Ready to start?

2500+ projects delivered by Bacancy Technology

Get access to an experienced team of developers and engineers from Bacancy Technology, handpicked to ace your goals. Kickstart within 48 hours, no-risk trial.

Book A 30 Min Call
14+Years of business experience
1458+Happy customers
30+Countries with happy customers
1050+Agile-enabled employees

More Case Studies

View All Case Studies