Tratop
Jun 2024 — Apr 2025
FP&A Intern
- Built and maintained an Excel operating-budget model consolidating assumptions and financial inputs across 20 projects for a topographic studies firm.
- Analyzed budget-to-actual variances and updated forecasts as project inputs changed, supporting management reviews of costs and financial performance.
- Analyzed project profitability to support management discussions on project-level financial performance.
- Prepared journal entries and assisted with month-end closing.
- Reconciled source data and validated formulas, assumptions and model outputs before budget reviews, using pivot tables, lookup formulas and data-validation controls.
- Prepared management summaries and standardized reporting views for KPI reviews, expense management and planning discussions.
- Automated financial reports to support recurring analysis and management reporting.