Organizing huge files and databases from multiple sources, with multiple variables and pieces of data. Once organized, the data will have to be analyzed and organized so multiple queries can be done to pull desired data.
Organizing will be the time consuming piece, there are hundreds of files.
* * *This broadcast message was sent to all bidders on Tuesday Jan 18, 2011 5:07:44 PM:
Hello Thank You for responding to our ad. This project is best suited for a small team. We have hundreds of different files of data, with all sorts of variables. Most are in xcel, some are text. The data ranges from simple one column with a plain header, insurance agents. So are more involved, with 30 columns of data, with keys or decifers that explains code meanings. All files must be put into one master database. Finite organization is a must. Each file must be tagged on what it is. When all files are imported into the database, then we need to organize everything according to what the data is and how to label it so we can pull queries from it. So we may have 20 million doctors, in all fields of expertise, allergy, radiology, dentist, chiropractor etc, so we must lable them as doctors, then label them in area of expertise. So if a client wishes to pull all doctors in CA they can, or if a client wishes to pull all chiropractors in zip code 90125 they can. There is a very large amount of data. We first need the data imported into one database, then organize it, then understand what data we have in order to develop queries. Pretty straight forward, it the size that becomes complicated. We need the program to pull queries. We will need to have de-dup process, we will need a simple option to import new data. We will need an option to purge all bad addresses. Many layers of this database, all in all once it is organized it should go fast. We want to incorporate this into a website with shopping cart mech on it. So if we can find a company to do it all that would be great. We have another job for the site, we can have another team donig the website to move it along faster. Please let me know if there are further questions. My skype is brooks1861