Investment Analyst · Tulsa, Oklahoma

I trade and rebalance client portfolios by day and build the tools the investment team runs on.

Investment Analyst at Argent Trust Oklahoma. I execute rebalancing and trading across $1B+ in client portfolios, and I build the Python, SQL, and Excel automation the investment team's research, reporting, and daily operations run on.

Jaylon Rodriguez
SERIES 65 · SIE · BMCPreparing for CFA Level I
$1B+in client portfolios rebalanced and traded
~90%less prep time on recurring reports
40–50 hrsof recurring manual work automated each month
18automation and AI projects presented to leadership

About

I joined Argent Trust Oklahoma in 2023 as a Financial Associate and was promoted to Investment Analyst in 2025. I sit on the investment team: rebalancing and trading trust, retirement, and institutional accounts; researching equities, fixed income, funds, and alternatives; and producing the quarterly reviews and presentations clients see.

Along the way I started fixing the parts of the job that were manual. The turning point came in late 2024: something in our market data looked off, I followed up, and learned that the provider our models had run on for more than 20 years was shutting down, with six weeks' notice. I negotiated several more months and led the move to a new platform, rebuilding the provider's discontinued calculations on new data and converting the model workbooks so nothing stopped running. Since then I've automated a large share of the office's recurring work, from daily cash reporting and trade checks to earnings updates and a daily rate the models depend on.

In 2026 that expanded into AI. I was selected for Argent's AI Task Force, I write a weekly internal AI briefing (22 editions so far), and I present the work to senior leadership and to finance audiences around Tulsa.

University of Oklahoma, BBA in Finance. Series 65 and SIE. Bloomberg Market Concepts. Currently preparing for CFA Level I.

01Investment management

Rebalancing, trading, and research across $1B+ in client portfolios; client-facing reviews and quarterly reporting. Member, Digital Asset Working Group.

02Data & automation

Python, SQL, VBA, and Power Query on top of LSEG Workspace. Daily pipelines, earnings automation, a research database, and portfolio-analytics prototypes.

03AI programs

AI Task Force member. Author of AI Wednesday, a weekly internal AI briefing. Speaker on AI basics for executives and staff.

04Shipping software

Three full-stack apps built end to end on React/Next.js, Supabase, and Capacitor iOS — with real users, real tests, and TestFlight builds.

Selected work

Two interactive demos you can click through, plus a live personal app.

All projects →

Experience

Full resume →
FEB 2025 — PRESENT

Investment Analyst

Argent Trust Oklahoma (formerly AmeriTrust) · Argent Financial Group

  • Execute rebalancing and trading across $1B+ in trust, retirement, and institutional portfolios.
  • Led the transition off a legacy data provider the office had used for 20+ years after a six-week shutdown notice; automation cut prep time ~90% on affected recurring reports.
  • Automated 40–50 hours a month of recurring manual work, including daily cash reporting, trade checks, and earnings updates.
  • Selected for Argent's AI Task Force (June 2026); author of a weekly internal AI briefing.
MAR 2023 — JAN 2025

Financial Associate / Analyst

Argent Trust Oklahoma

  • Supported rebalancing and trading across client portfolios totaling $250M+.
  • Led the data-provider transition and multiple automation projects; delivered institutional client presentations.
2017 — 2022

BBA, Finance

University of Oklahoma · Price College of Business

  • Finalist, Shell Oil Company / OU Corporate Valuation Challenge. Dean's Honor Roll (5 semesters).

Skills

Investment

  • Portfolio rebalancing
  • Trading
  • Asset allocation
  • Equity & fixed income research
  • Fund / ETF models
  • Digital assets
  • Client reporting

Data & automation

  • Python
  • pandas
  • SQL / SQLite
  • pyodbc
  • Excel VBA
  • Power Query
  • Power Automate
  • Plotly
  • Windows COM
  • Task Scheduler
  • Docker

Platforms & software

  • LSEG Workspace
  • Morningstar Direct
  • YCharts
  • Koyfin
  • Black Diamond
  • Portfolio Center
  • Envestnet
  • React / Next.js
  • Supabase
  • Node.js
  • Capacitor iOS
  • Claude / Copilot

Get in touch

Open to conversations about portfolio management, wealth management, and the intersection of investing, data, and AI. The fastest way to reach me is LinkedIn or email.