Rajesh Shahu

About Rajesh Shahu

I’m a results-driven Data Analyst with 6+ years of experience delivering actionable…

Experience

1. Data Analyst

   Cardinal Health

   Feb 2024 — Present · CA, US

   Partnered with clinicians and product managers to define project requirements, translating care management goals into measurable KPIs such as risk stratification accuracy, care-gap closure rates, and outreach conversion.• Extracted and standardized over 20 million claims, pharmacy, and device records from Teradata using advanced SQL queries, building a unified dataset that reduced manual preparation time by 30%.• Developed data quality scripts in Python (Pandas) to identify and resolve missing values, outliers, and duplicate entries, increasing the accuracy of model input data to 98%.• Engineered clinical and utilization features (adherence scores, chronic condition indicators, prior admissions) that improved the precision of risk models to 85%, enabling earlier identification of high-cost members.• Performed statistical testing in Python to evaluate intervention cohorts, confirming that targeted outreach reduced inpatient admissions by 18% and delivered $12M in annual medical cost savings.• Built interactive dashboards in Tableau to track engagement lift, cost trends, and care-gap closure progress, giving leadership near real-time visibility and reducing reporting cycles by 25%.• Created provider-level performance scorecards in Excel (PivotTables, Macros) that highlighted outreach effectiveness, driving a 20% increase in provider compliance with care protocols.• Automated daily ETL workflows with SQL Server Integration Services (SSIS), cutting data refresh time from 48 hours to 12 hours and ensuring timely delivery of updated risk scores.• Deployed curated datasets and dashboards to AWS Redshift with secure, role-based access controls, maintaining HIPAA compliance and passing internal audits with zero findings.• Produced monthly monitoring reports to track model drift and program ROI, providing insights that supported continuous enhancements and sustained a 15% year-over-year improvement in care-gap closures.