In-situ catalytic upgrading of heavy oil using oil-soluble transition metal-based catalysts