Loading...

I have worked in a wide range of industries from which I have learned many tips and tricks which I then adapted and delivered in other sectors. I always learn from my customers, and they also have something to learn from me.

Project goal: Centralise different source systems data into a unique Enterprise DWH. Create Enterprise Reporting System (Industry: Energy Trading)

Environment:

Oracle 11g, HPALM, HPQC, JIRA, Confluence

Tools:

SAP Business Objects Data Services 4.0

SAP Business Objects BI Platform 4.0/ 4.1

Data Sources:

Endur (ETRM System), Oracle

MS SQL Server, Web Services and Files

Business Value:

  • Cost Reduction and Unified Datasource (more than 20 data sources)
  • Regulatory reporting (REMIT, EMIR)

Lessons Learned:

  • Practice on Scrum methodology
  • Big project team,
  • Alignment with upstream and downstream units / simultaneous Go-Live / Plan B and C
  • Change impact analysis
  • Generic Trade Model – Finance, Credit Risk and Operational Risk alignments
  • Bitemporal Historization – Storage vs complexity optimisation
  • Complex currency and price curves conversions / Multiple currencies, units, dates reporting
  • End of day reporting
  • Performance and Storage optimisations
  • Template development
  • Code design and review

Project goal: Standardize Financial Reporting System – Excels to Database (Industry: Financial Services – Debt collection)

Environment:

Microsoft SQL Server 2008 R2

Tools:

SAP Business Objects Edge BI 4.0 SP08 / 4.1

Microsoft SQL Server 2008 R2 (SQL Stored Procedures + SSIS ETL Packages)

Data Sources:

Excel and CSV Files

Business Value:

  • 1 version of the truth replacing many excel files
  • Distribution of Revenue and cost at FTE level

Lessons Learned:

  • Experience in Continuous Agile Delivery (Monday-Friday Sprints)
  • Managing multiple roles & customer expectations in a one-man show scenario

Project goal: BusinessObjects BI System Recovery (Industry: Food Production)

Environment:

SAP Business Objects Edge BI 4.0 SP08, SAP BW 7.0

Windows Server 2003 SP02

Tools:

Notepad++ / Compare

Manually uploaded recovered universes

Data Sources:

DB Backup

IFRS / OFRS

Business Value:

  • Emergency situation fixed
  • Enabled in-time financial closing

Lessons Learned:

  • Deep understanding of back-end system
  • Creative and alternative server recovery methods
  • Ongoing backup is a must have

Project goal: Construction projects’ profitability / GPS Reports and Dashboards for construction machinery (Industry: Construction)

Environment:

SUSE Linux

Microsoft SQL Server 2008 R2

Tools:

SAP Business Objects Edge BI 4.0 SP08

Data Sources:

SAP ERP ECC 6.0 (FI, PS, Z Tables)

Custom GPS Software

Business Value:

  • Reduce construction site material losses
  • Get profitability for every 100m of road built

Lesson Learned:

  • Dig out SAP data model

Project goal: Upgrade from Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0 (Industry: Beverage distribution)

Environment:

SAP Business Objects Edge BI 3.1

SAP Business Objects Edge BI 4.0 SP07

Tools:

NA

Data Sources:

SAP BW 7.3

Business Value:

  • Faster reporting
  • Additional functionalities

Lessons Learned:

  • Design, plan the upgrade and prepare for Plan B
  • With every update & new features, comes deprecating old ones (e.g. Explorer 4.0 does not support OLAP Universes)
  • Clear separation between official supported reports and user ad hoc “drafts”.

Project goal: Integrate Custom application data into the DWH (Industry: Logistics Parcel Delivery)

Environment:

Custom “CARGO” Logistic Application, SAP BW 7.3

Tools:

SAP Business Objects Edge BI 4.0

Microsoft SQL Server Integration Services

Data Sources:

Custom application

Microsoft SQL Server 2008 R2

Business Value:

  • Acces to historical data
  • Easy access to multi-dimensional reporting (slice and dice)

Lessons Learned:

  • Custom application, custom problem, custom solution
  • In-depth understanding of the business and the custom app data model ( IT system should not drive the business process)

Project goal: Profitability model 2.0 / Decommissioning of source systems / Change of targets (Industry: Logistics Parcel Delivery)

Environment:

SAP BW 7.3

Tools:

SAP Business Objects Edge BI 4.0 SP06

Data Sources:

Microsoft SQL Server 2008 R2 MSAS

SAP ERP ECC 6.0, Wizcount

Business Value:

  • More accurate Profitability model 2.0 adapted to changing business
  • Faster end-of-month reporting (a few hours vs 3 days)
  • Streamlined Reporting architecture

Lessons Learned:

  • Eat the big elephant one piece at a time – 3 projects in 1 (1. Reconfigure Business data derivation rules + 2. Change of sources from Wizcount accounting to SAP ERP ECC 6.0 + 3. Change the destination from MSAS Cubes to BW 7.3 Cubes)
  • Streamline Go-live to have a minimal impact on the business users, dress rehearsal

Project goal: Speed up reporting on the new solution (Industry: Lotteries)

Environment:

Microsoft SQL Server 2008 R2

Microsoft Analysis Services 2008 R2

Tools:

SAP BusinessObjects Edge BI 4.0 SP06

Data Sources:

Microsoft SQL Server 2008 R2

Text Files

Business Value:

  • High speed and high quality due to training and mentoring

Lessons Learned:

  • Smaller projects could be more intensive
  • Post-training support and follow-up are critical for a successful implementation

Project goal: Upgrade from Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0 (Industry: Logistics Parcel Delivery)

Environment:

Windows Server 2008 to 2008 R2

SQL Server 2008 to 2008 R2

Tools:

Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0

Data Sources:

NA

Business Value:

  • Excellent user adoption for the new version

Lessons Learned:

  • Planning and Risk assessment
  • HERMES naming errors QaaWS queries that could not be upgraded

Project goal: Demo System integrating BOBJ with BPC (Industry: IT Business Consulting)

Environment:

Sandbox system

Tools:

SAP BPC 10.0 MS

SAP Business Objects Edge BI 4.0

Data Sources:

Excel and CSV Files

Microsoft SQL Server 2008 R2

Business Value:

  • More projects sold through appealing demos using industry-tailored data

Lessons Learned:

  • Generating mock-up data with business meaning among integrated systems
  • Installing predefined SAP Demos and RDS (Rapid Deployment Solutions)
Project goals: POC Implementation of the public budgeting process (Industry: Public Sector)

POC Roll-out of the public budgeting process (Industry: Public Sector)

Environment:

HP Datacenter

Tools:

SAP BPC 10.0 MS

SAP Business Objects Edge BI 4.0

Data Sources:

Excel files

Manual input

Business Value:

  • Ease of use and transparency & dexterity on Roll Out of public sector budgeting process
  • Insight into integrated planning solution

Lessons Learned:

  • Knowledge of public budgeting process, its compliance rules and paperwork
  • A successful POC does not necessarily mean a follow-up project

Project goal: Simplified reporting of Balance Sheet, P&L by route, Route Profitability (Industry: Budget Airline)

Environment:

MS SQL Server 2008

Tools:

SAP BPC 7.5 MS, SAP Business Objects Edge BI 3.1,  SAP Business Objects Data Services 3.1

Data Sources:

Excel, Manual Input

Navitaire, Microsoft Navision

Business Value:

  • One-click overview of Management Dashboards
  • Increased business agility

Lessons Learned:

  • Even integrated solutions (BPC and BOBJ) require custom development
  • Insights from the multiple sources of income and costs of an Airline company

Project goal: Integrating business view (Industry: Holding – Construction/ Airline/ Agriculture/ HORECA)

Environment:

MS SQL Server 2008

Oracle

Tools:

SAP BPC 7.5 MS

SAP Business Objects Edge BI 3.1

Data Sources:

Excel, Manual Input

Business Value:

  • Group CashFlow and Group P&L
  • Joint budgeting and reporting formats
  • Intercompany “clean-up”.

Lessons Learned:

  • Efficiently aligning different shareholders requires several feedback meetings and rather soft skills than technical

Project goal: Implementation of the Public-Sector Budgeting process (Industry: Telecommunication/Public-Sector)

Environment:

Microsoft SQL Server 2008

Tools:

SAP BPC 7.5 MS

Data Sources:

Excel 2003 & 2007, Manual input

Business Value:

  • Agile budgeting process (~ 2 days/version vs ~3 weeks)
  • Workload distribution
  • Centralised, versioned and secured access to data

Lessons Learned:

  • Expectation management could lead a project to either succeed or fail
  • All solutions have to be tested on all users’ configurations

Project goal: Analyze net profitability by customer, service, product and branch (Industry: Parcel Delivery)

Environment:

Custom “CARGO” application

SQL Server 2008 (SSIS, SSAS)

Tools:

SAP Business Objects Edge BI 3.1

Xcelsius 2008

Data Sources:

SQL Server 2008, Excel and CSV files

Accounting solution

Business Value:

  • Management dashboards: Customer Acquisition, Customer Removal, Discount Tool
  • Profitability reports by more than 10 dimensions

Lessons Learned:

  • Knowledge of the sources of company costs and expertise in cost distribution
  • Agile experience (1-month delivery cycles, reviews by board of directors)

Project goal: Near Real-time P&L (Industry: Telecom Site Construction)

Environment:

SAP ERP

Tools:

SAP Business Objects Edge BI 3.1

Xcelsius 2008, Crystal Reports 2008

Data Sources:

SAP ERP (CJI3/GLPCA)

Business Value:

  • Visibility of project-level net profitability
  • Competitive advantage in auctions

Lessons Learned:

  • RAW level security
  • Delivering results on short notice and at first interaction with tools