Gary Wong
******@*****.*** 619-***-**** *** Saybrook, Irvine, CA 92620 linkedin.com/in/usaadw
SUMMARY
Results-driven Data Analyst with 5+ years of experience in data analysis and programming, leveraging SAS, SQL, Excel and Power BI to transform complex datasets into actionable insights. Skilled in data cleaning, statistical modeling, and visualization, with a strong background in regulatory-compliant data reporting (CDISC, FDA). Proven ability to automate data cleaning, design interactive dashboards and visualization reports, and collaborate with cross-functional teams to drive data-driven decisions.
TECHNICAL SKILLS
Programming: SQL, SAS, Python, C#
Data Visualization: Power BI, Tableau, Python, SSRS, SAS/SQL reports, Excel
Data Wrangling: SQL, SAS, Excel, ETL (SSIS)
Data Modeling: SQL Server, Power Query
Analytics: Statistical modeling, hypothesis testing, regression, predictive analytics
Tools: MS SQL Server, SAS, SQL, Power BI, Tableau, Python, Excel, JIRA
Regulatory Standards: CDISC, GCP, FDA submissions
PROFESSIONAL EXPERIENCE
Ora Inc. Clinical Data Analyst/Programmer Feb 2024 – Mar 2025
Data Analysis & Reporting: Developed SAS/SQL scripts to generate data discrepancy reports and listing reports for studies, improving data analysis efficiency by 30%.
Automation & Quality Control: Programmed edit checks and validation rules, reducing data discrepancies by 60%.
Data Wrangling: Developed and optimized SAS/SQL/Excel scripts to clean and validate raw data into analysis-ready datasets.
Data Management Applications Optimization: Customized software and reports in data management software, enhancing stakeholders’ requirement compliance and data accuracy.
Cross-functional Collaboration: Partnered with biostatisticians and data managers to ensure datasets met FDA standards for regulatory submissions.
Statistics & Data Corporation (SDC) Clinical Data Programmer/Analyst Jun 2022 – Feb 2024
Interactive Dashboards: Built Power BI/Python dashboards to visualize patient safety data (AEs, labs, demographics), enabling faster decision-making.
Data Reconciliation: Generated SAS/SQL/Excel reports to identify discrepancies, streamlining data cleaning efforts.
Process Improvement: Enhanced iMednet eCRFs, reducing manual review time by 20%.
Hologic Clinical Data Programmer/Analyst Mar 2021 – Mar 2022
Data Validation: Automated SAS/SQL/Excel scripts to verify datasets, ensuring compliance with FDA standards.
Real-time Analytics: Developed trial progress reports, improving monitoring efficiency.
EDC Development: Led UAT for IBM Clinical Development, ensuring system reliability.
ClinChoice Statistical Programmer/Analyst Jul 2018 - Aug 2020
Data Analysis & Regulatory Compliance
Standardized and annotated clinical trial data (aCRFs) to align with CDISC and regulatory requirements, ensuring audit-ready datasets for FDA submissions.
Developed and validated statistical models with SAS procedures to analyze clinical trial data.
Data Pipeline Development & Visualization
Designed and validated ETL processes using SAS/SQL to transform raw clinical data into analysis-ready datasets (SDTM/ADaM), improving data integrity by 25%.
Generation of Tables, Listings, and Figures (TLFs) for Clinical Study Reports (CSRs).
Statistical Modeling & Insights
Conducted exploratory data analysis (EDA) and regression modeling to identify trends in patient outcomes, adverse events, and treatment efficacy.
Developed interactive dashboards (SAS ODS/Power BI) to visualize trial progress and safety data for cross-functional teams.
Quality Control & Process Improvement
Implemented data validation checks to flag discrepancies, reducing query resolution time by 20%.
Collaborated with biostatisticians to optimize data structures for efficient analysis.
EDUCATION
MS in Computer Software Engineering National University
BS in Computer Science San Diego State University
BS in Business Administration (Finance) San Diego State University