Financial Analyst
North Star Consumer Brands · Minneapolis, MN
May, 2022 · Present
• Own monthly close reporting and deliver budget-versus-actual variance analysis for a $185M consumer portfolio, partnering with brand and operations leaders to explain drivers and actions.
• Build rolling 18-month forecast models in advanced Excel; improved forecast accuracy 12% by standardizing assumptions, scenario cases, and sensitivity checks.
• Develop Power BI stakeholder dashboards and executive decks that consolidate revenue, gross margin, headcount, and spend KPIs for quarterly business reviews.
• Automate recurring SQL data pulls and reporting workflows, reducing manual reporting time by 8 hours per month and improving auditability.
Junior Financial Analyst
Twin Cities Retail Group · St. Paul, MN
Jun, 2019 · Apr, 2022
• Produced weekly department P&Ls and inventory-costing analyses for 40+ retail locations, identifying margin leakage and working-capital opportunities.
• Measured promotional ROI by product category using SQL extracts and Excel models; recommendations improved campaign contribution margin by 8%.
• Maintained sales, labor, and expense forecasts and prepared monthly variance commentary for merchandising, store operations, and finance leadership.
• Built Tableau scorecards for sell-through, markdowns, and inventory turns, giving category managers a consistent view of performance.
Finance Research Assistant
University of Minnesota Carlson School · Minneapolis, MN
Sep, 2018 · May, 2019
• Supported faculty research on consumer finance and corporate budgeting by cleaning datasets, validating assumptions, and preparing Excel analyses for grant-funded studies.
• Built sensitivity tables and visual summaries used in classroom cases and presentations to local finance professionals.
• Coordinated student investment-club reporting, tracking a $75K simulated portfolio and presenting monthly performance and risk commentary.