While CIOs and consultants draw the headlines, it’s mid-level managers, armed with Excel, grit, and five calendar invites, who drive transformation.