Rajkumar Badavath

Business Data Analyst @Tenet Healthcare

US

Developed and optimized SQL queries involving joins, CTEs, and window functions to extract, transform, and validate healthcare and financial data from PostgreSQL, and SQL Server. Built advanced Excel dashboards with Power Query, pivot tables, slicers, and VBA macros for budgeting, forecasting, andvariance analysis.• Followed SDLC principles to manage the end-to-end lifecycle of reporting and analytics solutions—requirement gathering, development, QA/UAT, and deployment; Used Python (Pandas, NumPy, Matplotlib) to analyze trends in healthcare costs, claim denial patterns, and utilization efficiency.• Collaborated with ETL developers to embed SQL logic into data pipelines for efficient processing; Shared Excel-based models with leadership for interactive financial planning and resource allocation.• Automated delivery of weekly and monthly reports through BI tools and email scheduling; Assisted in preparing data for ML models used in predicting patient readmissions and financial fraud detection.• Used Python (Pandas, NumPy, Scikit-learn) to clean, transform, and engineer features from clinical and claims data; Supported collaboration with data scientists on model evaluation, training pipelines, and performance tuning.• Worked with large-scale healthcare datasets processed via Hadoop MapReduce for batch data analysis; Integrated MapReduce outputs into dashboards for population health and treatment outcome reporting.• Used AWS S3 to store and manage large datasets securely, supporting data retrieval for dashboards and reporting tasks across departments; Queried data using AWS Athena and processed files with AWS Glue, helping automate ETL workflows and reduce manual data preparation time.• Used shell scripting in Linux/Unix environments for automating ETL workflows, scheduling jobs (cron), and performing system-level data validation; Managed log files, file transfers, and data ingestion tasks for secure financial and EHR systems.