Business Analyst and recent Global Business graduate (Tecnológico de Monterrey) working at the intersection of business processes, logistics, automation, and data. I gather requirements from finance and operations teams, document the workflows, and then build the automation that removes the manual work.

name:         Juan Carlos Contreras Gastélum
alias:        Juca8
location:     Ensenada / Tijuana / Monterrey, México 🇲🇽
role:         Business Analyst · Logistics/Supply Chain · Data Analytics
education:    B.A. Global Business — Data Analytics & AI Tools (GPA 91.76/100)
exchange:     Vrije Universiteit Amsterdam 🇳🇱
languages:    Español (nativo) · English (bilingual, C1) · Français · Nederlands
focus:        Requirements gathering → workflow documentation → automation

• 🔭 Currently building automated billing and customer-service workflows with Python, FastAPI and Playwright.
• 🧾 Shipped CFDI 4.0 electronic invoicing with SAT sealing, PDF generation and email delivery.
• 🤖 Integrated the WhatsApp Business API and Telegram Bot API into production business flows.
• 📊 Comfortable across the full analytics workflow — SQL → Pandas → Tableau, following CRISP-DM.
• 🌍 Work effectively in English and Spanish with cross-functional teams.
• 📫 Reach me at jccontrerasg08@gmail.com or on LinkedIn.

Rendered natively by GitHub — no external service, so it always loads.

flowchart LR
    A["🗣️ Stakeholder<br/>interviews"] --> B["📋 Requirements<br/>gathering"]
    B --> C["🗺️ Process<br/>mapping"]
    C --> D{"Automatable?"}
    D -->|Yes| E["⚙️ Build<br/>Python · FastAPI · Playwright"]
    D -->|No| F["📈 Process<br/>improvement"]
    E --> G["✅ Validation<br/>rules"]
    F --> G
    G --> H["📊 Reporting<br/>SQL · Pandas · Tableau"]
    H --> I["📁 Documentation<br/>& handover"]

    classDef analysis fill:#1a2a6c,stroke:#fdbb2d,stroke-width:2px,color:#ffffff
    classDef build fill:#b21f1f,stroke:#fdbb2d,stroke-width:2px,color:#ffffff
    classDef deliver fill:#fdbb2d,stroke:#1a2a6c,stroke-width:2px,color:#1a2a6c
    class A,B,C analysis
    class E,F,G build
    class H,I deliver

Data & Analytics

Automation & Development

Business & Enterprise Tools

Freelance Developer · RFA — Tijuana / Ensenada, México · 02/2025 – Present

Analyzed business processes and gathered requirements from finance and operations teams, translating them into automation opportunities. Built automated workflows in Python, FastAPI and Playwright that cut manual processing time in billing and customer service. Implemented CFDI 4.0 electronic invoicing with SAT sealing, PDF generation and email delivery, plus WhatsApp Business and Telegram API integrations. Documented workflows, validation rules and integration procedures.

Sponsorships Director · Comité de Participación Estudiantil, Tec de Monterrey · 01/2025 – 06/2025

Led the sponsorships area, securing funding for charity events and student initiatives. Managed outreach, proposals and follow-up with local businesses, and presented financial results to the committee.

Accounting Assistant · RFA · 09/2019 – 01/2020

Processed invoices, journal entries and financial documentation. Supported monthly close through account reconciliations and financial data validation. Produced reports, workflow documentation and internal controls.

Sales & Delivery Associate · RFA · 01/2019 – 08/2019

Supported B2C deliveries, order processing and customer accounts across Ensenada and Tijuana. Managed route pickups and inventory control, and identified upsell opportunities with repeat customers.

Certifications

• Google Data Analytics — SQL, R, Tableau, end-to-end workflow
• SAP Business Analyst — data analytics & business-process analysis
• McKinsey Forward Program — leadership & structured problem-solving
• Learn SQL Basics for Data Science — UC Davis
• Cadena de Suministro global — supply chain & logistics
• Comercio Internacional — export, import, customs & global business