Hi, I'm Julian Vargas.
Python Developer & Data Engineer.

Transforming complex data into actionable insights | Building scalable automation solutions

View My Work Get In Touch

Featured Projects

Scalable solutions that drive business value and efficiency

Bancolombia - Investment Funds Dashboard

Enterprise analytics platform processing 500,000+ daily transactions for 600+ investment funds. Automated data pipelines reduced manual processing by 85%, saving 20+ hours weekly.

Tech Stack: Python, Pandas, NumPy, Streamlit, SQL

Impact: 85% reduction in processing time | 600+ funds managed | Real-time analytics
View Live Demo →
ASCyber - AI Agent for Architects

An AI-powered assistant for architects that automates materials analysis, energy efficiency calculations, and project cost estimation. Integrates a smart conversational interface with a materials database.

Tech Stack: React (TSX), Firestore, Firebase SDK, GCP

Impact: Real-time energy performance estimation | Direct access to materials catalogs | Dynamic chat-based project analysis
View Live Demo →
Tech Watch - Personalized News Dashboard

A daily news automation platform that curates and delivers news tailored to specific user interests. Built as a prototype for monitoring tech trends and sending daily digests.

Tech Stack: GCP, Firestore, Firebase SDK

Impact: Daily personalized news delivery | Multi-topic subscription tracking | Automated content aggregation
View Live Demo →
Oxxo Actas - Smart Document Extractor

Document extraction system that automates the processing of Oxxo store reports and records. Leverages Google Cloud Document AI to extract metadata, organize folder structures, and generate reports, reducing manual data entry.

Tech Stack: Document AI, GCP, JavaScript

Impact: Automated metadata extraction | Automated directory structuring | Improved reporting speed and accuracy
View Live Demo →

What I Do

I'm a Python Developer specializing in financial data engineering and automation solutions. Currently at Bancolombia, I've architected and deployed systems that automate reporting for 600+ investment funds, processing over 500,000 data points daily.

My expertise includes:
• Building ETL pipelines that transform raw financial data into actionable insights
• Developing interactive dashboards with Python, Pandas, NumPy, and Streamlit
• Automating complex workflows to reduce manual processing by up to 85%
• Creating scalable data architectures for enterprise-level applications

I also develop modern web applications using JavaScript ES6+, React, Node.js, and the MERN stack, combining full-stack capabilities with data engineering expertise.