Data Analytics and AI
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
Bitwise Solution

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
Maintained the applications while stabilizing some pain areas
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