Kandukuri Nikhil
Data Engineer at ChenMed | Graduate student at Northeastern University | Master in Data Analytics Engineering
- Role
- Data Engineer at ChenMed
- Location
- Boston, MA, US
- LinkedIn followers
- 500 followers
About Kandukuri Nikhil
At ChenMed, contributed to data engineering initiatives utilizing skills in DBT…
Experience
Data Engineer
Aug 2024 — Present · Miami Gardens, FL, US
Designed and developed core dimension and fact tables for the Member Condition Mart, enabling unique identification of patient diagnosis codes (ICD-10 and HCC) and precise tracking of diagnosis status to support enterprise-wide analytics and reporting.• Developed and implemented robust logic for the Member Condition fact table, ensuring accurate monthly data representation by dynamically inserting proxy records when member evaluations were absent and eliminating them when actual assessments occurred, effectively filling evaluation gaps and increasing PMPM revenue.• Enhanced data integrity and eligibility tracking by incorporating retrospective updates to member eligibility status, ensuring the active flag within the fact table accurately reflects real-time changes in patient coverage and condition status.• Built an automated, multi-stage data pipeline in Snowflake using stored procedures (SQL/Snowpark), tasks, streams, and alerts to efficiently orchestrate data flow from staging to final fact tables.• Built Snowpark-based data quality checks to load payor files using customized validation rules for each file and to monitor nulls, data growth, and regression in the Membership Mart view, ensuring accurate membership tracking.
Education
Guru Nanak Institutions(GNI)
Bachelor of Technology - BTech, Information Technology
Northeastern University
Master's degree, Data Analytics Engineering
International Institute of Information Technology Bangalore
Postgraduation Diploma, Machine Learning and Artificial Intelligence
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.