• Develop and maintain financial models to project key performance indicators including occupancy, revenue, operating expenses, net operating income and capital expenditures using current and past trends• Monitor and analyze actual financial results and investigate causes of variances to budget, presenting findings and insights to management• Perform ad hoc financial analysis and assist with other projects as needed

• Enhanced AT&T invoice projection by refining subscriber projection method and using cost-based metrics, resulting in increased projection accuracy• Conducted financial analysis and NPV assessment for 5G network buildout, saving DISH $490K by reducing labor head count and capital expenditures for 5G cell tower equipment production• Created a pricing model for the Senior VP of Finance to select software for accurate revenue recognition for Boost Infinite device financing customers to be in line with GAAP • Led monthly presentation to CFO on impact of cryptocurrency payment strategies on brand equity, simplifying complex concepts and delivering insights to the entire finance department

• Created a database of closed homes and used pivot tables to gauge key financial metrics for each community such as revenue, gross profit and net income • Maintained backlog report of sold homes, and generated weekly operational reports in Excel for the VP of Finance that kept track of sales, foundation starts and closings, as well as measured progress toward monthly, quarterly and annual goals• Performed monthly variance analysis of budgeted versus actual operating expenses in order to assist the accounting department with income statement reconciliation• Periodically researched the Colorado housing market and crafted comprehensive monthly presentations for the VP of Finance that provided updates and offered insights into building material costs, housing demand, interest rates, macroeconomic trends and land costs

• Created an Excel loan pricing model to calculate loan profitability and ROI based on loan terms and other bank fees generated• Completed accurate financial statement spreads and performed covenant tests to verify borrowers’ performance against requirements in loan documents• Tracked the receipt of customers’ financial reporting requirements and maintained communication with Relationship Managers and Portfolio Managers regarding customers’ compliance with all loan requirements and covenants• Assisted Portfolio Managers with credit authorizations and supporting documentation for loan approvals

• Performed comparable analysis and helped build client network by connecting with local real estate agents through cold calls to inquire about property specifications and prices• Conducted research on the trends of the increasing demand in the housing market and supply chain shortages, and generated market reports for the chief appraiser