Find Jobs
Hire Freelancers

Build a database / create / design / add rules for processing / export

$250-750 USD

Closed
Posted about 5 years ago

$250-750 USD

Paid on delivery
I'm not sure the best way to do this. I believe it is through a database. i have raw data that has a list of Owners and the Properties they own. I want to be able to mail one letter per owner. This requires : 1. Separating the owners into Businesses and People 2. Formatting the Businesses and People's name into a clean format 3. Produce 4 lists a. To Be Mailed i. People (Duplicates Removed and Names cleaned/standardized) ii. Businesses (Duplicates Removed and Names cleaned/standardized) b. To Be uploaded into Podio i People (Duplicates included and Names cleaned/standardized) ii. Businesses (Duplicates included and Names cleaned/standardized) The four list would be outputed into csv, google sheets. Please provide guidelines of how you would do this at a high level. Also, please provide an estimate of how many hours this would take. I attached a copy of the raw data, that i want to upload into the database, have exported into clean data into the second tab format. To ensure that I know you read the post fully, please type (Odinson) at the beginning of your reply. :)
Project ID: 18645667

About the project

29 proposals
Remote project
Active 5 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
29 freelancers are bidding on average $510 USD for this job
User Avatar
Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java, ReactJS) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards
$555 USD in 10 days
5.0 (243 reviews)
8.7
8.7
User Avatar
Expert in making database. Let us discuss and move ahead. I am ready to start. Please reply so that we can move ahead.
$2,222 USD in 10 days
5.0 (140 reviews)
8.1
8.1
User Avatar
Odinson I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Database Programming, Excel, Microsoft Access, PHP. Please ping me for more discussion.
$500 USD in 8 days
4.9 (362 reviews)
8.1
8.1
User Avatar
Odinson Hello! I think this is a good idea to go with the database for this and, specifically, with Microsoft Access for few reasons: it can handle such data very well, it has Outlook integration through the object model and it is a fast development tool. Now, I am looking into the data and the list of request. Can you please explain 1 and 2 using the real data? As for an estimate, I think this is doable within 3 and up to 5 days (depending on the rest of requests) and as a minimum of 20 hours of work to make it right and perfect tool. For more details please start the chat! Regards, Branislav Mihaljev MS Access MVP 2008, 2009
$488 USD in 10 days
5.0 (313 reviews)
7.6
7.6
User Avatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$538 USD in 5 days
4.9 (158 reviews)
7.6
7.6
User Avatar
Odinson Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel. I plan to use VBA code to accomplish this. The output CSV files will be generated by pressing a button for all of them or a single button for each. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $500 and can deliver within a week (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$500 USD in 7 days
4.9 (281 reviews)
7.6
7.6
User Avatar
I did some projects which extract and clean up double details including names, similar address emails and more. Also, I have the knowledge to send emails from lists in Microsoft Excel via Microsoft Outlook. I want to suggest to you a Microsoft Excel application on your Excel module which enables you to conduct the entities and their status in a structured database. The app allows you to open/edit/delete entities/status (in forms). During the updating, Excel validates the information and prepares reports, documents and charts based on the needed parameters and criteria. There is a report generator which enables to develop template reports independently. The files are secured by login form with a database of usernames and passwords. About Me: I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules with incorporate complex components of business in a simplified and logical manner.
$750 USD in 10 days
4.9 (87 reviews)
7.1
7.1
User Avatar
Odinson. Dear Customer! I am an expert PHP developer with over 15 years of experience and very interested to work on your project. Ready to begin immediately and complete as soon as possible. Please contact to discuss details if you are interested. Best Regards.
$500 USD in 10 days
4.5 (181 reviews)
7.4
7.4
User Avatar
Odinson Hello, Let me get right into this. We use databases to store data that we want to have direct remote access to, something that allows us to have multiple "users" that can select, insert, update and delete data as fast as possible. That's what a database is for. Each database contains multiple tables which contains multiple columns, these columns have types, values and indexes. Once these are created, they're barely ever edited, so our job here is to make sure we think about this for the long run, to create something that, even if not used now, might be used in the future. Finally we can "easily" import your data to the database. Everything else you mentioned though, such as sending emails and the import/export process itself aren't a feature of any database system (MySql, MariaDB, PostgreSql, etc). The database is just for storage, we're also gonna need to create a "tool", could be a web based one using PHP/HTML5 or a a local one using any programming language, which will then access the Database, do the necessary operations to "select" the clients and then send them an email, for example. I know I talked too much about this but I think it's necessary you understand the process to. Now my job would be to make sure that ALL OF THIS is perfectly built and, with all humility, that's what I do and I'm very good at it... I've handled big projects before, even here on Freelancer, check my reviews out, let me handle this. Thanks for reading, Mario Adabachy.
$750 USD in 10 days
5.0 (13 reviews)
6.2
6.2
User Avatar
Hi. i am a full web developer with over 5 years on freelancer.com. I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Thanks. Best Regard
$300 USD in 10 days
4.9 (47 reviews)
6.1
6.1
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$444 USD in 4 days
4.6 (126 reviews)
6.5
6.5
User Avatar
Odinson I have excellent command on MS Access and VBA and create the database as per your requirements in 8-10 working days. In addition to creating databases from scratch, I have also completed complex projects in Access VBA before . For instance - Buy and sell bitcoins automatically on Coinfloor and GDAX using respective APIs based on an algorithm - Get Amazon prices and store them in database tables periodically - Get daily orders from Amazon and update the changes in existing orders present in the database. You can see the reviews of the same in my profile. Thanks, Archana
$450 USD in 10 days
4.8 (98 reviews)
6.0
6.0
User Avatar
INTRODUCTION I can see you are interested in building database application to manage people and your business processes. I have read your attached Sample document. I can develop this database together with other specified business intelligence searches and lookup integrations. I am smart enough to take your business requirements and work to reflect the intent of your requirements. I can also provide demo in case you want to see demonstration of your project concepts before you award the project. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/website-design/database-design-link-site/ • https://www.freelancer.com/jobs/project-15444898/ • https://www.freelancer.com/projects/mysql/review-database-model-for-survey/ • https://www.freelancer.com/projects/sql/human-resources-database-creation/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$400 USD in 10 days
4.8 (31 reviews)
6.1
6.1
User Avatar
HI SIR I AM MAINTAIN YOUR DATA LIST AS YOU NEEDED IN EXCEL SHEET AND WORK FOR YOU ON THE TIME WE DISCUSS MORE WITH SAMPLE THANKS Odinson
$750 USD in 10 days
4.9 (25 reviews)
5.6
5.6
User Avatar
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. I accept only once you are fully satisfied with the work done. Looking forward to work with you
$250 USD in 5 days
4.9 (37 reviews)
5.5
5.5
User Avatar
Odinson Hello I am wondering if we can filter for the word "LLC" in the owners name and differentiate Business from owners? I have a plenty of experience with Excel automation using Python and I think I can help. We can also port this to SQL and run PHP if you want to. Please send me a message. Looking forward to working on this one. Background: Software developer by profession having 7+ years of experience in C, C++, Python and other scripting languages for automation. I have worked on RESTful APIs as well.
$250 USD in 3 days
5.0 (18 reviews)
4.8
4.8
User Avatar
Odinson Hi I am able to make Wordpress website where you can import all your data and apply rules on them. I am 5+ years experienced web developer and sure able to do this. can you please chat with me so we can discuss.? Thanks
$500 USD in 12 days
5.0 (22 reviews)
5.0
5.0
User Avatar
I have 7+ years of experience in Web Development in the multiple technologies and industries. I have a team with high level skills in cutting edge Web Technologies and we always go by our principle of professionalism and perfection. Custom Website Development E-Commerce Website Development Business promotional Websites Business promotional Websites Integration of APIs Bug Fixings Deployments (Php + Node + Angular) Database Designs PSD to Html Restful API creation CMS (Content Management System)
$277 USD in 10 days
4.4 (22 reviews)
5.2
5.2
User Avatar
(Odinson) Dear Sir we read your task and we can deliver it with quality. please award us project so we can start working on this Best Regards! Veer Singh
$333 USD in 2 days
4.8 (36 reviews)
4.7
4.7
User Avatar
Odinson Hi there, My name is Lucian and I am an implementation engineer. I work daily with google app scripts and google sheets formulas on my job and I have done here few amazing projects. I can automate all this by creating a script in google sheets if we have a good set of riles, you ca reuse it any time. Hope to hear from you soon. I will do this in max 3 days. Best wishes, Lucian
$250 USD in 3 days
5.0 (6 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
Aldie, United States
4.8
4
Payment method verified
Member since May 17, 2015

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.