October 2004

CURRICULUM VITAE

PERSONAL NOTES

Name :Frank Georges Johan DE CREM

Place of birth :GENT, BELGIUM

Date of Birth :December 20th 1965

Nationality:Belgian

EDUCATION

1989 : R.U.G. ( Ghent State University ) - Belgium

Burgerlijk Elektrotechnisch Ingenieur ( Zwakstroom ) Richting Informatica

(Civil Electrical Engineer (Weak Current), Division Information Technology)

Paper :Design and implementation of a

graphic card with a transputer

1990 :U.C.L. ( Catholic University of Louvain-la-Neuve ) - Belgium

Diplôme en Administration et Gestion des Entreprises

( Degree in Business and Administration )

KNOWLEDGE OF LANGUAGES

SpeakingWritingReading

Dutch :Mothertongue

French :FluentFluentFluentFluent

English :FluentFluentFluentFluent

German :GoodGoodModerateGood

Spanish :Notions

FURTHER EDUCATION AND SKILLS

May-June 1991:Vlerickschool voor management - Gent

Doelmatig materiaalbeheer: produktieplanning en voorraadbeheer

(Efficient material management: production planning and inventory management)

November 1991 :I.I.R. - Antwerpen

Automatische identificatiesystemen

(Automatic Identification Systems)

October 1993-May 1994 :HIVA-VORMING, K.U.Leuven

Mensmanagement voor ingenieurs

(Human management for engineers)

PROFESSIONAL EXPERIENCE

1. May 1991 - December 1994:

REP Consulting, Maurits Sabbestraat 104 Bus 2, 2800 MECHELEN, Belgium.

This firm in the meantime has become a part of MRA Fiduciaire

Function: engineer-analist.

REP was a management-consulting firm for industry and distribution in Belgium.

The major focus of the projects is on production, logistics, technical and information management.

As an engineer-analyst, I was enlisted under the responsibility of a senior consultant.

Amongst other, I have been active on the following subjects:

PRODUCTION

  • Metal construction: assistance at the introduction of new production control tools
  • Steel processing: time and motion study production transport in view of productivity improvement

LOGISTICS - DISTRIBUTION

  • Food distribution: establishment standards with regard to order collection in view to production improvement
  • Apparel distribution: development and implementation of logistic improvements in the short and mid-long term; development of renewed integrated logistics
  • Wine distribution:

coaching of introduction of new production control tools

concept and lay-out for an integrated logistic system with the principal customer

  • Distribution of jeans and casual wear: concept for the lay-out of a new European distribution warehouse; optimisation of ratio investments costs versus operating costs; ensurance of logistic quality
  • Food distribution: audit of the dry food activity in shops; determination of potential of productivity improvement

INFORMATION MANAGEMENT - ADMINISTRATION

  • Building materials: assistance at the start-up of new information systems
  • Informatics: renewal of information systems; definition of needs, definition and selection of hardware and software

TECHNICAL ORGANIZATION

  • Garment distribution: development and project management of a total revision of the technical infrastructure of a chain distribution centre; definition an monitoring of functional criteria, timing and budget, selection and co-ordination of contractors, organisational modifications
  • Distribution of jeans and casual wear: project management with regard to lay-out of a new European distribution centre; selection and co-ordination of contractors; monitoring of functional criteria; timing and budget

GENERAL POLICY - STRATEGY

  • Automation: establishment of cost allocation system
  • Construction: renewal of the organisational structure and working procedures (preparation ISO9002); development and implementation of new functional descriptions

1. December 1994 – April 1998:

SAP BELGIUM NV, Woluwelaan 2, 1050 BRUSSELS, Belgium

Function: logistics consultant.

As senior logistics consultant I delivered MM (Materials Management) and SD (Sales and Distribution) consultancy, gave English-spoken courses in these two areas and occasionally gave support to pre-sales activities.

Other specific areas were covered as well (i.e. authorisation concept)

I was also product manager for the Automotive Industry and Utilities Industry.

I am MM and SD-certified by SAP for release 3.X.

Following consultancy has been given:

Materials management:

Union Minière Hoboken, Olen, Neerpelt, Balen,…:

Non-ferro industry

Project implemented without external partner

MM-PM-FI-CO project

1995-1996 version 2.2 F

Frequency: 2 days/week

Role: principal MM consultant

Procurement of stock and non-stock materials also for maintenance materials (160.000 materials, partly split-valuated )

Purchase requisitions with release procedure

Inventory management for these materials

Creation of new authorisation objects

Classification of all these materials

Use of contracts; changing the standard to allow use of product catalogues of external vendors

Implementation of non-standard MRP routine for procurement of materials with lump consumption, based on algorithm by J.D Croston

Implementation of vendor evaluation, enhanced with evaluation data recorded in a customer-specific LIS-structure and automatically incorporated in the vendor evaluation

Invoice verification for these purchases

Physical inventory taking

Implementation estimation study for 3.0D – Role: scan complete MM functionality and

estimate workload for straightforward upgrade

estimate workload for quick wins

example: central purchasing

estimating workload and feasibility for functional extensions

example: purchase requisitions with workflow release procedure

example: external service management

Beiersdorf NV, Brussels:

Consumer Packed Goods industry

Divisions

Cosmed (Nivea,…)

Medical (Hansaplast,…)

Tesa (Industrial tapes,…)

Project implemented with external partner KPMG

MM-WM-SD-FI-CO project

Medio 1996 version 3.0C

Frequency: 2 days/week

Role: principal MM consultant MM

Procurement of materials from external vendors and sister plants abroad, for stock and non-stock materials

Procurement for subcontracting of assembling and disassembling displays (customer requirement has been pushed into standard SAP for the latter functionality – negative quantities in BOM for subcontracting item)

Use of contracts

Purchase orders

Inventory management

Invoice verification

Authorisation concept for MM-module: determination of concept, determination of authorisations and profiles

Intrastat reporting

Straightforward upgrade to 3.0F together with addition of some extra functions:

Purchase requisition release procedure based on classification for Beiersdorf-specific characteristics

Reporting; LIS-courses given in-house

Third-party order (sister plants) handling triggered from SD

DAT, Brussels (daughter of SABENA World Airlines)

Airline industry

Medio 1996 version 3.0C

Punctual support MM

Yplon NV, Estaimpuis: Consumer Packed Goods industry (soaps and detergents, private label, own brands, local and export markets)

Plants

Ieper, Estaimpuis (Belgium)

Sallent (Spain)

Rosporden, St-Pée, Moyaux (1998 – Roll-out)

Project implemented under supervision of SAP Belgium and functional consultancy of CAP Volmac

MM-WM-SD-PP-FI-CO project

Start as of 1996 – upgraded to 3.0F

Frequency: 1,5 days/week

Role: principal MM consultant

Creation of new material types

Purchase requisitions, Purchase orders

Inventory Management also for finished products (split-valuated)

Invoice verification

LIS – creation of own infostructures

Stock transport orders between plants with SD delivery

Intrastat

Glaverbel, Brussels:

Glass production

Medio 1996 version 3.0C

Punctual support MM

Goodyear, Wilrijk: MM version 2.2F 1996

Sales Benelux: automobile and airline tyres

Medio 1997 version 3.0D

Punctual support MM (procurement, inventory management, invoice verification, stock transports, intrastat)

ABB verzekeringen, Leuven:

Insurance company

MM 2.2D 1996 (punctual support)

Punctual support MM (procurement, inventory management, invoice verification of office materials and marketing supplies for subsidiaries, call-off by subsidiaries)

Sales and distribution:

Yplon NV, Estaimpuis: description see MM

punctual support SD

Vandemoortele NV, Izegem: Bulk and Consumer Packed Goods industry (oils, margarines, bakery products, frozen mails, mayonaises; own brands an private labels)

Project implemented in co-operation with CSC

MM-SD-PP-FI-CO project

Start as of October 1996 version 3.1G

Frequency: 2 days/week

Role: principal SD consultant

Matching businesses requirements with SAP processes

Making a gross planning for the implementation

Important subjects:

Product hierarchy

Customer hierarchy

New customer account groups and partner determination

Materials listing and exclusion

Elaborate pricing procedures (new condition tables, access sequences, formulas and requirements, accruals postings)

New sales order types

Third-party order processing

Consignment handling with special stock partners

Delivery and transportation processing

Billing

New infostructure and planning types for flexible planning (via copy management copied to infostructure for Production planning)

Incoming and outgoing EDI-messaging

Returns handling

Malysse, Heule: SD 1997

Laundry industry

Medio 1997 version 3.0F

Punctual support MM-SD-Intercompany processing-Rebate agreements

Pasteur Mérieux, Brussels 1997

Pharmaceutical industry

Medio 1997

Punctual support MM-SD-Intrastat

Cross-application:

Tiense suiker, Tienen 1997 (pre-study of second phase)

Production and sales of sugar products and sweeteners

Pre-study of second phase implementation

MM (procurement, inter-company stock transports, inventory management, invoice verification)

SD (sales, distribution, intercompany sales, billing)

FI, CO

PP (repetitive manufacturing) and WM as new modules

For three subsidiaries (2 Belgian, 1 Dutch)

Deliverables: estimation of workload of all involved parties and gross planning

20 mandays

Authorisation concept

KONE Elevators, Brussels 1996

Beiersdorf NV, Brussels 1996

Intrastat

Cable and Wire Assemblies, Hasselt 1996

Zeneca, Destelbergen 1996

Petrofina, Brussels 1997

Courses followed:

FI overview course

PP overview course

Complete MM-cycle

Complete SD-cycle

BC Administration course

Automotive Supplier Workshop

BC400 ABAP/4 Development Workbench

Courses given:

1995 (13 days)

CMM01

CA010

MM005

MM060

MM010

MM020

1996 (14 days)

LO515

LO020

LO615

LO550

1997 (8 days)

LO605

LO630

SIS in-house course

Pre-sales support has been given for

Belgacom (MM 1995)

Sidmar (MM 1995)

Value-added reseller Delaware Industrial Solutions (MM-SD 1996)

Honda Europe (MM-SD-WM 1997)

Recticel (MM-SD 1997)

3. May 1998 – July 1999

Relocation to the US – Actual visa H1-B extendable until 2003.

Employed at BRODERICK MACJOHN

Weston Corporate Centre, 2700 South Commerce Parkway - Suite 309

Fort Lauderdale, Florida 33331

As senior logistics consultant MM (Materials Management) and SD (Sales and Distribution) I have been deployed on SAP implementation projects contracted to Andersen Consulting

Motorola, Fort Worth, Texas 05/98 – 07/98

Department CIG – Tigers project

Provide SAP configuration expertise for Purchasing

Assist team members in the development of interfaces

Map cross-functional business processes (SD-MM) in SAP, such as third-party processing and ancillary processing

Provide SAP expertise regarding Classification

Update AC-MDM-database regarding issues and configuration

Eastman Kodak, Rochester, New York 07-98 – 07/99

E2 Project – France Benelux Export Project– Global design Team member

Role: SD/MM consultant

ERP implementation for France/Benelux with SAP as backbone (SD,MM, FI, CO implementation) with interfaces to bolt-on packages like EMS-2000 (Vastera) for export determination and export document processing and legacy systems for Warehouse Management (KWWIC and PSA). This is a multi-plant, multi-company implementation. Sap’s 4.0 Plants Abroad solution is downgraded to 31H.

Involvement in complete project cycle from Business requirements definition to Production stabilisation after Go-Live, both in Global design Site (Rochester, NY) and in implementation sites (Paris, Marne-la-Vallée, Chalon sur Saône – France and Brussels - Belgium)

Andersen Consultings MDM methodology using ‘Phases and Gates’ was used in the complete cycle.

Consultancy and design support has been given in following areas:

  • Intercompany processing (Stock transport orders)
  • MM Invoice verification
  • Quotation and Sales order processing
  • Delivery processing
  • Shipment processing
  • Billing
  • SD customer exits and extensions (copy and data transfer routines)
  • Text processing
  • Pricing
  • Bill of materials
  • Logistics master data conversion preparation
  • Customer classification
  • Set up two-way interfaces for purchase orders, sales orders and shipments to Vastera Bolt-on Package using ALE and IDOCS
  • Lead-time reporting
  • Foreign trade reporting
  • Responsible for customising foreign trade processing
  • Interface for foreign trade reporting from German Spare Parts Legacy system
  • Extension of 4.0 downloaded program to customers needs.

Creation and follow-up of OSS-messages, chasing creation of standard SAP correction notes

Support Key and end users during System testing and User Readiness testing

Customer Order Processing and Foreign trade processing course

  • Preparation and monitoring development
  • Development of data generation scripts for courses using SAP-CATT
  • Courses given on site in Marne-la-Vallée and Chalon sur Saône in French

Cut-over and go-live support during 9 weeks on site in France

Stabilisation support

4. August 1999 – February 2000

Employed as freelancer at OPTIMUM NV, Veldkant 35D, B-2550 Kontich, Belgium.

As senior logistics consultant MM (Materials Management) and SD (Sales and Distribution) I have been deployed on SAP implementation projects

AKZO NOBEL BASE CHEMICALS (hereafter ANBC), Amersfoort, The Netherlands, 08/99 – 09/99

Provide SAP-expertise and consulting to co-workers and customer concerning a variety of improvement projects at ANBC:

Automatic allocation of transportation legs for sales orders

Creation of outbound IDOC-messages for transportation purchase orders

Creation of inbound IDOCS for order confirmations

Set-up of a custom-made vendor management inventory solution

Consulting concerning the implementation of delivery scheduling optimization tool (ref. APO)

AKZO NOBEL AEROSPACE COATINGS (hereafter ANAC), Leicester, United Kingdom, 10/99 – 12/99

Role: main SD/MM consultant

Scale and scope SAP implementation for the UK activities of ANAC. This is an implementation covering the SD, MM, FI and CO modules in release 4.0B.

On-site near full-time involvement in complete project cycle from Business requirements definition to Production stabilisation after Go-Live.

Main characteristics of the logistics side of the implementation:

  • Use of batch-managed materials throughout the complete logistics chain
  • Batch classification used as warehouse-management tool
  • Deterministic and Statistic Materials planning
  • Transmitting of Purchase Orders to Production instance via ALE; order confirmations and shipping notifications as well via ALE
  • Quotation and Sales order processing (Sale from stock and third-party sales)
  • Delivery processing (picking based on warehouse management embedded in classification)
  • Billing
  • Pricing
  • Logistics master data conversion preparation (use of CATTs and SAP’s Legacy System Management Workbench) for upload of materials, customers, conditions, purchasing info-records and initial stock.

Responsibilities

Check requirements with logistics key users

Establish SD/MM configuration

Train key and end users in the logistics modules

Prepare and execute initial data upload

Set up go-live plan

Cut-over and go-live support during 3 weeks on site in the UK

Stabilisation support

5. February 2000 - present

I have been working as a freelance senior logistics consultant MM (Materials Management) and SD (Sales and Distribution) for my company CRUSTILLA bvba, Lindestraat 14, 9880 Aalter, Belgium

Major projects

SIDMAR NV, Gent , Belgium 02/00 – 07/01

SIDMAR NV is a manufacturer of high quality steel products, part of the ARBED group.

Role: senior SD/MM and Automotive consultant

New implementation in release 46B for the automotive business (customer base = car manufacturers) using Automotive Scheduling agreements and EDI-handling.

On-site near full-time involvement in complete project cycle from Business requirements definition to Production stabilisation after Go-Live.

Main characteristics of the implementation of first phase:

  • Use of contracts per type of product
  • Use of scheduling agreements for the complete automotive business.
  • Production plants in Belgium, France and Germany are involved
  • Sales agencies in all European markets are involved
  • Use of variant configuration in scheduling agreements; configurations are interfaced to local systems
  • Extensive use of SAP workflow to streamline all the procedures between agencies, production sites, back offices.
  • Implementation of EDI-treatment for delivery schedules according to the three norms Odette, VDA4905 and EDIFACT for the complete customer base. Delivery schedules are interfaced with local production systems.

In a following phase Shipping is registered in SAP (interfaces from local systems) and billing is done in SAP.

Responsibilities

Represent IT department in all business meetings

Support Project Core team during business concept phase

Establish SAP Pilot and definitive SD configuration

Define extra developments and monitor development by developers

Train key users

Prepare and execute go-live plan

Cut-over and go-live support

Stabilisation support

Provide SD/MM consulting expertise for other projects as well

ENZA NV, Sint-Truiden , Belgium 01/01 – 05/01 as subcontractor for SAP Belgium

ENZA NV imports pip fruit (like apples and pears) from New Zealand and sells and distributes them throughout Europe

Role: senior SD/MM consultant; coaching of FI- and SD-consultant

Subject of project: transform - within the shortest delay possible and with minimal cost - the existing SAP implementation to a ‘Plants abroad’ configuration

Analysis of requirements, Enhance customizing, Implement developments, Test the solution and Support the go-live

Main characteristics:

  • Creation of new plants and storage locations
  • Extend accordingly the material master data
  • Change the document flow for sales processing, returns handling and complaints processing
  • Implement Goods transfers between European plants
  • Streamlining existing sales transactions
  • Develop Batch Input programs for deliveries
  • Adapt the tax determination
  • Change layout sets
  • Add FI document types, adapt pro-forma invoices
  • Set up Intrastat reporting

NV Scabal SA, Brussels, Belgium 06/01 – 03/03: as subcontractor for KPMG Optimum

The Scabal Group produces and sells worldwide high-end cloth for garments as well as garments based on this cloth; also third-party trading goods that complete the Scabals product range are sold.

Role: senior SD consultant, lead SD team, consulting support for MM implementation

Completely new SD/MM implementation in release 46C for the three different divisions (Cloth, Garments and Accessories). FI/CO is already implemented. Also BW version 3.0 is implemented.

On-site near full-time involvement in complete project cycle from Business requirements definition to Production stabilisation after Go-Live.

Main characteristics of the implementation:

  • Implemented are Sales, Deliveries, Transportation, Billing, MRP, Purchase Orders, Inventory Management, Invoice verification
  • Extensive use of Variant Configuration for Garments and Accessories, as well as Batch Management
  • Production activities (PP) in plants in the UK (Cloth) and DE (Garments) are not in scope and treated as external vendors: make-to-order sales orders with variant configuration are converted in purchase orders
  • Also company codes in Switzerland, the UK and the USA are implemented (inter-company sales)
  • Sales agencies in all European markets are involved.

Responsibilities

Establish Blueprint for the SD process flows