mobile managment ....

This project is aimed to automate the operations of Mobile Service Providers. Customers/Company representatives logging in may also access/search any information of mobile related services.

This ambitious service uses state-of-the-art technology to attain global excellence and leadership in business. Our entry into this sector has brought mobile service at an affordable cost to the common man. All serving a single objective, to provide better communication to millions across India.

This Customer service leads to have a good response for services and it can make users enroll as customers within months of launch this service.

Existing system:

The Existing system is a computerized system contains all the details of the mobile services providers are maintained in the individual databases. If customer wants the information they must keep a request to the admin authority and get the information. It’s a time delay process. And maintaining all the records in Excel sheets and paradox, clipper. If they want any record they have to search all the records. The whole process is now manually controlled. This requires maintaining the records of the queries coming from the corporate in the paper.

Limitations in Existing System:

Maintaining the data in excel sheets and files is very hard to remember the file names in which the required data is feed. No easy access to the required queries. Data redundancy, inconsistency, lot of human work need to be done in order analyze the details present in the excel sheets. It leads to wastage of time.

1.3 Proposed System:

The Proposed system is a browser which is completely related to internet browsing. The web enabled information management system designed to automate the entire operations of a modern technology. Mobile Service Provider and Operational Portal allow multi-divisional, multi-department system handling that includes various Services.

Services:

News & Updates

Call Management Services

Astrology

Entertainment

Sports

Travel

Advantages over Existing System:

1.      This system provides a Common User Interface for the system to log on to the system.

2.      Here the user interface is Graphical User Interface.

3.      This application is a Web based Application.

4.      Being a web based application it doesn’t require any client side installation.

5.      Any number of users can interact with the system simultaneously.

       Hardware Requirement:

The Hardware Interfaces for this system are:

    Processor                                               :           Pentium IV

    Hard Disk                                             :           40GB

    RAM                                                     :           256MB

  Software specification:

             Database     : MySQL 5.0, MySQL 3.5 JDBC driver

             Server         : Apache Tomcat 4.1

             Front end   :  JSP / Servlets, J2SDK 1.4, HTML, DHTML, Java Script

             Editor         :  Edit plus

Addition Modification and Replacement Scheme System

                                         

                                          The procedure is applicable to invest proposals for Additions, Modifications and Replacements (AMR) involving an expenditure of more than Rs.10 lakhs and upto Rs.25 crores. An AMR scheme can be any one or combination of Addition, Modification and Replacement.

1. ADDITION:

      Adding to the existing facility for

• Improvement of production / productivity.

• Improvement of quality of products.

• Introduction of new product.

• Cost reduction/ Energy savings/ Environmental control.

2. MODIFICATION:

 Improving or revamping of existing facility for Reducing cost of materials/labour/power / energy.

Improvement quality of products / services/ safety.

Balancing/ de-bottlenecking of production processes.

Better pollution control.

3. REPLACEMENT:

Replacing the existing machines with better performance machines.

OBJECTIVE:

Automation of AMR Schemes is to eliminate heavy load paper work by

Converting it into web based computer process.

This web-based application is completely client - server oriented for processing Investment proposals of AMR jobs and for monitoring effective implementation.

Current System

  Paper Based Work: - The existing system is completely paper based. So  this system needs lots of man power .

Time Consuming: - As this system needs lots of manpower and as papers will be moving from one department to another manually, lots of time is consumed. So time constraints maintenance is very difficult.

Less Security: - As these records move from department to department      the security provided to the data is very less. As this is manually done the data cannot be very accurate. Even there can be chance that intermediate person can leak the proposals.

Proposals cannot be placed round the clock: - As this is entirely manual work the regarding official should be available round the clock but practically this is not possible so there will be delays in the placing of proposal.

Updating of database is done only after approval or proposal: - As this is a manual process only after the proposal is completed the database is updated with all the details.

Progress of proposal not known instantaneously: - In this process as the database is not updated time 10 time, the progress of the proposal is hard to know and 10 get details instantaneously can be forgotten.

Problems with the Current System:

a)      It is more time consuming.

b)      It includes wastage of man power

c)      It leads to tender ring

d)     It includes wastage of money

So in order to overcome all these limitations and to meet all their requirements the    current process is replaced with this application.

Purpose:

            The purpose of this document is to display all the external requirements for the “Addition Modification and Replacement System”.  The main objective of preparing this document is to give a   detailed description   of   the   analysis   and requirements for the system to be automated and this will be a guide in the other phase.

             The purpose of “Addition Modification and Replacement System” to provide the traditional proposal process in an electronic form, using the Internet. Using ARM The Departments can publish the proposals and users submit the tenders then finally the departments evaluate the proposals.

Scope:

             This document is one that describes the requirements of the system. The department people mean it for use and Suppliers will be the basis for   this system. The department people responsible for publish &evaluation of proposal for required items. The suppliers are responsible for downloading &submission of tenders.

 PROPOSED SYSTEM:

            In this we discuss about the proposed Addition Modification and Replacement system.

General Description Of Inputs & Outputs:

                                                            The system will be getting input from the departments from various locations. The output also given by the departments depending on input given by the suppliers.

Fully Automated System: - Our proposed system is an automated format of the above Slated paper based work. Here the entire process is computerized thus by reducing the man power and the entire manual work.

Fast and Accurate: - As this is automated system and fully computerized    so it is far more fast and accurate than manual work.

Data security: - In our system the data is updated in database time 10 time and data is nor sent via any paper work so data is secured as only the administrator has the access to the database and no one else can modify the database,

Availability of system round the clock: - As this is an automated system, system is available all the time, so no need for the official availability so no delay in work. The process continues automatically does not need to wait for anyone to keep the proposal.

Continuous updating of database: -

  

           Database is updated from time to time after each effect on the proposal. So data is more accurate and perfect as all the updations are done simultaneously as the process.

Instantaneous retrieval of data: -

          

            As the database is update from time to time the data can he retrieved at any time.

Generation of reports for decision-making: -

          

            In our project we generate reports so that the higher officials can know the progress of the proposal placed and thus by also take the important decisions regarding the proposal handling.

The modules in this application are:

Administrator
Department
Purchase department

ISPC

Director Operations

CSD
Supplier

Administrator:
 This administrator will maintain all the master information like Items Information, suppliers’ information, and Department information.

Department:
He is going to prepare the indent for the required product to the purchase department, and also he checks indent status.

ISPC:

He checks the proposal information and it will be clear then he accept that proposal otherwise reject it. If he accept that proposal then it forward to Director Operation for his acceptance. Otherwise it will be closed.

Director Operation:

He checks the proposal information and it will be clear the he accept that proposal otherwise reject it. If he accept that proposal then it forward to the Purchase department to prepare Invitation for that proposed items. Otherwise it will be closed.

Purchase department:
Displaying indents information from different departments. Preparation of Invitations for the Proposed items, Invitation to the supplier for the proposal.

Supplier:
Supplier is going to bid the amount for proposal with in the stipulated time, and will know the final status of the tender once it is closed if it allot to him.

HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS                              

PROCESSOR    :        Intel 2.0 GHz or above

HARD DISK     :        80 GB

RAM                     :    512 MB RAM.

   SOFTWARE REQUIREMENTS

OPERATING SYSTEM                   : WINDOWS XP with SP2. 

LANGUAGE (FRONT END)   : JAVA (JDK1.5/1.6)

SERVER                                     : APACHE TOMCAT 5.5/6.0

WEB TECHNOLOGY              : HTML, JAVASCRIPT, CSS.

DATABASE (BACK END)        : ORACLE 10G.

ARCHITECTURE                      : 3-TIER ARCHITECTURE.

Airtel Prepaid

The main intention of introducing this system is to reduce the manual work at Airtel Prepaid Office. Every sort of task is performed by the system, such as storing the subscriber, outlets details to reducing much paper work and burden of the file storage and calculating the credit and profit reports in easier manner.

This project is entitled with “Automation of Airtel prepaid distribution Accounts Management” is to make more user friendliness to the Operators who are manipulating the Respective operations in the firm.

     The objectives of the project are:

1.                  Manipulating the Sale Transactions,

2.                  Maintaining the subscriber, outlet details,

3.                  Maintaining the daily  and monthly transactions,

4.                  Checking the Stock Updating,

5.                  Generating Daily, Weekly, Monthly Reports,

6.                  Generating credit Reports.

Currently the firm is maintaining records manually.  Now it has to be automated for the day-to-day transactions and for all other purposes. That means for generating day to day sale transaction, monthly reports and Yearly Reports.

Introduction:

Purpose of the System:

                   The “Automation of Airtel Prepaid Distribution Accounts Management” project gives complete reference to the distributor and operator who works for the specified tasks in the organization. It is mainly used to store the details of Subscriber, Outlet, Stock about easy  and paper refilling details and very easy to calculate net profit & credit. It gives more user friendliness to the operator for manipulating the data of the customers and as well as distributor who is verifying the reports.

Scope of the System:

          The scope of the system is mainly maintaining the data selling and activating the SIM cards in proper manner. It maintains the details about outlets and subscribers.

Objectives:

The objectives of the system are mainly to provide services to the customers who are purchased SIM cards, monthly recharges in different schemes.

Definition and Acronyms:

           SIM ID: Subscribers Information Module Identification

Current System:

          The existing system, the operator is facing many of problems for entering the data of the subscribers like maintaining the subscriber’s information. It is more difficult to verifying all the information and making reports for each and every SIM activation, difficult to update the reports. The present system is a manual work and is should require so much of manpower and it is time consuming process and also it is very in consisted and not reliable.

Drawbacks of the Current System:

·        Time Delay: Information related to all transactions is stored in different tables. Since all the information is stored in different tables, it takes a lot of time to prepare different reports.

·        Redundancy: As the data passes through different tables. It involves a lot of complication and duplication in manual work, thus it causes redundancy.

·        Security: All the data that is entering into the current system can be manipulated by any person.

Proposed System:

Overview:

 Proposed system is entirely computer based. In this all the data is fed into the computer and stored in to Database and it allows to store large amount of data about the information and these data can be accessed for calculating the profit and generate reports.

Functional Requirements:

          The functional requirements are the high level functionality of the system here the function requirements of the central system monitoring all the activities of the organization for storing the details of the database.

·        SIM Sale and Activation:

Input: Enter subscriber name, address, photo, Identity to Proof such as driving license, Voter ID, Phone bill, Electricity bill, etc.,

Specification: To sale and activate SIM cards.

Output: To get the profit for each sale and activation.

·        Store the subscribers details:

Input: Enter the subscriber name, address.

Specification: To specify the details of the subscriber who purchase the SIM Cards.

Output: To get the details of the customer.

·        Create Reports:

Input: Enter the no. of SIM sales, amount, Outlet information.

Specification: To specify the sales per month, competitive data.

Output: To get the reports about all the information.

·        Check Reports:

Input: Enter the created reports.

Specification: To specify the created reports.

Output: To get status of the sales, competition and manager will take further steps.

·        Store the Outlet details:

Input: Enter the Outlet name and Outlet address.

Specification: To specify the details of the Outlets who sale the SIM Cards.

Output: To get the details of the Outlets.

·        Calculating net profit and credit:

Input: Enter no. of sales of SIM cards per day, SIM cost and refilling amounts in different schemes.

Specification: To specify the total amount to be paid by the outlet                            Dealer.

 Output: To get the total credit and profit amounts at different dealers                           with subtracting their discounts.

·        Store the Stock details:

Input: Enter the No. of Sim cards, Easy & Paper Refilling amounts .

Specification: To specify the details of the Refilling amounts of easy recharge, different paper recharge cards and No. of Sim cards.

Output: To get the details of the Sim cards, refilling amounts.

Problem Analysis

          Every System whenever it is to be manipulated or modified or generated is in need of some more qualities, necessary functions, easy applications and fast manipulations. Then only the system needs to be changed according to the environment. For that reason only any system has to be changed. In some more cases it is done for further upgrade of the system.

          The current system processes the information manually. So that it is taking more time for the operations and calculations that are going in the system. So for that reason system evaluation has occurred. Various problems in current system are stated as below

Ø Currently the system is running by manual operations. So for every each transaction the calculations are to be done manually.

Ø Whenever there is a shortage in the stock, it was noticed only when it was required. There are no previous measures are taken for that, because it is going in manual.

Ø The credit list is maintaining separately on a book. If a note is mistakenly entered or credit list entering was forget by the person then the amount which has to be recovered from the customer will be lost.

Ø Day-to-Day calculations are performing manually.

Ø It is difficult to find how many SIM sales; activations and refilling were done on a particular day until we refer to that particular day sheet.

Ø Generating yearly reports for sales and stock is difficult.

Overview:

                   The System Design Document gives a brief overview of each subsystem functionality in the project.

Current Software Architecture:

            SIM distribution, maintaining outlet details, SIM activation all are maintained manually. Profits & losses are calculated manually. They maintained some forms to enter details of daily transactions.

MODULES:

·        Sales Transactions Module: This module is responsible for recording all the sales transactions with different outlets. It deals with SIM Sales, SIM activation and SIM refilling transactions. It restricts other users except manager to record the above data inside the database. It allows to view the list of SIM cards to be activated and then activate them. He can store the information related to different refilling cards sold to different outlets. It allows the manager to create different operators and manager logins.

·        Subscriber & Outlets Module: This module allows the operator to maintain all the subscribers and outlets information. It provides facility for the operator to update the new scheme details given to different outlets. It tracks different subscriber who are subscribed for airtel through our outlets. It can track how business goes on with our competitors in our outlets. It allows to segregate outlets into different categories. It can generate reports to analyze the business with an outlet.

·        Day-to-Day Transactions module: This module is responsible for tracking day-to-day transactions with different business partners and generates different reports. It also calculates the credits and net profit of the company.

·        Stock Updates Module: This module is responsible for maintaining stock availability, stock updates and stock delivers information. Whenever it reaches the re-order level then the manager can track the data and updates the stock the immediately. In this stock module SIM cards info and refilling info will be maintained in different tables. It can also track stock updates related to both paper refilling and easy refilling.

HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS                              

PROCESSOR     : Intel 2.0 GHz or above

HARD DISK     :  80 GB

RAM                 :   512 MB RAM.

   SOFTWARE REQUIREMENTS

OPERATING SYSTEM                     : WINDOWS XP with SP2. 

LANGUAGE (FRONT END)          : JAVA (JDK1.5/1.6).

SERVER                                     : APACHE TOMCAT 5.5/6.0.

DATABASE (BACK END)       : MYSQL SERVER.

ARCHITECTURE                     : 3-TIER ARCHITECTURE.