Record repository, web based application for analytics and data sharing

CLOSED
Bids
51
Avg Bid (USD)
$5074
Project Budget (USD)
$3000 - $5000

Project Description:
Summary:
Standalone app to upload records from customers servers to the central database.
Setup a mySQL database to store all of the records.
A php based web-based application utilizing AJAX for streamline operation. (Must use the PDO for database interaction).
All output will utilize a template engine.
The main purpose of the web based application is to:
-Perform analytics
-Generate a multitude of pre-defined reports
-Search data
-Share data
-Generate maps
-Perform spatial analysis
-Provide feedback on posts/bulletins

Overview
I need a developer to do the following:

Build a standalone application to export new and updated records from local database to a remote database over a secure connection. This application will be able to map the variables from the local database to the coordinating remote database fields as they will likely be named differently on each server. This application will be run by multiple different customer accounts on their server as a service to upload new records on a given schedule to the remote server.

A web based application (php) to standardize the new records based on a given set of rules (all customer records will be coded the same based on their criteria) and all new records have their locations/addresses geocoded. The new/updated records will be verified and have additional data added to them by a customer before they become usable within the customer account. The customers can then generate dynamic reports or run searches on these records.

These reports and searches will also provide dynamic maps using a mapping API (Currently undecided if the provider will be Bing, Google or Other, please list your preference/experience). Some of these maps will be on the same page as the search results and both the maps and the search results will be dynamic.

Spatial analysis will need to be conducted on-demand on similar records. Examples of types of spatial analysis will be; hot spots, predictive analysis, up and coming locations (trending locations), and new locations. These maps will also include records from other nearby customers, if the user is privileged to see those records.

The web based application will have an administrator account which is able to add/modify/delete customer accounts/users, etc. The customer accounts will also have different levels of access, i.e. moderator, power user, user, etc. There will be two initial types of customer accounts. Both accounts will be able to share information with other accounts. The sharing permissions will be able to be configured by each customer account moderator.

Each customer account will be given a default template for reports that are generated. Users will upload their own logo for these templates. Users will be able to customize these reports to their specifications using a template engine.

The design of the website must be modern, simple, clean and easy to navigate. The frontend must be separate from the backend.

The application must be scaleable so that it can handle hundreds of user accounts and hold millions of records.

This application is going to be initially developed and then likely to be continually modified/updated to add more functionality and additional modules. Future modules must be able to be easily added into the main application.

The application will also be able to, in the future, work on web enabled portable devices like the iphone/android/tablets. Upon successful completion of the project, we will likely hire the user for future additions to the program.

Please provide links to live web tools you've created. Well commented (in English) source code is required at the end of project.

Skills required:
Geospatial, Graphic Design, HTML5, MySQL, PHP
Hire kyvahe
Project posted by:
kyvahe United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 7725
in 90 days
$ 3090
in 30 days
$ 4500
in 60 days
$ 8000
in 75 days
$ 10300
in 90 days
$ 7004
in 60 days
$ 15965
in 90 days
Hire voservices
$ 5000
in 40 days
$ 4800
in 60 days
$ 3999
in 48 days