I’m Andrea Varela Medina, a Computer Systems Engineer focused on Applied AI, backend architecture, and digital transformation. I’ve contributed to enterprise automation and data-driven workflows by building reliable solutions that integrate tools like Power Apps and SharePoint Lists, and by deploying AI systems with strict privacy requirements on-premise.…

Andrea Varela Medina

I’m Andrea Varela Medina, a Computer Systems Engineer focused on Applied AI, backend architecture, and digital transformation. I’ve contributed to enterprise automation and data-driven workflows by building reliable solutions that integrate tools like Power Apps and SharePoint Lists, and by deploying AI systems with strict privacy requirements on-premise.…

Available to hire

I’m Andrea Varela Medina, a Computer Systems Engineer focused on Applied AI, backend architecture, and digital transformation. I’ve contributed to enterprise automation and data-driven workflows by building reliable solutions that integrate tools like Power Apps and SharePoint Lists, and by deploying AI systems with strict privacy requirements on-premise.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
Beginner
See more

Language

Spanish; Castilian
Fluent
English
Advanced
French
Beginner

Work Experience

Applied AI & Backend Engineering Intern at IDEA GTO (Instituto de Innovación, Ciencia y Emprendimiento)
March 17, 2026 - Present
Engineered and deployed an on-premise business intelligence and data retrieval platform to analyze official socioeconomic microdata (INEGI - ENIGH) without external API dependencies. Key Deliverables & Technical Impact: • Deterministic Text-to-SQL: Designed a natural language querying pipeline using local LLMs (Qwen 2.5 Coder via Ollama/llama.cpp), enforcing schema validation and elimination of hallucinations before query execution on SQLite. • Containerization & Local Deployment: Packaged the full application stack using Docker, deploying it across the institute's internal local network to ensure data privacy, zero recurring cloud API costs, and high availability. • Latency & Memory Optimization: Optimized local inference response times on dedicated consumer hardware (NVIDIA RTX 4050, 6GB VRAM) via 4-bit/8-bit model quantization and cached statistical aggregations. • Interactive Visualization: Integrated reactive dashboards in R Shiny with real-time geospatial and matrix exploratory tools using Graphic Walker. • Formally recognized with an executive letter of recommendation.
Backend & Artificial Intelligence Intern at IDEA GTO
March 1, 2026 - June 30, 2026
Designed and deployed a Market Analysis AI Agent that translates natural language questions into deterministic SQL against official socioeconomic microdata (ENIGH - INEGI) with a focus on avoiding hallucinations. Containerized and orchestrated the full stack across the local institutional intranet using Docker to isolate model runtime and ensure data privacy with zero external API dependencies. Optimized inference latency for Qwen 2.5 Coder (7B) on a dedicated NVIDIA RTX 4050 (6GB VRAM) GPU using Ollama, llama.cpp, quantization, and analytical pre-aggregations. Embedded reactive dashboards in R Shiny and delivered real-time exploratory visualization via Graphic Walker. Performance was formally endorsed through an official executive letter of recommendation.
Digital Transformation & IT Engineering Intern at General Motors
June 11, 2024 - July 27, 2024
Engineered and delivered the GM Audit Scheduler web platform at the General Motors Silao Complex within a 6-week development lifecycle. Key Business & Technical Impact: • Process Digitalization: Replaced legacy email and manual spreadsheet workflows with a centralized Power Apps Canvas application integrated with SharePoint Lists. • Measurable Operational Gain: Reduced administrative tracking overhead by 40% while ensuring 100% end-to-end audit traceability, automated notifications, and validation logic. • Plant Floor Requirements: Gathered user specifications directly on manufacturing plant lines and delivered technical training to operational personnel.
IT Intern – Digitalization & Automation at General Motors
June 1, 2024 - July 31, 2024
Built GM Audit Scheduler in six weeks using Power Apps Canvas and SharePoint Lists to schedule, track, and approve plant-wide internal audits. Replaced manual email tracking, reducing administrative overhead by 40% while introducing automated validation rules and end-to-end audit-trail traceability. Adapted system logic to evolving operational requirements and supported/trained colleagues to ensure smooth adoption.

Education

Bachelor of Computer Systems Engineering at Universidad de Guanajuato
August 17, 2020 - December 18, 2026
B.S. in Computer Systems Engineering (Degree in progress) at Universidad de Guanajuato (DICIS)
January 1, 2020 - September 18, 2026
Full Scholarship recipient (LASITS 2026) at Latin American School of Information Theory and Statistics (CIMAT LASITS 2026)
January 1, 2026 - December 31, 2026
Ful l Scholarship Recipient at Center for Research in Mathematics (CIMAT)
January 1, 2026 - September 18, 2026

Qualifications

Google Data Analytics (Data Scientist) - Santander + BEDU
January 11, 2030 - September 18, 2026
Google Cybersecurity
January 11, 2030 - September 18, 2026

Industry Experience

Computers & Electronics, Manufacturing, Software & Internet, Professional Services, Government
    SAD — Desktop Data Management System (PyQt & MongoDB)

    Developed an event-driven desktop GUI application in Python for tabular record browsing, filtering, and administration backed by a NoSQL database.

    Key Technical Highlights:
    • Modular Presentation Layer: Built an event-driven user interface leveraging PyQt widgets and Qt’s Signals & Slots architecture.
    • NoSQL Persistence: Managed dynamic document querying, updates, and collection storage with MongoDB via PyMongo.
    • Build & Packaging: Configured executable binary generation and dependency management using PyInstaller for standalone local execution.
    Repository: https://www.twine.net/signin

    LiliAgent — Voice-Enabled Virtual Assistant in Python

    Developed a modular virtual assistant in Python designed for hands-free command processing, contextual query resolution, and task automation.

    Key Technical Highlights:
    • Speech Transcription: Integrated OpenAI Whisper for real-time speech-to-text input processing.
    • Task Execution & APIs: Built natural language parsing logic connected to external REST APIs for automated system-level command execution.
    • Code Hygiene & Testing: Structured test suites with pytest to ensure command parser integrity and component reliability.

    More info here: https://www.twine.net/signin

    Genomics Data Analyzer — Cloud-Hosted Reactive Web Platform

    Engineered and deployed a production-ready bioinformatics web application in R and Shiny for statistical data exploration, quality control, and visualization of DNA/RNA genetic sequences.

    Key Technical Highlights:
    • Statistical Analytics: Executed multivariate exploratory data routines, real-time dynamic correlation matrices, and gene expression heatmaps.
    • Cloud Deployment: Hosted directly on shinyapps.io, providing interactive public access without local environment configuration requirements.
    • User-Centric Workflows: Built automated reporting modules for dynamic chart exports and statistical summary downloads.

    You can see the deployed demo here: https://www.twine.net/signin

    Modular ERP System — Python MVC Backend Architecture

    Engineered a layered, modular software architecture following the MVC design pattern for an enterprise ERP system managing inventory, procurement, finance, and user administration.
    Key Technical Deliverables:
    • Decoupled Architecture: Implemented clean separation of concerns across presentation views, business services, and database persistence layers.
    • Data Integrity & Security: Enforced ACID-compliant transactional flows, role-based access control (RBAC), input validation boundaries, and audit logging.
    • Database Persistence: Structured and mapped relational schemas across PostgreSQL and SQLite environments.

    You can find more details here: https://www.twine.net/signin

    Virtual Agent for multiple purposes

    I developed an agent to calculate the days between 2 dates given by the user spoken or written. For this project I used Python, Whisper and speech_recognition for the NLP part (to make the app understand the dates given by the user). The second part was to integrate that project with other agents, including a translator, a joke maker, a math solver a unit conversor, a cultural guide, a music app connected to YouTube and a year facts guide connected to Wikipedia. The user had a menu to choose the agent they wanted to use and the app showed the window chosen by the user with the functionality of each agent, which responded the user spoken requests.

    Medical Enterprise ERP
    erp python mongodb database nosql softwaredeveloper appdeveloper pyqt5 pyqt A personal project I made as an example of a medical enterprise ERP.…