Résumé · «Kira»
Juan Javier Ramírez Magaña
Mexico City, Mexico · Open to remote roles
55 7885 7991 · [email protected] · github.com/Kirajav
Profile
IT Infrastructure · Networking · Technical Support
Engineer with 15+ years of hands-on experience in IT support, networking and infrastructure for businesses and professional firms. Background in GPON fiber data services (Totalplay), network security with firewalls and switches, Windows and Linux administration, and Proxmox and Docker virtualization. I pair component-level hardware troubleshooting with Python and PowerShell automation. Currently preparing for the Cisco CCNA.
Embedded Systems · IoT · ESP32 Firmware
Engineer with 15+ years of hands-on technical experience, focused on embedded systems and IoT. I build C/C++ firmware for ESP32, ESP32-S3 and ESP32-C3 with MQTT, Home Assistant, ESP-NOW, OTA updates and LVGL displays, and replace the electronics of off-the-shelf smart devices (Tuya/Beken) with my own hardware and firmware. Experienced in reverse-engineering USB/MIDI protocols and in component-level electronics repair.
Applied AI · Automation · Local LLM Infrastructure
Engineer with 15+ years of hands-on technical experience, now building private AI infrastructure: local models on Ollama, a semantic router that chooses local or cloud models based on how confidential each request is, MCP servers that let an agent manage Proxmox and DNS, and Whisper transcription. Strong foundation in networking, servers, Python and automation, plus experience scoping AI solutions (RAG, chatbots, transcription) for SMBs.
Data Analysis · Business Intelligence · Automation
Engineer with 15+ years of hands-on technical experience across data, systems and operations. I build Power BI dashboards on SQL and Python (Pandas) models, connect APIs such as Mercado Libre's, and automate data collection with web scraping. Experience with real-time KPI dashboards and the corporate ERP at Vetco Gray, backed by a broad infrastructure and networking background that makes it easier to get operational data onto the dashboard.
Electronics Repair · Technical Support · Field Service
Engineer and hands-on technician with 15+ years of experience diagnosing and repairing electronic and computer equipment: laptops, PCs, printers, TVs, game consoles, UPS units and networks. I work down to component level, document every job with a diagnostic and quote report, and provide remote and on-site support to homes and offices. Field experience with GPON fiber (Totalplay) and with network and IP video-surveillance installations.
Experience
2024 – Present
Mexico City · remote and on-site
Senior IT & IoT Consultant
Self-employed (freelance)
- Provide remote and on-site IT support to accounting and architecture firms: networks, workstations, UPS units and Windows servers (setup, backups and monitoring).
- Designed and run a Proxmox homelab (VMs, LXC and Docker) hosting a private AI stack: local models on Ollama, a semantic router that keeps confidential prompts on local models and sends the rest to cloud LLMs, and an MCP server that lets a Telegram agent manage Proxmox and AdGuard DNS.
- Build C/C++ firmware (PlatformIO) for ESP32, ESP32-S3 and ESP32-C3 devices, covering water-level monitoring and pump and appliance control, with MQTT and Home Assistant auto-discovery, ESP-NOW, OTA updates and embedded web dashboards.
- Diagnose and repair laptops, PCs, printers, TVs and game consoles down to component level, delivering written diagnostic reports with photos, actions taken, the fix and a quote.
- Design PoE IP video-surveillance installations: camera selection, cabling plan, connection diagram and a visual mock-up of each camera's placement for the client.
- Reverse-engineered the USB-MIDI protocol of a pad controller (Wireshark/USBPcap captures; checksums validated against 384 real blocks) and built a Web MIDI browser editor for it.
- Automate workflows with Python and PowerShell: tablet-based PC control (per-app audio, DDC/CI monitor control, window management, keyboard and mouse) and auto-generated technical reports with diagrams.
- Full-stack web development and Power BI/SQL dashboards; market analysis with the Mercado Libre API and web scraping to set prices for computer-equipment sales.
- Scope digital-platform (website, email, domain) and AI service proposals for SMBs (RAG assistant, WhatsApp chatbot, transcription), including architecture, cost model and rollout plan.
2022–2023
Mexico City
Infrastructure Specialist
Totalplay
- Supervised GPON fiber-optic data services; provisioned and configured ONTs, routers and TV equipment.
- Configured network security (firewalls and switches) and installed wired and wireless networks for customers.
- Diagnosed and resolved network and fiber-optic incidents on-site and remotely.
2021
Mexico City
Data Analyst & Junior Developer
Vetco Gray (GE)
- Built real-time KPI dashboards with .NET, Excel/VBA and SQL database connections.
- Contributed to the architecture and development of the corporate ERP.
2011–2020
Mexico City · on-site and remote
Independent IT Technician & Consultant
Self-employed
- Repaired and maintained laptops, PCs, UPS units and printers for homes and businesses, with written diagnostics and quotes.
- Installed and maintained Windows Server machines and networks for small offices: setup, backups and monitoring.
- Built websites and landing pages with WordPress for small and medium-sized businesses.
2010–2011
Mexico City
Technical Support Consultant
Iusacell
- Provided specialized technical support to mobile users and provisioned data services remotely.
2004–2006
Mexico City
Programmer Analyst
RAM Software y Soluciones
- Developed C and C++ systems, including data validation, testing and technical documentation.
- Performed preventive and corrective maintenance on computer hardware.
Projects
2026
JamJum JP-1 Studio — MIDI controller reverse engineering
Decoded the device's SysEx protocol (pads, knobs, buttons, RGB color) and its checksums, validated 384/384 against real captures, and built a web editor with RGB effects and automated tests.
- Python
- JavaScript
- Web MIDI
- Wireshark/USBPcap
- Node.js
2026
Private AI stack on a homelab
Semantic request router (local vs. cloud, fail-closed for confidential data) with a rules dashboard, an MCP server for Proxmox and AdGuard, and a Whisper transcription server.
- Python
- FastMCP
- Docker
- Ollama
- Proxmox
2026
Tablet control surface for Windows
Python bridge that turns a tablet into a control surface: VoiceMeeter mixing, per-app volume and audio routing, DDC/CI monitor control, window manager, keyboard and mouse.
- Python
- OSC/UDP
- Win32/COM
- Node.js
2025
ESP32 liquid-level monitoring system
Modular firmware with an animated web dashboard, a 3-language captive portal, ESP-NOW mesh, MQTT with Home Assistant auto-discovery, OTA and WebSerial.
- C++
- ESP32
- MQTT
- Home Assistant
- ESP-NOW
2026
Camera-based washing-machine monitor
ESP32-S3 with a touch display (LVGL), a camera that reads the appliance's panel LEDs and an IMU for vibration; publishes cycle status to Home Assistant and streams MJPEG video.
- C++
- ESP32-S3
- LVGL
- MQTT
- Python
2026
ESP32-C3 smart switch (Tuya chip replacement)
Replaced the burnt BK7231 Wi-Fi module of a Tuya switch with an ESP32-C3 on the original PCB; custom firmware with web UI, mDNS and pump control, plus a documented root-cause analysis of resets.
- C++
- ESP32-C3
- PlatformIO
2026
Beken BK7231N flasher
Tools that use an ESP32 as a UART bridge to read and flash BK7231N chips in Tuya devices.
- Arduino
- Python
- ESP32
2026
Arduino Mega restore using an ESP32 as ISP programmer
Restored the stock bootloaders on both MCUs (ATmega2560 and ATmega16U2) after a HoodLoader2 modification.
- ESP32
- AVR
- ISP
2026
IP video-surveillance project
Residential technical proposal: 3 PoE IP cameras (bullet and dual-lens PTZ), cabling plan, connection diagram and a placement render over the façade.
- PoE IP cameras
- PTZ
- structured cabling
2026
Diagnostic report generator
Internal tool that assembles diagnostic and quote reports with SVG diagrams of the device (memory, storage, battery and disk health).
- Python
- SVG
- Word
2022
ESP32 greenhouse monitor
Temperature and humidity sensor with an embedded web page.
- C++
- ESP32
- DHT
Skills
- Networking
- LAN/WLAN, routers, switches and firewalls; GPON fiber/ONT; DNS (AdGuard Home); PoE IP video surveillance
- Systems & infrastructure
- Windows and Windows Server, Linux; Proxmox VE (VMs and LXC); Docker and Docker Compose; backups and monitoring; UPS
- Support & repair
- Remote and on-site support; component-level diagnosis and repair (laptops, PCs, printers, TVs, game consoles); preventive and corrective maintenance
- Embedded & IoT
- ESP32 / ESP32-S3 / ESP32-C3, Arduino, Raspberry Pi; C/C++ with PlatformIO and FreeRTOS; MQTT, Home Assistant, ESP-NOW, OTA; LVGL; I2C, SPI, UART; ISP programming
- Applied AI
- Ollama and local models (Qwen, Llama, DeepSeek-Coder); MCP servers (FastMCP); local/cloud LLM routing (AWS Bedrock, Gemini); Whisper; RAG and chatbot solution design
- Programming
- Python, C/C++, JavaScript/Node.js, PowerShell, SQL, HTML/CSS, PHP; React and Vue; .NET and VBA; Git/GitHub
- Data & BI
- SQL (PostgreSQL, MySQL), Power BI (DAX, Power Query), Python (Pandas), advanced Excel; APIs (Mercado Libre) and web scraping
- Tools
- Wireshark/USBPcap, PlatformIO, VS Code, Docker, Power BI Desktop
Education
Communications and Electronics Engineering
ESIME Zacatenco, National Polytechnic Institute (IPN)
2015–2020
Computer Engineering
School of Engineering, National Autonomous University of Mexico (UNAM)
2005–2008
In progress
- Cisco CCNA certification, in preparation
Languages
- Spanish (native)
- English (advanced, C1)
- Japanese (basic)
Updated: 2026-10-17