Hooley's shot was the last of the game and came with less than two seconds remaining. The win gave Albany its third America East tournament title in a row. Stony Brook was looking for its first ever trip to the NCAA tournament.
Stony Brook's Carson Puriefoy missed a free throw with 17 seconds left in the game.
Hooley scored 10 points for the Great Danes. Sam Rowley led the team with 14 points. Puriefoy had 23 points for Stony Brook, and Jameel Warney added 20 points and 14 rebounds.
Fans stormed the court after the game.