No character named "Director Sheppard" appears in NCIS (2003–present). The director roles have been:
"Sheppard" vs. "Shepard" — one letter. Jenny Shepard (Lauren Holly) was a major character (Director, Gibbs' former partner/lover, died Season 5). The misspelling is common.
If you meant Jenny Shepard, I can detail her arc. If it's a different "Director Sheppard," provide show/episode/context.