Marcus - Architecte COGNOS TM1

Ref : 150516S001
Photo de Marcus, Architecte COGNOS TM1
Compétences
VBA
VISUAL STUDIO
SQL SERVER ANALYSIS SERVICES
SQL SERVER REPORTING SERVICES
COGNOS REPORT STUDIO
WINDOWS SERVER 2008
COGNOS TM1
MICROSOFT BI
Expériences professionnelles
  • Automotive, Munich

    IBM Cognos TM1-Consultation and Development
    Jan 2014 - Jan 2014

    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.

    Tools, Methods : Cognos TM1 10.2: TurboIntegrator, Rules, TM1 Architect, HPQC, Scrum, Excel 2010
  • Industry, Aarburg
    Jan 2014 - Jan 2014

    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.

    Tools, Methods : Cognos TM1 10.2: TurboIntegrator, Rules, TM1Web, Active Forms, MDX, TM1 Architect, SAP-Cenit, Cognos Controller Interface
  • Automotive, Braunschweig IBM Cognos TM1-Consultation and Development
    Jan 2014 - Jan 2014

    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.

    Tools, Methoden : Cognos TM1 10.1: TurboIntegrator, Rules, TM1 Architect, HPQC, Scrum
  • Solution Architect IBM Cognos TM1

    Pharmacy, Basel
    Jan 2012 - Jan 2013

    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.

    Tools, Methods : Cognos TM1 10.1: TurboIntegrator, Rules, TM1Web, TM1 Architect, Cognos Insight, Excel 2010
  • Automotive, Stuttgart IBM Cognos TM1 Consulting
    Jan 2012 - Jan 2012

    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.

    Tools, Methods : Cognos TM1 9.5.2: TurboIntegrator, Rules, TM1Web, TM1 Architect, VBA, TM1-API für VBA, Excel 2003, Excel 2010
  • Industry, Aarburg
    Jan 2012 - aujourd'hui

    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.

    Tools, Methods : Cognos TM1 9.5.2: TurboIntegrator, Rules, TM1Web, TM1 Architect, Excel 2007
  • Automotive, Wörth
    Jan 2011 - Jan 2012

    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.

    Tools, Methods : Cognos TM1 9.5.2: TurboIntegrator, Rules, TM1Web, TM1 Architect, Cognos 8.4 BI, MS Access 2003, MS SQL Server 2008, T-SQL, SSIS 2008, SSAS 2008
  • Telecommunications, Leinfelden-Echterdingen
    Jan 2011 - Jan 2011

    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.

    Tools, Methods : Cognos TM1 9.5.1: TurboIntegrator, Rules, TM1Web, TM1Contributor
  • Automotive, Stuttgart
    Jan 2010 - Jan 2010

    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.

    Tools, Methods : Cognos TM1 9.5.1: TurboIntegrator, Rules, TM1Web, Cognos 8.4 BI
  • Industry, Duisburg
    Jan 2010 - Jan 2010

    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.

    Tools, Methods : Cognos TM1 9.4: TurboIntegrator, Rules, TM1Web, Syskoplan
Études et formations
  • Consultant and Project Manager for Business Intelligence

    2000
  • IBM Certified Advanced Solution Expert - Cognos TM1

  • IBM Certified TM1 Master- Cognos TM1

  • IBM Cognos TM1 Developer

Autres compétences
Data Mining (Fernkurs Universität Lugano-Manno)

Das DV-Management (Unilog Integrata)

Projektplanung und Projektsteuerung in der TLC

Branches
Banking, Automotive, TelCo, Transport and Logistics, Real Estate

Languages
German: Mother Language
English: fluent
French: good

D'autres freelances
Consultant VBA

Ces profils pourraient vous intéresser !
CV Actuaire Consultante transverse
Nabila

Actuaire Consultante transverse

  • PARIS
BUSINESS OBJECTS VBA R PYTHON
Disponible
CV Consultant PMO
Anass

Consultant PMO

  • MÉRIGNAC
EXCEL PACK OFFICE MS PROJECT VBA Microsoft Power BI PYTHON
Disponible
CV Actuaire
Ariel

Actuaire

  • PARIS
EXCEL VBA Alteryx TABLEAU SOFTWARE SAS ENTERPRISE GUIDE
Disponible
CV Actuaire, ASA
Amine

Actuaire, ASA

  • COURBEVOIE
ALM SAS R VBA PROPHET
Disponible
CV Business Analyst
Jad

Business Analyst

  • BAGNOLET
AGILE Finance JIRA SHAREPOINT TEMENOS GLOBUS T24 SQL VBA GOOGLE ANALYTICS Microsoft Power BI MICROSTRATEGY
Disponible
CV Consultant EPM/ TM1/ Planning analytics / Board
Myriam

Consultant EPM/ TM1/ Planning analytics / Board

  • COLOMBES
EPM COGNOS TM1 PACK OFFICE JAVASCRIPT MDX JIRA VBA R SAS
CV Développeur VBA
Patrick

Développeur VBA

  • NICE
EXCEL VBA ACCESS
CV Consultant outils informatiques
Manon

Consultant outils informatiques

  • LORIENT
HUBSPOT EXCEL ZAPIER VBA JAVASCRIPT
CV Consultant gestion _ experte EXCEL
Cyrielle

Consultant gestion _ experte EXCEL

  • LOCMINÉ
EXCEL WORD VBA POWERPOINT
Disponible
CV Actuaire expert
Mohamed Amine

Actuaire expert

  • PARIS
VBA EXCEL WORD IFRS SOLVABILITE II