Sap Hana Business Intelligence

*

Roberto Pablo Alcántara Ramírez

Mobile: +831-***-****

Email: ************.*********@*****.***

Professional Summary

Specialist with over 26 years of experience in SAP HANA, BusinessObjects, and DataServices. Proven track record in developing data models, leading BI projects, and implementing ETL solutions to optimize business processes. Expertise in handling data migrations with advanced knowledge in SQL, Python, and RDBMS systems. SAP-BODI certified professional with experience across multiple industries, including finance, telecommunications, and retail. Technical Skills

Business Intelligence Tools: SAP HANA, SAP BusinessObjects, BODS, WebIntelligence, Lumira, Tableau

RDBMS: Oracle, MS SQL Server, Teradata, MySQL, DB2

Programming & Scripting: SQL, Shell Scripts, Python (Basics), R, JavaScript, JAVA

Big Data Technologies: HDFS, Spark, Kafka, Elasticsearch, JSON

Operating Systems: Solaris, Linux, AIX, Windows

Professional Experience

TCS – SAP HANA Developer & Business Analyst

May 2023 – Present

Actuarial Data Store: Project: design and develop the Employees Retirement Funds data model in HANA. This model became necessary to merge the systems from Empower and Prudential Financial (acquired 2022) business data.

Map business process from Actuarial business process to SAP Standard HANA datastore.

Understand business needs and then map and model to SAP on ETL SDI, BODS and A40. TCS – SAP BO Consultor, Walgreens Boot Alliance

Mar 2020 – Apr 2023

Data Analytics Delivery and Monitoring of ETL process.

Delivered seamless execution of SAP BO 4.2 reports, resolving pharmacy-related data issues, and improved reporting efficiency by 20%.

Monitoring and troubleshooting of ETL jobs using Teradata SQL and Unix, minimizing downtime in critical processes.

PRAITS – Data Modeler and Developer with SAP HANA BO DS Oct 2018 – Dec 2019

Development of SAP BO 4.2 Universes and Web Intelligence reports, enhancing data accessibility for end-users.

Created interactive dashboards of Student Satisfaction (Happy faces metering) with Oracle 12 and HANA 12 as data sources, improving decision-making capabilities for management. KIO Networks – SAP HANA / BIG DATA Consultant

Feb 2015 – Jul 2018

2

RENAPO Project: ANALYTICAL CURP DataMart were migrated from Oracle to HANA. CURP (Unique Personal ID) and Registro Civil (Civil Registry, Birth Certificates) modeled as BIG DATA with SAP BODS 4.2 / SAP HANA 9 and visualized with BO 4.2

SORIANA Basket Project: Data preparation with BODS to run Market Basket Analysis and Sales Forecast (algorithm a priori & forecast in R-HANA). Visualization of insights for sales strategies with SAP Explorer/Mobile 4.1 using HANA 8 in order increase sales using items associations with tickets gotten from SAP MM.

TELEFONICA MÉXICO: Migration to BO 4.1 from BOE XI R2 of 750 Webinteligence & BO Desktop reports & corresponding universes. Install & Config. of SAP BO with Weblogic 11 and setup of Win AD Security. Interprotección / Grupo CP – SAP BO & Warehouse Developer Nov 2013 – Feb 2015

Specified operational and strategic KPIs for insurance brokerage, leading to improved data-driven decision-making.

Core System Universe maintenance of KPI’s metrics and dimensions.

Developed ETL processes for a data mart, ensuring accurate and timely data for reporting purposes. INXSIDE – Project Manager / Trainer / Architect SAP BO DS Oct 2009 – Nov 2013

BANBAJIO Bank Project Data Governance: Led the development of a Data Mart for Governance and dashboards for delivery and sales paths, enhancing operational efficiency. Managed the migration of BO XI Reports for Data Governance, ensuring data accuracy and compliance with business standards.

IXE Banco, Project Cleanse of Unique Customer DataMart: Data cleanse of personal information of customers using data quality principles.

Grupo Nacional Provincial: Developed regulatory reports for the National Banking and Securities Commission using SAS.

TELCEL: Conducted a proof of concept for massive data loads, improving performance metrics against shell scripts. Education

Bachelor’s Degree in Electronics Engineering

Universidad Autónoma Metropolitana, Azcapotzalco

1991 - 1996

Certifications & Training

SAP Certified Application - BusinessObjects Data Integrator XI R2

Kimball University Training for Data warehouse Lifecycle and modeling.

PMP Certified by PMI – Project Management Institute

Applied Analytics Using SAS Enterprise Miner – SAS Institute Mexico

SAP HANA Implementation & Data Modeling – SAP Mexico Languages

English: Good

Spanish: Fluent

French: Basic

Contact this candidate