It is a normally non-pejorative diminutive usage of the names... Alfredo or Federico, if i’m not mistaken.
The “dumb” of course comes from godfather. Don’t go fishing, Fredo.
Fredo wasn’t really ‘dumb’. He just knew he screwed up..