Distributed Account Management for Prepaid Mobile Services
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 “Distributed Account Management System for prepaid Mobile Services” is to make more user friendliness to the Operators who are manipulating the Respective operations in the firm. The objectives of the project are:
Manipulating the Sale Transactions,
Maintaining the subscriber, outlet details,
Maintaining the daily and monthly transactions,
Checking the Stock Updating,
Generating Daily, Weekly, Monthly Reports,
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.
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 much inconsisted 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 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. 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. Advantages over Proposed System:
1. We can provide more security to the important data.
2. We can maintain the data in centralized location.
3. Easily track out the subscriber and distributor details.
4. Track out the payment collections.
5. No other technology is needed for work on this application.
6. Maintaining SIM cards information is pretty easy.
7. Calculating the day-to-day transactions is also very much Simple.
In this system two users will have the facility to work.
Operator is the main user to operate and control this software. As a main user operator can able to add a new user that may be operator or manager and he can manage (Edit/Delete) all these users. He is having some extra features when compared to the manager. Operator will have some activities and he is the user to manage all the activities. Operator can able to manage the information regarding distributors, subscribers, outlets, stock entry, proof documents, competitive, category, cards and payments collection. Operator can able to enter the details SIM Sales, SIM Activations, Easy Refilling Sales, and Paper Recharge Card Sales. He can generate all the necessary reports like Credit Reports, Outlet Details Reports, Stock Details Reports, Subscriber Information Report, Users Information Report, Payments Report, and Invoice Reports.
Manager is the second responsible user for this software. He also having separate username and password for working in this application and his profile will be created by operator. Manager can able to create new outlets. He can able to add distributors and manage the distributors. He can add the details of subscribers. He can enter the stock details of SIM Cards, Paper Recharge Cards, and Easy Recharge. Manager can add the details of document proofs. He can add the details of new tariffs of cards and recharge coupons. Manager can able to manage the categories and its slabs. He can maintain the outlet wise details and payments collection.
2 Sales Transactions Module:
3 Subcriber & Outlets Module:
4 Day-to-Day Transactions module: