Allan Galarza

Senior Software engineer with 8 years of experience focused for building high-quality, maintainable code. With experience across diverse industries like oil and gas, healthcare, electronics and finance.

Proficient in various programming languages and technologies such as Python, Kotlin, C# and SQL, prioritizing following best practices for clean and well-documented codebases.

Extensive experience designing and implement robust databases to support different sorts of applications as well as designing and developing well-documented and APIs.

With experience in system administration on virtual servers, container deployments and monitoring systems, as well as designing and maintaining CI/CD workflows.

Mexico
galarzaa.com

Skills & Tools

  Python
  Kotlin
  C#
  Java
  JavaScript
  TypeScript
  C++
  Android
  .NET
  Node.js
  Angular
  Pydantic
  FastAPI
  aiohttp
  Django
  Material for MkDocs
  Sphinx
  Read The Docs
  Ktor
  SQLAlchemy
  Raspberry Pi
  Arduino
  Processing
  Discord
  PostgreSQL
  MySQL
  SQLite
  Microsoft SQL Server
  SingleStore
  Oracle
  Redis
  GitHub Actions
  GitLab CI/CD
  Docker
  Gradle
  Portainer
  nginx
  Grafana
  Metabase
  Prometheus
  SonarQube
  Sentry
  Android Studio
  IntelliJ IDEA
  PyCharm
  Visual Studio
  Visual Studio Code
  git
  Postman
  SolidWorks
  Ubuntu
  Windows
  macOS
API Design
PCB Design
Digital Electronics

Work Experience

Encora November 2020 — Present
Previously known as Nearsoft. Working as a backend developer and database administrator.
  • Design, development and maintenance of APIs for mobile and web apps to monitor and analyze pipeline flows and metrics in the oil industry.
  • Design and development of a backend application to create mappings between field equipment and field sensor data.
  • Development of service tasks to synchronize data and create events based on parameter configurations.
  • Management of GitHub actions workflows to build and deploy Docker images to on-premises Kubernetes infrastructure.
º
 Python  Swagger  aiohttp  SingleStore  Redis  Oracle  FastAPI  Docker  RabbitMQ  SQLAlchemy  GitHub Actions
Joybyte June 2020 — October 2020
Assisted the backend team during off-hours in developing a new release for a mobile pregnancy tracking app.
  • Designed APIs for the mobile app, providing information based on the user's registered due date and tracked health information, while providing tips and information based on their current pregnancy stage, as well as referring to health clinics.
  • Implemented Database First design and management, aiming for scalability and flexibility.
  • Developed and maintained stored procedures and other database logic, creating tailored information for users based on their pregnancy stage, symptom tracking and other information.
º
 C#  .NET  Azure Functions  Microsoft SQL Server
Gila Software May 2019 — October 2020
Worked on multiple projects for multiple clients as part of the backend development team, following scrum methdology, taking strong initiative on standardizing good coding practices across the company and the use of code quality tools.
  • Developed the backend for a web application to create and manage dynamically generated inspections and inventory. From the design of the database, to the microservice achitecture using Azure functions, letting administrators create dynamic inspection surveys based on attributes and previous answers.
  • Contributed to the development and maintenance of a reporting tool that created formatted reports based on inspection answers and data, allowing to quickly obtained compliant fire and security results reports.
  • Development of the backend of a multiplatform mobile app for fire & security inspections, including API development as well as application features and logic, letting users fill out surveys on mobile devices from dynamically selected questions, while also working without a network connection to ensure an interruption free inspection.
  • Contributed to the development of a mobile social media platform tailored for entrepreneurs and startups to show case their projects, share progress and look for private investors or be selected by government programs.
  • Maintenance of a booking and travel content management system.
  • Researched and implemented a company wide code analysis tool to integrate into projects CI/CD pipelines to generate reports on bad coding practices, potential bugs and security problems.
º
 C#  .NET  Azure Functions  Microsoft SQL Server  Xamarin  Python  Django
LyF Ingeniería January 2018 — May 2019
Developed applications and libraries for money management devices, enhanching funcionality and integration with third party services.
  • Created applications for end-users, deployed in kiosks with multiple money devices, allowing users to pay services, utilities or make bank transactions, focusing on accesibility and ease of use.
  • Designed and developed software interfaces for acceptors, dispensers, and other money devices to be used internally for application development or to be offered to customers for their own integration, focusing on usage and features documentation.
  • Integrated in-house monitoring services on end-user applications, keeping track of money transactions for quality and auditing purposes.
  • Integrated third-party banking and payment services, expanding payment options and enhancing transaction processing.
  • Developed and managed web services to support the core functionality of monitoring services.
  • Managed local and remote databases, ensuring data integrity and availability.
  • Implemented quality coding practices in the software department, contributing to the overall reliability of the software.
  • Temporary outsourced at Qualisys to aid in development of SAP Business One addons.
º
 C#  .NET  JavaScript  NodeJS  Gradle  Kotlin  Raspberry Pi  AngularJS  Electron  SQLite  MySQL
i3 June 2015 — December 2017
Development of innovation oriented projects in different areas. My work was focused on electronics, microcontrollers and software.
  • Created an Android app using Bluetooth LE technology to communicate with an embedded device, controlling ATV headlights to adjust for vehicle movement and ensure optimal illumination and visibility.
  • Designed and manufactured protective cases for electronic control devices, ensuring durability against environmental factors and strong movements.
  • Developed an Android app for remote monitoring of ambient conditions in aquaponic greenhouses, improving the life quality of fish and plants while reducing energy consumption.
  • Developed and implemented a backend system to monitor and collect sensor data from devices, providing historical data to assess the performance of aquaponic greenhouses.
  • Developed an embedded Android app serving as a user interface for dispensing machines, featuring a QR login system integrated with a companion mobile app to manage user credit and purchase history.
  • Researched and authored technical reports documenting project details, feasibility, and market studies.
º
 Android  Java  C++  Arduino  Processing  Python  Proteus  SolidWorks

Projects

NabBot March 2016 — Present
Discord bot focused on the MMO Tibia used in over 15,000 Discord servers. An interactive bot that answers to different commands, handles a user database and does realtime updates based on game events. The project is composed of multiple smaller services and applications to handle data gathering and communication.
  • Developed a service that periodically scrapes the game's website in order to detect changes between scans, generating historical data for the players.
  • Developed a chat bot that offers users synthetized information from the game's website, and allows linking their game data to their Discord accounts.
  • Developed a notification system through Discord that notifies users of game events based on their specific settings.
  • Recognized as a Promoted Fansite by the game developers, being featured on their official website and being granted additional benefits for being part of their programme.
  • Implemented automated build, testing and deployment pipelines using GitLab CI/CD, generating Docker images on private registries for deployment.
  • Migrated of codebase from Python to Kotlin, redesigning the service architecture from scratch for better performance and scalability.
  • Set up and managed self-managed virtual server on Ubuntu, creating and installing tools for deployment and monitoring of application services.
 Discord  Python  aiohttp  PostgreSQL  Angular  Ubuntu  TypeScript  Socket.IO  Redis  GitLab CI/CD  Docker  Prometheus  Grafana  Metabase  Gradle  Kotlin  Ktor
On-Demand Medical Service App September 2023 — March 2024
  • Designed and developed an HTTP API serving as the backend for an on-demand medical services mobile application (iOS & Android)
  • Designed SQL database for application storage, containing users, service history, ratings and more as well as using PostGIS to work with coordinates.
  • Integrated Stripe services using Stripe Connect workflow for in-app payments.
  • Integrated of Google Maps API for travel time calculations and geocoding, showing users estimated wait times.
  • Implemented Firebase Cloud Messaging service to allow communication of events and notifications between the server and mobile applications.
 Python  FastAPI  PostgreSQL  SQLAlchemy  Stripe  Google Maps  Firebase  Docker  Sentry
Car Insurance Web app April 2021 — December 2021
Worked on the integration of a third party REST API containing geocoding information and car insurance quote generation.
  • Integrated geocoding and insurance quoting API, and designed models for serialization and database.
  • Added admin panel sections to manage users, quotation and insurance policies.
  • Added front-facing sections to web app containing forms to generate quotes.
  • Cleaned up and made quality improvements in most of the app.
 Python  Django  JavaScript  jQuery  Bootstrap  PostgreSQL
tibia.py July 2018 — Present
Open source web scrapping library that extracts information from the website Tibia.com and deserializes it into Python data.
  • Designed strongly typed data models to represent the scrapped data into standardized objects.
  • Developed an asynchronous HTTP client to fetch content HTML content and convert it into Python objects.
  • Developed a test-driven Python library for the community to use in their own projects without having to worry about data extraction.
  • Developed GitHub Actions workflows to run unit tests, static code analysis, documentation sites deployment, Docker image building and deployment.
 Python  aiohttp  Pydantic  FastAPI  GitHub Actions  Docker
Dodo August 2016 — April 2019
Android application and web service featuring a two-sided network for odd jobs.
  • Developed native Android application with geolocation services to find users needing services in a close area.
  • Integrated Firebase Messaging Service to notify users of job offers and for them to trackt their progress.
  • Implemented authentication service using Firebase to allow users to sign-in through Google.
  • Designed SQL database to store user and job data.
 Gradle  Java  Kotlin  Android  MySQL  Firebase  GitLab CI/CD
Allan Galarza

Contact

 allan.galarza@gmail.com

 LinkedIn

 Galarzaa90

 Galarzaa90

Languages

Spanish (Native)

English (Professional)

Portuguese (Basic)

Interests

Electronics

Internet of Things

Gaming

PC Building

About Me

Senior Software engineer with 8 years of experience focused for building high-quality, maintainable code. With experience across diverse industries like oil and gas, healthcare, electronics and finance.

Proficient in various programming languages and technologies such as Python, Kotlin, C# and SQL, prioritizing following best practices for clean and well-documented codebases.

Extensive experience designing and implement robust databases to support different sorts of applications as well as designing and developing well-documented and APIs.

With experience in system administration on virtual servers, container deployments and monitoring systems, as well as designing and maintaining CI/CD workflows.

Skills & Tools

Work Experience

Encora

Software Engineer
November 2020 — Present

Previously known as Nearsoft. Working as a backend developer and database administrator.

  • Design, development and maintenance of APIs for mobile and web apps to monitor and analyze pipeline flows and metrics in the oil industry.
  • Design and development of a backend application to create mappings between field equipment and field sensor data.
  • Development of service tasks to synchronize data and create events based on parameter configurations.
  • Management of GitHub actions workflows to build and deploy Docker images to on-premises Kubernetes infrastructure.

Freelance Developer
June 2020 — October 2020

Assisted the backend team during off-hours in developing a new release for a mobile pregnancy tracking app.

  • Designed APIs for the mobile app, providing information based on the user's registered due date and tracked health information, while providing tips and information based on their current pregnancy stage, as well as referring to health clinics.
  • Implemented Database First design and management, aiming for scalability and flexibility.
  • Developed and maintained stored procedures and other database logic, creating tailored information for users based on their pregnancy stage, symptom tracking and other information.

Software Engineer
May 2019 — October 2020

Worked on multiple projects for multiple clients as part of the backend development team, following scrum methdology, taking strong initiative on standardizing good coding practices across the company and the use of code quality tools.

  • Developed the backend for a web application to create and manage dynamically generated inspections and inventory. From the design of the database, to the microservice achitecture using Azure functions, letting administrators create dynamic inspection surveys based on attributes and previous answers.
  • Contributed to the development and maintenance of a reporting tool that created formatted reports based on inspection answers and data, allowing to quickly obtained compliant fire and security results reports.
  • Development of the backend of a multiplatform mobile app for fire & security inspections, including API development as well as application features and logic, letting users fill out surveys on mobile devices from dynamically selected questions, while also working without a network connection to ensure an interruption free inspection.
  • Contributed to the development of a mobile social media platform tailored for entrepreneurs and startups to show case their projects, share progress and look for private investors or be selected by government programs.
  • Maintenance of a booking and travel content management system.
  • Researched and implemented a company wide code analysis tool to integrate into projects CI/CD pipelines to generate reports on bad coding practices, potential bugs and security problems.

Software Engineer
January 2018 — May 2019

Developed applications and libraries for money management devices, enhanching funcionality and integration with third party services.

  • Created applications for end-users, deployed in kiosks with multiple money devices, allowing users to pay services, utilities or make bank transactions, focusing on accesibility and ease of use.
  • Designed and developed software interfaces for acceptors, dispensers, and other money devices to be used internally for application development or to be offered to customers for their own integration, focusing on usage and features documentation.
  • Integrated in-house monitoring services on end-user applications, keeping track of money transactions for quality and auditing purposes.
  • Integrated third-party banking and payment services, expanding payment options and enhancing transaction processing.
  • Developed and managed web services to support the core functionality of monitoring services.
  • Managed local and remote databases, ensuring data integrity and availability.
  • Implemented quality coding practices in the software department, contributing to the overall reliability of the software.
  • Temporary outsourced at Qualisys to aid in development of SAP Business One addons.

Innovation Development Engineer
June 2015 — December 2017

Development of innovation oriented projects in different areas. My work was focused on electronics, microcontrollers and software.

  • Created an Android app using Bluetooth LE technology to communicate with an embedded device, controlling ATV headlights to adjust for vehicle movement and ensure optimal illumination and visibility.
  • Designed and manufactured protective cases for electronic control devices, ensuring durability against environmental factors and strong movements.
  • Developed an Android app for remote monitoring of ambient conditions in aquaponic greenhouses, improving the life quality of fish and plants while reducing energy consumption.
  • Developed and implemented a backend system to monitor and collect sensor data from devices, providing historical data to assess the performance of aquaponic greenhouses.
  • Developed an embedded Android app serving as a user interface for dispensing machines, featuring a QR login system integrated with a companion mobile app to manage user credit and purchase history.
  • Researched and authored technical reports documenting project details, feasibility, and market studies.

Technical Manager Assistant
April 2015 — May 2015

Assisted the technical manager and planned the project: Feasibility study of photovoltaic cells for airport gas stations electricity supply.

  • Implemented solar tracking algorithms in microcontroller based systems.
  • Designed and assembled an embedded motor control system for protyping solar trackers.
  • Designed solar tracking mechanical structures for photovoltaic cells, featuring mechanisms to perform automatic facet canting to increase the energy efficiency of the cells.
  • Published patent as co-inventor: System and method for the automatic facet canting of heliostats. (Patent Number: MX2015008322A, December 2016).

Developer
July 2014 — November 2014

Developed an energy saving control system, focused on school classrooms, based on configurable schedules obtained from a server, reducing manual efforts and providing energy savings to schools.

  • Designed and developed embedded systems to install in classrooms, using infrarred LED to emit sequences to control devices, with an internal memory storing code sequences.
  • Developed an Android application to create, view and modify classroom schedules to manage air conditioning units automatically.

Intern Developer
January 2014 — July 2014

Developed an alternative control system for heliostats solar tracking. An economic and open platform using Arduino, as an alternative to the private systems using CompactRIO by National Instruments.

  • Adapted a solar position algorith to run efficiently on an embedded system with lower hardware specifications.
  • Developed graphical interfaces to control, monitor, and test solar tracking mechanisms, fine-tuning PID control values for optimal performance.

Projects

March 2016 — Present

Discord bot focused on the MMO Tibia used in over 15,000 Discord servers. An interactive bot that answers to different commands, handles a user database and does realtime updates based on game events. The project is composed of multiple smaller services and applications to handle data gathering and communication.

  • Developed a service that periodically scrapes the game's website in order to detect changes between scans, generating historical data for the players.
  • Developed a chat bot that offers users synthetized information from the game's website, and allows linking their game data to their Discord accounts.
  • Developed a notification system through Discord that notifies users of game events based on their specific settings.
  • Recognized as a Promoted Fansite by the game developers, being featured on their official website and being granted additional benefits for being part of their programme.
  • Implemented automated build, testing and deployment pipelines using GitLab CI/CD, generating Docker images on private registries for deployment.
  • Migrated of codebase from Python to Kotlin, redesigning the service architecture from scratch for better performance and scalability.
  • Set up and managed self-managed virtual server on Ubuntu, creating and installing tools for deployment and monitoring of application services.

September 2023 — March 2024

  • Designed and developed an HTTP API serving as the backend for an on-demand medical services mobile application (iOS & Android)
  • Designed SQL database for application storage, containing users, service history, ratings and more as well as using PostGIS to work with coordinates.
  • Integrated Stripe services using Stripe Connect workflow for in-app payments.
  • Integrated of Google Maps API for travel time calculations and geocoding, showing users estimated wait times.
  • Implemented Firebase Cloud Messaging service to allow communication of events and notifications between the server and mobile applications.

April 2021 — December 2021

Worked on the integration of a third party REST API containing geocoding information and car insurance quote generation.

  • Integrated geocoding and insurance quoting API, and designed models for serialization and database.
  • Added admin panel sections to manage users, quotation and insurance policies.
  • Added front-facing sections to web app containing forms to generate quotes.
  • Cleaned up and made quality improvements in most of the app.

July 2018 — Present

Open source web scrapping library that extracts information from the website Tibia.com and deserializes it into Python data.

  • Designed strongly typed data models to represent the scrapped data into standardized objects.
  • Developed an asynchronous HTTP client to fetch content HTML content and convert it into Python objects.
  • Developed a test-driven Python library for the community to use in their own projects without having to worry about data extraction.
  • Developed GitHub Actions workflows to run unit tests, static code analysis, documentation sites deployment, Docker image building and deployment.

October 2017 — Present

Open source Python script that fetches TibiaWiki via its MediaWiki API. Article information is parsed and stored in a SQLite database.

August 2020 — Present

Open source Kotlin JVM library to parse Tibia.com content, including a Ktor asynchronous client.

August 2016 — April 2019

Android application and web service featuring a two-sided network for odd jobs.

  • Developed native Android application with geolocation services to find users needing services in a close area.
  • Integrated Firebase Messaging Service to notify users of job offers and for them to trackt their progress.
  • Implemented authentication service using Firebase to allow users to sign-in through Google.
  • Designed SQL database to store user and job data.

March 2017 — November 2017

Open source Android Things library for the RFID module RC522. Handles communication between the module and compatible RFID tags, with support for operations like sector permissions.

Education

Mechatronics Engineering (Ingeniería Mecatrónica)
Bachelor's Degree
August 2009 — April 2014

Specialization in Mechatronics
High School Diploma
August 2006 — June 2009