Automation · Data · AI Systems — Bogotá, Colombia

Automate the work. Analyze the signal. Scale the business.

Industrial engineer and founder. I diagnose how organizations actually work, quantify the inefficiency, and rebuild the process around data and automation — cutting up to 90% of manual processing time for clients in manufacturing, energy and construction.

Available for remote work
ES native · EN B2 · PT B1
B.S. Industrial Engineering · Javeriana
Jairo Amaya Celis
open to work
4int. competitions
3first places
90%manual time cut

Selected and recognized in 2026 by

01 Stellar · Pulso Hackathon 02 Vendimia Hackathon, Mendoza 03 Etherfuse · Stellar Builder Summit 04 30X × Colsubsidio 05 Springer · published author
90%

Reduction in manual processing time delivered to clients

+25%

Projected campaign ROI lift from the MercadoLibre segmentation study

5,000

Row database built and analyzed with SPSS multivariate methods

5th/500+

Finalist among 500+ participants — 30X × Colsubsidio Hackathon

What I do

I don't just build tools.
I fix how the operation runs.

Every engagement starts the same way: understand the real process before automating it. Then build the smallest system that removes the bottleneck for good.

01

Process diagnosis & automation

I map how work actually flows, quantify where time and money leak, and rebuild the process with automated pipelines instead of spreadsheets and copy-paste.

  • Python
  • n8n
  • Make
  • APIs & Webhooks
  • RPA
  • FlexSim
02

Data & business intelligence

From raw, unstructured operational data to dashboards leadership actually uses: structured datasets, statistical analysis and reporting that answers the decision, not just the question.

  • Power BI
  • SQL
  • SPSS
  • Pandas
  • RapidMiner
  • Web scraping
03

AI agents & LLM applications

Agentic workflows and RAG pipelines built on the Anthropic and OpenAI APIs — document extraction, conversational advisors and assistants wired into the systems a team already uses.

  • LangChain
  • Anthropic API
  • OpenAI API
  • RAG
  • Claude Code
  • Prompt engineering

Selected work

Systems shipped,
not slide decks.

01
Co-founder · 2026 — present

Truway — verifiable funding infrastructure

Infrastructure on Stellar that makes donor funding traceable and verifiable for NGOs. Foundations capture expenses from a photo through a WhatsApp bot, funds are disbursed and anchored automatically, and donors verify how every peso was used — without ever seeing a wallet or a hash. Selected participant at the Stellar Builder Summit and Stellar House, São Paulo.

Stellar / SorobanNestJSNext.jsPostgreSQLGeminiWhatsApp API
3 wins International competitions won with this product in 2026
02
Founder · Feb 2024 — present

Ceston — automation & data practice

End-to-end automation and data work for operations-driven companies across manufacturing, energy and construction. I lead each engagement from problem scoping to delivery: diagnose the process first, then build reporting pipelines, dashboards and internal web tools that replace the manual routine entirely.

PythonPower BISQLMakeNotion APISupabase
−90% Manual processing time on automated reporting pipelines
03
Data analyst · Jan — Jun 2025

MercadoLibre — consumer segmentation study

Built a 5,000-row primary research database and ran multivariate analysis in SPSS — cluster analysis, ANOVA and regression — to profile consumer behavior. Isolated three high-value segments and translated them into a go-to-market strategy for the marketing team.

SPSSPythonCluster / ANOVARegressionData viz
+25% Projected campaign ROI lift from the segments identified
04
Market intelligence · Jun — Dec 2025

Prolub — cross-industry benchmarking system

Led a benchmarking study across oil & gas, construction and manufacturing: competitor strategies and product portfolios mapped through primary research and industry interviews, then turned into structured datasets, Power BI dashboards and executive reports used for leadership-level decisions.

Power BIExcelWeb scrapingPrimary research
3 sectors Oil & gas, construction and manufacturing benchmarked
05
Hackathon · 2026

Conversational insurance advisor — 30X × Colsubsidio

An LLM advisor that automates an end-to-end insurance sales process: it qualifies the customer, explains coverage in plain language and carries the conversation to closing. Finished 5th out of more than 500 participants.

LLM agentsPythonConversational designProcess mapping
5th / 500+ Finalist, Bogotá 2026

Awards & competitions

Four international competitions
in 2026. Three first places.

Built and pitched under 48-hour constraints, against teams from across the Americas.

1st place — winner

Vendimia Hackathon

International hackathon held in Argentina's wine region, bringing together builders from across LATAM.

Mendoza, Argentina · 2026
1st place — winner

Pulso Hackathon

International competition across the Americas hosted by the Stellar blockchain ecosystem.

Stellar ecosystem · 2026
1st place — bounty winner

Etherfuse Bounty — “Emerging-Market Yield, Brazil-first”

Won at the Stellar Builder Summit, engaging directly with Stellar leadership and the LATAM ecosystem.

São Paulo, Brazil · 2026
Finalist — 5th of 500+

30X × Colsubsidio Hackathon

Conversational insurance advisor automating an end-to-end sales process, built in under 48 hours.

Bogotá, Colombia · 2026

Experience

Where the work happened.

Founder — Process Automation & Data

Ceston Feb 2024 — Present
  • Build end-to-end automation and data solutions for operations-driven companies, leading each engagement from problem scoping to delivery.
  • Automated reporting pipelines that cut manual processing time by up to 90%, improving operational visibility and decision speed.
  • Diagnose client processes before automating them, turning unstructured operational data into actionable systems with Python, Power BI and SQL.

Co-Founder

Truway 2026 — Present
  • Blockchain infrastructure on Stellar that makes donor funding traceable and verifiable for NGOs, addressing transparency in the social sector.
  • Selected participant at Stellar Builder Summit and Stellar House (São Paulo, 2026), engaging directly with Stellar leadership and the LATAM ecosystem.

Market Intelligence & Business Analyst

Prolub Jun — Dec 2025
  • Led a benchmarking study across oil & gas, construction and manufacturing, analyzing competitor strategies and product portfolios through primary research and industry interviews.
  • Built structured datasets and Power BI dashboards; delivered executive reports supporting leadership-level decisions.

Data Analyst — Market Study

MercadoLibre Jan — Jun 2025
  • Built a 5,000-row database and ran SPSS multivariate analysis (cluster, ANOVA, regression) to profile consumer behavior.
  • Isolated 3 high-value consumer segments, informing a go-to-market strategy projected to lift campaign ROI by 25%.

Research & speaking

Published, peer-reviewed,
and presented on stage.

Paper · Author & speaker

BIM + Blockchain integration for verifiable construction data

Research on anchoring building-information models to a verifiable ledger so that project data — quantities, changes, approvals — can be audited without trusting a single party. Published by Springer and presented at the Colombian Computing Congress.

Springer · Cartagena, Colombia · 2026
Conferences

Published author at international conferences on education and computing

Ongoing work at the intersection of engineering education, computing and verifiable data — the same thread that runs through everything I build: if a number matters, it should be possible to check it.

Multiple venues · 2024 — 2026

Capabilities

The toolkit.

Analytical rigor on one side, shipping the solution on the other.

Data & analytics

  • Python
  • SQL
  • SPSS
  • Power BI
  • Excel (advanced)
  • FlexSim
  • RapidMiner
  • Web scraping
  • Dashboard automation
  • Looker Studio

AI & automation

  • LangChain
  • Anthropic API
  • OpenAI API
  • Agentic workflows
  • RAG pipelines
  • Prompt engineering
  • Claude Code
  • n8n
  • Make
  • AI-assisted development

Development & tools

  • JavaScript
  • React
  • HTML / CSS
  • Git
  • Supabase
  • PostgreSQL
  • Soroban (Stellar)
  • Notion

Business & methods

  • Process optimization
  • Operations analysis
  • Requirements gathering
  • Stakeholder reporting
  • Project management
  • Scrum / Agile
  • Data-driven decisions
Spanishnative
Englishprofessional · B2
Portugueseintermediate · B1

Education & certifications

Trained in engineering.
Certified in the rest.

B.S. Industrial Engineering

Pontificia Universidad Javeriana

Bogotá · expected 2027

Salesforce Platform Basics

Trailhead

2026

Data Scientist Career Path

Codecademy

2025

Artificial Intelligence

MinTIC Colombia · + BI Data Analyst, Codecademy (2024)

2024

Let's build something

Ready to automate
your operation?

Tell me what part of the process still runs on spreadsheets and manual copy-paste. I'll tell you what it costs you and what it would take to remove it.

jairoamaya123456@gmail.com +57 302 836 1979 Bogotá, Colombia · remote worldwide