You should consider to make use of an author template. It will allow you to control how the author page is displayed, so you can add what you pictured into there.
You can then register a rewrite endpoint to create the multiple areas of the author page. In the template just check on which “subpage” you are and display the tabs and listing accordingly.
That’s basically doing WP_Query then which is pretty well documented, so should be an easy start.