SIKKIM MANIPAL UNIVERSITY

SYNOPSIS

ON

“MTNL BILLING SYSTEM”

Submitted in partial fulfillment of the requirements for qualifying

MSC(IT)

SUBMITTED BY

NAME :

ENROLLMENT NO :

UNDER SUPERVISION OF:

TITLE OF THE PROJECT

OBJECTIVES OF STUDY

Objective

This project is designed to achieve the following objectives:

To make the processing of MTNL Billing system easier & faster. Also to generate various types of reports requested by the user of the application. It contains the following features:

The whole system should be menu driven & the main menu should be displayed automatically as soon as the user logon succeeds.

The software must have a user-friendly interface & appealing appearance to ease the work of the end users.

The system should be able:
• To maintain consumers details
• To maintain bills paid by the consumers
• To add complaints, to assign complaints to the engineers and update the status of the complaints.
• To add new installations and connections.
• Update disconnections.

Above all the software system should be able to eliminate all the paper work required in implementation the task of data maintenance, which previously was tedious, time consuming and error prone.

PROBLEM STATEMENT

This is a Project work undertaken in context of partial fulfillment of the BCA.
MTNL has recognized that IT is the key to future business success. IT is being implemented as the backbone for running customer friendly services. Several IT systems and accounting and billing systems are already operational at MTNL.
Existing MTNL billing system had problems right from the beginning. Not only has the billing system worked erratically since, but also following the launch of services the subscribers (not many to begin with) were also not issued bills for months together. All due to some software problems,” the sources noted.
The billing system was working slowly and it was not possible to generate automatic disconnection list due to non-payment, complaint details etc. with the result that timely disconnection was not possible. All these factors resulted in heavy outstanding.
Apart from this, many subscribers continued to make heavy calls and then migrate to other mobile operators, leaving heavy outstanding amounts with MTNL.
They pointed out the problems in the billing system that continued and these include delayed implementation of roaming module, provisioning of credit control and service interface which continues to throw up sporadic mistakes in billing generation.
The present system also does not allow for monitoring of cases with outstanding payments, automatic generation of payment reminders, automatic disconnection and reconnections.
With the result, the outstanding dues of MTNL have only mounted.

TOOLS/PLATFORMS, HARDWARE & SOFTWARE REQUIREMENTS

HARDWARE:
Processor : Pentium 2.4 GHz or above
Memory : 256 MB RAM or above
Cache Memory : 128 KB or above
Hard Disk : 3 GB or above [at least 3 MB free space required]
Floppy Disk : 3.5” with 1.44 MB capacity
[at least one drive labeled A: required]

SOFTWARE:
Operating System : Windows 95/98, Win NT, Win 2000.
Font-End Tool : VISUAL BASIC .NET
Back End Tool : SQL SERVER

FRONT END:
• Visual Basic .NET is one of the languages that are directed towards meeting the objectives of the .NET initiative of creating distributed applications.
• Visual Basic .NET is a powerful object-oriented language that provides features such as abstraction, encapsulation, inheritance, and polymorphism.

Features of Visual Basic .NET
• Some of the key features of Visual Basic .NET are as follows:
o Inheritance
o Constructors and destructors
o Overloading
o Overriding
o Structured exception handling
o Multithreading

SQL SERVER

Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). Microsoft SQL Server is probably the most accessible and the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other database environments on the market.

METHODOLOGY AND TOOLS USED

Advent of computers in the last two decades, every organization is going under the process of computerization. The computerization has many benefits. Primarily, a computer is helpful in four major aspects of any kind of organization:
Time Efficiency
Cost Effective
Huge data storage capacity and
Simple operation

Moreover, with the advent of the Internet technologies, World have changed lot call it the social web. Through the dot COM bubble and bust, one trend has never wavered. Every year, millions more people around the world are using the internet to interact in more ways then ever before to date, find old classmates, check on medical elements and cures, to read and express alternative views of the news, and even to give live sales help online, and in so many other areas.

We have several alternative suggestions about the project category like: desktop application, web-based application, OOPs application, Networking, RDBMS etc. Out of available one we have opted Web based application based on client server architecture. The proposed system falls into the category of Multimedia. A web based system has two types of pages one is static web pages and another are dynamic web pages, which are saved on web server and can be seen by sending request to web server through HTTP protocol.

Static web pages: – Static web pages are easy to spot sometimes we can pick them out by just looking at the content of the page. The content (text, images, hyperlinks, and so on) and appearance of static web pages is always the same regardless of who visits the page, or how and when they arrive at the page, or any other factors.

Dynamic web pages: – The dynamic web pages are web pages, which we can interact like a time is shown on the page or we are sending information through web form, online chat, sending mail on net etc all the action this action performed with the help of dynamic web pages.

Web Server: – Web server are software that manage web pages and make them available to client browser via local network or over the internet. In the case of the internet, the web server and browser are usually on two different machines, possibly many miles apart. However, in a local situation you can set up machine that runs the web server software, and then use a browser on the same machine to look at its web pages.