Rafael C. Bastida Email & Phone Number

State Of São Paulo, Brazil

Brazil

- Working for multinational data consulting company in the Management Consulting business unit dealing with business transformation initiatives covering topics about Data Strategy, Data Governance, Data Architecture and Data Culture.- Leading projects related to data assessments and information maturity across different industries (insurance, pharmaceuticals, seeds & crops, manufacturing).- Interviewing different stakeholders (from senior leadership to operational roles) to understand pain points, data needs and opportunities (data insights, data-driven decision making, processes automation, use cases).- Consolidating business, technology, and leadership requirements into strategic action plans (roadmap and investment).- Analyzing global data guidelines, ensuring seamless integration at local offices.- Delivering impactful executive presentations addressing data concepts and company strategy

São Paulo, São Paulo, Brazil

- Worked for clothing retailing group Restoque SA, consisting of brands Le Lis Blanc, John John, Dudalina, Bo.Bô, Rosa Chá and Individual. Being part of the Competitive Intelligence team and reporting to the department Senior Manager.- Providing consulting services for strategic data solutions.- Helping structure CRM data processes and reports.- Supporting different areas in the company (store operations, brand operations, CRM, finance) with ad-hoc and canned reports.Stack: PowerBI, Databricks, MS SQL, Microsoft Azure, Kanban

São Paulo Area, Brazil

- Worked for the Brazilian market leader food ordering and delivering platform in the Data Visualization (Data Viz) team. Responsible for setting the best practices and supporting coworkers for using data visualization tools on an environment based on Amazon Web Services, Databricks and Snowflake.- Developed a Tableau Center of Excellence to provide full support inside company. Providing educational content for different user levels (digital content, presenting workshop). Setting-up communication channels (message channel, troubleshooting, walk-in schedule) for community engagement.- Managed company’s Tableau Server, a compute cluster to support over a thousand users, from infrastructure matters to content, settings and permissions as well. Creating dashboards to manage data sources and workbooks (size, update frequency, rendering time, background jobs) and monitoring the server compute resources using Amazon Web Services tools.- Supported Data Architects on modelling tables to achieve well performed dashboards and data sources.- Stablished Data Governance procedures on Tableau Server allowing an inclusive approach instead of a restrictive one. Defining roles and responsibilities to enable content and access management by different business units.

São Paulo, São Paulo, Brazil

- Worked in the Data Quality division under Big Data and Data Science department at Yandeh, responsible for developing qualitative analysis and processes (using AWS services and Tableau) on data related to retail receipts. - Created and optimized SQL queries on AWS Athena for ad hoc analysis and Tableau dashboards. Focusing in apply best practices SQL coding and to use only essencial data to minimize cost on AWS.- Developed the data rating concept for the retail stores on Yandeh data lake. The rating indicates the quality of the data collected. Problems related to collecting and processing data, inconsistencies about items quantity and values on the receipts storaged in the data lake will cause a drop in the rating of the respective store, indicating bad data to be applied on models or analysis. The rating calculation was based on surveying business units to define the most important criteria. - Managed Tableau projects (dashboards and data sources) to optimize queries and update frequency. Requirement analysis on internal clients requests to achieve efficiency on data lake queries and minimizing cost on AWS.

São Paulo, São Paulo, Brazil

- Worked in a dynamic, under pressure environment in the Operational Business Intelligence team and reporting to the Quality Assurance Coordinator at the Nextel Network Operations Center (NOC).- Developing custom reports and dashboards using Tableau for different audiences at NOC (teams, coordinators and directors) and for different purposes – to monitor systems at real time, to analyze performance, to monitor and reduce operational costs and to find points of improvement at NOC.- Automating data processes through Pentaho Data Integration (PDI) and interacting with different systems (MS SQL and Oracle servers, MS Excel files, Emails). Processes in the past that took several minutes to be completed nowadays are delivered at scheduled time according to the frequency requested.- Working with the company newly implemented Big Data system based on Amazon Web Services (AWS) platform.- Developing cognitive applications using IBM Cloud services: a chatbot integrated to Slack based on Node-RED (flow-based development tool) and Watson services; an interactive application to request weather info (current and forecast) for the company tower sites based on Weather Company Data and Node-RED.- Integrating third-party software to improve task management and communication: Slack (team collaboration service), Trello (Kaban methodology application), G Suite products.

Greater New York City Area

- Worked in the Research Department mainly with data management with the company’s software.- Created macros in VBA for Excel for large sets of data (usually more than 10,000 series) by observing patterns and creating templates. Without the macros, a project used to take one full day of work, and now it takes only 30 minutes to be done.- Developed tools in VBA for Excel to assist staff in management of tasks and also a library for future reference.- Supported and trained workmates how to create macros to increase their productivity and how to design the process for quick updates, instead of redoing everything from beginning.

Holtsville, Ny

Formerly Motorola Solutions, Inc.- Summer Internship working in the Enterprise Mobility Computing division (EMC) with handheld computers (TC75, MC36) and tablet (ET5X);- Requested and analyzed tests to compare performance with competitor devices;- Developed provisioning solutions for enterprise devices;- Proved and demonstrated concept of wireless bridge for the new ET5X tablet (linking LTE network with a local network)

Master'S Degree

Master Of Business Administration - Mba

Continuing Education

Bachelor'S Degree

Education record

Education record

E-Learning

E-Learning