Lakshmi Guntupalli

Research Data Analyst Ii @California Department of Health Care Access and Information

CA, US

Ensured clean, reliable data by leading validation of 250K+ records from Qualtrics and CRM systems. Used Alteryx to automate checks and cut data errors, improving compliance and reporting. Analyzed healthcare workforce trends using SQL, Alteryx, and Tableau. Built automated ETL/ELT pipelines using AWS Glue, EC2, and Delta Lake to process LRP data, cutting manual work. Integrated Microsoft Dynamics 365 data via Azure Synapse Link and managed storage in MySQL. Delivered dashboards and insights that boosted decision-making and improved reporting accuracy. Partnered with IT and research teams to shape scalable data strategies. Led UAT, A/B testing, QA reviews, and ensured clean, consistent data before every deployment. Migrated a legacy warehouse to AWS, boosting pipeline speed and cutting infrastructure costs. Also built UI features with React and shared insights through Power BI, Tableau dashboards.