SQL data automation/reporting

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.


Habilidades: SQL

Veja mais: sql report automation, data automation sql, webex location, top query, top data, top codes, sql software developer, sql pdf files, sql functions pdf, sql bi developer, sorted data, software developer remote, remote excel developer, remote excel, find a sql developer, find a remote developer, find an access developer, find access developer, excel support company, examples databases, developer find solution, databases examples, csv codes, as 400 developer, sql server gui

Acerca do Empregador:
( 1 comentário ) The Woodlands, United States

ID do Projeto: #579679

Concedido a:


Let's do it.

$1350 USD em 25 dias
(17 Comentários)

3 freelancers estão ofertando em média $1350 para esse trabalho


Hi, Expert here, can start now and can complete within 15-20 Days max. Awaiting ur selection.....! :-)

$1500 USD in 20 dias
(0 Comentários)

Hi Sir, I am looking forward to work in this project.

$1200 USD in 20 dias
(0 Comentários)