Michael Tsai Email & Phone Number

Atlanta, Georgia, United States

Greater Atlanta Area

• Lead teams in the acquisition, validation, and warehousing of encounter, fee-for-service, eligibility, and other supplemental data from all forms of submitters such as Medicaid Management Information Systems, state agencies and health plans. Develop encounter data submission and error trending reports and provide ongoing feedback to Medicaid managed care organizations and clients on process improvement opportunities for increased data quality.• Lead and maintain the informatics risk-adjusted rates process using the Johns Hopkins Adjusted Clinical Group (ACG) System, including evaluating periodic updates to the risk adjustment model and recalibrating client specific cost weights as emerging data is received.• Provide data science expertise to in-house partners through technical review of project deliverables, identifying data anomalies and exceptions. Transition existing Structured Query Language (SQL) projects to the Statistical Analysis System (SAS) environment. Create data visualizations addressing client needs within the Qlik Sense platform.• Mentor junior analysts and associates via role as People Manager. Provide guidance and performance feedback via monthly career pathing discussions.

Greater Chicago Area

• Created operational reports for C-Suite level decision making related to staffing and clinician productivity. Compiled queries to access Cerner Millennium or localized enterprise data warehouse using Cerner Command Language (CCL) or SQL and output results to user preferred format such as Excel, SQL Server Reporting Services (SSRS), or Tableau.• Developed reporting solutions for 12 clinical divisions within the Department of Medicine to evaluate quality of care and physician performance. Worked with division chairs to create reporting metrics for Ongoing Professional Practice Evaluation (OPPE), optimization of inpatient throughput, and timely documentation of billable procedures. Created automated reports to distribute information via SAP Business Objects.• Packaged system-wide data for export and use in third party performance evaluation solutions. Created monthly uploads of linked clinical data from Cerner Millennium and financial data within Siemens Healthcare for use in Vizient Clinical Data Base and Advisory Board. Worked with outside parties to troubleshoot data quality issues and educate local end users on availability and use of reporting tools.• Worked with Cerner in-house consultants to transition financial reporting system from Siemens Invision to Cerner Patient Accounting and create ad-hoc or modify existing Cerner Revenue Cycle reports using Discern Analytics 2.0.

Las Vegas, Nevada Area

• Served as project evaluator for over $7 million in grant funding awarded through Communities Putting Prevention to Work (CPPW), Community Transformation Grant (CTG), and Partnerships to Improve Community Health (PICH) grants from Centers for Disease Control and Prevention (CDC). Developed evaluation plans consisting of process and outcome performance measures, protocols for qualitative and quantitative evaluation to assess timely implementation and success of program interventions and objectives.• Provided informatics and analytics expertise for the Terrorism Injuries Information, Dissemination and Exchange (TIIDE) project. Developed data system to measure real-time medical surge capacity of local hospital system through probabilistic record linkage between Computer Aided Dispatch data, electronic patient care reporting information, and state trauma registry data to assist in deliver of care in the case of a mass casualty event.• Analyzed and interpreted outcome-specific data from multiple large-scale chronic disease data systems for use in planning, implementing, and evaluating public health practice using SAS to identify trends and areas of greatest need. Selected indicators for local chronic disease surveillance system and created reports to drive evidence-based decision making for public health funding, focusing on disparate populations and social determinants of health for 2.1 million residents of Clark County, Nevada.

Greater Atlanta Area

• Participated in the implementation and management of the Paul Coverdell National Acute Stroke Registry grantees in 4 states. Developed registry data elements and created performance measures to evaluate hospital performance of in-patient care against recommended best practices. Managed patient data between 190 hospitals and CDC. Participated in evaluation of grantee completion of program deliverables.• Analyzed CDC datasets to identify long-term trends in stroke and coronary heart disease mortality. Focused on modifiable risk factors for cardiovascular disease such as behaviors, health status, and policies. Prepared research for distribution to the public in the form of submissions to the Morbidity and Mortality Weekly Report.

Master Of Public Health - Mph, Epidemiology

Bachelor Of Science (Bs)