Franklin is an Enterprise-D security officer who dies in the opening firefight with individualised Borg at the Ohniaka III outpost in Descent, the sixth-season finale.
Franklin appears in Descent. He is part of the away team that beams to the Federation research station at Ohniaka III with William Riker, Worf and Data after a distress call, and finds the staff slaughtered.
The attackers are Borg, but unlike any met before: fast, aggressive and acting as individuals. In the fight that follows Franklin is cut down, and one of the Borg reacts with anger to the death of a comrade, calling him by name.
It is during this same engagement that Data kills a Borg with his bare hands and feels what he later recognises as pleasure, the event that draws him towards Lore.