analytics
Portafolio de Iván

About me

I've been on the other side of the dashboard

Data that doesn't lie.

Professional portrait of Iván Díaz

Iván de Jesús Díaz Navarro

Data, BI & Automation Consultant

I build and run the systems, not just the reports.

🇺🇸 CV English 🇲🇽 CV Español

Before I built dashboards, I used them. For ten years I was the person on the other side: the one who enters the data, checks it, and then has to explain why the number in the report does not match what happened at the counter.

In government banking I managed databases with hundreds of thousands of records and prepared the reports the programme was audited against. That is where I learned that a system does not fail the day it goes down: it fails the day it forces people to invent a workaround in order to get their job done.

And I have been a certified tour guide since 2009. Leading groups teaches you something else: real operations never look like the diagram. That is why the systems I build today deduct stock when a person confirms it, not when the software believes it knows.

Today I design, build and run those systems. I am still the one who has to explain the number — except now I also write the rule that computes it, and I hold it to telling the truth even when the truth is inconvenient.

Career path

Twenty years that explain how I build

Ten in critical operational data and seventeen in tourism. Neither is filler: together they explain why these systems respect the way people actually work.

  1. deployed_code 2026

    Systems in production

    Clients in Mexico and the United States

    The set of systems now running for real businesses, published one by one as case studies.

    See the published cases arrow_forward
  2. insights Feb 2025 — present

    Data Analyst

    Freelance

    KPIs, data pipelines and monitoring tools built with Python. Foundation: TripleTen professional certification (2024).

  3. hiking 2009 — present

    Certified Tour Guide

    Independent

    Visitor record keeping, attendance statistics and my own operational control tools.

  4. account_balance 2013 — 2020

    Government Programmes Coordinator

    Banco del Bienestar

    Databases with hundreds of thousands of records, reports for audits, and improvements that cut delivery times by more than 30%.

  5. account_balance 2010 — 2013

    Operations Support

    Banco del Ahorro Nacional y Servicios Financieros SNC

    Data migration, verification and control, and daily and weekly reporting.

  6. school 2005 — 2009

    Alternative Tourism · Bachelor’s degree

    Universidad Intercultural de Chiapas

Technology stack

What shows up in the cases published on this site. Nothing I cannot show running.

database

SQL and PostgreSQL

Modelling, complex queries and database-level isolation

code

Python and automation

Cleaning, analysis and pipelines that can be re-run safely

table_view

Spreadsheets

Pivot tables, macros and migrations with full traceability

deployed_code

Docker and operations

My own server, deployments with backup and rollback

monitoring

Tableau and Looker Studio

Visualisation and data storytelling

functions

Statistics

Hypothesis testing, cohorts and modelling

Supporting evidence

Certifications and credentials

They come last on purpose. The evidence in this portfolio is the systems published here, not the diplomas; even so, every original document is right here.

Click a card to see the document

Click → flip

New ITF · Salesforce

Introduction to Artificial Intelligence Engineering

Iberoamerican Technology Foundation · Salesforce Foundation

Folio #6186412644ID · 22 April 2026 · Silicon Valley, CA

Document details

  • Holder: Iván de Jesús Díaz Navarro
  • Program: Introduction to AI Engineering (Phase I)
  • Issued by the Iberoamerican Technology Foundation (ITF) with the support of the Salesforce Foundation.
  • Issued on 22 April 2026 · Silicon Valley, California, USA.
Data Analyst

Data Analyst · Business Intelligence & Automation

TripleTen

Folio #0001553 · Issued 22 Sep 2025

Document details

  • Official folio #0001553.
  • Issued on 22 September 2025.
  • Holder: Iván de Jesús Díaz Navarro.
Mimo2

SQL · Certificate of Completion

Johannes Berger · CEO, Mimo2

Issued 9 June 2025

Program highlights

  • Core SQL concepts for building tables and extracting insights from one or multiple tables.
  • Practical combination of queries, joins, and aggregations.
  • Applied to managing a basic relational database for business analysis.
CONOCER

EC0217.01 · Instructor-led training delivery

Registered under RNCE EC0217.01

Universidad Politécnica de Chiapas · 13 Jul 2023 · Folio D-0031405323

Official data

  • CONOCER grants this credential to Iván de Jesús Díaz Navarro.
  • Standard: delivery of instructor-led human capital training courses.
  • RNCE EC0217.01, published in the Diario Oficial de la Federación on 2 June 2021.
  • Certification body: Universidad Politécnica de Chiapas · Mexico City, 13 July 2023.
CONOCER

EC0301 · Course design & assessment

Certification body: Universidad Politécnica de Chiapas

RNCE EC0301 · DOF 28 Nov 2012

Folio D-0002370022 · Issued 23 Mar 2022

Competency standard

  • Design of instructor-led group courses, assessments, and manuals.
  • Registered under RNCE EC0301, published in the DOF on 28 November 2012.
  • Issued in Mexico City on 23 March 2022.
  • Officially recognized in Mexico, with no extra legalization requirements.

Looking for someone who has been on the other side?

If your operation depends on data nobody quite believes, or on a system only one person knows how to deploy, that is exactly where we start.

mailGet in touch dnsHow I work