Alois Carrera

Software Engineer | Data Specialist | Cloud Enthusiast

Panama City, Panama

A technology professional adept at architecting, developing, and deploying comprehensive solutions that bridge business needs with technical execution. I leverage expertise across full-stack development (JavaScript/TypeScript, Python), data engineering (ETL/ELT, analysis, visualization), and cloud infrastructure (AWS, Azure) to integrate complex systems, streamline operations, and unlock actionable insights from data. Proven ability to deliver end-to-end projects, from designing scalable cloud architectures and building robust APIs to creating data pipelines and user-facing applications that drive efficiency and inform strategic decisions.

Alois Carrera

Work Experience 3.9+ years

CRM Customer Analytics Specialist

Pandora Panama City, Panama
April 2025 - Present
pandoragroup.com

Skills

DuckDB SQL Polars Python PowerBI

Responsibilities & Achievements

  • As a CRM Customer Analytics Specialist, I leverage DuckDB, Polars, PowerBI and other tools to analyze and extract insightful information about customers in Pandora's LATAM Cluster.

Integrations and Analytics Specialist

Hola Moda Panama City, Panama
May 2024 - April 2025
holamoda.net

Skills

API Integration Data Analysis SAP Business One Python ELT ETL Power BI Business Intelligence ICG Point of Sale Microsoft SQL Server Azure React FastAPI

Responsibilities & Achievements

  • Automated Logistics Pipeline: Built a data pipeline processing H&M merchandise shipments using Azure Functions and Service Bus, handling critical logistics events (Purchase Orders, Commercial Invoices). Integrated with H&M Global API to deliver actionable insights to regional teams.
  • ERP Integration: Connected H&M Global API with SAP Business One via SAP Service Layer API using Python and Windmill, streamlining incoming container information availability and reducing processing time.
  • API Architecture: Designed and deployed multiple REST APIs (Python/FastAPI) connecting internal systems with external partners. Leveraged multiple Azure cloud services: VMs, Functions, Container Apps, Blob Storage, Logic Apps, CosmosDB (NoSQL).
  • Digital Tools Development: Created React/FastAPI web applications deployed on Azure VMs using Docker, giving store employees item data access across the region.
  • Analyzed sales data from ICG Point of Sale system and developed custom plugins for business-specific requirements.
  • Audit System: Built a middleware solution using React, shadcn/ui, FastAPI and Windmill (Async Processing) enabling store teams to audit merchandise after SML RFID scanning, improving inventory accuracy.
  • Custom Solutions: Developed Python/PySide GUI plugins for ICG PoS addressing specific business requirements.
  • Warehouse Operations: Integrated SAP with WIS warehouse system enabling merchandise reception of incoming merchandise containers.
  • Data Pipeline Optimization: Implemented ELT/ETL processes using Windmill and dltHub, enhancing data ingestion and processing capabilities enabling advanced analytics through SQL Server and PowerBI dashboards.

Solutions Architect

Eprezto Panama City, Panama
December 2022 - April 2024
eprezto.com

Skills

Nx Monorepo Next.js Serverless Framework AWS Lambda Tailwind CSS MongoDB Cybersource by Visa Elasticsearch

Responsibilities & Achievements

  • Led Eprezto's international expansion project, focusing on API-based vehicle insurance systems for 3 countries (Costa Rica, Guatemala, Dominican Republic), payment gateway integration (Visa Cybersource), as well as managing a compact team. A scalable system was established through the use of a monorepo, with a CI/CD (Continuous Integration/Delivery) process using modern technologies such as Nx, Next.js and Serverless Framework.
  • Vehicle insurance quotation system based on APIs
  • Management of electronic document delivery processes with the main insurance companies in Guatemala (Aseguradora General, Aseguradora Guatemalteca, Seguros Universales) and Costa Rica (Grupo INS, Mapfre, Oceánica de Seguros, Quálitas, Seguros LAFISE).
  • Development of a monorepo using Nx with a CI/CD pipeline, reducing code duplication between projects using a shared design system with components developed in React and TailwindCSS, reusing TypeScript interfaces and different configurations, including linter/formatter.

Research Intern

ESALab Expert Systems And Applications Salamanca, Spain
September 2021 - December 2021
esalab.es

Skills

MySensors IoT NRF24L01+PA+LNA Arduino Capacitive soil moisture sensors InfluxDB Telegraf MQTT Grafana AWS IoT Systems Design Radio Frequency (RF)

Responsibilities & Achievements

  • Developed an intelligent irrigation control system using IoT technologies, contributing to sustainable agriculture.
  • Independently designed and executed an intelligent irrigation control system using IoT technologies, NRF24L01+ modules, Arduino, and sensors, focusing on real-time data collection and soil moisture analysis.
  • Implemented InfluxDB for data logging, Telegraf for metric transportation from MQTT, and integrated Grafana for visualizing soil moisture data, ensuring effective data management and decision-making.
  • Leveraged AWS IoT as an MQTT cloud broker, showcasing skills in Systems Design, RF communication, and IoT, contributing to sustainable agriculture and efficient irrigation practices.

Software Engineer

Eprezto Panama City, Panama
August 2021 - December 2022
eprezto.com

Skills

Next.js SEO Headless WordPress GraphQL Tailwind CSS Google PageSpeed Google Lighthouse Elasticsearch AWS Lambda MongoDB

Responsibilities & Achievements

  • Focused on improving blog performance and main website payment integrations, significantly enhancing SEO and user experience.
  • Enhanced Eprezto Blog's performance and SEO by migrating from WordPress to Next.js with TailwindCSS.
  • Upgraded Eprezto Bluebook for vehicle price checking and depreciation calculations using Elasticsearch and AWS Lambda.
  • Implemented PayCash API for cash payments, managing from sandbox testing to live deployment and payment tracking.

Projects

CRM Data Analysis

CRM Data Analysis

March 2025

Features & Technologies

  • Developed an interactive data analysis application using Marimo to explore CRM dataset
  • Integrated DuckDB for high-performance SQL querying and processing directly on CSV data files
  • Created insightful and dynamic data visualizations with Altair to uncover trends in sales and customer data
  • Applied K-means clustering (Scikit-learn) for customer segmentation based on CRM attributes
Notes AI Agent

Notes AI Agent

February 2025

Features & Technologies

  • PydanticAI
  • FastAPI
  • React/Vite
  • LLM-powered insights and automatic summary features for note management
H&M Central America and the Caribbean | Store Reception

H&M Central America and the Caribbean | Store Reception

January 2025

Features & Technologies

  • Store reception middleware to audit all the merchandise in the boxes before sending the info to the ERP
  • React
  • shadcn/ui
  • Windmill (Job Orchestrator)
  • FastAPI
  • Docker
  • Deployment made in the internal Azure network of the company
No live demo available
H&M Central America and the Caribbean | Store items

H&M Central America and the Caribbean | Store items

August 2024

Features & Technologies

  • Internal project for all H&M stores in the region
  • Search relevant item information based on store
  • React
  • shadcn/ui
  • Docker
  • Deployment made in the private Azure network of the company
  • FastAPI
No live demo available
Eprezto Costa Rica

Eprezto Costa Rica

February 2023

Features & Technologies

  • Nx Monorepo
  • Next.js
  • AWS Lambda
  • Digital platform for vehicle insurance
Eprezto Guatemala

Eprezto Guatemala

December 2022

Features & Technologies

  • Nx Monorepo
  • Next.js
  • AWS Lambda
  • Digital platform for vehicle insurance
Eprezto | Vehicle depreciation calculation

Eprezto | Vehicle depreciation calculation

May 2022

Features & Technologies

  • React
  • Elasticsearch as Data Warehouse
  • AWS Lambda
Eprezto Bluebook | Vehicle price per year

Eprezto Bluebook | Vehicle price per year

May 2022

Features & Technologies

  • React
  • Elasticsearch as Data Warehouse
  • AWS Lambda
SIGNSPA | Translating Panamanian sign language with artificial intelligence

SIGNSPA | Translating Panamanian sign language with artificial intelligence

December 2021

Features & Technologies

  • TensorFlow.js
  • React
  • TypeScript
Eprezto Blog

Eprezto Blog

October 2021

Features & Technologies

  • Next.js
  • WordPress Headless GraphQL API
  • Complete re-write from WordPress to Next.js to improve SEO
  • Styled using Tailwind CSS

Skills

Cloud

  • Azure Container Apps
  • AWS Lambda
  • Azure Functions
  • Azure Service Bus
  • Docker
  • CI/CD Pipelines
  • Azure Blob Storage
  • AWS S3

Programming Languages

  • TypeScript
  • JavaScript
  • Python

Frameworks

  • Next.js
  • Astro
  • Nx
  • NestJS
  • FastAPI

Databases

  • MongoDB
  • PostgreSQL
  • Elasticsearch
  • Microsoft SQL Server

Education & Certifications

Education

Bachelor on Computer and Systems Engineering

Universidad Tecnológica de Panamá

Santiago, Veraguas, Panama

2017 - 2021
Grade: 2.1/3.0

Development of original and tailored computing solutions, strong mathematical and computational foundation.

Awards

HACK4EDU 2021 - Senior Category

ProFuturo Foundation

Secured second place in the senior category of #HACK4EDU hackathon with a project named SINGSPA, a web application that makes easy for people to understand sign language using machine learning.

November 2021 View Award

Certificates

EF SET Certificate 70/100, C1 Advanced

EF Standard English Test

October 2022 View Certificate

Amazon Web Services Advanced Course

Universidad Pontificia de Salamanca

Let's Collaborate

I'm looking to collaborate on exciting projects!

Whether you have an idea, need help with your project, or want to start something new together, I'm interested in collaborating in these areas:

Web Development

Full-stack applications with modern frameworks and architectures

  • SPA/SSR web applications
  • Static sites
  • Content management systems

AI & LLMs

Building intelligent applications with large language models

  • RAG systems
  • LLM fine-tuning
  • AI-powered tools

Data Engineering

Data pipelines, warehousing, and analytics solutions

  • ETL/ELT workflows
  • Data visualization
  • Streaming data systems

Systems & Backend

Robust backend services and distributed systems

  • Microservices
  • APIs (REST, GraphQL)
  • Kubernetes

Mobile Apps

Cross-platform mobile application development

  • React Native
  • Flutter

Open Source

Contributing to or starting open source projects

  • Library maintenance
  • Documentation
  • Feature development

Get in touch to discuss collaboration: