Miguel Ruiz available

Miguel Ruiz

SAP BPC / BI Expert

available
Profileimage by Miguel Ruiz SAP BPC / BI Experte from Mannheim
  • 68167 Mannheim Freelancer in
  • Graduation: BSc + MSc. Computer Science and Engineering
  • Hourly-/Daily rates: not provided
  • Languages: German (Elementary) | English (Full Professional) | Spanish (Native or Bilingual)
  • Last update: 24.06.2020
KEYWORDS
PROFILE PICTURE
Profileimage by Miguel Ruiz SAP BPC / BI Experte from Mannheim
ATTACHMENTS
CV Miguel Ruiz (English)

You need an account to view this information.

CV Miguel Ruiz (Deutsch)

You need an account to view this information.

SKILLS
SAP BPC / BI Expert and developer of computer applications. Generally interested in computer-related.

C_EPMBPC_10 SAP Certified Application Associate - SAP Business Objects Planning and Consolidation SAP BPC 10.0

C_EPMBPC 75 SAP Certified Application Associate – SAP Business Objects Planning and Consolidation SAP BPC 7.5

Specialties: SAP BPC (Business Planning and Consolidation) - all versions - , Tagetik, BO Planning, VBA, Java, Visual Basic For Applications (VBA), ABAP, Eclipse, HTML, Javascript, MySQL, Oracle, PHP, SQL, XML, ...
PROJECT HISTORY
  • 03/2020 - Present

    • an international engineering group
    • >10.000 employees
    • Industry and mechanical engineering
  • Adjustments in the Planning and Forecasting set up with SAP BPC 10.1 Embedded (SAP BPC Expert)
  • Job description

    SAP BPC 10.1 Embedded
    * Interface with other BW source systems (including Transformations and DTPs)
    * ABAP, VBA and FOX coding
    * Analysis for Office (AfO): Queries, Reports and Input Forms

    Used qualifications

    SAP BO-PC, SAP BI, SAP BI-IP, SAP BW, SAP HANA, VBA (Visual Basic for Applications), ABAP


  • 06/2020 - 06/2020

    • Swiss Krono
    • 5000-10.000 employees
    • Architecture and civil engineering
  • Consolidation with SAP BPC 10.1 Embedded (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 10.1 Embedded
    * SAP Analysis for Office (AfO) for Reporting
    * Analysis, Design and Implementation of Consolidation
    * Among others:
    -> Historical data migration for the Technical First Consolidation
    -> Definition of Master data (including Info Objects for all necessary dimensions, Cubes for Consolidation, Ownership and Rates data and their correspondent Aggregation Levels)
    -> Concept and design of the Consolidation Perimeter by using the Group and Entity dimensions and the Ownership Manager
    -> Concept of the Consolidation itself like IFRS and definition of the correspondent Business Rules for:
    --> Consolidation of Investments
    --> Elimination of Equity Accounts
    --> IC Elimination
    --> Dividends Elimination
    --> Intercompany Profit Elimination on Inventories
    -> Concept of Balance Carry Forward like IFRS and definition of the Business Rule
    -> Concept and definition of some extra Carry Forward Rules
    -> Concept of Currency Conversion with 2 different Group Currencies and definition of the Business Rules (Closing, Average and Historical)
    -> Specific developments to define the Intercompany Profit Elimination on Inventories using Planning Functions (FOX Formulas) to calculate the value of Margin starting from the percentage. And using a Process Chain to run that calculation periodically in order to have available the most current data

    Used qualifications

    SAP BO-PC, SAP BI, SAP BI-IP, SAP BW, VBA (Visual Basic for Applications)


  • 03/2020 - 06/2020

    • an international building materials group
    • >10.000 employees
    • Architecture and civil engineering
  • Adjustments in the Planning and Forecasting set up with SAP BPC 11.0 and SAP BW/4HANA (SAP BPC Experte)
  • Job description

    * SAP BPC 11
    * Interface with other BW source systems (including Transformations and DTPs)
    * ABAP, VBA and FOX coding
    * Analysis for Office (AfO): Queries, Reports and Input Forms
    * BW/4HANA
    * Lumira

    Used qualifications

    SAP BO-PC, SAP BusinessObjects (BO), SAP ABAP (BC-ABA), SAP BI, SAP BI-IP, SAP BW, SAP BW/4HANA, VBA (Visual Basic for Applications), Lumira


  • 09/2019 - 02/2020

    • an international manufacturing group
    • >10.000 employees
    • Automotive and vehicle construction
  • Adjustments in the Planning and Forecasting set up with SAP BPC 10.1 Embedded (SAP BPC Expert)
  • Job description

    * SAP BPC 10.1
    * Interface with other BW source systems (including Transformations and DTPs)
    * ABAP, VBA and FOX coding
    * Analysis for Office (AfO): Queries, Reports and Input Forms

    Used qualifications

    SAP BO-PC, SAP ABAP (BC-ABA), SAP BI-IP, SAP BW, SAP HANA, VBA (Visual Basic for Applications)


  • 06/2019 - 02/2020

    • an international manufacturing group
    • >10.000 employees
    • Automotive and vehicle construction
  • Adjustments in the Consolidation set up with SAP BPC 10.1 Embedded (SAP BPC Expert)
  • Job description

    * SAP BPC 10.1
    * Interface between SAP SEM BCS and SAP BPC 10.1 (including Transformations and DTPs)
    * ABAP, VBA and FOX coding
    * Analysis for Office (AfO): Queries, Reports and Input Forms

    Used qualifications

    SAP BO-PC, SAP ABAP (BC-ABA), SAP BI-IP, SAP BW, SAP HANA, VBA (Visual Basic for Applications)


  • 01/2019 - 05/2019

    • SIR consulting
    • 10-50 employees
    • Internet and Information Technology
  • SAP BPC Demo Cases (SAP BPC Expert and Project leader)
  • Job description

    * Project management
    * Analysis, design and implementation
    * SAP BPC 10.1 Standard:
    -> Reporting Demo
    -> Budgeting Demo
    -> Consolidation Demo
    * SAP BPC 10.1 Embedded
    -> Budgeting Demo
    -> Consolidation Demo
    * SAP BPC 11.0
    -> Budgeting and Consolidation Demo

    Used qualifications

    SAP BO-PC, SAP S/4HANA, Projektleitung / Teamleitung (IT), SAP ABAP (BC-ABA), SAP BI, SAP BI-IP, SAP BW, SAP BW/4HANA, SAP HANA, VBA (Visual Basic for Applications)


  • 03/2018 - 12/2018

    • ASK Chemicals
    • 1000-5000 employees
    • Other
  • Consolidation with SAP BPC 10.1 Standard (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 10.1 Standard
    * SAP Excel EPM Client for Reporting
    * Content and technical project management
    * Correcting and optimizing existing closing processes

    Used qualifications

    SAP BO-PC, SAP ABAP (BC-ABA), VBA (Visual Basic for Applications)


  • 02/2016 - 06/2018

    • E.ON
    • >10.000 employees
    • Energy, water and environment
  • Migration to SAP BPC (SAP BPC Expert and Project leader)
  • Job description

    * Projekt with SAP BPC NW
    * Content and technical project management
    * Migration of parts of the management consolidation from SAP SEM / BCS to SAP BPC
    * Macro programming
    * User Training and Testing
    * Further development of SAP BPC (planning system)
    * Support in BPC during migration BPC / Tagetik

    Used qualifications

    SAP BO-PC, Projektleitung / Teamleitung (IT), SAP ABAP (BC-ABA), SAP BW, VBA (Visual Basic for Applications)


  • 11/2014 - 01/2016

    • Meliá Hotels International
    • >10.000 employees
    • Other
  • Financial Consolidation and Budgeting with SAP BPC (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 10.0 NW
    * SAP Excel EPM Client für Reporting
    * Project management, conception and realization of Consolidation and Budgeting
    * Among others, harmonization of the structures between actual and budget processes, data transfer concept for the actual data, reports for deviation analysis

    Used qualifications

    SAP BO-PC, SAP BW, VBA (Visual Basic for Applications)


  • 07/2013 - 01/2016

    • Barcelona City Council
    • >10.000 employees
    • Public service
  • Financial Consolidation and Budgeting with SAP BPC NW 10.0 (SAP BPC Expert and Project leader)
  • Job description

    * Projekt with SAP BPC 10.0 NW
    * Content and technical project management
    * Specifications for the technical implementation in the areas of data transfer
    * Checks and adjustments
    * Harmonization of the budget process
    * SAP Excel EPM Client für Reporting
    * SAP Quality Awards 2014 ‘Silver’ (SAP Iberia - Spain and Portugal)

    Used qualifications

    SAP BO-PC, Projektleitung / Teamleitung (IT), SAP BW, SAP ABAP (BC-ABA), VBA (Visual Basic for Applications)


  • 06/2013 - 07/2013

    • ONCE
    • >10.000 employees
    • Other
  • Budgeting with SAP BPC (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 7.5 NW
    * Harmonization of the budget process
    * Adaptation of the BPC system for blind users
    * SAP Quality Awards 2013 'Gold' (SAP Iberia - Spain and Portugal)

    Used qualifications

    SAP BO-PC, VBA (Visual Basic for Applications)


  • 07/2012 - 05/2013

    • Abengoa
    • >10.000 employees
    • Energy, water and environment
  • Budgeting with SAP BPC (SAP BPC Expert and Project leader)
  • Job description

    * Projekt with SAP BPC 7.5 NW
    * Content and technical project management
    * Planning and monthly monitoring

    Used qualifications

    SAP BO-PC, Projektleitung / Teamleitung (IT), SAP ABAP (BC-ABA), SAP BW, VBA (Visual Basic for Applications)


  • 01/2011 - 06/2012

    • Fundosa
    • >10.000 employees
    • Other
  • Weiterentwicklung von SAP BPC (SAP BPC Expert and Project leader)
  • Job description

    * Projekt with SAP BPC 7.0 NW
    * Content and technical project management
    * Budgeting and consolidation system
    * SAP BPC support

    Used qualifications

    SAP BO-PC, Projektleitung / Teamleitung (IT), SAP BW, VBA (Visual Basic for Applications)


  • 10/2010 - 04/2011

    • Regional Ministry of Finance
    • >10.000 employees
    • Public service
  • Development of SAP BPC (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 7.5 NW
    * Migration to SAP BPC
    * Planning and planning consolidation
    * SAP Quality Awards 2011 'Silver' - New Business Applications SAP BPC (SAP Iberia - Spain and Portugal)

    Used qualifications

    SAP BO-PC, SAP BusinessObjects (BO), SAP BW, VBA (Visual Basic for Applications)


  • 06/2010 - 10/2010

    • Pernod Ricard
    • >10.000 employees
    • Consumer goods and retail
  • Design and implementation of budgeting and reporting with SAP BPC NW (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 7.0 MS
    * Process and structure definition and implementation
    * Definition of the Business Process Flows
    * Macro programming (VBA)
    * Definition of process chains in SAP BW
    * User Training and Testing

    Used qualifications

    QlikView, SAP BO-PC, VBA (Visual Basic for Applications)


  • 01/2010 - 06/2010

    • Leche Pascual
    • 1000-5000 employees
    • Consumer goods and retail
  • Simulation of financial data with SAP BPC (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 7.0 NW
    * Technical project management
    * Consultant, realization of a simulation function
    * Among others, definition of consolidation rules, design of reports and input forms, data transfer process, inclusion of comments
    * Macro programming
    * Script Logic
    * Definition of process chains in SAP BW
    * User Training and Testing

    Used qualifications

    SAP BO-PC, SAP BW, VBA (Visual Basic for Applications)


  • 06/2009 - 01/2010

    • Azkoyen
    • 500-1000 employees
    • Industry and mechanical engineering
  • Legal and Management Consolidation with SAP BPC NW 7.0 (SAP BPC Expert)
  • Job description

    * Projekt with SAP BPC 7.0 NW
    * SAP RAMP-UP Projekt
    * Definition of dimensions and rules for the part of group consolidation
    * Definition of the final process using Business Process Flows
    * Data transfer from SAP BW
    * Script-Logics coding

    Used qualifications

    SAP BO-PC, SAP ABAP (BC-ABA), SAP BW, VBA (Visual Basic for Applications)


  • 01/2009 - 05/2009

    • Telefonica
    • >10.000 employees
    • Telecommunications
  • Further development of SAP BPC (Consultant)
  • Job description

    * Projekt with SAP BPC 5.0, SAP BPC 5.1 and SAP BPC 7.0
    * Process and structure definition and implementation
    * Definition of the Business Process Flows
    * Macro programming (VBA)
    * Definition of process chains in SAP BW
    * User Training and Testing
    * System analysis of the current design and detection of optimization potentials

    Used qualifications

    SAP BO-PC, VBA (Visual Basic for Applications)


  • 11/2007 - 01/2009

    • Gas Natural Fenosa (now Naturgy)
    • >10.000 employees
    • Energy, water and environment
  • Simulation of financial plan (Consultant)
  • Job description

    * Projekt with Business Objects Planning
    * Development of the financial plan simulator
    * Macro programming
    * User Training and Testing

    Used qualifications

    SAP BO-PC, SAP BusinessObjects (BO), VBA (Visual Basic for Applications)


TIME AND SPATIAL FLEXIBILITY
Mainly remote working.
GET IN TOUCH

Message:

Sender:


exali seal of third party liability for IT representatives (special rate for freelancermap members):

The original exali seal of third party liability for IT representatives ensures that the person or company concerned has concluded an actually valid third party liability for IT representatives. This insurance has been concluded applying a special rate for freelancermap members.

Commencement of insurance:
01.06.2020

End of insurance:
01.06.2021

Show exali-profile »

WEB PRESENCE