Houston, Texas
Zachary Smart
Credit Risk Analyst at Hilcorp Energy · BS Statistics, Texas A&M
I'm a Credit Risk Analyst at Hilcorp Energy in Houston. Most of my week goes to reviewing the companies we buy from and sell to, deciding how much credit we can give them, and writing up a recommendation for leadership to approve.
Before Hilcorp I was a Financial Analyst at Sysco, where I built the monthly forecasts and margin reports with the Revenue Management team. I studied Statistics at Texas A&M. While I was there I built machine learning models as a research analyst and worked as a TA in the stats department.
I use AI tools at work and I'm open about it. At Sysco I used Claude to help write the SQL and R that took a three-day forecast down to two hours. I still check every number, and I'm the one who signs off.
Outside of work you'll find me on the golf course, at Kyle Field on Saturdays, or at Mass on Sunday. If you want to talk statistics, finance, or analytics, send me an email.
How I use AI
AI writes a lot of my first drafts. I check them and make the call. I use Claude, ChatGPT and Grok to draft formulas and write SQL, R and Python. Then I tie the numbers back to the source, test the assumptions, and decide what the result means.
Work samples
Things I've built
All three are interactive. Change an input and the numbers update.
Kinder Morgan 3-statement model
Income statement, balance sheet and cash flow for Kinder Morgan, built from the FY2025 10-K and linked so the balance sheet balances every year. Change volume growth, capex, dividends or interest rates and the leverage and coverage numbers move with them. The Excel file keeps the formulas.
Open the model → MarketsOil and natural gas dashboard
Henry Hub, WTI and Brent spot prices and Lower 48 gas storage against the 5-year average, all from EIA. It pulls fresh data every day and includes a simple 12-month price range.
Open the dashboard → Statistics, for funTexas A&M sports predictor
Elo ratings for Aggie football, men's basketball and baseball, built from every game ESPN has posted over the last few seasons. Win odds for each game, plus how often the model has picked the winner.
Open the predictor →Away from the desk