Erwin Ruttens Email & Phone Number

Vilvoorde

Mechelen

Establish a commercial offering and methodology regarding data visualisation.

Keerbergen - Belgium

With bebright I can bring an extra dimension to any BI project. By introducing report governance you will prevent report clutter and deliver consistency and quality to your reports.

Beerse

VIEWS reporting platformResponsible for the EMEA region (P2P business area).SPOC for the EMEA region regarding reporting/information requests in the Procure to Pay area, reporting directly to the Manager IT Applications (technical) and Director Indirect Procurement Europe (Functional).• Responsible for enhancements to the existing platform• Requirements gathering / Functional Design.• User acceptance testing.• Project member of the Vision project (US initiative) : o make sure EMEA requirements are captured in the new global spend reporting platform.o Give advise in data modeling; report design• Design, develop and test reports in Cognos Report Studio, Query Studio and Analysis Studio• Design, develop and test Janssen Commercial Procurement Dashboard, Medical Devices and Diagnostics Dashboard and Supplier Based Optimisation Dashboard (Tableau Software)• Train end-users of the reporting environment (Cognos Connection and Analysis Studio)

Project lead, reporting directly to the Program Manager, for the implementation of the BI program which will result in a complete new data warehouse environment.Creation of a business glossary which centralises all measures and dimensions and their business definitions.Definition of 14 implementation increments on 2 parallel tracks in order to be able to deliver business added value every 3 months.Responsible for :• Defining scope and business requirements document.• Translating business requirements into a functional solution document.• Designing dashboard and report prototypes and all communications with business. • Testing of the reporting frameworks• Development of dashboards and reports in Cognos Report Studio• Training of BICC and Business end-users

Manager of a team of 5 Business Analysts and reporting directly to the BICC Director. Day to day business support in providing information, thru reports and analysis, about the Customer Service and Bill to Cash processes for residential customers.Introduction of visualisation guidelines to optimise the presentation of information to business and to obtain a unique look and feel for all information delivered to business by the BICC team.The visualisation guidelines have been introduced in the team and every report or dashboard created needs to be compliant with these guidelines before being published.

Manager of a team of 4 to 6 consultants and reporting directly to the ICT-Manager. InsightDuring a short timeframe the team managed to deliver a central reporting environment which gives the business insight in the results of the company and the ability to analyse these results using an intuitive interface. A portal, called Insight, was created to centralise all management reports giving them a quality label to ensure consistency and reliability.The data warehouse gathers information from the different operational systems in order to create a complete view of the customer.Data Mining – Bad Debt SegmentationTogether with an external partner we managed to segment our customer base according to their payment behaviour. It will help the business to define new processes or modify existing processes to reduce bad debt. This ‘pilot’ project was able to convince management of the benefit of data mining.

BrusselsProduct and Service RegistrationBusiness Units, spread over different European countries, are in charge for a range of Sony products. To be able to understand what people influenced in buying their products, they developed on-line and off-line registration and survey forms. I was responsible for gathering this data, loading it into a central data warehouse and providing the Business Units with a user-friendly reporting environment for further analysis.Analysis of business requirementsGathering of data from different sourcesData cleansingETLDefinition and Implementation of Data Quality rulesDesign and implementation of the European Customer Data WarehouseDesign and Implementation of the reporting UniverseBusiness Objects end-user trainingData Extraction for campaign managementWeb Traffic AnalysisIntegration of HitBox as a central platform for the analysis of visitor behaviour on any European Sony website. As liaison between the Business Users and IT developers I'm responsible for translating business requirements into technical specifications for tagging the web pages.Analysis of business requirementsDefinition of page name, content group, segment, funnel and campaign variablesAccount and user managementCustom report buildingHitBox Enterprise and Commerce end-user training

C-Concept, Brussels; Definition and Implementation of a dynamic procedure for loading data, independent of its structure or format.Analysing the reporting requirements of the Business Units and providing a solution for the creation and distribution of the reports within the Sony network.Blagden PackagingCentralisation of stock data from the different plants and the creation of analysis reports using Pilot as OLAP tool.BelgacomTesting of new releases of the customer front-end application which is used in the different Belgacom Stores.