login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Access/VB/MS SQL Developer - Long Term Relationship

Bids 
114
Avg Bid
N/A
CLOSED
  • Project ID:

    220414
  • Project Type:

    Fixed
  • Budget:

    $750-$1500 USD

Project Description:

We are an benefits administration company, which is looking for a long term relationship with an Access/VB/MS SQL developer/expert. Expert, being the keyword.

We have an Access Database that has grown with the company. It is over 150 tables, 500 queries, 150 forms, and 200+ reports. The application has served us well, and continues to serve us well. The database has grown to 200MB and the number of users and records are starting to impact performance.

Phase 1
Migrate to MS SQL, maintain the same functionality we currently have. Forms, Reports, and Queries need to continue to work.

Phase 2
Couple of enhancements to the current application.
Implement SQL reporting services or similar program to offload reporting and automate the process..
Correct the code so that some of the data entry problems we currently experience are filtered and corrected before they get into the database.
Simple queries to help normalize the data.
Minor fixes and some automation.

Phase 3
Write a new application on MS SQL. New application will have better integration with 3rd party systems (xml), and provide web access to our clients to view benefit and insurance claim information (.net).

That gives you an idea of the long term relationship we are looking for. We are looking for responses on PHASE 1 ONLY AT THIS POINT.

Please provide references, experience, and examples of work if possible. Preference will be given to those that can communicate how they have supported clients on a long term relationship and someone that could communicate how they would work with us in a long term relationship.

Skills required:

.NET, ASP, Visual Basic, Web Security, XML

Project posted by:

russew United States
(9 Reviews)

Last seen:

Public Clarification Board

6 messages

  • amirquddus

    I've experience in the reference of work which you want to develop. Here is my resume, Consider me kindly.

    Attachment: Resume3.rtf

    over 4 years ago

  • Slavairon

    What version of MS SQL Server used by programming? Applicantion can build by ASP.Net 2.0?

    over 4 years ago

  • ananno

    Sir,

    I've read your proposal and i intened to inform you that we have a software company CRITH, and we delivered software like this but not so large. I understand your proposal and we can done it. We have a team of 5 programmers. So, not to worry about that...

    As your request, here is our acceptance of your proposal...please consider us to serve you a quality product...
    Other terms can be discussed if you select us...
    --------
    Thank you...

    over 4 years ago

  • HansYadav

    Sir, we have good experience in webservices,wcf services, and security and will do it.

    over 4 years ago

  • kashifahmar

    Dear Sir, I have read carefully message board on project and i agreed all the terms and condition. Plaese PM me for any clarifcation from mine side.

    over 4 years ago

  • russew

    The number of bids is overwhelming so here are some clarifications based on questions that we have received.

    What is our criteria for selection.

    1. Long term partner, that will work with us through elance.com
    2. Ability to help us select the right project. Current app is MS Access with VB Script, Future direction is VB in house and limited web based access for clients. We have laid out our plan, but if a better one exists we are open to discussion.
    3. More than one programmer, a company not an individual.
    4. Ability to support the application during US business hours.
    5. Jobs are done on time, on budget.
    6. No bait and switch, if the job can't be done for the price we agree to, don't accept the job.

    The current application is in Microsoft Access, it is NOT a VB application. There are 200+tables, 200+reports, 50+Queries, and 200+forms with a bunch of VBScript which makes it an application.

    There are 12 users on the current system and thousands of records which make the database 200MB compressed.

    The company is a Benefits Administration company. Meaning, we provide services to US companies to manage the health, dental, medical, health saving accounts, vision, and any other benefits they provide their employees. This application tracks, companies, their employees, Plans, Employee Elections, Claims, Eligibility, and all items related to the benefits our US clients offer their employees. You will be working with a database that is full of bogus information due to US law. You will never have access to the live database once it is in use. Take this into account for the support requirements of the application.

    What version of MS SQL are we using, and would we be interested in utilizing Stored Procedures. We would probably like to use SQL 2005, and yes we are interested in stored procedures, or any other recommendation you might have which provides better performance, and a better platform for our future direction.

    How much VBScript code exists. Hard to quantify, but I ran the documentation wizard in Access and the report was 16,000 pages. Consider the number of tables, reports, and forms and the verbosity of the report.

    Would you like to stay in Access 2003 as the front end, or would you consider a VB application. We are open to either, consider the direction we are trying to go, support, long term relationship. If the current project is not the right direction in your estimation, please note that in your Post and we will take it into consideration.

    How do you want us to bid on a long term relationship. My preference would be that you bid on the current project, but in the PM put what a retainer amount would be to provide support for whatever project you are recommending on a monthly basis. Please consider the requirement for US hours of support.

    Several people have commented that the correct way to do this project is a 3-tier architecture. We are in agreement with that, we anticipated doing the current project as a quick fix to our performance issues and then working with someone to design and develop a system which reflects a 3-Tier Architecture.

    Finally, I found this on another post and decided to include it as our terms as well for this project and all ongoing work.

    1. The job can be delivered on time and on budget, with regular updates on the progress of work. During the development period, daily progress reports should be provided.
    2. I can see a working demo that shows all of the requested features before I make payment.
    3. We can do the money swap via getafreelancer escrow.
    4. You assure full confidentiality for the job and respect my intellectual property by not using any code or data I give you access to without my permission.
    5. All rights to the code are assigned to me, and no code is encrypted or obscured in any way.
    6. In providing any code you can make the assurance that no copyright or intellectual property rights are being infringed.
    7. The code is fully documented.

    I am asking for all those that are interested to please post a PM as to your acceptance/understanding to these changes. Those that do not post a PM referring to this clarification will be considered not interested in performing the work.

    over 4 years ago


If you are the project creator or one of the bidders, please Log In for more options.


Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

All Bids ()