Alpharetta police officer shot, suspect dead