Juan – Python, React, AWS

This is a cloud-based Transportation Management System is tailored for the produce industry, specializing in temperature-controlled freight logistics. It offers ERP integration, AI load optimization, real-time tracking, and automated workflows to help shippers, brokers, and carriers increase efficiency and profitability in perishable goods transportation.

• Led Python version migration from 3.7 to 3.9, modernizing the application infrastructure to leverage performance improvements, security patches, and new language features while ensuring zero-downtime deployment;
• Optimized database performance by analyzing slow queries, implementing strategic indexes, and fine-tuning SQLAlchemy configurations, resulting in significant query response time improvements and enhanced system scalability;
• Reduced end-to-end testing time by 50% through the implementation of intelligent caching strategies and the elimination of flaky Cypress tests, accelerating the CI/CD pipeline and improving developer productivity;
• Architected a comprehensive refactor of Famous ERP integration, consolidating duplicate codebases into a unified, maintainable solution and establishing standardized patterns for feature development in this core system component, improving integration reliability and reducing technical debt.

The project is an online interior design platform that connects customers with professional designers to transform their living spaces. Founded over 10 years ago, it uses a style quiz for personalized matching and has completed nearly 1 million designs. The platform offers expert consultations, 3D renderings, and access to curated home furnishings, making professional interior design accessible and affordable for homeowners.

• Built modern web interfaces with Next.js/React, delivering responsive, high-performance applications that improved user engagement and reduced client-side rendering overhead;
• Used GraphQL API layer using Node.js, enabling flexible data querying capabilities;
• Engineered automated data pipelines using Apache Airflow to process and transform large-scale datasets, reducing manual processing time and ensuring reliable, scheduled data operations;
• Sustained critical PHP legacy applications, providing bug fixes and feature updates while documenting systems for future modernization efforts.

The client is a mid-sized company that manufactures white-label furniture for several major furniture retailers in Mexico. Juan's primary responsibility was to develop a system that links their existing ERP (SAI) to a web interface for managing weekly payroll and production lines.

• Engineered an automated data synchronization pipeline between a private ERP system and AWS infrastructure, ensuring real-time data consistency and enabling seamless import operations while maintaining data integrity across platforms;
• Developed a comprehensive payroll tracking system that automatically aggregates and monitors all billable items, time entries, and deductions throughout the week, streamlining payroll processing and reducing calculation errors;
• Built a dynamic cost calculation engine for furniture product lines, enabling real-time pricing analysis across multiple models by factoring in materials, labor, and overhead to support accurate quoting and margin optimization;
• Designed a custom labeling solution that generates furniture tracking labels with barcode/QR code output and integrates with standard printers, eliminating dependency on expensive third-party labeling software and reducing operational costs;
• Implemented role-based access control (ACL) system across all application modules, enforcing granular permissions and security policies to protect sensitive business data and ensure compliance.

This project involves a corporate mobility platform located in Jalisco, Mexico, designed to offer efficient transportation solutions for employees while also supporting sustainable initiatives for businesses. The company aims to be a strategic partner in fostering business growth by ensuring the safe and efficient transport of employees. The client caters to prominent companies in Jalisco that prioritize employee well-being and seek reliable commuting solutions for their workforce.

• Architected and deployed RESTful APIs using PHP/Laravel framework, enabling seamless integration between multiple systems and supporting business-critical operations with secure, scalable endpoints;
• Built internal productivity tools as Single Page Applications with React/Redux, streamlining workflows for operations teams and reducing manual task completion time through intuitive, real-time interfaces;
• Developed native Android applications in Kotlin, delivering mobile solutions that enhanced field operations and provided offline-first capabilities for improved user experience;
• Created data analysis and automation tools with Python, transforming raw datasets into actionable insights and automating repetitive processes to improve operational efficiency;
• Engineered IoT solutions integrating Raspberry Pi and Arduino microcontrollers with fingerprint readers and NFC technology, developing custom hardware-software systems for access control and attendance tracking applications.