Strategic Claims Database Proposal
*Note: This is the smaller and first of two projects we have in the works. Whoever completes this project for us will be in an excellent position to receive the contract for our second much larger and more important project.
What we have:
We already have a shared and hosted MS SQL database with an online provider, and we have our data in excel spreadsheet and/or MS Access format.
What we need:
We need two levels of access, one for administrators who can see all data fields, create custom views and queries, edit existing views and queries, add or alter data, and add users.
The second level would be client level, and while they can perform searches or select different views, they cannot edit any information, and are restricted to whatever sections of data the administrator has granted them permission to see. Furthermore, we need to able to group clients into categories, each category having its set of permissions.
We need two data tables, one with approximately one million rows of data, and the other about six thousand rows. Both tables have about 12-15 columns in them, and we do not need any relational tables
We need to have a way to easily upload or alter data in either table, and this could be accomplished through a simple graphical user interface or through training of personnel (which turns out to more cost effective in the long run).
We need to develop a system for creating complex search queries on the fly with a minimum of technical knowledge (again, maybe a GUI would be best). These queries would also need to have their permission sets, so we can control which clients see which queries.
We need a similar system for creating or modifying reports (a report being a static list or summary generated upon request based upon information from the database). Again, each report type would need its own permission set, for the control reasons described above. The reports should also have the capability to generate simple, printable graphs and perform basic calculations like averages, arithmetic means, and such.
Finally, depending on how close to budget the project is, we would like to be able to offer clients a simple paste in script for their website that allows them to display information directly from our database, report result, or search interface on their website.
13 freelancers are bidding on average $268 for this job
I am an ASP/MS SQL expert with 7+ years of experience. Also familiar with html and css. I can show you examples of my work when you contact me and detailed description about what I've done for the other projects.