Cityline International, a UAE based company involved in mobile entertainment and mobile marketing activities. They are currently offering in Access of 30 mobile-based services in 8 different countries. Currently they have millions of transaction as historical data, which is being increased by tens of thousands every month. The data is distributed in amongst GCC and African countries.

Problem: Distributed non-relational data in obsolete data base
Solution: DXB (Data eXchange Bridge) - A customized true multi-tier solution that collects data from 8 countries and converts it into relational model before updating the central data mart.
Technology: DXB is designed in Visual Basic as front-end with SQL Server at the back-end and MTS as middle tier.

Problem: Unable to generate authentic reports showing revenue, service rates, customer trends etc. on daily, monthly and annual basis
Solution: IM (Intelligent Manager) - Another customized solution designed for generating verity of reports. IM being an Intranet/Extranet web based solution is being used by managers of the company giving them intelligence of their customers behavior and trends.

Some of the salient futures of IM are:

• All reports can be grouped on daily, monthly, annual basis
• Dynamic input criteria, e.g., selection of services, selection of countries etc.
• Generates dynamic graphs (Bar, Pie, Multi-bar, Symbol-Line)
• Each user can create their customize alert graphs (Dashboard) for monitoring any service offered
• Handles unlimited service (Currently Cityline is offering 30 services with over 150 services in historical data)
• Handles unlimited countries