Lucas Jose P.

SAP BI/GCP Data Integration Consultant

Confidential company

Aug 2025 - Current (1 year 3 months)

The company operates in the industrial sector Oil & Gas (name confidential due to NDA). The project aimed to validate Google Cloud Cortex Framework as a scalable data integration and analytics solution for SAP Financial Accounting (FI) using SAP SLT and BigQuery. Project Type: Proof of Concept (POC) Implementation.

V

Microsoft Fabric / Power BI / Infor VISUAL Data Integration Consultant

Vantage Medical Group

Jan 2025 - Sep 2025 (9 months)

As a Data Integration & Power BI Consultant, my role involves building an end-to-end reporting solution over Infor VISUAL Manufacturing 9.0.8 using Microsoft Fabric (Lakehouse & Warehouse). I designed and implemented the full data ingestion flow using SQL and Python to unify VISUAL tables (Customer Orders, Shipper, Work Orders, Quotes, Operations, Requirements), created analytical models for Backlog, Past Due, Revenue, Quotes, and Work Orders, and optimized transformations using Lakehouse pipelines. I developed advanced Power Bl reports including YoY Growth, Margin analysis (GM%, CM%, Mark-Up%), OTD, Customer Open Orders, and Program-level Backlog (Morpheus, IKEA, Panels). The work includes SQL semantic modeling, Python-based data merging,

A

SAP Datasphere Consultant

Alpayana

Aug 2024 - Jun 2025 (11 months)

Alpayana is a mining group dedicated to underground mining, primarily polymetallic, producing zinc, lead, copper, and silver. Their three mining units, Americana, Yauliyacu, and Iscaycruz, are located in the highlands of Lima. Project Type: New Implementations. As a SAP Datasphere Consultant specializing in using CDS Views as data sources and ABAP programming, My job involves designing and developing CDS Views to model financial and production data, ensuring optimal performance through annotations and efficient data extraction mechanisms like delta and full extractions; enhancing functionalities with ABAP programming, integrating with other SAP modules and external systems, handling error management, and performing unit testing and validati

SAP BI DataSphere / DWC Support Analyst

alpina

May 2023 - Current (3 years 6 months)

In this proof of concepts is to apply a migration of the SAP SD flow in SAP BW 7.5, together with a migration of a report in Qlike Sence (Financial and SD Report) to SAP SAC and R Language to create a new Graphics, the survey of what is currently built is carried out and migrate to SAP DWC Business warehouse Cloud/ Datasphere, using task replication, Data builder and the Dasboard built in SAP SAC and configuration CPI-DS to send master data from BW to IBP.

SAP BI Support Analyst

Schlumberger

Nov 2020 - May 2024 (3 years 7 months)

Pioneer company in Oil & Gas services worldwide. Project Type: Global Support.

Senior BW/HANA/BO Senior Consultant

EMCALI

Jul 2020 - Current (6 years 4 months)

Public Sector Companies. Project Type: New Phased Deployment. Project focused reporting on SAP BO, 4.1 Web Intelligence with SAP BW On HANA 7.5 source and models in SAP HANA Studio creating View Calculation with SAP FI-GL data source, FI-AA, FM, using SAP SLT to replicate the data from ECC lifting and adjusting the requirements, construction and application of the solution, testing and adjustments EMCALI is a utility company owned by the municipality of Santiago de Cali and is in charge of Sewerage, Aqueduct, Energy and telecommunications.

BW/HANA Senior Consultant

El Palacio de Hierro

Apr 2020 - Current (6 years 7 months)

Project Type: New Phased Deployment. Project focused on creating the store plan in workbook in analysis For Office, creating flows in SAP BW-IP in the SAP CAR (Customer Activitity Repository) vertical in the SAP CAR - Merchandise Planning for Retail (MPR) part, Creating ADSO Flows, SAP HANA (Actual Data Tables), Aggregation Levels, Planning Filters, Planning Functions (Copy from Version to Version, Data Reinitialization, FOX Formulation,

A

BW/HANA Senior Consultant

ADOC Companies

Jan 2020 - Current (6 years 10 months)

Project Type: New Phased Deployment. Project focused on the activation of the SAP CAR (Customer Activitity Repository) vertical in the part of SAP CAR - Merchandise Planning for Retail (MPR) using SAP SLT/PIPO to replicate the data from ECC, And created some Calculation View in SAP HANA Native to additional reports, leader of the merchandise front, performing customer requirements, subsequent creation of the BBP for the implementation focused on performing the activation of the standard part and applied to the ADOC customer, this solution is based on SAP BW-IP to carry out planning at the standard levels, starting from a financial planning and then landed by the merchandiser, using reports such as OTB (Open To Buy), the entire solution supp

S

Senior BI | Ecopetrol (ERM)

Jul 2019 - Current (7 years 4 months)

Project Type: New Phased Deployment. Power BI reporting implementation project using tools such as SAP BW (BI-CONTENT SAP EC), SAP HANA to extract information from SAP EC sources (Environmental Compliance, Vertical intended for environmental legal compliance and creating indicators such as ICLA, LTO and CLA)to create Calculations View in SAP HANA along with activating the external content of Data extraction in SAP BW ON HANA using SAP SLT to replicate the data from ECC the final visualization tool was used POWER BI (R Language to create a new Graphics), in addition to the design and documentation of reports for ECOPETROL in legal and environmental compliance issues.

S

Senior BI | Investments La Paz

Apr 2019 - Current (7 years 7 months)

ILP Tegocigalpa, Honduras (MQA). Project Type: New Phased Deployment. Implementation project for reporting in SAP BO using tools such as SAP HANA Smart Data Integrator, SAP Data Services to extract information from MongoDB and OnBase (Using Python to make the data flow extraction), work modules SAP

BIBO Senior | Grupocnet

Colsubsidio

Dec 2018 - Current (7 years 11 months)

Project Type: PhaseD Improvement/New Implementation. Project focused on improving the flow of loading processes to DWH in SAP Data services to the cloud (Hana Cloud Enterprise), maintenance to THE JOB in SAP DS-DI, Creation of Calculation View in HANA Cloud, improvement in process chains in SAP BW4HANA and using SAP SLT to replicate the data from ECC, applying the LSA++ methodology for for HANA optimization, dashboard construction (SAP Lumira Design and Discovery 2.0 SP00) and Reports in WebIntelligence (BOBI 4.2 SP06), SAP Analysis For Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, Expansion of ERP extractors, In addition to the design and documentation of reports for the Holding Colsubsidio.

E

Senior Role/BIBO Leader | Aval Group

Experis By Manpower Group (IBM)

Oct 2018 - Current (8 years 1 month)

Project Type: PhaseD Improvement/New Implementation. Project for the implementation of PHASE II, creation of reports of the SAP MM (Invoice Verification) and FM (Budget Control) modules at the management level for the Financial Institutions and the AVAL Group applying the LSA++ methodology for optimization For HANA using SAP SLT to replicate the data from ECC (Calculation View, SDI, XSJOB, FlowGraph, Store Procedure), Design Studio and reports in WebIntelligence (BOBI 4.1 SP11), SAP Analysis For Microsoft Excel, SAP BW QUERY BEX connection, Exit ABAP Variable Extensions, ERP Extractor Extension, In addition to the design and documentation of SAP BW reports for entities.

A

Leader BIBO | AVAL GROUP

Adecco (IBM)

Jan 2018 - Current (8 years 10 months)

Project Type: PhaseD Improvement/New Implementation. Project for the implementation of PHASE II, creation of reports of the SAP MM (Invoice Verification) and FM (Budget Control) modules at the management level for the

Consultant Role BI/BW on Hana/BO

Sportline América

Aug 2017 - Current (9 years 3 months)

Project Type: Improvement. InfoCubos/ODS optimization process, performance improvement in response times for querying reports developed in SAP BO with source BW Module MM Inventory (Movements, Revaluations, Stock Initialization), adjustment to strings of Processes and Reporting in WebIntelligence (BOBI 4.1 SP6), SAP Analysis For Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, ERP Extractor Extension, In addition to the design and documentation of reports for the company.

C

Consultant Role BI/BW on Hana/BO/HANA

CMPC Companies

Feb 2017 - Current (9 years 9 months)

Project Type: New Project for BI. Creation of SAP Design Studio (1.4) Mobile/Desktop dashboard, with SAP BW QBEX font, models for CMPC Cellulose, Wood and Forestry, Maintenance (Support) businesses by help desk to reports in WebIntelligence (BOBI 4.1 SP6), SAP Design Studio, SAP Lumira (1.32), SAP Analysis for Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, ERP Extractor Extension, adjustments to process chains that present inconveniences, Modification Creation and adjustments of BEX querys from AODS, SAP BW On HANA Composer Providers and Cubes using SLA++ methodology using SAP SLT to replicate the data from ECC, in addition to the design and documentation of reports for holding KPI indicators.

F

Consultant Role BI/BW On Hana/BO/HANA/Data Services - Data Integrator (Freelance)

Fundación de la mujer – Microcredit Bank

Feb 2017 - Current (9 years 9 months)

Project Type: New Project for BI. Migrate data using SAP BO Data Services (NonSAP to SAP), SAP Dashboard (former Xcelsius), WebIntelligence (BOBI 4.1 SP6), SAP Design Studio, SAP Lumira (1.32), SAP Analysis For Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, ERP Extractor Extension by BADI's, Modification, Creating and adjusting BEX querys from AODS, Composer Providers and CUBEs of SAP BW On HANA using SLA++ methodology, Activating BI CONTENT Optimized for HANA

I

Consultant Role BI/BW on HANA/BO/HANA (Freelance)

IMSA

Nov 2016 - Current (10 years)

(Ingenio Azucarero – Guatemala City, Guatemala) Project Type: New Project for BI. Business Objects, Web Intelligence (BOBI 4.1 SP6), SAP Design Studio, SAP Lumira (1.28), SAP Analysis for Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, Extending ERP Extractors by BADI's, Modification Creation and adjustments of BEX querys from AODS, Composer Providers and CUBEs of SAP BW On HANA using SLA++ methodology and SAP SLT to replicate the data from ECC, Activation of BI CONTENT Optimized for HANA SP09 in 7.5, Activation of IBPF of S4/HANA Simple Finance for center planning benefits and cost centers support and adjust standard WorkBooks. In addition to the design and documentation of reports for KPI, weekly, monthly and

BI/BW On Hana/BO/ (Freelance) (Consultant)

Ecopetrol

Dec 2015 - Current (10 years 11 months)

(Oil & Gas - Bogota, Colombia) Project Type: Project New Instance. Business Objects, Web Intelligence (BOBI 4.1 SP5), SAP Design Studio, SAP Lumira (1.25), SAP Analysis For Microsoft Excel, SAP BW BEX query connection, Exit ABAP Variable Extensions, Extending ERP Extractors by BADI's, Modification Creation and adjustments of BEX querys from AODS, Composer Providers and CUBEs of SAP BW On HANA using SLA++ methodology and SAP SLT to replicate the data from ECC, design and documentation of Business Objects, Web Intelligence reports (BOBI WEBI 4.1) for KPI, weekly, monthly, monthly indicator reports quarterly ECOPETROL production.

S

BI/BW On Hana Acelerator/BO/

SAB Miller – Drinks

Apr 2015 - Current (11 years 7 months)

Bogota Project Type: Roll Outs Project for BI. Business Objects, Web Intelligence (BOBI 4.1 SP4 FP3), SAP BW BEX query connection, Exit ABAP Variable Extensions, Modification Creation and adjustments of BEX querys from SDGs and SAP BW On HANA Cubes, and design and documentation of reports Business Objects, Web Intelligence (BOBI WEBI 4.1 and MOBILE) for KPI, weekly, monthly and quarterly SABMiller production reports.

C

Consultant Role BI/BW On Hana Acelerator/BO

Chaidneme Hermanos S.A.

Apr 2014 - Dec 2014 (9 months)

Autoparts, Agricultural, Mining Services (CHM Mining formerly CHANEME) Bogotá/Barranquilla/Medellin, Colombia. Project Type: New Project for BI. Activating and extending BI content SAP BW 7.04 for CO-PA, SD, FI, CO, FI-AR and Business Objects, Web Intelligence reporting modules (BOBI 4.1 SP3), SAP BW BEX query connection, and Business Objects, Web Intelligence reporting and design (BOBI) WEBI 4.0 and MOBILE) for daily, weekly, monthly and quarterly indicator reports of holding production, Rollup for company companies for the SAP BI (BW/BO) system.

P

BI/BW/BO (Freelance) (Consultant)

PRE - Pacific Rubiales Energy

Jan 2013 - Mar 2014 (1 year 3 months)

(Oil & Gas - Bogota, Colombia) Project Type: New Project for BI. Creation of Business Objects, Web Intelligence (BOBI 4.0) reports, connecting universes to the SAP BW BEX query, and designing and documenting Business Objects, Web Intelligence reports (BOBI WEBI 4.0) for daily, weekly, monthly and quarterly production modules of SAP FI, HPM, APO, SD, TD, TSW, APO, SAP Oil & Gas vertical ECC modules.

P