Experience & Projects

14
Projects
7
Companies
117
Skills
5
Years
2025

Electoral and Socioeconomic Geospatial Analysis

Videntia

2.5M+ Data Processed
+78% Predictive Effectiveness
Geospatial AnalysisData VisualizationReactPythonETLGeoPandasMapbox GLTypeScriptTurf.jsData ProcessingInventory Optimization

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.

2025

Intelligent Commercial Document Analysis System

Prodensa AI

+95% Extraction Accuracy
98% ↓ Processing Time
AI ApplicationDocument ProcessingReactViteTailwind CSSPDF ProcessingLLM IntegrationNLPData ExtractionFrontend DevelopmentMeta LlamaPrompt Engineering

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.

2025

Specialized Industrial Real Estate Chatbot

STRTGY

+90% Response Relevance
85% ↓ Query Time
Machine LearningNLPPythonStreamlitRAGLLMVector DatabaseData ProcessingAI ApplicationAnthropic ClaudeOpenAIPDF Generation

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.

2025

Comprehensive Data Analysis Platform for TV Shopping Company

STRTGY

99% ↓ Analysis Time
+85% User Adoption
Data AnalysisBusiness IntelligenceFastAPIReactMongoDBDashboard DevelopmentAPI DevelopmentETLMaterial UIPythonJavaScriptData VisualizationMicroservicesSQLDatabase ManagementAPI IntegrationPerformance Optimization

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.

2025

Advanced Demand Forecasting & Inventory Optimization System

STRTGY

+42% Forecast Accuracy
30% ↓ Inventory Cost
Time Series AnalysisMachine LearningPythonReactTypeScriptData ProcessingInventory OptimizationProphetSARIMAETLData VisualizationChart.js

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.

2024

GeoAI Insights: Advanced Visualization of the Competitive Landscape

STRTGY

+82% Decision Confidence
70% ↓ Market Analysis Time
Geospatial AnalysisMachine LearningData VisualizationOpenAIGISSocial Media AnalyticsMarket AnalysisStrategic PlanningDecision Support Systems

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.

2024

Interactive Personal Portfolio Development

Personal Project

97/100 Page Speed
100% Accessibility
Web DevelopmentUI/UX DesignPerformance OptimizationReactTailwind CSSAstroContent ManagementGitVersion ControlResponsive DesignAccessibilityComponent-Based ArchitectureAnimation

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.

2024

Automated Data Analysis System for Motor Vehicle Company

STRTGY

90% ↓ Analysis Time
+45% Reporting Quality
AutomationETLData AnalysisDocumentationSurvey DataData CleaningAI-Driven Insight GenerationUser Interface DesignData SelectionRapid Report Generation

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.

2024

Comprehensive Time Series Analysis and Forecasting Project

STRTGY

+37% Forecasting Accuracy
~25% Cost Reduction
Time Series AnalysisForecastingPythonMachine LearningDeep LearningData PreprocessingVisualizationInventory OptimizationGPU AccelerationHyperparameter OptimizationGeospatial Analysis

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.

2023

Automated Interview Analysis

STRTGY

99.9% ↓ Processing Time
+75% Insight Depth
AutomationData AnalysisData VisualizationSurveyMonkeySurvey AnalysisPythonPandasMulti-IndexPlotlyHTMLInteractive VisualizationCustom VisualizationsEmployee Feedback AnalysisPerformance AnalysisOrganizational Improvement

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.

2023

Trading Strategy Backtesting

Personal Project

10x Testing Speed
24 Model Variants
Financial AnalysisData AnalysisAPI IntegrationPythonPlotlyMongoDBDatabase ManagementTrading StrategiesEconomic Data AnalysisMarket Trend AnalysisCorrelation AnalysisStrategy DevelopmentBacktesting

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.

2022

Geospatial Analysis of Ciudad Guzmán

Storymaps Personal Project

+63% Risk Prediction
4,700+ Data Points
Geospatial AnalysisData VisualizationArcGISEarthquake AnalysisElevation AnalysisInteractive MappingUrban PlanningDisaster Preparedness

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.

2022

Data Analysis for Property Management System

BlackPrint Technologies

+92% Location Accuracy
65% ↓ Response Time
Data AnalysisGeospatial AnalysisDatabase ManagementProperty ManagementData IntegrityOperational EfficiencyPythonPandasNumpyData ManipulationData PreparationAdvanced GeocodingLocation-Based Data

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.

2021

User Engagement Analysis for SaaS Platform

Collaborative Project: AGM Analytics

+28% User Retention
+41% Feature Adoption
Data AnalysisData VisualizationBusiness IntelligenceSaaS PlatformUser EngagementUser Behavior AnalysisUsage TrendsCustomer BehaviorData Visualization TechniquesActionable InsightsBusiness Decision-MakingStrategic Objectives

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.