UnitedHealthcare / Sole architect
Recurring
Automated reporting and claims feeds.
I designed and built RDF, a Python and Prefect 3 platform on Kubernetes that replaces legacy reporting workflows and automates claims feeds.
- Python
- Prefect 3
- Kubernetes
- SQL Server
- Oracle
- MongoDB
- Databricks
- Db2/Cosmos
- S3
The problem
Reporting depended on a large legacy SSIS package and a SAS reporting estate. RDF replaces these workflows and consolidates more than 380 reports.
- SSIS sequence containers
- 60+
- SSIS SQL tasks
- 300+
- SSIS data flows
- 120+
- SAS reports
- 380+
My contribution
I am the sole architect of RDF. I built the platform with Python and Prefect 3 on Kubernetes, connecting SQL Server, Oracle, MongoDB, Databricks, Db2/Cosmos, and S3.
I built claims feeds end to end for Medicare & Retirement adjudication: automated claim routing, reversal logic, AUS work-item queueing, and downstream persistence.
I also built the DOC360 feed in RDF to retrieve and email documents automatically for Fastbase.
The results
- Annual recurring savings
- 6 figures
From RDF’s reporting modernization and workflow automation.
- Projected claim-payout impact
- $3M+
From claims feeds supporting Medicare & Retirement adjudication.