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.