Profileimage by Leandro Cescato SAP Analytics Certified Consultant (BW/HANA/SAC/BO) from CP

Leandro Cescato

available

Last update: 06.09.2022

SAP Analytics Certified Consultant (BW/HANA/SAC/BO)

Graduation: Computer Science
Hourly-/Daily rates: show
Languages: English (Full Professional) | Spanish (Full Professional)

Attachments

cv-leandro-cescato---en5-freelance.docx

Skills

Summary:
Having 13+ years of experience in SAP BI projects including Retail, Oil & Gas, Energy and Public Sector industries. 
Extensive Experience on Data Modelling: analyzing business needs of clients, developing effective and efficient solutions, and ensuring client deliverables within committed timelines
Involved in end-to-end BI Solutions implementations with tools like SAP BW, SAP BO, SAP HANA, SAP BPC Optimized and SAP SAC. 
Experience with analysis, time/resource estimation, design, development, QA, implementation, post-deployment support and training.
Experience with functional areas like SAP FI, FM, SD, MM, PM, HR, CRM and SRM for integrating with SAP BI.

Techincal Skills:
  • SAP BW, BW/4HANA AND SAP HANA.
  • SAP BO: DASHBOARDS | WEB INTELLIGENCE | IDT | LUMIRA | CMC.
  • SAP ANALYTICS CLOUD.
  • SAP BPC OPTIMIZED.
  • SAP ABAP AND SQL.
Certifications:
  • C_BW4HANA_20 - REPORTING / MODELING AND DATA ACQUISITION WITH SAP BW/4HANA 2.X. (June 2021)
  • C_SACP_2102 - SAP ANALYTICS CLOUD: PLANNING (May 2021)
  • C_SAC_2008 - SAP ANALYTICS CLOUD (July 2020)

Project history

12/2019 - Present
SAP BO Sr Consultant
Grainger (Consumer goods and retail, >10.000 employees)

SAP BO remote project
Environment: SAP BW 7.5 on Hana and SAP BO 4.2
Responsibilities:

  • Migration of SAP BW old queries into SAP Business Objects Web Intelligence using Teradata database and IDT/UDT tools.
  • Direct contact with customers and business users.
  • Scrum Agile methodology.

10/2020 - 02/2021
SAP SAC Sr Consultant
Farmacorp (Bolivia) (Pharmaceuticals and medical technology, 500-1000 employees)

SAC Planning remote project
Environment: SAP SAC.

Responsibilities:

  • Implementation of SAC planning solution for Sales & Marketing, Finance, Purchasing and Human resources areas.
  • Implementation of SAC data models with Import connections from file server data sources.
  • Develop data actions, value driver trees and simulation scenarios.
  • Develop KPI’s Stories to show Profit & Loss Statement, Cashflow and Balance sheet.
  • Creation of roles and users.

04/2020 - 08/2020
SAP SAC Sr Consultant
Aza (Chile) (Industry and mechanical engineering, 500-1000 employees)

SAC remote project
Environment: SAP SAC.
Responsibilities:
* Delivery of SAC course for key users and IT customers.
* Implementation of SAC data models with Live and Import connections from BW embedded (S/4 HANA)
data sources.
* Design SAC Stories with Sales, Deliveries, Cost and Expense key figures.

10/2018 - 11/2019
SAP HANA/BW/BPC Sr Consultant
SOFSE (Argentina) (Public service, 500-1000 employees)

S/4HANA and BPC Optimized project
Environment: SAP S/4HANA 1610, BW 7.5 and BPC Embeded 10.1.
Responsibilities:
* Implementation of HANA models and BW embedded models for Material, Service, Asset Accounting
and Human Resource planning scenarios.
* Modelling of HANA views (based on S/4's tables), Table Functions, Advanced DSO and Composite
Provider to expose FI-AA, CO, MM, HCM information.
* BPC Optimized: design of Analysis for Office workbooks to generate planning, budgeting, and
forecasting scenarios. Including plan and actual data for budget.
* Configure security roles and authorizations for both BW objects and reports.

05/2018 - 09/2018
SAP SAC Sr Consultant
Senado de la Nación (Argentina) (Public service, 500-1000 employees)

SAC project
Environment: SAP SAC
Responsibilities:
* Developed data models with Live and Import connections from file server and Oracle data sources.
* Designed Stories and Digital Boardrooms with Budget, Purchase and Expense KPIs.
* Involved in security configuration.

07/2017 - 06/2018
SAP BW/BO Sr Consultant
Lotería de la Ciudad S.E. (Argentina) (Public service, 250-500 employees)

Roll Out project
Environment: SAP S/4HANA 1610, BW 7.4 and BO 4.1.

Responsibilities:

  • Interaction with end users to understand their Reporting Requirements and creating related informational document.
  • Complete adaptation of BW model and BO Web Intelligence reports for the new measures and KPIs.
  • Data extraction from SAP S/4 and SQL Server to SAP BW   
  • Performance tuning by maintaining Aggregates, Compression and indexing of infocubes.

04/2016 - 04/2017
SAP BW/BO/HANA Sr Consultant
Metrogas (Argentina) (Energy, water and environment, 500-1000 employees)

MetroGAS - M360 Project

Environment: SAP S/4HANA 1511 and SAP BW 7.4 on HANA
BW, HANA and BO implementation, which involve Business Blue printing, Development,Testing, Reporting, Go-live and Post Go-live support.
Responsibilities:

  • BW modelling optimized from HANA objects: use of Composite Provider, Advance DSO y ODS Views from CRM, IS-U (PM/MM) y CO modules.
  • Implementation of the new model of "Inventory Management and Physical Inventory" (MM-IM).
  • Modeling of HANA Views.
  • Implemented SLT to export data from SAP IS-U to HANA database.
  • Design of operational reports and management KPI s with Web Intelligence and SAP Lumira tools.

07/2014 - 03/2016
SAP BW/BO Team Lead
AFIP (Argentina) (Public service, 1000-5000 employees)

Environment: SAP ECC 6.0, SOLMAN, SRM and SAP BW 7.1.

Responsibilities:

  • In charge of SAP BI team with three people under my supervision. Responsible for planning and time/resource estimation.
  • Implementation of Budget KPIs (FM): data extraction with standard and custom data sources to SAP BW. Design of Web Application Designer reports.
  • Performed detailed analysis to improve infocube's performance using Aggregates, Partitions and Index.
  • BW modeling and reporting from FI-GL (data sources like 0FI_GL_4, 0FI_GL_10), SOLMAN y SRM modules.
  • Integrated Planning (IP): create simulation of financial scenarios which allows users to simulate different percentages and generate his own versions.
  • Implementation of BI reports statistics: user's executions and performance by queries.

09/2013 - 06/2014
SAP BW/BO Team Lead
YPF (Argentina) (Energy, water and environment, 1000-5000 employees)

Environment: SAP ECC 6.0, SAP BW 7.3 and SAP BO 4.0.
Full life cycle of BW and BO implementation, which involve Blue printing, Development, Testing,  Reporting, Go-live and Post Go-live support.

Responsibilities: 

  •  In charge of SAP BI team with one person under my supervision. Responsible for planning and  time/resource estimation.
  • Solution design and Business Blueprint for BW and BO modules.
  • BW modeling from MM and SD modules: creation and extension of Z and standards data sources like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_03_BF and 2LIS_03_BX.
  • Design of process chains and BW/BO security administration.
  • Design of Dashboards comparing budget and actual amounts of purchases and sales materials.
  • Design of Web Intelligence reports with amount and quantity KPIs by material.
  • Information Design Tool:  creation of universe and OLAP connection.

10/2010 - 08/2013
SAP BW/BO Sr Consultant
ANSES (Argentina) (Public service, 1000-5000 employees)

Environment: SAP ECC 6.0, SAP BW 7.0 y SAP BO 3.1 XI.
Full life cycle of SAP BW/BO implementation and Post Go-live support.
Responsibilities:

  • BW modeling.
  • Responsible for building the BW data model for SRM, CO and PM modules.
  • Designed and built the FI-GL, FI-AA, FI-AP and FM data flow including enhancing standard Data sources, building generic extractors and creating BW objects.
  • Creation and extension of Z and standards data sources.
  • Creation of process chain and design of BW/BO security roles.
  • Creation of Bex queries and WAD reports.
  • Design of dashboards with Xcelsius 2008 tool and operative reports with Web Intelligence.
  • Preparation and delivery of SAP Business Objects courses for customers and consultants.

02/2008 - 09/2010
SAP BW Jr Consultant
Ripley (Chile) (Consumer goods and retail, 1000-5000 employees)

Environment: SAP ECC 6.0 y SAP BW 7.0.
Responsibilities:

  • Defining Data sources, Infosources, Infoproviders, Infoobjets, DataFlow, process chains and Bex queries.
  • Activated Business Content for standard SD and MM Infocubes.

Local Availability

Only available in these countries: Argentina
I am open to relocation.
I have Italian Citizenship and Passport of the European Union.
Profileimage by Leandro Cescato SAP Analytics Certified Consultant (BW/HANA/SAC/BO) from CP SAP Analytics Certified Consultant (BW/HANA/SAC/BO)
Register