Complex sentence: Franklin transitioned to a studio executive position at Metro-Goldwyn-Mayer and ultimately Sony's Columbia Pictures, where he rose in the ranks to become Senior Vice President of Production.
Split into simpler sentences: Franklin transitioned to a studio executive, first at Metro-Goldwyn-Mayer, and then to Sony's Columbia Pictures. During his tenure at Columbia, he rose in the ranks to become Senior Vice President of Production.