Juan Pablo Gonzalez | Data Analyst

Juan Pablo Gonzalez

Data Analyst

Based in Colombia

About

I am a highly motivated and results-oriented professional with a background in industrial technology and a strong desire to transition into the dynamic field of data analysis. While I possess no formal experience as a Data Analyst, my educational foundation in industrial technology and my honed analytical and problem-solving skills from my previous role as an Account Receivable Representative have equipped me with a transferable skill set perfectly suited for this path.

Skills

Projects

Pizzeria Sales Analysis: A Data-Driven Approach

Analyzed pizzeria sales data by building a MySQL database and crafting SQL queries to discover meaningful insights. Visualized trends in an interactive Tableau dashboard to uncover customer preferences and optimize pizzeria operations.

Bean Voyage: Exploring Coffee Production & Consumption Worldwide

Explored global coffee trends over the past decade. Downloaded and cleaned the dataset in Excel. Using Tableau, performed an exploratory analysis, identifying the top coffee exporters, importers, and leading producers of Arabica and Robusta beans. Finally created a Story dashboard.

Experience

2020-2021

Accounts Receivable Representative

- Managed accounts receivable for multiple bilingual clients to ensure accurate and timely payment of invoices. - Manage the accounts assigned by the client, identify the reasons for overdue payments, negotiate payment agreements, resend invoices, and escalate the situation to the client according to the specifics of each account. - Work directly with Wesco Aircraft, the company's client; generating weekly financial reports in Excel and creating monthly invoices.

Education

2023

Google Data Analytics Specialization certificate

2020

Industrial Technologists Degree