SAP BW

Carlos Machado

Mobile: +55-41-919*-****

Skype: carlos.machado.1978

Email: *******.*****@*****.***

Professional Profile

An accomplished and detail oriented Global SAP BW/ABAP/HANA Senior Consultant with over 13 years of high quality corporate project management experience within areas of data warehouse, software development, product enhancement, end-to-end implementation, solution architect and business intelligence design measures. Offering expertise within high-profile industry sectors, including telecommunication, tobacco, food & beverage and oil & gas. Possesses considerable knowledge within multiple SAP environments including the configuration, development and implementation of BI/BW, ABAP, HANA, Dashboards (XCelsious), Qlickview, Tableu, Microstrategy and ERP solutions. Proven track record of continually implementing innovate solutions and providing successful troubleshooting measures, increasing productivity measures while decreasing costs. An excellent communicator, one who is able to effectively lead and motivate diverse, multicultural team members towards success while achieving common business goals. Demonstrates excellent attention to detail and employs superb organizational skills and finely honed analytical abilities.

Formal Qualifications

BAdI Development & BPC Execution

Web Intelligence Reports, Design & Deployment

ABAP Development

Integration & Date Integrity

HANA native development

SQL Script development

Strategic Planning

Universe Design and Creation

Education and Training

Bachelor

Master Degree

Training

Master Degree in Project Management (PMBOK) – Brazil (2016)

Bachelor Degree in System Analyst – Brazil (2003)

Certified SAP BW/BO - SAP

Certified Scrum Master Professional – Scrum.org

Certified ITIL Foundation – Exin

SAP HANA Academy – SAP

SAP HCM (PY) – In company – 30 hours

Data Analytics (Microstrategy, Tableau and Qlickview) – Udemy – 40 hours

SAP R3 Foundations (MM, SD and FI) – Trainning – 40 hours

SAP BO WebI – In company – 16 hours – 2014

SAP BO Dashboard – In company – 16 hours – 2014

ABAP/4 programming – In company – 16 hours - 2013

SAP Business Data Modeling -The Inteq Group – 16 hours – 2011 (Chicago-IL)

How to gather and document user requirements – The George Washington University – 24 hours – 2011 (Chicago-IL)

Facilitation Skills - In company – 16 hours – 2011

Programing with Microsoft .NET Framework using Visual Studio – Wise Training (Microsoft Gold Certified) – 40 hours – 2010

Presentation Skills – In company – 24 hours – 2009

.NET Framework 2.0 VB.NET – LACTEC (Microsoft Innovation Center) – 2008

Successful Software Development Process – In company – 20 hours – 2007

Individual Effectiveness Development Program (Introductory) – In company – 16 hours – 2007

Working globally – In company – 8 hours – 2007

Individual Effectiveness Development Program (Intermediate) – In company – 16 hours – 2007

Negotiation Skills – In company – 24 hours – 2007

Introduction to Oracle10g 2: PL/SQL, Procedures, Functions, Packages e Database Triggers - TargetTrust - 30 hours - 2005

Oracle Developer: Forms 6i – TargetTrust – 30 hours - 2005

Career Summary

Clients:

07/2013 - Present

Resource IT

Brazil Foods – Senior BW/ABAP Consultant

Worked extensively in creating and customizing Multiproviders, Info Cubes, Data Store Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process, APD’s, Open Hubs and Info Packages.

Extracted SD data (Data sources such as 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction.

Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.

Designed and developed process chains (RSPC) for master data loads and transaction data loads and these Process chains are scheduled for periodic loads.

Implemented ABAP routines on function module EXIT_SAPLRRS0_001 to handle variables in BEx reporting.

Created custom queries with Defined Calculated Key Figures, Restricted Key Figures, Variables, Conditions, Formulas, etc. For customized reporting using BEx Analyzer, BEx Query Designer. Designed and developed several web reports using web templates in Web Application Designer.

Large experience with Application Specific extractors (BW Content FI, HR, CO, SAP CRM, LO Cockpit), Customer-Generated Extractors (LIS, FI-SL, CO-PA) and Cross Application (Generic Extractors such as DB View, InfoSet, Function Module).

Created and customized Queries (reports) mainly for SD, FI, HR, MM, COPA and CRM.

Configured Datasource 1_CO_PA_CCA and performed COPA extraction

Provided Knowledge Transfer to the entry level employees. Monitored and evaluated their work.

Provided ABAP training to coworkers.

Developed some complex business rules by means of ABAP in update rules, start/end routines.

Involved in unit testing, QA, data validation, loading, created test scenarios, fixed the issues and collected and manage transport object to QA and Production.

Involved in BW cutover activities, this include production system build up, configuration, transport fix, master, transaction data loads, setup tables, initialization, delta loads.

Associated in the implementation of new KPI’s, which included Data Gathering, Gap Analysis, application specific Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Web Reporting

11/2011 – 07/2013

Wipro Technologies, SAP BI/BW Specialist/Team Lead

Acted as team lead of BW support team for by America Latin clients at British American Tobacco Company.

In charge of monitoring and keeping BW data loads up and running.

Responsible for new implementations quality assurance.

Applied SAP best practices to improve the modeling of data flows (using DTP, transformations, info packages, PSA’s and DSO’s) and ABAP routines.

Queries maintenance, customization and improvement.

Monitored and setup loads for SD module from R/3 source system.

Involved in frequent client meetings to discuss project status.

Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.

04/2006 – 11/2011

ExxonMobil Support Center, Support Analyst

Coordination of Intools application support team.

Problems and team activities management.

Development of knowledge base for support enhancement.

Responsible for the maintenance of a strategic global application used by more than 1000 oil refinery and chemical engineers around the globe.

Coordination of project IT activities for global projects.

Development and coordination of a system development project.

Acted as consultant for projects to perform data analyses.

Requirement elicitation and data modeling for global projects.

Utilized tools to perform the works above: SAP, ER Studio, Microsoft Visio, Microsoft SQL Server, Transact SQL, Oracle, PL/Sql, Access, Visual Basic.NET, ASP.NET, .NET Framework 1.1-3.5 and VBA.

05/2005 – 04/2006

Enabler Brasil, Support Analyst

Support and maintenance to Retek system (ERP – Application to manage retail companies).

Problem management as well as coordination of team activities.

Utilized tools to perform the works above: Oracle, Oracle Forms 6i, PL/Sql, C, Unix and ProC.

09/2002 – 04/2005

Votorantin Cimentos, System Analyst and Programmer

Played a key role on a project to customize Sysquali application, which is a workflow tool to evaluate, approve and share the company standard documents.

Acted as support and changes developer for the travel management system, legal contracts management system, telecom management system and tax management system.

Supervised and coordinated vendors on the various phases of an application development.

Utilized tools to perform the works above: SQL Server, Visual Basic, Transact SQL, MS Project and ASP.

01/2001 – 08/2002 InfoMatrix, System Analyst and Programmer

Responsible for the development and implementation of a tool to manage and share documents;

Participated as analyst and programmer in a project to develop a Workflow system to control the several phases and resources taken to approve new chemical products in Brazil.

Developed software to manage marketing campaigns creation workflow for a bank.

Utilized tools to perform the works above: SQL Server, Visual Basic, Transact SQL, MS Project, ASP, PHP, JSP, Java Script, Oracle, SQL plus, Java (J2SE / J2EE) and HTML.

Key Skills

IT

Developmental

Business Intelligence

Microsoft Word, Excel, Outlook, Access, Oracle, PowerPoint; Tableau

ABAP, C, C++, SQL, .NET, JAVA, User Exits, Customer Functions/Enhancement Projects, Javascript, HTML/XHTML,

FICO, FIGL, COPA, CRM, TRM, MM, P2P, SD, BI, BW, Consolidations

BI7.1, BI7.0, BW3.5, Data Warehouse/Sourcing, LIS, Custom Non-R/3 Extractors Development, Transports (ETL)

Contact this candidate