Database optimization
Up to 5x faster
Improved heavy SQL aggregations and reduced standard-query latency by 25% across core endpoints.
Full Stack Software Engineer
Gerardo Aramburo
Full Stack Software Engineer with 4 years of production experience building backend services, responsive web applications, AI-assisted engineering workflows, and deployment pipelines across FastAPI, ASP.NET, React, Angular, and SQL-heavy systems.
Recent impact includes REST API architecture, CI/CD automation, asynchronous processing, AI-assisted delivery practices, and SQL optimization that made heavy aggregations up to 5x faster.
Core Competencies
Backend, frontend, DevOps, and delivery ownership.
A practical full-stack skill set shaped by production systems, performance work, and agile team delivery.
Backend ArchitectureMicroservicesDomain-Driven DesignFastAPIASP.NETQuery OptimizationSQLAlchemyEntity FrameworkCeleryRabbitMQDockerGitHub ActionsAI-assisted DevelopmentCypressScrumKanbanTechnical Mentoring
Selected Impact
Performance, delivery, and ownership in production.
Recent project results translated into clear business and engineering outcomes.
Full-stack delivery
Backend to UI
Designed REST APIs, shipped responsive React and Angular interfaces, and covered key flows with Cypress tests.
Deployment ownership
CI/CD ready
Containerized applications with Docker and automated deployment workflows with GitHub Actions.
AI Tooling
AI-assisted engineering with human review.
A practical approach to using AI tools for faster delivery while keeping architecture, testing, and production quality under engineering ownership.
Tools used
ChatGPT, Codex, Copilot, custom OpenAI models
Used AI tools and trained custom OpenAI models for specific workflows, including repository-aware implementation support, architecture exploration, code generation, refactoring, documentation drafts, test ideas, and faster debugging loops.
Project integration
AI inside delivery workflow
Integrated AI into project work by providing concrete file context, designing workflow-specific prompts and model behavior, generating first-pass modules or scripts, and then adapting the output to team conventions and product requirements.
Working strategy
Small prompts, verified output
Used the CLI or desktop app when the AI needed direct repository context; kept prompts narrow, requested trade-offs, reviewed every change manually, and validated with linting, tests, code review, and performance measurements before merging.
Professional Experience
Four years of full-stack ownership with measurable backend impact.
Experience spans REST API architecture, domain modeling, complete module delivery, responsive frontends, asynchronous systems, CI/CD, database optimization, team collaboration, and technical mentoring.
Ordico
Software Engineer
April 2023 - Present
Remote, Mexico
Leading full-stack feature delivery, backend architecture, domain modeling, database optimization, deployment pipelines, and technical mentoring in a fast-paced product environment.
- Directed the architecture, domain modeling, and creation of complete backend modules with Python, FastAPI, ASP.NET, SQLAlchemy, and Entity Framework using microservices and Domain-Driven Design practices.
- Delivered responsive React and Angular web applications consuming REST and GraphQL APIs, coordinating with teammates through technical planning, code reviews, agile ceremonies, and iterative stakeholder feedback.
- Implemented Celery and RabbitMQ pipelines for data-intensive background processing while containerizing deployments with Docker and automating releases with GitHub Actions.
- Improved heavy SQL aggregations up to 5x and reduced standard-query latency by 25% by profiling execution plans, resolving N+1 query patterns, adding eager-loading strategies, consolidating repeated reads into set-based queries, and tuning indexes.
- Integrated AI-assisted development practices with ChatGPT, Codex CLI/Desktop App, GitHub Copilot, and custom OpenAI models trained for specific workflows to explore architecture alternatives, accelerate refactors and module scaffolding, draft documentation, and review edge cases while keeping final decisions, testing, and code quality under human review.
Instituto Tecnologico de Sonora (ITSON)
Software Developer, Professors Information System
June 2022 - February 2023
Empalme, Sonora
Built a web application to manage information about professors on the Sonora Technology Institute campus.
- Developed and optimized a full-stack web application with React, PHP, and MySQL, reducing data retrieval and update workflows from 1 hour to 5 minutes.
- Integrated Google OAuth 2.0 for reliable and secure user login.
Technical Skills
Tools and practices used across the stack.
A focused overview of the languages, frameworks, and practices used to ship reliable software.
Languages & Frameworks
PythonFastAPIC#.NETASP.NETJavaScriptTypeScriptReactAngularNodeJSPHP
Databases & ORMs
SQL ServerMySQLMongoDBSQLAlchemyEntity Framework
Architecture & Async
MicroservicesDomain-Driven DesignCeleryRabbitMQ
Testing & Quality
E2E TestingUnit TestingCypressPytestKarmaBehaveCode Reviews
DevOps & Cloud
DockerGitHub ActionsCI/CDMicrosoft Azure
AI-assisted Engineering
ChatGPTCodex CLICodex Desktop AppGitHub CopilotCustom OpenAI ModelsPromptingHuman Review
Languages
English C1Spanish Native
Education & Certifications
Software engineering foundation with Azure certification.
Formal software engineering education complemented by Microsoft Azure certification.
Instituto Tecnologico de Sonora
Bachelor's Degree in Software Engineering
2020 - 2024
Certifications
Azure AZ-204, Developing Solutions for Microsoft AzureContact
Full Stack Software Engineer
Based in Hermosillo, Sonora, with experience collaborating closely with stakeholders to deliver performant and user-centric web applications.