Semi-empirical many-body formalism of optical absorption in nanosystems and molecules