Technical Business Consultant
Aktualisiert am 06.11.2023
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 06.11.2023
Verfügbar zu: 100%
davon vor Ort: 100%
Oracle
Oracle APEX
Oracle Applications
Dutch
Spoken: excellent, Written: excellent
English
Spoken: excellent, Written: excellent

Einsatzorte

Deutschland, Österreich, Schweiz
möglich

Projekte

3 Jahre 9 Monate
2020-01 - 2023-09

INNIO Oracle Enhancements

Oracle Solution Architect PL/SQL Oracle APEX ORDS
Oracle Solution Architect
Oracle Applications Oracle APEX
PL/SQL Oracle APEX ORDS
INNIO
9 Monate
2022-12 - 2023-08

Toshiba Tec Implementation Oracle EBS Field Service

Lead implementation consultant Service
Lead implementation consultant Service
Oracle Applications
Toshiba Tec
Düsseldorf
8 Jahre 1 Monat
2015-03 - 2023-03

Ongoing Support GeesinkNorba

Oracle support consultant
Oracle support consultant
  • Branche: Manufacturing
  • Situation:
    • GeesinkNorba manufactures garbage trucks and have been using Oracle EBS since before I knew what Oracle was. Various companies in the Oracle business have been doing Geesink support, but nobody actually made such progress as the Enshore team has been making.

      Throughout the years, more and more processes were being managed outside of Oracle. Especially the picking process was done through Excel as Oracle was deemed not reliable enough. I turned that around. By putting in  some key customizations I managed to pull in some of the Excel processes and re-establishing the link between the internal supply chain and the external supply chain. It's almost like refurbishing an old machine to its former glory. (GeesinkNorba currently has a project to migrate to SAP).

      For reporting purposes we've been putting in some APEX applications for various departments.

  • Tasks and responsibilities:

    • Making sure Oracle works and keeps working

  • Results: 
    • Basically helped the organization work much more efficiently with the tools they already have.

  • Methods and techniques:

    • APEX (4.2) PL/SQL, SQL

  • Tools:

    • SQL developer

  • Software:
    • Oracle E-Business Suite 11.0.3

      • Purchasing
      • Inventory
      • BOM
      • WIP
      • MDS/MRP
GeesinkNorba (through Enshore)
6 Jahre 9 Monate
2015-03 - 2021-11

Welzorg Vooruit

Oracle consultant
Oracle consultant
  • Form March 2015 until today, I?ve been hired by Enshore for a number of their customers. As we have a history together (as in shared employers), they?ve been sending me as their representative to their own customers. Having a huge degree of freedom, I have had the opportunity to manage my own work at those customers while having a team of specialists for backup when necessary. Below are some of the projects from this period.

  • Branche: Wholesale / Healthcare
  • Situation:

    • Welzorg is a wholesale / service provider in rehabilitation products. Municipalities outsource the process of providing these products to their citizens to Welzorg. Welzorg then periodically invoices the rent to the municipalities and provides products and services to the end users. The last two years Welzorg has been transforming their organization from a decentralised to a centralised organisation, stressing the need for flawless logistics. To support this transformation a number of changes to Oracle were needed.
  • Tasks and responsibilities:

    • Supporting, analysing and developing changes. Also instructing and assisting peers.

  • Results:
    • In the period of more than a year numerous changes, big and small, core Oracle and APEX have been realised. A number of external systems needed to be integrated or enhanced, that I designed and built or helped building.

  • Methods and techniques: 
    • APEX (4.1), PL/SQL, SQL

  • Tools:
    • SQL developer

  • Software:
    • Oracle E-Business Suite 11.5.10.2 
      • Install Base
      • Service
      • Service Contracts
      • Purchasing
      • Sigmax Field Mobility Suite
Welzorg (through Enshore)
1 Jahr
2014-03 - 2015-02

Zumba

Lead designer fulfillment/CRM migration
Lead designer fulfillment/CRM migration
  • Branche: Telecom
  • Situation:

    • Ziggo had decided to phase out Oracle EBS. All major processes were to be handled by a best-of-breed solution. In case of fulfillment that application would be Ericsson Order Care (former ConceptWave). My responsibility was to design (and help implement) the migration of all customer data from an EBS fulfillment perspective. This included the customer's product portfolio, (special) rates, discounts, both B2C and B2B. Ziggo has approximately 2.7 million customers.

  • Tasks and responsibilities:

    • Be the SPOC for all fulfillment related questions from business or technical implementation partner (TechMahindra).

      Design the software that would help migrate the software from EBS to ConceptWave

  • Results:
    • The migration software was all delivered and was production ready on time. The project was terminated when Ziggo was taken over by Liberty Global (UPC).
  • Methods and techniques:

    • Prince2, PL/SQL, SQL

  • Tools: 

    • SQL developer, JIRA

  • Software:
    • Oracle E-Business Suite 11.5.9

      • Install Base
      • Advanced Pricing
      • TCA
Ziggo
4 Monate
2013-11 - 2014-02

Interface EBS FMS

Lead consultant Service
Lead consultant Service
  • Branche: Industry
  • Situation:
    • Duijvelaar has decided to use a 3rd party scheduling tool for their engineers (including a mobile field service app). This tool (FMS) needs its data from EBS and will feedback the results to EBS when the scheduling is done and again, when the work is completed. For this an interface is created that will handle all these aspects.

  • Tasks and responsibilities:

    • Design and QA of the interface and assisting in programming the interface itself
  • Results:

    • Operational interface

  • Methods and techniques:

    • PL/SQL

  • Tools:

    • TOAD
  • Software:
    • Oracle E-Business Suite 12.1.3
      • Field Service
      • Install Base
      • Service Contracts
      • Sigmax Field Mobility Suite.
DP Pumps
1 Jahr 7 Monate
2012-04 - 2013-10

GAIA

Implementation consultant Field Service
Implementation consultant Field Service
  • Branche: Medical
  • Situation:
    • TMSE is a long time user of Oracle EBS. In 2012 their 11i instance is upgraded to R12 and with that several processes are evaluated to see if they can be improved by using (new) R12 features.

    • This international project took place in Zoetermeer, European Headquarters in The Netherlands, but the roll-out of the R12 instance was to 12 countries. My international focus was on the DACH countries.

  • Tasks and responsibilities:

    • As a consultant within the Service team I was responsible for the entire design, realisation and training the trainers, of all core Field Service functionality, including territory setup, scheduling logic and all aspects of Mobile Field Service.

  • Results:

    • Successful go-live on the 10th of June 2013, on time and without critical issues within the Service modules

  • Methods and techniques:

    • AIM
  • Tools:

    • SQL developer
  • Software:
    • Oracle E-Business Suite 12.1.3

      • Field Service
      • Mobile Field Service (offline laptop application)
      • Spares Management
      • Service Contracts
      • Territory Management
Toshiba Medical Systems Europe / Deloitte
2 Jahre 3 Monate
2010-01 - 2012-03

Functional EBS Support

Lead functional consultant
Lead functional consultant
  • Branche: Governmet
  • Situation:
    • The Ministry is implementing EBS around financial and procurement modules. During this implementation all departments are to be migrated to the ministry-wide implemenation of EBS and since this is a huge organisation, this is a complex project.

    • An important part of the implementation is relationship management. This is covered by the use of the Oracle Customer Data Hub (formerly TCA). The Hub services as the single point of truth concering relationship data for the many applications that are interfaced to the Hub.
  • Tasks and responsibilities:

    • Responsible for 2nd line support for the modules Purchasing, iProcurement and Customer Data Hub. The ministry has a complex SLA setup and the part that involves Procurement is also part of my responsibility.

    • Besides this, I also function as a QA for projects in which I make sure processes are modelled as close to standard functionality as possible and are set up or built accordingly.

  • Results:
    • Usually I am working on the more complicated problems as far as they are not Finance related. It usually involves Purchasing but from time to time also complex interfaces internal (application interfacing, customer data hub) as well external (XML Gateway / Punchout).

    • Supported the upgrade from 12.0.5 to 12.1.2, did after live support and solved some critical issues.

  • Methods and techniques:

    • AIM, BiSL

  • Tools:
    • SQL developer, TOAD, Assyst,
  • Software:
    • Oracle E-Business Suite 12.1.2 
      • Purchasing
      • iProcurement including Punchout
      • Services Procurement
      • Customer Data Hub (Trading Community Architecture)
      • User Management
      • Subledger Accounting
      • Alert Manager
      • Contracts
      • BI Publisher
      • XML Gateway

      • Approval Management Engine (AME)

Ministry of Economic Affairs, Agriculture and Innovation
2 Jahre 1 Monat
2009-12 - 2011-12

Various

Business consultant
Business consultant
  • Branche: Telecom
  • Situation: 
    • Ziggo is using Oracle EBS for some years now. Every now and then they are in need of extra consulting in regard to EBS.
  • Tasks and responsibilities:

    • Act as a sparring partner for the business

      Create functional specifications for EBS changes

  • Results:

    • For 3 years Ziggo has hired me to share my expertise. So far I have created roughly 15 changes in either the business process or EBS.

  • Software:

    • Oracle E-Business Suite 11.5.9

      • Field Service

      • Teleservice
Ziggo
1 Jahr 3 Monate
2008-10 - 2009-12

TOP

Functional consultant
Functional consultant
  • Branche: Government
  • Situation:
    • The goal of the TOP project is to implement the core process of the  Authority in EBS. The VWA a.o. inspects slaughterhouses and certifies livestock for export. To support these inspections, Oracle Field Service is used.

    • Functional Support has, on behalf of TOP, implemented EBS in the organisation

  • Tasks and responsibilities:

    • Solving incidents, designing changes, setting up the Functional Management department

    • Implementing EBS in the organisation / workfloor

    • Functional Support fulfills a QA role in the TOP project. All decisions in the project will pass QA to verify whether the chosen path is manageable when in production or perhaps other options are better.

  • Results:
    • After a troublesome start in January 2009 the module Field Service went live in one region. After two months of intensive guidance the organisation was able to run the application with their own people.

    • Besides and after the implentation, I totally redesigned the initial setup. The redesign made sure the implementation was closer to the standard and less customisation was needed. I made the design and implemented this change in the organisation. It was considered a major improvement by all users.

    • During the summer months an extensive simulation was done by our project group to investigate how a major organisational change could be supported by Field Service. Our advice was to discontinue the EBS project in its current form.

    • I was the lead consultant for the simulation project.

  • Methods and techniques:

    • AIM, BiSL, Prince2
  • Tools:

    • SQL Developer, Assyst

  • Software:
    • Oracle E-Business Suite 12.0.3

      • Teleservice
      • Field Service
      • Install Base
      • Inventory
Food and Consumer Product Safety Authority (VWA)
3 Jahre 2 Monate
2006-08 - 2009-09

?BSS/OSS?, ?ERP fase 2?

Solution Designer
Solution Designer
  • Branche: Telecom
  • Situation:
    • Casema has been live with Oracle E-Business Suite since 2002. In the period after this, various change and optimization projects have been started. The IT department consists of three teams: Architecture&Design, Development and Maintenance. I have been placed in the first as Solution Designer for the Service related modules

    • As of May 2007 Casema is rolling out its Oracle E-Business Suite environment to two other companies, with which it has joined forces. In this integration project I fulfilled the role of EBS specialist and business consultant in the Assurance domain. The work in this project mainly consists of fit-gap analysis, making business cases and feasibility studies on processes and/or new EBS-features and last but not least advising the business on best practices concerning EBS. Major projects I have been involved in:

    • Connecting Avaya Interaction Center with Oracle E-Business Suite, my role here was Solution Designer.

    • In the ERP project, Oracle Financials, OTL and Purchasing&Inventory were implemented to replace SAP. My role was in the Design Authority, All RFC's, feasibility studies and designs came through me for approval.

    • The BSS/OSS project involved the enhancing and roll out of the Oracle CRM modules over the sister companies. This was the biggest project within the merger of Casema, Multikabel and @Home (together called Ziggo). Within this project I have been responsible for all Assurance related changes and optimisation. E.g. Network registration, Field Service, various interfaces to third parties and third party applications, groups and resources. Within the BSS/OSS project I was also part of the Design Authority.

  • Tasks and responsibilities :

    • As a Solution Designer I made feasibility studies, reviewed RFCs and propose possible alternatives, in EBS as well as in the business. Deliverables were feasibility studies, functional designs and cost calculations.

  • Results:
    • Various successfully migrated changes and various changes which  have been implemented otherwise, based on my advice.

    • May 16, 2008 the new brand Ziggo was launched succesfully. In the week before the sister company Multikabel was successfully migrated to the Casema production environment, including all Multikabel specific changes and product catalog alterations.

  • Methods and techniques:

    • AIM
  • Tools:
    • Toad, Workflow Builder, eRoom, Jira.

  • Software:
    • Oracle E-Business Suite 11.5.9 
      • Teleservice
      • Field Service
      • Universal Work Queue
      • Install Base
      • Inventory
      • Advanced Inbound
    • Oracle E-Business Suite 11.5.10
      • Inventory
      • Purchasing
Casema / Ziggo
9 Monate
2007-08 - 2008-04

Ordina Innovation Team

Innovator / Visionary
Innovator / Visionary
  • Branche: IT
  • Situation:
    • Within Ordina an Innovation Team was started up. Our mission was to follow all developments in the market and Oracle technology. If opportunities would arise / present themselves we had to act on it immediately.

    • From a 400-person organization 8 'visionaries' were selected to take part in this team.

  • Tasks and responsibilities:

    • Identifying market opportunities, work them out in business cases, and eventually transform the opportunity to a product or service.

  • Results:
    • The development of Application Integration Architecture, as presented by Oracle offers many opportunities for an otherwise closed ERP environment. AIA is aimed at integrating Oracle software suites like EBS, Siebel and JDEdwards, but also 3rd party applications. This integration is done through Process Integration Packs (PIP's)

    • One of the results of the Innovation Team was to see how a PIP is made, what the do's and dont's were in creating such a PIP and what a normal development timeline would be. The aim was to make the outcome of this project the basis for all custom Oracle integration development within Ordina.

Ordina n.v.
2 Monate
2007-09 - 2007-10

HaMIS

Functional Consultant
Functional Consultant
  • Branche: Shipping / Harbour Management - Coordination
  • Situation:
    • HaMIS is the management information system designed for the Rotterdam Harbor Company. Ordina was working on the pilot version. At the end of 2007 the Harbor Company would decide which systems integrator gets the assignment to build HaMIS. (see results)

    • The HaMIS solution was a SOA project with different components. One of these components was Oracle Service (part of the E-Business Suite). This module operates mainly 'under water'. The core task of this module was to automatically create tasks and assign them to the harbor inspectors. Every inspector would be able to debrief their tasks through the Field Service Technician Portal

  • Tasks and responsibilities:
    • My tasks within this project were mainly problem solving. I'm not a regular project member, but I use my knowledge of Service and Field Service in case of  'emergencies'. I solve problems within the application, help determine the direction in which the implementation should go and cross validating this with other project parts
  • Results:
    • We managed to get Service and the Technician Portal up and running with the business flows in place. But unfortunately the customer cancelled the project at the last moment.
  • Tools:
    • Oracle Workflow

  • Software:
    • Oracle E-Business Suite 11.5.10

      • Field Service

      • Teleservice
Ordina n.v.
1 Jahr 1 Monat
2005-06 - 2006-06

Common Agricultural Policy

Senior Consultant / Lead Consultant
Senior Consultant / Lead Consultant
  • Branche: Government
  • Situation: 
    • At the Ministry the relative new Common Agricultural Policy had to be implemented, various aspects of this Policy have been translated in so-called process chains. An example of such a process chain is a request for subsidy. This request will run through a Business Process Model and is verified and validated against referential data. Other examples are: subsidy exclusions, sanctions, inspection report processing resulting in sanctions. All these process chains have been implemented in a customized module called the Vertis Extensions. This is a combination of Installed Base, OPM Quality, CRM, Services, customized Workflow components

    • My role in this project is that of lead consultant. As lead consultant I designed the process chain, together with a team. The lead consultant is the central role in the project and responsible for the project result.

  • Tasks and responsibilities:

    • Design of the process chains, building the process chains and present the result during CRP's.

  • Results:

    • Four delivered process chains

  • Methods and techniques:

    • AIM
  • Tools:

    • Workflow Builder, Toad, MS Visual Source Safe

  • Software:
    • Oracle E-Business Suite 11.5.9, Vertis Uitbreidingen
      • Installed Base
      • Service
      • Quality
      • Workflow Builder
Ministry of Agriculture, Nature and Food safety
3 Monate
2005-04 - 2005-06

National Member Registration

Functional consultant
Functional consultant
  • Branche. non-profit
  • Situation:
    • As from May 1st, 2004, the Protestant Church in the Netherlands (PKN) is the continuation of three former churches, the Netherlands Reformed Church, the Reformed Churches in the Netherlands, and the Evangelical Lutheran Church in the Kingdom of the Netherlands. Before this fusion all three churches had their own member registration systems and rules. Within PKN a new member registration system was needed to supersede all previous ones. For this new application PKN chose Oracle E-Business Suite to match all demands of scale, security, decentralization, easy of use and data quality. This application has an average of 2.5 million members and will provide access to approx. 30,000 users. Besides the member registration, the E-Business Suite will also contain a minimum of 500 financial implementations for the local church communities.

  • Tasks and responsibilities:

    • Setup of Web ADI, User Management and Responsibilities and basic setup of Inventory and Purchasing

  • Results:

    • Operational modules Inventory and Purchasing (basic functionality)

  • Methods and techniques:

    • AIM
  • Tools:

    • Toad
  • Software:
    • Oracle E-Business Suite 11.5.10

      • Oracle User Management
      • Purchasing
      • Inventory
Protestant Churches of The Netherlands
2 Jahre 2 Monate
2003-03 - 2005-04

QA Manager, advisor to the board

  • Branche: Food industry, B2B
  • Situation: 
    • Family business, import.

      This job had overlap with Vertis. In March 2003 I started working 80% for Vertis and 20% for Klaas de Poel bv. March and April 2005 fulltime at Klaas de Poel bv

  • Tasks and responsibilities:

    •  Complete (policy) management of the quality and logistics department.

    • Responsible for the automation of the production logistics (e.g. tracking & tracing)

    • Advising (foreign) suppliers concerning microbiological analyses.

    • Verification and validation of the quality management system

    • Trainer

    • Executing internal audits

    • Initiate plans for improvement and monitor the progress.

  • Results:
    • Operational Vendor Rating system

    • Customer complaint repository

    • Automation of the complete production logistics.

    • Obtained HACCP-certificate (version 3), BRC and GMP (01&04).

  • Methods and techniques:

    • S88, S95, HACCP, BRC and GMP

  • Software:

    • Custom built ERP (made by me within Dbase III / MS Access, contains all production administration and production planning, customer recipes, complaints and other HACCP related information)

      This has been running since 1996 (last checked: May 2017)

Klaas de Poel bv
3 Jahre 1 Monat
2002-03 - 2005-03

Functional Consultant Oracle E-Business Suite

  • Branche: IT
  • Situation:
    • Projects and application management contracts

      While working for Vertis I first came into contact with EBS. After 6 months of internal courses I started doing EBS maintenance. Vertis has various customers who have their EBS maintenance outsourced to Vertis. All incidents and RFC pass through the maintenance department. Work therefore mainly existed of solving these incidents and make feasibility studies and implement changes for various customers. Besides that I've been involved in the implementation of EBS at Lasaulec BV. Right after the live date, the SLA was in effect which meant hard work right away. Two years I've been doing dedicated work for Lasaulec, mainly the modules Inventory and Purchasing. Customers for which I have worked during my Vertis employment:

    • Royal Niemeyer BV (part of BAT-group)

    • Dopharma
    • Lasaulec
  • Tasks and responsibilities:

    • Design and describe processes based upon EBS.

    • Develop and implement processes based upon EBS.

    • Internal support of collegues and advising management on the Oracle E-Business Suite.

    • Execution of tasks concerning incident-, problem- and changemanagement (incident solving, feasibility studies and implementation of RFC’s, et cetera).

    • Be the contact person for clients key-users.

    • Content support and business plan design of the EBS-division.

    • Support users.

  • Results:
    • Design of a complete new purchase flow for a customer in the technical wholesale. Subject focus on  core-functionality.

    • Functional integration of Oracle Process Manufacturing with common purchasing to upgrade EBS 10.7 to 11.5.9

    • Revising the complete authorization structure and purchase hierarchies together with AO/IC for more than 500 users.

    • Aiding a tobacco manufacturer in implementing OPM, and meanwhile optimizing logistic processes, resulting in a new, better way of providing raw materials to the floor. All of which was OPM compatible.

    • Designed and created an operational interface between OPM and Quintiq (advanced planning & scheduling), so OPM-generated batches could be scheduled visually.

  • Methods and techniques:

    • AIM, ITIL

  • Tools:
    • Toad
  • Software:
    • Oracle E-Business Suite 11.5.8
      • Order Management
      • Inventory
      • Purchasing
      • Process Manufacturing

      • Quintiq

Vertis bv

Aus- und Weiterbildung

Education:

  • 2002: University of Groningen
    • Industrial Engineering and Management Sciences ? IT
  • 1996: Lauwers College
    • VWO (pre-academic education)

Certificates and training:

  • Coursera / University of Eindhoven
    • 2015: Process Mining: Data Science in action
  • Oracle University
    • 2006: 11i Workflow Fundamentals
    • 2005: 11i Advanced Supply Chain Planning
    • 2005: 11i Advanced Supply Chain Planning
    • 2005: 11i E-Business Suite Essentials for implementers
  • Vertis
    • 2004: C-grade for EBS consultants (Oracle endorsed course) 
  • Altran
    • 2009: BiSL 
  • Lagant
    • 2006: Prince2 Foundation 
  • TWP
    • 2005: S88/S95 

Kompetenzen

Top-Skills

Oracle Oracle APEX Oracle Applications

Produkte / Standards / Erfahrungen / Methoden

JSON / REST
Main Oracle E-Business Suite modules
Service, Install Base, Service Contracts, Field Service, Purchasing, iProcurement, User Management, Customer Data Hub / TCA, Inventory
Oracle APEX
PL/SQL
SQL

Profile:

  • I like to position myself as a Technical Business Consultant. My expertise mainly comes from very complex ERP implementations which usually heavily customized. Having been a pure functional consultant for a couple of years, I?m now doing more and more development myself. (Since APEX 4 I?ve been using this tool non-stop) So now I have the experience of most facets of the development process; gathering requirements, challenging(!) the requirements and building the solutions if necessary.

  • In the end I?m a problem solver. Whether it?s a business problem or a technical problem; I?m committed to find the solution that works.


With Oracle EBS I have implementation and / or support experience in the following modules:

  • Service
  • Field Service
  • iSupport
  • Mobile Field Service (laptop)
  • Install Base
  • Service Contracts
  • Purchasing
  • iProcurement
  • Punchout / XML Gateway
  • Inventory
  • Human Resources (basic)
  • Approval Management Engine (AME)
  • Services Procurement
  • Advanced Inbound Telephony, incl Adapter SDK
  • Email Center
  • Universal Work Queue (UWQ)
  • Territory Management
  • Process Manufacturing
  • Customer Data Hub (Trading Community Architecture)
  • User Management
  • System Administration
  • Oracle Alert
  • Forms Personalization
  • Framework Personalization
  • Workflow
  • BI Publisher

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.