An update.

Just got a call from the service dept. Looks like its the transmission control module now. Now sure why they change their mind regarding the speed sensor. Once I get the car back and test drive it, I'll post another update. Here's keeping my fingers crossed.