Hi, Samuel here

SOFTWARE

ENGINEER |

Software engineer passionate about building solutions.
I work with APIs, data and web technologies to design, optimize and scale systems.

Portrait of Samuel Castro

02 //
Projects

Eco

Personal finance app: accounts, cards, transactions, debts, recurring plans and installments, with analytics exportable to Excel and PDF.

  • React
  • •
  • FastAPI
  • •
  • PostgreSQL
  • •
  • Supabase
Eco screenshot

COVID-19 Dashboard

Interactive dashboard on the spread of COVID-19: global totals, per-country charts and a vaccination map, built on Our World in Data.

  • Python
  • •
  • Dash
  • •
  • Plotly
  • •
  • Pandas
COVID-19 Dashboard screenshot

Alas Catalog

Fine jewelry catalog with category filters, fuzzy search and WhatsApp contact. The inventory updates straight from an Excel sheet.

  • Astro
  • •
  • Tailwind CSS
  • •
  • Python
Alas Catalog screenshot

Sismos de Panamá

Live dashboard of an earthquake sequence in Panama: interactive map, magnitude chart and event list, fed by the USGS API.

  • JavaScript
  • •
  • D3.js
  • •
  • USGS API
Sismos de Panamá screenshot

Focus Timer

Minimal dark countdown timer with an animated background.

  • React
  • •
  • TypeScript
  • •
  • Vite
Focus Timer screenshot

Particle Portrait

Interactive portrait made of thousands of lines that form from text and react to the mouse with a glitch effect. Adjustable in real time.

  • JavaScript
  • •
  • Canvas
  • •
  • CSS
Particle Portrait screenshot

+

More Projects

Check out my lab experiments

03 //
About Me

I'm Samuel, a Software Engineer from Panama focused on building systems that make an impact. I graduated from Universidad Tecnológica de Panamá and currently working in Business Intelligence at Banco Delta, using Microsoft Fabric, Azure and SQL to deliver data and KPIs that drive decision-making.


I enjoy building APIs and web applications, designing systems and integrating services to create scalable and efficient solutions, working with technologies like Python, JavaScript and React. I like solving complex problems and turning them into structured, reliable solutions.


I'm a self-learner at heart, always exploring new technologies and improving my skills across backend, modern web development, and the recent game-changer, AI. Outside of work, I’m into setups, gaming and the gym. I also enjoy exploring nature — especially rivers, natural pools and hidden spots across Panama.


Let’s build something great.

04 //
Experience Log

[2026.09 - PRESENT]

STATUS: [EXEC_OK]

ROLE: Data Engineer

@Banco Delta

●  TRACING ACTIVE

> TAIL -F /VAR/LOG/BANCO_DELTA.LOG

  • »  Designed and built a Microsoft Fabric lakehouse with a star schema that centralizes data from the bank's source systems (OnBase, Bantotal and Payme), including pipelines, Dataflows Gen2 and notebooks
  • »  Replaced QlikView and the Azure warehouse with the lakehouse and Power BI, rebuilding most core dashboards with the same analytics and more information, cutting costs and improving refresh times
  • »  Built the Payme integration and an automated Fabric notebook that computes and stores the daily delinquency behavior score of the active loan portfolio; now building a probability-of-default model on top of it
  • »  Built a Balanced Scorecard dashboard to track execution, goals and commissions for sales and collections staff

[2026.07 - PRESENT]

STATUS: [EXEC_OK]

ROLE: SQL Instructor (part-time)

@iacademy

●  TRACING ACTIVE

> TAIL -F /VAR/LOG/IACADEMY.LOG

  • »  Teach the basic SQL course through recorded and live synchronous classes

[2024.09 - 2026.08]

STATUS: [ARCHIVED]

ROLE: Programmer Analyst / Data Analyst

@Banco Delta

> TAIL -F /VAR/LOG/BANCO_DELTA.LOG

  • »  Implemented a FastAPI service and BPM workflow automation with generative AI (GPT), cutting workflow instance lifetime by 50% and meeting regulatory deadlines
  • »  Built advanced SQL queries and reporting in Power BI, Reporting Services and QlikView; optimized complex queries and data flows
  • »  Created and maintained ETL in Fabric Pipelines, Integration Services and Data Factory, with monitoring dashboards that ensure data availability

[2025]

STATUS: [ARCHIVED]

ROLE: Full Stack Developer

@UTP AWS Academic Project

> TAIL -F /VAR/LOG/UTP_AWS_ACADEMIC_PROJECT.LOG

  • »  Designed and deployed a cloud-native full-stack application on AWS using a serverless architecture
  • »  Built scalable backend services with FastAPI and PostgreSQL, integrated with a modern Next.js frontend
  • »  Architected cloud infrastructure with Amplify, API Gateway, Lambda, and RDS following best practices

[2022 - 2023]

STATUS: [ARCHIVED]

ROLE: Full Stack Developer

@Reto Innova Banesco

> TAIL -F /VAR/LOG/RETO_INNOVA_BANESCO.LOG

  • »  Earned 2nd place (2022) and 1st place (2023) in the hackathon
  • »  Designed and implemented a full-stack architecture with Django REST Framework and React, with RESTful APIs and custom authorization middleware
  • »  Modeled and optimized the MySQL database for complex legal and financial case management
  • »  Automated 80% of manual processes, including Word legal documents and email notifications, with multi-role workflows and custom dashboards