Data Steward guidebook October 2011 – V1

1. HR multicultural MDM by Data Steward guidebook October 2011 – V1

2. Preamble You can also refer to the Data Owner guidebook to get further information about the semantic data model

3. Welcome to HR multicultural MDM • You are interested in HR multicultural MDM to benefit from a unified data repository collecting all information needed to assess HR multicultural projects • When a multicultural project is considered it is necessary to achieve an assessement highlighting your company’s HR strenghts and weaknesses in countries involved • Therefore, before establishing detailed staffing and workloads, you have to work on a more strategic analysis of the project • Does the company hold skills needed in countries involved in the project? • Who is ready to work abroad? What are languages required? • What are HR risks abroad? What are business regulations to enforce? • Etc. Now let us show you how we can help

4. Achieving HR multicultural project assessment pains International project manager • What are our HR strengths and weaknesses to deliver this international project? IT system ? Regulatory organization Regulation by Country HR multicultural manager Qualification level Experience • Who is readiness to work in which countries? • What are languages mastered by whom? • What are persons’ skills by country? • What are regulations to enforce by country? • What are quality of educational system by country? • What are labor market performances by country? • What are HR risks by country? • What are skills needs and regulations to enforce for each multicultural project? Languages Strategic skill Bad data management Bad data management Skill by Person Training organization IT system HR riks by Country Skill by Country Labor market performance by Country Educational system by Country IT Third Party

5. HR multicultural project assessment removing pains International project manager • What are our HR strengths and weaknesses to deliver this international project? HR Multicultural MDM Assessment HR multicultural manager • Who is readiness to work in which countries? • What are languages mastered by whom? • What are persons’ skills by country? • What are regulations to enforce by country? • What are quality of educational system by country? • What are labor market performances by country? • What are HR risks by country? • What are skills needs and regulations to enforce for each multicultural project? • Knowledge management • Unified User Interface • Collaborative work • Permission management • Secured access • Audit trail • Data authoring • Data Query • Data services • Versioning • Workflow • Etc.

6. Now let’s start in HR multicututral MDM

7. Tasks you can deliver with HR multicultural MDM Project Declare project Declare countries and languages involve in projects Declare projects‘ needs, namely skills and regulation to enforce Person Declare persons working in your organization or in third parties Declare persons' languages Declare countries where a person can work and citizenship Regulatory organization Declare regulatory organization Declare regulation Skill Declare skill with type and qualification level Declare detailed description skill by experience level Declare strategic skill that complements with skill to describe strategic needs Country Declare country with key economic figures, alerts and Coface global analysis Declare languages by country Educational system Declare baseline and countries' qualification level Compare qualification level from a country to another Declare training organization with key figures and level of excellence Declare training organizaton's skills KPI Declare KPI structures Declare KPI values for Regulation enforcement by country Declare KPI values for Labor market by country Declare KPI values for Educational system by country Declare KPI values for HR risk by country Declare KPI values for Skill by country Declare KPI values for Skill by person Declare KPI values for Strategic skill by person And all data queries depending on your needs

8. Structure of the HR multicultural data repository

9. Project Project Declare project Declare countries and languages involve in projects Declare projects‘ needs, namely skills and regulation to enforce

10. Project portfolio view Countries and languages involved in projects Project indentification To complement with this tabular view you can use data hierarchy views (see next) Project’s needs  skills and regulations to enforce

11. Project detailed view (1/4) Define countries and languages involved in the project Declare which business regulations must be enforced by the project

12. Project detailed view (2/4) A skill is located at a country Indicate whether subcontracting is permitted or not to fulfill this skill Enter the first skill required by the project Author information which will be useful to support further work on the planning Refine skill definition by providing additional strategic skills when needed

13. Project detailed view (3/4) Enter another skill

14. Project detailed view (4/4) The last skill for this project is about enforcing compliance with the ISO 26000 regulation (social responsibility) Put other information available to describe the project

15. Project predefined data hierarchy views View by Delivery Country View by Manage by country View by skill need View by Type of project Predefined type of project

16. Person Person Declare persons working in your organization or in third parties Declare persons' languages Declare countries where a person can work and citizenship

17. Person directory view Your organization Services provider To complement with this tabular view you can use data hierarchy views (see next)

18. Predefined Person data hierarchy views View by Business Unit View by Internal Party View by Third Party

19. Languages by Person directory view Person’s languages To complement with this tabular view you can use data hierarchy views (see next)

20. Languages by Person predefined data hierarchy views View by Monther tongue View by Person

21. Country where a Person can work - directory view Country where a Person can work and citizenship To complement with this tabular view you can use data hierarchy views (see next)

22. Country where a Person can work predefined data hierarchy views View by Country View by Person Citizenship type is indicated for each country

23. Regulatory organization and Regulation Regulatory organization Declare regulatory organization Declare regulation

24. Regulatory organization directory view Regulatory organization’s main goal Direct website access Integrated textual information To complement with this tabular view you can use data hierarchy views (see next)

25. Regulatory organization data hierarchy view View by Goal Predefined type of regulatory organization, namely organization’s goal

26. Regulation directory view Regulatory organization in charge of regulation Direct website access Direct website access Integrated textual information To complement with this tabular view you can use data hierarchy views (see next)

27. Regulation predefined data hierarchy views View by Organization View by Type of regulation Predefined type of regulation

28. Skill Skill Declare skill with type and qualification level Declare detailed description skill by experience level Declare strategic skill that complements with skill to describe strategic needs

29. Skill directory view (1/4) Skill type Qualification level Integrated textual information to describe every skill To complement with this tabular view you can use data hierarchy views (see next)

30. Skill directory view (2/4) Detailed description of a skill depending on a specific experience level Predefined level of skill experience Integrated textual information to describe detailed skill To complement with this tabular view you can use data hierarchy views (see next)

31. Skill directory view (3/4) Strategic skills complement with skill to describe strategic needs Example next slide Integrated textual information to describe detailed stategic skill To complement with this tabular view you can use data hierarchy views (see next)

32. Skill directory view (4/4) Screen used to fulfill description needs in relation to a project Skill = Construction foreman + Two strategic skills = 5 years in Asia & Speak in Chinese To complement with this tabular view you can use data hierarchy views (see next)

33. Skill predefined data hierarchy views View by Qualification level View by Type of skill Predefined Qualification level Predefined Type of skill

34. Country Country Declare country with key economic figures, alerts and Coface global analysis Declare languages by country

35. Country directory view Country’s key economic figures Coface global analysis Country’s alerts Integrated textual information to describe country’s alerts Integrated textual information to gather country’s strenght and weakness data

36. Educational system structure

37. Country qualification level directory wiew Connection from the standard (baseline) qualification level to country’s qualification level structure Predefined Standard qualification level Base on this repository, France and United Kingdom qualification structures can be compared (see next: data hierarchy view) To complement with this tabular view you can use data hierarchy views (see next)

38. Country qualification level predefined data hierarchy View by Standard qualification level • Comparison France • United Kingdom • for A levels • Baccalauréat • A levels (Advanced Subsidiary-AS + A2) • Bac professionnel ou technologique  • BTEC National Dimploma

39. Training organization directory wiew Country Type of school School key figures Level of excellence Direct website access To complement with this tabular view you can use data hierarchy views (see next)

40. Training organization predefined data hierarchy views View by Country View by Level of excellence View by Type Predefined type of training organization, namely school Predefined level of excellence by reusing the general table Rating scale

41. Training organization’s skills directory view School’s skills Level of excellence applied to a specific school’s skill To complement with this tabular view you can use data hierarchy views (see next)

42. Training organization’s skills predefined data hierarchy View by Level of excellence View by Skill

43. KPI KPI Declare KPI structures Declare KPI values for Regulation enforcement by country Declare KPI values for Labor market by country Declare KPI values for Educational system by country Declare KPI values for HR risk by country Declare KPI values for Skill by country Declare KPI values for Skill by person Declare KPI values for Strategic skill by person

44. KPI structures Predefined KPI for HR risk Predefined KPI for Educational System Predefined KPI for Labor market

45. KPI: Regulation enforcement – Directory view Country Regulation Level of enforcement Source and date To complement with this tabular view you can use data hierarchy views (see next)

46. KPI: Regulation enforcement – Predefined viewes View by Country View by Level of enforcement View by Regulation Example: Canada don’t adopt the Forced Labour Convention - ILO 29 Predefined level of enforcement Dashboards: regulation enforcement by country

47. KPI: Labor market – Directory view KPI Labor market KPI value Source  organization providing the KPI value To complement with this tabular view you can use data hierarchy views (see next)

48. KPI: Labor market – Predefined data hierarchy views View by Country View by KPI Example: value of the Global Competitiveness Index rank (out of 139) provided by the World Economic Forum (WEF)

49. KPI: Educational system – Directory view KPI Educational system KPI value Source  organization providing the KPI value To complement with this tabular view you can use data hierarchy views (see next)

50. KPI: Educational system – Predefined data hierarchy View by Country View by KPI