Data Management and Report Development

Challenge:

Our client was experiencing an exponential increase in users. It was vital to manage the increasing data with an optimized database schema. Additionally, the client wanted to use the data to guide the design of new features and seasonal games.

The data was generated from various sources that resulted in the inconsistency and fragmentation of user data.

How Optimus Helped:

Our client was assisted by our technical experts to design and improve on the database schema. Our client also saw an opportunity to use their cloud infrastructure as a means to achieve database scalability. Once the database schema was designed, the data was cleaned and imported into their cloud infrastructure.

The new database became a single source of accurate information for master data that informed decision making resulting in a competitive advantage that allowed the company to pursue strategic initiatives with greater confidence.

By using Vertica DBMS, we helped to set up an open source reporting portal on their cloud. We then developed graphical reports that helped our client understand their users’ activities, likes and dislikes, and peak hour game performance. Reports were developed with superior query optimization techniques to run on the real time game and revenue data.

Our client was able to plan in-game promotions and build revenue-generating features that enhanced gaming performance. By choosing Optimus to help consult and deliver improved data management and reporting services, the online gaming client took major strides towards its goal of becoming a high-performance business.