Not SEC, but US attorney for the Southern District Preet Bharara apparently made his fame by going after Wall Street bigwigs. I don't know much about him besides his Wikipedia page (which could be edited by a PR firm), but it seems that was his career trajectory.