Devin Aguilar — Financial Analyst
Chicago, IL
Financial analyst two years into corporate FP&A, owning the monthly forecast for a
Experience
Financial Analyst, Trelane Consumer Goods · July 2024 – present
FP&A for the household care portfolio,
- Rebuilt the volume forecast as a driver-based model, cutting mean absolute forecast error on the household care line from 11% to 4% over three quarters.
- Automated the monthly variance pack in Power Query, replacing 14 hours of manual consolidation with a 20-minute refresh.
- Caught a $420k freight accrual error during the Q3 close by tying carrier invoices back to the shipment log, correcting the number before it reached the board pack.
- Prepares the monthly spend review for four plant managers, tracking 62 cost centers against budget and flagging overruns in the first week.
Junior Financial Analyst, Brackenfield Savings Bank · June 2023 – June 2024
- Built the branch profitability model for 28 locations, surfacing two branches whose deposit spread had gone negative and supporting a consolidation that saved $310k a year.
- Produced the quarterly rate sensitivity analysis used by the asset-liability committee, taking its preparation from five days to one.
- Corrected six years of cost center mapping in the general ledger, clearing 1,100 misclassified entries before the annual audit.
Projects
- Cook County Budget Explorer — A public dashboard that breaks 12 years of county budget data into department, fund and per-resident views.
Education
- B.S. Finance · University of Illinois Urbana-Champaign · August 2019 – May 2023
Skills
- Analysis: Driver-based forecasting, Variance analysis, Three-statement modeling, Scenario planning, Working capital
- Tools: Excel, Power Query, Power BI, SQL, NetSuite, Anaplan
- Reporting: Month-end close support, Board packs, KPI dashboards, Budget cycle coordination
Certifications
- Passed Level I of the CFA Program — CFA Institute
- Bloomberg Market Concepts — Bloomberg
Why this Financial Analyst résumé works
- The summary leads with one measured improvement, forecast error “from 11% to 4%”, which tells an FP&A hiring manager the analyst changes models rather than only updating them.
- Time saved and errors caught are both counted: 14 hours of consolidation replaced by a 20-minute refresh, and a $420k freight accrual error found before it reached the board pack.
- The Cook County Budget Explorer project shows Power BI and SQL used on public data with an audience of roughly 4,000 visitors, a useful addition for an entry-level candidate.
- The CFA Program pass and the 3.7 GPA from University of Illinois Urbana-Champaign are kept short, because two years of results already do the work.
Financial Analyst résumé: common questions
Should an entry-level financial analyst resume include GPA?
Yes in the first two or three years if it is 3.5 or higher. After that, drop it and let the work results carry the education section.
What skills should a financial analyst resume list?
Analysis skills (forecasting, variance analysis, three-statement modeling), tools (Excel, Power Query, Power BI, SQL) and the ERP or planning system you used, such as NetSuite or Anaplan. Show each in a bullet.
Should CFA progress go on a financial analyst resume?
Yes. List passed levels in a certifications section with the year, or note that you are a candidate for the next level. It signals commitment to finance even in a corporate FP&A role.
