If you are "picking holes in something" then you are also "finding fault", but the reverse is not true. "Picking holes" occurs only when you are finding fault with someone's logic.
I would say it is usually wrong to say "picking holes in my work". You can find fault or criticize someone's work, but you only pick holes in their work if their work is of a logical nature. If their work is to explain, then you can pick holes in their work. If they are a computer programmer, you can pick holes in their coding by pointing out their logical errors. However, if they are gardeners who have done a terrible job planting, you cannot pick holes in their work. You could, however, pick holes in their landscape plan.