The existing S-N curves by effective notch stress to assess the fatigue life of gusset welded joints can result in reduced accuracy due to the oversimplification of bead geometries. The present work proposes the parametric formulae of stress concentration factor (SCF) for as-welded gusset joints based on the spline model, by which the effective notch stress can be accurately calculated for fatigue resistance assessment. The spline model is also modified to make it applicable to the additional weld. The fatigue resistance of as-welded and additional-welded specimens is assessed considering the geometric effects and weld profiles. The results show that the error of SCFs by the proposed formulae is proven to be smaller than 5%. The additional weld can increase the fatigue life by as great as 9.4 times, mainly because the increasing weld toe radius and weld leg length lead to the smaller SCF. The proposed series of S-N curves, considering different SCFs, can be used to assess the welded joints with various geometric parameters and weld profiles.