as of January 1st, 2017.
After 45 years as a general manager, CEO, Accountant and IT specialist, I develop reports, analysis and datamarts for the board.
My resources are Excel, VBA and Access, bringing the information into tools that data users do master easily.
After some training, the data users will reinforce the finesse of their analysis, focusing on the weak points and quickly reacting for
the benefit of the enterprise.
- At all time :
- Giving some support to selected customers of my own and frequently coaching staffs of Belgian companies.
- Creating Tutorials for Excel and Access.
- Senior bookkeeper and Tax-consultant of the belgian company :
•
Flatlined Games
===================================
- Year 2017 - .....
-
Scale Models s.a.
- Update and implementation of their Website & Eshop.
- Update and implementation of their CMS.
LINK TO : Scale Models
========================
Magasins Gipsy s.a.
- Email campaigns
- Design and implementation of their Website and Eshop.
- Update & implementation of their CMS.
LINK TO : GipsySoignies
========================
Flatlined Games
- Bookkeeping.
- Inventory tracking.
- Tax advising.
LINK TO : Flatlined Games
===================================
- Year 2016 - .....
Scale Models s.a.
- Update and implementation of their Website & Eshop.
- Update and implementation of their CMS.
LINK TO : Scale Models
========================
Magasins Gipsy s.a.
- Email campaigns
- Design and implementation of their Website and Eshop.
- Update & implementation of their CMS.
LINK TO : GipsySoignies
========================
Flatlined Games
- Bookkeeping.
- Inventory tracking.
- Tax advising.
LINK TO : Flatlined Games
===================================
- Year 2015 - .....
Scale Models s.a.
- Update and implementation of their Website & Eshop.
- Update and implementation of their CMS.
LINK TO : Scale Models
========================
Magasins Gipsy s.a.
- Email campaigns
- Design and implementation of their Website and Eshop.
- Update & implementation of their CMS.
LINK TO : GipsySoignies
========================
Flatlined Games
- Bookkeeping.
- Inventory tracking.
- Tax advising.
LINK TO : Flatlined Games
===================================
- Year 2014 - .....
Gaudier-Rembaux s.a.
- Bookkeeping & inventory tracking in Excel
LINK TO : Gaudier-Rembaux s.a.
========================
Granit-Decor sprl
Rue A. Pouplier, 2
7190 - ECAUSSINNES (Belgium)
- Bookkeeping
========================
Scale Models s.a.
- Design and implementation of their new website & virtual Eshop.
- Creation and implementation of their New CMS.
LINK TO : Scale Models
========================
Magasins Gipsy s.a.
Chaussée de Mons, 141
7060 - SOIGNIES (Belgium)
- Email campaigns
- Design and implementation of their New web site and Eshop.
- Creation and implementation of their New CMS.
LINK TO : GipsySoignies
========================
Flatlined Games
- Bookkeeping.
- Inventory tracking.
- Tax advising.
LINK TO : Flatlined Games
===================================
- Year 2013 - .....
Le Chalet Robinson
- Executive Dashboard - Yearly reports in Excel
LINK TO : Le Chalet Robinson
========================
Gaudier-Rembaux s.a.
- Bookkeeping & inventory tracking in Excel
LINK TO : Gaudier-Rembaux s.a.
========================
Granit-Decor sprl
Rue A. Pouplier, 2
7190 - ECAUSSINNES (Belgium)
- Bookkeeping
========================
Scale Models s.a.
- Update, redesign and implementation of their virtual Eshop.
LINK TO : Scale Models
========================
Magasins Gipsy s.a.
Chaussée de Mons, 141
7060 - SOIGNIES (Belgium)
- Email campaigns
- Creation and implementation of their New web site and Eshop.
- Creation and implementation of their New CMS.
LINK TO : GipsySoignies
===================================
- Year 2012 - .....
Gaudier-Rembaux s.a.
- Bookkeeping & inventory tracking in Excel
LINK TO : Gaudier-Rembaux s.a.
========================
Granit-Decor sprl
Rue A. Pouplier, 2
7190 - ECAUSSINNES (Belgium)
- Bookkeeping
========================
Magasins Gipsy s.a.
Chaussée de Mons, 141
7060 - SOIGNIES (Belgium)
- Email campaigns
LINK TO : GipsySoignies
========================
Scale Models s.a.
- Update, redesign and implementation of their virtual Eshop.
LINK TO : Scale Models
===================================
- Year 2011 - .....
Gaudier-Rembaux s.a.
- Bookkeeping & inventory tracking in Excel
LINK TO : Gaudier-Rembaux s.a.
========================
Granit-Decor sprl
Rue A. Pouplier, 2
7190 - ECAUSSINNES (Belgium)
- Bookkeeping
========================
Magasins Gipsy s.a.
Chaussée de Mons, 141
7060 - SOIGNIES (Belgium)
- Email campaigns
LINK TO : GipsySoignies
========================
Scale Models s.a.
- Update, redesign and implementation of their virtual Eshop.
LINK TO : Scale Models
===================================
- Year 2010 - .....
TrueGreen sprl
Avenue Florida, 71
1410 - WATERLOO (Belgium)
... partners with
metaalconstructie TRUYENS
Oostkaai 24
2170 - MERKSEM
- Complex Excel application linking production and bookkeeping
- Involving imports from several programs into the Excel application
LINK TO : Truyens metaalconstructie
========================
Gaudier-Rembaux s.a.
- Bookkeeping & inventory tracking in Excel
LINK TO : Gaudier-Rembaux s.a.
========================
Granit-Decor sprl
Rue A. Pouplier, 2
7190 - ECAUSSINNES (Belgium)
- Bookkeeping
========================
Magasins Gipsy s.a.
Magasins Gipsy s.a.
Chaussée de Mons, 141
7060 - SOIGNIES (Belgium)
- Create Video Disks to present new collections
LINK TO : GipsySoignies
========================
Scale Models s.a.
- Update, redesign and implementation of their virtual Eshop.
- Migration to Windows 7.
LINK TO : Scale Models
===================================
- Year 2009 - .....
Gaudier-Rembaux s.a.
- New Bookkeeping & inventory tracking in Excel
- Excel Dashboard for the CEO
LINK TO : Gaudier-Rembaux s.a.
========================
Development
- Excel tool for use in Packaging Labels
Development sprl
Rue de l'Atelier, 12
1480 - TUBIZE (Belgium)
LINK TO : Development sprl
========================
Yours
- Excel tool for use in Spare parts catalog
LINK TO : n.v. Yours s.a.
========================
BD Biosciences
- Excel tool for use in Value Based Customer Segmentation
LINK TO : BD Biosciences (a division of Becton Dickinson)
========================
Scale Models s.a.
- Update, redesign and implementation of their virtual Eshop.
- Migration to Windows 7.
LINK TO : Scale Models
===================================
- Year 2008 - .....
Ellwood Steel Belgium
- Coaching in Excel
LINK TO : ESB
========================
Scale Models s.a. (Belgium)
- Update, redesign and implementation of their virtual Eshop.
LINK TO : Scale Models
===================================
- Year 2007 - .....
for JTL Associates (Belgium)
- Consultancy on some Client Surveys of one of their customer (Euroclear)
LINK TO : Euroclear
========================
Scale Models s.a. (Belgium)
- Update, redesign and implementation of their virtual Eshop.
LINK TO : Scale Models
===================================
- Year 2006 - .....
Scale Models s.a. (Belgium)
- Design, creation and implementation of a virtual Eshop for Scale Models s.a. in Belgium
LINK TO : Scale Models
===================================
- Year 2005 - .....
- Design, creation and implementation of a special designed Excel application combining Web access
and internal programming for the 'Centre Scolaire de Woluwe St Pierre'.
===================================
- Year 2004 - .....
- Design, creation and implementation of several Excel applications involving VBA :
Using direct VBA programming of the VBE (Visual Basic Editor).
for PiscinesLoisirs.be including: Bookkeeping, Orders follow-up and customer's list maintenance
LINK TO : Piscines et Loisirs
===================================
- April 2003 - May 2003
B/E Aerospace Nieuwegein (NL)
Preliminary studies of an ERP system to generate an order backlog report and a sales report, both in Excel format.
The order backlog report shows how many units of each product type are on order (per customer, with expected delivery
date etc.). The sales report shows the sales history. These reports should eventually be compared to the forecast in
order to detect any discrepancies and, if necessary, initiate necessary updates or marketing activities.
LINK TO : Aerospace
===================================
- March 2003
- Beginning Partnership with Belgacom :
Creation, Installation and Maintenance of new Web Sites
LINK TO : Belgacom
===================================
- January 2003 - March 2003
- Implementation of Web Sites :
- http://www.piscinesloisirs.be
- http://www.lgb.be
- http://www.traficsignal.be
- http://users.belgacombusiness.net/web-chimie
LINK TO : PiscinesLoisirs
LINK TO : LGB
LINK TO : Trafic Signal
LINK TO : Web Chimie
===================================
- Augustus 2002 - December 2002
- Consultancy for s.a. de Merbes-Sprimont, Heideveld 8 1654-Huizingen ( Web-site modification & implementation.)
- Business consultancy for Gaudier-Rembaux s.a. Rue A. Pouplier2 7190-ECAUSSINNES
- Creating the new "EXCEL PAGES" on my own web-site (http://www.affordsol.be)
LINK TO : Merbes-Sprimont
LINK TO : Gaudier-Rembaux
===================================
- November 2001 - July 2002
Consultancy for SCRL EVRART, rue Haute, ATH (Belgium). - Development of a brand new application mastering fabrication
prices in Euros, with lots of parameters and outgoing stock management, delivery sheets, order sheets for the fabrication
dept., and invoicing to customers. The replaced application had been written in C++, working on an old SCO Unix system,
using several dbases in dbVista. The new application, developped under Excel+Access (VBA) runs under W98SE.
LINK TO : Bijouterie Evrart
LINK TO : Joaillerie Evrart
===================================
- October 2001
Consultancy for Coopers & Lybrand.
LINK TO : PriceWaterHouseCoopers
===================================
- September 2001
Consultancy for EGGERMONT Natuursteen n.v. en RAFFO n.v.
===================================
- May to July 2001
Development of a multi-criteria report. The original data is stored on an Oracle database.
The client is stationed in Germany and we never met in person.
===================================
- 1 February 2001 - ...
Consultancy for s.a. de Merbes-Sprimont, Heideveld 8 1654-Huizingen
Web-site design & implementation, animation w/Flash5, DNS and hosting.
===================================
- 20 December 2000 - 31 January 2001
Consultancy for UCSMB (Union des Carrières et Scieries de Marbres de Belgique), rue du Bosquet 2, 1000-Bruxelles
Web-site design & implementation, DNS & hosting individual pages for all of the members of the union.
===================================
- 15 October 2000 - 20 December 2000
Consultancy for n.v. RAFFO, Stationsstraat 205 9450-Haaltert
Implementation of new peripherals for Bar-codes, training.
Web-site design & implementation, animation w/Flash5, DNS and hosting.
===================================
- 1 January 2000 - 30 June 2000
Foundation of Affordable Solutions
Creation of a 1st tutorial series for chemistry with prof. Y. BERGER.
===================================
- 1 January 1991.
I bought all the shares of RAFFO n.v. Stationsstraat 205 9450-Haaltert which I still operate with a staff of 5 persons.
General business administration and finances
===================================
- 31 May 1983 - 31 December 1991
Foundation of the company RAFFO n.v. Stationsstraat 205 9450-Haaltert where I became the C.E.O. and later the president.
General business administration, finances, full control of industrial process, supplies and products, general management.
===================================
- 1 January 1971 - 15 May 1995
s.a. Granitière HANUISE, Rue des trois planches, 7060-Soignies.
IT management, system administration, LAN design & troubleshooting
General business administration, finances, full control of industrial process, supplies and products, general management.
===================================
- 1 June 1968 - 31 December 1970
Export Coordinator (Ets Achille Marchal in St Gilles - Brussels) : sale of mechanical seals : you know that kind of seal placed
on the sternpost of a ship (some of them with a diameter of +170cm). The job was unique : I had to contact the various plants all
around the world and make sure that the mechanical seal requested for a given ship be 'just in time' at a given dock in
a given harbour somewhere else in the world : very exiting but very tricky : any delay for the ship in the harbour costs millions per day.
===================================
After more than 45 years of career as a company head, project leader and accountant, I have sold
out my different companies and work as a Business Analyst, specialized in the field of Micro Data.
My expertise is required by the boards of directors to build reports that clearly and concisely
outline, in a comprehensive way, the life of the company (and/or its competitors), pinpointing
weaknesses and strong points for an immediate reaction.
Using Excel, VBA and Access, I use the database(s) of the company to make the information available
to the end-user, in an Excel Workbook that can be easily manipulated.
No need for a meeting: after so many years, I am able to understand the needs of my client even
by Fax , E_mail or Phone, and deliver complete solutions.