v

Gerardo Cesar Salas Figueroa

SAP BW*HANA + ABAP Sr. Consultant

adm1vx@r.postjobfree.com

I am able to relocated my residence

TN American Visa, Update 2023

Cell +1-53-043*-****

Profile

Senior SAP BI/BW4HANA + ABAP Consultant with 14+ years’ experience in several full cycle SAP implementations. Strong Analytical using ASAP methodologies and LSA++ development process Extraction – Transformation and Loading Data, S4 Hana CDS Views like DS, to help to the Business the better solution for requests. Native HANA skill (modeling from CDW views – ADSO or Calculations view to Composite Provider - Queries). Good Knowledge in ABAP and Business Objects Analysis for Office.

Expertise in SAP BW4HANA + ABAP.

Strong Analytical architecture on S4 HANA CDS View (clear to use the right annotation for Transactional data dataCategory: #CUBE or Master Data dataCategory: #DIMENSION) and understanding the logic to join several tables for the client's needs.

Native HANA Strong developer to create Calculation View, attribute view and Analytical views using complex logic.

BW ABAP enhancement like start/end/field ABAP routine, data source and user exits.

Strong creation Queries in Hana Studio using variables with replacement path, exception aggregation, restricted key figure, calculation key figure, and formulas

Able to create BW CDS view, CDS Views works as InfoProviders (called Transient Provider)

Experience Translating Functional Specifications into Technical Specifications.

10+ years’ Experience like lead SAP BW Consultant, leader process request from BU Follow Up the methodology ASAP form Project Preparation until to Go Live,

Define work plan based on SAP methodologies, taking into account the technical and business requirements of customer. GAP Analysis and understanding of the client's current needs.

Define key indicators and dashboards configuration, taking into account the technical and business requirements of customer. Support activities to other functional elements.

Problem solving, analysis and support to the development of new applications and business solutions for the customer.

Customize SAP functionality to satisfy business unit requirements, scope, plan for risk and issues.

A person with leadership, Analytical Decision-Making Capacity, Able to work under pressure Able to communicate effectively, Proactive, personnel management.

Strong Analytical using SAP ASAP methodologies of SAP with Administration Workbench Data Modeling, Extractor Custom and Enhancement to Business Content, to help to the Business Unit the better solution for requests.

10+ years’ Experience with ERP systems software development and lead Consultant support and troubleshooting computing systems; a proven track record in identifying problems and developing innovative solutions.

Education:

Management Projects with SAP ASAP methodology 2006

SAP BW4HANA and S4 HANA

SAP Business Information Warehouse BW 3.5

SAP R/3 v 4.6C, ECC 6

Forester College Of Technology, Toronto, Canada

Diploma in Database Developer 2002.

(Specialization) DEEDs Project.

University of Toronto. Canada

University of Toronto 2001

International English as a Second Language

TOEFL Preparation

Bachelor Degree of Computer Engineer. 1997

University of Queretaro, Mexico.

Work Experience:

SAP BW4HANA - Lead Senior Consultant February 2020 – March 2021

Company: VDart.Inc working on behalf of Florida Power & Light Company (FPL)

Project: GULF S4 – BW4HANA Project

Place: Juno, Florida, USA

Summary: Consultant Developer - integration and consolidation the Financial, Billing and logistic data from SAP S4 to BW4HANA, creation the CDS view join several tables replication and Calculation View to BW then create the data flow, serves to provide information for a suggested query to derive the Final Analysis, the outstanding unpaid account balances, calculate unbilled revenue during closeouts etc.

Responsibilities:

Development the data flow from S4 CDS views to Composite Providers from Financial (FI), Billing using ODP and SDA Data Sources.

Design and create data flow Architecture of FPL Business processes from BBP to Go Live.

Consolidate in the advance DSO objects the information of the processes that involve the SAP S4 and Native HANA Calculation View.

Use the new technologies of SAP Operational Data Provisioning Connection and Smart Data Access which allows us to extract and load the information of non-SAP systems.

Use the BW Modeling Tools in HANA Studio Eclipse to Modeling the Business Request.

Use the ODP Operation Data Provisioning to connect the SAP S4 Data Sources.

Monitoring Process Chains from SAP S4.

Participate in the search for business opportunities and job development proposals.

Create queries in Hana Eclipse from the data mart - composite provider to Analysis for Office

Modeler the full Data Flow by creating CDS view data sources from ECC S4 to replicate to SAP BW4HANA.

Add ABAP code in Start, End Routine and InfoObjects to InfoObjects in Transformation, variable customer exit.

Made sure every month project done on time follow the scope see the need to avoid delay for the Go-live support.

Technology and Tools used: SAP S4 (Billing SD, Account to Reporting (FICO), P2P, and Logistics) and BW4HANA, Hana Studio 2.0 - Eclipse, ABAP, and Analysis for Office, BO, BODS, WEBI and SAC.

SAP BW4HANA - Lead Senior Consultant March 2018 – Dec 2019

Company: Biossmann

Project: Folio Tracker Biossmann

Place: Fremont, CA

Summary: Lead Support Folio Tracker Biossmann Project, to integration and Consolidate the Financial and logistic Data from SAP ECC 6.0, SAP ECC on HANA, and Legacy SQL Server Transitional Data to BW4HANA to determine the Data Flow from Folio Tracker in Biossmann, the possible way to analyze the Hospital Machines with the anesthesia and inventory medicines and information.

Responsibilities:

Development the Composite Providers from Financial (FI), Inventory (MM), (BPC), and Folio Tracker Process (Non-SAP) from Data sources SAP ECC and Legacies to BW using ODP and SDA Data Sources.

Design and Create the Data Flow Architecture of Biossmann Business processes from BBP to Go Live.

Consolidate in the advance DSO objects the information of the processes that involve the SAP and SQL legacy systems.

Use the new technologies of SAP SDA Smart Data Access which allows us to extract and load the information of non-SAP systems.

Use the BW Modeling Tools in HANA Studio and Eclipse to Modeling the Business Request.

Use the ODP Operation Data Provisioning to connect the SAP ECC Data Sources.

Use Fiori to Manage, Active and Load data into the SAP BW Objects.

Monitoring Process Chains from SAP and Legacies Systems.

Participate in the search for business opportunities and job development proposals.

High level Architecture project included creation of new SAP BW Composite Provider for several processes.

Create new queries from Data Mart - composite provider and calculation view direct.

Modeler the full Data Flow by creating Generic and Standards Data Sources from ECC to replicate to SAP BW4HANA.

Modeler Composite Provider with Advance DSO and Native HANA Calculation View, Attribute view, Analytic view to satisfy the following internal Biossmann models Management, Financial and Logistic data.

Add ABAP code in Start, End Routine and InfoObjects by InfoObjects in Transformation, CMOD, and Customer EXIT.

Made sure every Sprint Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Technology and Tools used: SAP ECC 6 (Billing SD, Order to Cash (OTC), Account to Reporting (FICO), P2P, Logistics, MM) and SAP BW4HANA, Hana Studio 2.0, ABAP, WEBI, Analysis for Office

SAP BI BW on HANA /Lead Senior Consultant July 2017 – February 2018

Company: INFONAVIT - UNISYS. Company Role - Government

Project: Audit Tax for Employers

Place: Mexico City

Summary: Lead Support the with the use of information technologies to determine the possible tax evasions of employee collection

Responsibilities:

Development of several Calculation Views on HANA of the audit process, to determine the possible fraud evasions of employers. And satisfy the need for online Information.

Audit Taxes collection - Evaluate and select the project approach for Incidents, Change Request, Services Orders, Services Request and Task, using BBP, Functional Specification,

Monitoring progress like Process Chains and participate in the search for business opportunities and job development proposals.

High level Architecture project included creation of new SAP BW MultiProvider for several processes at INFONAVIT. Create new queries on composite provider and calculation view direct.

Modeler the full DataFlow by creating Generic and Standards DataSources from ECC to replicate to SAP BW on HANA Infopackage to validate the PSA data then DTP to the AODS, configurate the composite provider and process chain to automatic load data form the system.

Modeler Composite provider with Advance DSO and Native HANA Calculation View Attribute view, Analytic view and SQL Statement procedures) to satisfy the following internal Infonavit models like Audit Taxes, Supplier Management, inmobilizations, Affiliations to the IMSS, Audit Employer from the SAT.

Created the Custom DataSource in ECC TRM and CRM and replicate in BW

Used ABAP code into Strat, End Routine and InfoObject by InfoObject in Transformation, CMOD, and Customer EXIT.

Made sure every Sprint Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Technology and Tools used: SAP ECC 6 (Billing SD, Order to Cash (OTC), (FICO GL, AR, and AP), P2P, Logistics, MM) and SAP BW/BI7.5 on HANA, Analysis for Office

SAP BW/BI /Senior Consultant January 2017 – June 2017

Company: Novartis – Company Role - Pharmacist

Project: SANDOZ – Novartis Solution Management

Place: Fremont, CA

Summary: Support Lead the SANDOZ BW/BI team, made sure the Incidents are solved and completed on time

Responsibilities:

Project SANDOZ SAP BW/BI 7.4 on HANA - Evaluate and select the project approach for Incidents, Change Request, Services Orders, Services Request and Task, using SAP NOVASOL, ensuring that projects are developed according to the request and consistency of the Company, be responsible for the management the times for the INC. monitoring progress like process Chains, and participate in the search for business opportunities and job development proposals.

High level Architecture project included creation of new MultiProvider FR Customer /Month - Sales out - dedicate new InfoCube data flow load by FR buying group and populate with exist Customer hierarchy object. Creating new InfoObjects. Update the process chain added the new InfoCube. Create new Queries FR Customer /month sales out.

Modeler by Creating InfoCubes by using Standards procedure by Novartis

Modeler Composite provider with Advance DSO and Native HANA Calculation View Attribute view, Analytic view to satisfy the model of business.

Created the Custom DataSource in ECC and replicate in BW

Used ABAP code into Strat, End Routine and InfoObject by InfoObject in Transformation, CMOD, and Customer EXIT. According to the Novartis Political

Resolve Incidents in SANDOZ BI team.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Technology and Tools used: SAP ECC 6 (Billing SD, Order to Cash (OTC), (FICO GL, AR, and AP), P2P, Logistics, MM) and SAP BW/BI7.4 on HANA

SAP BW/BI /Senior Consultant January 2016 – December 2016

Company: Soriana – Neoris. Company Role - Retails

Project: Proyecto T

Place: Mexico City

Summary: Lead the BW project, made sure the request is complete in time

Responsibilities:

Project SAP BW 7.3 Consultant. Evaluate and select the project approach - Business Blue Print, using SAP methodologies, ensuring that projects are developed to meet customer expectations and consistency of the Company, be responsible for the management of the resources allocated to project, monitoring progress against the work plan, and participate in the search for business opportunities and job development proposals.

Architecture for the archiving project to using the actual hardware to reduce cost and time at the archiving process

Modeler by Creating InfoCubes by using Tables, Attribute Views, Analytic View, Calculation View, Analytic Privilege, and Store Procedure.

Created the Custom DataSource in ECC and replicate in BW

Used ABAP code into Strat, End Routine and InfoObject by InfoObject in Transformation, CMOD, and Customer EXIT.

Lead Project SAP HR - BW for Data Provision from Headcount Employee.

Developed reports on Info Cubes/MultiProvider using BEx Analyzer/Explorer (RRMX) to facilitate summarization of data.

Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.

Worked extensively with 0FI_GL_4 and 0FI_GL_2 Extractors and developed 0FIGL_C01 cube to calculate total credit and debit postings along with generic extraction for Plant utilization reports.

Lead Project SAP FI-CO - BW for Data Provision from General ledger Installation of Business content for G/L (0FIGL_04) and built Trial Balance Reports..

Lead team with 5 member

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Integrate the HR data with other modules involve like Finance (FI) in several Queries.

Technology and Tools used: SAP ECC 4.6 (HR Human Resources, Billing SD, Order to Cash (OTC), (FICO GL, AR, and AP), P2P, Logistics, MM)ABAP and SAP BW/BI7.3 v

SAP BW/BI Lead Project /Senior Consultant July 2014 – Dec 2015

Company: IBM - Grupo México – Company Role - Mining

Project: IntegraSAP.

Place: Mexico City and Lima City, Peru

Summary: Lead the HR - BW project, made sure the request is complete in time

Responsibilities:

Project SAP BW 7.3 Consultant IntegraSAP. Architecture high level HR project, approach from Business Blue Print, using SAP methodologies, ensuring that projects satisfice the Peruvian and Mexican management head count person data with the payroll by developed to meet customer expectations and consistency of the Company, be responsible for the management of the resources allocated to project, monitoring progress against the work plan.

Hana Modeler by Creating Composite provider Union of advance DSO on Hana Model by using Tables, Attribute Views, Analytic View, Calculation View, Analytic Privilege, and SQL statement Store Procedure.

Built Process Chains to run data validation before loading Excel files and delta load for R/3 data.

Created the Custom DataSource in ECC and replicate in BW

Used ABAP code into Strat, End Routine and InfoObject by InfoObject in Transformation, CMOD, and Customer EXIT.

Lead Project SAP HR - BW with 6 BW consultants and 1 ABAP consultant for Data Provision from Headcount Employee. Created Personnel Cost Plan (0HR_PA_CM_8) enhancements to include Cost Center.

Created BI BEx Reports in Pension Funds, Compensation Management, and Organization Management in BI-HR Reporting.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.

Integrate the HR data with other modules involve like Finance (FI) in several Queries.

Technology and Tools used: SAP ECC 4.6 (Billing SD, Order to Cash (OTC), (FICO GL, AR, and AP), P2P, Logistics, MM) and SAP BW/BI7.4 on HANA

SAP BW/BI Team Lead/Senior Consultant July 2013 – July 2014

Company: Bachoco – Company Role Food

Project: Bachoco SD Sales and Finance.

Place: Mexico City

Summary: Lead the Finance and SD project, made sure the request is complete in time

Responsibilities:

Project SAP BW 7.3 Consultant Business Unit Bachoco. Evaluate and Architecture the Sales Distribution project approach, using the ASAP methodologies, ensuring that projects are developed to meet customer expectations and consistency of the Company, be responsible for the management of the resources allocated to project, monitoring progress against the work plan, and participate in the search for business opportunities and job development proposals.

Activate the Customizing Cockpit like Sales, Shipment and Billing add enhancement with the ABAP programming.

Monitored daily BW uploads and LO Cockpit Jobs, re-peat scheduled the Cockpit jobs when daily uploads were delayed, resolved several issues during uploads.

Created the Custom DataSource in ECC and replicate in BW

Used ABAP code into Strat, End Routine and InfoObject by InfoObject in Transformation, CMOD, and Customer EXIT.

Utilized Standard DataSources with LO Customizing Cockpit for extracting Sales, Billing, and Purchase applications data. Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, and 2LIS_03_S194 and populated into the procurement info cubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.

Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution (SD) module (SalesOrder 2LIS_11_VAHDR/VAITM, Shipping/Delivery 2LIS_12_VCHDR/VCITM, and Billing 2LIS_13_VDHDR/VDITM).

Lead Project SAP BW for Data Provision for finance and SD, keeping running fine the all Data Load and Ticket Request from Business.

Lead Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement.

Interaction with the following SAP modules in ECC like FICO, COPA, SD.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support

Technology and Tools used: SAP ECC 4.6 (Billing SD, Order to Cash (OTC), (FICO GL, AR, and AP), P2P, Logistics, MM), and SAP BW/BI7.3 v

SAP BW/BI Team Lead/Senior Consultant January 2013 – June 2013

Company: Monsanto DF - Company Role Food and Seeds

Project: Monsanto Growers Data from Seeds.

Place: Mexico City

Summary: Lead the Growers Data project, made sure the request is complete in time

Responsibilities:

Project SAP BW 7.0 Consultant Business Unit Monsanto. Architecture the Growers project approach, using ASAP methodologies used, ensuring that projects are developed to meet customer expectations and consistency of the Company, be responsible for the management of the resources allocated to project, monitoring progress against the work plan, and participate in the search for business opportunities and job development proposals.

Lead Project SAP BW for Data Provision in Seeds and Crop, keeping running fine the all Data Load and Ticket Request from Business.

Lead Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement.

Enhanced several standard reports like Overall Budget: Assigned Funds in the Commitment Budget, Annual Budget (Periodic Representation) Commitments and Actuals as per client requirement in Funds Management using SAP BEx Query Designer.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support

Technology and Tools used: SAP ECC and SAP BW/BI

SAP BW/BI Senior Consultant March 2012 – December 2012

Company: T-Systems at McKesson - San Francisco, California, USA - Company Role - Pharmacist

Project: McKesson Data SAP BW

Place: San Francisco, CA

Summary: Lead and Evaluate and select the project approach, and made sure the Data comes from ECC 100% fine to SAP BW.

Responsibilities:

Lead Project SAP BW 7.0 Consultant Business Unit McKesson. Be responsible for the management of the resources allocated to project, monitoring progress against the work plan, and participate in the search for business opportunities and job development proposals.

Lead BI Team and select the right consultants with the right need and Skills to develop the request from the BU. Show the full Scope, issues and risk.

Lead Project SAP BW for Data Provision and keep running fine the all load data and Ticket Request from Business

Lead Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement.

Interaction with the following SAP modules in ECC like FICO, QM, SD.

Performed the end user training, knowledge transfer and production support activities and resolved various issues apart from the above mentioned subject areas.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support

Technology and Tools used: SAP ECC and SAP BW/BI

SAP BW/BI Lead Consultant Feb 2011 – March 2012

Company: Hewlett-Packard (HP) – Softtek

Project: HP - LiveHouse Project

Place: Mexico City

Summary: Lead Project SAP BW LiveHouse into Business Unit. Lead Team with the right BI consultants

Responsibilities:

Lead Project SAP BW LiveHouse into Business Unit. Lead Team with the right BI consultants with the especial Skills to develop the request from the BU. Show the Plans for the full Scope, issues and risk, consultants and skills

Evaluate and select the project approach and tools and methodologies to be used, Lead Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement for Base Actual in R/3 (LiveHouse).

Interaction with the following SAP modules in ECC like FICO, QM, P2P, IM, PP, SD.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support

Technology and Tools used: SAP ECC and SAP BW/BI

SAP BW/BI Senior Consultant March 2007 – Feb 2011

Company: PepsiCo. International

Project: Evolve PepsiCo Project

Place: Mexico City

Summary: Development SAP BW Request from Business Unit

Responsibilities:

Consultant Evolve Project from Business Blueprint, Realization, Final preparation and Go Live,

Develops solutions and approaches, providing leadership in solving customer problems. Lead the development of the project, ensuring that the content of the deliverables are achievable and ensure sustained change customer. Manage development projects and close sales. Lead the development of new requirements and adapt to customer products and services.

Assign the right BI consultants with the especial Skills to develop them, Coordinate Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement for Base Actual in ECC Data Source, Created Customized Views from Operation Sabritas, Gamesa. QM, Quality Material. Replication into BW, Created and Fill up ODS & InfoCubes (Communication Structure, Transfer Rules, Update Rules, InfoSource, Created Info Package,), Then create InfoProvider and used them for Customized Reports in BEx Analyzer and Portal BI.

Interaction with the following SAP modules in ECC like FICO, QM, P2P, IM, PP, SD.

Made sure the full Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support

Technology and Tools used: SAP ECC and SAP BW/BI

SAP BW Developer Consultant April 2006 – Feb 2007

Company: Forester College of Technology, Toronto, Canada

Project: Forester Project

Summary: Develop Extractor Custom and Enhancement from ECC to SAP BW

Responsibilities:

Extractor Custom and Enhancement to Business Content for Base Actual in R/3 Data Source, LO Extraction. Created Customized Views from SD (Billing, Sales and Shipping Tables), Replication into BW, Created and Fill up ODS & Info Cubes (Communication Structure, Transfer Rules, Update Rules, InfoSources, Created Info Package,), Then create InfoProvider and used them for Customized Reports and BEx Queries.

Technology and Tools used: SAP ECC and SAP BW/BI

SAP BW Developer Jan 2006- Feb2007

Company: Salvation Army (Volunteer) Toronto, Canada

Project: SAP BW

Summary: Extractor Custom and Enhancement for Base Actual in ECC Data Source

Responsibilities:

BW Developer Consultant, Coordinate Roles and meeting to the BU (Business Unit) and Functional Track to clarify all the requests reports and Extractor Custom and Enhancement for Base Actual in ECC Data Source, Created Customized Views from Operation. Quality Material. Replication into BW, Created and Fill up ODS & InfoCubes (Communication Structure, Transfer Rules, Update Rules, InfoSource, Created Info Package,), Then create InfoProvider and used them for Customized Reports in BEx Analyzer and Portal BI.

Technology and Tools used: SAP ECC and SAP BW/BI

REFERENCES AVAILABLE UPON REQUEST.

Contact this candidate