H Venkata Sai Dumpala

Data Engineer Full Stack Developer @Colorado Mesa University

CA, US

Built scalable ETL pipelines using Apache Spark on AWS Glue to process and transform large volumes of healthcare claims and member data from diverse RDBMS and semi-structured sources into Amazon S3 and Snowflake.• Performed advanced data cleansing and transformation with PySpark, improving the accuracy of patient demographics, provider directories, and claims records for downstream analytics.• Integrated Snowflake with AWS S3 using Snowpipe for real-time data ingestion, enabling up-to-date access to policy and enrollment records across actuarial and compliance teams.• Developed and orchestrated robust ETL workflows using AWS Glue Workflows, Crawlers, and Lambda, ensuring timely ingestion of high-volume datasets across environments.• Created Tableau dashboards connected to Snowflake and Amazon Redshift, delivering real-time insights on claim approvals, cost trends, and care quality for over 10 business units.• Automated error handling and audit logging using Step Functions and CloudWatch, reducing manual monitoring effort and improving pipeline observability.• Designed HIPAA-compliant data architectures with AWS IAM, KMS encryption, and S3 access controls, ensuring secure storage and controlled access to PII and PHI data.• Tuned Spark jobs to reduce ETL runtime by 30%, supporting faster dashboard refresh cycles and more responsive data access for business stakeholders.