Project Title: Public Procurement Automation System

The Challenge

The customer was faced with new legislative regulations that imposed strict requirements on procurement process. The breach of regulations may result in procurement results’ protestation and cancellation.

The procedures used customer personnel to prepare procurement documents were not automated. All documents were made by manually using Microsoft Office: requests for proposal – in Microsoft Word, main stages were tracked in Microsoft Excel, reports were written by hand on pre-printed forms.

Considering new rules that mainly set up new time-constraints and restricted procedures execution, the customer could not rely upon old outdated practices any longer as they might result in transactions cancellation and financial loss.

The Solution

The new procurement system was designed to automate procedures, namely but not limited to:

• Registration of customer needs in goods and services;
  
• Automatic creation of procurement documents and requests for quotations based on predefined templates;
  
• Flexible documents and templates management
  
• Documents workflow management
  
• Results of purchase orders placement;
  
• Tracking of time-constraints fulfillment;
  
• Creation of reports on results of preliminary purchase plans execution
  
• Automatic notifications about upcoming events;
  
• Implementation of managed internal goods and services listings.

Also the system was designed to be easily extended to support new methods of procurements that were introduced by new legislation.

Technical Description
The solution was designed as a web part for Microsoft SharePoint Portal Server 2003 and is a typical 3-layered application.

Microsoft SQL Server 2000 and xml configuration files are used for storing data. Data management is implemented using stored procedures and a separate layer for data access. Business functions, such as data verification and reports generation, are performed by business logic layer. A separate system service sends automatic e-mail notifications about business events in the system. Visual part of the application is presented by the set of ASP.NET controls, consolidated into a single SharePoint Portal Server module.

A special feature of the system is usage of template files to generate report documents in MS Word è Excel formats. Interaction with MS Office applications is performed using standard Office API è .NET Framework.

Tools and Technologies

Microsoft SharePoint Portal Server 2003, Microsoft Office 2003, ASP.NET

Related links

http://www.qulix.com/Case_Study_-_Public_Procurement_Automation.html

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.