Hi! My name is Juan, and I am passionate about turning complex data into actionable insights. I specialize in business analytics and data visualization. Check out some of my latest work below.
Projects
Real Estate Property Management with Advanced Analytics
This project is a Real Estate Property Management System designed to streamline property tracking, maintenance requests, tenant payments, lease management, and more. It includes advanced SQL queries for ranking properties by open maintenance requests, calculating rent yields, tracking tenant payment history, and determining each owner’s total portfolio value. The system supports efficient data retrieval and provides actionable insights for property managers, landlords, and investors to optimize decision-making.
Investment Portfolio Management with Python
This project aims to optimize investment portfolios using Python by applying Modern Portfolio Theory (MPT) to analyze asset performance, minimize risk, and maximize returns. It identifies optimal portfolios through Monte Carlo simulations, calculates risk-return trade-offs, and visualizes key insights to guide informed investment decisions.