Gearbox banner
Case study

About Gearbox Entertainment

Gearbox Entertainment is a prominent interactive and independent game entertainment industry player. Launched by a group of renowned game veterans and developers, it entered the global gaming landscape in 1999. It innovated the best-selling video game Brothers in Arms and Borderlands series.

Based in Dallas, Texas, Gearbox Entertainment has carved its niche in crafting games that people love. With a mission to entertain the world, these are globally acclaimed game makers, producing original, inspiring, and record-breaking gaming and media content for the most famous brands.

Dashboard designed for Gearbox
Project Requirements

Epic Games, the Game Developer, launched its Currency Card program for Physical Gift cards in October 2019. BluEnt is the database developer for reconciling and reporting activators’ and platform activity. The client also intended to get a microsite for real-time reporting, data integrity, and secured infrastructure.

Our project priorities based on the client’s requirements were:

  • To streamline data management between the partners and the currency gift card activators. That included data consolidation, validation scripts, data preparation, and transaction report updates for admin and users.

  • Improving data integrity to track, monitor, and organize real-time gift card transactions and reports. That covered monthly statements for activators and platforms, reconciliation with remittance reports and payments, sales and redemption graphs and comparisons, data compliance reports, and more.

  • Launching a microsite to record, visualize, and analyze gift card redemption data from different sources needing data visualization expertise. That compiled interactive business and client dashboards for easy access to reports and with secure user access controls.

Project Challenges
  • Automated gift card data management and reporting for audit transactions outlining activators’ invoices. Transactions reconciliation with remittance reports and invoice statements. Prepare redemption reports, tax and accounting reports, and business compliance reports.

  • Custom platform portal for reporting with seamless and secure access to monthly platform statements and daily transactions reports of different regions or sources in one comprehensive view.

  • Complex data cleanups across location-based merchant reports, including geo-tagging, data integration for multiple sources on one card, accurate and sequenced transaction records, etc.

  • Identification of test transaction including unpaid individual cards by reconciliation of the remittance statements, tagging of influencer and trial cards and prevention of platform fees loss due to redemption of unpaid/test cards.

Reach out to us for cutting-edge data solutions

discover_ai_ani discover_ai_ani
Slice data into
manageable chunks
to decide better.
We will give you
optimized data
visualizations for
each layer.

BluEnt’s Solutions

Gift Card Reporting & Management Pain Points

  • Reconciliation of daily sales transactions with activator portal

  • Inaccurate sequencing of transactions on each card

  • Missing information or short payments from multiple sources

  • Business compliance and security concerns  

Since the client was concerned about inaccurate and inconsistent methods of gift card reporting, we delved into high-level data flow automation and reporting at the initial stage.

Based on the critical pain points of the client, we came up with value-engineered and custom gift card management solutions, including:

Custom Gift Card Reporting Dashboard

  • Total activation and redemption reports by distributors, retailers, platform and geography derived from advanced ETL (Extract, Transform, and Load) process.

  • Database design optimization to draw location-wise daily statement reports by region, city, and ZIP.

Daily Statement Automation & Reconciliation Features

  • Data validation and integrity for reconciliation on tax calculations, activator statements, invoices, transactions adjustments marked as void or test transactions, and missing or hidden activation.

  • Data sync for daily, weekly, and monthly remittance details from primary sources (inComm IRIS, EPAY, BLACKHAWK, and Fortnite).

All-in-one Microsite for Sales Tracking and Analysis

  • Reporting partner portal using AWS QuickSight/Tableau for a holistic view of detailed reports and statements from varied regions. Advanced latitude and longitude mapping extract exact location information for each gift card transaction.

  • Managed user access and roles featuring advanced authentication and authorization for multi-layered security and protected environment. 

  • Unified, cloud-driven, and interactive dashboard to build with managed user access and roles. Robust data governance and implementation for security, quality, and precise data analytics.

The BluEnt Approach

Our data engineers planned to obtain the best possible results for Gearbox Entertainment.

Foremostly, we coordinated with the client to understand their requirements. That helped us understand their pain points and recommend the most practical solutions.

  • We began with a complete data syncing process for gift card reporting, from data importing to data validation, cleansing, optimizing, and modeling. The core database encompassed daily activator data from primary and other sources, including inComm IRIS, BHN Reporting Portal, activator invoices, and bank statements.

  • For the microsite, we used BI tools for custom data visualization (designing reports and dashboards) and AWS cloud services (user access and roles). 

  • Our data teams integrated user authentication and authorization for admin, reader, and author portals to improve security. 

Explore more success stories for data analytics and management.

View Case studies
service provider


  • The microsite combining separate dashboards for admin and end users dissolved the reporting errors, user access controls, and security lags in the gift card system.

  • Core Features for Admin Portal

  • User Login

  • Manage Users

  • Manage Dashboard

  • Manage Dashboard Permissions

  • Core Features for End Users/Partners/Vendors

  • User Login

  • Dashboard Categorization List

  • View Dashboard Filter

  • With interactive dashboards and customizable reports, sales data analysis and net revenue calculations are now more streamlined and precise than before. It has also become easier for admins and vendors to track and interpret daily activators, gift card redemption, reconciliation, and business compliance reports all in one place.

  • Multi-user access controls and advanced authentication for the partner portal mitigated significant client security concerns.


The client was satisfied with the outcomes of counting on our data integration and management expertise.

Epic Games database administrator aptly guided BluEnt in developing their in-house data site and acknowledged our result-yielding competencies and value-engineered solutions in addressing the major pain points that weren’t overtly visible for the nascent card program.

Words from the Client

quote mark

Contact us now

Need a Strategy for Data Success?

Let’s Talk

Case Studies

Discover how we’ve helped businesses across the world.

Connect with us!

Let's Talk Fixed form

Let's Talk Fixed form

  • ✓ Valid number ✕ Invalid number
  • This field is for validation purposes and should be left unchanged.