2008-2009 - Oracle Business Intelligent Consultant on SAP ERP
During my time by NewFrontiers, I have principally worked as an OBIEE expert and have a DataWarehouse focus on the master data management. I have then decomposed it in three parts : OBIEE, Master Data Management and DataWarehouse.
OBIEE Consultant
Main realisations
- Migration of the reporting tool from Discover to OBIEE in Tommy Hilfiger : The complete history (in Dutch)
- Development of OBIEE Complement : A tool to manage the translation process and to synchronize the database comments with the obiee description
- Presentation on the OBI Forum : How can OBIEE help us in a Master Data Management project ?
Techniques
- Managing of the forecast and quota values :
- by adding them in the Business Model with the vertical/row-based fragmentation and level-based measure calculations techniques of OBIEE
- by permitting their update via the write back Obiee functionality
- Configuration of the query cache and planning of the purge
- Modeling of Many-to-many relationship with bridge table or join property of the logical table source
Master Data Management/Data Quality Consultant
Main Realisations
- Development of the NewFrontiers Master Data Management Product
- Data Integrity Project at Electrabel between SAP ISU and SAP CRM
- Presentation on the OBI Forum : How can OBIEE help us in a Master Data Management project ?
Oracle Warehouse Builder techniques
With Oracle Warehouse Builder, implementation of all data quality techniques :
- Load of the metadata (Date Rules, Table, Columns) in the dimensional model using the Public Views
- Redefinition of the UTL_NAME_ADDR PL/SQL Package linked to the Name and Address Operator to add our own address check program. See section How that works ?
DataWarehouse Consultant
Main Realisations
- Development of a ROLAP cube and integration of the data from the point of sales at Tommy Hilfiger
- Development in OMB Script of an automatic testing program for OWB
- Modification of the SAP Cost Control Module for the University of Tilburg
DataWarehouse techniques
All this datawarehouse techniques have been implemented with Oracle Warehouse Builder
2003-2008 - IT Architect Consultant SemWare
Working for the company Semware, I had two main jobs : IT Manager of LANCY MIXJET and an internal role as Oracle Developer, responsible of the system integration and reporting environment.
IT Executive Manager LANCY MIXJET
Subsidiary of worldwide company PUTZMEISTER (Concrete boom pumps, trucks, trailers, equipment and parts manufacturered) I worked in a project environment which was both functional as technical to help the ICT to become a competitive advantage.
- Strategic Information Technology Definition and yearly budget proposition according to the local and headquarters’ strategies (Budget of 140 K Euro, 7 servers, 47 personal computers)
- Management and purchase negotiation with suppliers
- Coordinator for cross functional processes (Supply Chain, Finance Controlling, Workshop material flow, Automation Warehouse, …)
- Project Leader of a Master Data Management Project on the Supply Chain
- Implementation of Real-Time Software and bar code automation system (Workshop, Warehouse)
- Development of Business DataWarehouse (for interface between ERP BAAN and headquarters’ SAP BW module and automatic update of Excel financial monthly reporting).
- Implementation of PDM Link by PTC – PLM Software (Product Life Management)
- Reorganization of IT Structure with implementation of a stream desktop system, Exchange Outlook 2007 Migration
- Reorganization of Telephony System with implementation of computer integration on a IPBX
Oracle Developer SemWare
I worked on the software IGus which is a package application to manage seeds production, responsible of the system integration and reporting environment.
- Interface development for SAP R/3 (idoc text file) and ERP BAAN (ole/com technology)
- Integration and deployment of Report Developer Oracle in IGUS Software (Package application to manage seeds production)
- Web Support of IGUS Software
- Business Object : Development and support of the BOBJ IGUS module
- Various developments for the process industry using Oracle Forms/Report (Transact SQL, package, stored procedures, triggers and loading batches)
- Portal CRM development on Object Symfony PHP Framework
1998-2003 - Project Manager / Functional and BI Consultant on BAAN
with IT consulting GUIMON
- Project Manager in BAAN Implementation (Distribution, Finance, Industry, Process and Euro Migration) for main customers : Lancy, Maestria and Pommiers
- Business Intelligence Expert with Crystal Info (now known as Business Object CMS and Crystal Reports) on every BAAN Module (Finance, Supply Chain, Sales)
- Audit and workshops on BAAN Software
- Implementation of automation stock management per profiles organised by class and consumption – ABZ Curve (reduction of 10% of average stock and 50% of purchasing order book)
- Project Manager in project reorganization (Sales processes, Warehouse material flow)
- Coordination, planning, quality and animation of running committees
- Definition, implementation and improvement of business process in accordance with Executive Manager
- Working out the terms of requirement and managing the decision-making process