Commissioning Handling and Computation System

Introduction

The commissioning system is a complete integrated system for telecom operators, for the support of the computation and management of commissions and subsidies to dealers and point-of-sales (POS).
The system supports usage based commissions, connection/disconnection commissions and flat bonus commissions.

Features of the system

The commissioning system accepts different types of data from the systems of the organization:

  • Subscriber data, from the billing system
  • Customer data, from the CRM system
  • Dealer data, accepted from a dealers database
  • Invoice data, from the billing/ERP system
  • Usage analysis (per service, destination, etc), from the data warehousing/billing system
  • Payment data, from the ERP system
  • Information about other products or services, if available in other systems of the organization.

The system provides output and results sent to the dealers and the ERP system, and possibly to a print bureau for the production of letters, or information to be presented on a Web site/extranet.

Three main types of commissions are supported by the system:

Aitime/Usage based commission computation.

  • The commissions computed are based on the usage done by customers of the dealer/POS.
  • They are based on the payments done by the users
  • Different percentage of commission depending on the type of usage (national, international, etc.)

Connection/Disconnection commission.

  • The commissions are computed according to the number of new connections done by the dealer during a specific period and the disconnections done (normally counting negative)

Flat bonus

  • Paid to dealers/POS depending on targets set on simple or complex conditions (new connections, number of customers, or any other metric that can be computed on dealers/POS).
  • Additional amount in case of continuous achievement of the target

The main features of the system are:

  • It is very flexible, parameterized and customizable, so that different commissioning policies can be supported. 
  • Possibility for the definition of different scenarios, policies and what-if functionality.
  • An architecture supporting a clear API and the possibility of the creation of different plug-ins, so that new metrics and computation ways can be easily created
  • Complete history of data and computations, so that it is possible the recalculation of commissions at a later time based on historic data
  • Special facilities for security, auditing and logging for all the data of the system as well as the results computed.

The system is based on a client/server architecture (currently a port to a Web based architecture is planned) and the Oracle database is used.