Financial Decisions In Time with Real Time Big Data Reporting System for Telecom

  • Duration: 3 months
  • Industries: Telecom Industry
  • Services: Custom Software Development; IT Consulting; Early-Stage Innovation, R&D Services; Software Reengineering, Refactoring and Modernization. Cloud Migration; Software Integration Services
  • Software Categories and Types: Analytics Systems, Data Analysis & Visualization
  • Technical Expertise: Research and Development (R&D); Databases; Big Data/ETL and BI/Data Science; Data Transformation
  • DevOps Expertise: Virtual Machines
  • Technologies: Project Management, Collaboration and Bug Tracking; CI/CD Automation Servers; Amazon Web Services (AWS); Jenkins; Cassandra; JUnit / TestNG; Data Bases; Java; Hudson; MongoDB; Cloud Platforms; Backend; Oracle DB; Concurrent Versions System (CVS); Spring; Source Code Management (SCM); Apache Druid; Test Automation; CI/CD and DevOps; Software Engineering and Management Tools; Spring Batch; Bugzilla; Micro Focus Quality Center; NoSQL DBs
  • Team size (3):
  • 1 Project Manager
  • 1 Frontend
  • 1 Backend

Project summary

thumbnail-image

The product is a real-time reporting system that works with a large number of different telecommunications data. The need for this product at the customer’s enterprise arose due to the slow operation of the existing system, which gave the final result to the user in several minutes.

As a result, the JazzTeam engineers created a high-performance system that allows generating the necessary reports almost instantly. In addition, the functionality of this reporting system has been significantly expanded.

Technical description

The customer uses the Oracle Database, which contains a large number of records. The complex structure of the database and the large amount of data led to the fact that the report generation based on these data was quite slow. The main task of our team was to reduce the time required to generate reports without changing the existing data structure.

At the stage of technical analysis, the decision to use the OLAP approach and implement the analytical data storage without changing the existing Oracle Database was made. Three candidates were selected:

  • Mongo DB
  • Cassandra
  • Druid

Each system was loaded with real data and measured with performance indicators tests. The best result was shown by the Apache Druid system. Its architecture is well suited to quickly generate reports from a large database.

At the next stage, we developed a prototype based on the following bundle: Oracle + Java + Spring + Spring Batch + JUnit + Apache Droid

The prototype performed the following operations:

  1. Exporting data from Oracle Database.
  2. Uploading data into Apache Druid.
  3. Report generation.
  4. Addition and adjustment of existing reports.

The customer was satisfied with the successful testing and results demonstration with help of the prototype.

Technologies

Programming language: Java.

Frameworks: Spring, Spring Batch, JUnit.

Databases: Oracle Database, Cassandra, MongoDB, Apache Druid.

Cloud service: Amazon Web Services.

Screenshots

Project features

  • Dealing with production data; GDPR compliance.
  • Creation of unit tests for various NoSQL databases (Cassandra, MongoDB, and Apache Druid) in limited time.
  • Real-time report generation.
  • Possibility to update existing reports with new information.
  • Limited development time.
  • Adherence to Scrum processes throughout the project.

Software

Project results

  • A comparative analysis of several Big Data systems for a specific practical implementation has been performed.
  • A high-performance interactive system for generation of required reports has been developed.
  • The functionality of the implemented system fully meets the customer’s requirements.
  • A possibility of viewing and updating existing reports has been implemented.
  • The customer deemed successful all iterations of the project.

The company’s achievements on the project

JazzTeam staff has examined existing research on the project subject and conducted their own benchmarking analysis of several data transformation and storage methods, while keeping the integrity and security of customer’s data.

Clients about cooperation with JazzTeam

Related projects

By industries:Telecom Industry

Recent Work

    Contact Us

    What happens next?
    • 1

      Leave your project request. We will contact you and schedule a call.

    • 2

      Signing of the NDA to ensure the project info confidentiality.

    • 3

      Negotiation of your request and the required services.

    • 4

      Team forming, coordination of workstages.

    • 5

      Contract signing and project start.