|
Job Achievements
Current position: Business Intelligence Analyst
As Microstrategy Developer I am both responsible for design, architect and report development as well as requirements gathering and definition with the business end users.
2008
Customer Online Reporting Dashboard
Build a part and took over the support and development for our new customer online reporting extranet portal.
Microstrategy Toolset: Dynamic Flash Dashboard, SDK and Netezza Data Warehouse Appliance
Global Strategic KPI Reporting Dashboard
Supported and supplied KPI information/data for a Global Strategic KPI Dashboard for our global CEO and accounting team to support and measure the results of the newly launched strategic KPI initiatives.
Microstrategy Toolset: Dashboarding, Oraloader for csv file data loads.
Vendor Metrics Reporting Dashboard
Building a flash based Vendor KPI Scorecard similar to the Customer Online Reporting project, with Extranet access for our Vendors.
Microstrategy Toolset: Dynamic Flash Dashboarding, Datamart, Oraloader and Netezza Data Warehouse Appliance.
Promotion and Trainings Video’s
For our National Sales Meeting I build several promotional video’s of the Customer Online Ordering Tool and the Sales Rep Dashboard which where launched during this big convention.
Toolset: Camtasia Studio 5.0, Powerpoint, Snagit 8.0, IE 7.0 and Microstrategy Web
2007
Unshipped Orders Reporting
This project consisted of developing complex SQL logic from various data points to calculate a more accurate Estimated Ship Date for unshipped order lines to better inform our internal Sales Support Team as well as our Customers.
Microstrategy Tools: Project architecture design and implementation of Logical tables, Desktop report and dashboard development, TOAD oracle SQL.
Various Operations (Logistics, Transportation, Purchasing) Reports and Dashboards
- Cycle Count / Inventory Management Reporting
- Paper Proof of Delivery scan performance reporting
- Wholesale and Vendor Purchase Reporting
- Various Data Analysis and Cleansing Projects
2006
- Global Account Reporting for top 15 global customers.
- IS Release Management Reporting to monitor system release quality
- Data Warehouse Access and Performance Management Reporting
- Project Management of two projects within Data Warehouse team. One for new data sourcing and reporting project from our E-Business system and one project to migrate to Oracle 10g and 3 server node RAC cluster.
Project Manager Achievements
- Implemented European Enterprise wide Data warehouse and web based Reporting system for the Merchandising department within the Office Products Division. Lead project team of 4 people and 2 external consultants of BI vendor to implement system on time and within budget. This was the first European Data Warehouse connecting data from 7 different ERP systems in 9 subsequent countries into one central database for reporting and analysis purpose.
Function: Project Manager Data Warehouse / Business Intelligence
|
| Company |
: Corporate Express Europe |
Budget |
: 500.000 Euro |
| Year |
: Oct.2004 – Dec. 2005 |
Direct Reports |
: 4 |
| Countries involved |
: 9 Countries / 7 ERP systems |
Estimated Savings |
: 1 Million Euro p/y |
- Defined a new concept, workflow and procedures and managed a 2 million
Euro project for the implementation of a web-enabled Product Data Management application and Image Media Asset Management application within Europe. Decreasing product data maintenance costs and efforts within total organization and increasing quality of electronic and paper catalogue productions.
Function: IT – Project Manager / Business Analyst
|
| Company |
: Corporate Express Europe |
Budget |
: 2 Million Euro |
| Year |
: Oct.2002 – Oct. 2004 |
Direct Reports |
: 4 |
| Countries involved |
: 3 Countries and HQ |
Estimated Savings |
: 30 FTE |
- Within one year timeframe almost solely responsible for the implementation of the 1 st European E-Commerce Internet ordering system within 5 countries in Europe. Decreasing internal sales order-entry staff
with 25% in the 1st year. Function: E-Business Consultant
|
| Company |
: Corporate Express Europe |
Budget |
: 500.000 Euro |
| Year |
: 2000 – 2002 |
Direct Reports |
: 1 |
| Countries involved |
: 5 Countries / 5 ERP systems |
Estimated Savings |
: 25% Order entry staff |
- Managed the automation of Paper Catalogue DTP productions in Europe by implementing a standard software product maintenance package and standard workflows within all countries. System also supported delivery of electronic product catalogue for E-Commerce application.
Function: E-Business Consultant
|
| Company |
: Corporate Express Europe |
Budget |
: 500.000 Euro |
| Year |
: 1999 -2002 |
Direct Reports |
: 1 |
| Countries involved |
: 7 Countries / 7 ERP systems |
Estimated Savings |
: 30% on production costs |
- Managed a team of 8 people to migrate to a new central ERP system within a 200 million Euro, large Office Products company in the NetherlandsFunction: Project Manager – Coordinator
|
| Company |
: Ahrend Office Products |
Budget |
: 5 Million Euro |
| Year |
: 1998 -1999 |
Direct Reports |
: 5 |
| Countries involved |
: 1 Country / 1 ERP system |
Estimated Savings |
: |
- Implemented new central ERP system and streamlined business processes in 11 Repro Graphic shops.
Function: Project Consultant Automation
|
| Company |
: Ahrend Repro |
Budget |
: 1 Million Euro |
| Year |
: 1996 -1997 |
Direct Reports |
: 1 |
| Countries involved |
: 1 Country /11 shops |
Estimated Savings |
: realtime MIS |
|
