Web Report System Development for an EU Client

Client Information

This client is an Australian telecommunication service provider who provides billing analysis for organizations including Land Lines, Mobile Phones, Voice, Data and Pager Systems. As part of the monthly reporting solution, the client developed a single page TPI (Telecommunications Performance Indicator) report which provides management with a list of key telecommunications statistics. Reviewing this on a monthly basis quickly highlights issues and enables the initiation of an investigation into the area of concern.

Requirement

The client needs to develop a web report system to help the users checking or downloading TPI report online. Because the client has authorization from several telecommunication companies, the system is required to process billing file in various formats at the back end automatically. The formats include .DBF, .BIL, .CSV, .TXT, .DAT (Fixed Width), MDB. Processed data can be saved to assigned database and displayed to users via SSRS. User can also create a new task to export a report.

Function Point

• Mapping
• Billing Upload
• Billing Process
• Report Setup
• Report Management
• Generate Report
• Client Management
• Configuration Management
• Allocation Management

Solution

Due to format variety of data resources, we decide to import billing files by using SSIS. After clarifying field mapping relationship between source and target, we create a SSIS Sub Package for each format of billing file correspondingly. Thereafter, a Main Package is created to manage and decide which Sub Package(s) is going to work. Main Package is called by Web Service and SQL Server 2005 Jobs.

SSRS is used to meet the requirement of report creating and display. Functions as filter, sum and others could be reached by database view and query. By calling web service, system can choose between different report formats, as PDF, Excel, Html or others.

In order to guarantee accuracy and standardization of data, ensure no bug in Data Access Layer and Business Entities, Software Framework. Data Access Layer and Business Entities are created automatically. The system used WSSF and WCSF to make the software framework.

VSTS and PMS are used in code management, project management and bug management. Follow MSF development criterion, keep smooth communication, standardize work process, track bug management.

 

Request the complete case study Contact sales