GFIS

1. IO – proseminarium November 2006 GFIS Global Finance Interface System

2. What is GFIS? GFIS is a set of financial and information access applications that allows managers to track engagement efforts and finances at a global level. GFIS includes work-in-process accounting through billing, collections, and general ledger applications. • A global business management system built to improve financial results, drive greater efficiencies and support growth • Operates seamlessly across borders • Provides flexibility in reporting and data analysis • Centrally managed for mutual benefit • Establishes the cornerstone of a truly global infrastructure Who (is / has been) impacted? • Everyone. • Because implementation of GFIS is connected to business model changes and many system replacement / modification - deployment will impact everyone in X Poland: • All Business Lines (business model, planning, budgeting, client, engagement setup, time & expense record, billing, reporting, etc.), • Accounting Department (new statutory and management systems, reporting, etc.) • Information Technology Department (new system selection, local system modifications, building GFIS interfaces, etc), • Human Resources Department (Payroll and HR system modifications,etc).

3. Participants • Central Europe & Switzerland • Austria • CESSA • Croatia • Czech Republic • Hungary • Slovakia • Slovenia • CIS • Azerbaijan • Belarus • Kazakhstan • Kyrgyzstan • Russia • Ukraine • Uzbekistan • Germany • Netherlands • Poland • Switzerland • Continental Western Europe • Belgium • France • Italy • Luxembourg • Spain • Northern Europe Middle East, India & Africa • Global • India • Ireland • Middle East • Bahrain • Egypt • Jordan • Kuwait • Lebanon • Middle East Head Office • Oman • Palestinian Authority • Qatar • Saudi Arabia • Syrian Arab Republic • United Arab Emirates • S Africa • Botswana • Namibia • South Africa • Swaziland • Sweden • United Kingdom • Americas • Canada • Mexico • SASA • Argentina • Bolivia • Brazil • Chile • Colombia • Ecuador • Paraguay • Peru • Uruguay • Venezuela • United States • Far East • China / Hong Kong • Oceania • Australia • New Zealand

4. Technologies Used • PeopleSoft 8.4 • Business Objects • Crystal Decisions • Oracle Database • Lotus Notes • MS .NET • MS SQL Server • Hyperion Essbase • GFIS JET • MS Office (Access, Excel itp…)

5. European Data Center Americas Data Center Spain LIS Australia LIS GFIS Architecture

6. GFIS System Components Accounting Transaction Component Engagement Transaction Component • PeopleSoft 8.4 • Visual Basic • .Net • PeopleSoft 8.4 Project Costing PeopleSoft General Ledger PeopleSoft Accounts Payables Billing- PeopleSoft & gBiller PeopleSoft Accounts Receivable Engagement Standard Reporting Component Accounting Info Warehouse (AIW) Reporting Component • Oracle Database • Business Objects • Crystal Decisions • Lotus Domino • Excel • Business Objects Engagement Standard Fixed Presentation & Ad-hoc Querying Accounting Data Analysis Presentations Engagement Datamart Component Accounting Datamart Component • Oracle Database • Business Objects • Hyperion/Essbase • Lotus Domino • Excel • Hyperion Essbase • Excel Accounting Standard Fixed Presentation & Ad-Hoc Querying Client & Engagement Data Analysis Reference Component

7. Implementation Model

8. Poland system changes System to be replaced by GFIS / gT&E or other solution System to be modified ORACLE GL,AP,AR ORACLE Fixed Asset Management STAR Time Reporting INVOICE PROCESSING Billing INTERFACES (Star, Oracle, Personnel, Bank, Payroll Interface, Weco, Credit Control) BUDGETING SYSTEM Financial Planning & Analysis SIMPLE Payroll EY ENGAGEMENTS EY HR HR System EY CLIENTS CREDIT CONTROL Accounts Recv Mgmt RMS (AABS) Resource Management / Staffing ARCD (AABS) AMI (AABS) Planning and Budgeting VACATION, LEAVE SYSTEM OVERTIME REQUEST SYSTEM TRAINING CALENDAR

9. Interfacing To and From Local Systems GLOBAL HR REPOSITORY Local IN Local OUT EMPLOYEE INFO HUMAN RESOURCE SYSTEMS ORGS TO LOCAL LOCAL SYSTEMS GIS TIME & EXPENSE SYSTEMS (including gT&E) TIME/EXPENSE ENGAGEMENTS TO LOCAL AP VOUCHER EDI ACTUALS TO LOCAL INBOUND BANK INFORMATION BANK INFORMATION PLANNING/PM PAYROLL, TREASURY,AND OTHER APPROVEDDATA SOURCES GL BATCH UPLOAD LOCAL BANK COMMUNICATIONS SOLUTIONS LOCAL BANK BANK INFORMATION PAYROLL PAYROLL TO IMPREST PLAN AND FINANCIAL ADJUSTMENTS PLANNING/PMc CHECK PRINTING SYSTEMS COST RATES COST RATE PROVIDER CURRENCY PROVIDER CURRENCY RATES GFIS CURRENCY PROVIDER DUN & BRADSTREET

10. GIS? A Global Interface Staging (GIS) area has been created in order to provide a central location for interface management. The GIS is available to all systems that are required to deliver and/or receive interfaces from Global Applications that employ the GIS. The GIS creates a barrier between the production servers and interfacing applications. Keeping issues related to local country access, security, transmission, and storage, from impacting processing on production machines.

11. The Problem – Complexity of Interfaces Interaction with interfacing systems without a GIS. All interfacing system(subscribers) have direct access to the Global Application’s production servers. Global Environment Production Servers FTP Server open to the internet. External Systems (D&B , other 3rd Party Vendors) Local Country Systems

12. The Solution – Global Interface Staging. Interaction with interfacing systems(subscribers) using the GIS. The GIS will be a barrier between the Global Applications and subscribers. Subscribers will not have access to the Global Application’s production servers. Global Environment Global Applications FTP Server open to the internet. GIS (Unix Server) External Systems (D&B , other 3rd Party Vendors) Local Country Systems (T&E, Payroll)

13. The Production Architecture

14. Secure Shell (SSH) • The chosen transport protocol of GIS • Meets company’s network security standards • Provides automatic encryption, compression, and integrity • Each SSH “login” has a public and private key • SSH requires local systems to install SSH software to access GIS on a designated GIS device • Each LE or group of LEs should have a single device connecting to the GIS • Local system developers will likely also need SSH software to enable their development efforts • Secure FTP (sftp) is one method of transporting files via SSH

15. Secure Shell (SSH) (Cont.) • Key Features of SSH • Authentication: reliably determine user’s identity • Encryption: scrambles data so it is unintelligible, except to the intended recipient. Whenever data is sent by a computer to the network, SSH automatically encrypts it. When the data reaches its intended recipient, SSH automatically decrypts. • Compression: minimizes file size for efficient network transport • File Integrity: guarantees the data traveling over the network arrives whole and unaltered • SSH Login (Subscriber ID (ISSI)) • Command shell on remote machine (limited execution power) • Enables movement of files from GIS to local system and vice-versa • Enables movement of files between directories on GIS

16. SSH File Movement

17. Directory Structure • Allows for multiple environments (production, testing, or development), applications, ISSIs, and interfaces Base Directory (Unix file system on which the interfaces will reside) Application ( e.g., gtr, ghr, gdf,…) Environment ( Production, Testing or Development) gshared (to be used by all ISSIs) ISSI (SSH login used to access GIS) Interface (name of the interface) IN (inbound interfaces) OUT (outbound interfaces) LOG (interface logging and/or processing info) ARCHIVE (processed files) ERROR (rejected or error interfaces)

18. Questions?