Lauren Castillo
Senior Financial Analyst — FP&A
lauren.castillo@example.com(555) 861-2240Dallas, TXLinkedIn: www.linkedin.com/in/laurencastillofpa
Summary
FP&A analyst with 5 years supporting $120M-$300M business units. Own the annual budget and rolling forecast for a $180M division, hold forecast accuracy within 3% of actuals, and built the SQL-fed variance dashboard that cut monthly reporting from 4 days to 1.
Work Experience
Senior Financial Analyst
November 2022 – Present- Own annual budget and monthly rolling forecast for a $180M venue division: revenue drivers, labor models, and opex across 14 sites
- Held forecast accuracy within 3% of actuals for eight consecutive quarters by rebuilding driver assumptions from POS-level data
- Built a SQL-fed Power BI variance dashboard that cut monthly reporting from 4 analyst-days to 1 and is now used by 3 other divisions
- Modeled the business case for a $12M venue refresh program; finance committee approved with the model's phasing intact
Financial Analyst
July 2020 – October 2022- Supported a $300M maintenance budget: monthly variance analysis, accrual reviews with accounting, and quarterly reforecasts
- Automated the monthly variance package in Excel with Power Query, cutting preparation from 3 days to 4 hours
- Analyzed vendor contract scenarios that informed a renegotiation saving $2.1M annually
Skills
Analysis: Budgeting and rolling forecasts, Three-statement and driver-based modeling, Variance and flux analysis, Scenario and sensitivity analysis, Business-case and capex modeling
Tools: Excel (advanced modeling), SQL, Power BI, Anaplan, Oracle EPM, PowerPoint
Education
B.B.A. Finance
August 2016 – May 2020Certifications
CFA Level II Candidate — CFA Institute (May 2026)