Health insurance company undergoes technology modernization project with Microsoft Data Integration
Health insurance company engages Baker Tilly to implement a data integration and conversion solution with Microsoft Data Integration.
Client background
This company is a large insurance provider offering Individual, Medicare and Employer plans. They are comprised of an extract, transform, load (ETL) and business intelligence (BI) team of 15+ ETL, data warehouse and business intelligence developers.
The business challenge
The client was undergoing a total quality improvement and technology modernization project which required a partner to assist with the architecture and implementation of a Medicare claims data conversion process. This entailed converting a large Medicare population from one of their legacy enterprise claims processing software to a more modern solution.
Director, IT DevelopmentBaker Tilly has helped us by providing expert consultants to work and train our development team on new features and functionality within the Microsoft platform, make recommendations on how to implement new features and provide guidance on how to optimize programs and reports we have previously developed.
Strategy and solution
Baker Tilly implemented a data integration and conversion solution that minimized overall project resources and eliminated additional development efforts for the data conversion.
- Interviewed ETL/BI team and the business in defining the best course of action
- Walked internal team though collaborative architecture session
- Implemented and delivered solutions through Microsoft’s Data Integration platforms
Through our approach, the client was able to successfully go-live with a new enterprise-wide claims processing software, adding new strategic capabilities of processing Medicare claims internally.