Könnte verfügbar sein
(Aktualisiert 2021-11-12)VBA Expert
København, Danmark
Einheimische Dutch, Fließend Danish, English
- Light, easy to use applications
- SQL Acess and other databases
- VBA applications
Fähigkeiten (25)
SQL
VBA Excel
PROCESS ANALYSIS
COST REDUCTION
PRODUCTION PROCESS
ACROBAT
WORKFLOW
Excel
Data Analysis
OPERATIONS
PRODUCTION PLANNING
ERP
API
MICROSOFT OFFICE
PURCHASING
BI
EDI
Business Intelligence
BUYING/PROCUREMENT
ADOBE ILLUSTRATOR
PowerBI
SharePoint
PHOTOSHOP
INDESIGN
MAINTENANCE
Zusammenfassung
Development of a complete web service (webshop) that al-
lows the customer to order products on target (oelandonline.
dk). For this, I developed a dynamic "language" to unambigu-
Analyzing processes and data and from there, making structure is ously describe different products, and whereby the informa-
my core competency. My goals: increase company efficiency across tion is reused during the entire production process.
the organization by developing small, down-to-earth tools, quickly
I have used the "language" in several applications.
implemented, flexible and thoroughly tailored to the problem to be
solved.
Over the years, I have created measurable results by focusing on
standardizing information sharing between the various depart-
ments (resources: sales, purchasing, production, transportation),
involving staff and balancing costs and benefits. LANGUAGE
My persistence is a great advantage when working with develop-
ment and moving on unfamiliar terrain.
Dansk: daily language
I have a degree in engineering from Belgium and was since my
settlement in Denmark (1997) primarily engaged in process optimi- Nederlands: native language
zation and digital development. English: fluent
The experience I have gained in my last position has given me last-
ing insight. But it also made visible to me where my competencies
lie and where you get the most out of my workforce: optimization.
SOFTWARE
Berufserfahrung
2018-01 - 2020-01
ETS NORD • Role as architect and outsourcing manager.
- • Øland Mobile
Establishment of a Danish branch of ETS NORD, • Øland "turning wheel". (Technical app for calcula-
an Estonian / Finnish company within ventilation tion of airflow, pressure and pressure loss)
components. Development of small software-tools to facilitate
Optimization of product range, stock and processes. everyday life and provide employees with "personal-
Calculation of min / max ized" information.
Stock calculation Information is the key to development and efficiency, but too much information kills the process. That is
Automation purchasing
why I have developed automation with intelligent
Sales (strategy) analysis and views so that too much information
Cost reduction (staff and warehouse department) does not blur important information.
Team management in Denmark. • Primary in VBA Excel. Also VB.
Personnel responsibilities • With a direct link between the ERP system (XAL and M3) and Excel to have data in real-time.
• BI.
• Two-way communication between the report and the ERP-system. Ex: Invoice analysis and approval,
2001-01 - 2017-01
Øland Ventilation A/S Scanner
- • Implementing a scanner system in the warehouse.
Generelt • Specially designed solutions that match the work-
Member of the management. flow and products of the company.
Development and improvement of work processes/ EDI
workflow across the company in close collaboration
• Various EDI (or equivalent systems) for communi- with the management team and colleagues
cation with third parties (customers and suppliers)
Change the company to "Just in Time", reducing the flow efficiency from 10 days to 1-2 days. Data vedligeholdelse.
Production layout. Optimizing machine flow to • Maintenance of master data, using my advanced
reduce non-value adding operations. Excel expertise.
Market and sales analysing. • Development of small tools that ensure uniform and complete master data.
Providing targeted information about customers,
sales and products to colleagues to make the best ERP System change
possible decisions for the company's strategy and/or • Oprydning, klargørelse af data til systemskift fra approach to the individual customers. XAL til M3.
Software: Catalogues and price lists (web & printed version).
Development of web service OelandOnline. • Using Indesign, Illustrator, Photoshop.
• Role as architect and outsourcing manager. • Including the development of scripts that make
• http://oo.codebakery.dk/product/BF/ quick updates possible.
• Advanced online B2B ordering system
• Ordering of standard and custom made products Building Coordinator:
• 3D modelling of custom-made products. • Remodeling new stores and facilities.Danida
• Backend system for easy administration of orders
Start-up of productions in Tanzania, Kenya and and customers.
Vietnam.
ALL ROUND OPTIMIZER
s. 3
WORK EXPERIENCE OTHER
2000-01 - 2001-01
Brantano • Working sheets.
- • Production planning
Simultaneous opening of the first 5 stores in Den- • Development quotation program.
mark • For companies into ventilation and rice production.
Coordination of the building engineering parts (re- construction, layout, permits)
Development of an internal app for Telia. The app is a communica-
tion tool to report network issues, as well as measuring speed.
Development of NoseyBoy, a media app, developed for iOS and
1997-01 - 2000-01
Production Workers. • Lamp. From design to working 3D printed prototype.
Production preparation and administrative develop- • Patio: design, building permit (including argumentation for ment. deviation from standard) and execution (semi self-build).
• Litter box. Developing the concept of a disposable litter box.
1990-1996 Before Danmark