Ricardo Roa

Modified and optimized AWS Lambda and Glue ETL pipelines to ingest multiple data sources into Snowflake, implemented CI/CD with Terraform and GitHub to deploy infrastructure, and built Athena-based data quality checks to ensure dataset integrity.

Advised on Snowflake architecture and best practices, designed standardized data loading patterns and CI/CD deployments using GitHub Actions and Schemachange, and promoted Snowpark and right-sized warehouses to improve pipeline maintainability and performance.

Refactored AWS Lambda codebase, implemented Pytest coverage and GitLab CI/CD, containerized Lambdas with Docker, and built AWS Glue jobs and Datadog dashboards to improve observability and reduce storage costs via S3 profiling.

Deployed Lambda-based services with Terraform and Docker, designed Snowflake data models and DBT transformations, automated Snowflake object deployments with Schemachange, and integrated Slack–Snowflake–AWS ingestion workflows with CI/CD automation.

Built ML-enabled fuzzy-matching and ETL pipelines using RecordLinkage, Rapidfuzz and AWS Glue to consolidate entity data into Redshift, deployed parallel Lambdas for summarization, and materialized Glue/Athena tables for downstream analytics.

Built marketing ETL pipelines using Airflow and Python, migrated data into BigQuery via Cloud Functions, and automated S3→GCS transfers to enable scalable reporting and unified campaign analytics.

Led S3→GCS and BigQuery migration workflows with Airflow, implemented incremental loading, materialized views and partitioning to improve query performance, and developed Glue jobs to unify historical Parquet datasets into Athena tables.

Designed analytical models and Power BI dashboards for energy consumption and subsidy analysis, implemented DAX and SSAS tabular models, and applied Python analytics for outlier detection in KWh usage.

Implemented ETL pipelines with PySpark and Cloudera Impala for mortgage calculations, designed Parquet schemas, migrated data to Azure SQL, and built Power BI dashboards for occupational health analytics.

Developed internal Java applications and T-SQL stored procedures for operational modules, implemented SLA policies and backup strategies, and improved network coverage with Ubiquiti deployments.

Developed Power BI dashboards and ETL processes with SQL and DAX to analyze COVID-19 risk and medical billing for incarcerated populations, and optimized data models for interactive visualizations.

Built institutional website, extended wireless LAN coverage, implemented SQL automation for admission validation, and managed backups to ensure data integrity and continuity.

Developed SQL reporting scripts for regulatory compliance and quality indicators, and created a Java claims application to improve tracking and resolution processes.

Designed and implemented IT maintenance plans and LAN connectivity projects for educational centers, and delivered practical SQL and Microsoft Office training to improve students' technical proficiency.

Improved hospital LAN topology and developed T-SQL queries for ERP financial reporting, optimizing system reliability and reporting accuracy.

Completed studies in Systems Engineering at Fundación Universitaria San Martín, focusing on software development, databases, and IT systems.