Skip to content

Julio GarciaFinance & Operations

Finance and operations builder who ships.

Sole finance owner of $24M+ in annual premiums. Shipped two AI tools into daily production with zero engineering support. I take ambiguous problems end to end — model it, automate it, ship the fix.

Statement of record2020 — present
Annual premiums ownedsole finance owner
$0M+
Employer accountsmulti-party portfolios
0
Employees coveredacross all accounts
0+
Hours saved weeklyAI tools I built solo
0+
RFP throughputvs. manual process
Manual work cutExcel VBA automation
0%
Reconciled

About

I own the finance function at TEB&HR — $24M+ in annual premiums across 8 employer accounts and 20,000+ covered employees — as the direct finance partner to senior leadership, with no team behind me.

When I find a broken process, I don't escalate it — I build the fix. Two AI-powered tools I designed and shipped alone, with zero engineering support, now run in production daily: one cut leadership search time by 10+ hours a week and tripled deal throughput; the other scores every proposal leadership decides to pursue.

Before that, I built a cross-border logistics company's entire financial reporting function from scratch. Advanced Excel/VBA, Python, SQL, and Power BI on top of a real FP&A and variance-analysis background. Bilingual (English/Spanish) with US–Mexico operating experience.

Experience

Finance & Operations Lead · TEB&HR

Jul 2022 — Present · El Paso, TX

$24M+ annual premiums · 8 employer accounts · 20,000+ employees covered

  • Sole finance owner for $24M+ in annual premiums across 8 employer accounts — the direct finance partner to senior leadership, with no team behind me.
  • Identified a fully manual, leadership-hours-heavy RFP search process and independently built the fix: an automated RFP Finder (Claude + Google AI Studio) with zero engineering support — cutting search time by 10+ hours/week and tripling RFP throughput. Still in daily production use.
  • Built a second tool from scratch, a Proposal Rater, that ingests carrier quotes and RFP requirements and scores competitive positioning — now used daily by leadership to decide which proposals to pursue and how to price them.
  • Designed and shipped Excel automation (macros/VBA) that cut manual processing time ~40%, with tooling still in active production use.
  • Own monthly and quarterly variance analysis across all 8 accounts — tracing discrepancies between internal records and carrier data to root cause, resolving billing exceptions before they reach client invoices.
  • Built and maintain live Power BI dashboards that replaced static reporting, giving leadership real-time visibility into premium billing and account-level performance.

Financial Analyst · ALYGA Logistics

Mar 2020 — Jun 2022 · El Paso, TX

15+ active clients · 120+ monthly shipments · $2M+ monthly transaction value

  • Built the company's financial reporting infrastructure from scratch for a cross-border US–Mexico logistics operation — giving 2 senior supervisors their first real-time visibility into revenue, cost, and margin.
  • Delivered variance analysis and data-driven pricing and resource-allocation recommendations that replaced gut-feel decisions, directly improving forecast accuracy on high-volume cross-border routes.
  • Sole finance partner across operations, sales, and leadership; ran bilingual (EN/ES) coordination with cross-border partners to keep reporting accurate in a fast-moving, multi-party supply chain.

Built & Shipped

RFP Finder

Live in production

Automated discovery tool across government RFP databases. Replaced a fully manual search process that consumed leadership hours — built solo, with zero engineering support.

10+ hrs/week saved · 3× throughput

Claude AI · Google AI Studio

Proposal Rater

Live in production

Scores carrier quotes against RFP requirements and surfaces the strongest bid. Replaced a judgment-heavy manual process; now used daily by leadership.

Daily pursue/price decisions

Claude AI · Google AI Studio

Probability-Weighted Decision Engine

Personal project

Ingests multi-variable data and applies a structured framework to compare modeled probability against implied market pricing — outputting confidence-weighted, risk-adjusted recommendations. Directly transferable to risk-scoring and underwriting-style decision problems.

Risk-adjusted recommendations

Python · Pandas · Claude AI

Toolkit

Finance & Analysis

  • FP&A reporting
  • Variance analysis
  • Reconciliation
  • Financial modeling
  • Forecasting

Automation & Code

  • Python (CS50P — Harvard)
  • Pandas
  • SQL
  • Power BI
  • Excel VBA / macros
  • XLOOKUP · SUMIFS · INDEX-MATCH

AI Tool-Building

  • Claude AI
  • Google AI Studio
  • LLM workflow design

Systems & Operations

  • Salesforce
  • QuickBooks
  • Employee Navigator
  • WEX
  • Bilingual EN/ES
  • Cross-border US–Mexico ops

Education & Development

BBA in Finance · University of Texas at El Paso (UTEP)

December 2025 · Minor: Commercial Real Estate

Financial Modeling · Corporate Finance · Capital Markets · Data Analytics

SEO EDGE Finance Program

Dec 2022 — Dec 2025

100+ hours in corporate finance, capital markets, financial modeling, and investment analysis — mentored by professionals from Goldman Sachs, Bain, and leading tech companies.

PwC Business Recovery Case Competition

Built financial models and recovery recommendations for a distressed-company scenario; presented to PwC senior leadership under time constraints.

Contact

If your books, ops, or processes need an owner — let's talk.

Open to relocation