At Florida Department of Children and Families, I design, develop, and support pipelines feeding the statewide Enterprise Data Warehouse from 15+ source systems. I use SQL, Python, Azure Synapse Analytics, Azure Data Factory, SSIS, and Alteryx to integrate data from APIs, databases, files, cloud storage, and SFTP.
On the FLWINS project, I integrated a MuleSoft API for inbound data loading, including authentication, payload parsing, error handling, and retry logic. I also re-engineered a vendor-delivered pipeline for a 50M+ record Medical Code Crosswalk load and added checksum and record-count reconciliation.
At Hunter and Hunter Consultants, I built data-integration pipelines for a 12-county affordable housing needs assessment. I used Python and SQL to prepare data from public APIs and other sources, then delivered Power BI and Tableau dashboards for county planners and officials.
At XpressBees Logistics, I built and supported data warehouse pipelines for operational and executive reporting, maintaining 99.9% data reliability. I also developed PySpark jobs on Google Cloud DataProc and built dashboards tracking shipment volumes, delivery performance, and returns.