Keywords
Skills
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.
- 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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
I have Italian Citizenship and Passport of the European Union.