Mathew Strom Email & Phone Number

West Fargo, Nd, Us

Secured funding for renewable energy solar gardens in accordance with banking contracts and short term cashflow needsDeveloped 3 statement budgeting and forecasting model that encompasses multiple entities and their intercompany transactionsBuilt and maintained models for CAPEX, headcount, departmental budgets, construction budgets, construction schedules, amortization, debt positions, asset use scenarios, etc.Maintained and improved project finance and construction cashflow forecastBuilt and owned investor reporting packages including operations reports, distributions reports, and audited financials reportsCleansed and maintained Procore document vault including funding requests, invoices, contracts, and allocationsBuilt and maintained bank funding, contract, and milestone tracking reports and leverages these insights to report risk and debt exposure to executives and VPsAd hoc analysis as necessary, such as funding variance analysis, inventory allocation analysis, and contract milestone analysisDeveloped closing flow of funds models and memos for NTP sales and debt financings per EPC and MIPA contractsCreated and maintained 3 statement tax equity SPV model for solar garden projects

Owned FP&A and S&OP budget, forecast, and scenario planning processesLed the development of our financial, operational, and inventory planning models in Adaptive Planning and aligned all three to support strategic purchasing plans across multiple scenarios in a DTC e-commerce marketplaceBuilt new and updated existing complex financial models in EPM and Excel.Served as company’s primary Workday Adaptive Insights contact, training administrator, integration operator and occasional integration developerAided in accounting month-end close process for statement consolidation, financials presentations, and bank covenants Provided management with financial reporting and forecasting for P&L, Balance Sheet, Cash Flow, departmental performance and various KPIsBuilt dashboards and reports to show company performance across different e-commerce lines of business and revenue streamsReported monthly variance analysis, sourcing gap analysis, cost analysis, contribution/purchase margins across revenue streams and areas of risk to all levels of the company

Fargo, North Dakota Area

Owned several FP&A reports as well as operational dashboards and managed their processes, improvements, testing and data sourcingDeveloped several trackers for financial and operational KPIsDeveloped annual budgets for over 250 properties as well as tools for measuring their positions against the budget on monthly, quarterly and annual basisSourced and developed real estate market data tools for individual regions and sub-regionsLed the rollout of Power BI, including sourcing of data tables, data cleansing, relationship management, report building and production environment rolloutCreated custom reporting for market, residential, operational, financial, budget, trending, forecasting and benchmarking using Yardi, SQL, third party data sources, Power BI and internal metricsIncome statement, GL, invoice and PO analysis

Acted as a communication hub between team and governanceOwner of 6 different lines of business to ensure proper handling of royalty payments/financial analytics related to Forza 1PP gaming, music, video, codec, console and collection societiesSupervised the handling of over $50 Billion USD of net revenue per yearServed as a specialist for advanced problem solving, finding collaborative solutions, and a quality assurance check on our projectsReviewed over 3,500 contracts for financial accuracyTranslated contract language into practical business operationsExtensive data and pivot table use to track team and personal metricsWorked within team and licensor business partners to ensure that they are appropriately compensated for their intellectual propertyBuilt and maintained a strong network of business partnerships to facilitate team demands

Validated data accuracy against third party data sourcesProcessed vendor statements in compliance with monthly and quarterly deadlinesServed as support contact regarding business partner’s payments, statements and dataBuilt firm understanding of the technology finance industryWorked to ensure the accuracy and timeliness of licensor IP royalty paymentsRan insights and MS Sales reports to track data variances between internal data, invoices, and external dataHands on industry knowledge in retail, digital commerce and gaming space that developed out of strong sense of curiosity