Experience & Projects
Electoral and Socioeconomic Geospatial Analysis
Videntia
Developed an advanced analytical platform integrating historical electoral data (2018-2024) with socioeconomic indicators at the block level for all of Mexico, allowing multidimensional analysis of electoral behavior. Implemented a frontend with React 18, TypeScript 5.0, and Mapbox GL JS v2.15 with custom extensions for interactive geospatial visualization and spatial analysis using Turf.js.
Key Achievements
- →
Designed and implemented Python scripts with GeoPandas for geospatial ETL, shapefile transformation, and vector processing for geometric schema unification.
- →
Processed more than 2.5M urban blocks from INEGI with more than 30 variables per entity, implementing AMAI classification algorithms for socioeconomic level calculation.
- →
Implemented topological optimization with adaptive Douglas-Peucker simplification and generation of vector tiling schemes with efficient encoding.
Intelligent Commercial Document Analysis System
Prodensa AI
Designed and developed a multipurpose system to extract structured information from unstructured commercial documents such as invoices, packing lists, and customs documents. Implemented a modern frontend application with React and Vite, using Tailwind CSS for responsive design and Drag and Drop system for file handling.
Key Achievements
- →
Created an advanced document processing system with support for multiple formats (PDF, CSV, XLSX) and worker threads for asynchronous processing without blocking the main thread.
- →
Developed advanced prompt engineering techniques for LLMs, with specialized templates for each document type, optimized parameter configuration, and advanced response validation.
- →
Implemented an optimized processing pipeline with asynchronous architecture, real-time progress tracking, robust error handling, and memory optimization.
Specialized Industrial Real Estate Chatbot
STRTGY
Designed and implemented a custom RAG (Retrieval Augmented Generation) system with chatbot for the industrial real estate sector, integrating Anthropic's Claude 3.5 Sonnet and OpenAI APIs. Developed a data processing system for semantic vectorization (embeddings) of complex real estate information using OpenAI Embeddings and FAISS for efficient search.
Key Achievements
- →
Implemented advanced prompt engineering techniques with a multi-layer system for contextualization, generation, and formatting, significantly improving the relevance and accuracy of responses.
- →
Created a dynamic PDF report generation system from conversations, using Jinja2 for templating and HTML-PDF conversion techniques for structured documents.
- →
Developed a customized user interface in Streamlit with multi-user authentication system, dynamic theming, and accessibility optimizations.
Comprehensive Data Analysis Platform for TV Shopping Company
STRTGY
Developed a complete data analysis and business visualization ecosystem consisting of three interconnected projects: a RESTful API backend (FastAPI), an interactive dashboard (React), and a report generation platform (Flask with AI). Implemented a RESTful API with FastAPI that provides access to analytical data stored in MongoDB, with endpoints for different dimensions of business analysis.
Key Achievements
- →
Designed and developed an interactive dashboard with React 18 and Material UI 6 for business KPI visualization, implementing visualizations with Recharts, D3.js, and React Leaflet.
- →
Created a data-driven decision-making solution, implementing KPIs for sales trends, customer segmentation, inventory turnover, and advertising effectiveness through interactive dashboards.
- →
Employed K-means clustering for customer segmentation and created interactive chloropleth maps using GeoJSON data, revealing geographical patterns in sales and customer behavior.
- →
Integrated Google Trends data using time series analysis to anticipate consumer interests, informing inventory management and marketing strategies.
- →
Implemented a multi-stage data processing pipeline, extracting data from SQL databases, storing in MongoDB, processing with pandas and numpy, and integrating external APIs for data enrichment.
Advanced Demand Forecasting & Inventory Optimization System
STRTGY
Developed a complete demand forecasting and inventory optimization system for the beverage industry, incorporating time series analysis, statistical modeling, and full-stack implementation. Designed and built a robust ETL pipeline for beverage sales data, with multiple source integration, advanced cleaning with pattern extraction, and automated outlier detection.
Key Achievements
- →
Implemented an adaptive forecasting system that selects optimal algorithms based on data characteristics: Prophet for SKUs with sufficient history, SARIMA for products with moderate history, and moving averages as fallback.
- →
Developed a mathematical inventory optimization model incorporating lead time calculations, safety stock determination, capacity constraints, and turnover rate optimization.
- →
Created a modern and responsive dashboard with React/TypeScript, interactive visualizations with Chart.js, component-based architecture, and performance optimization through memoization and lazy loading.
GeoAI Insights: Advanced Visualization of the Competitive Landscape
STRTGY
Leveraged GPT-4 and GPT Vision for competitor analysis, using chain of thought reasoning and previous examples to extract insights on employee count, building size, and competitor locations. Implemented GIS tools with GeoJSON and ArcGIS Online, overcoming data cleaning challenges to create detailed maps of showroom and retail locations.
Key Achievements
- →
Utilized Storymaps in ArcGIS Online for effective visualization, balancing local and cloud-based processing based on analysis requirements.
- →
Developed gradient-based visualizations using ArcGIS API to highlight competition concentrations across the US, ensuring interpretability through interactive maps.
- →
Integrated AI-driven analysis with geospatial data, validating accuracy with GPT Vision API, to create a comprehensive competitive landscape view.
Interactive Personal Portfolio Development
Personal Project
Designed and developed an interactive personal portfolio using Astro, React, and Tailwind CSS, optimizing for performance and SEO while leveraging popular frameworks for UI development. Implemented a responsive and accessible design following W3C Web Content Accessibility Guidelines (WCAG), ensuring optimal user experience across all devices and tested using browser developer tools.
Key Achievements
- →
Created reusable components for clean and maintainable code, including navigation menu, footer, and contact form, which facilitate effective data visualization and user interaction.
- →
Integrated smooth animations using Animate.css library to enhance interactivity and visual appeal, contributing to effective data storytelling and user engagement.
- →
Optimized website performance using Lighthouse, Google PageSpeed Insights, and WebPageTest tools, achieving fast loading times and a fluid user experience with measurable improvements.
Automated Data Analysis System for Motor Vehicle Company
STRTGY
Developed an automated system for efficient analysis of large-scale web analytics data using Google Analytics metrics and dimensions, with on-demand data extraction and batch processing. Designed and implemented a comprehensive ETL pipeline, incorporating data cleaning, validation, and profiling, along with AI-driven insight generation using Large Language Models.
Key Achievements
- →
Created an intuitive dashboard with filters and KPIs using HTML, CSS, and JavaScript, enabling non-technical stakeholders to select data and view reports easily.
- →
Conducted country-specific analysis of web data, analyzing user behavior patterns and cultural nuances across metrics like Active Users, Engagement Rate, and device preferences, as well as country-specific KPIs such as Build & Price completions and test drive bookings.
- →
Established thorough documentation practices using Google Docs and version control, enhancing project transparency and replicability.
Comprehensive Time Series Analysis and Forecasting Project
STRTGY
Developed a robust time series analysis and forecasting pipeline using Python, incorporating multiple advanced models including SARIMA, Prophet, XGBoost, LSTM, and Transformer. Implemented data preprocessing techniques such as handling missing values, resampling, and feature engineering to enhance model performance.
Key Achievements
- →
Utilized concurrent processing with ThreadPoolExecutor to efficiently handle multiple SKUs, optimizing computational resources and reducing execution time.
- →
Integrated advanced visualization techniques using Matplotlib and Plotly to create interactive and informative charts for trend analysis and forecast comparison.
- →
Implemented inventory optimization algorithms, including EOQ and safety stock calculations, considering sustainability factors like CO2 emissions.
- →
Leveraged GPU acceleration for deep learning models (LSTM, Transformer) using PyTorch and TensorFlow, significantly improving training speed.
- →
Developed a custom Transformer model architecture for time series forecasting, showcasing adaptability to complex sequential data.
- →
Implemented robust error handling and logging mechanisms to ensure reliable execution across large datasets.
- →
Utilized Optuna for hyperparameter optimization, enhancing model performance through automated tuning.
- →
Integrated geospatial analysis using Folium to visualize geographical patterns in sales and inventory distribution.
Automated Interview Analysis
STRTGY
Automated survey data analysis from SurveyMonkey, reducing a 1-2 month process to seconds of script runtime. Implemented data normalization and weighted sampling to mitigate demographic biases in survey responses.
Key Achievements
- →
Utilized sentiment analysis and topic modeling on open-ended responses to extract key themes and identify market opportunities.
- →
Leveraged Python, pandas, and multi-index for complex data manipulations, creating multi-level pivot tables for cross-sectional analysis.
- →
Optimized code performance using vectorized operations and chunking techniques for efficient large dataset processing.
- →
Generated custom radar and multi-line charts with Plotly, embedded in HTML, enhancing data interpretability.
- →
Balanced company design specifications with data visualization best practices, ensuring accessibility and effective communication.
- →
Applied ANOVA and chi-square tests to identify statistically significant performance issues across groups and sections.
- →
Developed an interactive HTML dashboard for management, featuring dynamic data exploration and highlighting key insights.
Trading Strategy Backtesting
Personal Project
Extracted financial data via Alpha Vantage API and visualized trading patterns using Plotly in Python, implementing rate limiting and error handling for data consistency. Configured a MongoDB database with a document-based schema for storing varied economic data, optimizing for scalability and query performance.
Key Achievements
- →
Conducted correlation analysis on key economic indicators (GDP, unemployment, inflation, interest rates) versus market trends, implementing lag analysis for optimal impact assessment.
- →
Discovered through rigorous testing that strategies performed poorly, using metrics like Sharpe ratio and maximum drawdown, highlighting the need for advanced techniques in future projects.
Geospatial Analysis of Ciudad Guzmán
Storymaps Personal Project
Conducted exploratory geospatial analysis in ArcGIS using data from the Jalisco Seismic Network, utilizing time slider for temporal visualization. Analyzed patterns between earthquake intensity and elevation using Getis-Ord Gi* spatial statistics and Geographical Weighted Regression.
Key Achievements
- →
Created an interactive Storymaps map in ArcGIS, using templates and pop-ups to present complex geospatial data accessibly.
Data Analysis for Property Management System
BlackPrint Technologies
Conducted comprehensive data analysis on KPIs like occupancy rates and maintenance response times, comparing against industry benchmarks. Utilized Google Maps Geocoding API for advanced geocoding, implementing address normalization and validation.
Key Achievements
- →
Performed data cleaning using Python scripts with pandas, addressing inconsistencies and duplicates in large datasets.
- →
Applied pandas and numpy for complex data transformations, including multi-level aggregations and pivot tables for cross-sectional analysis.
User Engagement Analysis for SaaS Platform
Collaborative Project: AGM Analytics
Analyzed user engagement using metrics like DAU, MAU, and feature adoption rates, segmenting users by subscription tier and usage frequency. Developed custom JavaScript visualizations in Looker Studio, creating interactive sankey diagrams and heatmaps.
Key Achievements
- →
Translated analytical findings into strategic recommendations, creating layered dashboards in Looker Studio for different levels of technical understanding.