Engineering Leadership for the Zombie Horde
”
Client Engagement Info
Industry
Entertainment
Size
Medium
Years Serviced
> 3
Select a Project :
Data Warehouse for Skybound Entertainment
Overview
One of our first projects we took on when we started engaging with Skybound was to rebuild and migrate their existing Data Warehouse from Rackspace to AWS. Skybound’s Data Warehouse is a giant database where one single table has over 430 million rows that stores data from multiple sources and is integrated with Tableau for advanced data visualization and reporting.
Challenges
The original Data Warehouse code was a mess of scripts and cron jobs scattered across a server. We had to not only manage migrating database tables with millions of rows of records from one cloud provider to another (the database was so big that the traditional AWS migration tool failed and we had to script the entire thing by hand table by table), but we also had to reverse engineer all of the existing scripts and rebuild them with best practice PHP in Laravel.
Solution
The solution was to migrate Skybound to a modern API application built with Laravel hosted on AWS
- Migrated from Rackspace DynamoDB to AWS Redshift
- Rebuilt hodgepodge scripts into modern API system leveraging Laravel
- Ecommerce integrations with AWS, Ebay, and Shopify
- Social integrations with Facebook, Youtube, Instagram, Twitch, and Twitter
- CRM Integration with Sendlane
- Custom Subscriber integration with the Insiders Laravel Application
- Game Sales Integrations (in progress)
Technologies
Results
The result of this massive project is a scalable data infrastructure which we help to maintain and further scale. The previous solution required constant maintenance and management to keep all of the scripts and crons running properly. Now we have a scalable API system that we can continue to grow with new data and integrations.
Select a New Skybound Entertainment Case Study
Related Case Studies
We partner with Skybound, acting as an extension of their internal team to prove technical leadership for the organization’s online activities. Our team communicates using their internal communication channels, we have multiple calls per week, and their team directly contacts our engineering leads when issues arise. From system refactoring and ecommerce development to marketing support and back-office automation, we support Skybound through their ever-changing priorities and initiatives.
