Experience

 

Below is an overview of projects in which I've participated. For each project, I've added a few links which provide more info.

As Colruyt Group, the largest retail group in Belgium, offers hundreds of thousands different products to consumers spread across different store concepts, they want to manage all product master data in an efficient way, especially in a fast changing environment with ever increasing legislation and consumer requirements. Therefore the PIM - Product Information Management - programme was created in order to be able to provide reliable product information to the different business operating units within Colruyt Group.

The programme consists out of the following tracks:

  • Organization & governance: Modifying existing processes within the organisation and setting up a centralized service center for product management
  • Tools: Implementing new applications to obtain product information from suppliers and manage product master data
  • Services: Setting up online and batch application services to provide product information to consumers such as shop floor applications, websites, ...

As a functional analyst within this programme, I mainly participated in the tools and services tracks in which my main tasks were to:

  • Analyse and describe system requirements in deliverables such as context and scope diagrams, use cases, logical data models, state diagrams, user interface designs, non-functional requirements, ...
  • Enable integrations between the new PIM application and legacy systems by creating integration requirements
  • Migrate data from legacy systems to the new PIM application and improve data quality
  • Create online and batch service specifications to be able to offer product information to consumers
  • Support the testing team during system testing, system integration testing, ... and manage user acceptance testing
  • Create training material, provide training and offer support to business

Colruyt Group GS1 GDSN Stibo Step

Fine Food Meat, the largest meat-processing company in Belgium and a member of Colruyt Group, cuts, processes and packages poultry, beef, veal and pork and also takes care of salads and vegetarian products. Previously, Fine Food Meat used a number of custom built applications to support their business needs.

However, as the company has a steady grow, these applications became insufficient to fulfill the requirements in terms of traceability, procurement, warehouse management, costing & invoicing, ... That's why Fine Food Meat decided to make the transition to an industry specific MES - Manufacturing Exection System - for both its existing plant as well as a newly constructed plant. As this application had to be configured from scratch, multiple analysts participated in the implementation project. My focus was on costing, production workflows, master data and business intelligence. This included:

  • Analysing business & system requirements, for example for internal operations and outside services
  • Configuring the MES solution to support business processes and to optimize the usability
  • Defining master data such as bill of materials, cutting plans, cost centers, ... for different processes
  • Setting up a costing system to determine the direct cost of products as well as stock value, sales price, ...
  • Create costing reports such as production efficiency for converging and diverging production
  • Create and execute test cases in HP ALM for system testing, regression testing, ...
  • Increase knowledge of coaches and key users through trainings and provide operational support

Colruyt Group CSB Systems

Symeta, a member of Colruyt Group, is a state of the art printing company which specializes in digital and variable data printing as well as mailing. To optimize the performance of the business processes and to focus on added value in each process, they launched a number of projects:

  • To improve warehouse management, logistics and procurement by implementing process modifications such as introducing a 2 bin flow, cross docking and just in time deliveries, determine the standard warehouse assortment and its optimal stock and order quantity, optimizing SSCC management, ...
  • To optimize production workflows and to achieve operational excellence by determining production categories, redesigning processes to reduce waste and to obtain a more consistent level of quality, setting up process indicators to monitor operations, ...

As a member of the process & quality team, my task was to:

  • Get a better overview of the as is process by modeling business processes and documenting working methods
  • Identify bottlenecks and determine - together with stakeholders - solutions to these bottlenecks to reduce waste
  • Define the to be process and implement the process change in business
  • Determining performance indicators such as takt time, throughput, ...

Symeta 

Before implementing a new software solution, you want to make sure the application is configured or developed as expected. As a functional analyst in various projects and as a member of the Center of Excellence for Testing in Colruyt Group, I participated in structured testing & quality assurance activities in which we followed the V-model as a methodology and used HP ALM as a test management tool. These activities included:

  • Creation of master test plans, system test plans, ... at an early stage in the project
  • Provide training in HP ALM and offer support to test specialists, test leads, ...
  • Creation and execution of test cases during system testing, system integration testing, user acceptance testing, ...
  • Follow up on defects and create testing status reports
  • Optimize the methodology for system and system integration testing, user acceptance testing, ...

HP ALM

Symeta, a member of Colruyt Group, is a state of the art printing company which specializes in digital and variable data printing as well as mailing. To reduce rework and to identify risks in the organisation, Symeta launched a project to introduce continuous improvement and to optimise the quality management system.

Furthermore, as Symeta also offers products & services to customers outside of Colruyt group, one of the requirements was to comply to ISO 9001. By obtaining this quality label, Symeta is able to ensure that their products & services consistently meet customer expectations and the necessary steps are taken to systematically improve the performance of the organisation.

As a member of the process & quality team, I helped Symeta to achieve its goals by:

  • Introducing a number of quality management methodologies such as PDCA, ishikawa diagrams, root cause analysis, ...
  • Determining - together with stakeholders - corrective and preventive actions and evaluating the effectiveness
  • Performing 1st party - process and department - audits and managing 3rd party ISO 9001 audits
  • Introducing crucial control points to identify non-conforming products to prevent their unintended use or delivery
  • Determining performance indicators such as delivery on time in full, cost of non-quality, ...

Symeta ISO 9001

Customer Communication & Experiences, the largest communication agency in Belgium and a member of Colruyt Group, relies on its ERP system to support the business processes, for example for the creation of sales orders, procurement of outside services, time registration on the shop floor, invoicing, ... For this company, the management of the application lifecycle was crucial. CCX could rely on me to:

  • Analyse business & system requirements
  • Configure the ERP system to support business processes and optimise the usability
  • Manage application upgrades, create and execute test scenarios to avoid regression
  • Offer 3rd line support to business and creating a support system through helpdesk, key users, ...
  • Create training material and provide training to business

Colruyt Group Cerm

When implementing a new application, most of the time an integration with one or several systems is required. This certainly was the case in most projects in which I've participated in the past. Some examples:

  • Integration between the existing ERP system and a new CRM application
    As Symeta not only offers products & services to business operating units within Colruyt Group but also to customers outside of Colruyt Group, they wanted to improve the CRM to be able to better manage leads, accounts and opportunities. To meet the business requirements, Salesforce was introduced which had to be integrated with the existing ERP system, CERM.
  • Integration between the legacy systems and a new PIM application
    Colruyt Group decided to make the switch from legacy systems to a new PIM application, STEP. However, as the existing mainframe modules could not be decommissioned, an integration was required.
  • Integration between the existing ERP system and a new web-2-print application
    One of Symeta's customers requested a W2P module in which they can create sales orders from a set of predefined products in the catalogue. To enable planning and invoicing of these orders, an integration with the existing ERP system, CERM, was required.

Setting up these integrations involved a number of steps such as:

  • Analysing business, system and integration requirements
  • Creating a datamodel for different applications and determining data lineage
  • Creating integration & service specifications including data transformation rules
  • Creating and executing test scenarios and test cases for system integration testing
  • Data selection and migration

Colruyt Group Symeta Cerm Stibo Step

Nowadays, every company needs a website because that's where so many of your potential customers are for so much of the time. Even if you have a brick-and-mortar store, investing in building an online presence can increase your offline store’s profits thanks to customers researching items online before purchasing them in-store. Think of it as an online billboard, a digital business card providing visitors with up to date information about your business.

That's why when we design a website, we include an award winning cloud based content management system which enables you to manage content in an easy and intuitive manner. In such a project, we focus on getting the minimum viable product online as fast as possible and adding extra functionalities later on in the project. Such projects include:

  • Analysis of functional requirements and offering an early POC
  • A custom responsive design which focuses on user experience
  • The ability to easily manage content by using Joomla CMS
  • In depth cross browser and cross device testing
  • Training and knowledge transfer including aftercare

You can visit some of the websites I've created for small and medium sized enterprises by selecting the links below.

Joomla CMS Perazzi Benelli

Symeta is a state of the art printing company which specializes in digital and variable data printing as well as mailing. As a member of Colruyt Group, they provide direct mailing solutions for all operating units within this group. When creating direct mailing campaigns on a regular base, Belgian postal service Bpost offers the possibility to reduce costs when complying to their sorting system. By introducing Bpost MailID v2, Symeta was able to adapt to the sorting requirements for direct mailing drops. This comes in two variations:

  • MailID: A way to identify each letter with a unique barcode. The barcode itself holds no routing or sorting information; its only purpose is to identify the mail piece in a unique way.
  • Round & sequence: A way to pre-sort the deposit in a specific order, based on addressee location. A sequence reference is printed on the envelope in addition to the mailID barcode.

As Colruyt Group is sending out tens of millions of letters each year, being able to make use of the cost reduction which Bpost offers meant the ROI of this project was quite huge.

As a functional analyst within this project, my main task was to:

  • Get a better overview of the application landscape by creating context & scope diagrams
  • Determine integration requirements by analysing the request and response specifications
  • Create test scenarios and test cases to verify if the system and non-functional requirements were met

Symeta Bpost mail ID

During several projects in industries such as printing & mailing, design & marketing, application development, meat processing, ... I was occupied with the requirements analysis, design & testing of reporting about indicators for operations, quality management, costing, ... By setting up the necessary reports, the company was able to monitor the performance of the processes. Below are some examples of reports I've created in the past for various industries:

  • Quality management: Scrap ratio, cost of non-quality, customer satisfaction, ...
  • Design & marketing: Estimated cost vs actual cost for each department such as design, copywriting, photo studio, video, web, ...
  • Printing & mailing: Takt time, throughput, overall equipment effectiveness, delivery on time in full, ...
  • Meat processing: Production efficiency for both converging and diverging production processes

The key aspect in generating these reports was determining the indicators which actually mattered and for which data was easily available. Next to that, I also made sure the data was graspable by representing the data in a visual way and comparing it to predefined targets. Finally, these reports offered the possibility to drill down on data so more details could be obtained.

Colruyt Group Symeta

Storopack is a worldwide player in providing packaging solutions for shippers needing packing supplies including air cushion packaging, paper padding, ... To support Storopack in its offline sales, we launched a direct mailing campaign in which customers received a printed catalogue containing an overview of all available products.

This campaign included the design of the catalogue, heatset rotation printing, determining the target group, direct mailing and reporting of the campaign results. To make sure Storopack stayed top of mind, we also launched an online campaign in which customers periodically received a newsletter to put the latest developments and promotions in the spotlights.

Storopack Group

Refresco is Europe's largest independent juice and soft drink manufacturer and offers bottling solutions for national brands as well as private labels. It goes without saying that packaging plays a vital role in selling FMCG to consumers, that's why Refresco launched several projects to redesign the product packaging. As packaging development coordinator, Refresco's customers could rely on me for the coordination and realization of packaging for cans, labels, shrink-wrap films, ... This included:

  • In house packaging design & follow-up of externally supplied artwork
  • Coordination between internal operations, customers and suppliers from concept to delivery
  • Making sure the packaging holds the right information in respect to legislation, technical specifications, corporate identity & marketing requirements, ...
  • Quality assurance during the printing process such as flexo printing, offset printing, ... through ready for press

Refresco Group