David Hedrick Email & Phone Number

Columbus, Oh, Us

Nashville, Tn, Us

Columbs, Oh, Us

• Designed and developed 2024 model for targeting of patients with high risk of avoidable utilization, resulting in enhanced capability to be proactive on medical expense, with significantly increased physician agreement over legacy models.• Developed a classification model to predict probability of twelve-month mortality in Medicare Advantage and traditional Medicare populations, leading to more accurate targeting and early intervention of patients in need of home, palliative, and hospice care.• Served as lead scientist on clinical program evaluation, including care management, palliative care and hospice for ~500,000 Medicare lives.• Mined claims data to search for irregularities in cost utilization patterns to identify cost-savings opportunities for value-based care.• Trained and mentored more junior members of medical economics and analytics teams.• Pioneered data strategy for identifying rising risk patients.• Key member of budget and business planning workgroups for all markets.

Columbs, Oh, Us

Columbs, Oh, Us

Westerville, Ohio, Us

• Created a parsing and post-receipt processing methodology for inbound HL7 ADT messages from a statewide health information exchange.• Cleaned and organized fragmented Care Coordination documentation into digestible episodic enrollment spans.• Automated Care Coordination participation compliance reporting for Medicare Comprehensive Primary Care Plus (CPC+) reporting.• Developed an identity-matching algorithm to align at-risk Medicare Advantage membership with the electronic medical record.• Created a low-value services dashboard for physicians to track their progress against their peers in low-value utilization.• Developed a process to reconcile paper hospitalist billing with actual receipts – recovering 30% of anticipated revenue.• Developed a SQL-based automated exception interface between electronic medical record and accounting system for retroactive vaccine administration documentation driving inventory management

Columbus, Oh, Us

• Developed a Java 2 Enterprise Edition (J2EE) web-based laboratory information management system (LIMS) in an Agile environment for the clinical genomics lab at the Nationwide Children’s Institute for Genomic Medicine.• Selected and implemented a network of 40 label printers using Bartender Enterprise Automation Suite and integrated printers with the web-based LIMS.• Developed a multidirectional HL7 interface with the Nationwide Children’s EMR and lab billing system for lab orders, patients, and physicians.• Eliminated the need for high risk record-keeping procedures in Excel and Access

Columbus, Oh, Us

Developed and managed back-end data architecture for clinical staff workflow tracking Qlikview dashboard and performance management SSRS dashboard.Created two separate data mining algorithms to target potential candidates for care coordination enrollment, resulting in a 2,000 patient, 625% increase in enrollment in 24 months.Developed a propensity-matched comparison model using logistic regression to evaluate utilization impact of care coordinated patients.Developed an identity-matching algorithm to accurately match 370,000 unique Medicaid managed care members to their corresponding NCH medical record on a daily basis.Developed new reporting process for care management program state compliance reporting, accommodating regulatory changes.Created staff performance audit reports, which help reduce EMR documentation error rate from 15% to 1-2%.Developed, implemented and taught front-end Qlikview training module for new clinical staff.Supported all departmental ad hoc reporting needs

Dublin, Ohio, Us

• Transformed raw medical/pharmacy cost, member engagement, and utilization data into actionable, timely and digestible decision support information for client health plans through quarterly and ongoing ad-hoc reporting.• Owned the development and maintenance of all financial performance reporting for client health plans.• Provided business intelligence support and development for pricing and underwriting of new and renewal contracts.• Nurtured a positive, responsive relationship with all account executives by consistently delivering a quality product in a timely manner. Widely recognized by these internal customers as a top performer in the Business Intelligence group.

New Albany, Ohio, Us

Project-managed a team of IT, operations, and marketing associates to configure, test, and deploy point-of-sale (POS) coupons through the busiest discount period in the company’s 60-year history. Worked with senior financial analysis team to analyze sales trends and menu mix at new restaurants and newly-remodeled restaurants, identify areas for sales improvement, and present actionable results to executive team members.Managed $1.2 million local store marketing campaign for over 280 remodeled restaurants.Planned a budget of over $2.5 million in marketing expenditures in collaboration with Field Marketing Director.

New Albany, Ohio, Us

New Albany, Ohio, Us

Columbus, Ohio, Us

Master Of Science (M.S.), Data Science & Analytics

Bachelor Of Science, Business Administration