Page 121 - NovDefComp

MASSACHUSETTS MUTUAL LIFE INSURANCE COMPANY
Defined Benefit and Defined Contribution

Recordkeeping Operations System

Controls Specified by Testing Performed by KPMG LLP and Results of Tests
MassMutual Business

7.6 Contribution transactions are Inspected contribution documentation and PRS screenshots,
subject to an independent quality and AWD workflow screens for a selection of contribution
review by a recordkeeping transactions that were independently quality checked after data
operations associate based on entry, but prior to nightly posting and determined that they were
pre-determined sampling processed completely and in accordance with documentation
parameters established in AWD. provide by the participant or plan sponsor.
The review is done after data
entry but prior to the nightly No Exceptions Noted.
posting to PRS to determine that
they are processed completely
and accurately in accordance
with the documentation provided
by the participant and/or Plan
Sponsor. The review is
evidenced by “Passed” status in
AWD. (DC)

7.7 Data files are uploaded to Inspected the system upload configurations for a selection of
the web servers by Plan data files uploaded to the web servers by Plan Sponsor and
Sponsors via the TRC, Secure determined that they were uploaded via the TRC, through SFTP,
File Transfer Protocol (SFTP) and VPN.
and VPN. A batch job moves the
data from the web servers to the Inspected the data file upload batch job and determined that it
was configured to move the data from the web servers to the
staging area for data exchange
processing every fifteen minutes. staging area for data exchange processing every fifteen minutes.
(DC) No Exceptions Noted.

7.8 All contributions processed Observed the processing of a transaction that failed to post to
through the TRC are combined the database during the nightly batch and determined that an e-
with other transactions and mail and ToDo was sent to recordkeeping operations associates
posted to PRS overnight. to notifying them of the transaction that failed to post.

PRS is configured to identify and Inspected a selection of To-Dos and system screenshots for
log transactions that cannot be unposted transactions and noted that transactions were
posted to the database during researched and resolved.
the nightly batch. An e-mail and No Exceptions Noted.
ToDo is sent to recordkeeping
operations associates who
follows-up and resolves
unposted transactions. (DC)

MassMutual Defined Benefit and Defined Control Objectives, Related Controls and Tests of
Contribution Recordkeeping Operations System Operating Effectiveness
73