Budjet Planner

ABSTRACT

This project is aimed at developing a system by which the employees in the organization submit the bills to their managers. The bills could of various types and also of various amounts. The employee after submitting the bill will automatically provide the manager’s name to which the bill will be submitted. The bill will pass through a workflow process and the owner of the bill can view the status of the bill at any time. An email will be sent to the concerned people to let them know about the status of the bill.

The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the “SQL Connection” methodology. The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.

The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage. The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The total front end was dominated using the ASP.Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest “SQL Connection” technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely.

INTRODUCTION

INTRODUCTION TO PROJECT

This project is very popular and widely used in many big organizations for submitting various types of bills to their senior. This is an online system and is used maintain most of the activities happening in big organizations. This project is aimed at developing a system by which the employees in the organization submit the bills to their managers. The employee after submitting the bill will automatically provide the manager’s name to which the bill be submitted. The bill will pass through a workflow process and the owner of the bill or bill creator can view the status of the bill at any time.

PURPOSE OF THE PROJECT

The main purpose of this project is aimed at developing a system which reduces work burden of employees of the organization. Every Organization has some maintenance and budget planning’s. In this situation submitting the bills to their corresponding managers will be a headache and we have to maintain records manually. Some times in manual process there is a possibility to get errors. To overcome these difficulties and time being best to use this type of application. In this the employees in the organization submit the bills to their managers. The bills could of various types and also of various amounts. The employee after submitting the bill will automatically provide the manager’s name to which the bill will be submitted. The bill will pass through a workflow process and the owner of the bill can view the status of the bill at any time. An email will be sent to the concerned people to let them know about the status of the bill.

PROBLEM IN EXISTING SYSTEM

• It is limited to a single system.
• It is less user-friendly.
• It is having lots of manual work (Manual system does not mean that you are working with pen and paper, it also include working on spread sheets and other simple software's)
• It requires more no of employees need to work.
• It is time consuming process.
• The present system is very less secure.
• It is unable to generate different kinds of report.

SOLUTION OF THESE PROBLEMS

The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.

• User friendliness is provided in the application with various controls.
• The system makes the overall project management much easier and flexible.
• It can be accessed over the Internet.
• Various classes have been used to provide file upload and mail features.
• There is no risk of data mismanagement at any level while the project development is under process.
• Report generation feature is provided using Crystal Reports to generate different kinds of reports like bar graphs, pie charts and table type charts etc.

It provides high level of security using different protocols like https etc.

NUMBER OF MODULES

The system after careful analysis has been identified to be presented with the following modules:

The modules involved are:          

1.       Administration

2.       Finance Managers

3.       Managers

4.       Request Creator

5.       Reports

6.       Search

7.       Authentication

Administration:- 

Admin has all privileges to add/modify employee and view the reports. In this there are sub modules like

1.    Employee Details

2.    Deportment Details

3.    Bill Details

4.    Reports

Employee:

This module only for employee maintenance like registering new employee details in the organization.

• Employee maintenance is used to register a new employee, modify the details of existing employee or remove the existing employee.
• Only the admin type user will have access to this part. Normal user won’t have access to this. While storing into database the password should be encrypted and stored. The user can choose its own logic to encrypt the password.
• User password is used to change own password. Both admin and normal user will have access to this.

Department Details:

This module is used to maintain the various departments in the organization. Department details can be modified by the admin type of users only. This module will be enabled only to the admin type of users.                  

Reports:

• This module is used to print various online reports. This module will be enabled only to the admin type of users.
• In this admin generate various types of reports about the employees working in the organization.

• In this admin generate various types of billing reports which are generated by employees working in the organization.
• In this admin generates the reports by date wise as input and gives details of bill made on that date along with total information. This report should be available for a given date or for a date range.

Managers:-

In this module there are two types of managers are exists.

1.   Finance Manager Users

2.   Managers Users.

3.   Request Creators.

Finance Managers:

• There will be number of finance managers and each finance manager will responsible for 1 or 2 departments.

• Users in this role can only close the application, they can only view the requests and after crediting the amount to the request creator the request will be closed by the finance manager

Manager Users:

• The manager of user is able to view the details of the bills which is created by request creators.
• This type of user can view the details but cannot modify the details send by request creators.
• This type of user can view the details and he can either approve the request or reject it.
• Every time he performs and operation the approver has to write the comments for the same.

HARDWARE REQUIREMENTS:

• PIV 2.8 GHz Processor and Above
• RAM 512MB and Above
• HDD 20 GB Hard Disk Space and Above

SOFTWARE REQUIREMENTS:

• WINDOWS OS (XP / 2000 / 200 Server / 2003 Server)
• Visual Studio .Net 2005 Enterprise Edition
• Internet Information Server 5.0 (IIS)
• Visual Studio .Net Framework (Minimal for Deployment)                          
• SQL Server 2000 Enterprise Edition