Dylan Henderson Email & Phone Number

Greater Phoenix Area

• Manages economic initiatives for multiple Medicaid and Duals markets to ensure plans meet financial targets.
• Uses SQL, ThoughtSpot and PowerBI, to gather data from company databases, synthesizes relevant information in Excel through advanced functions including Pivot Tables, V-Lookup, and IF statements.
• Compiles findings into concise monthly presentations for plan leadership, driving over $10 million in annual savings for the health plans.
• Catalogs savings initiatives and performs validation of findings with SQL and Excel to ensure savings are being captured accurately.
• Mentors and helps assist new team members with presentation design, SQL query construction, and any other ad-hoc question related to the position.

Tempe, Arizona, United States

• Used Python and YAML coding to input over 100 contract details into Oscar's internal system for correct payment on over $1 million in contracted payments to healthcare partners.
• Mentored new team members, assisting them in fine-tuning their coding skills.
• Used SQL to identify the scope of over 50 separate post-payment issues and work with relevant stakeholders to resolve and communicate the solution to external partners.
• Triaged and assigned incoming requests from other teams to help ensure turn around time goals were met.
• Drove process improvements via dashboard creation and improved SQL queries to boost efficiency within the team.

Phoenix, Arizona Area

• Synthesized historical data via internal big data platforms to identify trends and assist with executive level decision making, leading to a 10% increase in rental volume.
• Analyzed current market factors to implement an effective rate strategy across multiple revenue channels leading to a 5% increase in total revenue.
• Created training programs in Microsoft PowerPoint to increase job related knowledge for both field and headquarters staff.

Atlanta, Georgia

• Presented strategic opportunities to clients by analyzing current payment arrangements, leading to savings of over $5 million.
• Assisted in managing RFP and direct negotiation processes in order to reduce overall cost of payment acceptance for Fortune 500 and other large institutional clients.
• Analyzed payment data via Excel queries to find areas of inefficiency and process errors, leading directly to over $1 million in cost savings for top clients.

Norcross, GA

• Used Microsoft Excel, SAP software, and internal programs to perform analysis of aged accounts receivable inventory and determine root cause of incorrect payments.
• Identified and escalated over $1 million in incorrect payments through trends in data and contract review.
• Assembled spreadsheets reporting data trends to corporate office for guidance in corporate collection strategy.

Norcross, GA

• Used Microsoft Excel, SAP software, and internal programs to perform trended analysis of underpaid accounts and determine root cause of incorrect payments.
• Performed collection calls to help gather information on, and resolve, underpayments.
• Led project to remove coding errors, allowing for the reallocation of multiple man hours.

Atlanta, GA

• Worked with principal investigators to coordinate qualitativeresearch into opportunities to enhance the college's curriculum.
• Designed framework for multiple courses introduced into thecollege based on industry best practices.
• Assisted in research support of data processing operations forlarge survey research projects.

Bachelor’S Degree, Majors: Managerial Sciences. Minor: Psychology, 4.00

Activities and Societies: National Society of Collegiate Scholars. Honors College Ambassador.

High School Diploma