Deepa Chandramohan
Suwanee,GA
Summary
Certified Power BI Data Analyst
Overview
5
5
years of professional experience
1
1
Certification
Work History
Coding Quality Analyst
OPTUM
Suwanee, GA
01.2022 - Current
- Conduct in-depth audits of medical records to ensure accurate HCC coding for risk adjustment and compliance with Medicare/Medicaid guidelines
- Analyze healthcare claims data to identify discrepancies, trends and opportunities for improving risk scores and patient categorization
- Collaborate with coding teams to improve coding accuracy and optimize revenue related to risk adjusted populations
Senior Medical Coder
OPTUM
Suwanee, GA
07.2019 - 01.2022
- Reviewed and audited patient medical records to accurately assign ICD-10 codes relevant to HCC models, ensuring adherence to CMS (Centers for Medicare & Medicaid Services) guidelines and risk adjustment policies
- Ensured coding accuracy by conducting prospective, concurrent and retrospective reviews of medical records, identifying chronic conditions and comorbidities for risk adjustment and payment models
- Collaborated with physicians and healthcare providers to improve clinical documentation that supports risk-adjusted coding, ensuring accurate diagnosis capture and reduced coding discrepancies
Education
Master of Science - biotechnology
Bharathiar University
06.2004
Skills
- SQL (MySQL, PostgreSQL)
- Python
- Tableau
- ICD 10 CM
- HCPCS
- CPT
- Excel (VLOOKUP, Conditional Formatting, Pivot Tables)
- Statistics
- Microsoft Power BI
- Machine learning
- Descriptive statistics
Certification
- Power BI Data Analyst - Microsoft
- Certified Professional Coder (CPC) - AAPC
- Certified Risk Adjustment Coder (CRC) - AAPC
Projects
Attrition Rates in Nurse using Power BI in Visualization
https://github.com/dchan82/deepa.git
In this project, I did a department, age and gender based exploratory analysis to uncover the factors that lead to nurse attrition and explore important questions such as ‘show me a breakdown of distance from home by job role and attrition or compare average monthly income by education and attrition’.
Hospital Performance Dashboard using Tableau in Visualization
https://github.com/dchan82/Tableau.git
In this project I developed a hospital performance dashboard using Tableau to track key operational and patient care metrics, providing actionable insights for healthcare management.
Healthcare Patient Appointment Analysis Dashboard
https://github.com/dchan82/PowerBI.git
This dashboard provides an in-depth analysis of patient appointments and wait times in a healthcare setting. The goal was to deliver key insights into patient demographics, appointment types, and department referrals, helping stakeholders optimize patient flow and improve service delivery.
Timeline
Coding Quality Analyst
OPTUM
01.2022 - Current
Senior Medical Coder
OPTUM
07.2019 - 01.2022
Master of Science - biotechnology
Bharathiar University
Similar Profiles
Nowelle HoweNowelle Howe
Quality Specialist at OptumQuality Specialist at Optum
Rushik Reddy GangamRushik Reddy Gangam
Software Engineer - Remote at OptumSoftware Engineer - Remote at Optum
Arun ChoudharyArun Choudhary
Quality Analyst at OptumQuality Analyst at Optum
Adam DugginsAdam Duggins
Associate Director, Workforce Planning at OptumAssociate Director, Workforce Planning at Optum
Amrutha TatiparthiAmrutha Tatiparthi
Competitor at Future Business Leaders of America, FBLACompetitor at Future Business Leaders of America, FBLA