Available for New Opportunities

Hi, I'm John Lorenzo.
Data Analyst

I leverage code and visualization to uncover trends, solve complex problems, and drive data-driven decision making.

About Me

I am a Data Analyst based in Hamilton, OH, with a strong background in clinical data and dashboard development.

I hold a B.S. in Computer Science (Minor in Data Science) from Northern Kentucky University.

My experience at Medpace strengthened my ability to connect technical data insights with practical business needs. I’m passionate about building tools that turn raw data into meaningful solutions.

Email Me Hamilton, OH

Professional Experience

Clinical Data Analyst

Medpace • August 2022 – August 2024 • Cincinnati, OH

Designed and maintained Spotfire dashboards to monitor patient safety and site performance across multiple clinical trials.
Translated clinical trial protocols and CRFs into data visualization specifications.
Produced biweekly/monthly safety reports used by medical teams to guide trial decisions.
Automated ad hoc analyses using Python, including a lab cross-table tool for flagging abnormalities.

Featured Projects

A selection of work showcasing my experience in data analysis, visualization, and automation.

Lottery Scratch-Off Analyzer

Daily data pipeline tracking OH & KY lottery tickets. Analyzes prize pools, expected value, and optimal purchasing strategies in real-time.

R Shiny Python Web Scraping PHP API

View Project

Clinical Safety Dashboard

Interactive dashboard visualizing key patient safety metrics with drill-down capabilities for non-technical users.

Tableau Clinical Trial Data Data Viz

View Project

Technical Skills

A comprehensive toolkit for data analysis, visualization, and automation.

Programming

Python
R
SQL
SAS
Java

Visualization & BI

Spotfire
R Shiny
Tableau
Power BI

Tools & Tech

Git
MS Office Suite
VS Code
Jupyter

Core Competencies

Clinical Data Analysis
Dashboard Design
Automation
Data Cleaning

Interested in my full background?

I'm currently looking for new opportunities in data analysis and data science. Download my resume to see how my skills can benefit your team.

Download Resume Contact Me

Let's Connect

I'm actively interviewing and available for immediate start. Feel free to reach out!

[email protected]

Hamilton, OH

Hi, I'm John Lorenzo. Data Analyst