Professional Resume Template for
Budget Analyst
Theresa J. Castillo
Philadelphia, PA
(215) 555-0143
theresa.castillo@email.com
linkedin.com/in/theresa-castillo | github.com/theresacastillo
Professional Summary
Methodical Budget Analyst with 5 years of experience overseeing corporate and departmental budgets up to $12.5M within the financial services industry. Adept at conducting detailed variance analysis, cost-benefit modeling, and long-range financial forecasting to support executive decision-making. Demonstrated success in optimizing operational expenditures, saving $340,000 in annual vendor contracts, and improving forecast accuracy by 16% through SQL data modeling. Proficient in leveraging Oracle Hyperion, Workday Adaptive Planning, SAP ERP, and advanced Excel macro workflows to streamline reporting timelines.
Work Experience
Budget Analyst — Summit Financial Group
Philadelphia, PA | January 2024 – Present
- Managed a portfolio of 14 departmental budgets totaling $12.5M, utilizing Oracle Hyperion to identify and resolve $185,000 in budget variances prior to quarterly fiscal reviews.
- Formulated 5-year capital expenditure forecasts using SQL data integration, which reduced reporting cycles by 4 days and improved forecast accuracy by 16%.
- Collaborated with 8 department heads to audit operational costs, uncovering licensing overlaps that saved $145,000 in annual software subscription expenses.
- Designed custom Excel dashboards with automated VBA macros to track real-time spending, decreasing monthly ad-hoc executive financial report preparation time by 32%.
Associate Budget Analyst — Clearwater Municipal Advisors
Philadelphia, PA | June 2021 – December 2023
- Assisted in the administration of a $7.8M municipal agency budget, executing weekly reconciliation audits that corrected $92,000 in billing discrepancies.
- Conducted cost-benefit evaluations for 6 capital improvement proposals, providing quantitative analysis that supported the approval of $1.4M in infrastructure funding.
- Prepared monthly budget-to-actual variance statements for 11 regional programs, identifying a $64,000 deficit trend and recommending corrective reallocations.
- Standardized the annual budget submission documentation templates using SharePoint, training 22 staff members and cutting overall budget cycle processing time by 18%.
Education
Bachelor of Science in Finance
Rutgers University · New Brunswick, NJ · 2021
Skills
Budget forecasting, Variance analysis, Capital planning, Cost-benefit modeling, Ledger reconciliation, Financial compliance, SQL database querying, Oracle Hyperion, Workday Adaptive Planning, SAP ERP, SharePoint, Advanced Microsoft Excel, VBA scripting, Financial reporting
Projects
ERP System Migration
Role: Lead Finance Advisor
Tools: SAP ERP, Oracle Hyperion, MS Excel, SQL
Guided the financial data migration of a $12M business unit to SAP, reconciling over 12,000 line items with a 0.05% error rate and finishing 2 weeks early.
Departmental Cost Optimization Initiative
Role: Budget Analyst
Tools: Oracle Hyperion, Workday Adaptive Planning, Power BI
Conducted a comprehensive review of operational expenditures across 6 departments, identifying redundancies and implementing structural changes that trimmed $215,000 from the annual operating budget.
Certifications
- Certified Government Financial Manager (CGFM) (2023)
- Certified Public Accountant (CPA) (2024)
- Certified Budget Analyst (CBA) (2022)
Additional information
- Languages: English (Native), Spanish (Professional working proficiency)
- Volunteer Work: Treasurer for Philadelphia regional food bank (2022-present)
- Availability: 2 weeks notice
Job Market Insights
Market data and opportunities for
Budget Analyst
Job Market Insights
$78,000
-
$118,000
Avg:
$94,000
Growth Outlook:
The employment of budget analysts in the United States is projected to grow by 1% from 2024 to 2034, which is slower than average. However, approximately 3,100 job openings are anticipated annually to replace retiring workers. Artificial intelligence and advanced automation tools are transforming the role by automating data entry and basic reports. This shift requires budget analysts to focus heavily on strategic planning, interpreting complex financial data, and providing high-level counsel to executives. Demand remains steady in government agencies and corporate financial departments.
1% growth over 10 years
Key Skills Required
Focus on these skills when customizing your resume for recruiter screenings.
Search Jobs
Explore live openings for
Budget Analyst
roles and tailor your resume to match the market demand.
Search
Budget Analyst
FAQ
Common questions about the
Budget Analyst
position