Piyusha Gunjan

About Piyusha Gunjan

As a Claims Data Analyst at CCHP, I consolidate and analyze health & workers\' compensation reports from various segments of the insurance industry, and prepare and send reports to advocates on a regular basis. I also support the Worker\'s Compensation Advocates in board level reporting and presentations, using Excel and Tableau to calculate and visualize key performance metrics.With a B.Tech degree in Computer Science and three AMCAT certifications in Channel Sales and Collections, I have over three years of professional experience in data analysis, business intelligence, SQL, Python, and Tableau. Prior to joining EPIC Insurance, I worked as a Data Analyst and a HR Recruiting Specialist at Test Yantra, where I performed descriptive and diagnostic analytics, built and designed HR dashboards, performed data manipulation, and recruited and oriented over 500 new employees across the UK and Europe. I am passionate, data-driven, and result-oriented, and I aim to leverage my skills and expertise to deliver value and insights to the insurance and HR domains.

Experience

1. Claim Data Analyst

   Cchp

   Jul 2024 — Present · San Francisco, CA, US

   Led the development and implementation of ETL processes to integrate disparate healthcare data sources, including electronic health records (EHR), claims, Provider rosters. data, and patient satisfaction surveys. Utilized SQL to extract, transform, and analyze large. datasets for insights into patient demographics, clinical outcomes, and healthcare utilization patterns.• Implemented quality control measures to ensure the accuracy and reliability of automated processes, including error handling and validation checks.• Collaborated with eligibility and enrollment, provider network management, compliance departments, and external clients, including Covered California and other small EDI groups, to establish data.• Collaborated with eligibility and enrollment, provider network management, compliance departments, and external clients, including Covered California and other small EDI groups, to establish data requirements, validate data quality, and ensure adherence to healthcare regulations (e.g, HIPAA).• Designed and maintained interactive dashboards and reports using datavisualization tools such as Tableau or Power BI to facilitate data driven decision-making at all levels of the organization.• Presented findings and recommendations to executive leadership through clear and actionable insights, contributing to strategic planning and resource allocation decisions.

Education

• MATS University, Raipur

  B.Tech, Computer Science