Find Jobs
Hire Freelancers

Database creation

$30-250 USD

In Progress
Posted almost 8 years ago

$30-250 USD

Paid on delivery
Organised dataset with minimal cleaning required. Seeking a DB specialist to help with automating the cleaning & importing fresh data and establish new database. Data received in CSV format daily in multiple files. Relational tables required as well as calculated fields. Open to a platform. Looking at Azure but again open to ideas but reporting and automation is a must. Once created would like to automate a report. All quite simple for the person with the right skills.
Project ID: 10506724

About the project

14 proposals
Remote project
Active 8 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
14 freelancers are bidding on average $204 USD for this job
User Avatar
Hi there. Your project seems very interesting and challenging. I am a database expert with experience working with Excel and VBA macros. I would suggest to create a macro able to include data from other csv files and to report the information you need. Hope to hear back. Thanks
$189 USD in 3 days
4.9 (26 reviews)
5.3
5.3
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$150 USD in 3 days
5.0 (42 reviews)
5.4
5.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$250 USD in 10 days
4.7 (41 reviews)
5.0
5.0
User Avatar
You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.
$250 USD in 10 days
5.0 (5 reviews)
3.6
3.6
User Avatar
Hi, I will provide you with a tool to help you import the raw data from csv files into a relational database. The relational DB will be access and the tool will be built using Access and VBA. Please have a look at my portfolio and contact me if you need further details. Best Regards Ahmed
$444 USD in 10 days
4.8 (7 reviews)
3.9
3.9
User Avatar
Hello I am Hema, having 10 years experience in software development. Worked on various database projects on Oracle , MS SQL Server, MYSQL and POSTGRESQL. I am passionate working on database programming especially Oracle. I am a very quick learner and easily adapts to client's requirements. Very dedicated and sticks to deadlines. Please reach out for any questions. Looking forward to hear from you.
$160 USD in 3 days
5.0 (1 review)
2.4
2.4
User Avatar
hi.i have experience in ms access. My skill set range from database design and creation(including database structure), access objects such as queries,reports,forms,custom functions etc. please feel free to approach me for further assistance, i will give you feedback on project asap. kind regards enrico
$100 USD in 3 days
4.6 (3 reviews)
2.1
2.1
User Avatar
Hi, My name is shanalal. I have 8+ yr experience in software and Database development . Also, I have 2+ yr experience in the azure platform. I am interested in your project
$155 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$111 USD in 2 days
4.2 (1 review)
1.0
1.0
User Avatar
I am a software consultant based out of Toronto, Canada with 11 yrs experience in enterprise development within the loyalty , financial and telecom industries. Would love an opportunity to work on this solution. Quite a few different ways of tackling this particular problem - much of which could be solved using alot of open source frameworks in availability that are perfect for this type of batch type processing. Please PM if interested
$255 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
You mentioned Azure platform (Cloud), suggesting that you are going to use MS SQL server. I am familiar with MS SQL Server and I can help you in this case. Thank you and Regards.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been doing ETL work for the past 10 years, This should be pretty normal operation. I prefer SQL server but I am willing to work with AZURE if you have the server set up. If you have any questions feel free to message me.
$175 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have extensive experience as a Data Warehouse developer, and I know the challenges of automating the import and cleansing of CSV files into a data warehouse or relational data source. For this project, I can develop an ETL (Extract, Transform and Load) job using a productivity tool such as Talend for Data Integration. This job will take care of processing CSV files and loading data into target database. Deliverable is a packaged Java program that can be scheduled or run on demand. I also read your update, so this is what I recommend for each of your needs: * Staging database for CSV files plus Target database with Horses table (useful to clean/import horse's data only once) and analytical tables (same as hidden pivot tables in Excel example) ready for consumption. - Best practice for structuring, maintaining and housing the data - Centralise and consolidation of information * ETL job used to import/clean/format CSV files and load them into staging area. - Simplified way of importing fresh data daily: - Simplified way of scrubbing and formatting data: * ETL job used to load Horses and analytical tables, and also implement calculated fields logic. - Auto calculated fields as new data is fed in * Excel can connect to SQL target database and pull analytical tables. - Ability to run a report to pull pertinent information to populate dashboard in excel For target database, I suggest using SQL Database from Azure. Look forward to hearing from you. Kind regards
$240 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am 12+ years experienced HTML,CSS,Php,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,SharePoint,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
5.0
1
Member since Aug 14, 2009

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.