Kylie Pan Email & Phone Number

Chicago, Illinois, United States

• Manage one of the three key data processing workflows for a continuous longitudinal survey responsible for analyzing Medicare and informing fiscal projections• Oversee the day-to-day operations of 5+ mid-level and junior staff members, maintaining competing schedules and ensuring deadlines are met• Act as subject matter expert and point of contact for cross-functional activities• Collaborate with project stakeholders to identify analytic needs, design research questions, and perform analyses to inform data-driven operational decisions and evaluate data quality• Craft and develop dashboards using SAS Visual Analytics for senior leadership members to receive real-time insights on key data collection indicators to manage the progress of project objectives• Supervise automation and process modernization efforts, prioritizing code standardization and refinement to reduce execution time and improve data processing efficiency by over 50%• Led the design, development, and production of three rapid-turnaround client-facing data briefs on COVID-19 vaccination in the Medicare population

Chicago, Illinois, United States

• Spearheaded and executed framework for new data review workflow, reducing time spent in post-processing and accelerating delivery times by over 25%• Led process of translating complex questionnaire specifications into quality control checks and performed iterative data review and issue resolution to assess survey instrument adherence to specifications• Built robust data quality monitoring tools using automated SAS-generated reports to visualize data in tables, charts, and graphs in an easily comprehensible format• Supported analysis to determine impact of interview mode change from in-person to telephone due to the COVID-19 pandemic on data quality• Assisted with the construction, development, and generation of four quick-turnaround publicly released infographics and data briefs on topics including chronic pain and experiences during the COVID-19 pandemic among Medicare beneficiaries

Chicago, Illinois, United States

• Managed data processing workflow responsible for performing data review, data cleaning, and data issue investigation• Initiated process redesign efforts that resulted in significant improvements in processing effort and flexibility in data collection schedules and sample release approach

Ann Arbor, Michigan

• Department of Epidemiology, Arnold Monto, MD and Suzanne Ohmit, DrPH• Conducted research on influenza vaccine effectiveness in reducing medically-attended influenza and transmission in households with children through a CDC-funded prospective cohort study• Collaborated with Project Manager and Clinical Research Coordinators on cohort recruitment and follow-up • Interviewed participants of various ages during follow-up visits to collect data regarding illness onset, flu-associated symptoms, and perceived illness severity• Increased efficiency of follow-up visits by preparing paperwork and specimen collection material, and offered recommendations to improve study efficiency and data quality

Lansing, Michigan

• Addressed vaccination coverage rate denominator inflation issue through independent data analysis project using the Michigan Care Improvement Registry (MCIR)• Created and implemented SAS code to describe the effect of individuals with an unassigned county on statewide immunization coverage rates• Presented process, results, and recommendations for data quality improvement to division director, epidemiologists, and team members

Ann Arbor, Michigan

• Department of Geriatrics, R.J. Wessells, PhD• Performed research on the effects of endurance exercise on healthy lifespan with a fly model• Presented progress at weekly lab meetings with PI and lab members• Facilitated discussions in journal club meetings and brainstormed ways to utilize results and techniques described in papers to develop future projects• Trained four students in lab techniques over the course of a year in order to improve their ability to work independently and increase lab efficiency

Detroit, Michigan

• Coordinated with Market Manager to contact potential vendors, plan weekly market, and organize food demonstrations• Educated market visitors about the importance of fresh, local food and promoted use of informative programs to increase healthy food intake for low socioeconomic residents• Implemented advertising strategies around neighborhood to double the number of visitors from the prior year

Master Of Public Health (Mph), Epidemiology

Bachelor'S Degree, Neuroscience

Activities and Societies: Global Brigades, The Neuroscience Student Association, GlobeMed