Skip to content
Juan Parrado
  • Work
  • About
  • Work
  • About
Get in touch

Hi, I'm Juan.

I turn messy operational data into decisions leaders act on.

BI developer and data analyst with nearly 5 years in finance, credit and logistics. I build the pipelines, dashboards and AI tools that collections, sales and service teams run on every day.

See my work
Resume
  • 5 years in BI
  • 4 companies
  • Snowflake · Power BI · Python

Data Analyst

BI Developer

Selected work

Projects that show how I solve business problems, from the raw data to the decision it supports.

Reporting automation

Automated FX Reporting

A weekly pipeline that tracks USD/COP volatility and delivers an executive brief, so a flower exporter can protect its margins without anyone building the report by hand.

100%automated, from the exchange rate to the emailed PDF brief
  • AI
  • Automation
  • Finance

Case study →

AI quality assurance

AI Service Quality

An automated QA pipeline that transcribes support calls with Whisper and scores them with Gemini, rating agent performance and customer sentiment and replacing manual audits.

100%of calls reviewed, instead of a small manual sample
  • AI & NLP
  • Dashboard
  • E-commerce

Case study →

Machine learning app

AI Churn Prediction & Retention

An end-to-end machine learning pipeline that predicts which subscribers are likely to cancel and drafts a personalised retention plan for each one, protecting recurring revenue.

80%+accuracy predicting which subscribers will cancel
  • Python
  • Machine learning
  • AI

Case study →

BI dashboard

Conversational Dashboard

An executive Tableau dashboard paired with a Streamlit app, so stakeholders can explore e-commerce data and build their own charts by asking questions in plain language.

285Mraw behavioural events turned into a dashboard leaders can question
  • BI
  • Data viz
  • Tableau
  • AI & NLP

Case study →

Results from the job

Measured outcomes from my roles in finance, credit and logistics.

9 → 2min

Dashboard refresh time after rebuilding the Snowflake models

Importa Group

−18%

Monthly Snowflake cost after the same rebuild

Importa Group

~50%

Fewer questions reaching a human, thanks to an AI support assistant

Globant

5min

Refresh cycle of the collections dashboard used to track payments and targets

Finanzauto

Finance background, engineering habits

I’m a data professional with nearly five years of experience connecting complex finance operations to modern analytics pipelines. I studied finance and international trade before moving into BI, so I start from the business question and work back to the data.

  • SQL Server
  • Snowflake
  • MySQL & PostgreSQL
  • Python
  • Power BI (DAX)
  • Tableau
  • Advanced Excel

Full experience →

Two ways to work together

Hiring for a data role

See if I fit your team

My resume covers the full story: the companies, the stack and the results behind each role.

View experience
Download resume

Freelance project

Get a dashboard or automation built

Tell me which report eats your team’s week or which decision lacks data. I’ll reply with how I’d approach it.

Start a project
Juan Parrado

BI Developer & Data Analyst · Bogotá, Colombia

hello@juanparrado.comlinkedin.com/in/juanparrado