Sunday, December 16, 2012

The Case of the Nosy VP


For my Human Resources Systems and Technology (HRST) class, we were given several case studies to consider.  Here’s my take on #2:

“You are an HRIS Analyst and have been asked by the VP of Finance for the following information from the HRIS system: Name, Job Title, Manager, Salary, Birth Date, Ethnicity, and Social Security Number.

What do you do?”

First, I would need to know why he needs this information and what he intends to do with it.  This information isn’t typically allowed out of the HR team as it contains private and secure information.  We have a corporate Comprehensive Information Security Policy as well as a Department-Specific Information Security Policy.  Also, our corporate headquarters is in Massachusetts and they have a law (201 CMR 17.00) safeguarding their residents’ personal information.  So, I’d need permission from the HR Director to aggregate this information for distribution outside of our department.

Once it’s all settled, above-board, law-abiding and the VP has pinkie-sworn to burn or swallow all incriminating information, then I’ll need to know what kind of file the VP needs – Excel, Word, Accounting Software Specific?

I’d be strongly encouraging Excel since I believe our HRIS is capable of running a report that generates all of the required information into an Excel spreadsheet.  If not, it’ll take a little more time to generate separate reports and combine the information in Excel using Pivot Tables.  I have done Pivot Tables in the past (and our class saw a quick primer/refresher last week), so I’m estimating that the turnaround time for this information is a day or two.

No comments:

Post a Comment