Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

RAGHU VAMSI NALLA

Dalton,GA

Summary

Results-driven Data Analyst with a master’s degree and 4+ years of experience in the healthcare IT. Proficient in requirement gathering and transforming complex data into actionable insights through advanced analysis, data visualization, report development, and validation.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Business Intelligence Developer

Hamilton Medical Center
Dalton, GA
08.2023 - Current
  • Responsible for gathering the requirements from the end users/stakeholders and translating the business requirements into technical specifications
  • Worked on creating several reports tied to patient demographics, encounters, vitals, diagnosis, ICD codes, orders, medications, prescriptions, and procedure data from the Epic clarity EHR database
  • Involved in creating various reports within Reporting workbench and Slicer Dicer and shared them with the end users
  • Designed, developed, and optimized complex SSRS reports and ETL processes to extract, transform, and load data from various sources, ensuring data accuracy and timely reporting for key business decisions
  • Used several tools within Epic but not restricted to analytics catalog, data dictionary, column search, and record viewer to ensure that the data points are aligned with the user’s requirement
  • Involved in documenting and evaluating existing data sets that feed into the reports and dashboards
  • Responsible for generating monthly and ad-hoc reports, used Power Automate to schedule and distribute recurring reports
  • Enhanced existing report performance by optimizing DAX expressions, reducing computational complexity and ensuring faster query execution
  • Utilized Python libraries such as Pandas, NumPy, and Matplotlib for data analysis, manipulation, and visualization for data efficiency.

Masters Project - Predictive Analytics for Business Strategy Optimization

University of Memphis
Memphis, TN
01.2023 - 05.2023
  • Conducted in-depth data analysis on large datasets to identify key business trends and patterns, resulting in actionable insights that informed strategic decision-making
  • Designed and analyzed complex SQL queries to categorized business data
  • Developed predictive models using advanced statistical techniques and tools such as Python and R, enabling better business performance and optimization
  • Integrated and transformed data from multiple sources within Power BI, enabling seamless analysis and consistent reporting across various datasets.

Associate Systems Engineer

Novartis Healthcare
Hyderabad, India
08.2019 - 07.2022
  • Primarily worked on clinical data warehouse that captured EMR data, labs, and other third-party data
  • Responsible for developing SQL queries and stored procedures to extract, manipulate, and analyze data for reporting and decision-making purposes
  • Used ETL informatica to import flat files data into the clinical data warehouse
  • Conducted data analysis, preprocessing, and cleanup to ensure the accuracy and integrity of patient-related clinical data using Crystal Reports
  • Leveraged advanced Microsoft Excel functionalities, including pivot tables and lookup formulas, to analyze large datasets, extract actionable insights, and provide strategic data-driven recommendations
  • Developed interactive Tableau dashboards to analyze and present complex datasets, enabling data driven decision-making
  • Responsible for testing the reports ensuring the data quality and functionality meet the users requirements.

Education

Master of Science in Information Systems -

University of Memphis
Memphis, TN
05.2024

Bachelor of Science in Computer Science Engineering -

Jawaharlal Nehru Technological University
Andhra Pradesh, India
05.2017

Skills

  • MS SQL
  • Java
  • Python/R
  • ETL
  • Oracle PL/SQL
  • MS Office
  • Tableau
  • Power BI
  • Crystal Reports
  • IBM NoSQL
  • Big Data
  • Spark Foundations
  • Data Science with Databricks for Data Analysts
  • Meta Database Engineer

Certification

  • IBM NoSQL, Big Data, and Spark Foundations (Coursera)
  • Data Science with Databricks for Data Analysts (Coursera)
  • Meta Database Engineer (Coursera)

Timeline

Business Intelligence Developer

Hamilton Medical Center
08.2023 - Current

Masters Project - Predictive Analytics for Business Strategy Optimization

University of Memphis
01.2023 - 05.2023

Associate Systems Engineer

Novartis Healthcare
08.2019 - 07.2022

Master of Science in Information Systems -

University of Memphis

Bachelor of Science in Computer Science Engineering -

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
RAGHU VAMSI NALLA