Functional technical design of datawarehouses and datamarts

BI Consultancy project at BNP BrusselsMainly building BO Reports and ETL (sybase environment)

Startup business, planning- , financial-, stock support and training

- Learning stock trading (different courses)- Follow-up reporting portfolio- Maintain IT knowledge

o Creation en makeup of a datawarehouse o ETL (Extraction AS400 and transformation and modelling in MS-SQL Server).o Set-up of a Management Dashboard with WebFocus Business Intelligenceo Advanced Key-user and end-user reporting in WebFocus and Reporting Services via the SharePoint systemUsed products: - Pentaho Data integration - Kettle (spoon & chef)- CaseStudio (design tool) - Toad data modeller- MS SQL Server 2000 (Full package)- MS SQL Server 2005 (Full package) i.e. SSIS, SSAS. SSRS- WebFocus 7.1.x en 7.6.x- Iway (Information builders)- SharePoint

Freelance BI Consultant worked for different customers and sectorsBI reporting / ETL / DB Specialist

o SFC (Shop Floor Control) Waste and performance reporting for lamp production lines. Using statistics, trends and analysis should this lead to more effective production methods.This project gathers online production data and transforms this raw data into lines a online datawarehouse and data mart specially for Reporting usage for all kind of users managers, product engineers/ controllers even workers making the .o Cost management Reporting systeemo Other Online Reporting systemen.o Business Balance Scorecardso Personnel systeem.My contribution to this was design of necessary datawarehouse data marts and complete reporting systems mainly (BO universes en reporting).Used products: - Powerdesigner- CaseStudio (design tool)- Toad - PL/Sql developer- Intrack/wonderware (production data collection systems)- SQL Server (Full package)- Oracle (Full package)- Business Objects (Full package)- Visio

Worked for several clients - mainly EVC International SA (7 years) MIS Systemother small projects - Lumiance NV - ABB- CVP- BP Belgium NV Div. Chemicals- Case Consult (gateways and power builder)- Radson N.V.- Sociale dienst VEV- DP World- Laco - Give some trainings for Fortis, ASLK, VEV , Radson

Functioneel- en technisch ontwerp in verband met uitbreiding, optimalisatie en interfacing tussen mainframe- en decentrale systemen naar een data warehouse toe.Studie van nieuwe implementaties ter optimalisatie van end user rapportering systemen.Verbetering en optimalisatie van een datamart systeem en het toevoegen van nieuwe ontwikkelingen tbv het Credit Risk Management team.

BI Consultant IBB-Focus product : demo / pre-sales / integration / training / follow-up / projects

Reporting / ETL developer