Architecting for Change: How We Helped a Leading U.S. Insurer Cut Technical Debt by 97% and Modernize at Scale
Case Study
Insurance
SSIS/SSRS support and consolidation for a F500 leading insurance provider
A Fortune 500 commercial lines property and casualty insurance holding company had 5 subsidiaries and each of them had a different technology landscape which resulted in maintenance challenges and hindered the capability of application rationalization for eventual migration to the cloud.
Client Challenges and Requirements
- Each subsidiary had individual applications designed differently catering to the same business solution
- No overlap between the applications meant they were operating independently and hence duplicating the effort involved in maintaining them
- No documentation was available which made rationalization a challenge
- Absence of holistic understanding of the systems resulted in delays to cloud migration
Tools & Technologies We Used
SSIS
SSRS
SQL Server
T-SQL
SQL Server Agent
Azure
Key Results
Enabled a detailed knowledge repository
Maintenance of ongoing activities
Enabling architects to design future solutions
Remediated existing pain areas
Client Challenges and Requirements
- Each subsidiary had individual applications designed differently
catering to the same business solution - No overlap between the applications meant they were operating
independently and hence duplicating the effort involved in
maintaining them - No documentation was available which made rationalization a
challenge - Absence of holistic understanding of the systems resulted in delays
to cloud migration
Bitwise Solution
test (4)
Listed down the statistics for each application enabling architects to draft a modernized cloud solution
Carried out system appreciation sessions and documented detailed application documents while capturing all key aspects
feature (1)
Maintained the applications while stabilizing some pain areas
Tools & Technologies We Used
SSIS
SSRS
SQL Server
T-SQL
SQL Server Agent
Azure
Key Results
correctCreated with Sketch.
Enabled a detailed knowledge
repository
correctCreated with Sketch.
Maintenance of ongoing
activities
correctCreated with Sketch.
Enabling architects to
design future solutions
correctCreated with Sketch.
Remediated existing pain areas
Share This Case Study
Download Case Study
[contact-form-7 id="41633" title="CS - SSIS/SSRS Support & Consolidation"]
Bitwise provides comprehensive solution for all your data projects
Related Solution
Automated ETL Migration
Risk-free conversion and optimization of source ETL jobs to a target ETL tool with maximum automation
Learn More
Ready to start a conversation?
Contact Us
Related Insights
