Company Information
T-Mobile is a leading telecommunications provider in the United States, known for its innovative approach to mobile connectivity and customer-first strategies. With a vast nationwide 5G network, T-Mobile offers wireless voice, messaging, and data services to millions of consumers and businesses. Committed to delivering high-speed, reliable, and affordable solutions, the company continues to disrupt the telecom industry with its focus on innovation, customer experience, and expanding digital access. T-Mobile’s mission centers around connecting people to what matters most, driving advancements in mobile technology, and providing superior services across various sectors.
The Challenge
A team within T-Mobile relied on a legacy on-premises Oracle Database. As its data volume grew, the legacy database proved unable to handle the business’s desired data-aggregation queries. These bottlenecks proved to be an ideal use case for Snowflake’s highly scalable, high-performance cloud data platform.
Our Approach
ProCogia migrated this team's legacy data from Oracle to Snowflake, applying custom ETL to meet the team's requirements such as parsing of unintelligible/numerical codes to human-readable names.
Amazon EMR was used for reading from Oracle DB to Snowflake due to limitations with Snowpark.
Numerous normalized Oracle tables were consolidated into a smaller set of denormalized Snowflake tables.
PII Data underwent anonymization processes within Snowflake's secure environment, ensuring enhanced data privacy and protection.
Daily QA counts were generated and displayed in a dashboard, so engineers and stakeholders could monitor daily/weekly/monthly data volume trends.
Architecture
Results
With the on-demand scalability of Snowflake, this team was able to run their queries in minutes rather than hours and days.
Better Security and maintenance with centralized auditing of user/role access.
The biggest success for business stakeholders was the enablement of large data aggregations for reverse billing, leading to the recovery of $2M in revenue.
Conclusion
In migrating from its legacy on-premises Oracle Database to Snowflake, the team immediately unblocked the scalability issues that had restricted it. This provided immediate value by enabling the recovery of $2M in revenue. Once migrated to the Snowflake Data Platform, the benefits extended far beyond scalability and performance: Snowflake’s access-control and data-sharing features streamlined the team’s data governance process.
