Abraham Kim
Seattle,Washington
Summary
Experienced healthcare data analyst with a proven track record of driving business and clinical outcomes by extracting actionable insights from complex datasets.
Overview
7
7
years of professional experience
Work History
Senior Healthcare Analyst
Cecelia Health
07.2023 - Current
- Highlights the impact of care management programs by visualizing key clinical quality metrics in Tableau, effectively demonstrating program value to clients
- Collaborates with clinical leadership and engineering to gather and define requirements for diverse reporting needs
- Spearheads the SQL development for SLA metrics and the development of an SLA surveillance dashboard in Tableau for the company’s largest client, empowering leadership to make informed, targeted operational decisions to meet SLA requirements
- Delivers time-sensitive ad-hoc reports for C-suite and the Customer Success team, ensuring timely and actionable insights
- Troubleshoots and optimizes existing client-facing dashboards to improve the quality and accuracy of reporting
- Acts as the primary source of data quality assurance for all client-facing dashboards, collaborating internally and externally to address edge cases and resolve data discrepancies
- Delivers monthly reports to customers, highlighting member satisfaction metrics, referral statistics, and clinical outcomes
- Enabled the successful scaling and launch of the company’s largest pilot care management program by providing actionable, data-driven operational insights to clinical leadership, resulting in a ~5% month-over-month improvement in customer conversion rates
- Automated multiple daily operational reports using Python and SQL, streamlining workflows and significantly boosting team efficiency
- Developed a custom SQL function to calculate business minutes between any given start and end date, enabling accurate measurement of SLA metric performance
Senior Data Analyst
Valera Health
04.2022 - 07.2023
- Led all clinical quality metrics development for a successful 45 MM series B fundraise, developing custom HEDIS metrics for the practice such as Depression Screening %, Depression Screening + Follow Up, Metabolic Screening for Patients on Antipsychotics, and Depression Remission, Response, Improvement
- Synthesized provider attribution logic to portray clinical quality metrics at the provider level of detail, enabling clinical leadership to take on a targeted approach to improving quality
- Developed a medication surveillance dashboard that unearthed anomalous prescribing practices, allowing clinical leadership to hold providers accountable for non-adherence to clinical protocols
- Led the company response to new DEA regulations by synthesizing a DEA controlled substances dashboard that ensured providers were adhering to approved protocols
- Transitioned all clinical quality-related data sources from Postgres to AWS, developing business critical public schema tables from the data lake
- Transitioned all clinical quality-related Tableau Dashboards to AWS QuickSight
- Implemented a formal QA process with Github/VScode, bolstering credibility across the company
- Served as a critical QA lead during the transition from Postgres to AWS, pointing out specific data needs to engineering for clinical reporting
- Served as lead analyst for a successful value-based contract with CDPHP (NY) which yielded tens of thousands in bonus payments per quarter
Business Intelligence Analyst
Aledade, Inc.
05.2020 - 04.2022
- Synthesized data products through Snowflake and Tableau to unearth actionable business insights to leadership
- Created sustainable reporting infrastructure through modeling of raw, unstructured data into usable views/tables in Snowflake
- Effectively interfaced with engineering/product management to communicate technical requirements of incoming reporting needs
- Conducted exploratory analyses to inform c-suite on viability of new lines of business (regression, paired t-tests, etc.)
- Developed meaningful and sustainable KPI's to measure success of new application features
- Served as consult to critically assess the viability and business relevance of proposed application features
Analyst, Clinical Informatics
Evolent Health
07.2018 - 04.2020
- Supported Clinical Informatics with design, development, implementation and maintenance of technical specifications for algorithms that describe a patient's clinical data and experience
- Developed NCQA HEDIS Certified clinical quality measures via XML in an Agile methodology setting
- Lead quality assurance efforts related to the performance of rule engine algorithms via SQL reporting
Education
Master of Science - Applied Health Sciences Informatics
The Johns Hopkins University School of Medicine
Baltimore, MarylandBachelor of Science - Neuroscience and Behavioral Biology
Emory University
Atlanta, GeorgiaSkills
Querying Languages:
-PostgreSQL
-SnowflakeSQL
-PrestoSQL
-T-SQL
OOP Languages:
-Python (Pandas, NumPy, Matplotlib)
Data Visualization Tools:
-Tableau
-Quicksight
Data Types:
-EHR
-Payor Claims/837 Claims
-Web/Mobile App data
-Five9 (Call Log)
Timeline
Senior Healthcare Analyst
Cecelia Health
07.2023 - Current
Senior Data Analyst
Valera Health
04.2022 - 07.2023
Business Intelligence Analyst
Aledade, Inc.
05.2020 - 04.2022
Analyst, Clinical Informatics
Evolent Health
07.2018 - 04.2020
Master of Science - Applied Health Sciences Informatics
The Johns Hopkins University School of Medicine
Bachelor of Science - Neuroscience and Behavioral Biology
Emory University
Similar Profiles
Carolyn GalbraithCarolyn Galbraith
Care Coordinator at Cecelia HealthCare Coordinator at Cecelia Health
Ashton PardonAshton Pardon
Enterprise Support Manager at Cecelia HealthEnterprise Support Manager at Cecelia Health
LINDSAY BODREELINDSAY BODREE
Utilization Review Nurse at Cohere HealthUtilization Review Nurse at Cohere Health