John Harmon Email & Phone Number

Memphis, Tn, Us

Memphis, Tn, Us

Telluride, Colorado, Us

- Head of Revenue and member of the management team; responsible for forecasting and development of long-term revenue strategy, driving informed board decisions.- Leader of the Booking Operations Team, a multi-departmental team focused on guest lead generation and bookings, driving execution of c-suite vision for guest-facing revenue generation through emphasis on interdepartmental communication and goal alignment. The team develops and regularly adjusts the pricing and revenue strategy for 115-150 luxury vacation rental properties in 6 distinct markets. - Responsible for identifying, developing and tracking various KPIs while continuously challenging the status quo and developing new marketing and pricing strategies to drive between $8MM and $10MM in annual booked accommodations revenue.- Responsible for approval of all prospective home additions, with focus on location, product quality and overall revenue potential.

Telluride, Colorado, Us

- Developed, launched and drove adoption of all data warehousing, reporting and dashboarding across all departments. Designed, built and maintained PostgreSQL / MS Access / Power BI ETL, data warehouse and visualization stack. - Built the company’s first-ever dynamic revenue and cash forecasting tools, which are used daily to continually guide evolving company-wide initiatives. Work directly with finance leaders and 3rd party accounting firm to inform the P&L / Balance Sheet. - Developed the company’s owner-facing revenue projection tool, while regularly training and coaching regional growth-focused sales teams, which have signed over 200 new units since inception.- Responsible for approval of all prospective home additions, with focus on location, product quality and overall revenue potential. - Designed and built commissions payout system for sales team and broker partnership program. - Assisted with tracking of operational costs through related dashboarding and distribution to field operations teams.- Built portions of and advised on broader development of fundraising financial model, including working directly with M&A advisory firm during fundraising activities.

Broomfield, Colorado, Us

Primary Duties: Assist with monthly close process, including coordination with accounting teams to better understand monthly financial results. Calculate and provide cost allocations by product to Margin Accounting & Reporting team to ensure correct monthly network expense bookings. Translate booked financial results for use in monthly revenue, expense and margin forecasts. Invoice-to-accrual gap analysis. Scenario modeling, forecast variance and ad hoc financial analysis in support of product management team. Evaluation and modification of forecasted revenue, expense and margin based on accounting policy changes and varying operational conditions.Accomplishments: Created/implemented first ever SQL-based customer margin reporting for International Long Distance product. Collaborated with Margin Accounting & Reporting team to improve accuracy of accrual adjustment process. Improved forecast accuracy of planned cost savings initiatives through joint analysis with Cost Planning & Validation team. Regularly modified network expense and margin forecasts based on changes to accounting policies and procedures. Modified cost allocation process to ensure accurate booking of network expenses.

Primary Duties: Budgeting and forecasting Net Operating Income (NOI) for portfolio of approximately 160 luxury multifamily rental communities using Hyperion Planning and Essbase platforms. Scenario modeling, budget variance and ad hoc financial analysis for Senior Management, including C-Level Executives. Evaluation and modification of budgeted revenue, expense and NOI. Hyperion Planning and Essbase administration.Accomplishments: Assisted with creation of company-wide 2013 operating budget and 5-year plan, provided various ad hoc analyses for proposed Initial Public Offering and related SEC filings, coordinated with Accounting team to create budgets for over 50 joint venture properties during 2013 budget cycle, created a 5-year operational staffing needs assessment, hosted over 20 web-based Planning training seminars for operators, assisted with creation of 2013 rent and occupancy seasonality model, and regularly produced market-level revenue, expense and NOI growth rate reports.

Primary Duties: Creation, review and modification of operating income and expense models for existing and proposed multifamily rental properties and developments financed primarily through the federal Low Income Housing Tax Credit (LIHTC) program, as well as the USDA Section 515 Rural Rental Housing program, local Tax Increment Financing (TIF) and conventional sources. Many developments also utilized the HUD Section 8 Housing Choice Voucher (HCV) and/or project-based rental assistance (PBRA) programs. Demographic and economic research, analysis and forecasting. Short-, medium- and long-term forecasting of market conditions in real estate markets throughout the country.Additional Duties: Project-specific modification recommendations for developers and lenders based on local market conditions. Assisting clients (including tax credit syndicators Wachovia/Wells Fargo, Boston Capital, Centerline Capital and RBC) with various underwriting needs, including creation and evaluation of pro forma operating income and expense models, NPV/IRR-based analyses, as well as zoning, easement and property tax research.Accomplishments: Conducted or directed original research and production of over 500 multifamily operating forecasts nationwide. Directly managed and trained up to three entry-level real estate analysts at any given time. Completed several general economic and housing needs assessments in communities experiencing economic and demographic changes.

Conducted physical site/property assessments and field research for proposed developments and rehabilitations. Created preliminary operating models and forecasts, as well as market feasibility analyses for approximately 200 multifamily projects throughout the country. Additional duties included ad hoc market research, analysis and forecasting projects.