Q brought him back to life at the end to replace the crew member who stayed back in the past. You actually see a fair bit of him towards the final moments of the last episode in Ten Foward with the rest of the crew.