12/29/2022 updated
MS
100 % available
SAP SAC/Group Reporting/Anaplan/BW/HANA/BWC/AO/
white plains, USA
USA
https://sapinsider.org/experts/dr-marco-sisfontes-monge/Data AnalysisCloud ComputingFinancesSAP ApplicationsSAP NetWeaver BISAP HANAVba Programming Language
SAP SAC(very strong)/BW/DWC/Group Reporting (very Strong)/Financial Transformation
marc1986119_cr@hotmail.com
https://sapinsider.org/experts/dr-marco-sisfontes-monge/
marc1986119_cr@hotmail.com
https://sapinsider.org/experts/dr-marco-sisfontes-monge/
Experience
Professional experience10+ years
Languages
EnglishFluentSpanishFluent
Project history
Biopharma
Biotech and Pharmaceutical Client, Global Deployment Europe, Asia, Americas
North East, USA
Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect)
Jan-2019- to Dec 2019
SAP BPC 10.1 on HANA 1809 with BW4 with SAP ECC S/4
* Financial Statements development using composite providers.
* AO Reporting and customization using extensive MS Excel VBA programming and SAP BPC VBA
programming.
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, building ADSOs, Info Cubes, working with the new IBP/BPC Interface using
ADSos for flat file upload.
* SAP CPM configuration and integration with PS, SD, Procurement and Billing, Lumira, and
Project Baselines.
* GAP/FIT analysis to determine upgrade, reporting changes, data flow and implementation
strategy changes.
* Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1
* Integration with new consolidation tool from SAP Group Reporting for plan data.
* Working with CDS Hana Views, and deploying using Fiori of BEx Queries and AO Reports.
* Create Embedded S/4 Calculated KPIs and Key Figures and reported using HANA Views and AO
Reports for Planning and Consolidation.
* Working with Cost Center Planning, Workforce Planning, Financial Planning Balance Sheet, P&L,
Intercompany; Capital Projects, data conversion to third party reporting using BPC VBA.
* Work Status, and Business Process Flows using HANA Embedded functionality.
* Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for
BPC Planning, Workbooks, VBA code for BPC, Planning Functions.
* Working with SOLMAN (Solution Manager), and QC Vera for Testing, and deployment.
* Working with Embedded Fox Code and calculations.
Fiori Tile deployment of AO Workbooks, and end-user testing and training.
* Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR
Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for
material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods
Sold, Cost of Sales, P&L, B/S reporting, Cash Flow by Transaction Type.
Biotech and Pharmaceutical Client, Global Deployment Europe, Asia, Americas
North East, USA
Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect)
Jan-2019- to Dec 2019
SAP BPC 10.1 on HANA 1809 with BW4 with SAP ECC S/4
* Financial Statements development using composite providers.
* AO Reporting and customization using extensive MS Excel VBA programming and SAP BPC VBA
programming.
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, building ADSOs, Info Cubes, working with the new IBP/BPC Interface using
ADSos for flat file upload.
* SAP CPM configuration and integration with PS, SD, Procurement and Billing, Lumira, and
Project Baselines.
* GAP/FIT analysis to determine upgrade, reporting changes, data flow and implementation
strategy changes.
* Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1
* Integration with new consolidation tool from SAP Group Reporting for plan data.
* Working with CDS Hana Views, and deploying using Fiori of BEx Queries and AO Reports.
* Create Embedded S/4 Calculated KPIs and Key Figures and reported using HANA Views and AO
Reports for Planning and Consolidation.
* Working with Cost Center Planning, Workforce Planning, Financial Planning Balance Sheet, P&L,
Intercompany; Capital Projects, data conversion to third party reporting using BPC VBA.
* Work Status, and Business Process Flows using HANA Embedded functionality.
* Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for
BPC Planning, Workbooks, VBA code for BPC, Planning Functions.
* Working with SOLMAN (Solution Manager), and QC Vera for Testing, and deployment.
* Working with Embedded Fox Code and calculations.
Fiori Tile deployment of AO Workbooks, and end-user testing and training.
* Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR
Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for
material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods
Sold, Cost of Sales, P&L, B/S reporting, Cash Flow by Transaction Type.
Konica Minolta
Manufacturing Client, global Deployment Europe, Americas, and Asia
North East, USA
Implementation and Financial Transformation Lead (BPC Embedded/Standard/HANA Architect)
SAP BPC 10.1/11 on HANA 1709 with BW4 with SAP ECC S/4, and current migration to SAP BPC 11.
March 2017-Jan 2019
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience
working with SAP BPC MS versions.
* Global Deployments in different Continents in both Planning and consolidation.
* GAP/FIT analysis report development, architectural changes, data flow, software upgrade, and
package configurations in alignment with SAP BPC 10.1/SAP BPC 11.
* Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC ,and migration to SAP
HANA Optimized in progress.
* Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1 and SAP BPC 11.
* SAP BPC Security on SAP BW, Test Scripts, Training, Citrix Deployment using BOBJ Data Repository.
* Working with FOX Code formulas
* SAP CPM project management, baseline, project reporting, Issue Resolution, working with business
requirements and SAP BPC and SAP CPM integration.
* Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat
Files and reading SAP BI Info Cubes.
* VBA and BPC customizations for dropdowns, save, prompts, complex calculations for labor and
capital, multiple selections, queries with multiple selection of merge variables, complex
workbooks, with multiple aggregation levels, copy functions.
* IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
* Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for BPC
Planning, Workbooks, VBA code for BPC, Planning Functions.
* Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR
Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for
material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold,
Cost of Sales, P&L, B/S reporting, and architecture design and integration with Japanese
Operations.
* SAP BW DTPs, Data Transformations, Mappings, conversions.
Manufacturing Client, global Deployment Europe, Americas, and Asia
North East, USA
Implementation and Financial Transformation Lead (BPC Embedded/Standard/HANA Architect)
SAP BPC 10.1/11 on HANA 1709 with BW4 with SAP ECC S/4, and current migration to SAP BPC 11.
March 2017-Jan 2019
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience
working with SAP BPC MS versions.
* Global Deployments in different Continents in both Planning and consolidation.
* GAP/FIT analysis report development, architectural changes, data flow, software upgrade, and
package configurations in alignment with SAP BPC 10.1/SAP BPC 11.
* Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC ,and migration to SAP
HANA Optimized in progress.
* Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1 and SAP BPC 11.
* SAP BPC Security on SAP BW, Test Scripts, Training, Citrix Deployment using BOBJ Data Repository.
* Working with FOX Code formulas
* SAP CPM project management, baseline, project reporting, Issue Resolution, working with business
requirements and SAP BPC and SAP CPM integration.
* Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat
Files and reading SAP BI Info Cubes.
* VBA and BPC customizations for dropdowns, save, prompts, complex calculations for labor and
capital, multiple selections, queries with multiple selection of merge variables, complex
workbooks, with multiple aggregation levels, copy functions.
* IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
* Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for BPC
Planning, Workbooks, VBA code for BPC, Planning Functions.
* Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR
Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for
material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold,
Cost of Sales, P&L, B/S reporting, and architecture design and integration with Japanese
Operations.
* SAP BW DTPs, Data Transformations, Mappings, conversions.
Kao Group,
Manufacturing Client, global Deployment Europe, Americas, and Asia
USA, Midwest and Northeast
Implementation and Financial Transformation Lead (EPM/HANA Architect)
SAP EPM 10.0/SAP BPC 10.1 on HANA with BW4 with SAP ECC S/4.
March 2015-March 2017
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience
working with SAP BPC MS versions.
* Global Deployments in different Continents in both Planning and consolidation.
* Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC.
* Migration of SAP BW Tax data to SAP HANA and included as part of the SAP
* Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat
Files and reading SAP BI Info Cubes.
* IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
* Reporting, Consolidation and Planning.
* Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial
Consolidation, Investments: short-term and long-term debt, Balance Sheet Planning, Income
Statement, and others.
* Planning and Consolidation project, with global training in different locations onsite in Europe
and USA.
* Development of BEx queries, workbooks, key figures and variables, DTS, QDPs, Info Providers, ODS,
Composite Providers, Info Cubes, Multicubes.
* Reports using Crystal Reports, Dashboards, WEBI, Analysis for Office, and direct connection of MS
Excel to HANA platform.
* HANA migration and enhancement of reporting:
* Update of S/4 HANA Reporting using BOBJ, Crystal Reports, and Web Intelligence.
* Update of SAP HANA from SP06 to SP12 for Graphical Views.
* Working with SAP HANA security and Analytic Privileges
* Creating and enhancing Analytic, Attribute, and Calculation Views for BOBJ4 reporting using
Universes.
* Creating customized calculations using SQL, Calculation Engine and SAP HANA Expression
Editor.
* Creating Decision Tables for Sales Analysis and Discounts
* Replicating SAP ECC tables into HANA, and enhancing and combining SAP BW cubes (migrated to
SAP HANA) and Third-Party sources into the same Calculation views.
* Creating Input Parameters and calculated values on the fly.
* Transporting SAPHANA objects between systems.
* Integration with SAP BPC for master data on the fly replication from SAP ECC, and alignment
with the SAP EPM Embedded model.
* Migration of SAP EPM 10 to 10.1 on HANA objects.
* Replicating SAP ECC data into HANA and exporting into SAP BW for reporting.
* Data provisioning replicating SAP ECC data into HANA using SLT, and working with BW on HANA
to enhance BW cube information and combine it with HANA Calculation Views.
* Working with Analytical Views Join, Aggregation, Projection, and Union for SAP and Non-SAP
data.
* Extensive reporting using the Universal Journal and ACDOCA to combine analysis of CO-PA,
Assets, FI, CO, and Statistical Journals in order to provide real time financial reporting.
Manufacturing Client, global Deployment Europe, Americas, and Asia
USA, Midwest and Northeast
Implementation and Financial Transformation Lead (EPM/HANA Architect)
SAP EPM 10.0/SAP BPC 10.1 on HANA with BW4 with SAP ECC S/4.
March 2015-March 2017
* Focused on Financial Reporting, Consolidation and Financial Planning.
* SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience
working with SAP BPC MS versions.
* Global Deployments in different Continents in both Planning and consolidation.
* Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC.
* Migration of SAP BW Tax data to SAP HANA and included as part of the SAP
* Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat
Files and reading SAP BI Info Cubes.
* IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
* Reporting, Consolidation and Planning.
* Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial
Consolidation, Investments: short-term and long-term debt, Balance Sheet Planning, Income
Statement, and others.
* Planning and Consolidation project, with global training in different locations onsite in Europe
and USA.
* Development of BEx queries, workbooks, key figures and variables, DTS, QDPs, Info Providers, ODS,
Composite Providers, Info Cubes, Multicubes.
* Reports using Crystal Reports, Dashboards, WEBI, Analysis for Office, and direct connection of MS
Excel to HANA platform.
* HANA migration and enhancement of reporting:
* Update of S/4 HANA Reporting using BOBJ, Crystal Reports, and Web Intelligence.
* Update of SAP HANA from SP06 to SP12 for Graphical Views.
* Working with SAP HANA security and Analytic Privileges
* Creating and enhancing Analytic, Attribute, and Calculation Views for BOBJ4 reporting using
Universes.
* Creating customized calculations using SQL, Calculation Engine and SAP HANA Expression
Editor.
* Creating Decision Tables for Sales Analysis and Discounts
* Replicating SAP ECC tables into HANA, and enhancing and combining SAP BW cubes (migrated to
SAP HANA) and Third-Party sources into the same Calculation views.
* Creating Input Parameters and calculated values on the fly.
* Transporting SAPHANA objects between systems.
* Integration with SAP BPC for master data on the fly replication from SAP ECC, and alignment
with the SAP EPM Embedded model.
* Migration of SAP EPM 10 to 10.1 on HANA objects.
* Replicating SAP ECC data into HANA and exporting into SAP BW for reporting.
* Data provisioning replicating SAP ECC data into HANA using SLT, and working with BW on HANA
to enhance BW cube information and combine it with HANA Calculation Views.
* Working with Analytical Views Join, Aggregation, Projection, and Union for SAP and Non-SAP
data.
* Extensive reporting using the Universal Journal and ACDOCA to combine analysis of CO-PA,
Assets, FI, CO, and Statistical Journals in order to provide real time financial reporting.