Remote facility data management, query, and reporting
-5 users with access to the same databases
-Automated and scheduled import of tab delimited txt files to append existing SQL databases (SQL Server Authentication)
-TXT files for each individual location will share a similar naming convention ([url removed, login to view], [url removed, login to view], [url removed, login to view], etc)
-Ability to correct individual databases using additional columns in table instead of overwriting original data
-Ability to use specified data to calculate new columns (i.e. subtract two date columns to find the elapsed time and create a new column)
-Automated and scheduled report generation based on predefined queries (ie query all company codes matching 400 between 10/01/09 and 10/31/09 sorted by date)
-Reporting will be date sorted and include the sum of specified columns with a subtotal for each day (examples will be provided)
-Ability to edit reports once they are created
-Ability to manually enter data into tables
-Ability to create a custom query using a GUI
-Ability to create a custom report using a GUI
-Queries will use corrected column data if available, otherwise query will use original data
-At the top of the report a summary of the data should be generated (examples will be provided)
-Output format for reports should be in excel, pdf, txt, or csv
-Ability to add new files/queries/reports for new remote facilites
-We have some experience with Wabit BI ([url removed, login to view]) as a GUI. We are open to using Wabit, a custom solution or another off-the-shelf solution. Please check with us before choosing an off-the-shelf GUI.
-Easy to use GUI for custom queries and flexible reporting are key.
-Developer should have ability to provide ongoing support but this support should not be part of this bid.
-Software/Developer will be required to perform several test functions (append database, correct database, custom query, create report, etc) before payment. Ideally this could be done through a Webex demonstration.
I have included a sample of txt files for you to review. We have some ability to modify the structure of these files if necessary.
We are looking forward to discussing the project with you.
25 freelancers are bidding on average $958 for this job
I am experienced in designing and developing analytics software, and I hope to provide you with a great experience regarding this project. Please refer to your PMB for further discussion.
I have vast experience in SQl, .Net, SSRS. Currently working on a same kind of reporting requirement and very much sure of meeting your requirements and expectations.