Data Migration & ETL Consultant

Federico Puma

Ph.D., Biomedical Engineering  ·  15+ Years in Mission-Critical Data

I help healthcare organizations, government agencies, insurance platforms, and regulated enterprises move their data — accurately, completely, and without disruption. From legacy system extraction to go-live validation, I own the full migration lifecycle.

100+
Zero-Data-Loss Migrations
Across 10+ platform types
67×
Pipeline Throughput Gain
67 → 4,400+ records/second
300M+
Records Migrated
Healthcare & institutional data
15+
Years of Experience
Healthcare · Gov · Insurance · HE
Serving: Healthcare / HIPAA Federal & State Government Insurance Platforms Higher Education / FERPA Clinical Research Organ Transplant Data

Complex data.
Clean migrations.
No surprises.

I'm a senior data migration engineer and ETL architect with a Ph.D. in Biomedical Engineering and deep roots in regulated industries where data quality is a matter of compliance — and sometimes patient safety. For over 15 years, I've been the person organizations turn to when a migration can't fail.

My work spans the full lifecycle: understanding your legacy system's quirks, building accurate source-to-target maps, writing the ETL that moves the data without losing a record, and standing beside you through cutover. I communicate in plain language with stakeholders and in precise technical terms with your engineering team.

I've worked as an embedded engineer, a Subject Matter Expert, and an independent technical lead. As a consultant, I bring that same standard — without the overhead of a large firm.

  • Promoted to Subject Matter Expert for ETL Engineering at a national SaaS company
  • Presented data architecture at the Healthcare Data and Analytics Association (HDAA) national conference
  • Published researcher in peer-reviewed clinical and biomedical journals
  • Bilingual consultant: fluent in English and Spanish
  • AI-augmented delivery: Claude Code, Gemini CLI, Amazon Q integrated into ETL workflows
🇺🇸 🇪🇸

Fully bilingual consultant — available to serve English- and Spanish-speaking clients and stakeholders.

What I can do for your organization

🔄

Data Migration & Conversion

End-to-end migration from legacy systems to modern platforms. I handle discovery, schema analysis, source-to-target mapping, ETL development, validation, cutover planning, and go-live support — with zero data loss as the baseline expectation.

SSIS Talend ADF SQL Server
🏗️

ETL Pipeline Architecture

Design and build high-volume ETL/ELT pipelines that are reliable, auditable, and maintainable. I specialize in performance tuning, batch optimization, and replacing brittle legacy pipelines with robust, scalable alternatives.

CloverDX Python C# Azure
🏥

Healthcare Data Systems

HIPAA-compliant data architectures for health systems, payers, and research organizations. Deep experience with clinical data (HL7, ICD-10, CPT), organ transplant registries, and integrated health data repositories.

HIPAA HL7 ICD-10 PHI Governance
☁️

Cloud Data Modernization

Migrate legacy on-premises pipelines to Azure Data Factory, Snowflake, or Databricks. Assessment, roadmap, phased migration, and validation — without disrupting your production data flows.

Azure SQL Snowflake Databricks AWS Glue

Data Quality & Compliance

Data profiling, cleansing, validation framework design, and root cause analysis for quality failures. Audit-ready documentation, access controls, and in-database governance for HIPAA, FERPA, and PHI environments.

HIPAA FERPA PII / PHI Audit Trails
🎓

Technical Advisory & Mentorship

Fractional technical leadership for data engineering teams. ETL standards, code review, pipeline best practices, and hands-on mentorship for junior engineers — drawing on 15+ years of production migration experience.

SME Code Review Standards Team Training

Regulated industries are where I work best

My background is rooted in environments where a migration error has real consequences — for patients, students, policyholders, and research outcomes. That discipline shapes every project I take on.

🏥
Healthcare & Health Systems HIPAA-compliant pipelines, EHR integrations, health data repositories, organ transplant data (UNOS), clinical trials systems
🏛️
Federal & State Government Health program data, public sector migrations, compliance-first architectures suitable for CMS, VA, HHS agency workflows
📋
Insurance Platforms 10+ platform migrations: AMS360, EZLynx, HawkSoft, QQ Catalyst, Agency Matrix, Eclipse, and others
🎓
Higher Education FERPA-compliant data warehouses, 50+ institutional data ingestion, student data governance
🧬
Clinical Research & Life Sciences Clinical trial data systems (ONCORE), HL7 v2.3 streaming, ICD-9/10 migration, biomedical research databases

Tools I work with every day

ETL / Pipeline Tools
SSIS Azure Data Factory Talend CloverDX AWS Glue
Databases & Platforms
SQL Server MySQL / MariaDB Oracle PostgreSQL Azure SQL Snowflake Databricks
Languages & Scripting
T-SQL Python C# Java Bash PowerShell SAS
Cloud & DevOps
Azure Blob Storage AWS S3 GitHub Azure DevOps Jira
AI-Augmented Development
Claude Code Gemini CLI Amazon Q
Compliance & Standards
HIPAA FERPA PHI / PII Governance ICD-10 HL7 v2.3 CPT / HCPCS

Measured in migrations, not promises

Every number below represents a real project delivered — data moved, validated, and signed off by a client who could trust the results.

100+
Zero-Data-Loss
Migrations Completed
67×
Pipeline Throughput
Improvement Achieved
300M+
Health Records
Migrated & Governed
50+
Institutions Ingested
Into Single Data Store

Ready to talk through your migration challenge?

Get in Touch →

Let's talk about
your data.

Whether you have an upcoming migration, a broken pipeline, or just want to understand your options — I'm happy to have a no-pressure conversation.

📞
📍
Location Richmond, VA — Available for fully remote engagements

Send a message

I typically respond within one business day.