Find Jobs
Hire Freelancers

Database Consolidation - Web Interface

$250-750 USD

Completed
Posted over 13 years ago

$250-750 USD

Paid on delivery
I am the Marketing Manager for a lead generation company. We've been in business for eight years and have accumulated 100's of spreadsheets with approximately 500,000 to 750,000 contact data records (names, addresses, company name, type of system, etc.). The spreadsheets are disparate in the headings ("Zip" on one might be "Postal Code" on another). Some may have "Full Name" while others have "First Name" and "Last Name." Some might have information that might be present on that spreadsheet but not others. Some company names are disparate ("Microsoft Inc." might be "Microsoft" on a different record). The bottom line is that we would like to homogenize this data into a single database that we can then easily add to at our convenience and is web accessible. This is what we are looking for our provider to do: 1. Provide advice on whether to use MySQL, MS Access or other database platform. 2. Take all of our spreadsheets and data files and enter the data into a single database. 3. Combine data (if there are multiple records of the same entry) to get the most accurate record. 4. De-duplicate the data. 5. Create a front end web user interface for upload and download of said information: • Must have downloadable search results based on all different criteria (all fields provided) • Must have reporting of said data numbers • Must have admin login and easy user creation • Must have import and export capability • Web interface must match current web design (can provide template) • Please also provide estimate on building it on [login to view URL] app exchange 6. Provider must be accessible to communicate by telephone if needed (International providers OK, but English-speaking is a must). If you do a great job, we'll be happy to provide excellent feedback and give you more work, as necessary. Thanks for bidding and we look forward to working with you.
Project ID: 807305

About the project

17 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
please check PMB for details
$750 USD in 30 days
5.0 (1 review)
4.2
4.2
17 freelancers are bidding on average $546 USD for this job
User Avatar
The databases were part of my job during last 15 years. Creating all forms that you want to load data or to extract data from databases could be done in less than 7 days. But the hard part of this project is to homogenize the tables that you have now. Achieve the homogeneity must be done in gradual steps and it take time depending of number of columns. That why I choose 20 days to finish the project, but if it will be proved to be easer job is possible to be finished sooner. Additionally, if job will be easer I will agree to fee less.
$700 USD in 20 days
4.8 (4 reviews)
5.5
5.5
User Avatar
Hi sir, our team is expert in developing data bases, we will provide you the best solution , contact for quality work, thanks
$280 USD in 30 days
4.9 (10 reviews)
5.0
5.0
User Avatar
I am expert in database designing. PIXAR develop, integrate, implement and deploy innovative technology solutions globally for small to high portfolio businesses through rapid software development model. We are committed to provide solution and services which dramatically increase business performance.
$300 USD in 4 days
4.9 (12 reviews)
4.7
4.7
User Avatar
Hi, please check PMB to know more about our technical expertise and capabilities. Regards, Ricku Lohar
$700 USD in 15 days
5.0 (1 review)
4.0
4.0
User Avatar
Hi, I can do this work. Thanks
$400 USD in 10 days
4.7 (2 reviews)
3.7
3.7
User Avatar
Please check PM, Thank you.
$500 USD in 8 days
5.0 (1 review)
2.0
2.0
User Avatar
Dear Sir, Hello! We have gone through your requirements, all ready we have done such type of work. If you have any questions feel fee to get in touch us for more clarifications. Please visit PMB for more information. With Regards iCUBE Lab
$600 USD in 7 days
5.0 (1 review)
2.0
2.0
User Avatar
Hi, Please check PMB for details. Thanks
$750 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
check my pmb
$300 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to work on this one which would require some data cleansing strategies...
$600 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i will do this job
$300 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My bid is still negotiable and we could meet half way.
$700 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Madam/Sir, We are a group of software professionals and posses more than five years of industry experience. We look forward to work on your project and assure you on time delivery with high quality and customer satisfaction. Thank you.
$600 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Please check PMB.
$300 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Dallas, United States
4.7
2
Member since Aug 25, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.