Clean up Profiles from DB

--Delete custom Profile tables from your Profile repository(Only if you have extended Profile Repository)
delete from dps_user_prevpwd;
delete from dps_user_org;
delete from dps_user_address;
delete from dps_user_roles;
delete from dps_user_org_anc;
delete from dps_user_mailing;
delete from dps_user_scenario;
delete from dps_scenario_value;
delete from dps_user_slot;
delete from dps_usr_markers;
delete from dss_user_bpmarkers;
delete from dcs_usr_actvpromo;
delete from dcs_usr_usedpromo;
delete from dcs_user;
delete from dcs_user_wishlist;
delete from dcs_user_giftlist;
delete from dcs_user_otherlist;
delete from dcs_user_catalog;
delete from dps_usr_creditcard;
delete from dps_other_addr;
delete from dps_mailing;
delete from dps_mail_trackdata;
delete from dps_user_mailing;
delete from dps_email_address;
delete from dps_user;
commit;

Read More