Andrew Aultman Email & Phone Number

Denver, Co, Us

- Supervise team of report developers, ensuring timely delivery of high-quality, accurate reporting on patient engagement, appointment scheduling and completion, and clinical teammate productivity for HCC (Hierarchical Condition Category) documentation and billing.- Work one-on-one with direct reports and other teammates to improve their SQL and Tableau skills. Facilitate weekly SQL and Tableau workshops with business intelligence teammates to enhance technical abilities and standardize processes.- Collaborate closely with administrative and clinical stakeholders to create a comprehensive reporting portfolio supporting improved patient health outcomes and appropriate business revenue through HCC documentation and follow-up care for chronic health conditions.

Denver, Co, Us

- Managed end-to-end report development cycle, beginning with stakeholder engagement to understand business needs, researching UI processes and related backend data, using SQL to create custom database views, building reports in Tableau, coordinating UAT, and supporting user education pre- and post-launch.- Developed full spectrum of Tableau reports, from daily clinical workflow tools to C-level performance management summaries, to launch new electronic medical records software across 1000+ clinical team members caring for 50,000+ patients.- Implemented standardization practices, including data normalization, consistent naming convention for database views, and a Tableau style guide, to improve data integrity and overall quality of life for teammates.- Hosted weekly office hours calls with clinical team members to answer questions about Tableau reports, provide guidance on how to use reports to help structure daily and weekly workload, and troubleshoot issues.

Golden, Co, Us

- Extracted and analyzed complex data from multiple databases using advanced SQL skills, presenting information to nontechnical audiences with reports and data visualizations in Excel and Tableau.- Principal business analyst for in-house customer relationship management and workflow management software employing a hybrid Kanban/Scrum development cycle.- Managed business transformation projects utilizing Lean methodology, including integrating online services team into general workload and transitioning long-term care team from individual caseloads to a process workflow model.

Golden, Co, Us

- Completed customer interviews and data entry to determine initial and ongoing eligibility for public assistance programs, including Medicaid and SNAP (food assistance).- Created interview scheduling and tracking tool in Excel to help teams manage capacity and streamline business processes.- Researched fraudulent public assistance eligibility and represented Jefferson County at administrative hearings. Documented hearing policies and developed templates to standardize hearing process.

Master Of Public Administration - Mpa

Bachelor Of Arts - Ba, International Studies