10-04-2017, 08:31 PM
Automation of Airtel prepaid distribution Accounts Management
Abstract
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:
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.
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.
1.1 Object Design Trade-offs:
The object design trade-offs made by developers. If the software does not meet response time or throughput requirements, more memory can be expended to speed up the software such as caching more. Java (jsp, Servlets, html) as front-end and oracle as a back-end.
SOFTWARE REQUIREMENTS
Programming languages : Java
Web technologies : JSP 2.0, Servlets 2.3
Frame work : Struts 1.3.5
Database connectivity : Java Database Connectivity (JDBC 3.0)
RDBMS : MS-SQL Server 2003
Client-side Technologies : HTML, Java script,