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.
- Nearly 5 years in BI
- 4 companies
- SQL · Power BI · Python
- 10K+ followers on LinkedIn
Juan Parrado · Data Analyst · BI Developer
Selected work
Projects that show how I solve business problems, from the raw data to the decision it supports.
Python analysis · interactive D3 map
96,470 real orders, one answer a manager can act on: open the next hub in Recife.
- Interactive map of all 27 states
- Plain-English reading per state
- 3 findings, 3 ranked recommendations
- Real data, fully sourced
Automation · Make, Gemini, Google Workspace
Built for companies whose margins move every time the dollar does.
- Weekly USD/COP brief, 100% automated
- 30+ news articles read by AI each week
- Trends over 1 month, 3 months and 1 year
- PDF report emailed to stakeholders
AI pipeline · Power BI dashboard
A supervisor can listen to a handful of calls a week. This listens to all of them.
- Every call reviewed, not a sample
- 11-point AI scoring rubric
- Customer emotion scored 1–10, no survey
- Live Power BI dashboard
Machine learning · Streamlit app
Knowing who will cancel is half the job. The other half is knowing how to keep them.
- 0.84 ROC-AUC on unseen customers
- 3 models trained and compared
- AI-written retention offer per customer
- Live app with one-click CSV export
Tableau dashboard · AI chat app
Leaders shouldn’t have to wait for an analyst to answer a simple question.
- 285M-event dataset filtered in Python
- Executive Tableau dashboard
- Ask in plain English, get a chart
- AI never touches the raw database
Results from the job
Measured outcomes from my roles in finance, credit and logistics.
9 → 2min
Dashboard refresh time after rebuilding the Snowflake models
Refactored the transformations and right-sized the warehouse.
Importa Group
−18%
Monthly Snowflake cost after the same rebuild
Same refactor: a right-sized warehouse uses fewer credits.
Importa Group
~50%
Fewer questions reaching a human, thanks to an AI support assistant
GeneXus Enterprise AI agent with REST API integrations; 73% fully correct answers in its last quality test.
Globant
5min
Refresh cycle of the collections dashboard used to track payments and targets
Data flows in automatically through an API, so the numbers are never more than 5 minutes old.
Finanzauto
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.
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.