Greetings,

Today Astir would like to share another successfully case study with our audience.  This case study involves a common situation: Company A acquires Company B and now must integrate their systems and data into their existing technology environment.  This can be a complex, cumbersome task that requires many resources and multiples more man hours to complete.  If done correctly, new sales opportunities can present themselves and revenue can be further increased.  If done incorrectly, not only do those sales opportunities get dropped on the floor, important relationships can suffer… leading to long-term revenue loss.

In this case study, a very large Astir customer acquired a similarly sized firm and needed to tackle the gargantuan task of merging their customer, sales, and marketing data into their existing systems.  The data was extremely sensitive and needed to be cleansed, validated, and migrated very quickly.  Given overlap in customers and products, there was an overwhelming need to quickly integrate this data in order to avoid incorrect and ineffective sales follow-ups in order to preserve relationships during the transition period.

Astir IT was engaged to help the customer navigate this process quickly and complete the migration with minimal impact to daily operations.  A team of on-site resources were placed with the customer and worked closely with internal teams to create a set of standard operating procedures and workflows in order to execute a smooth migration process.  Once the data migration was underway, all steps were meticulously documented and multiple back-ups were put in place to ensure that no data was lost or corrupted.  Finally, new data housing systems were built in order to create and maintain a clean, efficient access system for the resulting merged data. 

The initial set-up process and standard operating procedures put into place prior to the data migration resulted in a smooth transition for the customer, and there was zero down-time.  The Astir team remained in place for a short time after the initial migration in order to continually monitor progress and perform any maintenance and training needed.  Ultimately, the customer was able to leverage the merged database to expand their operations.

If you are interested in learning more about how we have addressed a specific topic that you do not see here or on our website (www.astirit.com), please contact us to discuss further.

Business Intelligence, Consulting Business Intelligence, Database Management, IT consulting