Web based Integrated Solution for E&D Deptt.

DATA SERVICES DEPTT, EnD and BRAT are one of the most important parts of the telecom industry. Being one of the major revenue generators and catering to big industrial houses and corporate clients, they form the backbone of any telecom company. Our studies lead to the conclusion that in most of the telecom companys the working of these departments is done manual, thus creating an urgent requirement of this software solution. This software is a step further in bridging the gap between various departments pertaining to Data Services Connections. It streamlines the work process between these departments and hence increases the productivity of personnel.    
 
 

The primary objective of the automation of the business functions for all business organizations is to implement information systems, which provide for a vertical integration of the information from the base operational units like branches/Departments with the Head-Office of the Organization.
The Objective of this proposal is to offer a comprehensive IT solution, based on the emerging trends in IT to enable the telecom company to have a uniformly effective transaction level control of its activities and improve efficiency with the following overall aims:
• To infuse considerable ease and flexibility of operations related to Billing, Payments and Report Generation.
• Centralized Architecture for client server application.
• On line Central access to department wide data for effective decision-making.
• Elimination of duplicate and redundant information.
• Swift generation of reports on demand.
• Elimination of inter department reconciliation’s and reports.
• To facilitate command and communication Activities
• Query based availability of position on Outstanding, Revenue Projection and Sales Data.
• Elimination of manual records which are difficult to maintain and duplicate.
• Automated Monitoring and Control.

In order to meet the objectives of the organization for addressing existing information needs SUGARUDYOG.com is submitting this proposal by adopting an integrated approach to inter-department and functional section needs, whereby assessment is made of both application software and hardware including networking needs.
SUGARUDYOG.com offers speedy customization for immediate deployment of this user-friendly application software package across the Organization. An indicative hardware infrastructure need is also being outlined for overall assessment of the solution.

 

The Architecture of the proposed system suggested by SUGARUDYOG.COM is
• Centralized Architecture, with front-end functions across various Departments/locations
• Use Current Technologies, which are user friendly.
• Further Expandability - With the Implementation of Central Integrated Database System, provide for any new location requiring desktop PC, ISDN line / modem connectivity.
• Minimize the investment on distributed RDBMS / OS as well as recurring system administrative effort and expenditure.
• Application Parameter Updation to be instantly effective across all departments.
• Use the telecom company’s existing Wide Area Network

Network Architecture

                         BRAT                                                   CENTRAL APPLICATION SYSTEM                       E n D &  CORPORATE                

                       ISP DEPTT                                                                                                                          TECHNICAL DEPTT

Detailed below is the overall functionality of the Proposed System Modules:

User management
With a view to security concerns, the Software includes enhanced features to obviate possible breaches. These are as detailed below
• Define Class
• Grant/Revoke Permissions to a Class
• User Information
• Grant Permission to User
• Change Password
• Maintain User
• MIS

Application management
• Routine Database Backup
• Crash Recovery
• User Time log
• User Activity log

SAF/ Work order Module
• Online SAF entry
• Customized tariff package
• Time specific billing cycle
• Changeable Service Tax
• Payment/ approval check
• Work order generation
• Request forwarding to the concerned department
• DEMO INSTALLATIONS
• Billable
• Non-billable

Channel Activation Module
• Activation date entry
• Hardware details entry
• Channel details entry

Billing Module
• Due bills
• Bill generation
• Bill printing
• Bill reprinting

Payment Module
• Payment against bills

Waiver Module
• Waiver requisition
• Waiver authorization

Upgrade/ Downgrade Module
• Up gradation
• Down gradation
• New bill generation
• Automatic waiver generation

Channel Activation Module
• Activation date entry
• Hardware details entry

Debtor Aging Module
• Bill-wise
• Customer-wise

Disconnection Module
• Permanent disconnection
• Suspension (Temporary disconnection)

Access
Keeping in view the security concerns involved, the software provides for the facility to limit the access provided to the varied users of the system. The users are required to login using their user name and passwords and the software logs them into the system enabling them to access the relevant data screens assigned to them by the System Administrator. The various screens in this
• Login
• Logout
• Change Password

Master updation
• Client master
• Add
• Delete
• Modify
• Connection master
• Add
• Delete
• Modify

Revenue reports/ Projections
• Revenue projections
• Product wise
• Corporate wise
• Team leader wise
• Overall
• Executive wise

Sales Report
• Product wise
• Corporate wise
• Team leader wise
• Overall
• Executive wise

Outstanding reports
• Product wise
• Corporate wise
• Team leader wise
• Overall
• Executive wise

Amalgamation
• Collection report
• Customer ledger
• Pending installations
• Active connections