Marcus - Architecte COGNOS TM1

Automotive, Munich

Project activities : TM1 backend development: Rules, TI processes, test support of end users
Project description : Conception and implementation of a worldwide planning application with IBM Cognos TM1 for Budgeting and Forecast of the whole credit business including a balance and P&L module.

Sales Planning/Reporting IBM Cognos TM1

Project activities : Implemention of a worldwide planning tool for Sales, COGS, Intercompany relations with IBM Cognos TM1; Further enhancement of the existing reporting application for Saleschannel and Servicelevel-Reporting and consolidation of the Reportingapplikation („Continental Reporting“); Education of internal specialists, Back-end, Front-end, Interface programming (SAP CENIT, Cognos Controller), TM1 Software configuration and upgrade.
Project description : Based on an existing reporting application a planning module is developped and continuosly extended. The Reporting is extended as well and freed from old and untransparent modules (e.g. Security; Replacement of long running load processes/Rules). The internal specialists are trained.

Project activities : TM1-Backend-Development: Rules, TI-Processes, delivery of a service- and support concept, Business Test support
Project description : A new worldwide Tool for Planning, Budgeting and Forecast with TM1 and Arcplan is established. The Task is to create a financial amortization calculation for Retail and Leasing products.

Solution Architect IBM Cognos TM1

Project activities : Development of a PoC in the project „Business Plan“ in 2012 and further development in 2013. The planning solution is based on Active Forms and TM1Web. The project methodology is agile development.
Furthermore the work included the setup of a standardized methodology for all TM1 projects in the division and coaching of colleagues.
Project description : A new Business planning tool for the division is developed. An existing Excel solution shall be migrated to TM1. Different affiliates and Business areas contribute to the plan for the years 2014-2018 and until 2032 respectively (project planning). Plan data are input for P&L, Cash Flow, Balance strategic and CAPEX-Projects. Top-down adjustments by the central Finance department on all levels are possible. A workflow module will support the planning process.

Project activities : TM1-Consulting and development with regards to the planning application CHQ_FMP which is used for the internal IT costs and revenue planning. It was a firefighter task to bring the pilot application into production within a short time.
Afterwards a prototype based on Active Forms in the Web was developed as a possible alternative to the application which is difficult to administrate due to the deployment of the API.
Project description : The project CHQ_FMP of the internal IT department is used for the planning of costs and revenues for administrative and development projects for the next two years. It contains the input of target values on different aggregation levels and the comparison with the budget. The GoLive was in November 2012.

Sales Budget Planning with IBM Cognos TM1
Project activities : Conception and development of a webbased planning tool for Sales planning with TM1
Project description : Based on an existing TM1 reporting system a planning module was developed. Several dynamic input sheets were created to capture product sales and quantities.

BI development and administration
Project activities : IBM Cognos TM1 and Microsoft BI-Consulting, Development of the planning application STAIRS for the Financial Target Review of Daimler Trucks including planning of Contribution margin/Capex/CashFlow.
Maintenance and continuous development of the application Code-DB with price and cost information. Maintenance and continuous development of the application Herstellerleasing.
Project description : The project STAIRS ist part of the strategic plan of Daimler Trucks. The contribution margin per subunit is consolidated to EbIT.
The IT-Tool “Herstellerleasing „ displays Leasing- and Buy-Back-business of DAG separated into P&L and balance positions. The tool also serves as a planning instrument, which forecasts existing assets and enables planning of new assets. The application Code-Database is the central database for the documentation of Code costs for price information.

IBM Cognos TM1- maintenance and continuos development of TM1 applications
Project activities : Error elimination and continuos development of the pilot application “BD/IV”. Continuous development of the HR TM1 planning application „Exposé“.
Project description : BD/IV: planning and forecast tool in TM1 for demand coverage of xDSL products. With the help of the application the process of demand planning, technical planning and assignment is supported.
Project description : Exposé: Planning application for the organizational commitment based on factors like duties, organizational entities, products, and geographical and temporal entities.

Redesign TM1 application for Balance Planning, Project BAPS
Project activities : Multidimensional Modelling, Rules calculation, implementation of plausibility checks, Implementation of a security concept, coaching of internal administrators, Requirements engineering.
Project description : Redesign of the central planning application BAPS for the Controlling and operative divisions. The application serves as a step for the company-wide planning and is reported to CFO.

Cognos-TM1 Finanz-Planungssystem
Project activities : Creation of a planning application for Costcenter-, project-, capacity and balance planning as well as reporting. SAP BW interface programming, Calculation of allocations, term of payment, percentage of completion, Cashflow, Internal and external services etc.
Project description : Establishment of a new decentralized planning application for Controlling and operative departments. Automatic import of meta- and transactional data from SAP-BW, Calculation of derived measures with TM1 Rules, Creation of input forms for plan and forecast data.