Hawking was most famous for developing several theories involving black holes, as well as performing all of his work while suffering with a severe neurological disease that had him almost completely paralyzed.
In 2369, Lieutenant Commander Data created a holographic version of Hawking to participate in a poker game with Albert Einstein, Sir Isaac Newton, and Data himself. Hawking eventually won. (TNG episode & novelization: Descent)
Hawking passed away at his home in Cambridge on 14 March 2018.  His name was added to a memorial list in Star Trek Online.