Advancing ab initio electronic structure theory and computational methods for excited state molecular dynamics