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.
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.
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.
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.
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
Final
Outcomes
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.
Conclusion
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
Need a Strategy for Data Success?
Let’s TalkCase Studies
Discover how we’ve helped businesses across the world.
Take insights into our success story for Gearbox Entertainment, a renowned game developer we benefitted with gift card management, reporting, data integration, and analytics solutions.
Learn more
Take a glimpse of how BluEnt streamlined data integration and management with custom client reporting for HfS Research.
Learn more
