Professonal Database Construction - well payed

jobs hiring
1

All work must be of professional quality! And must be completed in a timely manner. If you are interested contact me ASAP at:

[email protected]

Here is an outline of the project…

CENTRUM ONLINE PROJECT DATABASE

IDEA: Create an online database accessible by login with restrictive access to certain parts of the information, that will maintain and report traffic, unit, contract, customer and construction information.

TIMEFRAME: We are looking at an immediate need for this technology. The sooner it is put into use, the better. We have 2 projects opening in 3 weeks, and would like to put them in a database as soon as possible, as to reduce redundant work.

COST: We are looking to dedicate around $30,000.

TECHNOLOGIES APPLIED: We like the way a system functions under the following framework, but would be open to other suggestions: Microsoft .NET framework (ASP.NET, VB.NET), Microsoft SQL Server, COM, COM, Windows 2000 Advanced Server, Microsoft Internet Information Server (IIS), XML, XSLT, AT&T Frame Relay.

INFORMATIONAL NEEDS FOR THIS PROJECT:
WEB ACCESS
DATABASE
Unit Information
Traffic Information
Contract Information
Customer Information
Construction Information
CONTRACT GENERATION
REPORTS
QUERIES

GENERAL OUTLINE OF WHAT IS NEEDED-

WEB ACCESS
a. Access by Web Browser
The Database needs to be accessible by web browser, from any location.
b. Login Restrictions
Need to have restricted access to this information as it is very sensitive
c. Restricted Access to Certain Information
Not everybody is to have full access to all information. Permissions will vary person to person.

DATABASE (The following is a list of the information we would need to track)
d. Unit Information

  1. Unit Number
  2. Unit Pricing
  3. Square footage
  4. Outdoor square footage
  5. Ownership Percentage
  6. Assesments
  7. Taxes
  8. Floor
  9. Floorplan
  10. View

  11. Bedrooms

  12. Bathrooms

  13. Family Room

  14. Den

  15. Finish Level
  16. Amenities
  17. Parking Space(s)
    a. Building
  18. Floorplan Upgrade
  19. Storage Space

e. Traffic Information

  1. Date of Visit
  2. Name(s)
  3. Address
  4. Street
  5. City
  6. State
  7. Zip
  8. Phone
  9. Home
  10. Work
  11. Email address
  12. Demographics
  13. Source
  14. Bedrooms
  15. Move date
  16. Price Range
  17. Ownership

f. Contract Information

  1. Customer
  2. Name
  3. Address
  4. Phone
    a. Fax
  5. Email
  6. SSN
  7. Unit #
  8. Amenities purchased (Parking/Storage/Floorplan)
  9. Space #
  10. Location
  11. Price
  12. Milestones/Dates
  13. Contract date
  14. Contract approval date
  15. Attorney approval date
  16. Mortgage contingency date
  17. Drop dead date
  18. Estimate closing date
  19. Actual closing date
  20. Broker
  21. Broker name
  22. Broker Agency
  23. Agency address
  24. Agency phone/fax/email
  25. Broker MLS#
  26. Agency MLS#
  27. Broker Commission rate
  28. Broker incentives received
  29. Attorney
  30. Attorney name
  31. Attorney address
  32. Attorney phone/fax/email
  33. Monies
  34. Deposit
    a. Amount due
    b. Amount received
    c. Date received
  35. Installment(s)
    a. Amount due
    b. Amount received
    c. Date due
    d. Date received
  36. Promssory Note
    a. Amount due
    b. Amount received
    c. Date due
    d. Date received
  37. House Salesperson(s)
  38. Name(s)
  39. Credits
  40. Upgrades at close
    a. Monetary amount
    b. Specific items (W/D, balcony…)
  41. Employee credit
  42. Referral credit
  43. Recessions
  44. Unit
  45. Customer
  46. Date
  47. Reason

g. Construction Information (TBD)

  1. Milestones
  2. Selections

CONTRACTS
h. Contract Generation (fills in merge fields from the legal contract)
i. Including Riders

REPORTS
j. Sales Summary

  1. Traffic by source
  2. Contract Activity for the last 7 days
  3. Contracts prior
  4. Contracts written
  5. Contracts rescinded
  6. Total contracts
  7. Contract by type
  8. Reservations outstanding (#/$)
  9. Contracts under review (#/$)
  10. Contracts binding (#/$)
  11. Total units purchased (#/$)
  12. Total garages purchased (#/$)
  13. Total both unit and garage price (#/$)
  14. Total Units
  15. Units Sold (#)
  16. Units Unsold (#)
  17. Breakdown by Bedroom
  18. Total (#/$/%)
  19. Sold (#/$/%)
  20. Available (#/$/%)
  21. Breakdown by View
  22. Total (#/$/%)
  23. Sold (#/$/%)
  24. Available (#/$/%)
  25. Breakdown by Floorplan
  26. Total (#/$/%)
  27. Sold (#/$/%)
  28. Available (#/$/%)
  29. Breakdown by phase/building
  30. Total (#/$/%)
  31. Sold (#/$/%)
  32. Available (#/$/%)
  33. Note field

k. Sales Report (TBD)

l. Customer Report (TBD)

m. Traffic Report

  1. Traffic from past week
  2. Date
  3. Name
  4. Address
  5. Phone
  6. House salesperson
  7. Rating
  8. Source
  9. Price range
  10. Bedrooms needed
  11. Comments

n. Letters

  1. Thank you card (traffic)
  2. Contract to Attorney
  3. Congrats/Contract to Buyer
  4. Memo to Attorney
  5. Memo to Bank
  6. Earnest Money request to BuyeR

o. MISC. reports to be determined at later date.

QUERIES
p. Need the ability to select any criteria and view it online.