Business Development Fp A

CAMERON MACDONALD

P: 512-***-**** E: *******.*.*********@*****.*** LI: www.linkedin.com/in/cameron-macdonald-6525519/ Professional Summary Expertise

Cameron is a finance professional with experience in strategic consulting, business development and financial modeling. He combines deep industry knowledge with experience in managing corporate initiatives, including product development and operational performance analysis. Cameron brings an expertise in technology platforms to aid in quantitative analysis that uncovers actionable insights and is adept at analyzing KPIs against industry benchmarks.

• SaaS Revenue Forecasting

• Forecasting and Budgeting

• Financial Modeling

• Financial Planning and Analysis

• Valuation

• Project Management

• Market Research & Analysis

• Internal Reporting

WIN Reality, Austin, Tx (2023 – 2024)

A virtual reality sports training company

FP&A Manager

• Responsible for subscription cohort tables, renewal rate analysis, and related SaaS metrics (ie. Fully burdened CAC as well as LTV from ARPU, Gross Margin, and Average Lifetime).

• Managed monthly close process by compiling revenue files for deferred revenue schedule as well as validating expenses to budget.

• Point person for investor performance reporting.

• Multiple Ad Hoc projects including modeling for historical inventory, reorder points, and average value per SKU.

• Assisted in annual audit with subscriber ARR validation for prior 2-years. Bridgepoint Consulting, Austin, TX (2019 – 2023)

A provider of finance and accounting advisory

Summary of projects and assignments:

FP&A Manager Support for Oil & Gas SaaS Company

• Responsible for Book-to-Bill functions (including New Logo and Renewal) processes for the largest business unit in a $300M+ revenue company.

• Constructed Revenue Bridges and Renewal Walk models to highlight main areas of variance in revenue types.

• Point person for tracking and calculating churn in the company’s largest business unit; $110M+ available-to- renew (ATR).

• Key member in cross-functional team for integrating Salesforce with NetSuite; primary responsibility was testing the renewal data between the two platforms for FY2023. NetSuite Inventory Support for a Medical Diagnostic Technology Company

• Organized and uploaded Inventory Items data (BIN, Part Numbers, Unit of Measure, Count, Cost, etc.) into a new instance of NetSuite for a transitioning company.

Revenue Operations Support for a Cloud Ecommerce Company

• Managed the entire commission calculation process for a $200M+ revenue SaaS company which includes deal audits as well as calculated payouts for 150 sales reps (averaging over $500k in total monthly payouts).

• Key member in cross-functional team for implementing a commission calculating tool (Captivate). Salesforce Data Support for Office Management Software

• Created upload data templates to fill in Salesforce fields (such as Forecast Segment).

• Responsible for adjusting renewals modeling to show churn, downsells, and upsells by forecast segment and by region.

FP&A Support for an Online Education Start-up

• Created a 5-year Strategic Plan for a technology start-up and presented the model to the company’s board of directors.

FP&A Support for a Public Life Sciences Company

• The point-person in organizing the mid-year budget recast model as well as reporting on Quarterly budget to actuals.

• Created new financials model that integrated and projected P&L, Balance Sheet, and Statement of Cash Flows. Modeling Support for a Digital Print Manufacturing and Services Company

• Created a DSO Benchmarking model that calculated the value of the company’s Excess DSO against a peer group of competitors.

FP&A Support for Cloud-Based Digital Banking Solutions Company

• Using Adaptive Insights to report budget to actuals on multiple segments for a $800M+ revenue SaaS company. Compeat, Inc., Austin, TX (2017 – 2019)

A provider of cloud-based restaurant management and accounting software suites Senior Financial Analyst

• Served as company’s first financial analyst; reported directly to CFO.

• Established internal reporting processes; utilized company databases to uncover actionable insights for delivery to C-level executives.

• Constructed financial forecast models to achieve annual board-approved plan, including SaaS revenue, income statement, balance sheet, cash flow statement.

• Led corporate initiative for cross-functional team to facilitate data connections between Salesforce and NetSuite to reduce redundancies in data entry.

• Created NPV sensitivity model for executive team for major capital budgeting decision: resulted in newly created strategic partnership and white-labeled product rollout.

• Generated monthly, quarterly and annual reports for executive board, including KPIs and variance analysis on financial statements.

EVA Dimensions LLC, Locust Valley, NY (2014 – 2017) A provider of corporate consulting services

Senior Financial Analyst

• Supported company’s growth from start-up to acquisition by largest U.S.-based proxy-advisor firm.

• Worked directly with C-level team to develop company’s primary FP&A, valuation and internal reporting product solution.

• Valued multiple capital budgeting projects ($60M – $340M), acquisitions ($500M – $1.3B).

• Created high-value creative market analysis, internal reporting presentations (business unit performance vs peer companies and/or industry) and income statement and balance sheet drivers related to economic growth.

• Conducted ongoing variance analysis on corporate plan data for client business segments to determine wealth creation, profitability, growth and strategic position. Education

The University of Texas at San Antonio, San Antonio, TX

• Master of Science – Finance

• Master of Business Administration (Project Management) The University of Texas at Austin, Austin, TX

• Bachelor of Arts – Government (minor in Economics) Technical Skills/Other

• Microsoft Office (Word, PowerPoint, Excel); pivot tables (proficient); Visual Basic, recording macros

(competent)

• NetSuite, Salesforce, Tableau, Adaptive Insights, Google Excel Sheets, Bloomberg, Expensify

Contact this candidate