HRIS Case Study – Strategic Leadership India -LLC PDF

Preview

Summary

Case Study – Actual Work Product IMPLEMENTATION OF A - HRIS FRAMEWORK Strategic-Leadership-LLC-India Index: Abstract / Executive Summary: 1. Abstract / Executive Summary – Pg.1 The objective of this case study is to present to 2. Industry Background - Pg.2 prospective clients - our knowledge, skills...

Description

Case Study – Actual Work Product IMPLEMENTATION OF A - HRIS FRAMEWORK Strategic-Leadership-LLC-India

Abstract / Executive Summary:

Index: 1. Abstract / Executive Summary 2. Industry Background 3. Description of Business 4. The HRIS- Planning Stage 5. Leave Management -Offline Process a. LMS - An Effective Transaction Processing System b. Data Cleansing and Validation c. Test Environment d. Data Security e. Application Level Triggers f. Testing Roadblocks and Challenges g. Post Implementation Functionalities

Acronyms used – PCMS – Performance and Competency Management System LMS – Leave Management System

- Pg.4 - Pg.4 - Pg.4 - Pg.5 - Pg.5 - Pg.6 - Pg.6

Pre Implementation Existing / rudimentary / offline – Performance Management & Leave Tracking processes. Post Implementation –

6. Performance Management – Offline Process

- Pg.8

a. The Challenges with Offline Process b. Performance Management – Entity Relationship Diagram c. Online PCMS Advantages d. User Friendly Interface e. Enhanced Functionalities f. Schedule Adherence 7. Conclusion

The objective of this case study is to present to prospective clients - our knowledge, skills and abilities to "synthesize" the clients need and deliver a integrated HRIS solution.

– Pg.1 - Pg.2 - Pg.2 - Pg.2 - Pg.3

Overview of the Online – PCMS & LMS – Related IT and Information Infrastructure.

- Pg.9

Industry Background:

- Pg.9 - Pg.9 - Pg.9 - Pg.10 - Pg.10

Client Name was established in late 2005 as a fully owned IT Infrastructure subsidy of the CLIENT NAME Group, the organization grew from 20 to 100 in a span of @ 6 months. As factors in the external and internal environment were conducive to growth the organization is rapidly scaling up, employee strength is increasing (100 Employees as of March 2012, year end target 300+) so is the geographical spread. CLIENT NAME already has its employees at two locations within Bangalore and at Gurgaon.

- Pg.11

Description of Business: The CLIENT NAME Group is a worldwide leader in Financial Protection. CLIENT NAME's operations are diverse geographically, with major operations in Europe, North America and the Asia/Pacific area. For 1H09, IFRS revenues amounted to Euro 48.4 billion and IFRS underlying earnings to Euro 2.1 billion. CLIENT NAME had Euro 967 billion in assets under management as of June 30, 2009.

1 HRIS Case Study – Strategic Leadership India - LLC

4. The resources assigned to carry out these and other similar projects constituted of –

The HRIS- Planning Stage:

a.

The Information Technology Team Lead and two team members ( additional resources were at the discretion of the Project Manager subject to availability) b. The Information Systems Manager and three team members ( additional resources were at the discretion of the Project Manager subject to availability) c. The HR Assistant Manager ( additional HR resources were not available )

The IT Strategy of the organization was Primarily driven from Germany (the Corp HQ of the MNC) , this strategy was clearly aligned towards implementation of a scalable company wide integrated - Human Resource Information System / Management Information System / Enterprise Resource Planning Platform - SAP. 1. Currently all international entities like – Belgium, Germany, France, England and Australia were in transition mode from locally / internally built HRIS to SAP. India as an entity was to decide how to transition from offline manually driven processes to SAP over the span of next 2 years, by when the size of the Indian entity could justify a SAP implementation. ---------------------------------------------------------------------

5. Strategic-Leadership-India was consulted as most of the functional know how was not present internally. 6. The Project Planning was the joint responsibility of the Information Systems Manager and Rohit . The Information Technology Team Lead provided access to the IT Infrastructure – Test Servers, Testing Environment, Development Environment, the Build and Release Environment.

The resources allocable to such a transitional project were limited. We have not shared the details of budget allocated to this project as it’s confidential to CLIENT NAME .

7. The Project Manager was given discretion to take decisions (within budget and other agreed limits) and was given access to additional resources of the IT and IS team as and when required, rider being that there should not be unnecessary interruption to normal BAU activities. All affected departments IS, IT and HR were consulted by the Project Manager during the planning of the project on all matters that affected their people and resources. This was done by means of weekly progress review meetings.

2. CLIENT NAME had to decide which HR Applications had the most Business Critical data. This decision was required to zero in on the quick-wins for the Transition Project. It helped them identify applications with the most critical data – data which was required over a period of time, data which could not be inaccurate, as its inaccuracy would impact the business. 3.

It was decided that the very first automation of processes would be for Leave Management and Performance Management. a. Functional interoperability was critical for these applications as they were to be the base upon which the SAP Structure was to be built at a latter date. b. These and the systems which were to follow were not to expect changes in process, but were to rather aid the existing process by making it agile and online. c. The processes as such were not faulty they had been tweaked with the in house Six Sigma methodology. d. Thus this project was to be a vanilla automation of a healthy existing offline process.

Pre Implementation – Leave Management Offline Process: In this section we describe the AS IS process for Leave Management and share challenges in the offline leave management process. Most of these challenges were overcome by automation of the process. The Data consistency, accuracy and authenticity were ensured as a result of the automation. This data was available in real time and thus was ready to be ported onto the SAP system - this being the primary objective of the project – a smooth transition to SAP from offline processes.

2 HRIS Case Study – Strategic Leadership India - LLC

10. There was substantial time wasted by the HR resources on these transactional activities and still the data was never to be found accurate when required. The worksheet used for maintaining this data offline was akin to the worksheet seen - Figure 1.1 below :

1. Employee joins the organization; HR creates the EMP ID by increasing the counter in a Worksheet. 2. Employee is authorized X numbers of days of Earned Leave ( EL ) , Y number of days of Casual Leave ( CL ) along with Sick Leave , all these are entered into the Worksheet as starting balances on DOJ or as accrued balance from the date of confirmation. 3. Every time an employee applies for leave the Leave Application form duly signed by the Employee, Manager and HR needs to be filed in the personal file. 4. In case this leave application form is misplaced there is no documented proof of leave availed. This used to create problems during compliance AUDITS – ISO etc. 5. The HR team needs to enter leave data manually for all employees and debit the Worksheet of the leave balance once the Leave form had been submitted. Sometimes managers shall be tied up and will not sign the leave form. There shall always be issues around the accuracy of data in this worksheet and also about the storage and safe keeping of the pages of leave application. 6. An employee’s real time leave balance shall only be available with the HR business partner or the Manager if he also maintains a worksheet. 7. If the manager maintains a worksheet then there shall be synchronization issues between the two worksheets. 8. The leave data is critical for employees on client projects as they cannot be billed on the dates they take either CL or SL , the EL’s are usually planned for in advance and are thus flagged in the project management & planning tools of the client also. 9. It was sometimes warranted to integrate the Attendance tracking system – swipe in system data with the leave data. Especially so for invoicing T&M projects. The clients required Leave and Attendance data as part of these invoices. This was a challenge as data was maintained offline and client did not believe the authenticity of the data.

( Figure ) data maintained offline. Figure ( 1.1 )1.1 Leave

The Leave Management System – An Effective Transaction Processing System: The Leave Management System was envisioned as an ideal Transaction processing System, which would provide real-time data, the essence being that leave data is managed in such a manner that after each transaction with the system the data is left in a consistent state. Transaction processing as a model for development was also implemented for the entire HRIS (LMS, PCMS and the subsequent modules). Transactions made by employees and managers in real-time were to be viewed as stand-alone transactions both at the request stage and end result / out put stage. These were inputs for many a internal and external stakeholder processes – client invoicing,

Let’s understand this advantage with an example –  Ram is allocated to work in a team whose Client Resource Manager is stationed in Australia (employee of CLIENT NAME Australia). The project is being executed for CLIENT NAME’s Australia office. Ram is based in Pune his Operational Reporting is mapped to the IT Manager stationed at Bangalore (there is no manager level employee stationed at Australia). Ram can not be mapped to the Australian employee as this shall lead to Employee Relation issues. If Ram applies for leave being in Gurgaon, his manager approves the same being stationed at Bangalore this transaction is over.

3 HRIS Case Study – Strategic Leadership India - LLC

 The system immediately needs to provide the relevant out put from this transaction as an input to the Client Resource Manager. This was not possible from the offline system. There the Manager at Bangalore or Ram at Gurgaon would be required to email the manager in Australia. The LMS was built keeping these Real-time Transactional benefits in mind.

c. An EMP_INFO table within the LMS database was created , its various record types were – 1. Emp ID of Employee 2. Name of Employee 3. Emp ID of Resource Manager 4. Name of Resource Manager 5. Email ID of Employee 6. Email ID of Resource Manager

Data Cleansing and Validation:

d. Forms were also created for the Resource Manager and the HR Business partner. The Manager could view a listing of his entire team along with their various leave balances. He could also view the Applications Pending for approval. Within this form itself he had a URL that took him to another form where he could conduct individual leave transactions. Approvals / Rejections reflected in real-time to the employee and the HR Business Partner.

As the LMS was a highly data dependant application the very first step taken was the validation of the Leave Data available with the HR team , the different functional teams and the client resource managers ( being the case for two teams working on Payroll of CLIENT NAME but under direct Operational Control of Client Managers ). Manually updated worksheets were emailed to al concerned Resource Managers and their inputs consolidated in a master sheet.

e. The Leave_MASTER , table within the LMS database was created , its various record types were – 1. 2. 3. 4. 5. 6. 7. 8.

This data was then signed off by the respective Business Unit Heads. This was to be an ongoing process till the Leave Management System went live as this data was changing almost daily.

Test Environment: With the live data ported into the leave Master Database a test environment was created for the application –

EL_Opening Balance EL_Closing Balance EL_Applied Date EL_Approved Date CL_Opening Balance CL_Closing Balance CL_Applied Date CL_Approved Date etc.

These records were updated for every transaction through SQL queries and the Leave Master database was kept updated in real-time.

a. The test environment was to have a pilot application running with all the functionalities of the actual LMS.

f.

b. The front end forms which were created were – A Dash Board / Landing Page for the Employee which showed his current EL, CL & SL Balances. This form gave the employee option to apply for these leaves and also for the SL and Maternity Leave (for female employees). The moment the employee applied for a leave an auto email intimation was sent from the Email Server to the mapped Resource Manager and the HR Business Partner.

Various Reports were catered for and tested in the Test Environment – 1. Resource Managers Team Report 2. Finances Billing / Invoicing Report 3. Attendance Report 4. Payroll Report The need was felt for varied reports as all stakeholders did not require all the data that was stored in the Leave master database. All these reports exported in the form of worksheets.

4 HRIS Case Study – Strategic Leadership India - LLC

Resource Manager and his/ her Manager if leave not approved / rejected within 24hrs of application. This was deemed necessitated as the Resource Manager could be on leave themselves.

Data Security: Data security was catered for at two levels one at the individual user level and the application level. This pattern of data security was also replicated for the PCMS and the subsequent HR Modules developed within the HRIS.

3. Trigger to HR and Resource Manager in case employee is absent – has not swiped in nor has logged into designated workstation. This was possible as the LMS was integrated with the Swipe In Attendance tracking system.

Individual User Level - Employees (with no direct reports) could access only personal data, of which they could modify only limited data i.e. – Office Extension, IP Phone etc, for most other data the approval from the Resource Manger was mandatory in some cases a secondary approval was required from the HR Business Partner. None could view the data of other employees / access data of other employee’s direct reports.

4. The reminder to managers for Confirmation of Employees post the 6 months probation period. This trigger was similar and parallel to a trigger in the PCMS.

Testing Roadblocks and Challenges: It is never easy to replicate a test environment exactly in the manner that we would desire a live application environment, even after the very best efforts of the IT team a majority of bugs were trapped at the actual execution level after the Go Live / Implementation.

Application Level – The LMS, PCMS and the modules created subsequently as part of the HRIS had mandatory secondary logins. The Passwords had 28bit encryption and were similar to the Windows Login. This ensured that no other employee could login and alter the information of any other employee.

During the test phase certain challenges were faced which were –

Also included in application level security were the concerns for Employee Privacy or data secrecy. For example the training team could only view the Training Requirements posted as part of the PCMS by Resource Managers and could under no circumstances see / generate reports on employee leave and employee salary etc.

1. Inconsistent Leave data, the HR team had to go through almost 15 iterations before data could be frozen. Kurt Lewin’s Change model recommends – Unfreeze - Change – Refreeze, sometimes the data would change before the refreeze, and this was by far the most prominent functional challenge.

Application Level Triggers:

1. The first reminder to managers for leave approvals, an auto generated email sent to the manager if leave not approved / rejected within 12hrs of application.

2. It was easy to train employees on the functionalities of the Leave Management System but it was a daunting task to make them change their attitudes and lax behavioral patterns. Everyone was used to the offline Leave Process, the offline process was Batch processing transactions. There was always scope, time and bandwidth for timely corrections. Real-time processing capabilities of the Leave Management System warranted accuracy and authentic transactions.

2. The second reminder to managers for leave approvals, an auto generated email sent to the

a. Changing data once entered for leave applied required a cancellation which would again trigger

The LMS had certain application level triggers which were mandatory to remind the stakeholders of certain timelines etc , these were –

5 HRIS Case Study – Strategic Leadership India - LLC

an alert and require the manager’s approval for cancellation.

b. The HRIS as also the PCMS had a client server / thin client architecture, thus keeping the IT infrastructure cost minimal. The desktops required no changes of hardware of configuration etc.

b. This was considered as an overhead by most employees but imbibed a sense of discipline and accuracy into the daily functioning.

c. There were no additional requirements or costs.

Few challenges warranted a re-look at organizational policy and structure an example is as seen below -

networking

d. Web interfaces were not planned as the data was sensitive & business critical. There was thus no external web hosting costs.

3. A challenge that led to policy change and partial Org. restructuring was - email ID’s of the Employees and Resource managers were frequently required to be updated in the database. This was so that they reflected the current reporting. Reporting had become dynamic and flexible due to frequent project allocations and resources sharing for batch projects.

e. Hardware costs were minimal as internal servers were used to co host these applications with other internal applications.

Application Specific Advantages –

It was thus warranted that the concept of the Resource-manager or Pool-manager being distinct from the Functional Manager be introduced. The Resource Manager was to handle the Operational reporting for employees within a Batch project. The Functional Manager was to handle the functional reporting for employees with related, similar or aligned competencies i.e. Network Engineers, Java Developers, .Net engineers, Technical Helpdesk Associates etc. Employees operationally became pool resources. Their Leaves were sanctioned by the Resource manager, billing was invoiced by the resource managers and the Performance was appraised by the Functional managers.

1. No need for creation of employee iD’s manually, the employee master process increments the EMP_ID counter. 2. All employees have similar leave authorization thus on creation of new employee database populated with authorized number of EL’s, PL’s & CL’s. The SL and Maternity Leave are transaction dependent; these are debited on need basis from the Employee leave Master table. 3. An employee leave transaction is complete when it goes through the following six steps:i. Employee validates available leave balance – done within the employee form, as realtime balances are available. ii. Employee triggers leave application by choosing – “from” and “to” date, choosing leave type and resource manager name (in certain cases employees were mapped to 2 resource managers). Employee fills in the address, contact details while on leave if the leave period is beyond 3 days. iii. Email is triggered to Resource manager, HR Business Partner giving all ...