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.
Work Experience 3.9+ years
CRM Customer Analytics Specialist
Skills
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
Skills
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
Skills
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
Skills
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
Skills
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
March 2025Features & 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
February 2025Features & Technologies
- • PydanticAI
- • FastAPI
- • React/Vite
- • LLM-powered insights and automatic summary features for note management
H&M Central America and the Caribbean | Store Reception
January 2025Features & 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
H&M Central America and the Caribbean | Store items
August 2024Features & 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
Eprezto Costa Rica
February 2023Features & Technologies
- • Nx Monorepo
- • Next.js
- • AWS Lambda
- • Digital platform for vehicle insurance
Eprezto Guatemala
December 2022Features & Technologies
- • Nx Monorepo
- • Next.js
- • AWS Lambda
- • Digital platform for vehicle insurance
Eprezto | Vehicle depreciation calculation
May 2022Features & Technologies
- • React
- • Elasticsearch as Data Warehouse
- • AWS Lambda
Eprezto Bluebook | Vehicle price per year
May 2022Features & Technologies
- • React
- • Elasticsearch as Data Warehouse
- • AWS Lambda
SIGNSPA | Translating Panamanian sign language with artificial intelligence
December 2021Features & Technologies
- • TensorFlow.js
- • React
- • TypeScript
Eprezto Blog
October 2021Features & 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
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.
Certificates
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