Custom Database for a Small Busines

Closed

Description

We're looking for a well qualified dev to build a database for us.

Overview:

-It will be an attempt to get a "one view of our customers", meaning data from multiple sources pulled into one solitary place.

-Customer information comes from many sources. The easiest source is transactional, from a point of sale. Other sources involve loyalty programs, custom web forms, mail chimp, etc etc.

-We want the software to automate the import and management as much as possible. We'll identify the various sources of data (10 or so) and create a master structure field list and relationships. The software would give us the ability to map fields for each input source, creating templates for each source. Multiple templates can be used.

-Software, using the above templates, will routinely scan for new data and synchronize/import.

-data must be able to be exported, which again, will allow us to select output type (CSV or MSDOS tab delimited, usually) and which fields to include, all in a template. The export process would happen automatically after the nightly import process

-the database must be portable, meaning we could keep it in dropbox and open it from any location (single user access only required)

-the number of records are estimated to be the following: number of patient records: 5-10k, transactions 50-300 daily, products 5-10k.

-there must be a query form where we can search for recordsets based on criteria (age > 14 AND gender=female, age between 50 and 65, etc etc)

-there must be a form where an individual customer can be opened to see the other table contents (sort of like an order system)

Looking for people with experience with this software. I MUST see previous examples/portfolio of similar work.

I will clarify as I get questions. I am currently gathering the data exports from the varied sources, so I'll have a better picture of specific needs shortly.

Skills: Database Administration, Microsoft Access, PHP, Software Architecture

See more: synchronize table, search web for picture, questions of data structure, portfolio web dev, patient point, meaning of data structure, examples of data structure, data structure sort, data structure meaning, data structure examples in c, database web templates, c map data structure, c data structure programs, architecture programs, a small template, type a scan, mail chimp template, following number, custom web build, chimp, creating access database forms, import access database php, map csv fields, small data table, patient database questions

Project ID: #4635392

33 freelancers are bidding on average $1348 for this job

evsoftpk

Hello! (1) A better way to undertake this project is to let you interview and discuss the project with our systems analyst. Mutual discussion and proper guideline will put both of us in a win-win situation. All details More

$1473 USD in 45 days
(191 Reviews)
8.9
hits

I represent a team of designers and developers with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress and MySql. We have developed many complex and extensive custom sites of varied ex More

$1578 USD in 15 days
(862 Reviews)
8.8
manpreet

We are experts in such websites.

$1500 USD in 21 days
(211 Reviews)
8.2
leadconcept

Please see PMB for more detailed message.

$1546 USD in 30 days
(33 Reviews)
8.0
buraqtech

Check your PMB for details!!!

$1324 USD in 22 days
(65 Reviews)
7.6
weng0000

Good day! I can help you provide the application. Thanks and regards, Weng

$1250 USD in 3 days
(746 Reviews)
6.9
onelinewebdeUK

Thanks for your consideration, please see our message and if you would like to discuss the project further do get in touch and I'll give you a call.

$1578 USD in 25 days
(14 Reviews)
6.8
ibapi

need to have details about example sources and master.

$1030 USD in 8 days
(106 Reviews)
6.6
AndreiMk

I made a similar system in the past. Please, see my PM.

$1833 USD in 14 days
(55 Reviews)
6.5
Premshanks

This is what I call it as Customer Master data management. It gives 360 degree view of a customer i.e., gather customer data from various sources, match/merge them, enable queries. The data import will happen through a More

$1110 USD in 3 days
(344 Reviews)
6.5
kchg

Hello, sir I'm interested with your project. I'll do it for you. Regards.

$1546 USD in 15 days
(54 Reviews)
6.2
forrestwang

Hi Sir, I did similar work with .NET. Lets discuss it.

$1666 USD in 30 days
(23 Reviews)
6.0
vnb400sl

i can develop an app in .NET, kindly provide samples.

$1444 USD in 30 days
(110 Reviews)
5.7
bigdognec

Let us discuss the details a little more

$1010 USD in 3 days
(73 Reviews)
5.7
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$1333 USD in 40 days
(23 Reviews)
5.5
qspsolutions

Details in PMB.

$2631 USD in 30 days
(7 Reviews)
5.4
ielkfarna

Please, See my private Message.

$789 USD in 14 days
(26 Reviews)
5.2
extreamcode

HI, understood.Let's get it started.

$1159 USD in 30 days
(6 Reviews)
4.9
on2it

Hi, We can give you the best and quick output. We have a professional team in your required area, they work sincerely. You will get your desired output from us. We are very much concerned about quality and customer sa More

$1546 USD in 30 days
(4 Reviews)
4.8
Churaliya

I'm ready.....

$833 USD in 12 days
(17 Reviews)
4.7