A basic idea is here:
CREATE TABLE #a (MyText VARCHAR(150))
INSERT INTO #a (MyText)
VALUES('Database specialist, database analyst, business analyst')
;WITH Words AS
(
SELECT ROW_NUMBER() OVER(ORDER BY MyText) AS RowNo, LEFT(MyText, CHARINDEX(',', MyText)-1) AS Word, LTRIM(RIGHT(MyText, LEN(MyText) - CHARINDEX(',', MyText))) AS Remainder
FROM #a
WHERE CHARINDEX(',', MyText)>0
UNION ALL
SELECT RowNo, LEFT(Remainder, CHARINDEX(',', Remainder)-1) AS Word, LTRIM(RIGHT(Remainder, LEN(Remainder) - CHARINDEX(',', Remainder))) AS Remainder
FROM Words
WHERE CHARINDEX(',', Remainder)>0
UNION ALL
SELECT RowNo, LTRIM(Remainder) AS Word, NULL AS Remainder
FROM Words
WHERE CHARINDEX(',', Remainder)=0
)
SELECT RowNo, Word, UPPER(LEFT(Word,1) + SUBSTRING(Word,CHARINDEX(' ', Word)+1,1)) AS ShortWord
FROM Words
DROP TABLE #a
Result:
RowNo Word ShortWord
1 Database specialist DS
1 database analyst DA
1 business analyst BA
The rest you need to do by yourself.