Skip to content

Mario Villafaina – SAP BI Consultant

For more than 13 years I have been designing, migrating and optimizing SAP data platforms: BW/4HANA, BW-IP, Datasphere and SAP Analytics Cloud. I currently work for Meliá Hotels International and share what I learn on the blog.

Let's talkRead the blog
years in SAP BI
13+
clients and projects
8
years at Meliá
8+
SAP certifications
2

About me

I consider myself ambitious, consistent, honest and responsible, with a strong ability to learn and full commitment to my work.

I've worked with consulting firms such as Deloitte, Indra and Ayesa on projects in logistics, finance, healthcare, energy and hospitality. Since 2017 I've been part of Meliá's BI team: modeling, planning, authorizations, performance and the migration to BW/4HANA.

My current focus: BW/4HANA, SAP Datasphere and SAP Business Data Cloud, and how to make them coexist without breaking anything along the way.

SAP stack

Data Warehousing

  • SAP BW/4HANA
  • SAP BW 7.x
  • BW on HANA
  • SAP Datasphere
  • SAP Business Data Cloud

Planning

  • BW-IP
  • Planning Functions
  • Planning Sequences

Reporting & Analytics

  • SAP Analytics Cloud
  • Analysis for Office
  • BEx

Development & Integration

  • ABAP
  • CDS Views
  • SAP Data Services
  • SQL / SQLScript
  • Process Chains

Experience

  1. Meliá Hotels International · IBSAP

    SAP BI Consultant

    Mallorca

    Support and continuous improvements for one of the largest hotel groups in the world on SAP BW/4HANA 2023, BW-IP, SAP Datasphere and SAP Analytics Cloud. Migration from BW 7.5 to BW/4HANA together with SAP, and planning of the evolution towards SAP Business Data Cloud.

    • BW Modeling Tools
    • SAP Datasphere
    • SAP Analytics Cloud
    • Analysis for Office
    • BW 7.5 → BW/4HANA migration
    • Planning Functions & Sequences
    • Aggregation Levels & Filters
    • Roles & authorizations
    • Process Chains
    • Analysis Process Designer
    • ABAP
    • Performance tuning

  2. Cinfa · Indra

    SAP BW Consultant

    Madrid

    BW on HANA project for a pharmaceutical company: creation and enhancement of LO extractors, report design in Analysis for Office and ABAP development when needed. Data model optimization and support for the main logistics transactions in the ERP.

    • BW on HANA
    • LO extractors
    • Analysis for Office
    • ABAP
    • Data modeling
    • Performance tuning

  3. Grupo Quirónsalud · Indra

    SAP BusinessObjects Consultant

    Madrid

    Development and support for Spain's leading hospital group, working with the BusinessObjects suite from report design to go-live.

    • BO Design Studio
    • BO Web Intelligence
    • SAP Lumira
    • Universes
    • Troubleshooting
    • Performance tuning

  4. Terumo · Deloitte

    SAP BPC Consultant

    Madrid

    BPC (NetWeaver) support: small developments of script logics and BAdIs, plus maintenance of dimensions, reports and BPFs.

    • Script Logics
    • BAdIs
    • Dimensions
    • EPM Add-in
    • BPFs
    • Performance

  5. Iberdrola · Deloitte

    SAP BW Consultant

    Bilbao

    Prototype on the PPM module: from activating standard Business Content to reporting in BEx Analyzer.

    • Business Content
    • Data modeling
    • Process Chains
    • BEx Query Designer
    • BEx Analyzer

  6. Juver · Deloitte

    SAP BW Consultant

    Madrid

    Incident resolution and performance tuning of the SAP BW system of an international company, fixing and optimizing ABAP code.

    • Data modeling
    • ABAP
    • Process Chains
    • Performance tuning

  7. Adveo · Deloitte

    SAP BW / BO Consultant

    Madrid

    Development and support for an international leader in office supplies: LO extractors, BusinessObjects reporting and ABAP. Data model optimization and support for logistics transactions in R/3.

    • BEx Query Designer
    • BO Web Intelligence
    • BO Data Services
    • Roles & authorizations
    • Analysis Process Designer
    • Process Chains
    • Data validation

  8. Ayesa · Internal systems

    SAP BW Consultant

    Seville

    Support of the company's own system on the PS module: small developments, troubleshooting, data model optimization and support for the main PS transactions in R/3.

    • BEx Query Designer
    • BEx Broadcaster
    • Analysis Process Designer
    • Roles & authorizations
    • User management
    • Documentation

Education

  1. Technical Engineering in Computer Science

    Universidad de Sevilla

    Seville

    From 2006 to 2011

  2. Master in SAP ERP

    Universidad de Sevilla

    Seville

    From 2011 to 2012

  3. Master in Mobile Development

    Universidad Alfonso X el Sabio

    Madrid

    From 2012 to 2013

Certifications

  • C_DS_42Data Integration with SAP Data Services 4.2
  • C_TFIN52_66Financial Accounting with SAP ERP 6.0

Courses

  • DBW462Data Warehousing with SAP BW/4HANA - Delta from SAP BW 7.5 classic to SAP BW/4HANA
  • S4H400SAP S/4HANA Analytics: Overview
  • S4H410SAP S/4HANA Analytics: Modeling CDS Views

Skills

  • SAP
  • ABAP
  • HTML / CSS
  • Java
  • Office
  • Android
  • iOS

Languages

  • Spanish
  • English

SAP Tips

See all articles

Have an SAP BI project?

BW/4HANA implementations, enhancements, Datasphere adoption, planning with BW-IP or SAC, performance audits… Tell me what you need.

Email me LinkedIn