A centralized and secure cloud-based financial data warehouse provides a single source of truth, improving analytics and reducing risk, for a major insurer.
Client
Large NY-based life insurance and investment company
Goal
Consolidate multiple accounting systems into a centralized, reliable data warehouse to improve reporting and decision-making
Tools and Technologies
BNY Eagle Access, Python, Oracle, AWS EC2 and S3, SQL Server, Jira, Stonebranch
Business Challenge
The insurer faced growing inefficiencies due to siloed accounting systems that lacked integration, consistency, and scalability. Reporting processes were time-consuming, error-prone, and lacked real-time visibility—hindering timely business and investment decisions. A centralized solution was needed to ingest and unify data from disparate systems like SAP GL, Singularity, and Loan Management into a single, trusted platform to support strategic financial insights and reduce operational complexity.
Solution
- Built a centralized accounting data warehouse using the Eagle Access secure private cloud environment
- Ingested and standardized data from SAP GL, Singularity, and Loan Management systems
- Used AWS EC2, S3, and Stonebranch Universal Automation Controller for cloud infrastructure and job orchestration
- Enabled real-time reporting via Tableau integration and migration of legacy dashboards
- Improved data accuracy and consistency through robust validation and automation
Outcomes
- Created a unified source of truth for all accounting data
- Enabled faster, more accurate reporting and analytics, improving business and investment decision-making
- Reduced data silos and improved accessibility across systems
- Minimized infrastructure complexity and operational risk with secure private cloud hosting
- Enhanced efficiency through automated data processing and orchestration
