This project will require that an MS SQL database connection be made through VBA to INSERT, SELECT and UPDATE data from a SQL Azure Database. We currently have an Excel 2007/2010 Workbook which is used to calculate monthly payments for car dealers. The goal of this project is to provide our users the ability to save and then retrieve quotes they have done previously. Most of what we will be doing will be fairly straight forward; INSERT, SELECT, UPDATE (no DELETE for now), however there will be a few trickier pieces which we will need to deal with.
You will be responsible for the database design (please following my naming conventions and data type suggestions as closely as possible) based on the attached DatabaseSpec.xlsx. I am not a SQL programmer however I do have some experience with it, hence why I've made some suggestions around what I want to see done.
You will also be responsible to write all of the required VBA in order to make the required database connection and then the subsequent moving of information back and forth from the workbook to the database.
WHAT I AM LOOKING FOR: I want someone who is experienced in with SQL as well as VBA. You probably don't need to have done much, if any, work with SQL Azure as this is simply a cloud based SQL 2012 database offering. I want someone who can dedicate a fair bit of time to this over the next couple weeks so that we can hopefully have this project complete within 30 days. It is important that you have excellent communication skills. Please speak specifically to this project in your bid, do not reference a bunch of websites you've built, etc. Tell me why you will be the best candidate for this project.
Finally - I was a business analyst for a large software development company for 10 years - I am very experienced working with specification documents and communicating back and forth with developers. I can assure you that I will test the work you do for me quickly and will provide you detailed feedback to any issues I encounter.
Please read the attached [url removed, login to view] and [url removed, login to view] for more details on what the project entails. I will send the winning bidder the workbook which we will be getting and storing the values in. Please let me know if you have any questions.
16 freelancers are bidding on average $1378 for this job
VBA developer (with a heavy Insto trading and finance background with major banks and fund managers). I build professional solutions. Period. My pedigree in your PM. SteveP.
I am an experienced BI architect with considerable design and development experience, specifically around Information Management solutions. I am well-versed in MS SQL and VBA. Please see PM for further details
20+ Yrs. of experience developing IT Solutions using Microsoft Technologies. Expert in Excel-VBA and MS SQL 2000 to 2012. Created similar solution before a month.