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.