logo

Select Sidearea

Populate the sidearea with useful widgets. It’s simple to add images, categories, latest post, social media icon links, tag clouds, and more.

miguel@mruizsolutions.com
+49 1575 1808 626
 

My Projects

These are some projects I worked on

Projects (and their details)

Below you can see the projects I was part of and clicking on “+” you will see a more detailed description

Project “Adjustments in the Planning and Forecasting set up with SAP BPC 10.1 Embedded” at an international engineering group
Project
  • 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
Project “Adj. in the Planning and Forecasting set up with SAP BPC 11.0 (and SAP BW/4HANA)” at an international building materials group
Project
  • SAP BPC 11.0
  • 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
Project “Adjustments in the Planning and Forecasting set up with SAP BPC 10.1 Embedded” at an international manufacturing group
Project
  • 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
Project “Adjustments in the Consolidation set up with SAP BPC 10.1 Embedded” at an international manufacturing group
Project
  • 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
Presales tasks
Sales
  • Preparation of offers
  • Presentation of offers at the customer side
Internal Project ``SAP BPC Demo cases``
Project
  • 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
Project ``Consolidation with SAP BPC 10.1 Standard`` at an international chemical company
Project
  • Content and technical project management
  • Correcting and optimizing existing closing processes
Project ``Consolidation with SAP BPC 10.1 Embedded`` at an international wood-based materials group
Project
  • Analyse, Design und Implementierung der Konsolidierung
  • 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
Project ``Consolidation with SAP BPC 10.1 Standard`` at an international chemical company
Project
  • Correct and optimize existing closing processes
Project ``Migration to SAP BPC`` at an international energy company
Project
  • Migration of parts of the management consolidation from SAP SEM / BCS to SAP BPC
Project ``Financial Consolidation and Budgeting with SAP BPC`` at a hotel chain
Project
  • 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
Project ``Financial Consolidation and Budgeting with SAP BPC NW 10.0`` at a City Council
Project
  • Content and technical project management
  • Specifications for the technical implementation in the areas of data transfer
  • Checks and adjustments
  • Harmonization of the budget process
Project ``Legal and Management Consolidation with SAP BPC NW 10.0`` at an international trading group
Project
  • 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
Project ``Design and implementation of budgeting and reporting with SAP BPC NW`` at an international wine and spirits company
Project
  • 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
Project ``Further development of SAP BPC`` at an internationally operating telephone provider
Project
  • 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
Project ``Simulation of financial data with SAP BPC`` at a large manufacturer of packaging material
Project
  • Consultant, realization of a simulation function
  • Among others, definition of consolidation rules, design of reports and input forms, data transfer process, inclusion of comments