About JohanBI, DwH and ETL Consultant

Johan De Pauw has studied Information Management and is active participant in the area of Data warehouse, Business Intelligence, Business Logical and Finance.

Professional experience

His expertise in the domains DwH, BI, Data mining and ITIL ensure a successful performance management implementation in addition with his driven characteristics and his passion and drive in his job.

2010 - now

Business Intelligence Consultant at Alti.CernumBusiness Intelligence and Business Objects Analyst Presales Alti.Cernum

Getting a more in-depth knowledge of designing universes, creating advanced functional reports, dashboard design (Xcelsius), setting up a performance BO (Business Objects) Environment (BOE XI 3.1 SP2+FP2.3, BOE XI 3.1 SP3) with an Oracle or SQL Server for pre-sales activities. Being a contact point for SAP BOE 4.0 gave me the opportunity to discover and use the newest technology of BO in-depth.

March - May 2011

Business Intelligence ConsultantKuwait Petroleum International (Q8), BI/BO Consultant Alti.Cernum

The Business Intelligence project at Q8 may be divided into three projects:

Drawing a complete new Data Warehouse model for the track site-activity of Q8 Petroleum.

The second project involved the development of a showcase for advanced reporting with several BI tools such as: SAP Business Objects WebI 3.1, SAP Business Objects Deski, SAP Business Objects Live Office, SAP Business Objects WebI 4.0.

Rebuilding a huge universe for reporting purposes by defining new classes, objects, measures, joins, contexts,… was the third part.

Feb - March 2011

Business Intelligence Consultant at A. Raymond - Raynet A. Raymond - Raynet, BI/BO Analyst

During my international project in France, my mission was to establish the data flow between SAP BW (Business Warehouse) and SAP BO (Business Objects) using BeX Query. The project was won after some pre-sales actions I did. After the setup, I started optimizing the universes. In the next phase, I gave the client training on how everything was integrated and what the functionalities were in terms of querying, reporting and the integration between SAP CRM and SAP BO using Open Doc.

Nov 2010

Business Intelligence Consultant at Q8 PetroleumBI Analyst, BO Consultant Alti.Cernum

Kuwait Petroleum is one of the biggest oil companies in the world. I had the opportunity to support Q8 with the migration of their BO Environment from BO 6.5 to BO XI 3.1.

July - Sept 2007-2010

Business Intelligence Consultant at Frutarom Industries Analyst, Programmer, Business Intelligence

1. My main goal of this project was to create a tool to manage all their product specification data – and use that information on an effective way.

2. They asked me to build an application in VB.NET and Access in a way that different departments could work continuously at the same time.

3. I was responsible to configure a FT-IR laboratory tool to identify advanced chemical compounds.

March - April 2010

Business Intelligence Consultant at KeyrusAnalyst and Business Intelligence Consultant

A French international hypermarket chain decided to outsource the handling of their targeting & analysis – related campaign results and other supplier relationship management requests to Keyrus.

My mission was to transform raw data into statistic or data files using SAS Base, SAS Macro, SAS SQL and Microsoft Pivot Tables.
I was responsible for the pre analyses. The pre analyses are important to check whether it is interesting to launch the marketing campaign. These analyses are based on historical data in the Data warehouse and manipulated with SAS Base code. The analyses contained a pool of the most ‘valuable’ customers for that specific campaign based on historical data and cross selling.

EducationEducation and Training

I studied Information Management. My education covers a whole spectrum of things to improve the business activities in terms of revenue, ROE, cashflow, ...

2011

SAP Education Belgium

BW310 - SAP Business Information Warehouse
- Architecture of SAP NetWeaver BW 7.0
- Overview of the most important objects (InfoProviders,...) and their attributes
- Components of the data flow and extraction from SAP and other sources
- Benefits and use of BW content
- Introduction to the administration of BW data targets
- Principles of optimizing query performance (BW accelera

2007-2010

Degree in Information Management, Mechelen University College

- Oracle PL/SQL
- Data Warehousing
- Business Intelligence
- Cubes
- Cognos
- Pentaho (Kettle Tool)
- Performance Management
- Database Administration
- ERP / UML / BPM
- Customer Relationship Management
- Information Technology Infrastructure Library
- Presentation Skills
- Communication Skills

2010

Keyrus Academy

- Data warehousing concepts
- Multi-dimensional modeling
- Extract Transform and Load (ETL)

RecommendationsOpinions of people I worked with

After finishing a project I have asked the people of that project to leave a quoute about the quality of my work. 6 Recommendations are available on request.

Hugo De Smet

Johan is a very knowledgeable and hard working IT and data base expert, and pleasant to work with.

Chris Vandermeiren

As a student at Lessius Mechelen - Information Management, Johan was remarkably eager to learn. No effort was too much for him. Johan is very determinated to learn new theories, programming languages and techniques. I'm sure he will be a very dedicated and loyal ICT-professional.

Vicky Franssen

Johan is one of the most friendly, polite, conscientious and helpful students I’ve ever teached. He really helps every co-student (or teacher) in every situation which made him most noticeable on that matter. He’s also mild, cooperative in a non-arrogant way, and agreeable to work with. Furthermore he's precise and conscientious.