Health Informatics - PharmD Candidate - Data Analytics

Lavanya Ruthala

Indianapolis, IN ********@**.*** 205-***-**** linkedin.com/in/lavanya-ruthala SUMMARY

MS Health Informatics candidate (Dec 2025) with a PharmD and experience in clinical pharmacy practice and health information systems. Proficient in SQL, Python, Tableau, and Excel for data analysis, visualization, and EMR customization. Experienced in clinical documentation, workflow optimization, and leveraging health data to support evidence-based decision-making and patient care. PROFESSIONAL EXPERIENCE

Research Assistant, Indiana University, Luddy School of Informatics, Computing, and Engineering — Indianapolis, IN Aug 2025- Dec 2025

• Analysed annotation data across Research Assistants (RAs) for each study participant’s clinical notes to evaluate inter-rater consistency and response accuracy.

• Assessed the impact of pharmacogenetic testing on adverse drug events (ADEs) through structured data review and statistical analysis.

• Utilized Excel for data cleaning, aggregation, and visualization; applied Python (pandas, NumPy, SciPy) for correlation testing, agreement metrics, and trend identification.

• Identified annotation discrepancies, quantified reviewer alignment, and generated insights that improved annotation guidelines and pharmacogenetic interpretation reliability. Data Analyst Intern, GTechnologies Pty Ltd — Remote (Australia) Jun 2025 – Aug 2025

• Designed and implemented a web-based EMR system using React.js, Node.js, and MySQL to improve healthcare data management.

• Built patient registration and appointment modules, optimized ~100 database tables, and supported testing/debugging for data accuracy.

• Collaborated with a remote team to improve usability, interoperability, and compliance with healthcare data standards.

Teaching Assistant, Indiana University, Luddy School of Informatics, Computing, and Engineering — Indianapolis, IN Oct 2024 – Dec 2025

• Assisted faculty in delivering coursework on EHR systems, healthcare interoperability (HL7), clinical decision support, and health data analytics.

• Graded assignments and projects, providing structured feedback to improve students’ analytical reasoning and technical accuracy.

• Supported instruction in Excel-based statistical analysis and Tableau data visualization for healthcare datasets.

• Collaborated with professors to research, review, and update course materials to align with current healthcare technology standards and industry practices. Peer Tutor, Indiana University, Luddy School of Informatics, Computing, and Engineering — Indianapolis, IN Jan 2025 – Dec 2025

• Provided individualized tutoring to students in Health Informatics and Clinical Information Systems, clarifying complex clinical workflows and system concepts.

• Mentored students in developing Gantt charts and managing health IT projects effectively.

• Guided student teams in conducting EHR usability testing and applying human-computer interaction principles.

• Strengthened students’ practical application of informatics tools through hands-on support and problem- solving guidance.

Clinical Pharmacist Intern / Data Entry Intern, Gandhi Hospital, Hyderabad, India Jul 2022 – Jul 2023

• Supported chronic and infectious disease management through patient interviews, monitoring, and counseling, contributing to early detection and prevention in general, gynecology, and pediatrics departments.

• Delivered direct patient care and health education in high-volume inpatient and outpatient settings, including phlebotomy, specimen labeling, and risk communication aligned with public health practices.

• Monitored and reported adverse drug reactions (ADRs), ensuring safe and effective medication use.

• Managed and updated clinical patient records, supporting physicians with evidence-based therapeutic strategies to improve care quality and outcomes.

Clinical Research Intern, Deepam Hospital, India Jun 2020 – Jan 2021

• Gained practical training in WHO-GCP guidelines, bioequivalence standards, and ethical conduct of clinical trials, ensuring understanding of global regulatory compliance requirements.

• Acquired knowledge of the drug discovery and development lifecycle, including preclinical research, Phase I–IV trials, and post-marketing surveillance.

• Participated in clinical research discussions across therapeutic areas including immunology, gynecology, respiratory medicine, and pediatrics, enhancing protocol and disease-area understanding.

• Learned fundamentals of pharmacovigilance and Adverse Drug Reaction (ADR) reporting, including safety monitoring and regulatory documentation practices.

• Developed familiarity with clinical trial regulations, documentation processes, and trial support activities, strengthening understanding of study coordination workflows. EDUCATION

Indiana University, Luddy School of Informatics, Computing, and Engineering Indianapolis, IN Master of Science in Health Informatics December 2025 Jawaharlal Nehru Technological University – Hyderabad Telangana, India Doctor of Pharmacy (Pharm.D) July 2023

SKILLS

Programming & Databases: SQL, Python, R, MySQL, JavaScript (Node.js, React.js),REDCap Data Management & Visualization: Tableau, Power BI, Microsoft Excel, Microsoft Access, EndNote Other Tools: DBeaver, Microsoft Office Suite

Professional: Communication, Collaboration, Attention to Detail, Problem-Solving PROJECT EXPERIENCE

Investigating Factors Influencing Asthma Diagnosis Aug 2024 – Dec 2024

• Analyzed 999 patient cases from Kaggle using R to evaluate demographic, lifestyle, and environmental risk factors for asthma diagnosis.

• Performed data preprocessing, class balancing, and exploratory data analysis to prepare data for modeling.

• Applied Mann-Whitney U, Chi-Square, and Logistic Regression with stepwise feature selection to identify key predictors.

• Focused on integrating statistical modeling techniques to understand associations between clinical and non-clinical variables.

ETL Pipeline Demonstration Aug 2024 – Dec 2024

• Built an ETL pipeline in Python to extract, transform, and load healthcare data from FHIR-compliant APIs

(OpenEMR, Hermes Terminology Server, Primary Care EHR).

• Implemented Python scripts with secure authentication (Bearer Tokens) to retrieve patient demographics, conditions, and procedures.

• Standardized and cleaned data using SNOMED codes to improv accuracy, interoperability, and hierarchical representation of medical conditions.

• Automated secure integration into FHIR servers, enhancing data quality, reducing manual errors, and enabling clinical dashboards and predictive modeling. Indiana Mental Health Events Dashboard (Power BI) Feb 2025

• Collected and cleaned Indiana Data Hub public dataset (92 counties 6 years) in Power Query; standardized types/dates and handled nulls/outliers for analysis readiness.

• Built DAX measures for Total Events, Events per 10k (population-adjusted), YoY change, and age-group share to enable rate-based comparisons.

• Designed an interactive report (yearly trend, county ranking, age-group distribution, slicers, drill-through, tooltips) for quick anomaly detection and geographic drill-downs.

• Validated row counts and yearly totals; summarized insights (largest share from 18–60 age group; peak in 2021 with slight dip in 2022) and documented a lightweight data dictionary. Chronic Disease Management Analysis Aug 2025 – Dec 2025

• Designed a normalized relational database (patient, encounter, prescription, procedure tables) to support cohort-based analysis of asthma and hypertension management.

• Developed reusable SQL CTEs to define chronic patient cohorts from encounter-level clinical data, ensuring consistent and accurate population health analysis.

• Performed advanced SQL analytics (JOINs, GROUP BY, COUNT DISTINCT, CASE, TIMESTAMPDIFF) to evaluate follow-up trends, medication utilization, procedures, and demographic distributions.

• Identified care utilization differences between asthma and hypertension patients and translated findings into visualization-ready datasets using Python (Pandas, Matplotlib) for clear clinical insight reporting. CERTIFICATIONS

CITI Program – Biomedical Researcher, Stage 1

CITI Program – Good Clinical Practice (GCP)

HIPAA Privacy and Security — Fall 2025

SQL Essential Learning

Project Management Job Simulation

PUBLICATIONS

• Kasturi, S., Vankodoth, S., Ruthala, L., Cheppalli, V., & lunavath, G. (2023). Multiple cerebral infarcts: A rare and delayed presentation of honeybee sting bite. Asian Journal of Case Reports in Medicine and Health, 6(1), 134–137. https://journalajcrmh.com/index.php/AJCRMH/article/view/169.

• Sireesha, V., Pratibha, M., Kumar, M., Reddy, C., & Lavanya, R. (2023). An overview on COVID-19 induced avascular hip necrosis . European Journal of Pharmaceutical and Medical Research, 10(5). https://storage.googleapis.com/innctech/ejpmr/article_issue/168*******.pdf

• Rajesham, V & Lavanya, R & Nikitha, K & Rao, S & Tadikonda, Rama. (2022). Treatment protocol and recovery rate for epileptic patients in tertiary care hospital. YMER. 21(11). 302-310. 10.37896/YMER21.11/28

Contact this candidate