Tyler Lantz Email & Phone Number

Analytics lead for UI Physicians. Work includes Tableau, SQL, and SSIS. Subject matter expertise in health care clinical operations, human resources, supply chain analytics, and general ledger transactions.• Pioneered development of a consolidated data mart of aggregated measurements from multiple business domains, eliminating redundant departmental data munging and enforcing governance of business rules.• Engineered SSIS data pipelines to extract, load, and transform human resources data from multiple ERP systems, enabling the use of conformed dimensions and facts across many analytics projects including workforce planning, employee retention analyses, and the access control lists.• Architected COVID-19 analytic and visualization tools used for informing state and local government agencies and enabling internal leadership to plan and prepare, manage surges, and operate effectively.• Led development of University of Iowa Physicians KPI Tableau reporting suite, ensuring effective and insightful communication of revenue, productivity benchmarks, and patient satisfaction metrics to department executives, administrators, and health care providers. • Consulted on interoperability of commercial-off-the-shelf provider scheduling application to support productivity and compensation reporting application.• Directed professional development of talent capable of providing analytics and consulting services.• Engaged stakeholders to ensure functional and non-functional requirements are clearly identified.

• Architected inpatient throughput analytics and forecast models to support executive leadership initiatives, influencing the development of a surge capacity plan and patient transfer prioritization policies.• Created live data stream of healthcare supply chain catalog to improve accessibility and timeliness of reporting on personal protective equipment during the Covid-19 surge.• Performed root cause analysis to discover and fix design defects in electronic health record application.• Developed patient regionalization model to assist in assigning patients to geographically localized resources, improving physician efficiency and care coordination.• Architected and maintained Iowa Hospital Association warehouse for the Office of Strategic Growth.• Advised leadership on Vizient benchmarking data traceability to ensure executive initiatives will deliver benchmarking results and improve patient care.• Standardized Tableau reporting templates and data flow naming conventions.

• Led design and implementation of laundry services billing software.• Automated budget reporting process to improve consistency and accuracy of reporting items across seven departments with a combined $21MM in annual activity.• Optimized data collection and processing methods resulting in reduction in labor, reduction in source-to-database error rates, and improved data accessibility.

Master'S Of Accountancy, Finance / Audit

Bachelor Of Business Administration (Bba), Accounting And Finance