Roberto Ortiz-Navarro, Senior SAP BW / BI / HANA Consultant

Roberto Ortiz-Navarro

Senior SAP BW / BI / HANA Consultant

Petroleum Development Oman (Contractor)

Location
Oman - Muscat
Education
Bachelor's degree, Computer Science
Experience
16 years, 11 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 11 Months

Senior SAP BW / BI / HANA Consultant at Petroleum Development Oman (Contractor)
  • Oman - Muscat
  • My current job since July 2019

SAP HANA & PowerBI; Development of complete data models in BW and HANA for the financial area, Including custom data sources, ADSO, Composite Providers, Open ODS Views, HANA Calculation Views, table functions, and SQL coding. Cross-tenant dataflows and security configuration. PowerBI support for validating financial data. Over 3 years of experience supporting the financial area.

SAP HANA & Lumira; Development of solutions in a SAP SSM project and mixed scenario. Conducted object modeling in BW 7.5 and HANA, ABAP routines, custom extractors, adsos, composite providers, queries, and further development of dashboard components in SAP Lumira. Successfully managed project cutover in SAP ChaRM and provided ongoing support. Played a pivotal role in training inexperienced national consultants to enhance their proficiency.

SAP BW/BI/HANA Team Leader, Analytics Manager at Seidor Consulting
  • Spain - Madrid
  • March 2017 to January 2019

Clients: Vitaldent, Berge, Varma, Consum

Contributed to the development of the sap bw team in Madrid, managing resources and supporting clients. Achieved the objective of growth of the department in terms of resources, volume, and customer satisfaction. In addition, I have also collaborated in the development of projects in all phases.

SAP BW/BI/HANA Senior Consultant, Project Manager at SAPIMSA Consulting
  • Spain - Madrid
  • September 2009 to February 2017

Clients: REPSOL (oil & gas), Navantia (military shipbuilding company)

SAP BI Project Management; Responsibilities have included tasks such as planning, scheduling, project coordination, and communication management for Business Intelligence projects, ensuring successful execution and customer satisfaction. Managed resources and monitored project progress.

SAP Business Intelligence; Development of new projects, support, and training for end-users. Technical tasks have covered BW modeling, data extraction from purchasing and financial areas, ABAP programming and reporting in Bex & BusinessObjects Web Intelligence, Dashboards, Analysis For Office, Design Studio, Lumira.

SAP HANA; Migration project for a pharmaceutical distribution company (BW on HANA), BW
modeling, and native HANA modeling. ABAP & SQL programming. Data migration with SBO Data
Services & SLT from SAP and Non-SAP systems. Corporate reporting using several BO tools (Web
Intelligence, Crystal Reports, Design Studio, Analysis For Office)

SAP Design Studio & Lumira; Advanced reporting on top of non-SAP systems (relational universes), Javascript programming, and CSS3. Universes (IDT) and jobs (Data Services) optimization.

SAP GRC; Prototype for Access Control, central management of users, profiles, and authorizations.

SAP BW/4HANA & HANA Predictive Analytics; prototyping for internal workshops.

May/2014 - Feb/2017
Business Development; Other responsibilities were coordinating the company's international expansion in the MENA region, managing the work team, relations with partners, and performing pre-sales tasks in several countries (KSA, UAE, Algeria, Morocco)

SAP BW / BI Consultant at EoZen (SQLI Group)
  • Netherlands
  • November 2008 to September 2009

Clients: Schering-Plough (pharmaceutical), NXP (semiconductors)

SAP Business Intelligence & Business Objects consultant. Involved in the teaching of Business Warehouse modeling and reporting for new consultants. Research and solutions development in the new Business Objects tools and Business Planning and Consolidation (SAP BPC - Excel) area. Internal presentations for the management team and demos in customer workshops. Technical proposals for potential customers. BI modeling, data extraction, and reporting for customers.

SAP BW / BI Consultant at SAPIMSA Consulting
  • Spain - Madrid
  • September 2007 to July 2008

Client: Repsol (oil & gas)

SAP Business Intelligence & Business Warehouse consultant. Full life cycle project development, implementing ad-hoc solutions for the financial area. Analysis of customer requirements, backend implementation (modelling, data extraction, programming), business reporting, test and go live.

SAP Business Intelligence & Integrated Planning Consultant at Stratesys Consulting
  • Spain
  • September 2006 to July 2007

Client: Landata (Amper Group, electronics)

SAP Business Warehouse; developing technical solutions for several customers in 7.x/3.x versions. Prototyping activities in SAP Strategic Enterprise Management CPM and developments in Integrated Planning. Analysis, technical design, and developments in the module SEM-CPM (Management Cockpit and Balanced Scorecard), on top of BW corporate data.

SEM-IP & BW; full life cycle projects focused on Financial and Purchasing areas; BI 7.0 implementation (Modelling & Reporting) - FOX functions and IP filters implementation. Visual Composer, BEx Analyzer, and Web Application Designer as the main reporting tools. Other customers required a support role in a BW 3.5 environment.

Education

Bachelor's degree, Computer Science
  • at Polytechnic University of Valencia
  • November 2003

Technical Engineering in Management of Information Systems.

Specialties & Skills

Business Objects
SAP ABAP
SAP BI/BW
SAP ABAP
SAP Business Objects / Lumira
SQL Queries
SAP Analytics Cloud
SAP HANA
Microsoft PowerBI

Languages

Spanish
Expert
English
Expert
French
Beginner
Arabic
Beginner

Training and Certifications

SAP BusinessObjects Design Studio / Lumira (Training)
Training Institute:
SAP
Date Attended:
October 2014
Duration:
24 hours
SAP Certified Application Associate - SAP HANA (Certificate)
Date Attended:
February 2013
Valid Until:
January 2020
Project Management Professional PMP (Certificate)
Date Attended:
November 2016
Scrum Master Certified (SMC) (Certificate)
Date Attended:
April 2016
SAP NW2004s, Business Intelligence 7.0 & Strategic Enterprise Management (Certificate)
Date Attended:
May 2008
Valid Until:
January 2020
SAP BusinessObjects Web Intelligence 4.0 - C_BOWI_40 (Certificate)
Date Attended:
October 2013
Valid Until:
January 2020
SAP GRC Access Control 10.0 - C_GRCAC_10 (Certificate)
Date Attended:
February 2014
Valid Until:
January 2020
SAP Certified Application Professional - Modeling and Data Management with SAP BW 7.3 & BI 4.0 (Certificate)
Date Attended:
March 2016
SAP Lumira Hands On (Training)
Training Institute:
SAP
Date Attended:
May 2015
Duration:
16 hours
SAP BusinessObjects Data Services 4.0 (Training)
Training Institute:
SAP
Date Attended:
February 2013
Duration:
40 hours
SAP Predictive Analytics (Training)
Training Institute:
SAP
Date Attended:
September 2015
Duration:
16 hours
ITIL Foundation Level v3 – ITILF (Certificate)
Date Attended:
July 2013
Valid Until:
January 9999