Bharnab

R1

R1RCM • Fulltime

Jan 2025 - Feb 2026 • 1 yr 1 mo

Expert Data & ETL Analyst | Revenue Cycle Systems I specialize in architecting end-to-end data workflows to optimize financial performance. During my tenure at R1RCM, I spearheaded the ETL (Extract, Transform, Load) process for high-volume healthcare datasets from major institutions like Baylor Scott & White. Extract: Managed large-scale data extraction from the Epic Systems database, ensuring data integrity across thousands of patient and financial records. Transform: Utilized SQL and Advanced Excel to clean, normalize, and validate unstructured denial data. I engineered complex logic to categorize technical discrepancies and eliminate data redundancies. Load & Visualize: Built automated reporting pipelines and Power BI and Excel dashboards to load transformed data into executive-level summaries, tracking recovery trends and revenue leakage. My expertise lies in converting "raw, noisy data" into structured, high-accuracy assets that drive multi-million dollar financial recoveries and operational efficiency.