role of mis in bsnl telecommunications 2

8/12/2019 Role of Mis in Bsnl Telecommunications 2

1/21

DEPARTMENT OF COMMERCE AND MANAGEMENT STUDIES

CALICUT UNIVERSITY

FIRM VISIT REPORT ON RELIANCE COMMUNICATION LTD

Submitted to, submitted by,

Prof.Dr.P . Mohan Ranju. C

DCMS, Calicut University Snitha. N.V

2ndsem Mcom


2/21


3/21

It ranks among the top five telecommunications companies in the world bynumber of customers in a single country. Reliance Communicationscorporate clienteleincludes 2,100 Indian andmultinational corporations,and over 800 global, regional anddomestic carriers. The company established a pan-India, integrated (wireless andwireline), convergent (voice, data and video)digital networkthat is capable of supportingservices spanning the entire communications value chain, covering over 24,000 townsand 600,000 villages. Reliance Communications owns and operates theIP-enabledconnectivity infrastructure,[3]comprising over 190,000 kilometres offibre optic cablesystems in India, United States, Europe, Middle East, and the Asia .

Major subsidiaries

Reliance Telecommunication Limited

Subsidiary Reliance Telecommunication Limited (RTL) operates

inGujarat,Madhya Pradesh,West Bengal,Himachal Pradesh,Odisha,Bihar,Assam,and the northeast of India. It first offeredGSM services in January 2009.

Reliance Tech Services

Reliance Tech Services is the IT services wing of Reliance Anil Dhirubhai Ambanigroup. It provides IT consultancy, business process outsourcing and softwaredevelopment for Reliance Communications and other ADA group companies. Itprovides services to industry sectors such as telecommunications, financial services,utilities, entertainment, infrastructure, BPO operations and health care.

Reliance Globalcom

Reliance Globalcom owns theFiber-Optic Link Around the Globe undersea cablesystem, which spanned 65,000 km in 2006. Over 110,000 km of domestic optic-fibreconnects 40 markets in India, the Middle East, Asia, Europe, and the United States.

Reliance Internet Data Centre

RIDC provides Internetdata centre (IDC) services locatedinMumbai,Bangalore,Hyderabad andChennai.Spread across 650,000 sq ft(60,000 m2) of hosting space, it offers IT infrastructure management services to large,medium and small enterprises. It is one of the leading data-center service provider inIndia and provides services likecolocation,managed server hosting, virtual private

server and data security. It has launched cloud computing services, offering productunder its infrastructure as a server and software as a service portfolio, which enablesenterprises, mainly small and medium, a cost-effective IT infrastructure and applicationon pay-per-user model.

Reliance Digital TV
http://en.wikipedia.org/wiki/Corporationhttp://en.wikipedia.org/wiki/Multinational_corporationhttp://en.wikipedia.org/wiki/Wirelesshttp://en.wikipedia.org/wiki/Digital_electronicshttp://en.wikipedia.org/wiki/Internet_Protocolhttp://en.wikipedia.org/wiki/Reliance_Communications#cite_note-3http://en.wikipedia.org/wiki/Reliance_Communications#cite_note-3http://en.wikipedia.org/wiki/Reliance_Communications#cite_note-3http://en.wikipedia.org/wiki/Optical_fibrehttp://en.wikipedia.org/wiki/Gujarathttp://en.wikipedia.org/wiki/Madhya_Pradeshhttp://en.wikipedia.org/wiki/West_Bengalhttp://en.wikipedia.org/wiki/Himachal_Pradeshhttp://en.wikipedia.org/wiki/Odishahttp://en.wikipedia.org/wiki/Biharhttp://en.wikipedia.org/wiki/Assamhttp://en.wikipedia.org/wiki/GSMhttp://en.wikipedia.org/wiki/Fiber-Optic_Link_Around_the_Globehttp://en.wikipedia.org/wiki/Data_centrehttp://en.wikipedia.org/wiki/Mumbaihttp://en.wikipedia.org/wiki/Bangalorehttp://en.wikipedia.org/wiki/Hyderabad,_Indiahttp://en.wikipedia.org/wiki/Chennaihttp://en.wikipedia.org/wiki/Colocation_(business)http://en.wikipedia.org/wiki/Colocation_(business)http://en.wikipedia.org/wiki/Chennaihttp://en.wikipedia.org/wiki/Hyderabad,_Indiahttp://en.wikipedia.org/wiki/Bangalorehttp://en.wikipedia.org/wiki/Mumbaihttp://en.wikipedia.org/wiki/Data_centrehttp://en.wikipedia.org/wiki/Fiber-Optic_Link_Around_the_Globehttp://en.wikipedia.org/wiki/GSMhttp://en.wikipedia.org/wiki/Assamhttp://en.wikipedia.org/wiki/Biharhttp://en.wikipedia.org/wiki/Odishahttp://en.wikipedia.org/wiki/Himachal_Pradeshhttp://en.wikipedia.org/wiki/West_Bengalhttp://en.wikipedia.org/wiki/Madhya_Pradeshhttp://en.wikipedia.org/wiki/Gujarathttp://en.wikipedia.org/wiki/Optical_fibrehttp://en.wikipedia.org/wiki/Reliance_Communications#cite_note-3http://en.wikipedia.org/wiki/Internet_Protocolhttp://en.wikipedia.org/wiki/Digital_electronicshttp://en.wikipedia.org/wiki/Wirelesshttp://en.wikipedia.org/wiki/Multinational_corporationhttp://en.wikipedia.org/wiki/Corporation


4/21

Reliance Big TV launched in August 2008 and thereafter acquired 1 millionsubscribers within 90 days of launch,the fastest ramp-up ever achieved by any DTHoperator in the world. Reliance Big TV offers its 1.7 million customers DVD-qualitypictures on over 200 channels usingMPEG-4 technology.

According toCellular Operators Association of India (COAI) director-general

Rajan S. Mathews, Reliance Industries was expected to launch 4G services inDecember 2011.They were expected to useLTE technology. On 25 May 2012, RComannounced a price reduction of 61% on its 3G services.In 2011 Reliance provided up to28 Mb. its data rate in India with itsMIMO technology.On 31 January 2013, Relianceannounced its partnership withLenovo to market co-branded smart phones in India.Thesmart phones were said to use theAndroid operating system and have dual-coreprocessors.

Competitors

Reliance Communications competes with 14 other mobile operators throughoutIndia. They areAircel,Airtel,BSNL,Idea,Loop Mobile,MTNL,MTS,Ping Mobile,S

Tel,Tata DoCoMo,Tata Indicom,Uninor,Videocon,Virgin Mobile (GSM & CDMA)andVodafone.

ANALYSIS AND DISCUSSION

A management information system (MIS) provides information that

organizations require to manage themselves efficiently and effectively.[1]

Management

information systems are typically computer systems used for managing. The five

primary components: 1.)Hardware 2.)Software 3.) Data (information for decision

making),4.) Procedures (design,development and documentation), and 5.) People

(individuals, groups, or organizations).Management information systems are distinct

from otherinformation systems because they are used to analyze and facilitate strategic

and operational activities.

The Role of MIS From efficient data processing shops

to understanding the goals and objectives of an Organization

to participating directly in the decision making and strategy formulation

Knowledge Users: Users take on increased responsibility. Identify applications,and conduct systems analysis and design.

Better Applications: More specific, user friendly,functional, lower price, readilyavailable, and self training. Results: less need for programmers IShead count andbudget decrease as a result.
http://en.wikipedia.org/wiki/MPEG-4http://en.wikipedia.org/wiki/Cellular_Operators_Association_of_Indiahttp://en.wikipedia.org/wiki/3GPP_Long_Term_Evolutionhttp://en.wikipedia.org/wiki/MIMOhttp://en.wikipedia.org/wiki/Lenovohttp://en.wikipedia.org/wiki/Android_(operating_system)http://en.wikipedia.org/wiki/Aircelhttp://en.wikipedia.org/wiki/Airtel_(India)http://en.wikipedia.org/wiki/BSNLhttp://en.wikipedia.org/wiki/Idea_Cellularhttp://en.wikipedia.org/wiki/Loop_Mobile_Indiahttp://en.wikipedia.org/wiki/MTNLhttp://en.wikipedia.org/wiki/MTS_Indiahttp://en.wikipedia.org/w/index.php?title=Ping_Mobile&action=edit&redlink=1http://en.wikipedia.org/wiki/S_Telhttp://en.wikipedia.org/wiki/S_Telhttp://en.wikipedia.org/wiki/Tata_DoCoMohttp://en.wikipedia.org/wiki/Tata_Indicomhttp://en.wikipedia.org/wiki/Uninorhttp://en.wikipedia.org/wiki/Videocon_Telecommunications_Limitedhttp://en.wikipedia.org/wiki/Virgin_Mobile_Indiahttp://en.wikipedia.org/wiki/Vodafone_Indiahttp://en.wikipedia.org/wiki/Management_information_system#cite_note-1http://en.wikipedia.org/wiki/Management_information_system#cite_note-1http://en.wikipedia.org/wiki/Management_information_system#cite_note-1http://en.wikipedia.org/wiki/Information_systemhttp://en.wikipedia.org/wiki/Managementhttp://en.wikipedia.org/wiki/Information_systemhttp://en.wikipedia.org/wiki/Information_systemhttp://en.wikipedia.org/wiki/Managementhttp://en.wikipedia.org/wiki/Information_systemhttp://en.wikipedia.org/wiki/Management_information_system#cite_note-1http://en.wikipedia.org/wiki/Vodafone_Indiahttp://en.wikipedia.org/wiki/Virgin_Mobile_Indiahttp://en.wikipedia.org/wiki/Videocon_Telecommunications_Limitedhttp://en.wikipedia.org/wiki/Uninorhttp://en.wikipedia.org/wiki/Tata_Indicomhttp://en.wikipedia.org/wiki/Tata_DoCoMohttp://en.wikipedia.org/wiki/S_Telhttp://en.wikipedia.org/wiki/S_Telhttp://en.wikipedia.org/w/index.php?title=Ping_Mobile&action=edit&redlink=1http://en.wikipedia.org/wiki/MTS_Indiahttp://en.wikipedia.org/wiki/MTNLhttp://en.wikipedia.org/wiki/Loop_Mobile_Indiahttp://en.wikipedia.org/wiki/Idea_Cellularhttp://en.wikipedia.org/wiki/BSNLhttp://en.wikipedia.org/wiki/Airtel_(India)http://en.wikipedia.org/wiki/Aircelhttp://en.wikipedia.org/wiki/Android_(operating_system)http://en.wikipedia.org/wiki/Lenovohttp://en.wikipedia.org/wiki/MIMOhttp://en.wikipedia.org/wiki/3GPP_Long_Term_Evolutionhttp://en.wikipedia.org/wiki/Cellular_Operators_Association_of_Indiahttp://en.wikipedia.org/wiki/MPEG-4


5/21

Outsourcing: Other, external organizations taking over the management andcontrol of the data centers. It Results cost reductions, headcount reductions,Budget reductions etc..

Understand the business: products, markets &customers.

Establish credibility of the systems department:responsiveness to needs andrequests.

Increase the technological maturity of the organization: "Make it easier to takeadvantage of computer and telecommunications applications. Spend money, keepup with technology and applications.

The Evolving Systems Function1)APanel Discussion

The user has/will the IS power

The Guild system

An infrastructure for both central and de-central control

Leadership and direction

Guidance and coordination

2) Managing Risks IS projects are becoming more complex,widespread, and Expensive.

IS personnel are beings distributed- central systems, division systems and

functional systems.Thus, top management must assume responsibility.

They are more conservative, cautious, less knowledgeable

3) Building Relationships Because of costs- build external relationships with vendors, consultants, academics

Because of complexity- build internal relationships with senior management

Because of competition- build relationships with users- usability and satisfaction.

Reliance communication- Software Packages1.DOTSOFT

DOTSOFT is an in house developed integrated telecom database systemcomprising commercial, billing,accounting,fault repair service and directory inquiry

services .Dotsoft is integrated with other systems such as call centre, portal .


6/21

portal enables online bill payments and availability of duplicate bills for its customers.

In addition, Dotsoft, AP has a tie-up with e-seva, the most popular e-governanceproject of Andhra Pradesh government. it provides customers with a complete onlinedelivery, review and payment solution all at a single mouse click. It has beenconceptualized, designed and developed entirely by the core group of the Software

Development Center at Hyderabad of IT project Circle, Pune. Dotsoft is implemented inComputer Network in Client / Server mode. Now a days Central server concept is usedin Dotsoft wherein a single server will be available for 13 to 15 SSAa in a Circle eg.There is a Dotsoft server available at Nagpur,Aurangabad & Pune coveringMaharashtra Circle..

Important features /utility /advantage of dotsoftEvery subscriber is identified by a unique identification number calledUnique_Id_No

Bill generation is absolutely easy and totally secure.

Payments are faster and completely hassle free for the customer and the counter

personnel because of the use of bill scanners.

Online inquiry is available for supervision and queries .

Complete history of subscribers activities available online.

Directory Inquiry shows the status at the moment of inquiry. It can query on any of the

subscribers details in part or in full.

Outstanding details can be taken for any month on any given date.

Complete managerial supervision is possible about the activities happening anywhere

in the district/Circle.

Database security is implemented

System is highly salable and can run on many operating system platforms

All the parameters of the system are table driven .

2.FAULT REPAIR SERVICE FRS)Need of FRS System

The maintenance of Line and Wires and subscribers apparatus consists of two

parts.

i)clearance of faults reported by Subscribers on day to day basis.

ii)Preventive maintenance of the lines to reduce incidents of faults and thereby thecomplaints.

FRS system is needed control over the clearance of faults reported by the subscribers.


7/21

3.DIRECTORY INQUIRYNeed of DQ

Directory Inquiry system is needed to find out the Phone number of particularcustomer from available details such as Name, Surname, Location etc & Vice Versa.

Directory Inquiry (DQ) system are generally Directory assistance systemsincorporated on a wide range of automation to reduce the load of human operators.

Almost all systems use custom database software to locate listings quickly. Mostdirectory assistance systems use automated read back systems to give out the phonenumber. This frees the directory assistance operator to move on to another caller assoon as the correct listing is located.

Directory Inquiry related master in DOTSOFT

ISD Code Master

STD Code MasterAll other Customer related data is used by DQ Module from Commercial Module

Tables available in Dotsoft.

4.BCCSBCCS is a Billing and Customer Care System(BCCS) for Mobile Billing .

BCCS Technical Details ;

Front end-JAVA

Database-Oracle 8i

Operating System-Sun Solaris Unix.

Language- C, C++, JAVA, JAVA Script

BCCS Salient features

The Billing and Customer Care Subsystem [BCCS] of Reliance has beensourced from CSG Systems, and is referred to as the Kenan BP/OM or Arbor. This is apowerful platform for billing and customer care, and can be configured to suitorganizational and customer needs. This application is client-server based where thedata or information is contained in one or more centralized database on servers and the

user interfaces reside in the workstation. The application can be used in a local areanetwork (LAN) environment or WAN Network.

5.ARBOR/OM INTERFACE

An order Management System supports order handling.

It supports work flow management activities for products and services and also to

manage number and equipment inventories


8/21

It is used in tandem with arbor/BP.

Every order is associated with a master Account.

Master Account may be an existing account from BP as a new or pending account

in OM.

An order consists of one or more items.

You can view history information of order & revised order can be issued

A single order can contain any combination of new, modified or disconnected

service.

Examples of order

a.Create new Accounts

b.Add products & services

c.Change products & services.

d.Discontinue products or services.

Role of ARBOR/OM interfaceCollects CDRs from various NEs

Filters the CDRs (Allowing all & only billable CDRs to the Billing System)

Formats the CDRs as required by the Billing System

Can store CDRs for a certain time period

6. BILL PROCESSING SYSTEMCalculate customer balances based on charges and credits (e.g. service charges,

monthly fees, usage charges, taxes, late fees, adjustments, discounts and

payments).

Arrange charges and credits on formatted customer bills.

Dispatch customer bills.

7.INVENTORY MANAGEMENT PACKAGE

Inventory Management Package is a web-based application, which Work in

Client server model .

Client - A remote computer accessing Server through dial up/leased line.

Server- A high end server and associated servers Located in Trivandrum.

.Oracle 9i as the back-end database.


9/21

Use of Inventory Management involvesProject Planning

Purchase order management

Indenting and allotment at SSA/Field level

Receipt of stores at Circle / SSA stores

Checking the material for quality and taking into stock

Issue of stores from Circle/SSA stores.

Purchase Billing

Inventory Management Package

Salient Features

Web enabled multi-user application. User-friendly data entry forms.

Various queries/reports for master data from Admin/Circle/SSA levels.

User-role based access.

System log out on expiry of session ensuring security.

Forced log out by user ensuring security.

Forced change of password on first log in.

Data validation all over the circle since it resides on a single server.

Multiple roles can be assigned to a single user.

This system is designed for planning/accounting of Materials in BSNL up to

field units thereby bringing uniformity in Material Management.

This system is designed to start operation from the Circle tier.

8. Customer support software

The never-ending technological developments combined with cut-throatcompetition have made the Industry more competitive than ever. Telecom industry is

customer driven and hence being customer-responsive is an important trait for successin this industry. To be customer focused and to be upfront in the interactions with thecustomer, the primary need is a tool that empowers the customer facing staff withaccurate information at the click of a button..

Email and Phone are the two main ways the customer support is approached inTelecom Industry. Customers expect faster response times, one call resolution and


10/21

better user experience. Support Center Plus with its strong email responsemanagement system, intuitive Knowledge Base, unique Self-Service Portal andcomputer telephony integration can help a telecom company to provide top-notchcustomer support to its customers.

features

E-mail response management

Multi channel communication

Knowledge base and solution.

Self service portal

Remote control

Account and contact management

Benefits

Affordable, easy to use and quick implementation. No need of any installation inthe client's place as the Support Portal can be accessed through web.

Customize Self Service Portal for clients and the respective contacts according toyour needs

Increase support efficiency by reducing repetitive queries and high volume oftickets and calls

Organize and integrate computer telephony with your Customer Support in orderto provide better user experience with your call center and customer support.

Keep the clients and their staff informed with latest information.

Create performance and efficiency reports of your customer support staff.Manage your resources effectively

24 X 7 support for your clients.

9. Sales force management system

Sales force management systems areinformation systems used in CRMmarketing

andmanagement that help automate somesales andsales force management

functions. They are often combined with amarketing information system,in which casethey are often calledcustomer relationship management (CRM) systems.

Sales force management systems are essentially the same thing as sales force

automation system(SFA).

A SFA, typically a part of a companyscustomer relationship management system,

is a system that automatically records all the stages in a sales process. SFA includes a
http://en.wikipedia.org/wiki/Information_systemshttp://en.wikipedia.org/wiki/Marketinghttp://en.wikipedia.org/wiki/Managementhttp://en.wikipedia.org/wiki/Saleshttp://en.wikipedia.org/wiki/Sales_force_managementhttp://en.wikipedia.org/wiki/Marketing_information_systemhttp://en.wikipedia.org/wiki/Customer_relationship_managementhttp://en.wikipedia.org/wiki/Customer_relationship_managementhttp://en.wikipedia.org/wiki/Customer_relationship_managementhttp://en.wikipedia.org/wiki/Customer_relationship_managementhttp://en.wikipedia.org/wiki/Customer_relationship_managementhttp://en.wikipedia.org/wiki/Marketing_information_systemhttp://en.wikipedia.org/wiki/Sales_force_managementhttp://en.wikipedia.org/wiki/Saleshttp://en.wikipedia.org/wiki/Managementhttp://en.wikipedia.org/wiki/Marketinghttp://en.wikipedia.org/wiki/Information_systems


11/21

contact management system which tracks all contact that has been made with a given

customer, the purpose of the contact, and any follow up that may be needed. This

ensures that sales efforts are not duplicated, reducing the risk of irritating customers.

SFA also includes asales lead tracking system,which lists potential customers through

paid phone lists, or customers of related products. Other elements of an SFA systemcan includesales forecasting,order management andproduct knowledge.More

developed SFA systems have features where customers can actually model the product

to meet their needs through online product building systems. This is becoming more

and more popular in the automobile industry, where patrons can customize various

features such as color and interior features such as leather vs. upholstered seats.

An integral part of any SFA system is company wide integration among different

departments. If SFA systems arent adopted and properly integrated to all departments,

there might be a lack of communication which could result in different departments

contacting the same customer for the same purpose. In order to mitigate this risk, SFAmust be fully integrated in all departments that deal with customer service management.

Making a dynamic sales force links strategy and operational actions that can take place

within a department. the SFA relies on objectives, plans, budget, and control indicators

under specific conditions. In order to perform the objectives correctly, specific

procedures must be implemented:

10. Automation software

Automation Anywhere Standard is automation software that gives you the power toclaim back hours in your workday. The software captures and executes your most time-consuming, repetitive tasks with flawless precision, leveraging built-in technology thatrecords keyboard and mouse actions as you perform a task. Capture, edit, and rapidlyreplicate a wide variety of tasks and processes that would otherwise slow you down and do it without any lengthy infrastructure code or scripting.

Automation provides means of staying competitive by automating simple and complextasks across applications. Users realize a quick ROI by saving both time and costs,increase business and IT process reliability and speed while reducing the possibility ofhuman error.

DatabaseA database is an organized collection ofdata.The data are typically organized to

model relevant aspects of reality in a way that supports processes requiring this

information. For example, modelling the availability of rooms in hotels in a way that

supports finding a hotel with vacancies.
http://en.wikipedia.org/wiki/Contact_management_systemhttp://en.wikipedia.org/w/index.php?title=Sales_lead_tracking_system&action=edit&redlink=1http://en.wikipedia.org/wiki/Sales_forecastinghttp://en.wikipedia.org/wiki/Order_managementhttp://en.wikipedia.org/w/index.php?title=Product_knowledge&action=edit&redlink=1http://en.wikipedia.org/wiki/Data_(computing)http://en.wikipedia.org/wiki/Data_(computing)http://en.wikipedia.org/w/index.php?title=Product_knowledge&action=edit&redlink=1http://en.wikipedia.org/wiki/Order_managementhttp://en.wikipedia.org/wiki/Sales_forecastinghttp://en.wikipedia.org/w/index.php?title=Sales_lead_tracking_system&action=edit&redlink=1http://en.wikipedia.org/wiki/Contact_management_system


12/21

Database management systems (DBMSs) are specially designed software

applications that interact with the user, other applications, and the database itself to

capture and analyze data. A general-purpose DBMS is asoftware system designed to

allow the definition, creation, querying, update, and administration of databases. Well-

known DBMSs includeMySQL,MariaDB,PostgreSQL,SQLite,Microsoft SQL Server,Microsoft Access,Oracle,SAP HANA,dBASE,FoxPro,IBM DB2,LibreOffice Base,

FileMaker Pro andInterSystems Cach.A database is not generallyportable across

different DBMSs, but different DBMSs can interoperate by usingstandards such asSQL

andODBC orJDBC to allow a single application to work with more than one database.

Purpose of database

A DBMS has evolved into a complex software system and its development typically

requires thousands of person-years of development effort.[4]Some general-purpose

DBMSs such asAdabas,Oracle and DB2 have been undergoing upgrades since the

1970s. General-purpose DBMSs aim to meet the needs of as many applications as

possible, which adds to the complexity. However, the fact that their development cost

can be spread over a large number of users means that they are often the most cost-

effective approach. However, a general-purpose DBMS is not always the optimal

solution: in some cases a general-purpose DBMS may introduce unnecessary

overhead. Therefore, there are many examples of systems that use special-purpose

databases. A common example is anemail system: email systems are designed to

optimize the handling of email messages, and do not need significant portions of a

general-purpose DBMS functionality.

Many databases haveapplication software that accesses the database on behalf of

end-users, without exposing the DBMS interface directly. Application programmers may

use awire protocol directly, or more likely through anapplication programming

interface.Database designers and database administrators interact with the DBMS

through dedicated interfaces to build and maintain the applications' databases, and thus

need some more knowledge and understanding about how DBMSs operate and the

DBMSs' external interfaces and tuning parameters.

Network in Reliance communicationLAN( Local Area Network)

A local area network (LAN) is acomputer network that interconnects computers within

a limited area such as a home, school, computer laboratory, or office building, using

network media.[1]The defining characteristics of LANs, in contrast towide area networks
http://en.wikipedia.org/wiki/Computer_softwarehttp://en.wikipedia.org/wiki/MySQLhttp://en.wikipedia.org/wiki/MariaDBhttp://en.wikipedia.org/wiki/PostgreSQLhttp://en.wikipedia.org/wiki/SQLitehttp://en.wikipedia.org/wiki/Microsoft_SQL_Serverhttp://en.wikipedia.org/wiki/Microsoft_Accesshttp://en.wikipedia.org/wiki/Oracle_Databasehttp://en.wikipedia.org/wiki/SAP_HANAhttp://en.wikipedia.org/wiki/DBASEhttp://en.wikipedia.org/wiki/FoxProhttp://en.wikipedia.org/wiki/IBM_DB2http://en.wikipedia.org/wiki/LibreOffice_Basehttp://en.wikipedia.org/wiki/FilemakerProhttp://en.wikipedia.org/wiki/InterSystems_Cachehttp://en.wikipedia.org/wiki/Software_portabilityhttp://en.wikipedia.org/wiki/Technical_standardhttp://en.wikipedia.org/wiki/SQLhttp://en.wikipedia.org/wiki/ODBChttp://en.wikipedia.org/wiki/JDBChttp://en.wikipedia.org/wiki/Database#cite_note-4http://en.wikipedia.org/wiki/Database#cite_note-4http://en.wikipedia.org/wiki/Database#cite_note-4http://en.wikipedia.org/wiki/Adabashttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Emailhttp://en.wikipedia.org/wiki/Application_softwarehttp://en.wikipedia.org/wiki/Wire_protocolhttp://en.wikipedia.org/wiki/Application_programming_interfacehttp://en.wikipedia.org/wiki/Application_programming_interfacehttp://en.wikipedia.org/wiki/Computer_networkhttp://en.wikipedia.org/wiki/Local_area_network#cite_note-1http://en.wikipedia.org/wiki/Local_area_network#cite_note-1http://en.wikipedia.org/wiki/Local_area_network#cite_note-1http://en.wikipedia.org/wiki/Wide_area_networkhttp://en.wikipedia.org/wiki/Wide_area_networkhttp://en.wikipedia.org/wiki/Local_area_network#cite_note-1http://en.wikipedia.org/wiki/Computer_networkhttp://en.wikipedia.org/wiki/Application_programming_interfacehttp://en.wikipedia.org/wiki/Application_programming_interfacehttp://en.wikipedia.org/wiki/Wire_protocolhttp://en.wikipedia.org/wiki/Application_softwarehttp://en.wikipedia.org/wiki/Emailhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Adabashttp://en.wikipedia.org/wiki/Database#cite_note-4http://en.wikipedia.org/wiki/JDBChttp://en.wikipedia.org/wiki/ODBChttp://en.wikipedia.org/wiki/SQLhttp://en.wikipedia.org/wiki/Technical_standardhttp://en.wikipedia.org/wiki/Software_portabilityhttp://en.wikipedia.org/wiki/InterSystems_Cachehttp://en.wikipedia.org/wiki/FilemakerProhttp://en.wikipedia.org/wiki/LibreOffice_Basehttp://en.wikipedia.org/wiki/IBM_DB2http://en.wikipedia.org/wiki/FoxProhttp://en.wikipedia.org/wiki/DBASEhttp://en.wikipedia.org/wiki/SAP_HANAhttp://en.wikipedia.org/wiki/Oracle_Databasehttp://en.wikipedia.org/wiki/Microsoft_Accesshttp://en.wikipedia.org/wiki/Microsoft_SQL_Serverhttp://en.wikipedia.org/wiki/SQLitehttp://en.wikipedia.org/wiki/PostgreSQLhttp://en.wikipedia.org/wiki/MariaDBhttp://en.wikipedia.org/wiki/MySQLhttp://en.wikipedia.org/wiki/Computer_software


13/21

(WANs), include their smaller geographic area, and non-inclusion ofleased

telecommunication lines.

ARCNET,Token Ring and other technology standards have been used in the past, but

Ethernet overtwisted pair cabling, andWi-Fi are the two most common technologies

currently used to build LANs.

MIS-Management Information System

In Management Information System , HTML is used for front-end screen design.

ASP used for necessary logic for submitting/updating/modifying the Data.

Java script is used for data validation at client side.

Database is implemented in Oracle Management Information System Salient Features

It has more than 30 input forms for submitting Management Information. Systemdata/report as per new format of reliance communication HQ Basic MOC and then MISdata is keyed by SSA level users and data is stored at central database server.For theidentical fields in MOC & MIS, once entered in MOC, same fields data entryautomatically updated in MIS . Application generates MOC & MIS reports dynamicallybased on SSA, Month and Year of selection. MIS deals with preparation of templatesand maintaining uniform and standardized formats for various circles. The application isWeb-based and field units from anywhere in the reliance network can access thesystem located at Trivandrum through Internet. User-friendly interfaces are provided for

entering data and any report as per requirement can be generated. The applicationfollows three-tier architecture for Reliance communication, Circles and SSAsrespectively.

Management Information System Concepts used Package is a Web based

application having the two-layer Architecture (2 Layers). Layer one encompasses

Business logic along with the input forms and the next layer includes Database server.

These two layers can be accommodated in a single machine or on separate machines.

It has 40 input forms for submitting Management Information System data as per the

new format of reliance HQ. The basic MIS data is keyed by SSA level users and data is

stored at central database server. In a single window concept, user can input the dataand obtain the respective output report. MIS Reports are developed in VB 6.0 using

DLLs to enhance the speed and performance of report generation.

Management Information System Menus

Admin
http://en.wikipedia.org/wiki/Leased_linehttp://en.wikipedia.org/wiki/Leased_linehttp://en.wikipedia.org/wiki/ARCNEThttp://en.wikipedia.org/wiki/Token_Ringhttp://en.wikipedia.org/wiki/Ethernethttp://en.wikipedia.org/wiki/Twisted_pairhttp://en.wikipedia.org/wiki/Wi-Fihttp://en.wikipedia.org/wiki/Wi-Fihttp://en.wikipedia.org/wiki/Twisted_pairhttp://en.wikipedia.org/wiki/Ethernethttp://en.wikipedia.org/wiki/Token_Ringhttp://en.wikipedia.org/wiki/ARCNEThttp://en.wikipedia.org/wiki/Leased_linehttp://en.wikipedia.org/wiki/Leased_line


14/21

OTE (One Time Entry)

MOC (24 point reports)

QPI (Qualitative Performance Indicator)

DP (Development Performance)

U/P (Rehabilitation /Up gradation)

HRD (Human Resource & Development)

FP (Financial Performance)

BD & MKTG

MIS report is available at the following levels:

Management Information System Reports

FormLevel Report

Module Level Report

SSA Level Report

Circle Level Report

Management Information system Separate input forms are available for inputtingone time data (Closing status for previous year ending) for DP, HRD, UP (Circle/SSA

Administrators are only permitted to input this data) It is a two stage process.

In first stage data flow is from SSAs into central data store. In the next stage data isprocessed based on the selected SSA/Circle/ Reliance HQ, Month and Year forgenerating the Reports.Before storing the data (inputted by end users) into database,

package takes care of validation and correctness of the data, as it is required forgeneration of correct MIS report.

End users (SSA level) inputted data is stored in tables and are maintained Reportwise like. QPI, DP, UP, HRD etc., in a single MIS Database. Each SSA Data is storedin the database uniquely. Each row is identified with the Circle name, SSA name, monthand year. For avoiding data duplication and maintaining data consistency normalizationtechniques are used. The basic data used for generating the MIS Report at all levels


15/21

and is strictly adhering to the format of MIS supplied by reliance HQ. Completion statusof Form can be viewed and modified by Module Level users. Module can be viewed andmodified by SSA Level Administrators and viewed by users at SSA. All the Modules ofall SSAs of a Circle can be viewed by respective Circle Administrator and Users atCircle. All the reports SSAs and Circles can be viewed by Administrator and Users at

HQ. Application generates MIS reports dynamically based on SSA, Month and Year ofselection.

MIS FOR INTELLIGENT NETWORK SERVICESMIS FOR INTELLIGENT NETWORK SERVICES USES

MIS on IN Services is a web based software application. It is SoftwareDesigned and Developed by O/o CGM, IT Project Circle.Software enables to User tofeed MIS data on IN services for ITC cards (50, 100, 200, 500, 1000, 2000, and 5000)

and other services (ACC, FPH, UAN, VPN, UAN, PRM, VOT) for every month atCity/SSA/Circle level and final consolidation at Corporate Office. This has four levelshaving two types of users at each leveladmin user and common user, except Citylevel user.

The users of application will have unique user name and passwords.Transaction

data for different services will be maintained at city level for each SSA on monthly basis.Start up data entry at city level will be onetime and compulsory.

MIS FOR INTELLIGENT NETWORK SERVICES

The IN software has (a) HTML as front end, (b) JavaScript for client sidevalidation, (c) PHP for server side scripting, (d) oracle-9i as database and (e) Linux asoperating system. This software application is hosted at reliance Intranet server locatedat Trivandrum. Minimum requirement for user side machine is that it should havePentium-II or better configurations with 64 MB RAM and any jvm enabled Web browserlike Internet Explorer 5.0 and above. Access to Application The user can access theapplication through internet .

MIS FOR INTELLIGENT NETWORK SERVICES users

The details of functional Users of this application are:

(1) City User (2) SSA Admin (3) SSA User (4) Head Of SSA (5) Circle Admin

(6) Circle User (7) reliance HQ Admin and (8) Reliance HQ User


16/21

DCR Billing PackageCDR Based Convergent Billing and Customer Care system.CDR based

convergent billing and customer care system. is Under Implementation stage inReliance.This is an biggest project taken by any TSP(Telecom service provider) in

India. This project is going to replace all the existing systems of Commercial, TRA(Telecom Revenue Accounting), FRS (Fault Repair Service) and DQ (DirectoryEnquiry). The project will cover the customer care and billing for the following services:

1. Landline

2. Broadband

3. CDMA

The project is not simply a replacement of the existing systems, but it is much

more than that. For the first time in the history of reliance, we are going to have State-of-the-Art Customer Relationship Management (CRM) software. This software will takecare of all types of requests from the customers and integrate with other systems suchas Order Management and Billing systems.

This software will also provide a Web Self Care (WSC) module which willenable customers to access the system through Internet for placing any request, formaking payments, or for general enquiry.

CONVERGENT BIILING advantagesThis project shall implement a convergent billing system, which enables us to issue a

single bill for a customer taking any type of service from Reliance..

The electronic stapling software shall be implemented in all the four zones.

A customer having presence only in a particular zone, spanning across SSAs and

Circles, can have a single bill for all the services he takes from Reliance whether the billfor the particular service is prepared or not from this system.

The electronic stapling software installed at Hyderabad, shall take care of Corporatecustomers having All India presence.

This system will have interfaces with other zonal billing systems, GSM billing systemsand the NIB billing system.

With these interfaces, it is possible to issue a single bill to a Corporate customer


17/21

having All India presence.

The system is also capable of taking the payments against this single bill and then

distributing the payments back to the original billing systems of the different

services taken by the customer for proper accounting.

This is one of the biggest advantages of this project.

The system will also help us introduce Combo Plans, offering flexible tariff plans

to customers availing Land line, Broadband and GSM services.

HR PackageWhy HR Package for Reliance communications.

Centralized Employee Information System

Better and Efficient Services to Employee

Transparency in HR Matters

Effective Utilization of HR Resource

Proper Accounting of Expenditure on HR

Step Towards Paperless Office

Long Term HR Policy

HR Package FeaturesWeb based on-line application.

Complete and comprehensive solution for Human Resource management of Reliancecommunications..

User-friendly design.

Integrated with Payroll.


18/21

Caters to the complete employee life cycle, from recruitment to retirement.

Role based user participation.

Centralized, secured database.

Access to every employees.

On-line flexible reports for management.

HR Package Technology

Operating System

Linux Enterprise Server.

Application Server

Oracle 10gApp Server

Database

Oracle 10g

Front end coding

J2EE.

HR Package Client System Requirement

Pentium III with 128 Mb RAM & above Configuration

System should have IE 5.0 & above

System should installed Acrobat reader 5.0 & above Pop up Blocker should be disabled

Yahoo Toolbar shouldnt be installed

ERP

Enterprise -Is an entity where Business Activities are conducted profitably

Resource-Various Resources available within an enterprise such as, Finance, Materials,

Manpower, Equipment, Facilities and infrastructure etc. .

Planning-Activity to optimize the utilization of resources.

ERP BASIC What is ERP?

ERP stands for Enterprise Resource Planning. It is packaged software designedfor client/server architecture. It integrates the majority of business process andtransactions. It allows integration between process and planning and supports multiplecurrencies, languages, etc. It can be customized without programming. It ensuresdiscipline in working of entire organization by ensuring no data gets posted without


19/21

fulfilling all laid down business rules. ERP attempts to integrate all departments andfunctions of a company into a single system that can serve all departments' needs.Anextensive change management concept ensures the acceptance and motivation of theend users.

Enterprise Resource Planning (ERP) is a term usually used in conjunction with

ERP software or an ERP system which is intended to manage all the information andfunctions of a business or company from shared data stores. An ERP system typicallyhas modular hardware and software units and "services" that communicate on a localarea network or on Intranets . The modular design allows a business to add orreconfigure modules (perhaps from different vendors) while preserving data integrity inone shared database that may be centralized or distributed .

Area of Computerization in an Organization

Financial Activities

Material Management and its procurement

Sales and Marketing

Quality Management and assurance

Human Resource Development

Payroll

Training Management

Business Intelligent Warehousing

Project Planning and Monitoring

System Maintenance

ERP Functional Scope Modules

Financial and controlling (FICO)

Material Management (MM)

Project Systems (PS)

Plant Maintenance (PM)

Sales and Distribution (S&D)

Quality Management (QM) Human Resource and Payroll (HR)

Business Intelligent Warehousing (BIW)

Reliance communications Present Status of computerization activities

Financial activities Present Status


20/21

DotSOFT Package

In house developed packages for computation and preparation of financial

statements

Other locally developed software

Material Management and Procurement Present Status

Inventory Management system

MIS for IN Service Web package

Other locally developed software .

Advantages of ERP

Integrate financial information

Integrate customer order information

Standardize and speed up manufacturing processes

Reduce inventory

Standardize HR information

Some security features are included within an ERP system to protect against both

outsider crime and internal control

ERP Systems centralize the data in one place. Benefits of this include:

Eliminates the problem of synchronizing changes between multiple systems Permits control of business processes that cross functional boundaries

Provides top-down view of the enterprise (no "islands of information")

Reduces the risk of loss of sensitive data by consolidating multiple permissions

and security models into a single structure.

Problems with ERP

Some large organizations may have multiple departments with separate,

independent resources, missions, chains-of-command, etc, and consolidation into

a single enterprise may yield limited benefits.

Resistance in sharing sensitive internal information between departments can

reduce the effectiveness of the software.

The blurring of company boundaries can cause problems in accountability, lines

of responsibility, and employee morale.


21/21

Once a system is established, switching costs are very high for any one of the

partners (reducing flexibility and strategic control at the corporate level).

Many of the integrated links need high accuracy in other applications to work

effectively.

ERP systems can be very expensive

Re-engineering of business processes to fit the "industry standard" prescribed by

the ERP system may lead to a loss of competitive advantages.

SUMMARY AND SUGGESSIONS

SUMMARY

In Reliance communication MIS helps to increasing the efficiency of dataprocessing . It directly participating in the decision making and strategy formulation. MISestablish credibility of the systems department: responsiveness to needs and requests.MIS Increase the technological maturity of the organization: "Make it easier to takeadvantage of computer and telecommunications applications. Spend money, keep upwith technology and applications. In Reliance communications MIS has a great role inday to day operations. They benefited financially and non financially by use of computerand other MIS settings. By adopting modern softwares they could reduce time taken todo various activities.

SUGGESSIONS We suggest that it is better to use more and more newly advanced softwares.

Majority of customers complains about the after sale service, like billing andinterruption in the network. So the quality of the after sale services should beimproved.

Device installation and registration on site should be easier to work. So thecustomers need not to give more papers at the time of purchasing new connection.

Company should move towards the good customer relation. So company shouldplan for customer relationship management.

REFERENCES

1.WWW.GOOGLE.COM

2.WWW.WIKIPEDIA.COM

3.RELIANCE COMMUNICATION LTD
http://www.google.com/http://www.google.com/http://www.google.com/http://www.wikipidia/http://www.wikipidia/http://www.wikipidia/http://www.wikipidia/http://www.google.com/

role of mis in bsnl telecommunications 2

Documents