Provisional Expenses Calculation System
Client
NVision Group, a market-leading Russian system integrator that is uniquely focused to align the business of national companies with the power of best-in-class IT, networking and telecom solutions. NVision Group brings clients value-added consulting and system integration services, from planning of the network, to strategic consulting, system design, integration, and development.
Problem Background
Moscow City, one of the largest world's megalopolis, government performs enormous number of public purchases and uses one of the most complex integrated information systems to consolidate information about its activities.
The information system "Provisional Expenses" is a part of this complex system and is purposed to collect data about various government departments' future activities and conduct their automatic expenses calculation with integrated control over the correctness of calculation and initial data.
Project Overview
The main goal of the system development is standardization and automation of provisional expenses documents formation for the following budget items:
- Software development
- Software services support
- Equipment acquisition and support
- Telecommunication services
The system is integrated with other departments' modules and can receive initial data from them. Also initial data may be imported from preformed Excel templates with consistency control. The data is consolidated and classified in the system to allow automatic processing using reference module.
Reference sub-system is a key element in the application. Most calculations performed are unified or dictated by legislation; therefore they can be pre-set in the system and used later by automation module. A powerful "Formula" module was envisaged in the application to allow users to form their own dependencies and formulas for calculation. Thus the system is very flexible as we have minimized hard-coded values calculations.
Most provisional expenses are calculated automatically, however there are a number of documents that are not possible to automate; for them we have provided manual facilities. Resulting documents may be printed or exported to Excel templates. Also a powerful reporting system is envisaged with registry keeping on key objects and objects' groups in the workflow.
Benefits for the customers
- A Single information space which saves time by providing information 24/7 using common information objects
- Work support for all distant users providing quick access to reference database
- Complex calculations using multitude of objects are automated and controlled
- Superior bodies can quickly and easily obtain detailed reports about planned activities and their expenses.
Used Technologies and Products
IDE & Dev. Tools: Eclipse, DBMS, Oracle 9i, J2EE, OC4J, OOP, OOD
Project workload
The project team was composed of 5 developers per 20 months project duration (project is in process).
- Learn more about
