Bertrand - Business Analyst SAP FI-CO

IS Free-lance consultant from Feb. 2011 to August 2012
SAP Functional Expert FI/CO/MM
SAP IS-Retail environment

Casino Group
N°5 in French retail sector – 34,4 Bn EUR turnover (before consolidation of GPA)

From Aug. 2011 to Aug. 2012
Casino Group
FR – Saint-Etienne
FI CO MM EXPERT
CONCEPTUAL DESIGN :
• Business model for margin & inventory calculation in SAP IS Retail environment (Shifting from FIFO to MAP)
• Operational & financial reporting related to margins & inventories
• Design for scan & pay flows pilot

FAST PROJECT – PHASE 2 :
SAP PILOT AS PROOF OF CONCEPT FOR STOCK INVENTORY VALUATION IN A SAP IS-RETAIL ENVIRONMENT
• Pilot solution – Build proof of concept for main business processes & flows at Casino Group warehouses & stores
• Build complex retail pricing procedures (internal transfer prices)
• Build inter-company transfer prices & stock transfer flows
• Implement finance & controlling functional requirements solutions – specific enhancements to fulfill Casino business requirements
• Strengthen IS-Retail & ERP integration
• Solution for stock valuation solution – Casino, Franprix & LeaderPrice warehouses
• Write detailed design documentation
• Interfaces with master data, inventory movements applications (GOLD + ETL)

IS ARCHITECTURE ROADMAP
SIGP PROGRAM
• Support IS architecture plan : elaborate new global vision and specified targets for IS application landscape (IS architecture plan)
• Identify critical factors of success
• Promote pragmatic options for IS landscape rationalization
• Identify possible optimization (Change management)
• Identify temporary vs. target scenarios & related IS application solutions (program roadmap)

From Feb. 2011to July 2011
Casino Group FR – Saint-Etienne
FI CO MM EXPERT
Stock inventory valuation for Casino / Franprix / LeaderPrice warehouses

FAST PROJECT – PHASE 1 :
CONCEPTUAL DESIGN FOR STOCK INVENTORY VALUATION
• Project roadmap
• Identify interactions with existing IS landscape applications (Gold / Aldata software editor)
• Confirm expectations & deliverables for phase 1
• Build design solution for Casino Group warehouses & stores (Swim lanes)
• Deep analysis of business process and information workflows
• Build valuation matrix design solution for stock valuation solution – Casino, Franprix & LeaderPrice warehouses
• Prepare & monitor big picture sessions & customer validation
• Conceptual design documentation

SAP Consultant from October 2009 to August 2010
Mylan Group
N°3 in Generics Pharmaceutical industry

From Oct. 2009 to end of August 2010
Mylan Group
Region EMEA
BE- Brussels
NL - Utrecht
PRE-SALES
BENELUX PROJECT
5 Affiliates : Mylan NL &BE, DocPharma BE & LU, Apothecon
BUILD REQUEST FOR PROPOSAL TO INTEGRATORS (EXTERNAL SERVICES PROVIDERS)
• Context & expectations
• Scope perimeter
• Requirements

BUILD QUOTATION OFFER TO MYLAN GROUP
• Analysis of existing set-up
• Project plan
• Project scope & deliverables
• Quotation submission

FI CO EXPERT
BENELUX IMPLEMENTATION
FI CO IMPLEMENTATION
• Project preparation : Tools & Methodology
• Gap analysis
• Solution implementation
• Tests & validation
• Go-live preparation
• Go-live & support

HIGHLIGTHS
• NL : Data migration from MOVEX to SAP ECC 5.0 :
- extract from MOVEX of stock inventory positions
- stock upload into SAP
- extract from MOVEX of GL/AR/AP/assets balances
- upload of all finance balances into SAP
• NL & BE : Integration between SAP modules: MM/WM/QM, SD/CO-PA – Customizing & integration tests of logistics flows
• NL & BE : Set-up electronic banking
• BE : Upload of profit & cost centers balances into SAP
• BE : Upload of fixed assets impairments values

SAP Consultant – NetPeople CH from October 2007 to September 2009

From Oct. 2007 to Sept. 2009
OI Form. BSN Glasspack
CH – Lausanne
Worldwide leader
Glass industry
FI EXPERT
SENIOR SD
FI CO CONSULTANT
INTEGRATION SUPPORT FOR ALL MODULES
SD FLOWS RE-ENGENEERING
SAP ECC v5.0
• Finance expertise FI-GL, FI-AP, FI-AP
• Support & maintenance levels 2 et 3, training & assistance to the users
• Grant Finance Core model compliance for any process & enhancement
• Finance Core model enhancement : design and implementation of new SAP functionality (petty cash journal, miscellaneous invoices automated processes including Idocs for triangular flows including holding), logistics flows optimisation, write specifications for project enhancements (FRICEW)
• Specific analysis & studies: stock transfer orders in triangular flows, exchange rate table set-up, enhanced country statutory solutions (legal, accounting & tax regulation requirements)

OI Form. BSN Glasspack
CH – Lausanne
Worldwide leader
Glass industry
From Jan. 2008 to June 2008
FICO IMPLEMENTATION PROJECT LEADER FOR CZ AFFILIATE IMPLEMENTATION
1stsemester 2008
FI CO PROJECT LEADER
SAP ECC v5.0
• FI CO project scope CZ: GL/PCA , AP, AR, Bank & Treasury, AA/IM, CCA, OM, COPA
• FI CO project leader (All modules) : Monitoring FICO Team: 5 SAP analysts (Internal OI & external)
• Monitoring of FICO team planning
• Grant Finance Core model implementation compliancy for CZ
• Grant full compliance with OI Group accounting plan & accounting manual
• Analysis of legal & statutory business needs in CZ
• Identify & document CZ gaps analysis
• Implementation & validation of specific solutions for the Czech OI affiliate
• Re-engineering of inaccurate, cumbersome & sub-optimal processes,
• Catalyst to challenge et propose enhancements for weak processes identified in previous step
• Month & Year-end closing procedure improvement
• Reporting process improvements
• Finance expertise support: GL, AP, AR, Bank & Treasury, AA/IM, data migration (transfer of inventories property + business contribution to a new single legal entity)
• Follow-up CO implementation
• Payroll interface
• Customizing & unitary tests
• Set-up training documentation
• Training of key users
• Support key users preparation for end users training
• Integration tests in dedicated environment
• Monitoring user acceptance tests & validation
• Monitoring data migration preparation (data cleansing in old legacy system, file set-up definition, tests)
• Build & prepare Cut-off plan
• Monitoring Cut-off activities & Go-live activities
• Process data migration & Validation of data migration by business owners
• Key user support after Go-live
• Various controls making sure that new processes, best practises & rules are properly fulfilled after Go-live

OI Form. BSN Glasspack
CH – Lausanne
Worldwide leader
Glass industry
SYNGENTA from April 1998 to September 2007
N° 1 in Crop Protection
N° 3 in Seeds
From April 2007 to Sept. 2007
BUSINESS ANALYST – PLANIFICATION BUDGETISATION ET PREVISION
NEW GLOBAL ERP SYNGENTA PROJECT ALL DIVISIONS : CROP PROTECTION + SEEDS
PHASE II = DEFINE GLOBAL DESIGN
SAP Solution Manager, SAP R/3 COPA, BI /SEM-BPS
• For memo, phase I = Identification & recognition of key business processes for the Company.
• Definition of pre-requisites & Company high level requirements
• Definition of global design for all finance planning activities : turn strategy into quantitative targets & numbers, clarify cascading targets process
• Definition of analysis scope, methodology & tools to build long & midterm planning (business plan by division / business unit)
• Definition of analysis scope, methodology & tools to build & secure short term planning (budget processes & budget control)
• Define operational profit and loss structure to support profitability analysis, definition of characteristics (Global / BU) and granularity levels for customer / product line / market segment profitability analysis (COPA) and planning (SEM-BPS)
• Determination of optimal phasing for planning / budgeting / forecasting (SEM-BPS, CO, DP/APO)
• Creation of detailed documentation for each business process (& related tasks)
• Swim lanes & business flows documentation
• Monitoring of workshop meetings with Top managers and dedicated specialist
• Review meetings, challenging & proposal optimisation
• Conceptual design solutions validation
• Activity reports
• Solution documentation & update status follow-up for each business process & task in SAP Solution Manager
• Reporting of progress & milestones completion to project integrator (Accenture DE)

SYNGENTA AG
Company Headquarter
CH - Basel
From July 2004 to March 2007
BUSINESS ANALYST – STRATEGIC PLANNING BI /DEVELOPMENT OF INNOVATIVE SOLUTIONS FOR BUSINESS PLANNING & BUSINESS INTELLIGENCE

BI / SEM-BPS v3.5 (Excel ‘in place’ + SAP Portal)
Intranet portal dedicated to business competition intelligence tracking & follow-up(quantitative data interfaced with SEM-BPS)

• Project promotion of an integrated business planning solution to cover strategic planning business needs – Seeds division
• Selection of software application : SEM-BPS module (Business Planning & Simulation)
• Identification & analysis of business requests to determine functional needs for Vegetables Seeds business unit
• Preparation & monitoring of design workshops
• Monitoring communication & relationship with integrator & off-shore development Team
• Tests & validation of design solution by business managers
• Set-up documentation, operating modes & user guides
• SEM-BPS training to sales & marketing Teams (Approx. 70 countries)
• Functional specification for interfacing SEM-BPS data with Business Intelligence Intranet portal
• Design, tests & validation of the Intranet portal functionality
- SEM-BPS quantitative data
- Validation workflow for qualitative data (sales & marketing team on-line requests managed directly in the Intranet portal)
- Qualitative data centrally screened, challenged and validated by strategic marketing Team (Competitors Company profile, Newsletter & latest insights…)
- Monitoring access to classified information (management of user profiles authorization)

SYNGENTA SEEDS GLOBAL
BU Vegetables Seeds
From Oct. 2003 to June 2004
SAP ANALYST
FI CO ANALYST – UPGRADE VERSION PROJECT
SAP R/3 from v3.1i to v4.7
• Analysis of FICO delta from v3.0x to 4.7 Enterprise
• Identification of technical critical points
• Build version upgrade plan
• Analysis of new functionality
• Validation of the scope of new functionality to be launched with upgrade version
• Build Upgrade plan set-up
• Get business validation for Upgrade methodology and planning
• Customizing and preparation of testing environments
• Full Upgrade tests
• Set-up documentation for SAP users
• SAP key users training on both deltas & new functionality
• Production system upgrade
• Upgrade technical & business validation: System environment client & data integrity
• Post upgrade functional assistance

SYNGENTA SEEDS EUROPE
FR – Toulouse
From Jan. 2002 to Sept. 2003
SAP ANALYST
FICO BUSINESS ANALYST
SAP R/3 v3.1i
• Design & implementation of sub-contracting flows between France & Italian affiliates
• Core model roll-out for Wheat & Barley BU in English & French single legal entities
• Data migration combined with a legal entities restructuring including merger / spin-off & business contribution for some entities home based in UK
• Rationalization of business process & IT solutions, replacement of isolated IT software package by integrated solutions (SAP R/3 ERP)
• Conceptual design & implementation of IT costs follow-up by project
• Optimization of intercompany reconciliation
• Enhancement for bank statement integration and clearing of bank postings against sub-ledgers
• Design & roll-out of a centralized cash management solution (module TR-CM) for the French single legal entities
• Set-up internal control procedures
• Creation of operating modes & user guides
• Define functional roles & generic user profiles
• Support & assistance to audit activities
• Special studies & business analysis on demand
• Costs & budget analysis

SYNGENTA SEEDS EUROPE
FR – Toulouse
From July 2000 to January 2002
EURO CONVERSION RESPONSABLE CONVERSION EURO SAP R3
EURO CONVERSION PROJECT LEADER SYNGENTA SEEDS
SAP R/3 v3.1i
• Project planning
• Set-up project Team
• Selection of external consulting provider for functional and technical assistance
• Project management
• Project newsletter for Company internal communication
• Supervision of SAP environment technical set-up
• Monitoring & supervision of all local country teams EURO changeover activities
• Full EURO changeover test performed in a dedicated environment
• EURO changeover of 9 Euro land affiliates based in 7 countries (AT, BE, DE, ES, FR, IT, NL) performed in a single Worldwide client (including APAC & NAFTA)
• Set-up methodology & validation process for EURO conversion with internal & legal auditors

SYNGENTA SEEDS EUROPE
FR - Toulouse
From April 1998 to May 2000
SAP ANALYST
FICO BUSINESS ANALYST
SAP R/3 v3.0f / v3.1i
• North Europe Core model roll-out
 AT, BE, DE, GB, HU, NL + Holding CH
• SAP R/3 FICO modules – maintenance and enhancements
 GL, AP, AR, AA, PCA/CCA, OM

NOVARTIS SEEDS B.V,
Former CIBA-SANDOZ
NL - Enkhuizen
OTHERS
March 2008
SAP / BW TRAINING FOR FINANCIAL AUDITORS
SAP ECC v6.0
• Introduction to SAP module FI/CO et BW for E&Y auditors: Module AC 050 & Module BI
(courses were done in English language)

SAP France
FR – Paris La Défense
From 1993 to 1998 LECTURER IN ACCOUNTING & FINANCE
• Accounting & finance management for several management schools and professional organisations
• Set-up business plan for trading & craftwork companies LECTURER IN ACCOUNTING & FINANCE – MANAGMENT SCHOOLS & CHAMBER OF COMMERCE

IFAG Toulouse, CCI Rodez, Chambre de Métiers du Cantal
From 1990 to 1992 FINANCE / TREASURY ASSISTANT
• Accounts receivables monitoring (retail sector)
• Credit management & credit insurance
• Cash & Treasury management
• Bank communication software
• Customizing & functionality enhancement of the treasury software ‘Concept’
• Budget & planning activities
• Currency risk hedging monitoring

FROMARSAC SARL (BONGRAIN Group’s major brands:
Tartare, Saint-Moret, Chaumes, Saint-Agur, Bresse Bleu, Caprice des Dieux, Coraya, Bordeau Chesnel …)

FR – Périgueux
Food Industry
1989 ACCOUNTING CABINET
• Monitoring accounting for craftwork & shops customers
• Set-up tax, social & legal declarations SOREC S.A
FR – Toulouse
Accounting cabinet