Power Data

Rafael Oliveira

Florida

RESUME: Keyrus **** / **21- Expertise in generating project insights (Industrial, Financial, Insurance, Technology and Telecommunications) using Microstrategy, BPMN and Power Bi Coca Cola Mjv - 18/19

Digital Transformation with Design Thinking, BPM Bizagi, SCRUM, Kanban, Modeling ETL - OLAP, Pentaho.

Dashboards in Tableau and Power Bi with focus on Google Analytics, Facebook Insights, SQL Server Database, Oracle,

SSIS and Salesforce . Indicator Management (KPI).

TIM - 2017 to 2018 -Marketing - Data Science ( Power Bi - Tableau - SAS) Dashboards for analysis and indicator management

(KPI) strategies to facilitate decision making by the Cia. Modeling - ETL, Database, SQL and SAS Guide

Oi -2007 to 2017 - Project Management, Financial Viability Assessment of Projects, DRE, Sox and Balance Scorecard ( BSC ) through Business Project at IBMEC Experience Management of Indicators, Processes and Budget ( Forecast ) GREENBELT 6SIGMA / PDCA Certification

SAP systems, SAS Guide, Tableau and Power Bi

Work Experience

Business Intelligence Consultant

KEYRUS

February 2019 to Present

Senior Business Intelligence Consultant - Performance in the IT area in generating business insights

( Marketshare, Network Engineering,

Telesales Service ) using experiences acquired in Multidisciplinary projects and Data visualization in the Power Bi and Tableau

Business Intelligence Consultant

The Coca-Cola Company (TCCC)

May 2018 to February 2019

Senior Data Scientist

Digital Transformation Data Scientist using Design Thinking, SCRUM, Kanban, ETL Data Modeling - OLAP (Star Schema) Pentaho. Expertise in building Dashboards on Tableau and Power Bi with a focus on Google

Analytics, SSIS and SSAS databases (SQL Server) and Salesforce in Indicator Management (KPIs) to facilitate decision making

decision of the Direction of the company

Business Intelligence Consultant

Tim

March 2017 to April 2018

Senior Marketing Consultant - TIM's Customer Relation, Mass Segment Prepaid, using Data science (Power Bi - Tableau - SAS) at

production of Dashboards, for analysis and Management of strategic Indicators (KPIs) of Recharge, Gross, Churn, Revenue.

Using Facebook Insights in order to contribute to strategic marketing decisions in order to capture new customers in the base and generate value for Company Senior BI Consultant

Oi

February 2007 to January 2017

Senior Bi Consultant - Performance in Budgetary Control - Financial (Forecast), Contingency, Project Management and Mapping of

Processes (BPM). Responsible for creating a tool for Simulation of Scenarios / Results and Indicators Backoffice ( Power Bi / Tableau / Dashboard ), based on SAS GUIDE - Report (DW), BO, SAP and Juris systems.

Action plans to improve Products / Services, to increase customer satisfaction and reduction of complaints.

I acquired skills in Statistics, Marketing / Strategic Planning, Budget Management, Profitability, Projects, Financial Viability Assessment of Projects (HP12C), DRE, Cash Flow, Sox and Balance Scorecard (BSC), through the

conducting a Business Project at (IBMEC-RJ).

Awarded in 2008 in the Green Belt Quality Project (6 SIGMA) - where I contributed to the profit of R $ 3 million through the construction of automatic fault correction in the Mobile network. Awarded in 2007 in the TOP Multidisciplinary Project - Green Belt, where I contributed to savings of R

$ 6 million due to

my expertise in Technologies to reduce the volume of calls in the IVR - Call Center and TMA Education

Bachelor of Business Administration

Skills

• Portuguese (10+ years)

• SQL (5 years)

• Power BI (5 years)

• Power BI (5 years)

• Tableau (5 years)

• Microsoft SQL Server (5 years)

• Data Warehouse (5 years)

• Requirements Gathering (5 years)

• Jira (5 years)

• Agile (5 years)

• SSIS (5 years)

• Azure (3 years)

• SAS (5 years)

• AWS (1 year)

• Scrum (4 years)

• Business Requirements (5 years)

• MySQL (5 years)

• Data Modeling (5 years)

• Oracle (5 years)

• Business Intelligence (10+ years)

Languages

• Portuguese - Fluent

• English - Expert

Military Service

Branch: Marine Corps Reserve

Service Country: Brazil

Certifications and Licenses

Lean Six Sigma Green Belt

Present

Contact this candidate