Nicolas Gerard (To the Dutch Resume)
Current address: Oegstgeest (Randstad - The Netherlands)
Age: 37
On Internet : gerardnico.com, Expert level in Oracle BI Forum

A Business Intelligence and DataWarehouse Consultant with 12 years of working experience.

• BI and Data Warehouse architecture skills
• CRM/ERP business knowledge (7 years as functional consultant)
• Industry experience (in manufacturing, process, retail, …)
• Technical DBA and tuning capabilities
• Interface design expertise between various IT Business Software

by Hot Item

• Obiee
• Informatica PowerCenter
• Oracle Database

by Ciber BV

On this role, I have principally worked with OBIEE as data access tool and Oracle Warehouse Builder as data integration tool to construct Business Intelligence and DataWarehousing environments.

Projects:

• by Gemeente Belastingen Rotterdam (4 month): OWB Lead and OBIEE Lead Developer on an existing datawarehouse build against the ERP Oracle E-Business Suite.
  • Oracle Warehouse Builder: data modeling of 3 business event/process in the datawarehouse, data mart and staging layers (with delta detection), Oracle E-Business Suite Module Involved: AR (Account Receivable) and CS (Support, Incident), OWB target user configurations, OMB Release scripting, Management and test on the O(T)AP street, query and mapping optimizations, parallelism configuration (query execution and DML)
  • OBIEE: repository modeling, dashboard development and release, usage tracking installation
• by van Gansewinkel Groep (10 month): OBIEE Lead and OWB Developer
  • OBIEE: Migration of the current environment, release management, repository data modeling against the databases (Oracle, SQL Server) and Excel Files using data federation, level-based measures and AGO functions, usage tracking installation and dashboard design
  • Oracle Warehouse Builder: Integration of the data sources Salesforce, Clear, Cargan through ODBC (SQL Server) and flat files (external tables), OMB scripting, dimension modeling
  • APEX: migration of applications and a few modifications.
  • Oracle Database: Development of a Java Stored Procedure to transform before integration the Salesforce files generated by Salesforce APEX Data Loader

by NewFrontiers Consultancy BV

I have principally worked with OBIEE as data access tool and Oracle Warehouse Builder as data integration tool to construct a complete Business Intelligence environment against the ERP SAP.

Projects:

• Presentation on the OBI Forum : How can OBIEE help us in a Master Data Management project ?
• Data Quality Project at Electrabel between SAP ISU and SAP CRM
• Development of the NewFrontiers Master Data Management Product with MapViewer Integration.
• Migration of the reporting tool from Discover to OBIEE at 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
• 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 the Quickstart datawarehouse application developed on Oracle Warehouse Builder.
• Modification of the SAP Cost Control Module Star Model for the University of Tilburg
• Help in in the migration of the Quickstart reporting tool from OBIEE to SAP Business Object

Working for the company Semware, I had two main roles : IT Manager of LANCY MIXJET and an internal role as Oracle Developer, responsible of the system integration and reporting environment.

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)
• Project Leader of a Master Data Management Project on the Supply Chain
• Development of a DataWarehouse (for interface between ERP BAAN and headquarters SAP BW module and automatic update of Excel financial monthly reporting).
• Implementation of Real-Time Software and bar code automation system (Workshop, Warehouse)
• Implementation of PDM Link (PTC) – PLM Software (Product Life Management)

I worked on the software IGus (build on Oracle Forms and Report) 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 Oracle Report in IGUS Software
• Business Object : Development and support of the Business Object IGUS module
• Web Support of IGUS Software

with IT consulting GUIMON

• Project Manager BAAN Implementation (Distribution, Finance, Manufacturing, Process, After-sales, 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

• Analysis / Dashboard Tools : Oracle Business Intelligence (also known as Siebel Analytics), Business Object (BOBJ V, XI)
• Reporting Tools: Business Intelligence Publisher (XML Publisher), Crystal Reports, Oracle Report
• Data Integration Tools : Oracle Warehouse Builder, Informatica PowerCenter, Oracle Data Integrator
  
• Relational Database : Oracle, Microsoft Sql Server
• Mutli-Dimensional Database: Essbase, Oracle OLAP
• Database Client: SQL Developer, SQLPlus, Toad
• Application : SAP (Data Access), BAAN (Distribution, Industry, Finance, Process), Oracle E-Business Suite, Salesforce
• Scripting : SQL, PL/SQL, Java, PHP, Javascript, Visual basic script
• Integrated development environment : Apex, Eclipse, Oracle Forms/Report
• Techniques : WebService (SOAP), Ajax, XmlRpc
• Spatial, Map, Chart : Oracle MapViewer, Oracle Spatial
• Operating System: Windows Server, Unix/Linux (OEL, RedHat)

• Certification 2010: Oracle Business Intelligence Foundation 10.1.3 Essentials
• Self-study 2010 : Linux (OEL, RedHat), Oracle Business Intelligence Application 7.9.6.1 on Oracle E-Business Suite
• Home Training 2009 : BusinessObjects Enterprise XI 3.0, Informatica PowerCenter, Oracle Data Integrator
  
• Next to the product documentation, my main source of knowledge comes from my reference books:
  • The DataWarehouse Tool Kit by Ralph Kimball
  • Effective Oracle by Design by Tom Kyte
  • Code Complete by Steve McConnell

• Dutch : Fluent (Effective Operational Proficiency or upper intermediate (C1))
• French : Mother tongue
• English : Vantage or intermediate (B2)

• Reading: History and Economy (Galbraith, Stieglitz and Keynes)
• Sport: Aikido, Rugby