Well being that you have to hit the brakes to hear the "noise" its probably something else, check the brakes/rotors/pads/etc.....i would think that if it was a tranny problem you would hear that "noise" with or without the brakes being applied