Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Work Preference
Timeline

Revathi Puppala

Data Analyst
Milwaukee

Summary

Results-driven Data Analyst with over 4 years of expertise in healthcare data analysis and compliance. Proven ability to lead data optimization initiatives, increasing productivity by 15% through streamlined workflows. Proficient in SQL for complex data analysis and query optimization within fast-paced environments. Extensive experience with MySQL and Server databases. Skilled in creating interactive dashboards and delivering actionable insights using Tableau and Power BI. Adept in data visualization, data modeling, and data mining. Strong collaborator with expertise in Git and GitHub for version control and project management.

Overview

4
4
years of professional experience

Work History

Data Analyst

HCA Healthcare
01.2024 - Current
  • Formulated and documented data-centric business requirements, identifying critical data needs and addressing issues in Electronic Medical Records (EMR), billing systems, and custom healthcare applications across the hospital network
  • Engineered large-scale data pipelines and structures using SQL and Python, achieving a data processing efficiency and ensuring streamlined data collection and standardization
  • Maintained HIPAA compliance when handling sensitive patient information, upholding strict confidentiality and ethical standards in all data management processes
  • Developed and implemented a system to generate weekly patient health profiles for those who missed checkups, resulting in a 30% increase in exam adherence and helping reduce the gap in patient care
  • Created executive-level KPI dashboards and reports in Power BI, enabling healthcare leaders to make strategic decisions based on clear, insightful data visualizations
  • Collaborated with clinical researchers to support predictive modeling initiatives, utilizing logistic regression, KNN, SVM, and random forest algorithms to identify trends and improve healthcare delivery.
  • Maintained complex SQL queries, stored procedures, and functions to support data processing and analysis, ensuring data quality and integrity, resulting in data-related errors.
  • Wrote Subqueries, Stored Procedures, Triggers, Cursors, and Functions on SQLand PostgreSQL database.

Data Analyst

SeaGate
05.2019 - 01.2023
  • Conducted comprehensive Exploratory Data Analysis (EDA) to uncover patterns, trends, and outliers in large sales and operations datasets, providing actionable insights that improved data-driven decision-making
  • Developed and managed interactive dashboards using Tableau and Power BI, which streamlined data visualization for cross-functional teams and reduced report generation time by 35%
  • Enhanced Excel-based analytical tools by creating pivot tables, VLOOKUPs, and other advanced functions, improving the accuracy and efficiency of data processing and reporting
  • Utilized Python libraries (NumPy, Pandas) to automate data wrangling processes, significantly reducing data preparation time and enabling more efficient analysis.
  • Hands-on experience in Using DDLand DMLfor writing Triggers, Stored Procedures, and Data manipulation.
  • Experience in Data Integration, Report development (MIS), and Data miningusing SQL, Tableau& Excel
  • Used AWS services (EC2, S3) to address data storage needs and optimize cloud-based data workflows, ensuring scalability and efficiency in data management practices
  • Conducted root cause analysis of insurance claim data, identifying patterns that reduced overhead costs by 70% through process optimization
  • Established a management dashboard in Power BI to track call center metrics and KPIs, improving performance insights and decreasing reporting time by 35%
  • Experience working with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
  • Created visual representations, graphs, and statistical plots using Python libraries such as Matplotlib, Seaborn, ggplot2, Scipy, and Plotly to convey complex data insights.
  • Utilized SQL and MySQL to create and optimize queries for data extraction and analysis, contributing to more efficient database management and faster access to critical information

Education

Master of Science - Information Technology

University of Wisconsin-Milwaukee
05.2024

Skills

  • Programming Languages: Python, SQL, R, SAS
  • Data Analysis & Statistical Techniques: Exploratory Data Analysis (EDA), Descriptive Inferential Statistics, Regression
    Analysis, Hypothesis Testing, Time Series Analysis, Cluster Analysis, Random Forest, Decision Trees
  • Data Visualization Tools: Tableau, Power BI, Microsoft Excel (Pivot Tables, VLOOKUP, HLOOKUP, Charts), Python
    (Matplotlib, Seaborn)
  • Machine Learning & Predictive Modeling: Logistic Regression, K-Nearest Neighbors (KNN), Support Vector Machines
    (SVM), Random Forest
  • ETL & Data Integration: SQL, SSIS, Informatica Power Center, Talend
  • Big Data & Cloud Technologies: Hadoop, AmazonWeb Services (AWS: EC2, S3), Microsoft Azure
  • Databases & Data Management Systems: MySQL, PostgreSQL, Oracle, MongoDB, Snowflake
  • DataWrangling & Transformation: Data Cleaning, Data Transformation, Data Modeling, Data Integration, Data
    Warehousing
  • Version Control & Collaboration: Git, GitHub, JIRA
  • Soft Skills: Analytical Thinking, Problem-Solving, Communication, Collaboration, Stakeholder Engagement

Websites

Personal Information

Work Preference

Work Type

Full TimeContract Work

Location Preference

On-SiteRemoteHybrid

Important To Me

Career advancementPersonal development programsTeam Building / Company Retreats

Timeline

Data Analyst - HCA Healthcare
01.2024 - Current
Data Analyst - SeaGate
05.2019 - 01.2023
University of Wisconsin-Milwaukee - Master of Science, Information Technology

Similar Profiles

CREATE PROFILE
Revathi PuppalaData Analyst