Post Job Free
Sign in

statistical programmer

Location:
El Cajon, CA
Salary:
100/hour
Posted:
November 16, 2026

Contact this candidate

Resume:

Haiping Guinn

****.**@*****.***

858-***-****

California

Professional Summary

Principal Statistical Programmer with 19+ years of experience supporting global Phase I–III clinical trials in the pharmaceutical and biotechnology industries across Oncology, Immunology, Cardiology, Virology, and Atopic Dermatitis.

Extensive experience delivering FDA NDA/BLA submission-ready statistical programming solutions, including CDISC SDTM/ADaM datasets, Tables, Listings, and Figures (TLFs), Define.xml, reviewer guides, and ISS/ISE. Strong expertise in SAS programming, clinical trial data analysis, and regulatory standards.

Hands-on technical leader with experience mentoring programmers, supporting vendor oversight, driving programming standards, and collaborating with cross-functional teams to deliver high-quality, compliant, and timely clinical trial deliverables.

CORE COMPETENCIES

Leadership: Project leadership, Cross-functional Collaboration, Programming Standards, Code Review, AI-assisted Programming, Process Improvement, Vendor Oversight, mentoring, resource planning, timeline management

Regulatory: NDA/BLA, CSR, ISS/ISE, Define.xml, ADRG, SDRG, Pinnacle 21, CDISC SDTM/ADaM

Programming: SAS Base, Macro, SQL, ODS, PROC REPORT, LIFETEST, PHREG, MIXED, GLIMMIX, FREQ, LOGISTIC, SGPLOT, SGRENDER, TEMPLATE.

Therapeutic Areas: Oncology, Immunology, Cardiology, Infectious Diseases

EDUCATION

Master of Science in Mathematics – Loyola University of Chicago May, 2006

Bachelor of Art in Computer Science – University of North Carolina at Charlotte May, 2003

PROFESSIONAL EXPERIENCE

02/2022 – 10/2026

Principal Statistical Programmer (FSP), Jazz Pharmaceuticals

Supported Medical Affairs by developing customized efficacy and safety analyses, post hoc analyses, publication-quality Tables, Listings, and Figures (TLFs), and statistical graphics for scientific presentations, manuscripts, publications, and other Medical Affairs deliverables. Identified and clarified efficacy and safety endpoint derivation rules, implemented them in SAS programs, and documented programming logic in Medical Affairs (MAV) request specifications.

Collaborated closely with statisticians to evaluate analysis requests, investigate real-world data scenarios, identify data quality issues that could affect statistical results, and develop appropriate programming solutions to ensure accurate, reliable, and scientifically meaningful outputs.

Served as the technical programming lead for complex Medical Affairs requests requiring end-to-end programming solutions. Led the technical design and implementation of table shells, ADaM specifications, analysis dataset derivations, and TLF development based on request specifications, while coordinating programming activities through final delivery.

Provided technical leadership throughout the programming lifecycle by performing independent quality control, mentoring junior programmers, resolving complex programming issues, and ensuring programming deliverables met quality standards, project timelines, and business requirements.

Support PMDA submission readiness as part of a five-member programming team, independently performing Pinnacle 21 (P21) engine-upgrade re-runs across assigned studies; compare validation reports, investigate new or changed findings, update SDRG/ADRG documentation as needed, and perform peer QC of other programmers’ findings and completion checklists.

11/2019 – 02/2022

Principal Statistical Programmer (FSP), Gilead Sciences

Supported multiple global virology studies, primarily focusing on transitioning studies from double-blind to open-label phases.

Developed and validated CDISC-compliant SDTM and ADaM datasets supporting efficacy, safety, and regulatory reporting. Utilized company validation tools to compare production and validation outputs (.out files), ensuring identical content, format, and statistical results.

Extensively customized and enhanced company-standard utility macros to improve programming efficiency, post-processing flexibility, and output consistency. Developed reusable study-specific macros to automate repetitive programming tasks, standardize processes, and improve code reusability across studies.

Provided programming support for multiple studies, including urgent and ad hoc analysis requests, ensuring accurate, high-quality, and timely delivery of statistical programming deliverables.

Provided technical leadership for study validation activities by reviewing validation tracking documents, monitoring issue resolution, and maintaining consistency between TLF numbering, titles, populations, footnotes, validation tracking sheets, table shells, and Table of Contents (TOC) documents as study specifications evolved.

Worked closely with statisticians through regular technical review meetings to clarify primary and secondary endpoint derivations, review ADaM specifications, resolve validation discrepancies, and verify programming logic against the SAP, table shells, and analysis specifications.

Performed detailed technical reviews of programming findings against the SAP and table shells, documented issues and proposed resolutions in the statistical comments log, tracked issue status through completion, identified programming changes affecting multiple outputs, and communicated updates promptly to ensure consistent implementation across study deliverables.

04/2018 – 10/2019

Senior Statistical Programmer (FSP), BeiGene Inc.

Supported multiple oncology clinical trials, including dry runs and key safety deliverables such as DMC, IDMC, DSUR, and other regulatory and clinical reporting activities.

Developed and validated CDISC-compliant safety and efficacy ADaM datasets for oncology studies. Reviewed and identified discrepancies between programming specifications, SAPs, and analysis requirements for primary and secondary efficacy endpoints, including OS, PFS, ORR, CR, PR, BOR, DoR, TTP, and TTR. Ensured accurate traceability from aCRF to SDTM, ADaM, and ultimately to TLF outputs. Performed comprehensive validation of dataset metadata, variable metadata, and value-level metadata, and conducted independent programming validation and peer reviews to ensure high-quality deliverables.

Applied, enhanced, and maintained company-standard utility macro libraries for population summaries, categorical and continuous statistical reporting, ODS RTF generation, and automated log validation. Developed reusable study-specific utility macros for AE/CM partial date imputation, ISO 8601 (DTC) conversion, visit-to-analysis visit mapping, and other programming utilities to standardize programming processes, improve code reusability, and increase programming efficiency.

04/2012 – 04/2018

Senior Statistical Programmer (Contractor), Amgen Inc.

Supported oncology clinical development programs for approximately six years, contributing to multiple studies from study start-up through regulatory submission.

Developed and independently validated CDISC-compliant SDTM and ADaM datasets, along with Tables, Listings, and Figures (TLFs), ensuring compliance with study specifications, Statistical Analysis Plans (SAPs), CDISC standards, and company programming guidelines.

Supported FDA regulatory submission activities by generating Define.xml using company metadata tools and utility macros; validated ADaM datasets and Define.xml using company validation tools and Pinnacle 21; investigated and resolved validation findings; reviewed SDRG and ADRG for consistency with submitted datasets; and ensured metadata accuracy, traceability, and compliance with CDISC SDTM/ADaM standards and FDA submission requirements.

Developed publication-quality statistical graphics using SAS, including Kaplan–Meier survival curves (OS, PFS, and RFS), forest plots with hazard ratios or response rates and 95% confidence intervals, waterfall plots (Best Overall Response), spider plots (longitudinal tumor response), swimmer plots (duration of response and treatment exposure), bar charts (ORR, DCR, and BOR), and customized ODS Graphics to support Clinical Study Reports (CSRs), regulatory submissions, and clinical presentations.

11/2008 – 04/2012

SAS Programming Consultant (Contractor), K&L Consulting Services, Inc., Fort Washington, PA

Served as the CRO Study Lead Programmer for multiple clinical studies, acting as the primary programming contact between the CRO and sponsor. Participated in weekly sponsor meetings to provide programming status updates, discuss study timelines, review data quality and vendor data transfer issues, resolve SAP and analysis-related questions, track statistical programming deliverables, and coordinate programming activities with Biostatistics, Data Management, Clinical Operations, and sponsor teams.

Developed and independently validated analysis datasets and statistical outputs for multiple clinical studies. Reviewed and contributed to Statistical Analysis Plans (SAPs), mock TLFs, programming specifications, and company programming standards.

Led the validation and testing of the Analysis Dataset System (ADS) and Oncology Clinical Data Analysis and Reporting (OCDAR) management systems. Developed GUI test scripts, executed system validation using standard test cases, and independently verified ADaM datasets and standard oncology table outputs through pilot studies and quality control programming.

Developed user manuals and training materials and delivered classroom and web-based training sessions for ADS and OCDAR systems. Provided hands-on guidance for generating ADaM datasets, tables, and listings using company-standard SAS macros and programming workflows.

05/2007 – 11/2008

SAS Programming Consultant (Contractor), ClinForce / GlaxoSmithKline Inc., King of Prussia, PA

Supported oncology clinical trial programming by developing and validating analysis datasets and statistical outputs for interim analyses, regulatory submissions, and ad hoc requests, ensuring accurate and timely delivery.

Supported ad hoc analyses by investigating unexpected analysis results, resolving programming and data issues, and ensuring statistical outputs accurately reflected the underlying clinical data.



Contact this candidate