CURRICULUM VITAE

[nom]

Data [nom]

Anita Zucker Center for Excellence in Early Childhood Studies

University of Florida

PO Box 117050

Gainesville, FL [téléphone]

[e-mail]

EDUCATION

Graduate

2012 · Electrical and Computer Engineering · M.S.

University of Florida, USA

2010 · Computer Networks and Information Security · M.S.

Northwestern Polytechnical University, PRC

Undergraduate

2007 · Information Security Technology · B.S.

Northwestern Polytechnical University, PRC

SKILLS

Databases: Microsoft SQL Server, BigQuery, Snowflake, PostgreSQL, MySQL

Data Management and Analysis: SAS, R, Python, Tableau Prep, SSIS, ArcGIS

Data Visualization: Advanced Tableau development and Tableau server administration

EXPERIENCE

Data [nom] · August 2024 – Present

Anita Zucker Center for Excellence in Early Childhood Studies · Gainesville, FL

University of Florida

Early Childhood Policy Research

• Built the data infrastructure collecting data from the Florida Agency for Health Care Administration (AHCA), Florida Department of Health (DOH), Florida Department of Education (DOE), Florida Department of Children and Families (DCF), US Department of Housing and Urban Development (HUD), Environmental Systems Research Institute (ESRI) and US Census on service recipients in the state of Florida.
• Developed a privacy-preserving record linkage algorithm to identify unique individuals and households for researchers to conduct policy and economic analysis. The algorithm links and

1 · Rev. 9/2024

integrates children's service records from disparate sources, providing a more comprehensive view of individuals’ and households’ health and economic status.

Data Management Analyst II · March 2015 – August 2024

Department of Health Outcomes and Biomedical Informatics · Gainesville, FL

University of Florida

Early Care and Education Needs Assessment

• Created the Early Care and Education Needs Assessment (ECENA) data dashboard for the Florida Office of Early Learning. This centralized data portal used 44 metrics to track Florida’s early childhood socio-demographic characteristics, health and safety risk factors, and educational attainment and help the stakeholders to identify both well-served and under- served areas at multiple geographic levels, including ZIP codes, counties, early learning coalitions, and statewide.

Florida Medicaid Maternal and Child Health Status Indicators

• Integrated Florida Medicaid claims and encounter data, vital statistic records, child welfare, and foster care records to provide descriptive statistics for 49 maternal and child Health Status Indicators (HSI) to policy and legislative decision-makers at the State and County levels.
• Conducted in-depth data analysis to extract meaningful insights from integrated datasets.

Developed custom reports and presentations to effectively communicate findings to policy and legislative stakeholders, enhancing data-driven decision-making.

• Designed and maintained the data dashboard for Florida AHCA and DOH-designated users to explore the multi-year HSI data trends.

The Child and Caregiver Outcomes Using Linked Data (CCOULD) project

• Integrated child welfare and Medicaid datasets in Florida to strengthen the infrastructure of state-level data to help the state link their child welfare and Medicaid data, determine the utility of a linked dataset, and provide state agencies and the research community with data to study the relationship between services and outcomes.
• Executed data linkage processes to uniquely identify children, caregivers, and child-caregiver dyads. Established a common data model to standardize and streamline data analysis across different datasets.

Family Planning Waiver Program Evaluation

• Administered database and conducted data quality assessment for the Florida AHCA Medicaid Family Planning Waiver (FPW) program evaluation project. Prepared analytical datasets by integrating Florida Medicaid claims and encounters data, birth certificates, and Healthy Start Screenings for the research team to evaluate the performance of the FPW program.

March of Dimes

• Designed the data dashboard to identify clusters of premature births in Florida using data from Florida DOH and Bureau of Vital Statistics for the March of Dimes.

2 · Rev. 9/2024

Family Data Center at the University of Florida

• Managed the data warehouse for the Family Data Center and provided ad-hoc support for OneFlorida data integration.
• Administrated Tableau Server for the Family Data Center – managing user groups, workbooks and projects, database views, and data sources, monitoring server activity and usage statistics, and upgrading server software.

Texas Medicaid Quality of Care Public Reporting

• Managed the front and back end of the Texas Healthcare Learning Collaborative (THLC) portal, including new functionality development, data pipeline updates, Tableau workbook development and maintenance, and user access control.
• Oversaw activities related to the Texas THLC portal, collaborating with stakeholders, contractors, and data team to disseminate quality of care measures to the public to encourage further discussion and increase transparency and accountability of services and care being provided under the Texas Medicaid system.

SQL Database Developer · September – November 2014

Department of Health Outcomes and Biomedical Informatics · Gainesville, FL

University of Florida

• Designed and implemented the database for data report in Microsoft SQL server and performed longitudinal calculations to derive indicators at the zip, county, Early Learning Coalition, and Statewide level.
• Exported and managed datasets from the Florida Community Health Assessment Resource Toolset (CHARTS), the US Census American Fact Finder, private data vendors, and state agencies.

SQL Database Developer · July – September 2014

Department of Health Services Research, Management and Policy · Gainesville, FL

University of Florida

• Imported Medicaid claims and Medicaid-eligible patient records into a Microsoft SQL server database, de-duplicated Medicaid claims data records, and calculated healthcare measures for the inpatient/outpatient visit.
• Developed algorithms to define patient comorbidities and assign weights for the Charlson comorbidity index. This calculation was used to evaluate the mortality risk of breast cancer patients.
• Provided data on-demand for statistical analysis and reporting.

SQL Database Developer · September 2012 – November 2014

Delcher Analytics · Gainesville, FL

• Optimized the National HIV/AIDS Case Surveillance System (HASS) in Haiti for statistical reporting, patient identification, and research dataset distribution.

3 · Rev. 9/2024

• Managed the Microsoft SQL server database and administrated the Windows Server for HASS.
• Implemented algorithms to identify the same patient across facilities and treatment networks.
• Ingested data from clinics and performed monthly data quality assessments.

4 · Rev. 9/2024