Can a U.S. czar of cybersecurity be effective?

Yes. Having one person responsible for security efforts can only help.
No. That person would not have enough vested authority to be effective.