Fábio Carlos Pereira

Function (BI/BW/HANA/ABAP/) – Senior

adnbgo@r.postjobfree.com +55-11-991**-****

Mini CV

Experienced in process automation and systems integration, combining several IT technologies as SAP BW/HANA specialist. Experience in projects deployment, migration, upgrade and support in the main Modules ECC and S4/HANA (SD, MM, FI, PP, PS, PM and others) and extensively with IS-U (CCS) where the large volume of data requires Analytical tools such as BW and HANA 2.0 Native Development in conjunction with PowerBI and Excel (Bex) and Snowflake Cloud Data warehouse.

Business areas: Services, Metallurgy, Telecom, Pharmaceutical, Retail, Mining, Utilities, OIL.

Professional with 25+ year’s extensive IT experience, including SAP R/3 BI/BW/HANA ABAP 7.5. Work Remotely or move to USA (sponsorship needed)

Hard Skills

SAP BW powered by SAP HANA

SAC – Analytics Cloud – HANA Modeling in Eclipse

SNOWFLAKE – Cloud Data warehouse

Google Cloud, AWS deployment Knowledge

AZURE Dev OPS Knowledge

MS Power BI: Analytics Dashboards, ETL, DAX, Query’s, Reports.

ABAP 7.5 Development for SAP HANA

Agile methodology skills

CDS Views, Calculated Views, AMDP on HANA

SAP HANA 2.0 Data Modeling and XSA Development

DataSources, Extractors Function Modules, Infoobjects, Infosources, ODS, Cubes, Multicores, Transfer Rules, Update Rules, Formulas Transformations and Object oriented ABAPs, Process Chain, Jobs scheduling, BW generic datasources.

Bex Analyzer, Query Designer, WAD, SAP Portal iView, MS EXCEL-VBA.

Modeling: Info Objects, Info object Catalogs, Info cubes, DSO objects, Info Sets, Multi Providers, Application Component, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP)

Extractions: Used Business Content extensively, loaded statistical data using (BC) Technical Content. Extracted data from ECC, classification system, through Web service and Flat File. LO Cockpit Extraction, Generic Extraction, Flat file Extraction for Master data and Transactional data, and Activating Data structure, transporting data sources, customizing and Enhancement of Extract.

Scheduling: Creation of Batch process and scheduling load jobs in parallel. Process Chain Maintenance

Reporting: Expertise in Reporting with Business Explorer using BEx Analyzer, BEx Query Designer, Web Application Designer, Condition Reporting, Exception highlighting, developed Queries, queries using Filters, Free Characteristics, Calculated Key figures, and Restricted Key figures, Variables, Structures.

ABAP 7.5 Development for SAP HANA

Performance and dump analysis / tests and program debugging.

SAP: R/3 e ECC 6.0 CRM 5.0 SRM 5.0 SRM 7.0, Workflow, S4/HANA, FIORI

Modules: SD, MM, FI, CO, PP, IS-U, CCS

Education

Business Administration – UNISA /2010

Physics Institute of São Paulo University (USP): Physics (3 years) / 1998

Experience

Client Exxon Mobil

Role Consultant SAP BW / HANA XSA - Snowflake

Environment Azure Dev Ops – SAP WEBIDE – HANA 2.0

Start SET/2020

End till now

Description SAP- HANA XSA Developer

Responsibilities:

Snowflake Developer

Developed SAP HANA – XSA application for manual data entry to centralized database.

Worked on Cloud Data warehouse (Snowflake), integrating PowerBI and Tableau.

WEBIDE – Developed Procedures, Calculation Views, Table Functions, for UI5, Power BI e Tableau.

Worked in MS AZURE Dev Ops environment integrated to SAP HANA 2.0.

Solution Manager and Charm change request for SAP HANA objects.

Client Techmahindra (ENDE - Angola)

Role SAP BW/HANA/ABAP

Environment S4/HANA – IS-U EHP8 - BW 7.5 on HANA 2.0

Start SET/2016

End AUG/2020

Description SAP-Utilities

Responsibilities:

Worked in 2 Full cycle implementation of S4HANA IS-U and BW powered by HANA including conducting Blueprint / Design for one or more processes.

Worked Extensively on BW powered by HANA Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders.

Designed Query’s in BW for MS-EXCEL - BEX and PowerBI Dashboards.

Developing Bex Analyzer Reports for Invoicing, Billing, Sales statistics, Financial Control (Simple Finance), Costs, FI-CA Control.

Design and data modeling of custom artifacts like Calculated Views in HANA 2.0 using WEBIDE – XSA.

Involved in provide OData (XSOdata) service in HANA 2.0 for third party application.

Developed CDS Views, AMDP using HANA Studio

Developed Custom Generic Datasources using Eclipse tools.

Designed and modeled Data flow using DTP, transformations, ADSO, Start Routines using Eclipse BW tools.

Created BODS export by ODP.

Created Kpi s for Launchpad in SAP Cloud Platform.

Setup and monitored collective run jobs for SD, MM, FI and others.

Resolved Customer reported tickets through email and phone.

Involved in solving the tickets regarding extractions, Performance Issues and also load failures.

Client Elektro Energy-Brazil/CEMAR

Role SAP BW/HANA/ABAP Consultant

Environment ECC 7.0 – BW/HANA- 7.4

Duration MAR/2015- JAN/2016

Description Utilities – MCSE – ANEEL – NEW GL

Responsibilities:

Worked in Full Cycle BW powered by HANA delivery.

Involved in Financial NEW GL Implementation of Specialized Chart of Accounts for Energy area. Created Finance NEW GL, Data Flow (ETL- Extractors, Transformations, DSO’s, Cubes e Multi providers).

Created Monthly Balance Queries using Bex Analyzer Reports.

Developed ABAP routines for Transformations, structures Appends, Extractors Enhancements 3FI_GL_XX_SI (Line Items) e 3FI_GL_XX_TT (Totals), including PS and AA data,

Developed Generic Extractors.

Managed BW ETL Integration to third party applications SQL server.

Modeled CDS Views in HANA Studio.

Publication of Queries and Reports on SAP PORTAL Netweaver.

Developed XML files export using MS-EXCEL VBA in BEX Query Analyzer.

Created Finance Reports (Aging, Accounts Payable, Accounts Receivable) using Bex Analyzer.

Client EDP- Energy of Portugal

Role SAP BW/ABAP Consultant

Environment ECC 7.0 – BW-NetWeaver - 7.3

Duration OCT/2014 - MAR/2015

Description Utilities – MCSE - ANEEL

Responsibilities:

Developed Specialized Chart of Accounts for Energy area,

Installed Bi content for FI-AR (Accounts Receivable),

Setup SD-Billing (2LIS-13), creation of (ETL- Extractors, Transformations, DSO’s, Cubes and Multi providers).

Designed and created Billing and Accounts Receivable Queries.

Developed Transformations ABAP routines, structures Appends, Extractors Enhancements to include PS and AA data, Generic Extractors.

Project: Vale One Americas

Client: Vale do Rio Doce - RJ

Duration: Jun/2013 – Oct/2014

Role: SAP ABAP Developer/BW Analyst

Environment: SAP BW 7.0/ECC 7.0

Description: Upgrade of existing Solution on Mining for SD MM PP

Responsibilities:

Create Inbound and Outbound PI Proxy interfaces for legacy system communications. Develop User-Exits, RICEF’s, Abap Objects, Tests support and Go-Live. Work flow maintenance (PO Approval and Contract Approval). TIBICO integration.

Webservices creation for mobile app.

Automation in ABAP for Procure to Pay - Goods receipt, Invoice Verification and Vendor payment.

Automation in ABAP to Order to Cash – Sales Order Creation based on Purchase Order

Developed BW Generic extractors using Function Modules and ETL

Client Agricola Xingu

Role SAP WORKFLOW-FIORI Power BI

Environment ECC 7.0 –

Start JAN/2016

End SET/2016

Description SAP-ACM-Workflow-FIORI Power BI

Responsibilities:

Company code split data migration and SAP ACM implementation. Created Custom Workflow for Logistics approval, created Custom Workflow for Purchase Orders approval, Custom Workflow for Purchase Requisitions approval and Custom Workflow for Invoicing approval. BADI’s implementation for Workflow approvals via SAP FIORI.

Automation to Order to Cash interfaces in ABAP for Sales Orders and invoicing automation trigger by legacy application GEATEC (Agro-busyness). PowerBI Dashboards using BW Open HUB.

Project: Project IDF – SRM-MM-BW

Client: BRASKEM

Duration: Apr/2013 – Jun/2013

Role: SAP ABAP Developer/BW Analyst

Environment: SAP BW 7.0/ECC 7.0

Description: Implement SRM 7.0 ABAP – BW with MM QM data.

Responsibilities:

Migrate DSO’s, Cubes, and SRM MM Std. extractors and Generic extractors to calculate Vendors index. Optimization and survey of transfer rules, formulas transformations and ABAP. Replacement of generic extractors by standard extractors.

Project: Itautec – Robot PP

Client: Itautec

Duration: April 2012 – April 2013

Role: SAP ABAP Developer/BW Analyst

Environment: SAP BW 7.0/ECC 7.0

Description: Implement / Maintain BW reports, PP MM SD Custom programs.

Responsibilities:

Maintenance of existing SAP BW reports. Data Sources, Function Extractors, Infoobjects, Infosources, ODS, Cubes, Multproviders, Transfer Rules, Update Rules, Transformation formulas, Object oriented ABAP, Process Chain, Jobs scheduling.

Custom extractor’s creation, Bex Analyzer, Query Designer, and users support.

Designed and developed ABAP ALV reporting programs and function modules, RFCs, interfaces for PP SD MM modules in order to integrate equipment serial numbers and Microsoft Software licenses. Multimedia GUI Interface for bar code reading.

Developed SD interfaces integrating Ecommerce Web Portal creating Sales Orders and Customers Masters Data.

Project: Vicon Maq NFe

Client: Vicon Maq

Duration: March 2011 – November 2011

Role: SAP ABAP Developer/Delphi Analyst

Environment: SAP ECC 5.0 – Delphi 7.0

Description: NF-e ECC 5.0 integration to Delphi Legacy

Responsibilities:

Designed and developed ABAP Interfaces to integrate legacy program, reporting programs and function modules, NF-e for SAP SD module.

Project: IBM Worldwide FIT SAP

Client: IBM

Duration: January 2007 – March 2011

Role: SAP ABAP Developer/Analyst

Environment: SAP R/3 - 4.7 Unicode 5.0

Description:

IBM's Worldwide FIT SAP Finance Team supports general ledger, fixed assets, and project systems, which integrates with several IBM SAP systems including Material Master Lead Client. This part of the project includes designing, developing, updating, and testing custom components, as required for the new SAP R/3 system (Unicode environment), to meet business logic changes and revised standards, and to improve runtime performance.

Responsibilities:

Design and develop ABAP ALV reporting programs, function modules, BAPIs, RFCs in SAP Unicode system integrated with web applications. Implement financial solutions to handle web application requests by RFC and IDocs, providing ALV reporting programs and management routines, regarding IBM financials, integrated to web application. Demonstrate ABAP ALV reporting programs to architects, managers, web team leads, web developers, functional leads, function team members, and other ABAPers. Train other ABAP team members in ABAP/ALV and other design/development techniques. Create technical specifications. Lead daily Net Meetings for eTools Team.

Project: IBM – Ericsson – MP135

Client: Ericsson

Duration: July 2006 – December 2006

Role: SAP ABAP Developer/Analyst

Environment: SAP R/3 - ECC 5.0

Description: Implementation of tax localization laws in SAP system.

Responsibilities:

Designed and developed new ABAP ALV reporting programs, RFC interfaces, and SAP Scripts regarding legal requirements, according to client and IBM standards and methodology. Designed and developed BADIs and enhancements for MM and processes. Created functional specifications and technical specifications.

Project: Hot Line

Client: Cooper Tools (USA) and Decathlon (France)

Duration: June – July 2006

Role: SAP ABAP Developer/Analyst

Environment: SAP R/3 - 3.1h, 4.0, 4.6, and ECC 5.0

Description:

Decathlon, a French Sports Store with operations worldwide, implemented ECC 5.0 with ABAP Objects to meet evolving legal standards.

Responsibilities:

Cooper Tools, an American Tools manufacturer located in Socoraba, Brazil, wanted to bridge the gap between several SAP systems: 3.1h through 4.6.

Designed and developed ABAP ALV reporting programs and function modules, RFCs, interfaces, SAP Scripts, SmartForms, for all SAP modules, for clients in several countries.

Project: Banco FOX

Client: Lojas Marisa

Duration: March – June 2006

Role: SAP ABAP Developer/Analyst

Environment: SAP ECC 5.0 – CRM 5.0- Java

Description: Banco Fox Implementation of ECC 5.0 modules FI, FS (CML and CFM)

Responsibilities:

Designed and developed ABAP ALV reporting programs and function modules for contracts interest calculation, RFCs, enhancements, user exits, using ABAP Objects, achieving JAVA front-end integration with SAP FI/FS module. OO Interfaces CRM and Remote enabled RFC s for Java Legacy front-end.

Project: Decathlon

Client: Decathlon (France)

Duration: January - March 2006

Role: SAP ABAP Developer/Analyst

Environment: ECC 5.0 – CRM 5.0 - JAVA

Description: Implementation ECC 5.0 – ABAP Objects

Responsibilities:

Designed and developed ABAP ALV reporting programs and function modules, SAP Scripts, SmartForms, conversions, interfaces, for SD module. Maintain BSP UI in CRM, design CRM RFC s and interfaces for Java Legacy. Identifying the various object types and objects in the customer namespace in CRM.

Project: Embraer - Nashville

Client: Embraer - Nashville, Tennessee

Duration: December 2005 – January 2006

Role: SAP ABAP Developer/Analyst

Environment: SAP 4.7

Description: SAP 4.7 Implementation

Responsibilities:

Designed and developed ABAP ALV reporting programs and function modules, SAP Scripts & SmartForms for SAP modules PP, FI and SD.

Project: SAP R/3 4.7

Client: Bosch Brazil - São Paulo

Duration: August - December 2005

Role: SAP ABAP Developer/Analyst

Environment: SAP R/3 4.7

Description:

Implementation of SAP R/3 version 4.7 in one of Bosch s branches in São Paulo, in accordance with other branches in Brazil that already had SAP running in production. This project was supervised by Bosch headquarters in Germany.

Responsibilities:

Designed and developed ABAP ALV reporting programs and function modules, SAP Scripts, SmartForms, interfaces, enhancements, user exits for Bosch Brazil and Germany.

Project: SAP R/3 Upgrade from Version 4.0 to 4.7

Client: Embraer Aeroespacial, São José dos Campos, São Paulo

Duration: July 2004 – July 2005

Role: SAP ABAP Developer/Analyst

Environment: SAP R/3 4.0, 4.7

Description:

Upgrade from SAP R/3 4.0 to version 4.7 including new MRP features. This project to control warranty and maintenance of aircrafts (ALV reporting, module pools, screen exits).

Responsibilities:

Designed and developed ABAP ALV reporting programs and function modules, online dialog programs, enhancements, screen exits, SAP Scripts, SmartForms

.

Project: ERP System for integration with JD Edwards

Client: N&W Global Vending, São Paulo

Duration: March 2001 – June 2006

Role: ERP Developer/Analyst

Description:

Designed and developed ERP system for integration with JD Edwards ERP system.

Additional IT project experience available upon request.

Technical Training

SAP BW powered by SAP HANA - SAP

ABAP Development for SAP HANA – SAP

Snowflake Cloud Data warehouse - ExxonMobil

Academia - SAP BW Netweaver 7.0 – Training Educations Services

Work Flow – Pimentel It Services ABR/2006

Solution Manager Overview – Pimentel It Services – JAN/2005

ABAP Objects – Pimentel It Services- JAN/2006

Desenvolvimento de (ALV reports, SapScript,SmartForms)– SAP/R3 -Fev/2005

Desenvolvimento de (Screen Exits, Funções, Call Transaction, Module Pool) Out/2004

Academia ABAP SAP/R3 - Jul/2004

Java Básico – Pimentel It Services MAI/2006

Certificação Conectiva Linux. – (2001)

Certificates

SAP BW/4HANA in a Nutshell (bw4h1) – Nov/2016

ABAP Development for SAP HANA (a4h1) – Out/2014

Languages

Portuguese: (Native)

English: (Fluent)

Spanish; (Intermediate)

Contact this candidate