Post Job Free
Sign in

Data Analyst Power Bi

Location:
Irvine, CA
Posted:
June 17, 2025

Contact this candidate

Resume:

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



Contact this candidate