Case studies that reduced TCO by up to 50%

The Client

One of the largest (Tier-1) wireless service provider (USA) having more than 30 million subscribers.

Goal

Engineering & operation teams across all the markets/regions like to manage their customers, networks and its services with ease using an efficient single interface and platform by providing critical data on time

Functionality of AIMS

• Network Data Analyzer is an Open Query tool that allows various users to run queries on different data sources and overlay critical information in GIS mapping. It also provides meaningful information in the form of Map, datasheets related to the ad-hoc queries created by users.
• Overlaying coverage information using map facility across markets/regions and allows users to create and update ISA (Impaired Service Areas) in their wireless coverage area, Managing Trouble Ticket events related to customer service issues with in a short time

Challenges/Business Need

• Challenge is to provide a low cost query engine tool with very minimal turn around delivery time, rich functionality and better performance for the end users.
• Interoperability with multi vendor databases to manage and improve overall end-to-end engineering operations and its daily day-2-day operations of various end users by providing critical and useful data on time. 
• Addressing customer service issues with no time.

Solution Provided

• We are responsible for developing data mining tool to allow, communicate and extract meaningful data from heterogeneous data sources and provide meaningful data to different users in real time.
• Able to manage service issues and trouble tickets related to entire engineering and operations team across all the markets/regions using single interface.
• Robust error handling solution was provided with database driven error description supported by error code

Solution Benefits

• Client was able to save more than 50% of cost by developing tool using Prithvi’s Global Delivery model.
• End-to-End operational maintenance with least effort to manage and address issues related to client’s network, services and their customer problems.
• User can build adhoc queries with minimal SQL Knowledge.

Technologies Used in the Legacy System:

Windows Server 2000, SQL DB (application Databases), Oracle database (only for data queries), Softmask for VB, CTSchedule for VB, VS Flexgrid for VB , Mapinfo OCX control(MapX), ChartFX controls for VB, VB 6.0

Technologies Used in the Current Application:

Windows Server 2000, MS-SQL DB 2000 (Application Database), ORACLE DB 9i (Data queries), .NET MAPINFO control/ MAPEXTREME, Infragistics .NET controls 2006 v 3.0 CLR 1.x, ChartFX for .Net 6.2, C#.Net 1.1 development language