

Client
Large NY-based life insurance & investment company
Goal
Modernize multiple legacy accounting systems to achieve operational efficiency, scalability and improved data analytics.
Tools and Technologies
Python, Oracle, SQL Server, AWS Server, Jira, Stonebranch
Business Challenge
The insurer sought a comprehensive cloud-based solution using modern infrastructure and automation to address key challenges. The Singularity platform was selected to integrate investment data from multiple accounting systems, including SS&C CAMRA, Blackrock, IDCFX, Mackay, and Marked Price, into a unified solution. The project aimed to modernize the insurer’s legacy Debt & Derivatives system, which was limited in functionality, lacked scalability, and hindered business growth due to its outdated, on-premises infrastructure.

Solution
- Seamless integration of data into and out of the Singularity platform enabled streamlined operations
- Stonebranch Universal Automation Controller on AWS was leveraged to automate and schedule data extracts, ensuring timely and reliable data availability
- Robust data integrity checks were embedded throughout the pipeline to maintain high-quality outputs
- Tableau was integrated to deliver interactive dashboards, enabling data-driven decision-making across business functions

Outcomes
- The solution delivered greater scalability, system reliability, and data accuracy
- The streamlined data ecosystem significantly enhanced overall user experience
- Unified data and interactive Tableau dashboards established a single source of truth, supporting more informed business decision-making
- The modernized platform enabled the generation of complex business-critical reports that were not possible with the legacy system
