Project Detail

SQL Automation/Query/Reporting  

SQL Automation/Query/Reporting is project number 543446
posted at GetAFreelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: grx3

Budget: min $500

Created: 11/04/2009 at 16:46 EST

Bid Count: 25

Average Bid:
$ 958

11/24/2009 at 16:46 EST

Project Creator: mattgriswold View PM Post PM
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

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 (OKLAtransactions.txt, OKLAlinetemp.txt, OKLAtankgauge.txt, 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 (http://www.sqlpower.ca/page/wabit) 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.

Messages Posted:3 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 
View PM Post PM

1200

25 days

11-05-2009 11:19 EST

Please check PMB for details, Thanks.

help

 
View PM Post PM

1000

15 days

11-04-2009 23:14 EST

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 work on this immediately.

help

 
View PM Post PM

1650

25 days

11-07-2009 05:48 EST

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.

help

 
View PM Post PM

1500

10 days

11-05-2009 00:27 EST

Hello, please see PMB

help

 
View PM Post PM

500

10 days

11-04-2009 19:57 EST

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

help

 
View PM Post PM

900

20 days

11-04-2009 19:32 EST

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

help

 
View PM Post PM

800

25 days

11-09-2009 03:30 EST

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 Singapore. We've clients from USA, Germany and Holland. Here are some good projects that we've worked on. www.greensherpa.com www.authoria.com www.teeccino.com If you want to test us before selecting us, you could do that. Just give us a small requirement. You could pay us money at the end of project once you're completely satisfied with all the changes. Please let us know if you're interested, we would be glad to work on this project. Thanks, Subrat Parida

help

 
View PM Post PM

1700

30 days

11-05-2009 00:48 EST

(No Feedback Yet)

********************************************************************* KINDLY CHC PMB ******************************************************** ********************************************************************* PAYMENTS ON MILESTONES Via GAF ******************************************************** ****************************************************

help

 
View PM Post PM

1100

30 days

11-04-2009 19:23 EST

(No Feedback Yet)

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.

help

 
View PM Post PM

750

15 days

11-04-2009 20:35 EST

(No Feedback Yet)

see my pm to you, please. Thank you.

help

 
View PM Post PM

1200

15 days

11-04-2009 21:45 EST

(No Feedback Yet)

Please check PM for details.

help

 
View PM Post PM

800

20 days

11-04-2009 21:51 EST

(No Feedback Yet)

Hi, I have a 5+ yrs of experience with SQL Server. Please feel free to contact me for any clarification. Thanks & regards,

help

 
View PM Post PM

500

20 days

11-05-2009 00:08 EST

(No Feedback Yet)

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 recommended GUI. I am currently working in Fortune Top 10 listed company.I had done same Kind of Project various times.Looking forward for your reply. Thanks Aakash

help

 
View PM Post PM

602

17 days

11-05-2009 00:27 EST

(No Feedback Yet)

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

help

 
View PM Post PM

500

7 days

11-05-2009 00:39 EST

(No Feedback Yet)

he ghjghjkjjkhj bhmgh

help

 
View PM Post PM

500

30 days

11-05-2009 01:51 EST

(No Feedback Yet)

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 Java programming language. Best regards, Stanislav

help

 
View PM Post PM

1500

20 days

11-05-2009 02:31 EST

(No Feedback Yet)

Hi we are master in data processing and report generation just need your complete requirements recently working on the same so please let us do this to you. We can give you a user interface application for this so you have no need to use SQL as front end.

help

 
View PM Post PM

1500

30 days

11-05-2009 03:21 EST

(No Feedback Yet)

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

help

 
View PM Post PM

1000

20 days

11-05-2009 07:36 EST

(No Feedback Yet)

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

help

 
View PM Post PM

900

15 days

11-05-2009 07:55 EST

(No Feedback Yet)

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 answer you in detail. You can Contact me for any type of SQL queries and reporting. I hope to hear from you soon ! Sincerely, UnixDatabase911

help

 
View PM Post PM

600

10 days

11-09-2009 01:23 EST

(No Feedback Yet)

we will complete this project in given time.

help

 
View PM Post PM

950

23 days

11-06-2009 07:12 EST

(No Feedback Yet)

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

help

 
View PM Post PM

800

30 days

11-06-2009 14:53 EST

(No Feedback Yet)

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

help

 
View PM Post PM

1000

20 days

11-07-2009 18:11 EST

(No Feedback Yet)

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. Flexible to requirements.

help

 
View PM Post PM

500

10 days

11-08-2009 07:10 EST

(No Feedback Yet)

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

help


    Bid on this Project