Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ramya Devarapelly

Hartford,CT

Summary

Experienced Data Analyst with 5 years of expertise in Clinical Informatics and Business Analysis. Proven track record in enhancing data integrity and optimizing reporting processes, leading to improved decision-making. Core competencies include data visualization, statistical analysis, and stakeholder collaboration. Committed to leveraging analytical skills to drive strategic initiatives in healthcare environments.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Healthcare Project Data Analyst

Regenstrief Institute
Indianapolis, Indiana
02.2024 - 12.2024
  • Created dashboards, reports, and visualizations to monitor trends in patient outcomes.
  • Extracted data elements such as demographics, encounter types, and clinical observations using ICD and CPT codes.
  • Improved project productivity by 18% through enhanced tracking of clinical data progress, ensuring timely project delivery while aligning with organizational goals.
  • Performed data manipulation and analysis using SAS for efficient extraction and reporting.

Health Database Research Analyst

Luddy School of Informatics and Computing
Indianapolis, Indiana
09.2023 - 12.2023
  • Spearheaded the collection and interpretation of 130+ patient records across four hospitals, achieving a 98% data accuracy rate using platforms such as REDCap, Cerner, Excel, and EPIC.
  • Conducted comprehensive data validation and cleaning, establishing a strong foundation for advanced statistical analysis in SPSS to assess treatment impacts and compare pre- and post-treatment effects.
  • Communicated key insights and trends through Power BI dashboards and presentations, driving informed decision-making at senior levels.

Clinical Data Analyst

IU Methodist Hospital
Indianapolis, Indiana
05.2023 - 08.2023
  • Conducted advanced statistical analyses of physiological data, improving data-driven decision-making by 15%.
  • Developed a mortality prediction model using Scikit-Learn and TensorFlow, enhancing accuracy and positively impacting patient outcomes.
  • Applied Git for version control, reducing development time by 30% and ensuring efficient, collaborative problem-solving.

Data Analytics Research Assistant

Luddy school of informatics
Indianapolis, Indiana
01.2022 - 12.2022
  • Extracted and analyzed Medicare and Medicaid claims data to identify cost drivers and inefficiencies in healthcare spending.
  • Collaborated with cross-functional teams to recommend data-driven strategies for cost reduction and policy improvements in healthcare claims management.
  • Created data visualizations and dashboards using Tableau, Power BI, and Excel to present actionable insights to management and stakeholders.

Clinical Data Analyst Intern

Gandhi Hospital
Hyderabad
05.2020 - 06.2021
  • Executed comprehensive data cleaning and analysis using SQL, reducing data discrepancies by 20% and ensuring precision across healthcare data sources.
  • Enhanced data analysis workflows by creating advanced Excel Pivot tables and V-lookup tables, reducing interpretation time and improving ROI.
  • Developed and managed hospital dashboards with Power BI and Tableau, providing real-time insights and facilitating data-driven strategies.

Education

Master of Science - Health Information Technology

Indiana University
IN
01-2022

Pharm D

Anurag Group of Institutions
India
05-2021

Skills

  • HRIS database management
  • SQL databases
  • PostgreSQL management
  • Database Management Competency
  • Azure SQL database
  • Project planning
  • HIPAA compliance
  • ICD-10 and CPT coding skills
  • HEDIS compliance
  • EHR user training
  • EMR expertise
  • Proficiency in Python
  • Tableau
  • Power BI
  • SPSS/STATA/SAS software
  • Advanced SAS programming
  • R programming expertise

Certification

  • Attained Project Management Professional certification, showcasing expertise in strategic project execution.
  • Secured Six Sigma Belt certification, demonstrating proficiency in process improvement methodologies.

• Earned certifications in HTML and CSS, validating strong web development skills.

Timeline

Healthcare Project Data Analyst

Regenstrief Institute
02.2024 - 12.2024

Health Database Research Analyst

Luddy School of Informatics and Computing
09.2023 - 12.2023

Clinical Data Analyst

IU Methodist Hospital
05.2023 - 08.2023

Data Analytics Research Assistant

Luddy school of informatics
01.2022 - 12.2022

Clinical Data Analyst Intern

Gandhi Hospital
05.2020 - 06.2021

Master of Science - Health Information Technology

Indiana University

Pharm D

Anurag Group of Institutions
Ramya Devarapelly