No, the Nobel Prize-winning physicist's first name was Leon (Leon N Cooper).
The character names Leonard Hofstadter and Sheldon Cooper from the TV show The Big Bang Theory were created as a tribute by combining the names of two real people:
Leonard, the first name of the character Leonard Hofstadter, came from actor/producer Sheldon Leonard.
Cooper, the last name of the character Sheldon Cooper, came from physicist Leon Cooper.