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.
Email 
LinkedIn 
GitHub 
Work Experience 5.3+ years
CRM Customer Analytics Specialist
Designed and maintained CRM data pipelines and unified customer tables across stores and countries. Built SQL-based churn, RFM, and CLV models, while leading segmentation and churn prediction projects. Developed Power BI dashboards to deliver 360° customer insights and email marketing performance, enabling targeted campaigns and improved engagement.
pandoragroup.comSkills
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.
- • Customer Data Pipeline: Designed and implemented an ETL process to consolidate CRM transactional data into a single unified customer table. Established a unique customer ID across stores and countries, enabling consistent tracking regardless of registration source.
- • Churn Rate Analysis: Built SQL-based models to calculate monthly and yearly churn rates using buyer frequency. Identified seasonality patterns, retention cohorts, key churn periods, providing insights that helped the company address and reverse negative trends.
- • CRM Reporting: Developed a Power BI dashboard to provide a comprehensive overview of the CRM database. Delivered insights on customers by country, segmentation (Active / Pre-Inactive / Inactive), pricing behavior (Full-Price vs. Promo-based), churn rate, monthly customer acquisition, and other key metrics to enable a 360° view of customer activity.
- • Email Marketing Reporting: Built a Power BI dashboard to track email marketing performance, measuring both sales/revenue KPIs (e.g., total sellout, transactions, average transaction value, unique customers, gross/net return rates) and engagement KPIs (sent, delivered, opened, open rate, click-through rate, click-to-open rate, revenue per email sent/open/click) at the campaign level. Additionally, regularly develop customer segmentations within the CRM to target specific audiences based on buying behavior.
- • Analytic Models: Developed an RFM (Recency, Frequency, Monetary) model in SQL to categorize customers (e.g., VIPs, needs attention, potential) and a CLV (Customer Lifetime Value) model based on activity status (Active / Pre-Inactive / Inactive). Currently leading projects to implement customer segmentation using K-Means clustering and a churn prediction algorithm.
Integrations and Analytics Specialist
Designed and maintained data pipelines and ETL/ELT processes connecting H&M Global API, SAP Business One, WIS Warehouse, and ICG Point of Sale systems. Built REST APIs, web applications, and custom Python/PySide plugins to streamline logistics, merchandise auditing, and operational workflows. Leveraged Azure cloud services and analytics tools to deliver actionable insights, optimize data ingestion, and support regional decision-making.
holamoda.netSkills
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.
- • 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
Led Eprezto’s international expansion, building scalable API-based vehicle insurance systems across Costa Rica, Guatemala, and the Dominican Republic. Managed payment gateway integrations, electronic document delivery with major insurers, and a compact development team. Established a monorepo with CI/CD using Nx, Next.js, and Serverless Framework, reducing code duplication through shared React/Tailwind components and reusable TypeScript interfaces.
eprezto.comSkills
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
Designed and implemented an intelligent IoT-based irrigation control system using Arduino, NRF24L01+ modules, and sensors for real-time soil moisture monitoring. Integrated InfluxDB, Telegraf, and Grafana for data logging and visualization, and leveraged AWS IoT as an MQTT cloud broker. Contributed to sustainable agriculture by enabling efficient, data-driven irrigation management.
esalab.esSkills
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
Improved website performance and SEO by migrating the company blog from WordPress to Next.js with TailwindCSS. Enhanced the Bluebook tool for vehicle pricing and depreciation using Elasticsearch and AWS Lambda. Implemented PayCash API for cash payments, managing end-to-end integration from sandbox testing to live deployment and payment tracking.
eprezto.comSkills
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
- • Docker
- • Vite
- • LLM-powered insights and automatic summary features for note management
H&M Central America and the Caribbean | Store Reception
January 2025Features & Technologies
- • React
- • FastAPI
- • Deployment made in the internal Azure network of the company
- • Internal project for all H&M stores in the region
- • Store reception middleware to audit all the merchandise in the boxes before sending the info to the ERP
- • shadcn/ui
- • Docker
- • Vite
H&M Central America and the Caribbean | Store items
August 2024Features & Technologies
- • FastAPI
- • React
- • Docker
- • shadcn/ui
- • Store reception middleware to audit all the merchandise in the boxes before sending the info to the ERP
- • Internal project for all H&M stores in the region
- • Deployment made in the internal Azure network of the company
Eprezto Costa Rica
February 2023Features & Technologies
- • Next.js
- • AWS Lambda
- • Nx Monorepo
- • Digital platform for vehicle insurance
- • Platform integrated with the biggest insurance companies in Costa Rica (Grupo INS, Mapfre, Oceánica de Seguros, Quálitas, Seguros LAFISE)
Eprezto Guatemala
December 2022Features & Technologies
- • Next.js
- • Nx Monorepo
- • AWS Lambda
- • Platform integrated with the biggest insurance companies in Guatemala (Aseguradora General, Aseguradora Guatemalteca, Seguros Universales)
- • Digital platform for vehicle insurance
Eprezto Bluebook | Vehicle price per year
May 2022Features & Technologies
- • React
- • AWS Lambda
- • Elasticsearch
Eprezto | Vehicle depreciation calculation
May 2022Features & Technologies
- • React
- • AWS Lambda
- • Elasticsearch
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
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
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