Data Analyst Healthcare

DEEPTHI SRI KOMMAGANI.

Healthcare Data Analyst

Pittsburgh, PA ********************@*****.***

412-***-**** LinkedIn

SUMMARY

Experienced in the healthcare industry with 5+ years with a background as a Healthcare Data Analytics, contributing to critical projects such as patient outcome assessments, data standardization, and performance optimization. Expertise includes data coding, analytics, and project management, with a strong focus on leveraging tools like Python, SQL, Power BI, Tableau, and R for data analysis and visualization. Proficient in data modeling, ETL processes, statistical analysis, and predictive analytics, with hands-on experience using cloud platforms such as AWS to build scalable data solutions. Proficient in Microsoft Excel (advanced data analysis, pivot tables, macros), Word (technical documentation, report creation), and PowerPoint (data visualization, presentations, stakeholder engagement). Skilled in creating interactive dashboards, streamlining workflows, and implementing machine learning models to enhance data-driven decision-making. Adept at regulatory compliance and healthcare data standards, committed to deploying innovative, data-driven solutions to address complex challenges and drive measurable improvements in the healthcare sector. SKILLS

Programming Languages Python, SQL, T- SQL, C#

Data Analysis Data Cleaning, Data Wrangling, Data Profiling, Predictive Modeling, Patient Outcome Analysis Healthcare

Expertise

HL7 Standards, Data Standardization, Regulatory Compliance (HIPAA), EHR/EMR Systems Integration

Data Visualization Tableau, Power BI, Microsoft Excel, Matplotlib, Seaborn, Looker, Microsoft Word, Powerpoint Database Management Microsoft SQL, PostgreSQL, Oracle, No SQL, MongoDB, Snowflake, BigQuery ETL and Data Pipelines ETL Development, Data Transformation, Apache Airflow, Informatica PowerCenter, SSIS, Talend Healthcare Metrics/KPIs Patient Satisfaction Analysis, Population Health Analysis, Hospital Readmission Rate Analysis Cloud Platforms AWS (Redshift, S3, Athena, Lambda), GCP (BigQuery, Cloud Storage, Cloud Functions) Big Data Tools Hadoop, Spark, Hive, Kafka, MapReduce Machine Learning Predictive Analytics, SVM and Regression Models, Clustering, Classification, Feature Engineering Tools & Techniques NumPy, Pandas, Scikit-learn, TensorFlow, PyTorch, Keras Business Intelligence KPI Dashboards, Forecasting, Data Standardization, Root Cause Analysis Healthcare Reporting /

Compliance Analysis

Electronic Health Record (EHR), Joint Commission Standards, compliance metrics, regulatory audits, quality assurance, NQF

Project Management Agile, Scrum, Jira, Trello, Confluence Soft Skills Communication, Stakeholder Collaboration, Problem-Solving, Presentation Skills, Team Leadership PROFESSIONAL EXPERIENCE

Healthcare Data Analyst August 2024 - Present

Allegheny General Hospital, PA, USA

• Ensured HIPAA compliance by implementing robust data encryption, access controls, and conducting audits on EHR systems like EPIC, maintaining sensitive data integrity and security.

• Contributed to a Joint Commission project aimed at ensuring hospital compliance with healthcare standards; Designed interactive dashboards in Power BI to track patient admission and discharge metrics.

• Developed SQL-based stored procedures in Snowflake to automate data transformations and aggregations, enabling efficient analytics workflows.

• Supported in ETL pipelines for data ingestion from multiple sources into Hadoop ecosystems; Used Spark for distributed data processing and analytics on large-scale datasets. Utilized Python to clean, preprocess, and analyze large datasets, ensuring data quality and consistency for further analysis.

• Ensured HIPAA compliance by managing sensitive EHR data (e.g., EPIC), conducting audits on patient records, medication histories, and treatment plans to maintain data integrity.

• Monitored and analyzed KPIs to track business performance and project success, aligning metrics with Joint Commission Standards and identifying trends for continuous improvement.

• Leveraged BigQuery for running SQL queries and developing schemas for healthcare and SaaS data analytics projects. Built an AWS Redshift data warehouse consolidating patient records across.

• Conducted data analysis, developed dashboards, and ensured regulatory compliance, collaborating with cross-functional teams to identify trends, improve accuracy, and meet Joint Commission standards.

• Developed predictive models using machine learning algorithms to forecast patient outcomes and deployed anomaly detection models via AI Studio for healthcare data.

• Created detailed reports to evaluate quality and safety compliance, managed data analytics projects using Jira, and ensured timely task completion.

• Designed data-driven solutions to enhance hospital workflows and patient care quality, performing data wrangling and preprocessing to improve model accuracy and integrating predictive models with hospital management systems for real- time insights.

• Worked on predictive models using AWS SageMaker for forecasting patient inflow and resource needs. Managed structured and NoSQL databases (AWS RDS, DynamoDB), automated workflows using AWS Lambda, and created drill-down Tableau reports for actionable insights.

• Worked on machine learning models with scikit-learn to predict trends and optimize operational efficiency. Utilized Pandas and NumPy for data manipulation and statistical analysis as well as Analyzed clinical data from EPIC EHR systems, generating actionable insights for hospital operations. Automated data migration workflows into centralized data warehouses, ensuring efficiency and accuracy.

• Worked on Tableau with Snowflake and BigQuery for real-time analytics. Automated Tableau dashboards to refresh daily, performed cost optimization for BigQuery, and conducted advanced ETL workflows with Hadoop and Databricks; Developed Power BI dashboards to track KPIs such as HAI rates, driving quality improvements. Collaborated on ETL pipelines to load data, optimizing data pipelines for machine learning models.

• Utilized SQL, Spark, and Hive for advanced data cleansing and query optimization, ensuring seamless integration with cloud-based machine learning workflows. Developed scalable Snowflake data models and implemented clustering for improved performance.

• Designed data pipelines for hybrid applications, integrating SQL and NoSQL systems to manage unstructured data in healthcare; Calculated KPIs like revenue growth, customer retention, and operational efficiency, and conducted feature engineering to enhance ML model performance.

• Collaborated with cross-functional teams using Agile principles via Jira, managing sprint planning and retrospectives to optimize workflows.

• Created technical documentation and data visualizations to support training and adoption of analytical tools. Ensured high-quality data reporting to drive operational efficiency, meeting stakeholders’ requirements for healthcare claims processing.

Data Analyst January 2021 - May 2023

Sri Sai Hospital, Hyderabad, India

• Developed comprehensive reports to track key performance metrics, boosting operational effectiveness; Collaborated with healthcare professionals to implement new data management protocols, reducing errors by 15%.

• Developed process models to map out current and future states of the claims workflow; Conducted data analysis to uncover trends and support decision-making in claims management.

• Leveraged Pandas and NumPy for statistical analysis, uncovering key insights to drive business decisions; used Spark SQL for efficient big data querying and analysis; Conducted strategic analysis to optimize utility and align with the hospital’s vision, utilizing DBMS and Power BI to analyze patient data and suggest optimizations for hospital workflows.

• Assisted in integrating BigQuery with cloud-based tools like AI Studio for predictive analytics; Utilized BigQuery ML for building machine learning models directly within the platform; Worked on operations for a multi-specialty hospital, including 200+ healthcare staff, and oversee patient care initiatives

• Standardized patient records using ETL pipelines in AWS Glue to adhere to HL7 standards; Designed and managed healthcare datasets using Amazon S3, ensuring secure and scalable storage; Implemented data lifecycle policies in AWS S3 to optimize cost and performance.

• Worked on PostgreSQL databases for secure data storage and retrieval; Visualized clinical performance metrics in Tableau, facilitating executive decision-making; Created dashboards to visualize predictions from ML models integrated into AI Studio; Evaluated ML models using metrics like RMSE, accuracy.

• Wrote SQL queries to extract, clean, and transform data for analytics and reporting, and automated dashboards for real- time KPI monitoring, enhancing decision-making; Conducted regular KPI reviews to assess project success and identify trends, integrating Snowflake with Tableau and Power BI for seamless visualization; Used Jira reports to analyze sprint performance and identify bottlenecks in data analytics pipelines.

• Partnered with compliance teams to ensure alignment with HIPAA regulations; Spearheaded data-driven decision-making, enhancing the quality of patient records and improving hospital efficiency. Data Analyst September 2018 - December 2020

JIMS Hospital Hyderabad, India

• Utilized data coding skills for hospital records management, including Electronic Health Records (EHR); Gained practical experience in healthcare analytics; Implemented data-driven solutions to improve patient record accuracy, enhancing data quality by 20%; Conducted training sessions for hospital staff on efficient data entry practices, reducing errors.

• Collaborated with a team to develop an automated reporting system for patient diagnostics, increasing reporting speed; Spearheaded the development of a patient feedback analysis system using.

• Created dashboards in Power BI and Tableau to visualize patient outcomes, readmission rates, and operational metrics derived from EHR data; Generated reports for compliance with healthcare regulations and Joint Commission standards using data sourced from EPIC.

• Ensured compliance with healthcare regulations and standards in all processes and systems; Used Python to automate data cleaning and transformation tasks; Python, identifying key areas for service improvement; Designed dynamic AWS QuickSight dashboards, visualizing patient satisfaction and treatment efficiency.

• Conducted stakeholder workshops to refine reporting requirements; Provided assistance to patients and implemented treatment procedures for 4 years, caring for 1,000+ patients. PROJECTS

• Breast Cancer Prediction using SVM Models :Developed SVM models for predicting breast cancer, achieving an accuracy rate of 90%, India, Hyderabad 2021

• Hospital Data Analysis with Power BI :Engineered a robust data ingestion pipeline using AWS services to streamline data processing, reducing manual effort by 40%; Cloud Data Management Project: Automated data backup processes using AWS Lambda, reducing data loss risk by 50%, India, Hyderabad, 2022

• EHR Records Management (January 2023 - March 2023) Pill Reminder Application Development (Aug 2024 - Dec 2024), Startup Craftors,LA

• Technical Documentation and Visualization: Created detailed workflow documentation and data visualizations to support training and implementation across units (USA, AHN, 2024)

• Digitalization of Vascular Compliance Rate: Designed and implemented a digitalized solution to track and improve vascular compliance rates (USA, AHN, 2024)

• Dashboard Development Across 20 Units: Developed an interactive Power BI dashboard that streamlined quality and performance tracking across 20 units. ( USA, AHN, 2024)

• Patient Outcome Assessment Project: Gathered and analyzed information to standardize workflows for patient outcome assessments across multiple specialties (USA, AHN, 2024)

• Dashboard for Healthcare-Associated Infections (HAIs): Designed a Power BI dashboard to monitor and analyze HAI rates, providing actionable insights for quality improvement (USA, AHN, 2024) CERTIFICATIONS

Python Certification SQL Certification Currently pursuing AWS Cloud Architect Certification AI Studio R studio Professional Medical License Power BI NSLS Leadership training Certificate HIPAA EDUCATION

Master of Science in Health Care Analytics Robert Morris University, Pittsburgh, PA Aug 2023 Bachelors of Medicine and Surgery Kaloji Narayan Rao University, India May 2021

Contact this candidate