Data Analytics

Data Analyics Visualization

Analyzing data is the core of my work. This process involves inspecting, cleaning, transforming, and modeling data to make it structured for data visualization and business intelligence. I'm very proficient in SQL and Python, which allows me to easily find solutions to the most common pain points when working with any type of data.

  • Advanced Business Reporting: Writing complex SQL queries to extract precise answers from structured databases across multiple business domains, optimizing performance, and guaranteeing data correctness.
  • Data Modeling and Data Warehousing: Designing concise models that organize scattered raw data into datasets that are easy to understand and use. Perfect for self-service reporting or Business Intelligence.
  • Data Wrangling and Cleaning: Transforming and cleaning data from multiple sources using Python, automating integration and validation to deliver structured, analysis-ready datasets.
  • Machine Learning and AI: Using machine learning techniques, from classical models to deep learning, to uncover patterns and forecast trends. Creatively applying modern LLMs to get the most out of existing data.

Tech Stack

During my career, I've worked with many data analytics tools, but these are the ones I have the most experience with and have proven especially effective in my professional projects, particularly when working in small and medium-sized businesses.

  • Databases: Primarily use of PostgreSQL, with past experiente in MySQL.
  • Data Transformation: Heavy use of SQL and dbt (data build tool) for structured data, along with Python and libraries like pandas, DuckDB, and NumPy for processing and automation.
  • Machine Learning & AI: Experience with classical ML models (scikit-learn), deep learning (Keras, PyTorch), and time series forecasting (ARIMA, Statsmodels).
  • Spreadsheets: It's impossible not to mention them. Excel and Google Sheets are still invaluable, whether for quick analysis, financial modeling, or when SQL just isn't an option.

Beyond these, I'm always exploring new technologies, but this tech stack has consistently provided the best balance of efficiency and reliability.