Mott Transition In Strongly Correlated Materials: Many-Body Methods And Realistic Materials Simulations