← All projects

PROGRAM OPERATIONS / Tennessee Department of Education

An intake-to-payment workflow across vendors.

A statewide process that scaled vendor contracts from about 30 to 900+ across a $146.5M portfolio.

MY ROLE
Operating-process design & matrixed coordination
CONTEXT
110+ participating schools
WHAT I BUILT
Grant-delivery infrastructure

SEE THE WORK

The tools that moved 900+ contracts

A tracker every team worked from, and a signature route that replaced paper.

EANS_Contract_Tracker_v14.xlsx
HomeInsertFormulasDataReviewView
H7fx=IF(AND(F7="Approved",G7<>""),"Ready for signature",IF(F7="Returned","Hold: see notes","In review"))
ABCDEFGHIJ
1Contract IDSchoolService categoryGrants IDAmountAllowabilityVendor packetStatusPO #Paid to date
2EANS-23-0388Tutoring servicesEP-11824$42,600.00ApprovedCompletePaidPO-7710$42,600.00
3EANS-23-0391Instructional technologyEP-11830$18,450.00ApprovedCompletePaidPO-7714$18,450.00
4EANS-23-0402Counseling servicesEP-11857$27,900.00ApprovedCompleteOut for signature$0.00
5EANS-23-0407Educational softwareEP-11862$9,875.00ApprovedCompleteOut for signature$0.00
6EANS-23-0411Sanitation suppliesEP-11871$6,240.00ReturnedMissing W-9Hold: see notes$0.00
7EANS-23-0412Instructional technologyEP-11873$31,120.00ApprovedCompleteReady for signature$0.00
8EANS-23-0415Tutoring servicesEP-11880$15,300.00In reviewCompleteIn review$0.00
9EANS-23-0419Professional developmentEP-11886$12,000.00In reviewPendingIn review$0.00
TrackerVendor PacketsAllocationsWeekly PivotNotes
ReadyFilter: All schools · Sorted by Contract ID

Recreation of the working tracker, rebuilt with fictional contract IDs, amounts, and redacted school names. The real workbook held every contract from intake through payment, and it was the shared source of truth across teams.

Read the project story

THE STARTING POINT

What needed to change.

Schools identified their needs and vendors, but the state contracted with and paid those vendors directly. Delivery depended on connected work across grants, finance, procurement, contracting, legal, and executive leadership. Unclear processes and limited capacity constrained that work.

THE WORK

What I built
and why.

01

Standardize what comes in

Clarify eligibility, school intake, vendor information, budget inputs, and allowability review before requests enter contracting.

02

Connect the handoffs

Build a repeatable path through contract preparation, review, approval, purchase orders, invoicing, and payment.

03

Coordinate without formal authority

Work across functional teams whose members did not report to me, resolving bottlenecks and maintaining shared progress.

04

Make the process repeatable

Support schools and vendors with consistent guidance and expenditure monitoring.

BEFORE AI

Automation first.

I didn’t use AI for this work. I scaled it with automation instead: introducing e-signature routing for contracts that had moved on paper, and building Excel models to track eligibility, allocations, and contract status across hundreds of transactions.

THE RESULT

The redesigned infrastructure supported growth from roughly 30 to more than 900 vendor contracts across 110+ participating schools within Tennessee’s approximately $146.5 million EANS portfolio. The model was repeatable enough that the state used it for a $63 million follow-on program.

The funding figure describes program scope. Contract counts describe execution volume; they are not a measure of annual revenue or funds personally awarded. The $63 million follow-on redeployed unspent EANS funds and is not additional to the $146.5 million.

PROJECT DOCUMENT

The case study.

A one-page overview of the context, work, and result.

Read the case study PDF ↗
First page of Adam W. Holdren’s Access to funded student services case study
NEXT PROJECTPayment tracking and reconciliation portal