Origin Solutions is a telematics solutions provider. Typical applications include the installation of PCB interfaces and terminals (satellite and GSM/GPRS modems) in client assets for collection and transmission of data. Currently, internal/administrative management of the above mentioned is done in Excel spreadsheets. A growing customer base has resulted in the system becoming cumbersome and difficult to manage and maintain. Origin Solutions requires an MS-SQL database driven system for the administrative and financial management of installed terminals. This system must provide functionality for addition, updating, modification and deleting of all relevant details applicable to terminals installed at clients, including but not limited to: • Client details ??" account number, name, contact details etc • Terminal details ??" terminal ID, modem and application type, status, application type, routing details etc. • Interface details (some applications require the installation of a data interface with terminals) • Financial information ??" addition/modification of financial information per terminal/client for billing purposes. The developer should use the attached documents (see [url removed, login to view] contents) as a reference for the design and development of the database structure and user interface application(s). - [url removed, login to view] - design framework for database and application(s) - terminal list - [url removed, login to view] - sample of current Excel spreadsheets used.
1) Complete and fully-functional working database and program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be delivered by the Seller in ready-to-run condition in the Buyer's environment. Buyer will do installation and final testing. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement.
The database and web-based appplication(s) will be installed on a server with either SBS2003, Server2003, with SQL Server2005 Client PC's from where data will be accessed via web-based interface will run either Win XP Pro (SP2) or Vista.