Sumana Sree N

Data Analyst @Franciscan Health

US

Collaborated with clinical teams to define KPIs, gather requirements, and align readmission metrics with business goals.• Developed ETL workflows using SSIS and Python, integrating data from EHR systems, admission logs, and external healthcare sources, ensuring smooth data pipelines and automated processes.• Used advanced SQL optimization techniques and indexed views to improve query performance for large-scale EHR datasets in Oracle and MySQL environments.• Cleaned and prepared large datasets using Pandas, NumPy, and handled missing values, outliers, and data standardization to ensure high-quality data for analysis.• Visualized patient risk factors, readmission trends, and key health metrics using Tableau, Power BI, and Matplotlib/Seaborn, providing interactive and easy-to-understand dashboards for stakeholders.• Implemented automated data pipelines with SSIS, Azure Data Factory, Airflow, and Cloud Functions to facilitate daily data refreshes, ensuring up-to-date reporting and analytics.• Created interactive dashboards and reports for stakeholders, documenting ETL pipelines, data lineage, and transformation logic using Confluence and Git for version control and team collaboration.• Collaborated with data engineers and IT teams to design scalable data models supporting healthcare analytics across multiple departments.