Marcelo Menezes

Experience

• 

  BR5 Consulting and Commercial Representation

  Jul 2019 - Jan 2022

  Business Intelligence Analyst

  Activities:👉 Extraction of data from Excel, CSV, and TXT👉 Data treatment (ETL) using Power Query👉 Data modeling👉 Mapping of indicators👉 Dashboard construction in Power BI👉 Setting up automatic data updatesDashboard for the commercial area, with analysis of Sell In and Sell Out indicators, days of inventory, product activation, customer portfolio activation by seller, and temporal analyses, such as Year to Date, Month to Date, among others.

• 

  Finance

  Jan 2022 - Apr 2022

  Data Analyst

  Activities:👉 Integration via API with Conta Azul to extract financial reports.👉 Data treatment (ETL)👉 Data modeling👉 Creating panels with Income Statement, Cash Flow, and other financial indicators in Power BI👉 RLS - Row-level security👉 Setting up automatic data updates.

• 

  Grupo Portfolio

  Apr 2022 - Oct 2022

  Data Analyst

  I have participated in medium and large-scale data projects for various companies, working on the process of extracting, processing, and loading data into the Data Warehouse.Tools used:👉 SQL Server, Pentaho Data Integration, and Power BI.

• 

  Infracommerce

  Oct 2022 - Jul 2024

  Data Enginner

  Allocated through the Dataside consultancy.I worked on sustaining and improving legacy processes, then migrating these processes from Pentaho to Databricks. In addition, I worked on the company's data product, which connects to multiple data sources of various types, performing maintenance and improvements to this environment.During the migration of the legacy environment, I migrated SQL procedures to Pyspark, maintaining the same business rules.I implemented data quality processes in the DW which significantly reduced the number of calls to the support team.Tools used:- Cloud: Databricks, Unity Catalog and Amazon S3- On-premises: Jenkins, Pentaho Data Integration- Technologies: Python, Pyspark, SQL Show less

• 

  Dataside

  Nov 2022 - now

  Data Enginner

  Working on medium and large data projects, mainly using the Azure cloud with the following technologies:- Azure Data Factory- Azure Databricks- Azure Functions- Azure Data Lake