Learn English – Any idiom for a person who has solution of every single problem

In English, we have the infamous know-it-all: one who knows everything; hence, a person who makes pretension to great knowledge, especially one whose didactic conversational habit conspicuously reveals his belief that he has superior knowledge on many subjects; a wiseacre; a know-all; -- usually ironical. [Colloq. & pejorative] Note: the use of this term implies that the speaker disapproves of this behavior, and may think that it is unjustified.

**know all: someone who seems to know everything and annoys other people by showing how clever they are.

No one likes him because he's such a know-all.

smarty-pants is an older idiom, for one who is obnoxiously self-assertive and arrogant, as is weisenheimer.

There is the Jerkass, who might say something like, "Sometimes I park in handicapped spaces while handicapped people make handicapped faces. I'm an asshole!" (— Denis Leary, Asshole) but this is more trope or jargon.

And, as StoneyB has kindly reminded me, there is the loudmouth:

Be loquacious, often noisily or boastfully; someone who talks too much or too loudly, esp. in an offensive or stupid way

*Harvard Square: Know-it-all capital of the universe. * - Universal Hub.

In this situation, I would say he "knows it backwards". The implication is that one knows something so thoroughly that they could do it in reverse.

Also consider

"knows it backwards and forwards"

{Cambridge Dictionary of American Idioms}

and "knows it inside out"

{McGraw-Hill Dictionary of American Idioms and Phrasal Verbs}.

"knows it like the back of his hand" does often, but not always, have a geographical connotation.