Mark Schroeder
Finance Director · SELF EMPLOYED
Tustin, CAIn My Own Words
Seasoned finance executive with a successful track record of financial leadership for a global business with extensive experience in developing best practices and solutions while collaborating across multiple business units
Work Experience
FINANCIAL CONSULTANT
SELF EMPLOYED2018 – Present
* Managed budget/forecasts and financial presentations for retail, consumer goods, e-commerce, and entertainment (e.g., Beauty Counter, Kaspien, Disney, IHerb, NBCU, Pure 710 SF, etc.) * Performed monthly/quarterly accounting close functions * Manual accruals, analysis for bad debt & reserve, G/L account reconciliations, BS flux analysis, deferred revenue rollforward, inventory impairment/valuation, and corporate reporting * Provided financial analysis and recommendations for business strategies, new operations/product, and deal negotiations * Developed dashboard/key metrics with industry benchmarks, YOY comparisons, and budget tracking * Provided quarterly financial data and narrative to investor relations for earning calls * Prepared consolidation and financial analysis for investment spend including IRR & ROI analysis * Managed weekly AP approval process and impact to rolling cash forecast * Provided reconciliations and accrual analysis for accounting team (e.g. deferred revenue, freight/fulfillment, bad debt reserve, inventory impairment reserve) * Managed monthly financial executive presentations to highlight operational performance and actionable items * Provided oversight of accounting team (etc. A/P, A/R, Payroll, Inventory) and financial reporting * Maintained control policies for allocations and revenue recognition (ASC 606 guidelines) * Updated internal control policies to increase efficiencies and controls * Prepared data analytics including trend analysis based on historical and 3rd party data * Facilitated supply chain management with improved collaboration between accounting and purchase teams * Managed consolidation of financial statements with variance analysis versus models & prior submissions * Provided financial reporting and supporting documentation to external auditors and financing partners * Improved month-end close process of accruals, reconciliations, and variance analysis
VP FINANCE
SONY PICTURES ENTERTAINMENT2015 – 2018
* Led and streamlined budgets, forecasts, and long-range plans with the collaboration of the global sales, operations, HR partners, marketing, regional finance, and production teams * Presented executive financial plans summarizing market conditions, trends, opportunities/risks, business strategy, resource needs, headcount, and variances per prior plans/years * Improved financial modeling analysis adjusting for current market conditions to increase profit margins and reduce risks * Partnered with executives, developing financial analysis (e.g., modeling P&L, Cash Flow, ROI, IRR, & NPV) for future acquisitions, licensing deals, product launches, marketing plans, and new operations * Improved KPI dashboards highlighting key budget category pacing, production costs pacing, product, risks/opportunities, and strategy pacing * Managed monthly actuals presentation and supporting schedules to executives, including G&A and headcount, with variance analysis and narrative for YTD pacing compared to budget, forecast, and prior year * Partnered with internal/external quarterly auditors performing quarterly audit testing (e.g., SOX narrative & substantive testing) * Reviewed/approved month-end manual accruals (A/R, A/P, & SG&A) and financial reporting * Developed solutions with business partners for off-track performance to ensure financial targets were met by leveraging opportunities/risks, driving sales to specified product, adjusting negotiations for marketing campaigns, reducing vendor costs, and adjusting timing of investments * Established IT enhancements and solutions for financial/sales systems to increase functionality and reporting capabilities * Led and mentored FP&A and shared service teams, increasing capabilities and efficiencies
DIRECTOR FINANCE
SONY PICTURES ENTERTAINMENT2011 – 2015
* Managed International budgets, forecasts, capital budget, forecasts, and long-range plans * Developed budgeting/forecasting best practices while collaborating with production, sales operations, and regional finance teams * Consolidated and submitted regional financial plans on a per product basis to align with financial models and business strategies * Collaborated with sales operations to develop and implement new business strategies to improve profitability * Provided financial analysis and recommendations for multi-year global deals * Managed month-end inventory analysis, highlighting profit margins and sales opportunities * Provided treasury with rolling 3-month cash plans for month-end close * Improved monthly flash and forecast process by leveraging CRM system, increasing accuracy and analysis * Provided monthly variance analysis and commentary for sales operations compared to budget, flash, forecast, and prior year for monthly results presentation * Managed market share analytics to establish industry benchmarks * Developed monthly operational KPI dashboards and variance analysis with the collaboration of the regional teams, highlighting sales to-go for major markets by key product and risks/opportunities to stakeholders * Partnered with IT during the implementation of new sales/finance systems (e.g., RPM & SAP) * Developed and mentored International Home Office FP&A team and regional finance teams
Software/System Skills * ERP Systems - SAP, NetSuite * Reporting Systems - Business Objects, BW, Tableau, Power BI * CRM Systems * Advanced Excel