Gabriel Melo

Data Analyst with experience in digital analytics, research, marketing and project management.

GitHub LinkedIn

About Me

Hello! I'm Gabriel Melo, a dedicated Data Analyst passionate about transforming raw data into actionable insights. With a background in digital analytics, marketing, research, and project management, I thrive on solving complex problems and driving data-informed strategies. My expertise lies in Python, R, SQL, and various business intelligence tools, enabling me to uncover trends, optimize processes, and contribute to impactful business decisions. I'm always eager to learn and apply new technologies in the ever-evolving field of data.

Projects

GTM A/B Test Generator

A/B testing with Google Tag Manager: the free and lean solution. A simple web-based tool to instantly generate a ready-to-import Google Tag Manager container (.json) for a classic A/B test.

Technologies: HTML/CSS, Javascript, Google Tag Manager.

View
Google Maps Scraper

Web and MacOS App to scrape data from Google Maps. Extracts name, address, phone number, website, rating, reviews, email and more for each place.

Technologies: Go, Golang, PLpgSQL, HTML/CSS, Docker.

View on GitHub
Basket Analysis Apriori

Performs association analysis on a sales dataset using the Apriori algorithm to find frequent itemsets and association rules based on support, confidence, and lift.

Technologies: Python, Jupyter, Pandas, Mixtend, Looker Studio.

View on GitHub
LangChain + ChatGPT for Data Analysis

Uses the LangChain library and OpenAI's ChatGPT API to perform data analysis on a dataset, similar to OpenAI's Code Interpreter.

Technologies: Python, Jupyter, Pandas, OpenAI API, LangChain.

View on GitHub
Shiny WebApp Finances

This is a Shiny web application that allows you to analyze stock data for Brazilian assets. The application retrieves data from Yahoo Finance and provides interactive charts for the selected asset.

Technologies: R, Shiny, Yahoo Finance API.

View on GitHub
Google Search Scraper

A Python script that fetches the top search results from Google for a given list of queries and outputs them in TSV format for easy use in spreadsheets.

Technologies: Python, Requests, BeautifulSoup.

View on GitHub
Shop Status Monitor

An automation project that monitors the availability of Tinfoil shops using GitHub Actions and reports the status.

Technologies: Python, GitHub Actions, Automation.

View
NSX Tinfoil Shops Repository

This is a GitHub page to list links to active and working tinfoil shops for Nintendo Switch.

Technologies: Python, GitHub Actions, Automation.

View

Skills

Languages:

Python R JavaScript SQL

Tools & Platforms:

Jupyter Notebook GitHub Actions Google Analytics Google Tag Manager Looker Studio Power BI BigQuery RStudio VSCode Excel Tableau

Libraries & Methodologies:

Pandas NumPy Scikit-learn BeautifulSoup Requests LangChain StatsModels Agile Project Management Data Mining ETL Processes

Work Experience

  • Developed and maintained comprehensive Looker Studio dashboards for sales and marketing KPIs, leading campaign targeting accuracy.
  • Performed in-depth analysis of customer behavior using Python (Pandas, NumPy) and SQL, providing actionable insights that informed product development strategies.
  • Automated data extraction and reporting processes from Google Analytics and various databases, reducing manual effort.
  • Collaborated with cross-functional teams to define data requirements, implement data quality checks, and ensure data integrity across projects.
  • Conducted A/B testing analysis for website optimizations, resulting in a increase in user conversion rates.
  • Solve business problems using a data-driven approach to developing or adapting existing methods.
  • Setup and diagnose containers and triggers within Google Tag Manager and DataLayers to digital attribution and digital analytics.

  • Indicators and Metrics course for Digital Marketing Technologists.

  • Web Analytics subject of the graduation course Market Intelligence and Data Analysis.

  • Provide data and analysis to aid decision making.
  • Create dashboards and reports in Google Sheets, Looker Studio and Power BI.
  • Constantly monitor results and signal trends and opportunities.
  • Ensure data synchronization and reliability in the tools used by teams.
  • Analysis and generation of intelligence.
  • Understand user behavior.
  • Data maintenance.

Education & Certifications

Education

  • Master's degree, Administration
    UFF - Federal Fluminense University, Niterói, Brazil.
  • Master's degree, Exchange in Economics
    FEUC - Faculty of Economics of the University of Coimbra, Coimbra, Portugal.
  • Master of Business Administration - MBA, Business Management and Information Systems
    UFF - Federal Fluminense University, Niterói, Brazil.
  • Bachelor's degree, Information Systems
    UNSESA - Estácio de Sá University, Niterói, Brazil.

Certifications

Contact Me