Hi, I am

AISHWARYA RAO KALLEPU

I'm a

About

Detail-oriented and analytical Data Analyst with 1.5+ years of experience in healthcare, academic research, and enterprise environments. Strong expertise in data cleaning, transformation, analysis, and visualization to drive data-informed decisions. Proficient in SQL, Python, Power BI, and Excel, with hands-on experience building ETL pipelines, dashboards, and automated reporting workflows. Experienced in healthcare and operational data, ensuring accuracy, compliance, and actionable insights. Passionate about translating complex datasets into meaningful business and clinical insights.

Data Analyst &AWS Cloud Practitioner

  • Birthday: 20 April 2001
  • Phone: +1 (656)-565-9217
  • City: Tampa, FL, USA
  • Age: 24
  • Degree: Master's
  • Email: aishurao2021@gmail.com

I specialize in transforming raw data into actionable insights through data analysis, visualization, and automation. My experience includes building SQL-based ETL pipelines, developing Power BI dashboards, and automating reporting workflows using Python. I have worked extensively with healthcare and operational datasets, ensuring data quality, validation, and compliance. I leverage AWS services such as S3, Lambda, and Redshift for scalable data processing and reporting. With a strong foundation in statistics, data modeling, and business analysis, I support stakeholders by delivering clear insights that drive informed decision-making.

Skills

My skills as a Data Analyst mainly comprises of the skills listed below. Additionally, there are other skills which are listed in my resume.

SQL (PostgreSQL, MySQL, SQL Server) 100%
Python (Pandas, NumPy) 95%
Data Cleaning & Transformation 95%
Excel (Pivot Tables, VLOOKUP, Power Query) 90%
Data Visualization 90%
ETL Pipelines 90%
Power BI & Dashboards 95%
GIT 85%
Statistics & Data Analysis 85%
Data Automation 90%
AWS (S3, Lambda, Redshift) 80%
Machine Learning (Basic) 40%

Experience

I have 1.5 years of research and internship experience in analyzing, automating, and visualizing healthcare and operational data workflows.

Education

Master of Science in Computer Science

2023 - 2025

University of South Florida, Tampa, FL

Bachelor of Technology

2019 - 2023

Kakatiya Institute of Technology and Sciences,Warangal, India

Professional Experience

Data Analyst Intern – Tenex Software Solutions

Jan 2025 – Present

Tampa, FL, USA

  • Analyzed operational and financial datasets using SQL and Python to support internal reporting and business decision-making.
  • Built interactive Power BI dashboards to track performance metrics, trends, and KPIs for leadership and stakeholders.
  • Developed automated ETL workflows to clean, validate, and transform data from multiple sources into structured reporting tables.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into data-driven insights.

Graduate Research Assistant – Data Analyst

Aug 2024 - Present

University of South Florida, Tampa, FL

  • Analyzed large-scale healthcare and pathology datasets using SQL and Python to identify trends, anomalies, and clinical patterns.
  • Built automated data pipelines using AWS services to extract, transform, and load structured and unstructured healthcare data.
  • Developed data validation and quality checks to ensure accuracy and consistency across research datasets.
  • Created summary reports and visualizations to support research insights and stakeholder decision-making.

Research Assistant - Moffitt Cancer Center

May 2024 - July 2024

Tampa, FL, USA

  • Collected, organized, and analyzed experimental data related to melanoma and breast cancer research.
  • Maintained structured datasets and documentation to support reproducibility and research reporting.
  • Assisted in summarizing findings and trends from laboratory data for research presentations.

President - USF Squirrel Club

Jan 2024 - Present

Tampa, FL, USA

  • Initially served as Treasurer, managing club finances transparently and efficiently.
  • Coordinated support for international students, including accommodation, transportation, and insurance guidance.
  • Enhanced community building for international students to ensure a welcoming environment at USF.

Projects

These are some of my projects

  • All Projects

Data Automation & Reporting Workflow

Tools: SQL, Python, Power BI, AWS

Focus: ETL • Reporting • KPI tracking

Outcome: Faster refresh, cleaner data, reusable pipeline

Data Automation & Reporting Workflow

SQL Python Power BI ETL AWS
  • Built automated ETL workflow to validate and transform raw datasets into reporting tables.
  • Created KPI-ready outputs for dashboards and recurring refresh cycles to support business reporting.
  • Improved data consistency using validation checks and reusable pipeline logic.

Healthcare Data Analytics Pipeline

Healthcare Data Analytics Pipeline

Python SQL AWS Data Quality ETL
  • Extracted and structured pathology report data for analytics and reporting.
  • Applied validation rules to improve accuracy and consistency across datasets.
  • Prepared datasets for scalable analysis and future predictive modeling.

Healthcare Data Analytics Pipeline

Tools: Python, SQL, AWS

Focus: Text extraction • Data quality • Analytics-ready tables

Outcome: Structured clinical dataset for analysis and reporting

Predictive Analytics Project

Tools: Python, Scikit-learn

Focus: Modeling • Evaluation • Class balancing

Outcome: Reduced false negatives for clinical reliability

Predictive Analytics Project

Python ML PCA SMOTE Model Evaluation
  • Built predictive models to identify high-risk cases using a large healthcare dataset.
  • Applied PCA and SMOTE to improve signal-to-noise and handle class imbalance.
  • Focused on minimizing false negatives to improve real-world reliability.