Alois Carrera

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 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.

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.

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.

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.