Profile Photo

About

Hi! I'm Ivan Silva, a Data Analyst from Corrientes, Argentina 🇦🇷. I enjoy working throughout the whole process of transforming plain data into actionable insights that help people to inform themselves better and take better decisions.

Skills

Technical Skills

Python Pandas, NumPy, Scikit-learn
Excel Power Query, Pivot Tables, VBA
SQL PostgreSQL, MySQL, BigQuery
Power BI DAX, Data Modeling, Dashboards
Tableau Visual Analytics, Storytelling
ETL & Data Prep Pipelines, Data Cleaning, APIs
Git & GitHub Version Control, CI/CD

Languages

🇪🇸
Spanish
Native
Native
EN
English
B2 - Professional Working
B2
🇨🇳
Mandarin Chinese
HSK1 - Elementary
HSK1

Projects

Suicidio en Datos

Python Excel Power BI Tableau
  • Analyzed 25+ years of public data on suicide in Argentina across diverse dimensions of the issue.
  • Cleaned nearly 200,000 records from three different Argentine government sources using Pandas.
  • Built a full analysis of the data in a website using both Power BI and Tableau.
GitHub Repository Website

RFM Analysis on Online Retail

Python Power BI Excel
  • Cleaned more than 400,000 transactional records from the UCI 'Online Retail' repository and created a pipeline to calculate RFM metrics using Pandas.
  • Segmented 4,338 customers based on a K-means algorithm using Scikit-learn.
  • Data visualization using Power BI for interactive dashboards and Matplotlib for static graphs.
  • Calculated customers churn rate based on a recency threshold during a one-year period.
GitHub Repository Website

Cybersecurity Tendencies

Excel Power Query Power BI
  • Consolidated 5 years of public cybercrime data collected by the IC3 using Power Query.
  • Designed a dashboard in Power BI that showed the most significant crime trends.
GitHub Repository Website

Olist Store Analysis (In progress)

SQL PostgreSQL
  • Cleaned and restructured the data model using SQL in a PostgreSQL database.
  • Answered several business questions using SQL.
GitHub Repository

Work Experience

Food Server

Dr. Jekyll & Mr. Hyde
2020 - 2023 On-site
  • I worked as a food server for a restaurant with a capacity of over 100 people.
Effective Communication Multi-tasking Cooperativeness