See the attachments for further details for this project beyond the brief description. More files will be uploaded shortly including some wireframes depicting the use of this system.
*Note this is a two part project. Web development for this project has been posted under a different project. Preference will be given to those who can handle both parts of this project. To bid on the web-dev. portion, search "Server Side DB System Web Development". It should be up within 12hrs of this project being posted.
Alright, here's the project:
Build a server side database solution that can:
1A. Clean customer database files from various sources (automotive industry DMSs). These files will be uploaded through an online client portal in cvs, xml, or some other db file format. There are up-to 5 different file types/formats that will be uploaded. I will have samples of each for the winning bidder.
1B. Scripts should be used to auto convert these data files to a uniform output format.
2. Combine the cleaned tables with additional database info from both static DB files (postal Codes) and dynamic tables (vehicle trade in value) that will be pulled from various sources - Canada Blackbook, etc.
3. Run specified queries against combined data and output client lists based on specific criteria. Some queries will simply be "sort" function to seperate a particular vehicle type (ie. All customers that drive a Jeep), some will be need to be sortable based on multiple criteria (ie. all customers with a Jeep, purchased between 2008-2010), and some queries will need to utilize equations to create customer lists from the data files (ie. Equity Scrapes, trade in value vs. new vehicle cost, etc.). There will be approx 10 different functions that will allow for different report outputs.
4. New lists will need to be formatted in multiple way with specific field output formats for sending to printer and direct mail company for marketing campaigns. Reports must also be accessible within client portal for future reference.
We are looking to start this project ASAP and want to have it completed within 10-12 weeks and have beta testing within 8-10 weeks. I will handle all communication between any integration points or API systems that need to be included.
This is phase one of the project and winning freelancer will have opportunity to do continued work (version 2, 3, etc.) based on project outcome.
In your bid include the following to save time on finding the right freelancer:
-Cost of scope creep if project outline changes mid project
-Your experience with creating DB software solutions similar to this (examples are best)
-Expected timeframe (do not say 3-5 days)
-Your process if you have a formal one
-Anything that sets you apart from the rest
-Your milestones and payment required for each.