Breathing Easier

A closer look at a life sciences client whose data was suffocating

THE CHALLENGE

Hylaine's life sciences client had a need to move their existing partner data from collocated SQL Server machines into a managed SQL Server Azure environment.

key findings

After an in-depth analysis, Hylaine identified an opportunity for organization and consolidation when implementing ETL workflows. The team also made recommendations around the client's MS SQL data structure to standardize, enhance, and improve upon current environment objects, and follow current POC patterns.

OUR PHASE ZERO APPROACH

Perform interviews with application owners and leadership, identify dependencies and integration points, data movement, and data architecture

Examine current data integrations and requirements to create orchestration and migration solutions

Analyze architecture, technology and infrastructure choices to provide recommendations and determine implementation priorities

OUR SOLUTION

  • Creation of data warehouse

    Begin migration of applications

    Begin ETL re-platforming

  • Replicate data to Azure

    Complete application migrations

    Complete ETL replatforming

  • Migrate VMs

    Consolidation testing