Profilbild von Guylain deFranceDeTersant Architect, Project Manager & Senior Financial consultant FI-REFX-CO-AA aus Munich

Guylain de France De Tersant

verfügbar

Letztes Update: 18.02.2023

Architect, Project Manager & Senior Financial consultant FI-REFX-CO-AA

Abschluss: BSc Computer science
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: englisch (Muttersprache) | französisch (Muttersprache) | italienisch (Muttersprache)

Dateianlagen

REFX-Guylain_MUC-EN-100.docx

Skills

Senior SAP REFX and IFRS16 consultant and integration of GIS, AutoCAD, BOBJ, SAP, FI, CRM, Google, ESRI, DMS, HANA, database, BPC, , SAP CRM, Document Management, REFX, ESRI integration, REFX/CRM, Data Migration, Business Objects, Primavera, GIS, visualization, Documentum, data cleaning, data collection, Google maps, JDE, JDA, Lawson, Solomon, SAP 5.0, SAP R/3, SAP BW, SAP APO, PKMS, Optiva, Cognos, EDW, Teradata, PeopleSoft, POSDM, WebUI, ABAP, VBA, SAP Modules, IM, PS, SD, PM, PP/QM/WM, HR. Integration between FI/CO, AA, FILA, SM/MM, PP, QM, REFX-AA-FI, LA, ESRI/GIS GOOGLE & BING maps, AutoCAD for drawing software, SAP ECC 6.0-EhP 7.0 BW 3.5, IS-Automotive, IS-Retails, IS-Real, Estate 6.0, EIS (Executive Information System), Microsoft, CRM Customizing, DB Admin UNIX/ Oracle, SAP Install, Sun Solaris

Projekthistorie

06/2020 - 06/2020
Consultant

* Delivery of SAP training for Financials and Controlling classes
* AC.010/AC.040/AC.050/AC.200/AC.410/AC/415

01/2018 - 06/2020
Visionary, Architect, Project Manager & Senior Financial consultant

Client: Energy - Senior Architect of SAP REFX (Flexible Real Estate), SAP REM (Real Estate
Management) and IFRS16 for Five countries Integration with Land Use Management, Fixed Assets,
Plant Maintenance.

Client: SAP Canada - Training on RE050 EFX-IFRS16 Solution

Client: SAP EMEA - Dubai - Training RE050 REFX-IFRS16 Solution for New client of SAP with REFX-REM

Client: SAP America - Training RE010 & RE-200 Flexible Real Estate Course
SAP America - Training on RE050 EFX-IFRS16 Solution

Client: SAP America - USC842 REFX-REM Implementation Project
New Accounting Principles for North America and Asia Pacific (USC842 & IFRS16)

Client: SAP India - Training RE050 REFX-IFRS16 Solution for New client of SAP with REFX-REM

Client: SAP Saudi Arabia S4 HANA Senior Architect of SAP REFX (Flexible Real Estate), SAP REM (Real
Estate Management) and Integration with Tenant Relationship management (TRM) for Land Use
Management and Buildings.

Client: SAP Switzerland - Training RE010 & RE-200 Flexible Real Estate Course (Madrid delivery)
SAP Switzerland - Training on RE050 EFX-IFRS16 Solution (Madrid delivery)

Client: SAP Germany S/4 HANA Senior Architect of SAP REFX (Flexible Real Estate) and SAP REM (Real
Estate Management for new Leasing regulations under IFRS 16 and Integration with Fixed Assets)

Client: SAP Germany - Delivery of RE.050 Training for Service Industry

Client: SAP Switzerland Senior Architect of SAP REFX (Flexible Real Estate) and SAP REM (Real
Estate Management for new Leasing regulations under IFRS 16 and Integration with Fixed Assets)

Client: SAP Canada - Training on RE-200 Flexible Real Estate Course.
SAP Canada - Training on RE050 EFX-IFRS16 Solution

Client: REFX-REM Telecom & Retail Stores
IFRS 16 project as Architect/Design and Implementation of SAP REFX (Flexible Real Estate) and
SAP REM (Real Estate Management for new Leasing regulations under IFRS15 & IFRS 16 and
Integration with Fixed Assets)

01/2017 - 06/2020
Visionary, Architect, Project Manager & Senior Financial consultant

Client: SAP Saudi Arabia S4 HANA Senior Architect of REFX-REM

Client: SAP Switzerland Senior Architect of SAP REFX (Flexible Real Estate) and SAP REM (Real
Estate Management for new Leasing regulations under IFRS 16 and Integration with Fixed Assets)

Client: SAP North America for the delivery of REFX and REM classes: RE-200 and RE-050 on demand from
SAP
Deliver RE-050 REM SAP Training on Accounting Principles IFRS 16, and US GAAP ASC 842 for new
leasing regulations - delivered 3 classes for RE.050

09/2010 - 06/2020
Consultant
REFX NY County

* Analysis and design of integration of Enterprise Asset Management and ESRI
* The implementation of SAP allows better reporting of incidents, provided ability to discover
the "cost object" which was always problematic, allowing better maintenance planning.

01/2017 - 02/2018
Visionary, Architect, Project Manager & Senior Financial consultant
REFX-REM Telecom & Retail Stores

IFRS 16 project as Architect/Design and Implementation of SAP REFX (Flexible Real Estate) and
SAP REM (Real Estate Management for new Leasing regulations under IFRS 15 and IFRS 16 and
Integration with Fixed Assets)

06/2016 - 09/2016
Project manager
REFX Construction Conglomerate

Project manager of a team of 8 in order to realize the implementation and integration of
finance, asset accounting and project system on the financial side with real estate, plant
maintenance, service management and the HR mini master in order to track the manpower cost of
each operation.

Design, Architecture and realization of integration of PS (Project System) with REFX (Flexible
Real Estate) and SM/PM (Service Management and Plant Maintenance) for construction project
realization by trade.

12/2014 - 01/2016
Senior REFX consultant
REFX Gas Utility

SAP in order to track more than 100,000 parcels of land, land rights and buildings.
Integrate with usage view, (REFX-Financials) and REFX Contracts with posting to FI/CO-Cost
Center, Project System and Internal Order.
Integration to ESRI in order to validate that the Utility knew each parcel of lands and its
Right of Ways and made timely payments and invoicing.

07/2014 - 01/2015
Architect
REFX WCS

* Senior Architect for deployment of SAP ECC, BW/BPC, BOBJ, Portal on Global Implementation (USA
+ 45 countries)
* Project Manager for the implementation of the following functionality and systems:

* Review and guide the upgrade process to ECC 6.0 with EhP 5.0, BW/BPC, BOBJ Portal to
MS2012 and NW 7.4.1
* BSI Tax software upgrade from 9.0 to 10.e.1 and the implementation of HR year End Process
and W2 generation all within SAP
* Implementation of MM Physical Inventory and Cycle Counting
* Implementation of REFX Contracts functionalities Lease-In/Lease Out and LUM for land
management and tracking in 45 countries
* Implementation of MDM/MDG for Customers/Vendors/Materials for 45 countries
* Establishing a DEV development environment for BW/BPC and BOBJ
* Develop a reporting strategy with Integration to Informatica as Data Mart

03/2014 - 06/2014
Consultant
REFX-FILA Leasing Sarl

* Integration of CRM Quote/CRM Leasing and CRM Billing to ECC-FILA (LAE) Lease accounting Engine
(FI-LA) with Fixed Assets, FI-Accrual Engine and CO-PA
* Integration of Revenue Recognition (RAR) for IFRS 15 standard.
* Integration of REFX Lease-In contract with Lease accounting Engine (FI-LA) and ECC Billing
* Localization of SAP Lease Accounting FILA to REFX for ECC and Switzerland, Japan and Korea

01/2014 - 03/2014
Consultant
REFX Real Estate

* Update REFX-Accounting Integration with Fixed Assets based on the 2013 IFRS rules for Europe

06/2012 - 04/2013
Consultant
REFX-FILA Telecom USA

* Integration of CRM Leasing with FI-LA (Lease Accounting)
* Integration of FI-LA (Lease Accounting) contract with REFX-Contracts
* Integration FI-CA/FI-LA to REFX to A/P (Accounts Payable)
* Integration of FI-LA to Fixed Assets, Accrual engine, CO-PA and Portal
* Configuration of FI Contract Accounts (FI-CA) and integration with CRM Leasing
* Integration of Right of Ways, Easements, Waste Site, Poles and other Land Assets related of
this client into REFX-LUM and then integrated with RE-contracts and FI/CO in order to pay or
received the money for said uses.
* Developed Governance Strategy for MDG/MDM Documents for Customers, Vendors and Business
Partners for ECC/CRM/SRM and legacy applications
* Worked with developer for Data Migration efforts utilizing Business Objects Data Services
(BODS) for REFX objects, Customers, Vendors and Business partners.
* The implementation of this functionality is going to bring savings of millions dollars a year
for the customer.

01/2013 - 03/2013
Senior Consultant
REFX Big Box Retail

* Senior consultant for Flexible Real Estate (REFX) with Land Usage Management (LUM),
Architectural Objects, Usage Views & RE-Contracts and Common Area Maintenance Expense and
Recovery integration.
* Integration within the current SAP Landscape with Business Partners, Business Address Services
and ESRI software
* Integration with SAP EC&O for construction flowing to REFX and AA on final built.
* The implementation of SAP enable an electronic database of all the properties owned, ensure
that all sub-leases are maintain correctly, increase accounting accuracy and enable decision
making on which property to buy/hold or sell.

07/2011 - 12/2012
Project Manager
REFX Rail Road Canada

Big 4 Integration firm - Deliver projects in three phases of six months each for the following
functionality:
* Design and direct bi-directional integration with SAP-REFX and ESRI GIS system using Silver
light technology, for ECC & CRM
* Integration of Google map to REFX-AA-EAM and PM Functional Location and Equipment.
* Full integration with CRM/ECC Business Partners and Classic Customers/Vendors in ECC;
Integration with Finance/Controlling/Project Systems/Plant Maintenance/EAM/Sales &
Distribution/Material Management and CRM.
* Integration of REFX contract to FI release strategy from MM/PM/SM to
* Integration with SAP DMS System in order to track each Financial & Legal document related to
real estate purchase and maintenance
* Integration with rail built construction software to REFX and to AA for capitalization
* Defined data governance approach and organizational structure
* The implementation of SAP REFX-LUM enabled the land property database (~5,000 parcels) in this
organization, allowed to understand which property to acquire, to track and maintain every
encumbrance on the land parcel, allowed visualization with the GeoSpatial software and
enrichment by the integration with Asset Accounting (AA), Enterprise Asset Management (EAM)
and Plant Maintenance (PM).
* REFX-LUM for the integration of Right of Ways, Easements, Waste Site, Non-Hazardous waste,
Development Plan and link to DMS system in order for end users to view documents.
* Extend via custom development the usage of REFX-LUM in order to meet Green Environmental
requirements of the client,
* REFX-LUM allowed the legal department to do their job much more efficiently with the
integration of REFX with Documentum.

02/2011 - 12/2012
Consultant
REFX US Federal Government SAP Public Sector

* Proposed design and integration of SAP Flexible Real Estate with CRM Grantor Management and
ESRI
* Integration with Business Partners/Finance/Controlling/Project Systems/Plant Maintenance/Fund
Management/Public Sector Cash & Disbursement/Material Management/Sales & Distribution and CRM
* Participate in the design of MDM solutions for Business Partners/Customers/Vendors between
ECC, CRM and legacy applications.
* The goal of the implementation was to move the US Government into the 21st century technology,
moving from local system to an integrated SAP CRM system, making the life of the field office
(~ 2,000) much more pleasant, all information held within one system for the first time.
* Architect of pilot project to integrate REFX- Land Use Management (LUM) with CRM Grantor
management and PSCD as well as ESRI as geo-spatial software.

03/2012 - 10/2012
Senior Consultant
REFX-FILA Retail Org Inc.

* Integration of REFX contracts to FI-LA with Fixed Assets integration for management and lease
tracking of 500+ tractors and trailers
* Architect & Senior consultant for Flexible Real Estate (REFX) with Land Usage Management
(LUM), Architectural Objects, Usage Views & Contracts and CAMER integration.
* Integration within the current SAP Landscape with Business Partners, Business Address Services
and ESRI software
* Integration of asset accounting with lease accounting specific to Capital leases.
* Integration with Primavera construction software to REFX and to Asset Accounting
* The implementation of SAP enabled an electronic database of all the properties owned, ensured
that all sub-leases are maintained correctly, increased accounting accuracy and enabled
decision making on which property to buy/hold or sell.
* Integration of Right of Ways, Easements, Waste Site, Non-Hazardous waste, Development Plan for
all own or lease properties as each of these required payments to a Third party; integration
with RE-Contracts and FI/CO in order to pay the fees associated with such land requirements.

05/2007 - 11/2010
Project Manager
REFX Public Sector

Project Manager reporting to Client Program Manager - Deliver project in multiple phases over a 42
months period for the following functionality:
* SAP Solution Architect for Land Use Management (72,000+) properties fully managed in SAP
* Integration with Financials, Controlling, Asset Accounting, Enterprise Asset Management, PSCD,
Funds Management,
* Design and implement data governance for external system feeding SAP-REFX,
* Design integration of SAP Master Data Maintenance (MDM) for Vendors/Customers/Business
Partners/Materials between ECC/SRM and Engineering systems
* Configuration of Fixed Asset module, supervise the data cleaning and data collection and load
strategy of more than 400,000 assets
* Integration public work construction software for utilities and integration with FI/MM/PM/SM
for final payment process
* Integration with ESRI GIS system in order to manage and maintain Linear Assets such as Right
of Ways, Easements, Waste Site, Non-Hazardous waste, Development Plan for the various
departments
* Integration with Google maps for the Financial Supply Chain
* The implementation of SAP improved the purchasing; allowing the Company, for the first time,
to know which land and the buildings it owned and to manage them correctly; the integration
and enrichment of asset accounting/project system and plant maintenance improved the ease of
work. By being able to capitalize all the land owned, the balance sheet augmented in value.

09/2006 - 10/2007
Consultant

* Senior consultant for FI Implementation (FI-G/L, FI-A/P, FI-A/R, FI-AA, Bank, Treasury) in
order to meet USA Legal requirements - Fixed Assets Integration with Logistics Invoice
Verification (LIV) for North American operations,
* Implementation of USA, Canadian and Mexican GAAP with links to IFRS, Foreign Exchange
integration and Vertex tax system
* Greenfield implementation in the USA/Canada/Mexico region for this Swiss holding company;
enable integration with European headquarters

01/2007 - 06/2007
Project Manager and Senior Consultant
REFX Rail Road

multiple phases over a 6 months period for the following functionality:
* This project is to implement the management of 1,000+ pieces of lands in USA and Canada (Axis
North South; from Churchill MB to the Mexican border) that these railroads own and to make
sure they collect all revenues for each lease as well as distribute the expenses amongst the
tenants equally.
* Integration with BI for reporting
* The implementation of SAP REFX-LUM was to build an electronic database of the leases on each
parcel of land owned and managed; some parcels could have up to 8 leases and ensure that
accurate accounting follow. By moving from paper files to SAP the accuracy of reporting was
enhanced in time and effort reduction.

07/2006 - 06/2007
Project Manager and Senior Consultant
REFX Rail Road

multiple phases over a 12 months period for the following functionality:
* This project is to implement the management of 4,000+ pieces of land in USA (Axis West-East)
that these railroads own and to make sure they collect all revenues for each lease as well as
distribute the expenses amongst the tenants equally.
* The implementation of SAP REFX-LUM was to build an electronic database of all parcels of land
own and manage the leases on each parcel; some parcels could have up to 8 leases and ensure
that accurate accounting follow. By moving from paper files to SAP the accuracy of reporting
was enhanced in time and effort reduction.

03/2007 - 05/2007
Consultant
REFX Utility

* Provided SAP Flexible Real Estate design and integration with the Finance department to manage
the payment of 300,000 Right of Way leases via REFX-LUM.
* The implementation of SAP REFX allowed accuracy of lease payments, ensuring that no one was
paid twice or someone was forgotten and send out the checks in a timely manner.

11/2006 - 03/2007
Consultant

* Delivery of SAP training Financials and Controlling classes:
* AC.010/AC.040/AC.050/AC.200/AC.410/AC/415/AC.610

08/2005 - 06/2006
Consultant
REFX Retails

* Implementation of SAP ECC 5.0 Financials, Controlling, Fixed Assets, IS-Retail, Real Estate
(REFX) and Global Trade Strategies (GTS)
* In charge of the migration for the fixed assets module, ~ 280,000 assets from legacy to
multiple company codes and new cost centres mapping.
* Project is to implement around 200 US and 15 foreign legal entities, (Italy, China, Guatemala,
and England) with functionalities of FI/CO/AA on 5.0 with IS-Retail and Real Estate, Foreign
Exchange, Bank Register and SWIFT functionality
* Migration from 11 different legacy systems, (JDE, JDA, Lawson, Solomon, Island Pacific and
others) to SAP 5.0
* Pilot of Usage View configuration: of ~400+ stores in USA with commercial building leases to
ensure the tracking of expenses for each lease and integration with Asset Accounting
* FI/GL, FI/AP, FI/AR, FI/Banking, FI/Credit & Gift Cards in a retail environment (AMEX, VISA,
MC DISCOVER), CO-PA costing based, BW/BPS and a full BW dashboard reporting for executives.
* Integrate SAP R/3 with Is-Retail, IS-Real Estate, GTS (Global Trade Services), SAP BW 3.5, SAP
APO, and with 22 other system such as Manugistics, JDA, PKMS, Optiva, Cognos, MSI, EDW, ARIBA,
Teradata and others.
* Migrating HR mini master integration of FI/CO/HR from PeopleSoft to SAP.
* AP History and Credit cards/Gift cards processing moved to SAP.
* BW works with PIPE/POPE for linking stores POS to registers, now POSDM.

07/2004 - 09/2004
SECURITY AUDIT

Security Audit for Compliance with FDA regulation

12/1996 - 10/1997
Executive Vice President

* Full cycle implementation of FI-GL, FI-A/P, FI-AR, FI-AA/CO/HR/PS/MM/SD

05/1995 - 01/1997
Chief Information Officer
The Primetech Group

* Project manager and hands on Financials/Logistics/ABAP consultant
* Full cycle implementation of FI-GL, FI-A/P, FI-AR, FI-AA/CO/SD/MM/PP/QM/HR/Basis/Security

02/1990 - 06/1995
Chief Information Officer
GSS NA Inc


06/1985 - 02/1990
Chief Information Officer
VBA Ag


Reisebereitschaft

Verfügbar in den Ländern Deutschland
Munich
Will travel 110%

Sonstige Angaben

25+ years of SAP Financials
15+ years of REFX-REM-CLM
7+ years of IFRS16
Profilbild von Guylain deFranceDeTersant Architect, Project Manager & Senior Financial consultant FI-REFX-CO-AA aus Munich Architect, Project Manager & Senior Financial consultant FI-REFX-CO-AA
Registrieren