Hexaware Technologies Limited · NSE:HEXT
Hexaware Technologies — Technical Presentation (April 2010)
30 slides from Hexaware Technologies's technical presentation, April 2010
Slide 1: EPM HCM Warehouse Solution
EPM HCM Warehouse Solution Hexaware Business Intelligence & Analytics
Slide 2: Hexaware Overview
Hexaware Overview 5924 15th 177 Employees globally Largest software exporter Active Clients worldwide (NASSCOM) 56 66 253 Million dollar clients Fortune / Global 500 USD mn Revenues in CY ’07 (Sep’08) corporations as clients (Sep’08) Founded in1990 – Nearly 2 decades of continued value creation 2 ©
Slide 3: Global Presence
Global Presence Toronto Bad Homburg Chicago Brussels Boston London Atlanta San Jose Paris Dubai New Jersey Frankfurt F kf t Tokyo Mumbai Mexico Pune Chennai Bangkok Singapore Sydney Proximity Center Delivery y Center Sales Office 3 © Hexaware Technologies. All rights reserved.
Slide 4: Vertical and Horizontal Competency
Vertical and Horizontal Competency Industries Travel and Transportation Banking and Insurance Manufacturing Healthcare Technologies Enterprise Solutions (PeopleSoft, Oracle SAP Oracle, SAP, MS CRM) HR IT and HRO BTO/Testing Solutions Business Process Outsourcing Business Intelligence & Analytics Ent
Slide 5: Agenda
Agenda Need for HR Analytics Why EPM HCM Warehouse? Implementation Scenarios Case Study 5 © Hexaware Technologies. All rights reserved.
Slide 6: Typical Data Needs for HR Analytics
Typical Data Needs for HR Analytics Hires by Terminations by a) Age b) Length of service a) Age b) Length of service c) Gender d) Diversity c) Gender d) Diversity across month / quarter across month / quarter Employee turnover by a) Age b) Length of service Employee Performance by c) Gender d) Diver
Slide 7: Why EPM HCM Warehouse?
Why EPM HCM Warehouse? EPM Provides: • Jumpstart in implementing HR Analytics solution and ease in software upgrades • Fully processed data marts (with both fact and dimension tables) that are optimized i i d ffor reporting i and d iinclude l d ddata mart row-level l l security i • Pre-packaged mart
Slide 8: EPM Architecture
EPM Architecture Specialized target warehouse tables, data models models, ETL jobs jobs, metadata metadata, tools and processes Dual Warehouse Architecture – Operational (OW) & Multi-dimensional Warehouse (MDW) – Operational warehouse is divided into OW Staging (OWS) and OW Enriched (OWE) – OWE
Slide 9: Logical Layers of EPM - OWS
Logical Layers of EPM - OWS • An entry point for source data • Offload, consolidate and stage • ETL jobs loads data into OWS tables • No transformations are performed in this layer • N td Not designed i d ffor reporting ti • OWS Error tables are used for data validation • Dimension key validation •
Slide 10: Logical Layers of EPM - OWE
Logical Layers of EPM - OWE • Stores enriched data arranged in a normalized format • Entail many transformations • Used to perform reporting and analysis – ETL Jobs will be used and dimension and fact tables are loaded – OWE tables are augmented with sub-records,, which helps p the ETL process and t
Slide 11: Logical Layers of EPM - MDW
Logical Layers of EPM - MDW The MDW contains a de- normalized table (in a Star Schema) for BI & ad hoc reporting Data in MDW is grouped as it is related to one or more business processes – Surrogate keys – Audit fields – Data aggregation Data in MDW is primarily loaded from OWS – Enriched data
Slide 12: PeopleSoft EPM Functional Warehouse
PeopleSoft EPM Functional Warehouse Solution Details Report / Info Generated Workforce & Organization Total headcount Workforce Health and Safety Headcount change over the last 12 months Deployment Business Process Survey Involuntary separations in last 6 months Benefits Which busine
Slide 13: Implementing EPM HCM Warehouse
Implementing EPM HCM Warehouse Scenario 1 • Source for HR data mart is (Peoplesoft /JDEdwards ) alone and the Source is not customized. Steps: • Based on the report requirements identify the Pre Built HCM Warehouse model that will be used for the implementation • Map p the data model with the report
Slide 14: Work Force – Time & Labor
Work Force – Time & Labor Facts Include: Conforming Dimensions Dimensions Include: Time and Labor Currency Business Unit Number of Hours Business Company Currency Date / Date/Calendar Unit Calendar Person Department Employee Job TA Location Annual Benefit Base Account Annual/Daily Rate Project FTE %
Slide 15: Compensation Payroll Earnings
Compensation Payroll Earnings Dimensions Include: Facts Include: Conforming Dimensions • Currency Payroll Earnings • Business Unit • Date/Calendar • Account Code • Regular Pay Hours • Company Business Company Currency Date / • Regular Earnings Hours • Pay Group Unit Calendar • Regular Hours • Depart
Slide 16: Implementing EPM HCM Warehouse
Implementing EPM HCM Warehouse Scenario 2 • Source for HR data mart is (Peoplesoft /JDEdwards ) alone and the source is heavily customized. • Steps: • Do a FIT GAP Analysis • Based on the report requirements Identify the Pre Built HCM Warehouse model that will be used for the implementation • Map th
Slide 17: Implementing EPM HCM Warehouse
Implementing EPM HCM Warehouse Scenario 3 • Multiple sources and one of them is Peoplesoft • Report requirements fits the existing EPM HCM models Steps: • Do a FIT GAP Analysis D A l i • Customize the Pre built data model based on the report requirements • Install and Configure EPM HCM Warehouse • I
Slide 18: PeopleSoft Org Tree and Security Setup
PeopleSoft Org Tree and Security Setup • HCM Security is assigned based on tree hierarchy approach. • Two types of trees – Balanced and Unbalanced • Tree information is stored in the following tables: – PSTREENODE – PSTREESTRCT – PSTREELEAF – PSTREEDEFN – PS_TREE_NODE_TBL PS TREE NODE TBL – And Orga
Slide 19: Row Level Security - Screenshot
Row Level Security - Screenshot Step1 – Setup Position / Dept Tree 19 © Hexaware Technologies. All rights reserved.
Slide 20: Sample Tree
Sample Tree DEPARTMENT DEPT CHILD 1 DEPT CHILD 2 DEPT CHILD 3 Dept Child 21 Dept Child 23 Dept Child 11 Dept Child 13 Dept Child 22 Dept Child 31 Dept Child 32 Dept Child 12 Dept Child 33 105 106 110 101 102 103 104 107 108 109 111 112 11320 © Hexaware Technologies. All rights reserved.
Slide 21: Tree Flattening
Tree Flattening Level1 Level2 Level3 Level4 Department p Dept p Child1 Dept p Child11 101 Department Dept Child1 Dept Child12 102 Department Dept Child1 Dept Child12 103 Department Dept Child1 Dept Child13 104 Department Dept Child2 Dept Child21 105 Department Dept Child2 Dept Child21 106 Department
Slide 22: Setup Security
Setup Security Setup the security in EPM using Dept dimension User Tree Node U1 Dept Child33 U2 101 U3 Dept Child1 U4 Dept Child12 U5 Dept Child11 Run the Custom ETL to Flatten the tree and put all levels into custom table 22 © Hexaware Technologies. All rights reserved.
Slide 23: Join Flatten Tree with Security Table
Join Flatten Tree with Security Table • After Joining the security data With Flattened dept Table p security the dept y table will have following g data User ID Dept Id U1 111 U1 112 U2 101 U3 101 U3 102 U3 103 U3 104 U4 102 U4 103 U5 101 23 © Hexaware Technologies. All rights reserved.
Slide 24: Import Tables into Cognos
Import Tables into Cognos Import the Dept dimension, Dept security and HR fact table into Cognos Link the Dept security with Dept key of the HR fact table Create a security filter for user id so that when the user logs in he will be seeing only data he has access to at that point of time. E Ex
Slide 25: EPM Challenges and Solutions
EPM Challenges and Solutions C - Each countryy stores its employee p y data in a different way y and used PeopleSoft for payroll only S - Proposed solution had all the security data and data for OWE dimensions pulled from PeopleSoft and each country now sent its employee l iinformation f ti iin a co
Slide 26: EPM Challenges and Solutions
EPM Challenges and Solutions C - Need to translate list of values (gender, job codes, employee status, etc ) as each country sends the employee data the way they store in etc.) their local system and not in the way data is required in EPM S - Proposed solution had a translation logic built in EPM wh
Slide 27: EPM Challenges and Solutions
EPM Challenges and Solutions C - Need to convert date field into standard format as each country use their own format in sending the date info which varies S - We built an online page in EPM which stores the format each country sends for date columns. The ET Logic will use this information in the un
Slide 28: A Case Study – Leading Insurance Co., USA
A Case Study – Leading Insurance Co., USA Business Situation Business Benefits • Client’s need for common reporting and analysis of Decrease in overall effort (about 30%) in the HR information across its International Businesses overall lifecycle of the HR Analytics development • Identify reporting
Slide 29: Summary
Summary • Need for HR Analytical Solution • Benefits of Implementing EPM • The 4 data marts in EPM HCM Warehouse & how it suits the business needs • H How tto implement i l t EPM for f different diff t scenarios i • How to implement Row Level security • EPM Challenges and success story 29 © Hexaware
Slide 30: Questions & Answers Thank You
Questions & Answers Thank You 30 © Hexaware Technologies. All rights reserved. www.hexaware.com
Hexaware Technologies — Technical Presentation (April 2010) on 6ix