MLB veteran was a two-time All-American at SHU and helped lead the Pirates to two College World Series appearances