Dr. Florian Birkenfeld
Business intelligence expert

»I will solve your TM1 problem, no matter how big or small it may be.«

About myself

I will help with the architecture of your BI-landscape and with the design of your planning or reporting solution. I will create and improve your TM1-model, I will enhance your SQL-solution and your ETL-architecture and I can serve as your sparring partner.

First as an employed consultant and later on as a freelancer, I have more than ten years of professional experience.

As long as the project language is English, French or German, I will do projects everywhere in Europe.

Due to good relations with various consultancies, I can also help you when you need a bigger team.

My skill set - planning and reporting
  • IBM Cognos TM1 / IBM Planning Analytics (***)
    design, architecture, turbo integrator, rules, TM1Web, perspectives

  • Infor PM 10 (**)
    pushrules, rules, reports

  • MS-SQL-Server (**)
    views, stored procedures

My skill set - ETL
  • Turbo Integrator (***)
    data loads, data transformation, individual programming

  • Cubeware Importer (***)
    SAP R/3 extracts, mappings, scripts

  • Microsoft SSIS (**)

  • informatica Power-Center (*)
    mappings and workflows

* basic knowledge, ** advanced knowledge, *** expert

Clients' opinions

"Very experienced within the IBM TM1. Main contributor to the success. Leveraged on his broad experience. Highly reliable, focused and very senior."
Dr. Peter Landgraf, Co-Head CIB Planning & Control, HypoVereinsbank - Member of UniCredit

"Mr. Birkenfeld highly professional developer. He always showed great commitment and understanding of the tools and processes."
Wolfgang Steiner, Associate Director, UBS

Certificates, badges etc

Diploma Français B2+
Diploma Français B2+
Diploma Français B2
Diploma Français B2
Project experience (selection)
  • Automotive (hardware)
    Support of the sales planning, enhancement to contribution margin planning

  • Automotive (IT)
    Design and implementation of a cost controlling application

  • Bank
    Design, implementation and support of a solution for external and internal risk reporting
    later migration of the solution from Windows to Linux
    replacement of the TM1 planning manager by individual programming

  • Bank
    Review and completion of the loan and deposit planning tool, addition of a non-commercial-module
    migration to planning analytics

  • Construction chemistry
    Design of an integrated financial planning solution (from sales planning to balance sheet) independent of technology

  • Chemistry and pharmaceutical
    Design and implementation of sales planning
    development and realization of detailed spreading/splashing routines

  • Energy service
    Design and implementation of a new planning logic from volume effects to balance sheet and cashflow statement

  • Health and social
    Development of an Excel-application for time registraton and holiday planning

  • Retail and tourism
    Operation and enhancement of the integrated financial planning

GULP ID: 180015