The client is a leading North American telecommunications company with an estimated revenue near $24 billion.
Challenge
The client was serving their clients billing reporting data from their on-premise data sources Oracle and Teradata. This had several downsides including a lack of real-time reporting, poor reliability, scalability and stability issues for increased user loads, and high costs for additional infrastructure.
Solution
Orion was contacted to analyze and provide the right fit GCP service for clients analytical warehouse requirements and begin their cloud migration journey. Our team began by developing a PoC with similar data sizes in a GCP sandbox environment using Google BigQuery service to establish the results with performance and cost details. With client approval to move forward, our cloud and infrastructure experts began by establishing a baseline structure and infrastructure to launch the pilot migration wave and scheduling out migration process.
Our team set up the SAS ETL pipeline for historic and daily data movement on top of setting up identity and access management protocols. As the client moved forward on their cloud journey, our team provided cloud monitoring and optimization services, optimizing reporting queries by utilizing partitions and clustering of BigQuery table. Once the financial and budget analysis was complete and summarized, it was presented to stakeholders and the Executive board members.
Impact
This cloud migration approach allowed the client to meet performance requirements their on-premise solution could not. The cloud infrastructure can support 400+ concurrent users and has provided enough scalability to account for 6 terabytes of data growth year over year all while saving more than 10% on operating expense.
