Web-Based Hotel Market Database & Reporting Tool

Posted 3 weeks ago

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:3 weeks ago
  • Interviewing:
    1
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Aug 1, 2025
  • USA
    Winchester7:19 AM
  • $150 total spent
    1 hire, 0 active

Explore similar jobs on Upwork

JavaScript
Web Development
Android
WordPress
Web Design
PHP
HTML
HTML5
iOS
Graphic Design
Looking for iso26262 ExpertHourly‐ Posted 4 weeks ago
Data Entry
Social Media Marketing
Risk Analysis
HAZOP
Data Analysis
YouTube Development
Test Development
Risk Assessment
Analytical Presentation
Content Editing
HazID
Email Marketing Strategy
Social Media Optimization
Web Design

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