Unmet Mental Health
Quantifying unmet healthcare needs across federal demographics to drive legislative resource allocation. Performed rigorous Chi-Square statistical analysis on SAMHSA dataset parameters.
CLEAN CLAIM RATE95.2%
FIRST PASS DENIAL RATE4.8%
NET COLLECTION RATE97.2%
NET DAYS IN A/R31.4
A/R > 90 DAYS16.5%
POS COLLECTIONS28.6%
PATIENT RESPONSIBILITY COLLECTED AT VISIT39.0%
CHARGE POSTING LAG7.8 DAYS
DENIAL WRITE-OFF RATE1.3%
COST TO COLLECT3.1%
CLEAN CLAIM RATE95.2%
FIRST PASS DENIAL RATE4.8%
NET COLLECTION RATE97.2%
Senior Data Analyst Healthcare Expertise
Behavioral Analyst & Data Storyteller
Darren Littlejohn Revenue Cycle Management
Graduate-level training in research methods and statistical analysis (Psychology; Cognitive/Behavioral emphasis). Skilled in SQL, Python, R, ETL workflows, visualization, and translating complex analyses into clear, actionable narratives for senior leadership and non-technical stakeholders.
Background includes evidence-based public-health research, analysis of SAMHSA/CDC/federal health datasets, and producing rigorously sourced, decision-focused insights.
Thought Leadership
The Zen of Data Analysis
Professional Focus
Healthcare Data Analyst
Revenue Cycle Management, data quality, and analytics storytelling.
Hiring Evidence
End-to-End Case Study Architecture & SQL Implementation
- Engineered three full healthcare case studies from extraction through delivery.
- Applied advanced SQL patterns including joins, CTEs, and window logic.
- Documented method and findings with transparent, auditable analytical flow.
Federal & Public Health Data Translation
- Processed federal/public-health datasets into clean analytical structures.
- Converted raw data into decision-ready narratives for non-technical stakeholders.
- Highlighted actionable insights for resource allocation and care delivery focus.
Business-Aligned Project Delivery
- Connected problem, method, and business relevance in each portfolio page.
- Structured deliverables for fast technical + managerial review.
- Focused each project on practical decision impact, not just technical output.
Dutch Retail Sales
Reverse-engineering legacy sales metrics into a real-time reactive infrastructure for immediate business insight.
Fentanyl Morbidity
Critical heat-mapping of prescription trends to identify high-risk regional clusters of systemic fentanyl distribution.
Evidence
Proof of Execution
1
Healthcare EconomicsUnmet Mental Health Approaching SAMHSA datasets from unexpected vectors to prove the impact of healthcare access on employment.
2
Enterprise IntelligenceDutch Retail Sales Reverse-engineering legacy sales metrics into a reactive decision system.
3
Geospatial ForensicsFentanyl Morbidity Extracting hidden high-risk clusters from federal prescription data.
4
Thought LeadershipThe Zen of Data Analysis explores analytics, communication, and visual storytelling through portfolio-linked articles and graphics.
Portfolio Evidence
What These Projects Prove
Unmet Mental Health
Frames a healthcare question, builds the SQL pipeline, applies statistical testing, and explains why the result matters.
Fentanyl Morbidity
Takes complex public-health data and turns it into interpretable visual evidence for risk-focused decision making.
Dutch Retail Sales
Shows dashboard thinking, metric design, and how raw reporting becomes something a manager can actually use.
Across All Three
Demonstrates question design, data preparation, analysis, visualization, and stakeholder-facing communication.
Contact
Contact Darren Littlejohn
Email Darren directly at darren@darrenlittlejohn.com to discuss the portfolio and interview opportunities.