Welcome to the forum !

Transmission :
1. low fluid
2. check the electrical connector for leaks
3. replace the 'conductor plate'

TPMS light - pretty normal these days - the batterys in the tire sensors don't last much past 10 years.

CEL - go to Advance or Autozone and have them read the codes, or buy yourself a cheap code reader.
Post results back here.