Web-Based Hotel Market Database & Reporting Tool

Posted last week

Only freelancers located in the U.S. may apply.U.S. located freelancers only

Summary

I am looking for a developer to build a simple web-based database and reporting tool to replace an existing Microsoft Access database with a lot of history. The current database tracks monthly hotel market performance for 100+ hotels over approximately 10-15 years (3 data metrics for each hotel on a monthly basis). Currently, each hotel has a profile with fields such as: - Hotel name / ID - Submarket - Room count - Price point Each hotel submits monthly performance records, including: 1. Month / year 2. Rooms available 3. Rooms occupied 4. Room revenue The system calculates: - Occupancy (#3 / #4) - ADR (#4 / #3) - RevPAR (#4 / #2) - All of the above monthly and YTD ** I need a secure, web-based database built that allows me to: - Maintain hotel profiles - Add or edit monthly hotel performance data - Import monthly data from Excel or CSV - Run pre-formatted reports to include the full market, filtered by hotel characteristics, including submarket, price point, and hotel size - Export reports to Excel and/or PDF - Preserve historical data - Support future duplication for other markets Reports should summarize monthly, year-to-date, and historical performance for: - Total market - Selected submarkets - Selected price points - Selected hotel size categories This does not need to be a large SaaS platform. I am looking for a clean, practical web-based database with simple data entry, import, filtering, reporting, and export functionality. The first version should be simple and functional. More advanced features can be added later. Please respond if you have experience with: - Web-based database development - Microsoft Access database migration - SQL database design - Admin dashboards - CSV/Excel imports - Report generation - Basic data visualization - Secure/confidential data handling Please include examples of similar small database/reporting tools you have built. ** CURRENT REPORT/OUTPUT IS ATTACHED (lots of room for improvement)

  • $600.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Database Architecture
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:last week
  • Interviewing:
    1
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Aug 1, 2025
  • USA
    Winchester4:32 AM
  • $150 total spent
    1 hire, 0 active

Explore similar jobs on Upwork

Software DeveloperHourly‐ Posted 8 months ago
ASP.NET MVC
Django
Python
AngularJS
JavaScript
jQuery
WordPress
Google Chrome Extension
React
CRM Development
Microsoft Dynamics 365
Microsoft Dynamics CRM
Microsoft Dynamics Development
Microsoft PowerApps
Single Sign-On
Three.js
JavaScript
WordPress
AR Plugin
WooCommerce
3D Modeling

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo