Founded in 1979, the client is a premier provider of auto, home, and business owners insurance in Massachusetts, Maine, and New Hampshire.
The client had a proprietary ETL solution that had no disaster recovery support. They were looking for a more standardized technology that allowed them flexibility and resiliency.
Ironside was brought in to help the client design a new solution leveraging industry-standard data stage software to implement their Data Warehouse using standardized ETL. Ironside architected, installed, configured and continues to manage the software required. The engagement was made up of the following phases:
Established where the client was and where they wanted to be
Proposed 2-3 paths forward with recommendations
Agreed up on path forward that would best accommodate their needs
Installed and configured the InfoSphere Information Server and db2 Cloud for the implementation
Worked with the client to understand the ETL that was already in the environment
Optimized the straight port of the ETL to leverage benefits of both the data stage and cloud-based Data Warehouse
Improved the application configuration on the fly as needed
Verified that functionality matched the requirements
Change & Maintain
Shifted from Cloud Data Warehouse back to On-Prem Data Warehouse and verified that the optimizations worked for the On-Prem solution as well
Continue to support the environment through upgrades and usage and expanded the footprint to include a Cognos Analytics environment
Expanded the footprint to include a Cognos Analytics environment
KEYS TO SUCCESS
Through this engagement, the client achieved the following successes:
Gained a resilient environment that can recover if there is an outage at the primary data center
Trimmed daily ETL load times by approximately 50%
Freed up developers to develop rather than administer
IBM is a leading cloud platform and cognitive solutions company. Leverage IBM’s Analytics portfolio of high-value products and solutions to turn the company you’re running today into the company you’re building for tomorrow.
Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.