Frederico Carvalho
Advisor, BI Leader
São José dos Campos,São Paulo
Resumo
Profissional com atuação técnica e de liderança especializada em SAC Planning e Reports, SAP BPC Consolidation, SAP BW4/Hana e On Hana e Embedded Analytics. Capacidade de liderar para motivar equipes. Demonstra flexibilidade para lidar com mudanças e orientação para metas, otimizando processos operacionais. Possui habilidades em MS Power BI e comunicação eficaz, promovendo um ambiente colaborativo e confiável. Experiência com a metodologia SAP Activate em projetos de S4/Hana.
Visão geral
22
22
years of professional experience
3
3
Certification
Experiência profissional
Advisor / BI Leader / Sr Consultant
DXC Technology
2016.06 - 2026.01
- Projeto BPC Consolidation e Bloco K: January/2025 – January/2026
- Projeto BPC Consolidation: June/2020 – May/2021
- Projeto BPC Consolidation: December/2019 – March/2020
- Projeto BPC Consolidation: January/2019 – November/2019
- Projeto BPC Consolidation: October/2017 – December/2018
- Projeto BPC Consolidation: June/2016 – September/2017
- Atuações
- BluePrint para projetos de Consolidação e Planning;
- Integração com BW para carga de dados mestre e transacionais;
- Carga de dados com flat-files;
- Conversão de moeda em projetos de consolidação e planning. Local Currency for Group Currency;
- Regras de eliminação de investimentos, intercompany, contas a pagar/receber, patrimônio líquido, minoritário e outras em projeto de consolidação;
- Conhecimento nos programas standard de BPC Consolidação - CALCACCOUNT, CONSOLIDATION, CURR CONVERSION, COPYOPENNING, RUN ALLOCATION;
- Conhecimento na configuração de estruturas societárias de unidades de negócio;
- Cálculo de CTA para ajustes de conversão de moeda;
- Template de configuração de journals (ajustes manuais);
- Desenvolvimento de relatórios para o cenário de consolidação como Balanço Patrimonial, DRE, Fluxo de Caixa, DMPL, DVA, entre outros quadros de notas explicativas;
- Configuração do BPF (Business Process Flow);
- Configuração do work status e relatórios de auditoria;
- Parametrização de cálculos em script logic e Badi.
- Integração do SAP BPC com SAP BW com cargas automáticas, usando process chain, infocubes, DSOs, transformations and DTPs.
Advisor / BI Leader / Sr Consultant
DXC Technology
2021.01 - 2023.12
- Projeto SAC Planning and Reports: June/2021 – June/2023
- Projeto BPC Planning: July/2014 – December/2015
- Atuações
- Conhecimento em finanças gerando relatórios de planejamento financeiro no SAC e BPC como: Balanço Patrimonial, DRE, Fluxo de Caixa, EBITDA e COVENANTS. Todos projetados;
- Utilização de data actions e analytics application como programação automática de cálculos no SAC;
- Criação de relatórios diversos;
- Carga de dados com fonte em CDS views, calculations views and BW para o SAC, usando import and live connection;
- Criação de diversos dashboards carregando dados de módulos PM, PS, FI, CO and FM on SAC. Dashboards para atender área operacional e estratégica;
- Criação de diversos relatórios no Fiori, utilizando a ferramenta analytics tools.
Sr Consultant
DXC Technology
2010.01 - 2014.12
- Projeto BW: January/2023 – June/2023
- Projeto BW: March/2010 – June/2014
Atuações: - Promover visibilidade das informações gerenciais e estratégicas usando o SAP BW nas diversas versões, trabalhando com grande volumetria de armazenamento de dados e gerando valor em relatórios / dashboards para os clientes na tomada de decisão;
- Data modeling to build BW’s architecture for the several SAP R/3, ECC and S4/Hana modules;
- Data modeling to build BW’s architecture by flat file;
- Build generic extractors based on views;
- Extension of the standard extractors;
- Build the Transformation Rules, Transformations, Infopackages, DTPs (Data Transfer Process), Process Chain, InfoObjects, hierarchy and Open Hub;
- Knowledge by data load Full and Delta;
- Basic knowledge by ABAP routines;
- Substantial knowledge by Bex Analyzer, Query Designer e Web Application Designer;
- Build Queries, Variables, Web Models and Publication in SAP BW Portals;
- Participation on Upgrade of Version (3,5 to 7.0) in the SAP BW;
Functional Analysis in the several modules SAP R/3; - Documentation of requirements for the multidimensional modeling architecture and detailing of queries;
- Functional specifications for the expansion of the fields of the standard extractors;
- Development solution with CDS views with extractors for BW on Hana;
- Work with BW modeling tools and eclipse projects for BW and ABAP perspective.
Sr Consultant
DXC Technology
2006.03 - 2009.12
- Projeto JVA (Operation with Partners)
- Atuações:
- Review the Operation with Partners solution (Joint Ventures) at PETROBRAS, emphasizing the vast knowledge of the business and the improvements to be implemented in the SAP R/3 System with emphasis in the modules SD, CO, MM, PS e JVA, besides the specifications for the creation of modules (InfoProviders) in the SAP BW System;
- Specifications for the creation of modules (InfoProviders) in the SAP BW System, to meet the solutions of the recovery monitoring to the partner of PETROBRAS on Joint Ventures. Solution that covered the creating of the BW model with information from the modules JVA, PS, CO, SD and FI;
- Training for 10 users of the developed solution on SAP BW;
- Functional Specifications to meet the needs of the Pricing Program developed in the SAP R/3 System. This program developed the JVA, PS, CO and MM modules;
- Functional Specifications to meet the Budgeting Program developed in the SAP R/3 System. This program developed the JVA, PS, CO, MM;
- Functional Specification to meet the Emission Measurement of the Transport Partnerships Report Program developed in the SAP R/3. This program developed the JVA, PS, CO and LT (Logistics and Transport – developed at PETROBRAS) modules;
- Functional Specifications to meet the Sale of Surplus Partnership Program developed in the SAP R/3 system. This program developed JVA, SD and FI modules;
- Training for 600 users engaged in the business of the new solution developed in the SAP R/3;
- Support after the entry of the developed programs in the system to the users engaged in the business;
- Process Mapping of cases involving issues relating to Audit Partner in Joint Ventures at PETROBRAS. Use of the taxonomy Aris in Visio;
- Process Mapping of cases involving issues relating to pointing costs in the SAP R/3, related to the Joint Venture at PETROBRAS. Use of the taxonomy Aris in Visio;
- Knowledge of the legal operation on partner solution, like: JOA, Accounting Procedure, Concession Contract and the Consortium Contract.
- Implement a new system of charging in the SAP R/3 System to the Partners of PETROBRAS in Joint Ventures;
- Functional specification to changes in the charging model to the Partners of PETROBRAS, in Joint Ventures, with emphasis on JVA and SD modules;
- Functional specification for the creation of exits in the SAP R/3, to meet the charging solutions to the Partners;
- Functional specification for the creation of the Charging to the Partners Report, in the SAP R/3 System, with emphasis in JVA and SD modules;
- Utilization of tables 'price list' in SAP R/3 at module SD;
- Participation in the Test of Development and Integrated Tests;
- Training to 30 engaged users in the new solution developed in SAP R/3 System;
- Support after the entry of the developed programs to the users engaged in the business.
Consultant
DXC Technology
2004.03 - 2005.12
- Projeto Indicadores BW
- Atuações:
- Develop strategic indicators to the Exploration & Production area at PETROBRAS, based in the SAP BW System;
- Development of queries and workbooks on BW-CO and BW-PS modules;
- Creation of financial indicators like ROCE (Return on Capital Employed), ROI (Return on Investment), GCO (Operating Cash Flow), CE (Cost of the Extraction of Oil) and CTPP (Total Cost of the Produced Oil);
- Creation of a Portal of Managerial Information, based on the SAP BW System;
- Training for 30 key users of the SAP BW System, using the Bex Analyzer and Query Designer.
Analyst
DXC Technology
2004.03 - 2005.12
- Projeto Suporte AMS SAP R/3
- Atuações:
- Support to user (help desk) and development to improvement in the SAP R/3 System;
- Attendance and solution of more than 1000 calls, with emphasis on modules FI-AP, FI-AR;
- Functional specification for development of the improvements after the implementation.
Formação acadêmica
Industrial Administration -
CEFET/RJ University (Centro Federal de Educação Tecnológica Celso Suckow da Fonseca)
BrazilHabilidades e competências
- SAC Planning
- Embedded Analytics
- SAP BPC Consolidation
- SAP BPC Planning
- SAP BW
- SAP BO
- SAP Lumira
- MS Power BI
- SAP JVA
- SAP FI
- Boa comunicação com a equipe
- Trabalho em equipe colaborativo
- Flexibilidade para lidar com mudanças
- Capacidade de aprendizado contínuo
- Conhecimento em processos operacionais
- Orientação para metas
- Responsabilidade e ética profissional
- Liderança para motivar equipes
- Postura profissional e confiável
Certificados
- SAP Certified Associate - Data Analyst - SAP Analytics Cloud, 01/2025
- SAP Certified Application Associate - SAP Analytics Cloud: Planning, 01/2022
- SAP Certified Application Associate – SAP BusinessObjects Planning and Consolidation 10.0, 01/2016
- SAP-BW Academy (Solution Consultant Certification – SAP NetWeaver ´04 – Business Intelligence), 01/2004
- Open SAP Course: Introduction to SAP Datasphere, 01/2023
- Open SAP Course: Planning with SAP Analytics Cloud, 01/2021
- Open SAP Course: SAP S/4HANA Embedded Analytics, 01/2021
- Open SAP Course: Getting Started with SAP Lumira, 01/2018
- Open SAP Course: Modern Data Warehousing with SAP BW/4HANA, 01/2018
- Curso Elaboração de Queries para Usuário-chave no Sistema SAP-BW, ministered by PETROBRAS S.A., 01/2004
- BOW310 - BusinessObjects Web Intelligence XI 3.0: Report Design, 01/2010
- BOW320 - BusinessObjects Web Intelligence XI 3.0: Advanced Report Design, 01/2010
- BOX310 - BusinessObjects Xcelsius 2008 Enterprise: Core & Connectivity, 01/2010
- BOU310 - BusinessObjects Universe Designer XI 3.0: Universe Design, 01/2010
- BOU320 - Business Objects Universe Designer XI 3.0: Adv.Univ. Design, 01/2010
- Training Course for Process Consultant, ministered by Instituto INSADI, 01/2008
Personalizado
- Silver Beacon Award / 'In recognition of your outstanding contributions, exemplifying our values and making a significant contribution to our business. Congratulations!'
- Reconhecimento por Valores / Liderança & Aspiração
Linha do tempo
Advisor / BI Leader / Sr Consultant
DXC Technology
2021.01 - 2023.12
Advisor / BI Leader / Sr Consultant
DXC Technology
2016.06 - 2026.01
Sr Consultant
DXC Technology
2010.01 - 2014.12
Sr Consultant
DXC Technology
2006.03 - 2009.12
Consultant
DXC Technology
2004.03 - 2005.12
Analyst
DXC Technology
2004.03 - 2005.12
Industrial Administration -
CEFET/RJ University (Centro Federal de Educação Tecnológica Celso Suckow da Fonseca)