BHAVANI K
+1-628-***-**** ************@*****.***
PROFESSIONAL SUMMARY:
Detail-oriented Data Analyst with nearly 2 years of experience in data analysis, reporting, and business intelligence across healthcare and digital media domains. Proficient in SQL, Python, Excel, Tableau, and Power BI, with skills in data cleaning, validation, exploratory data analysis, and dashboard development. Skilled in analyzing large datasets, identifying trends, resolving data-quality issues, and preparing reports to support business decisions. Holds a master's degree in data science.
EDUCATION:
University of the Cumberlands (UC)
Master of Science in Data Science (December 2024)
GPA: 4.00/4.00
Relevant Coursework: Statistics for Data Science, Data Science Programming with Python, Data Management for Data Science, Data Mining, Big Data, R Programming, Natural Language Processing, Deep Learning.
TECHNICAL SKILLS
Programming:
Python, SQL,T-SQL
Python Libraries:
Pandas
Data Visualization & Reporting:
Tableau, Power BI, Dashboard Development, KPI Reporting
Data Analysis:
Exploratory Data Analysis (EDA), Trend Analysis, Data Aggregation, Data Quality Analysis
Data Cleaning & Processing:
Data Cleaning, Data Validation, Data Transformation, Data Preparation, Python Scripting
Databases & Query Tools:
Microsoft SQL Server, SQL Server Management Studio (SSMS), Relational Databases
Microsoft Office:
Microsoft Excel, Microsoft Word, Microsoft PowerPoint
Generative AI Tools & Productivity:
ChatGPT, Google Gemini, Microsoft Copilot, Claude, DeepSeek, Perplexity AI, Prompt Engineering, AI-Assisted Research, Content Generation, AI-Assisted Problem Solving.
Environment:
Jupyter Notebook, Visual Studio Code
PROFESSIONAL EXPERIENCE:
Amalgam Technologies Inc. Data Analyst
October 2025 – Present
Project: Streaming Viewership & Advertising Performance Analytics
Technologies: SQL, Python, Pandas, Tableau
Analyzed streaming viewership and advertising performance datasets to identify trends and support business reporting.
Wrote SQL queries using joins, filters, and aggregations to retrieve and prepare datasets for analysis and reporting.
Used Python and Pandas to clean datasets, handle missing values, identify duplicate records, and perform data-quality checks.
Analyzed viewing activity, audience engagement, and advertising performance metrics to support recurring business reports.
Developed and maintained Tableau dashboards to monitor viewership trends, audience engagement, and advertising KPIs.
Validated dashboard metrics against SQL query results and available source data to identify reporting discrepancies.
Investigated data inconsistencies and performed data validation and reconciliation to support accurate reporting.
Prepared weekly and monthly performance summaries and communicated analytical findings to business stakeholders.
CVS Health Healthcare Data Analyst
January 2025 – September 2025
Project: Healthcare Claims Data Quality & Utilization Reporting
Technologies: Microsoft SQL Server, SSMS, T-SQL, Python, Pandas, Power BI
Retrieved and analyzed healthcare claims, member, and provider datasets from Microsoft SQL Server using SSMS for reporting and analysis.
Developed T-SQL queries using joins, filters, grouping, and aggregations to prepare datasets for healthcare claims reporting.
Analyzed healthcare claims activity and utilization trends to identify reporting patterns and variations.
Used Python and Pandas to clean datasets, handle missing values, identify duplicate records, and perform data-quality checks.
Validated claims datasets by comparing record counts, missing fields, duplicate records, and data inconsistencies.
Developed Power BI dashboards to monitor claims activity, utilization trends, and operational KPIs.
Reconciled Power BI dashboard metrics with SQL query results to investigate and resolve reporting discrepancies.
Prepared recurring analytical reports and communicated findings to business stakeholders.