Gearbox

Gearbox Software launched their currency gift card in October 2019. They wanted to outsource the project for managing data, analytics, and data security and infrastructure. They also wanted a microsite for reporting.

There were various sources of data from different vendors. The goals were:

• Consolidate all data

• Data validation script

• Data prep

• Daily data update on reports

There were various sources of data from different vendors. The goals were:

• Monthly statement for partners

• Sales and redemption visuals

• Sales comparison

• Data complaints report

There were various sources of data from different vendors. The goals were:

• Create a microsite for easy access to reports

• Integration with QuickSight for accessing dashboard

• Integration with AWS services for managing user access and roles

There were various sources of data from different vendors. The goals were:

• Protected environments

• Tightened perimeter security measures

• Advanced authentication and authorization

• Access control security measures

• Managing Data – Gathering card activation and redemption data from different sources. Consolidating data and importing into AWS big data solution. Designing procedures for data validation, handling and consolidation.

• Monthly Statement – Providing monthly statements for different platform with their fee calculation.

• Data Analytics – Using data from AWS database, we designed different dashboards for different partners based on their privileges.

  • QuickSight – We used AWS QuickSight for designing reports

  • Microsite development for accessing AWS QuickSight reports – We create a microsite for partners to access for their dashboard.

• Server – Managing AWS Server and Security Implementation

Let’s discuss your business needs!

Our website developers laid out a plan to obtain the best possible results for Gearbox Software.

• Gathering information: We coordinated with the client to understand their requirements. This helped us gain a concrete understanding of their purpose, goals, target audience, and content type.

• Brainstorming discussions: Internal and external discussions aided us in defining the client’s expectations and delivering the best results.

• Planning: Based on information received from the client, we decided to upload the sales data in SQL. A comprehensive table of net revenue was also prepared in SQL for analysis purposes.

• Developing: In this stage, the sales data was uploaded in SQL. A comprehensive view was also prepared in SQL. Based on the view, the data set was prepared in QuickSight for preparation of the dashboard. The net revenue calculation was analyzed, and accordingly the calculations were replicated in QuickSight. Discussions have been ongoing with the client regarding automation of the process and the integration of Net Suite and QuickSight for recording purchase order data.

• Testing & Final Delivery: Our team communicated consistently with developers and performed detailed testing. Test cases were created for:

  • Functional testing

  • Non-functional (UX & UI) testing

  • Internal network vulnerability assessment and penetration testing

Want to share your business ideas? Write to us