The president of ratings agency Standard & Poor's is stepping down just weeks after the credit rating agency cut the US' top 'AAA' rating and sent global markets into turmoil.