Jonathan Wallace Email & Phone Number

Plano, Tx, Us

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• Oracle NetSuite and Solutions 7 Excel Add-In hierarchy and system use for financial reporting

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, profitability, credit memos, etc.)• 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 directors and senior field finance director; P&L forecast to actuals, forecast to plan, LOB reporting and deck (PowerPoint) automation generating P&L’s for all districts, markets and branches from Excel to PowerPoint for field branch managers, District VP’s, CFO and COO review• 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 report• Gathered and submitted fixed asset journal entries; capitalizing pre-paid & amortization• Performed miscellaneous financial analyses to identify and support business opportunities• Supported a wide variety of ad hoc analyses and initiatives from other departments (MP (Money Processing), ATM, CIT (Cash-In-Transit), CSF (CompuSafe) and Coin) and internal finance teams• Involvement and leadership of business unit and finance initiatives• Defined efficient solutions through improved processes and tools; revenue and customer trend analysis for rolling 13 months, automation of Waterfall chart in Excel to PowerPoint by district of actuals to plan with expenses shown • Financial Reporting Systems used; Hyperion products (Essbase, HFM, SmartView) & PeopleSoft Financials• Basic statistical modeling, MS Access SQL statements used and intermediate joins/multi-table relationships in queries

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 (+$50 mil in capital spending, 1800+ stores)• 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 expenditures to plan with advanced matching of change orders• 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• Developed net new General Contractor and vendor (supplier) analysis and scorecard metrics• Championed process improvements throughout the Real Estate department via Quality Driven Management principles

• 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 supervision with frequent deadlines. Managed distribution of emails to targeted customers and data gathering responsibilities. Weekly reports to upper management and national sales team weekly• 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