Matthew Johnson
Dallas,TX
Summary
Highly motivated and goal-driven Financial Analyst skilled in collecting, monitoring and studying data to analyze financial status and recommend business strategy. Experienced in qualitative and quantitative analysis, contract management and forecasting. Tech-savvy in use of spreadsheets, accounting and financial management software.
Overview
10
10
years of professional experience
Work History
Lead Product Management & Development
AT&T
09.2023 - Current
- Business Case Development for OCN Product relaunch with dynamic P&L and sensitivity analysis for improved product visibility with a focus on improved EBITDA targets
- Analytic development for Business Volumes by Business Unit, Segment, Channel, and Device Group
- Product Churn Analysis by Segment, Channel, Customer, and Rate Plan for improved disconnect visibility
Lead Financial Analyst - Promo & Subsidy
AT&T
04.2023 - 09.2023
- Rebuilt $300M Billing Adjustment P&L to enable financial reporting and quick analysis for key operational stakeholders
- Built Promo Master Data model that enables promo trending by day, device, channel, acquisition type, and promo ID: represents $8B of gross expense
Lead Financial Analyst - Mass Markets
AT&T
06.2022 - 04.2023
- Rebuilt $500M Apps & Services P&L to better align with reorganization and strategic objectives
- Managed budgeting, close, forecasting, vendor contracts, and Ad Hoc analysis for 3 major lines of business: Strategic Partnerships, A2P and Security
- Built Capital business case models for Fiber & Mobility to quickly customize inputs and analyze business case Financials: Revenue, Expense, EBITDA, Volumes, Rates, NPV, IRR, & DPP
- Built standardized project assumption analysis that enables precise communication between operations and key stakeholders
Lead Financial Analyst - Consumer Wireline
AT&T
09.2021 - 05.2022
- Performed forecasting, budgeting, & reporting for Consumer Wireline that manages $4B of annual EBITDA
- Established ad hoc analysis to discover key variance drivers within Consumer Wireline to increase business operational efficiency
Manager - Financial Planning
BorrowWorks
12.2019 - 08.2021
- Led a team of two analysts that oversaw two investment portfolios with emphasis on modeling development
- Managed all forecasting & budgeting responsibilities for lending services that manages $40M of assets and $60M of income annually
- Managed Daily Bank Reconciliation processes that reconciles $4M of daily transactions across Nortridge Loan System, bank accounts, and SQL Looker database
Senior Financial Analyst - Capital
American Airlines Dallas
03.2017 - 12.2019
- Wrote business cases to prove financial viability for operating and capital projects within the Integrated Operations Division that operates with a $1B annual budget
- Served as the finance point of contact for Flight and Integrated Operations Center capital projects, totaling $220M worth of investment annually as well as the management of various aircraft modification projects totaling $400M, which includes forecasting, budgeting, and variance analysis activities
- Directly supported the Senior Manager of Capital Finance in the development of sound financial business cases for projects presented to the COO and CFO through NPV analysis, cost-benefit analysis, and qualitative justifications
Strategic Pricing Analyst
Academy Sports & Outdoors
04.2014 - 02.2017
- Drove strategic pricing solutions and quick implementation of those solutions
- Built financial and statistical models to support the buying and planning organizations in various areas that included forecasting, assortment and inventory allocation
Education
Master of Business Administration - Finance
University of Arkansas
Fayetteville, AR05.2013
Bachelor of Business Administration - Finance
Arkansas State University
Jonesboro, AR12.2011
Skills
- Knowledge of ERP Software
- Project Strategy
- Oracle Hyperion
- Project Planning
- Statistical Data
- Financial Modeling
- Financial and Operational Reporting
- Financial Management
- Power BI
- Expense and Revenue Analysis
- MicroStrategy Reporting Suite
- Software Applications
- Cognos
- Google Looker
Timeline
Lead Product Management & Development
AT&T
09.2023 - Current
Lead Financial Analyst - Promo & Subsidy
AT&T
04.2023 - 09.2023
Lead Financial Analyst - Mass Markets
AT&T
06.2022 - 04.2023
Lead Financial Analyst - Consumer Wireline
AT&T
09.2021 - 05.2022
Manager - Financial Planning
BorrowWorks
12.2019 - 08.2021
Senior Financial Analyst - Capital
American Airlines Dallas
03.2017 - 12.2019
Strategic Pricing Analyst
Academy Sports & Outdoors
04.2014 - 02.2017
Master of Business Administration - Finance
University of Arkansas
Bachelor of Business Administration - Finance
Arkansas State University