Jonathan Wallace Email & Phone Number

Plano, TX, US

Dallas, Texas, US

Dallas, TX, US

• Updated financial models with actuals and operational market curves (power pricing & gas data) forecasts to drive upper management decisions
• Review of wire timing amongst accounts related to security deposit and credit agreements
• M&A due diligence
• Debt & operating draw cash waterfall planning of inflows/outflows related to credit agreement - debt service coverage ratio (DSCR)
• Asset management of two power plants
• LP investor package updates with most recent financial data

Dallas, TX, US

Worked on pricing model analysis and input uploads to Salesforce.

Plano, Texas, US

Contractor

Dallas, TX, US

• Rebuilt corporate cash model to project NOI, FFO and AFFO for REIT structure
• Built budget templates and worked with C-suite executives on planning phase and review of payroll and operating expense budgets
• Built portfolio actuals to budget for investment banks and constantly ensured accuracy with any budget changes
• Developed home office variance analysis on expenses
• Collaborate with acquisition team and others to build a quantitative, market-based approach to establishing cap rate methodology which ultimately factors into NAV (Net Asset Value) calculation and valuation of portfolio
• Automation of financial reports and AR reserve out of different software reporting systems at marinas

Coppell, Texas, US

• Served as the key financial point of contact for operational leadership across all business units
• Extensive revenue and pricing analysis – managed Access database, pricing tables by LOB (line of business), revenue service type, detailed customer analysis models (monthly and YTD views of transactions, revenue.
• Helped prepare analytical presentations and other financial and strategic solutions for leadership such as; month-end reporting on monthly, YTD and prior year comparable income statement analysis for the field finance.
• Enhanced and completely automated the refresh of SmartView/Essbase reports via macros and SmartView using VBA. LOB, Operating Profit Margin, forecast variance analysis for the field, district rollup details and revenue.
• Gathered and submitted fixed asset journal entries; capitalizing pre-paid & amortization
• Performed miscellaneous financial analyses to identify and support business opportunities

Plano, TX, US

• Created and biannually updated a store refresh cycle model with dashboard (scenario analysis and charts) to aide in the selection of FedEx Office sites to be remodeled by fiscal year based on numerous financial metrics.
• Assisted with development and implementation of department policies, procedures, standards and framework
• Provided regular detailed reporting & metrics existing project pipeline, resource allocation, project status completion statistics, variances to budget & forecasting
• Developed numerous automated tools in Excel via VBA to aide in closeouts of open PO’s, document tracking by milestone dates (internal control), project kick-off call application linked to Outlook calendars, capital.
• Provided assistance developing new processes and measurement tools to ensure overall pipeline success
• Worked with VP and MD’s on department presentations to senior management

• Reported directly to Corporate Training Manager of FedEx Office Corporate (North America and Canada) in Learning and Development department
• Reported on company-wide training requirements through Learning Management System (LMS); weekly compliance and curriculum trackers
• Heavy use of Excel with Pivot Tables, VLOOKUP, INDEX/MATCH combination, IF statements, Data Validation, Macros (to automate processes), and various other functions
• Developed & assembled spreadsheets and PowerPoint files for Managing Directors FY16 budget presentation to CEO
• Organization and assistance of coordination for FSO and Plano corporate training
• Collaborated with Learning Management Systems’ Admin to respond to incoming inquiries from the field operations

Irving, TX, US

• Data analysis and reporting on medical equipment quotes, specifically capital.

Plano, Texas, US

• Created Pivot Table reports in Ad Hoc format for Billing manager and business owner (utilizing Pivot Table, GETPIVOTDATA function and Data Validation drop-down for interactive “real-time” reports)
• Administered Dell KACE ERP system with assistant mgr. and billing department manager
• Billed patients for equipment not returned (charged their account, printed and mailed statement) thru AdvancedMD billing software

• Product Partner Compliance – Maintained business requirements & documentation; Purchase Order Reports: Cancellations, Maintenance, DTS. Maintained email inbox; responded directly to all vendor inquiries
• MSS Group – SKU Creation/Maintenance; Nested Sets, GRS Add/Deletes & PO Management; Ship Window Changes, Port Changes, Un-Cancel PO’s, Receive DTS Orders
• Worked closely with accounting to send remittance and answer chargeback questions

Plano, TX, US

• Primary point of contact for key dental and sleep physician accounts
• Marketing assistant to VP/offered Marketing Research Manager position but VP left and company restructured – temporarily worked the role while not an official job title, project management assignments given with little.
• Managed various parts of the country; incoming calls, outbound calls, pushing ad campaigns, tracking data of US territories, and working with upper management on increasing sales

• Building direct relationships (prospecting) within my network to evaluate their needs for life insurance or a perspective on financial planning