Hardware Reliability Monitoring Solution
A new bespoke software system is to be designed and developed to retrieve data being sent from multiple hardware units and stored in a database. The application to be designed & developed will analyse the stored data and provide statics & reporting to the users of the system. I require software developers to submit their high level proposals for this development project using Microsoft technologies (i.e. .NET & SQL). Below are some further details, the selected contractor will receive detailed specifications. 1. Review sample data delivered within a flat file from dial up connection o Each row has 31 character in text string containing 5 data elements within predefined positions 2. Obtain sample data from a dial up connection (connection details to be provided to selected contractor) 3. Design SQL database to store the data retrieved from the dial up modem & extracted from the flat file 4. Design solution architecture 5. Write code to extract data from the dial up modem & extract from the flat file then store in Db 6. Write a simple algorithm to measure the % consistency of the data being generated by many distinct pieces of hardware, each identified by a unique code within the data retrieved 7. Design & develop a basic configuration utility controlling the tolerance applied to the algorithm for reporting purposes 8. Design & develop a web application (.NET) to: o A simple user management feature is required, ensuring only approved users can log in and see the data & reports The functions & UI required to create & manage system users is required o Interrogate the data in the database according to user queries (note: specification will be provided to selected contractor) o Present the results of the algorithm (% consistency) per individual item of hardware o Present statistics of the collected data in pretty graphs 9. Design and develop a basic email alert mechanism presenting analysis data (SMTP server details will be provided) 10. Design & develop a installation script, so that I can visit the onsite server and install the new database & application o A new server will be purchased to meet the solutions requirements, you will be required to ensure you define software & licence needs for that server (i.e. SQL licence, web server) 11. Complete all development, testing & bug fixes on your own hardware before the solution is deployed within the customer data centre ? I am interested in your estimate for any ongoing maintenance of the solution ? The application will not be available publicly, users will access the application only from within a secure corporate Intranet ? It may be possible to gain access to the internal server within the corporate network, yet it is an unwieldy & slow process to apply for this access and obtain approval. Thus the preference for an onsite deployment via installation scripts & processes ? The data volumes will grow, so an archive mechanism will need to be designed and developed ? In the future the database will need to be enhanced in future project phases to add web services/API's allowing 3rd party internal applications to integrate and use the data within the Db. The details of the future plan will be discussed with the selected contractor and must be considered during the design & build process. ? All source code, I.P., etc belongs to Jundra Pty Ltd and all source code will be delivered to Jundra upon completion of the project Desired Skills: SQL, SQL Server, .NET Keywords: Software Application, SQL, .NET, Server
| Expired |
More sql projects
View AllMore sql server projects
View AllRelated projects
Search for freelance jobs
"I did not know what to expect at first. But my final impression once I used your site and service is a great one! Simply amazing!
I would recommend this service to any other freelance artists and co workers who are looking to expand their client base."
"The possibility to include all information about my freelance working places in just one website. It means, I don't need to tell my future employer to go to odesk, elance, etc. They can check everything about me in donanza website."




