Yunzhu (Helen) Pan Email & Phone Number

Charlotte, North Carolina, United States

Charlotte, North Carolina, United States

• Interpreted and analyzed data from multiple sources including medical claims, provider, members and encounters data• Developed, executed, and troubleshoot complex scripts and reports using SQL, SAS and Microsoft Excel• Perform root-cause analysis of data irregularities, present findings, and proposed solutions to leadership • Manage multiple tasks with limited supervision within targeted timelines and support execution of large-scale projects with limited direction from… Show more • Interpreted and analyzed data from multiple sources including medical claims, provider, members and encounters data• Developed, executed, and troubleshoot complex scripts and reports using SQL, SAS and Microsoft Excel• Perform root-cause analysis of data irregularities, present findings, and proposed solutions to leadership • Manage multiple tasks with limited supervision within targeted timelines and support execution of large-scale projects with limited direction from leadership• Utilized data governance tools such as Alation to improve work efficiency Show less

Remote

• Worked on a consultation basis to create and modify pivot tables as per client needs using worksheet resources.• Built charts and graphs to assist company strategic planning. • Manage spreadsheets and maintain data currency to ensure accurate data availability for managers.• Utilized Collaboratory to run Python scripts which generated time sheet report for clients and write into Excel.

Ann Arbor, Usa

● Designed and created the website for the Mobilizing Computable Biomedical Knowledge (MCBK) community.● Prepared all data reporting work for clinical research using formulas and tables in Excel.● In charge of all video and social media promotion via YouTube and Twitter and optimized posts and videos based on channel performance metrics and trending discussion topics.● Organized and facilitated transition from annual in-person meeting to high-quality international virtual meeting… Show more ● Designed and created the website for the Mobilizing Computable Biomedical Knowledge (MCBK) community.● Prepared all data reporting work for clinical research using formulas and tables in Excel.● In charge of all video and social media promotion via YouTube and Twitter and optimized posts and videos based on channel performance metrics and trending discussion topics.● Organized and facilitated transition from annual in-person meeting to high-quality international virtual meeting for over 200 participants under the impact of COVID-19. ● Provided administrative support to all four work groups and standardized information sharing platform for internal projects across groups by using MS Excel, Word, Google drive and Box. Show less

Ann Arbor, Michigan, United States

• Conducted twelve interviews and identified real-time communication needs of the members by using contextual inquiry methods and generated survey questions by using Qualtrics. • Established real-time communication channel through Slack and created launch framework for users. • Executed internal communication channel soft-launch and performed PDCA procedure. • Designed poster for 2020 Michigan Medicine Quality week using PowerPoint.

Shenzhen, Guangdong, China

● Analyzed and reported on digital medical records data for the hospital’s 2019 drafting statistic report.● Screened problematic medical records and modified records in multiple EMR systems.● Learned ICD-10 code and ICD-9-CM operation code during weekly training session.

Bloomington, Indiana Area

● Create a share button on an iOS app that was designed for new parents.● Performed literature searches in health IT fields for improving information sharing effectiveness.● Present professional development opportunities to approximately 10 students weekly.● Advised students on professional development skills such as networking, interviewing and training.

Bloomington, Indiana Area

● Conducted adolescent patient rights education workshops to improve patients’ self-awareness.● Interviewed discharged patients and generated care quality improvement reports.● Shadowed different healthcare providers and administrators to learn how to run a hospital.

Shenzhen, Guangdong, China

● Screened and selected unclear, substandard, and problematic medical informed consents, and worked with the medical records department to improve the hospital’s informed consent process.● Collected confidential incident reports from 2007 to 2016 and organized data reports for senior management forum.

Master'S Degree, Health Informatics

Bachelor Of Science - Bs, Healthcare Management And Policy