IMHO this the "Get's things done." part of the developer skill set defined by Joel Spolsky. A wizard at solving problems without an eye on maintainability or the long term picture.

The antithesis of this is the "Smart" guy who can design the "perfect system" upto and past the release date.