MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- create table
CREATE TABLE ResumeActivityLog1 ( ResumeDID VARCHAR(255), CreatedOn  VARCHAR(255));
CREATE TABLE ResumeActivityLog2 ( ResumeDID VARCHAR(255), CreatedOn  VARCHAR(255));

-- create procedure
CREATE  PROCEDURE `SaveMultipleResumeActivityLog1`(
    _resumeDIDs           Text
)
    INSERT INTO `ResumeActivityLog1` ( `ResumeDID`, `CreatedOn`)
    SELECT ResumeDID,"2021"
    FROM JSON_TABLE(CONCAT('["', REPLACE(_resumeDIDs, ',', '","'), '"]'),
                    '$[*]' COLUMNS (ResumeDID VARCHAR(255) PATH '$')) jsontable;

-- create procedure
CREATE  PROCEDURE `SaveMultipleResumeActivityLog2`(
    _resumeDIDs           Text
)
    INSERT INTO `ResumeActivityLog2` ( `ResumeDID`, `CreatedOn`)
    SELECT ResumeDID,"2021"
    FROM JSON_TABLE(CONCAT('["', REPLACE(_resumeDIDs, ',', '","'), '"]'),
                    '$[*]' COLUMNS (ResumeDID VARCHAR(255) PATH '$')) jsontable;
-- call procedure with CSV as a parameter
CALL SaveMultipleResumeActivityLog1('a,b,c,d,e,f');
CALL SaveMultipleResumeActivityLog2('a,b,c,x,y');

-- check for the result
SELECT * FROM ResumeActivityLog1;
SELECT * FROM ResumeActivityLog2;

select *
from `ResumeActivityLog1` p
where not exists (
  select * from `ResumeActivityLog2` q
  where q.CreatedOn = p.CreatedOn
);

ResumeDID	CreatedOn
a	2021
b	2021
c	2021
d	2021
e	2021
f	2021

ResumeDID	CreatedOn
a	2021
b	2021
c	2021
x	2021
y	2021