Jon Moran

Data Analyst

Philadelphia, PA

Healthcare professional

Penn Medicine - Philadelphia, PA

University of Pennsylvania Health System - Emergency Medicine - Philadelphia, PA

Developed and maintained operational reports across a variety of systems including Microsoft SQL studio, SSRS, PowerBI, Databricks and Epic in addition to other tools such as Azure DevOps, Microsoft Visual Studio and third party data sources
Produced reporting for four hospital Emergency Departments including: monthly physician performance reports, annual physician incentive payment reports, and annual operational benchmarking submissions
Automated repetitive reporting and admin tasks leveraging VBA, Python, and MS PowerAutomate, reducing administrative burden on staff
Created operational dashboards in PowerBI to project patient volume, inform future business strategy, and promote patient compliance with treatment

Philadelphia Department of Public Health - Philadelphia, PA

Deployed in program responses to Covid-19, Operation Allies Welcome, and MPox as a member of the Bioterrorism and Public Health Preparedness Program
Served as Clinic Manager for approximately 150 clinics hosted throughout the city, managing a staff of 10-30 through Covid-19, Mpox, and Flu vaccination campaigns
Led the design, project management, and compliance of the Community Engagement for Public Health, a program which distributed $3M dollars in federal funds to Community-Based Organizations doing work on behalf of the Philadelphia Department of Public Health
Created and maintained reporting metrics and process for an $8M CDC funded Covid Disparities grant, collaborating with a variety of internal stakeholders to accurately report a wide range of activities to the CDC's specification
Implemented MS Office based automation to improve operations, including an appointment confirmation system and clinic inventory tool, created and delivered staff trainings on MS office automation

Philadelphia Department of Public Health - Philadelphia, PA

Revint - Chaddsford, Pennsylvania

Cloudmed - Chadds Ford, PA

Supervised client engagement, overseeing budget forecasts, interfacing with clients, creating invoices and monthly reports, and managing a staff of 2-3 in recovering underpaid hospital claims
Built hospital claim pricing models for client engagements, managing data validation, transformation, and auditing for quarterly data extracts from client EHR and claims management systems
Navigated a variety of client systems to research and pursue underpaid claims, including Epic, Cerner, and Meditech systems, working with Provider Relations representatives to resolve large scale issues

The Pennsylvania State University - Bachelor’s of Science in Biobehavioral Health

The Pennsylvania State University - B.S. in Biobehavioral Health

Epic - Certification in Cogito Reporting