We are collecting data (CSV files) on trips driven in passenger vehicles and we currently do our analysis in Excel. This is laborious and the resulting files are too big for Excel. Your job is to take the CSV file and the tasks performed in Excel and transform it into a robust MySQL database, which we can administer and improve as needed.
Skills: mysql programming
“ I hired Rvor to build a MySQL database. The job involved pulling in CSV files, dealing with data outliers, adding some computed variables, and outputting the data in several flat files. He seemed to be progressing well at the beginning, then progress slowed down, the contract end date passed and, in the end, the project was going backwards with older code replacing newer code. The delays were especially frustrating since he originally bid $350 and said he'd complete it in 3 weeks. I added $150 to his original bid and we executed a one-month contract for $500.
The one-month contract was supposed to end on Nov 22, and he assured me on numerous occasions that he was almost done. Finally, after missing yet another deadline, on Jan 12th, I informed him that I was going to find someone else to finish the job. I'm not sure why he performed so poorly. Part of the reason I chose him was due to his excellent Elance ratings by previous clients. My guess is that he got busy with other work or just didn't know how to do some of it. I have lots emails documenting his failure to answer questions and my increasing dissatisfaction with his performance. One example was code that was supposed to put data into mutually exclusive categories. Categories were supposed to go from 1 to 5, 6 to 10, 11 to 15, etc. Rvor put the categories as 1 to 5, 5 to 10, 10 to 15, breaking the cardinal rule of having mutually exclusive categories. This is an easy mistake to make; however, I asked him to fix it in a series of emails that I sent him over several weeks and he never fixed it.
Another repeated issue was more serious. Several times he admitted to uploading the wrong code for me to review. I spent countless hours trying to figure out why things were not working and why previous problems were not reflected in the new code, only to find that he uploaded the wrong files. In fact, the source code he sent me when I cancelled the job was not the latest version.”