Return to site

Allan Galarza

Senior Software Engineer | Backend, Data, DevOps

Senior Software Engineer with 10 years of experience building reliable, maintainable software across finance and large-scale community platforms. Creator of NabBot, a Discord bot ecosystem recognized as an official Promoted Fansite by Tibia’s developers.

Specialized in backend development with Python (FastAPI) and Kotlin (Ktor), with extensive experience designing and operating databases at scale — handling hundreds of millions of rows while ensuring performance and reliability.

Skilled in API design and implementation, from data-heavy financial services to real-time gaming platforms, with a strong focus on clean, documented code and sustainable architectures.

Hands-on with DevOps practices for small to medium-scale environments: containerized deployments, CI/CD workflows, and observability tooling to keep services stable and maintainable.

Mexico[email protected]Galarzaa90galarzaa.com

Skills & Tools

PythonPythonFastAPIFastAPIKotlinKotlinKtorKtorPostgreSQLPostgreSQLDockerDockerGitHub ActionsGitHub ActionsGitLab CI/CDGitLab CI/CDRabbitMQRabbitMQJavaJavaC#C#TypeScriptTypeScriptJavaScriptJavaScriptNode.jsNode.jsDjangoDjangoaiohttpaiohttpSQLAlchemySQLAlchemyPydanticPydanticRedisRedisMySQLMySQLSQLiteSQLiteMicrosoft SQL ServerSingleStoreSingleStoreOracleCaddyCaddynginxnginxPrometheusPrometheusGrafanaGrafanaMetabaseMetabaseSonarQubeSonarQubeSentrySentryPortainerPortainerGradleGradlegitgitPostmanPostmanIntelliJ IDEAIntelliJ IDEAPyCharmPyCharmVisual Studio CodeVisual StudioAndroid StudioAndroid StudioUbuntuUbuntuWindowsmacOSmacOSAndroidAndroid.NET.NETAngularAngularNext.jsNext.jsMaterial for MkDocsMaterial for MkDocsSphinxSphinxRead The DocsRead The DocsDiscordDiscordRaspberry PiRaspberry PiArduinoArduinoProcessingProcessingC++C++

Work Experience

Fully ParsedAugust 2024 - Present
Tech Design LeadJune 2025 - Present

Early-stage startup building data processing and reporting platforms for financial and investment workflows.

  • Integrated LLM-assisted components into data processing pipelines to transform, validate, and enrich structured datasets.
  • Designed end-to-end data processing workflows combining deterministic pipelines with LLM-assisted components for transforming and validating structured financial data.
  • Defined architectural patterns for integrating LLM-based systems into production, including prompt design, validation layers, and error handling.
  • Provided technical guidance and architectural feedback to engineers during design and implementation.
TypeScriptTypeScriptMongoDBMongoDBOpenAIOpenAI
Software Engineer (Contractor)August 2024 - May 2024 | Part-time

Startup developing data processing and reporting workflows for financial and investment-related domains.

  • Reduced report generation time by 60% through backend optimizations and data aggregation improvements.
  • Designed and implemented APIs for workflow orchestration and data analysis, leveraging containerized services on GCP with Windmill for scalable task execution.
  • Improved developer onboarding and deployment speed by building a modular architecture that supports scripts in multiple languages with automatic dependency management.
TypeScriptTypeScriptReactReactRemixRemixMongoDBMongoDBPythonPythonFastAPIFastAPIOpenAIOpenAI
EncoraNovember 2020 - June 2024
Software Engineer

Backend developer and database administrator for oil & gas industry applications.

  • Built and maintained APIs for monitoring thousands of pipelines and processing millions of sensor records daily, focusing on data analysis and presentation for operational insights.
  • Led a major backend refactor introducing FastAPI + Pydantic, improving maintainability, boosting documentation quality, and accelerating collaboration with frontend teams.
  • Developed backend services to map equipment and sensor data, consolidating previously fragmented internal apps into a unified system.
  • Built event-driven services consuming sensor data streams to trigger automated warnings, alarms, and operational controls based on real-time conditions.
  • Maintained CI/CD pipelines using GitHub Actions with Docker with on-prem Kubernetes, managing deployments and ensuring system reliability.
PythonPythonSwaggerSwaggeraiohttpaiohttpSingleStoreSingleStoreRedisRedisOracle DatabaseFastAPIFastAPIDockerDockerRabbitMQRabbitMQSQLAlchemySQLAlchemyGitHub ActionsGitHub Actions
JoybyteJune 2020 - October 2020
Software Engineer

Collaborated with a team of freelance engineers under an in-house technical lead to support backend development for a pregnancy tracking mobile app.

  • Designed and implemented APIs to provide stage-specific health tips, pregnancy tracking, and clinic referrals based on user profiles.
  • Built and optimized a relational database using a Database-First approach, focusing on scalability and flexible schema evolution.
  • Developed stored procedures and backend logic to tailor information dynamically to each user’s pregnancy stage and tracked health data.
C#C#.NET.NETAzure FunctionsMicrosoft SQL Server
Gila SoftwareMay 2019 - October 2020
Software Engineer

Worked on multiple client projects as part of the backend team, following Scrum methodology. Took strong initiative on addressing technical debt and improving code quality practices across the company.

  • Built backend services for a replacement inspection and inventory platform, focusing on database design and microservice architecture with Azure Functions.
  • Delivered APIs and offline-capable features for a fire & security inspection mobile app, essential for facilities where connectivity was unreliable.
  • Automated generation of regulatory fire and safety reports, eliminating manual report creation for clients.
  • Supported additional projects including a startup social media pilot and a travel CMS, contributing features and bug fixes as required.
  • Compiled and drove adoption of a technical debt reduction plan for the inspection app, which reduced bug rates and improved overall maintainability.
  • Researched and trialed SonarQube integration into CI/CD pipelines, laying groundwork for company-wide static analysis (though not fully adopted).
C#C#.NET.NETAzure FunctionsMicrosoft SQL ServerXamarinPythonPythonDjangoDjango
LyF IngenieríaJanuary 2018 - May 2019
Software Engineer

Developed applications and device libraries for money management systems, enhancing functionality, third-party integrations, and transaction monitoring.

  • Built end-user kiosk applications integrating multiple money devices (acceptors, dispensers, validators) for payments, utilities, and banking transactions — deployed in production, including international installations.
  • Developed reusable software interfaces for MEI and CC-Talk devices, enabling both in-house and customer integrations.
  • Integrated real-time monitoring services into kiosk apps, providing transaction tracking and auditability.
  • Designed and managed supporting web services and databases to ensure transactional integrity and availability.
  • Contributed quality improvements while temporarily outsourced at Qualisys for SAP Business One addon development.
C#C#.NET.NETJavaScriptJavaScriptNodeJSNodeJSGradleGradleKotlinKotlinRaspberry PiRaspberry PiAngularJSAngularJSElectronElectronSQLiteSQLiteMySQLMySQL
i3June 2015 - December 2017
Innovation Development Engineer

Developed applied R&D projects at the intersection of embedded systems, Android applications, and hardware design.

  • Built an Android BLE app and UI to control ATV headlights, mounted and tested with embedded hardware systems.
  • Designed CAD-based protective enclosures for electronic control devices, ensuring functional durability in mechanical assemblies.
  • Developed an aquaponics greenhouse monitoring system, integrating sensors for temperature, pH, dissolved oxygen, humidity, and light, with a backend for real-time data collection.
  • Designed both the embedded UI and mobile companion app for a dispensing machine demo, featuring QR-based login and a credit management system backed by a database.
  • Produced detailed technical and feasibility reports supporting research and innovation activities.
AndroidAndroidJavaJavaC++C++ArduinoArduinoProcessingProcessingPythonPythonProteusProteusSolidWorksSolidWorks

Projects

NabBotMarch 2016 - Present

Discord bot ecosystem for the MMORPG Tibia, recognized as a Promoted Fansite by the game’s developers and listed on the official Tibia website. Used in over 17,000 servers worldwide.

  • Serves 6,000 monthly active users and handles an average of 114,000 command requests per month.
  • Built services to scrape and process game data, generating large historical datasets (235M+ records across player activity and events).
  • Provides real-time event notifications and account-linked insights for players.
  • Migrated the codebase from Python to Kotlin, consolidating into a monorepo and improving maintainability through static typing and unified service architecture.
  • Implemented automated pipelines with GitLab CI/CD to build, test, and deploy Docker images to a self-managed Ubuntu VDS.
  • Set up observability with Prometheus, Grafana, and Metabase, ensuring reliable monitoring and long-term uptime.
DiscordDiscordPythonPythonaiohttpaiohttpPostgreSQLPostgreSQLAngularAngularNext.jsNext.jsUbuntuUbuntuTypeScriptTypeScriptSocket.IOSocket.IORedisRedisGitLab CI/CDGitLab CI/CDDockerDockerPrometheusPrometheusGrafanaGrafanaMetabaseMetabaseGradleGradleKotlinKotlinKtorKtor
On-Demand Medical Service AppSeptember 2023 - March 2024

Engineered the backend for a mobile platform connecting patients and doctors, with integrations for payments, mapping, and notifications.

  • Designed and implemented an HTTP API backend to support iOS and Android apps.
  • Built a relational database with PostGIS extensions for geospatial queries, managing users, service history, and ratings.
  • Integrated Stripe Connect for in-app payments between patients and doctors.
  • Implemented Google Maps API for travel time estimation and geocoding.
  • Configured Firebase Cloud Messaging to deliver real-time server-to-mobile notifications.
  • Deployed as a Docker Compose project on a VPS, including application and database containers.
PythonPythonFastAPIFastAPIPostgreSQLPostgreSQLSQLAlchemySQLAlchemyStripeStripeGoogle MapsGoogle MapsFirebaseFirebaseDockerDockerSentrySentry
Car Insurance Web appApril 2021 - December 2021

Took over development of a car insurance quotation platform, improving code quality while delivering new backend and frontend features.

  • Integrated a third-party REST API for geocoding and insurance quote generation.
  • Designed models for serialization and database storage of users, quotations, and policies.
  • Extended the admin panel with tools to manage users, quotations, and insurance policies.
  • Built front-facing web forms for generating insurance quotes.
  • Cleaned up and standardized frontend code, significantly improving maintainability of the CSS and UI.
PythonPythonDjangoDjangoJavaScriptJavaScriptjQueryjQueryBootstrapBootstrapPostgreSQLPostgreSQL
tibia.pyJuly 2018 - Present

Python library for scraping and deserializing Tibia.com data, originally extracted from NabBot and maintained as a standalone package.

  • Published on PyPI and GitHub with full documentation on Read the Docs, plus a Dockerized API server for quick deployment.
  • Reached 40+ GitHub stars and averages ~350 monthly downloads, with adoption by community developers beyond NabBot.
  • Designed strongly typed data models and a client API to standardize scraped content.
  • Maintained >90% test coverage, ensuring reliability even as Tibia.com changed its HTML structure.
  • Continues in active maintenance, providing fixes for site changes while the feature set remains stable and complete.
PythonPythonaiohttpaiohttpPydanticPydanticFastAPIFastAPIGitHub ActionsGitHub ActionsDockerDocker
DodoAugust 2016 - April 2019

Side project developed with a small team as a two-sided job marketplace app.

  • Built a native Android application with geolocation services to match users offering and requesting odd jobs.
  • Migrated the codebase from Java to Kotlin during Android’s adoption of Kotlin as an official language, improving readability and maintainability.
  • Integrated Firebase Messaging Service for job notifications and progress tracking.
  • Implemented Google authentication using Firebase for account management.
  • Designed and connected the app to a SQL database for storing user and job data.
  • Introduced GitLab CI/CD pipelines to automatically generate APK builds, enabling the team to test and share updated versions throughout development.
GradleGradleJavaJavaKotlinKotlinAndroidAndroidMySQLMySQLFirebaseFirebaseGitLab CI/CDGitLab CI/CD