JOSHUA ZOMBRON
Fairfax,VA
Summary
Financial Analyst with experience supporting federal programs, real estate investments, and construction projects through budgeting, forecasting, variance analysis, and cost optimization. Proven ability to analyze budgets, reconcile financial data, and deliver executive-level reports that improve funding utilization and reduce costs. Advanced user of Excel, SQL, Python, and R with an Active Public Trust Clearance.
Overview
5
5
years of professional experience
Work History
Project Data Analyst III
XLA
01.2025 - 06.2025
- Consolidated and analyzed $1M-$5M+ in federal budgets and obligations to enhance financial reporting and forecasting accuracy.
- Reconciled financial transactions across multiple federal accounts, correcting discrepancies to ensure data accuracy and enhance audit readiness.
- Prepared monthly detailed reports on financial status, funding utilization, and contract performance for executives and program stakeholders.
- Identified cost-saving opportunities through deobligation of unused funds, leading to estimated funding efficiency improvements of 5-10%.
- Supported financial compliance efforts in coordination with the DEA’s internal accounting and audit teams.
Project Analyst
Mason Capital Advisors
06.2024 - 12.2024
- Developed detailed financial models and forecasting tools for real estate investments valued in the low to mid seven figures using discounted cash flow and profitability analysis.
- Conducted benchmarking, variance, and comparative performance analysis across multiple investment assets, identifying key risk and return drivers.
- Created and presented structured financial reports and risk analyses to executives and investors.
- Tracked actual vs. forecasted performance, identifying variances of approximately 5-15% and offering data-driven recommendations.
Project Manager
K Contracting
07.2023 - 02.2024
- Oversaw project financials including budgets, invoices, and procurement for multiple concurrent construction projects.
- Analyzed project costs and forecasts using Excel-based financial models to monitor burn rates, cash flow, and funding needs.
- Consulted with senior leadership on policy development and project feasibility through comprehensive risk and cost assessments.
Data Analyst Intern
Axis Equity Group
06.2022 - 02.2023
- Built interactive dashboards and recurring reports using SQL and R to support stakeholder decision-making.
- Analyzed large datasets to identify investment trends and performance indicators that informed portfolio strategy.
- Conducted macroeconomic research that enhanced forecasting and risk modeling initiatives.
Data Analyst Intern
Super Chicken
04.2020 - 05.2022
- Built predictive models to forecast sales trends and automate inventory planning, leading to estimated 10-20% reduction in waste.
- Developed daily demand forecasting models to optimize supply chain operations and minimize ingredient waste.
- Created clear financial summaries and visualizations for non-technical management teams to support operational decisions.
Education
Bachelor of Science - Applied Mathematics, Concentration in Statistics
Virginia Commonwealth University
12-2021
Skills
Financial Analysis: Budgeting, Forecasting, Variance Analysis, Cost Control, Financial Modeling, Risk Analysis
Data & Tools: Advanced Excel, SQL, Python, SAS, R, Data Visualization, Dashboards
Business: Stakeholder Reporting, Contract Management, Project management
Additional Information
- Volunteer Math Tutor
- Volunteer Youth Soccer Coach
- 7+ years of customer service
Timeline
Project Data Analyst III
XLA
01.2025 - 06.2025
Project Analyst
Mason Capital Advisors
06.2024 - 12.2024
Project Manager
K Contracting
07.2023 - 02.2024
Data Analyst Intern
Axis Equity Group
06.2022 - 02.2023
Data Analyst Intern
Super Chicken
04.2020 - 05.2022
Bachelor of Science - Applied Mathematics, Concentration in Statistics
Virginia Commonwealth University