Kiran Devireddy

About Kiran Devireddy

I’m a software engineer and an enthusiast with 4+ years of experience designing…

Experience

1. Data Engineer

   Bloom

   Jul 2024 — Present · Bloomington, IN, US

   At Bloom, I work as a hybrid Data Engineer and Database Developer, leading projects that automate the ingestion, transformation, and reporting of sensitive healthcare data. I\'ve built scalable ETL pipelines using SSIS, AWS Glue, and Redshift to streamline data delivery and improve reporting accuracy for internal and client-facing teams.Some of my key projects include:Designing a secure AWS Lambda framework to validate incoming client files from S3 using rules stored in PostgreSQL, improving data quality and reducing manual errors.Building a Redshift-based data warehouse architecture from scratch, integrating multiple data sources via configuration-driven Glue jobs.Automating ETL workflows that extract from RDS and MS SQL Server, apply validation rules in Python, and deliver reports via SFTP and email notifications using SES.Collaborating with analysts, BI teams, and compliance stakeholders during peak Annual Enrollment Periods (AEP) to ensure high-volume data pipelines run smoothly and meet SLAs.Maintaining over 150 SSRS reports and 20+ SSIS pipelines used to support enrollment, billing, and client metrics.This role has strengthened my skills in SQL optimization, data governance, AWS architecture, and end-to-end pipeline automation.

Education

• Indiana University Bloomington

  Master of Science - MS, Data Science

• KL University

  Bachelor of Technology - BTech, Electronics and Communications Engineering