In Progress

SQL Automation/Query/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.

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.

Skills: Data Processing, SQL

See more: automation query, sql server reporting automation, sql automation query, looking sql server developer, webex location, top query, top codes, sql software developer, sql pdf files, sql functions pdf, software developer remote, reporting software review, remote excel developer, remote excel, looking sql developer remote, key data structure, find sql developer, excel support company, examples data structure, examples databases, developer find solution, data structure solution, data structure examples, databases examples, csv codes

About the Employer:
( 1 review ) The Woodlands, United States

Project ID: #543446

Awarded to:

grx3

Greetings. I have the depth of experience and support you need to take on this reporting project. Let me help you.

$900 USD in 20 days
(1 Review)
0.0

25 freelancers are bidding on average $958 for this job

qtsteam

Please check PMB for details, Thanks.

$1200 USD in 25 days
(17 Reviews)
6.5
AlosDeveloper

Hello, please see PMB

$1500 USD in 10 days
(28 Reviews)
6.1
spawar

Hi, I have a very good experience on SQL and .Net technology, I will do this work for you and provide you the support still you are familier with the process, interested to work with you long term. Ready to start wo More

$1000 USD in 15 days
(14 Reviews)
4.8
subratparida

My name is Subrat Parida. I'm the owner of CADS Inc (Computer Applications & Database Solutions Inc) is located in Bhubaneswar, India. I have 8 years of software development working experience in USA and 2 years in More

$800 USD in 25 days
(2 Reviews)
3.8
YashpalSingh123

hello, Expert Computer Engineer, in ASP.net,C#, Sql2005,Can Start Work on Immediately effect. thanx

$500 USD in 10 days
(1 Review)
3.0
zeuner

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.

$1650 USD in 25 days
(2 Reviews)
2.8
Yasas

I have an almost complete solution .. please check your PM. Thanks.

$1000 USD in 20 days
(0 Reviews)
0.0
iduy

I have a good experience on SQL and PHP. I Ready to start work on this immediately.

$500 USD in 10 days
(0 Reviews)
0.0
obcparis

I am a .NET developer with SQL experience. Have already developed similar applications, automating report generation in multiple formats. Can create a GUI for standard data entry. User can choose columns to change. More

$1000 USD in 20 days
(0 Reviews)
0.0
shilpisoni

-------------------------------

$800 USD in 30 days
(0 Reviews)
0.0
lillyjosh21

hello there we are SolutionBytes have the right expertise to do this...please check PM...regards lillyjosh.

$950 USD in 23 days
(0 Reviews)
0.0
krishna25051982

we will complete this project in given time.

$600 USD in 10 days
(0 Reviews)
0.0
UnixDatabase911

Hi, I have 9 years of experience in Database field especially in Database Designing using different CASE tools, and implementation using Oracle, SQL Server, mySQL and MS Access. Contact me ASAP then I'll be able to More

$900 USD in 15 days
(0 Reviews)
0.0
naveen8878

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.

$1100 USD in 30 days
(0 Reviews)
0.0
sravi22

We have DB admin team handle your request. we are capable deliver your request ontime.

$1500 USD in 30 days
(0 Reviews)
0.0
sedavhikh

Hello! I have 3 years experience with developing GUI application that collaborate with different RDBMSs. I'm also experienced in developing applications with report creation functionality. I can do the project on Ja More

$500 USD in 30 days
(0 Reviews)
0.0
fgtpl

********************************************************************* KINDLY CHC PMB ******************************************************** ********************************************************************* PAYMEN More

$1700 USD in 30 days
(0 Reviews)
0.0
kuntalghosh2

he ghjghjkjjkhj bhmgh

$500 USD in 7 days
(0 Reviews)
0.0
nidhish12345

WE HAVE PASSIONATE ENGINEER WHO CAN DELIVER ON TIME IN LEAST COST.

$602 USD in 17 days
(0 Reviews)
0.0
SkySoftware

Hi, I understood your requirement, it will take 20 days for me to complete.I am having 4 years experience in SQL and also in developing GUI applications with backend as SQL. To develop GUI i prefer VB 6 as it is most r More

$500 USD in 20 days
(0 Reviews)
0.0