Budget Management System Based on .Net Technology

Client Overview
This client is a subsidiary of a leading integrated energy corporation, one of the world's major petroleum engineering providers with businesses covering oil and gas upstream and downstream operations, petroleum refining, oilfield services, and equipment manufacturing and supply. It is one of the foremost oil and gas asset-holders on the continent of Africa.

Project Overview
Prior to completing a project, the planning department was required to create financial reports based on the up-to-date budget numbers of the project. After reviewing the collected data, the results would be presented to the upper echelons of the company for project approval. Under the old system it was a multi-day process to gather and aggregate the information. The delay was significantly impacting the client's business operations.

The time spent laboriously mining data and compiling reports was hindering their overseas management progress. They wanted a solution that would facilitate more efficient budget data tracking and reporting.

Project Challenges
Collection of data from myriad functional units of the client.
Interface compatibility issues between varying database systems during data mining.

USE solution
According to the client's current work model, we selected Microsoft Office as the data input interface. This choice allows users to use the standard Office formulas, functions and graphs with which they are familiar, thereby avoiding any operational disruptions. There are two key stages in the PMS (Planning Management System) development process:

Basic implementation
We organize an offshore development team for the client and select development tools. Based on USE's standard software development process, we collect research resources, analyze client requirements, design databases and create a logical and physical framework plan for the new system. Second, software development engineers finish the primary business module and PMS system module, and integrate the new ASP.NET system with existing programs written in other languages such as JAVA, ASP, VB and PB.

On-site operation
We assign team members to the client company in Africa for on-site service. Following the PMS deployment, we synchronize relevant client data into the PMS system. Finally, we present a clear report to the client based on the PMS system's statistical analysis of the client's data.

The PMS system provides tools to the client including data entry, data mining, results display, cost analysis and statistical reporting.
Points of project

Points of project
Runtime Environment:          Window Server 2003+IIS6.0 + .Net Framework
Source Code Management:   Microsoft Visual SourceSafe 6.0
Appendix software:               Microsoft Office 2003 or later version, Crystal Reports 10
Development tools:               Microsoft Visual Studio.Net 2003
Programming language:        C#, ASP.Net,
Database:                            Sql Server 2000

Benefits

  • PMS system has eliminated the need to enter data into multiple systems.
  • Significantly reduced paperwork in the field involved with submitting data.
  • The high-level audit and approval of the budget report is much faster.
  • Variety of statistic diagram and search conditions can be used in report.
  • Significantly improved maintenance and support efficiency and effectiveness.
Return