Welcome to my data portfolio! This guide will serve as an overview of my current data projects. For a deeper dive into any project, click on the project link to be taken to the project repo.
| Project Link | Tools | Area of Expertise | Project Description |
|---|---|---|---|
| Clinical Trial Feasibility Analysis | Python, Jupyter Notebook, SQL, PostgreSQL, pgAdmin4, Power BI | Data Cleaning, Data Validation, Multi-table JOINS, CTE, Cohort Segmentation Logic, Data Visualization | Python (pandas) is used to load, clean, and validate synthetic EHR data (Synthea) in a Jupyter Notebook prior to loading into a postgreSQL database managed via pgAdmin4. SQL queries then build the patient cohort and apply inclusion/exclusion criteria from a real prostate cancer trial protocol to assess recruitment feasibility. A Power BI dashboard then visualizes cohort attrition and screen-fail rates by criterion. |
| Project Link | Tools | Area of Expertise | Project Description |
|---|---|---|---|
| Clinical Research Workload Manager | Excel, VBA Macros | Process Automation, Dashboard Design, Operations Analytics | Built in Excel with VBA macros to automate data flow across three linked components: • A standardized intake form for capturing new trial criteria. • A configurable multiplier table that calculates a trial complexity score from key trial elements. • Per-coordinator dashboards that combine patient counts with complexity scores into a real-time composite workload metric. |
More projects will be added here as they're completed. Feel free to explore each repository for full technical details, business context, and results.