SAP BW Consultant

Academic Background

• Master degree in Software Engineering in IPT- Instituto de Pesquisas Tecnológicas/USP (Study on the influence of the user's profile in the inteligibility of the Datawarehouse interfaces, January 2007)
• Graduate Course (latus sensu) - Administration  - 1991
• Bachelors Degree in Administration (focused in Systems Analysis) - FASP - Faculdades Associadas de São Paulo (1987)

Main Qualifications             

• Over than 17 years of experience as an IT consultant of which over 10 years of experience as a SAP Technical Developer BW with working knowledge in application, integration and implementation in several projects and industries. Experience with data modeling, processes mapping, great SW engineering knowledge, business intelligence (SAP – Business Information Warehouse) concepts and practice as well.
• The career has been developed in a consultant agency, national and multinational, with a proposal  of analyze and search a customer solution, in a several market segment like a: Telco, Industry, Oil & gas, Pharma, Hospital, Tobacco, Drink, Communication, Bank, Utilities, Commercial, Retail, Automotive Industry, Steel Industry, Food Industry.
• Strong experience in more than one full SAP project life cycle end to end (blueprint through to go-live), support level 3 and rollout experience.
• Over than 10 years of Hands-on experience working in SAP BI Developer will be responsible for the design, development, unit testing and support of the SAP Netweaver BW 7.x ( and older versions) for Operational and Analytical reporting solutions using SAP BO across several SAP modules including HR: PA-PA,BN ,PA-OM, FI/CO (GL, New GL,  AA,  AR, AP), Logistics: SD, MM, PS, PP, CRM, TRM, CLM,TRM,PM, QM and Integration module BPC, BCS, SEM; SRM, PI using Solution Manager(SOLMAN); BI- IP;  integration with SAP and Non SAP data sources. 
• Solid knowledge and experience working closely with Business users, Functional Analysts, Developers and System Engineers to resolve issues, analyze Business requirements and implement BW Data Models and BO solutions to address the reporting needs.
• Develop and maintain thorough understanding of the Best practices of SAP BW Modelling and Implementation methodologies, Query Design techniques, follow existing standards and resolve issues in a timely manner. 
• Build and Enhance the BI metadata object repository including Infocubes, DSOs, Multi-providers, Infosets, Virtual and Hybrid Providers relevant to reporting needs in areas of SAP HR, FI, and Logistics.
• Activate and Enhance Standard SAP BI content as relevant to the reporting requirements. 
• Analyze and configure the BI Solutions to facilitate Operational and Analytical reporting. 
• Develop Data Flows, BW structures and support the ETL processes for loading data into BW and BPC Info-providers. 
• Troubleshoot existing data models, transformation routines, process chains and BEX queries to address performance / data load issues. 
• Ability to explain technology issues and work progress to both technical and non-technical staff. 
• Support the SAP team during system testing, interacting with functional business analysts to define and clarify system specifications. 
• Coordination and customization of the systems implementation.
• Management of the administrative area, including negotiation and control of all contracts with third parties, rent, facilities maintenance, attorneys, communication and legal documentation (contracts).
• Management skills: experience with multidisciplinary teams (Brazil & Argentina & Holland & Indian). Ability and flexibility to quickly learn new applications and software
• Solid organization, time management, and project estimating skills
• Ability to handle multiple projects simultaneously, with attention to detail and closure
• Experience over than 9 full lifecycle implementations of SAP Netweaver BW, Experience in translate Business requirements into Business Warehouse and/or Business Objects solutions (BBP) till go live and support systems.
• Experience with creating and managing complex Process chains
• Experience with developing and Build BEX queries for reporting and analysis for feeding data into SAP BO for delivering BO platform solutions including Analysis for Excel, WebBI reports and Dashboards. 
• Experience with Data Extraction and Loading; experience in data migration and version migration BW 3.x to 7.4 – datasources conversion, mapping, etc.
• Excellent communication and analytical skills; skill in the relationship with users in several hierarchical levels; easy interpersonal relationship; easy adaptation to different processes; Capacity to adapt to constantly changing environments; excellent capacity to work and to lead groups of professionals; quick in the problems solution and focused in results are items that complete my professional profile.

Professional background
NBCC Consulting / HP DXC (Apr/17 to Jun/17)
REN Rede Eléctrica Nacional, S.A., Lisboa - Portugal
Main Responsibilities:

• Consulting services for call and problem solving, development of improvements, fixes, testing and deployment of systems BI BW. Responsible for preparation and monitoring of schedules SLA's using HPSM software for tracking calls. BO Reports maintained WEBI. Process Chain resolutions problems and monitoring. SAP BW v 7.4

Caelum Solutions. (January 2017)
HIKMA PHARMACEUTICALS – SAP BW Training – Amman, Jordan
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for elaboration BW training, schedule training, training development including follow topics: Introduction BW, BW Architecture, Naming Conventions, Data Modeling (ER x Star Schema), Roadmap to create/maintain Infoobject, Infoproviders, ETL ( standard datasource, flat file, generic)BCT, Authorization & Security, Performance, Bex Analyzer, Workbook, Query Designer, Process Chain, APD. All the topics include concepts and Practice. BW 7.4 version

T-Systems/ ABC Technology (Nov/16 to Dec/16))
HONDA – Price Control Project – Technical report
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for Technical report preparation to identify and mapping GAPS found in the Price Control System.,interface IP, Webdynpro.

T-Systems/ ABC Technology (Oct/16)
Lactalis - Project EquilibriUM - Rollout
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Rollout for Lactalis company to create new company code, development of data load,  test run / change Process Chain, validation of queries.

Engineering do Brasil/ Ultracon (Oct/16)
SGD Brasil Vidros(Glass) – SAP BW Key Users Training
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for elaboration of material training and training development for key users BW encompassing leveling concepts, BW overview and navigability of web reports.

LCA Informática  (from Feb/16 till Jul/16)
Ferrero Roche - Sales Reporting Brasil / BBP / Rollout BO - Argentina
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Working with a Global team company,  responsible for  mapping Sell In & Out model and BBP elaboration for new KPI´s Sales Reporting Brazil, environment architecture; necessary requirements – Report and Query Development with BO - WEBI. Documentation and specification mapping. Integration Data Service with sytems BIS, SID, Planning, PV systems and SAP - SD. Planning Integration Test, UAT, test script´s elaboration. Plan for Rollout for BO Argentina. Integration with local DW – DataWaherouse SQL Server. PM module:  report analysis, data load checking, WEBI Development.

Tata Consultancy Services/ Assurance – (from Sep/15 till nov/15)
CSN – Companhia Siderúrgica Nacional – Fusão Mineração Project / BBP module PP - ARCOS
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for mapping and check EDW environment architecture; necessary requirements for  Fusão Mineração implementation and  new company, Development: cutover planning; Test Plan. Maintain abap program. Development of the Blueprint phase Fusão Mineração implementation. Infoareas CO, MM, PP, PM, SD, FI. BBP module PP new plant ARCOS, with integration systems MES, GEE, PI and Cognus Planning IBM.

InfoA2 – (from Apr/15 till Aug/2015)
Groupe SEB – ARNO – Frente Melhorias Recife New Plant/ DAT warehouse/ Rollout PW8 to PW1
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for mapping and check EDW environment architecture; Process Chain monitoring; necessary requeriments implementation´s Recife New Plant and DAT, Cutover planning; Test Plan. Development of the Blueprint phase Recife´s New Plant implementation. Monitoring PC. Support process chain  monitoring solving data loading problems.  Customizing/maintanance Web Dynpro programm.

Blend IT – (from Jan/15 to Marc/15)
Aço Cearense – primer Softtek - Project: Mais Sinergia – Frente Melhorias
Current Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Consultancies for improvement; EDW environment architecture; Multidimensional modeling; ETL processes; activation and treatment Business content; Surveying and mapping information; Creating generic extractors and extensions; Making queries using Bex Analyzer and Query Designer; documentation and training materials; Design documentation. BW version 7.3.1, FI modules, SD, MM, SOLMAN.

Engineering do Brasil. – (from Nov/13 to Jul/14)
TIM (Telco) / VGB / CSN  
Position: Consultant SAP BI BW/BO
Main Responsibilities:

• Responsible for BW QA, test and transportation data, Cutover Plan, BCT activation; Project PM. BW 7.4 BBP documentation. Requirements gathering / detail / documentation information for Implementation, Test and Transportation. Module TRM, Ciclo Passivo. Analyze BO reports, publish at portal.

ThewhIteam – (from  Aug/13 to Oct/13)
 Project for Leo Madeiras
Position: SAP BI BW/BO
Main Responsabilities:

• Functional analyst responsible for evaluating, and defining business process/requirements. Responsible for business process mapping for adjustment and development change requests. Report development  BW BO -Project support pos Golive. Development of enhancements.

Infosys Ltda – (from  Jun/11 to Aug/13)
 Project Support for Syngenta/ Benteler
Position: SAP BI BW/BO
Main Responsabilities:

• Responsible for requirements gathering / detail / documentation information for knowledge transfer - KT BI Brazil, development / implementation of test scripts version migration SAP. Consulting services for call and problem solving, development of improvements, fixes, testing and deployment of systems BI BW. Preparation of queries. Preparation and monitoring of schedules SLA's using HSPM software for tracking calls. BEXanalyzer key user´s traning and version migration 7.x. Development of enhancements.
• Management and development of Benteler´s Rollout: Responsible for Planning and coordination of rollout template for Brazil, modules FI, MM, and SD.

Logica – (from Oct/10 to Apr/11)
 Project Support for Comgás and Bandeirante
Position: SAP BI BW/BO Project Lider
Main Responsabilities:

• Responsible for Coordination carried forward to answering call (AM) problem solving, development of improvements and Development of enhancements, testing and deployment of BI BW BO. Preparation and monitoring of training schedule ITIL training, SLA's using Remedy software for tracking calls.

CPMBraxis – (Free Lancer Consultant - occasional for a couple of month)
 Project Support for Project Integra and Support Syngenta
Position: SAP BI BW
Main Responsabilities:

• Consulting services for call and problem solving, development of improvements, fixes, testing and deployment of systems BI BW. Preparation of queries. Analysis, applying SAP notes. Specifications for ABAP customization BW: routnes end; start routines; features. Infoset maintenance. ECC6/ BI 7.0.

HONDA – (from Sep/09 to Jul/10)
 Project Price Simulation
Position: SAP BI BW/BO Project Lider
Main Responsabilities:

• Consulting done for fixe, testing and deploying BI systems to perform simulations of IP prices from external sources with loads via flat file, web service, PI. BI 7.0. Specifications for ABAP customization BW: End routines, routines start, features, creation of extractors for Views; extension extractors. Report Designer to making letter to vendor.. Preparation of queries, maintenance of web designer. IP: modeling, settings: creating level of aggregation, filters, variables, functions of planning (standard) variables. Portal: Creation of iViews, Roles, Worksets.

GERDAU – (from Nov/08 to Mar/09)
 Project Vendor avaliation
Position: SAP BI BW
Main Responsabilities:

• Designed DM and solution for new key figures (KPI´s) to analyze the vendor performance using layer EDW. Module: MM; QM. Integration of SRM / R/3. BI 7.0.

Votorantim – (from Sep/08 to Nov/08)
Votorantin Project 4 Maximização and Project Maximizacao VM and VE
Position: SAP BI BW
Main Responsabilities:

• Project 4 Maximização: Responsible for Designed Data Modeling and soluction for new implementation or to Customizing. First module: Logistic – LES Transportation. Conducting a workshops to analyze requiriments. BW  BI 7.0 Instructor. Development of enhancements
• Project Maximizacao VM and VE: Responsible for Designed solution and data modeling, customizing BW; module CO; CCA; PC; MM.

Philips Ligthing – (from Nov/07 to Jun/08)
Project Diamond
Position: SAP BI BW
Main Responsabilities:

• Responsible for Rooll out a global template for South America ( Brazil). Training in Eindhoven, Netherlands – Holland to understanding a global templates and business report solution for the modules SD- Sales, FI - Finance, SCM - Supplay Chain. Integration Analyzes with a DW regional. Generation of CR – Change Requests; planning and execution of Change Managers training and Key Users. Colaboration helping in R/3 Authorisation, creation of groups, creation of R/3users, mapping roles for BW and R/3.  BW v.7.0.

Souza Cruz – (from Sep/07 to Nov/07)
Souza Cruz – BAT (British American Tobacco)
Position: SAP BI BW
Main Responsabilities:

• Project Talent: Responsible for a Workshop presentation about BW conceptions. Designed Data Modeling solution modules HR: PA-PA, BN, PA-OM. BW 3.5.
• Project Vision RH:  Responsible for Solution Analyze of BW, preparing a documentation of GAP’s between BCT x Implementation Module.
• Workshop BW, training of concepts for GERDAU – 1 week 

Louis Dreyfus – (from Oct/06 to Jun/06)
Project Bossa Nova
Position: SAP BI BW
Main Responsabilities:

• Responsible for Designed Data Modeling solution modules GL (new GL), MM, CO, PS, AA; a BCS integration solution, Process Chain creation/manutence. ECC6 – BW 3.5.

ProcWork -Aspen – (from Feb/04 to Oct/06)
Project Handover SD / Project Margem de Venda / Project Cockpit Key figures/ Integration Project
Position: SAP BI BW
Main Responsabilities:

• Transpetro – Handover SD

Handover modules GL, MM. Production support. Process Chain maintenance. BW 3.5.

• Petrobras - Project Margem de Venda

Designed data modeling solution, Blueprint, used modules CO-PA,MM, SD, solution design with a SEM BPC integration.

• Robert Bosch – Project Cockpit Key figures 

Designed info cubes for FI_AP, FI_AR, GL. Activated Infocube and creation.Modified Update rules, transfer rules, update routines, and transfer routines as per client requirements.
Created Update rules for the key figures of Info Objects that is updated in the Info Cubes from the communication structure of Info Source.  Created Custom Info Object Catalogues for Characteristics and Key figures for Info area. Created BEx Reports, WEB templates, Queries for the required account payable order queries

• Bradesco – Integration Project

Responsible for configuration of BW by identifying the Info Objects, Info Sources, Info Cubes, ODS and Business Contents for FI (AP, GL, TV), MM (Purchasing). Loaded transaction data and initialized deltas for FI Line Items and transaction data.
Customized vendor master data to add Minority Indicator and created various custom reports for FI Line Items.  Responsible for the implementation infocubes creation, infopackages, infosources, generic datasources, Update rules, etc. Queries development. BW interfaces by TXT files, R/3 v. 3.x, BW 3.1, 3.5. Info-cubes documentation, end user training and remote support. Configured, Customized and Tested Basic Cubes, MultiCubes and ODS Objects
FINO – (Free Lancer Dec/2003)
Project PP
Position: SAP BI BW
Main Responsabilities:

• Responsible for Business Content Infoproviders for module PP were activated and loaded. Info-cubes documentation

Suzano Bahia Sul Celulose – (from Jan/03 to Feb/03)
Project Queries
Position: SAP BI BW
Main Responsabilities:

• Responsible for Developed different queries for Cash Flow, building Queries , maintain infocubes, infopackages, infosources, Datasources replication Hierarchic BW

Souza Cruz– (from Sep/03 to Nov/03)
Project Queries
Position: SAP BI BW
Main Responsabilities:

• Responsible for Data Modeling– Design and implementation of Standard model or customizing. (ODS, Cube, Multicube, Infosources, Infoobject Maintain, Update rules, Transfer Rules, Master data, InfoPackage, Mapping, Queries development - Reporting – Business Explorer Analyzer ( creation of Variables of  Formule, Variables of Selection, structures, using as source, cubes of PP, MM ,CO  and flat-files.
• Analyzed business reporting requirements that could be satisfied by Business content info cubes

BCP Telecomunicações (CLARO) – (from Jun/00 to Jun/02)
Project Data Warehouse Implementation and SAP BW Implementation (SD/MM)
Position: SAP BI BW Project Lider/Coordinator DW
Main Responsabilities:

• Responsible for building Info Cubes for modules: SD, MM.
• Responsible for building models using SAP BW ,  raising of indicators, Modeling of INFOCUBES, information configuration at BW  and writing of Reports(Query), responsible for the implantation of the Sales and Stock front using as sources  modules SAP : SD, MM , flat files .
• Coordination/ Modeling/restructuring/ implantation of the process of Data Warehousing (DW) – Dimensional Modeling and Model CRM, Modeling of Data Mart´s departments. Development of Reports for DataWarehouse in tool Microstrategy v6 e v.7, for the mapping and writing of reports;
• Coordination of training; training for Heavy Users in Data Warehouse and Data Mart’s Department. Microstrategy, Impromptu - Cognos, SQL, Data Model CRM – relational - and Dimentional Modeling.
• Definition and implementation of the metrics based in the definition of business concepts and rules.
• Development of interface DataWarehouse with SAP, module CO-PA
• Definition of business concepts and rules for the users.

Languages:

• Portuguese ( Native)
• English – Fluent (Written, listening and conversation).
• Spanish – Basic.
• Italian – Basic (good understanding and reading).

Courses:

• Data Modeling expertise ( star schema ,snow flake - DW) and relational modeling
• Good skills with process mapping and business analyst
• End user (BW) and developers training.
• SAP BO 4.1 - BI Launch Pad, Dashboard Design, Web Intelligence
• SAP: SAP BW310 SAP BW DATA WAREHOUSING
• SAP: BW305 - Enterprise Reporting, Query & Analysis
• BCP Training: Reports,, Analyzer
• Training at Plaut: SAP Solution Manager (SOLMAN)
• Training SAP ABAP p/ BW
• PMI Project Management, PMI/PMO.
• ITL
• HANA – e-Learning course: SAP HANA Basics; SAP HANA Modeling; HANA Migration BW to BW ,Hana Studio
• Data Base: DB2, Oracle, Teradata,  Sybase, SQLServer, Adabas , RedBrick

Tools CASE: Erwin V3.5.2, V4.1, Microstrategy V 7.2; Oracle Case Designer/2000 older versions, BpWin, S-Designor 5.0, Power Builder, System