Reddylohith Vaka

Experience

1. Data Analyst

   Humana

   Jan 2025 — Present

   Developed and optimized complex SQL queries (nested CTEs, dynamic joins) to extract over 10 million healthcare records, reducing query latency by 20% using indexing and execution plan optimization.• Performed data validation and profiling using Python (pandas, NumPy) and SQL, improving data quality by 25% through automated outlier detection, duplicate resolution, and type casting.• Designed and deployed ETL workflows in Informatica PowerCenter and SSIS to integrate multi-source datasets (Oracle, SQL Server), ensuring end-to-end traceability and alignment with SAP-based data.• Modeled fact-dimension relationships using star schema in Snowflake to support patient behavior analysis and operational efficiency reporting, increasing dashboard responsiveness by 30%.• Automated KPI dashboards in Power BI with DAX-driven drill-downs and interactive slicers to monitor metrics like customer retention, claims turnaround time, and provider network performance.• Migrated legacy Excel-based reporting tools into structured Excel VBA and Power Query frameworks, reducing manual effort by 25% and ensuring version control consistency.• Supported Teradata data warehouse migration for enterprise reporting, reconciling historical and transactional data to ensure OLTP-OLAP consistency across care delivery systems.

Education

• Lamar University

  Master of Science, Management Information Systems, General

• Lamar University

  Master of Business Administration - MBA, Management Information Systems, General

• Guntur Engineering College - India

  Bachelor's Degree, Civil Engineering

• RVR&JC college of engineering

  Bachelor of Engineering - BE, Civil Engineering