Data Analytics · Business Intelligence · Data Engineering

Based in Panama City, Panama.

I have a Systems and Computer Engineering background with a focus on building end-to-end data solutions: from ingestion and transformation to data modeling, analytics, automated validation, and business intelligence.

My projects combine Python, SQL, PostgreSQL, Power BI, and cloud technologies to turn raw data into reliable analytical models and actionable insights.

🌎 Español: README.es.md

Data & Analytics
Python · SQL · PostgreSQL · Power BI · DAX · Power Query · Excel · pandas

Data Engineering
ETL/ELT · Data Pipelines · Data Quality · Dimensional Modeling · Star Schemas · Analytical Marts · PyArrow · SQLAlchemy

Cloud
AWS S3 · AWS Lambda · Amazon Athena · IAM · CloudWatch

Development & Testing
Docker · Docker Compose · Git · GitHub · GitHub Actions · pytest · Ruff

End-to-end data engineering and analytics project built on NYC Yellow Taxi trip data, covering the complete path from raw Parquet ingestion to an analytical PostgreSQL model and Power BI reporting layer.

• Processed and modeled 3.4M+ taxi trip records using Python and PostgreSQL.
• Built a reproducible ingestion pipeline with audit records, idempotent file processing, validation, and data-quality controls.
• Designed raw, staging, analytics, marts, and dimensional layers, including a trip-level star schema.
• Developed daily and hourly analytical marts with rankings, rolling averages, cumulative metrics, and period comparisons.
• Optimized analytical query paths with indexes and fact-based mart definitions.
• Added 33 unit tests and 9 PostgreSQL integration tests.
• Implemented automated code-quality and database validation with GitHub Actions CI.
• Built a three-page Power BI dashboard for executive metrics, demand patterns, revenue, and data-quality analysis.

Stack: Python · PostgreSQL · SQL · Docker · pandas · PyArrow · SQLAlchemy · pytest · GitHub Actions · Power BI

View repository →

Serverless security analytics pipeline built on AWS to ingest, normalize, analyze, and visualize 450K synthetic Firewall, VPN, and VPC Flow records.

• Event-driven AWS Lambda parser triggered by S3 uploads.
• Per-source schema validation, vocabulary normalization, metadata enrichment, and data-quality flags.
• Serverless SQL analytics with Amazon Athena across nine analytical queries.
• Analysis of blocked traffic, authentication failures, network behavior, severity patterns, and threat indicators.
• Three-page Power BI dashboard covering executive, network, threat, and VPN analysis.
• Collaborative Git workflow using branches and pull requests.

Stack: Python · AWS S3 · Lambda · Athena · IAM · CloudWatch · SQL · Power BI

View repository →

Business intelligence project focused on transforming transactional retail data into a structured analytical model and interactive Power BI report.

• Cleaned and transformed raw transactional data using Power Query.
• Identified and classified cancellations, returns, missing customer identifiers, and non-product records.
• Built a relational model with transactional and calendar tables.
• Created DAX measures for net sales, orders, unique customers, average order value, return value, and return rate.
• Developed a two-page Power BI dashboard covering sales performance, products, customers, and returns.

Stack: Power BI · Power Query · DAX · Excel · Data Modeling

View repository →

Universidad Tecnológica de Panamá

Coursework completed · Expected graduation: 2026

• AWS Academy Graduate – Data Engineering
• AWS Academy Graduate – Cloud Architecting
• AWS Academy Graduate – Cloud Foundations
• PCAP: Programming Essentials in Python — Cisco Networking Academy / OpenEDG Python Institute
• Stanford University – Code in Place 2026
• Power BI & DAX
• Database & SQL Fundamentals
• Python for Data Science
• AI Engineering Fundamentals with Python
• OpenAI API & LangChain

• Spanish: Native
• English: C2 Proficient

LinkedIn: linkedin.com/in/angel-w-miller
GitHub: github.com/angel-wm
Email: awmiller.mazzitelli@outlook.com