Samuel Okwo

Healthcare Data Analyst with 6+ years of experience translating complex clinical, insurance, and pharmacy datasets into actionable business intelligence. Proficient in SQL (T-SQL), Power BI, Python, and AWS QuickSight, with a track record of improving operational efficiency, reducing costs, and accelerating decision-making across hospital, pharmacy, and health insurance environments. Combines a Master's in Health Administration/Data Analytics with a military-honed discipline for data accuracy and cross-functional collaboration to deliver insights that directly support organizational and patient outcomes.

Data Analyst II, Data Enablement Operations - SelectQuote Insurance - Overland Park, KS

(2024-01)

• Optimized T-SQL queries, stored procedures, and Power BI dashboards to improve database performance and enable real-time operational and server performance monitoring
• Automated monthly agent performance reporting using Power BI and DAX, cutting manual processing time by 40% and improving data accuracy
• Delivered ad-hoc SQL analyses that informed strategic decisions, contributing to a 15% increase in customer retention
• Managed project timelines and leadership reporting through Power BI dashboards, increasing on-time delivery by 20% and improving cross-team visibility
• Leveraged Python (Pandas, NumPy) to build and automate data preprocessing pipelines for advanced analytics initiatives, strengthening the team's predictive analytics capabilities

Data and Reporting Analyst, SelectRx Pharmacy - SelectQuote Insurance

(2022-06 - 2024-01)

• Built and maintained ETL pipelines extracting, transforming, and validating data from multiple sources to power operational dashboards for prescription fulfillment, labor cost, and member retention reporting
• Developed an AWS QuickSight dashboard tracking prescription fulfillment turnaround and labor costs, giving operational leaders real-time visibility
• Partnered with finance and operations on cohort analysis of patient drug spend, identifying a 12% cost reduction through optimized vendor and fulfillment strategies
• Collaborated with pharmacists, informaticians, and clinical technicians to design data-driven solutions that improved the point-of-care experience for 7,000+ patients
• Analyzed cost, utilization, and fulfillment data to build self-service KPI scorecards, enabling internal and external stakeholders to independently track pharmacy performance metrics

Healthcare Data Analyst - CoxHealth - Springfield, MO

(2020-08 - 2022-05)

• Analyzed insurance claims data for 10,000+ patients using ICD-10 and CPT coding standards, identifying billing inefficiencies and reducing administrative overhead by 30%
• Designed and implemented a patient flow tracking system with health informatics teams, reducing average ED wait times by 50%
• Built Power BI dashboards for predictive patient health trend analysis, improving forecasting accuracy by 40% and supporting data-driven clinical decisions
• Delivered self-service Power BI dashboards for non-technical stakeholders, improving patient satisfaction scores by 10%
• Benchmarked hospital performance and quality metrics against industry standards, collaborating with physicians and nursing leadership to identify and prioritize performance improvement initiatives
• Maintained COVID-19 hospital utilization reporting during peak pandemic periods, enabling leadership to optimize staffing and facility resources
• Extracted and analyzed patient data from Cerner EHR in compliance with HIPAA regulations, ensuring data integrity and privacy across clinical reporting workflows

Graduate Research Assistant - Missouri State University - Springfield, MO

(2021-08 - 2023-05)

• Conducted statistical analysis of healthcare delivery and health administration datasets to identify trends supporting faculty research
• Led technical training sessions for graduate students on SQL query optimization and Power BI dashboard development
• Cleaned and structured large academic datasets using Python (NumPy, Pandas), transforming raw research data into formats suitable for advanced statistical analysis
• Developed automated reporting templates with cross-functional research teams, reducing manual data entry for longitudinal healthcare studies

Product Analyst - Clina Lancet Laboratories - Lagos, Nigeria

(2018-06 - 2020-07)

• Built and optimized SQL/Excel reporting infrastructure to deliver real-time KPI visibility for product and operations teams
• Analyzed behavioral data from 25,000+ monthly active users, driving targeted engagement initiatives that doubled application engagement and cut drop-off rates by 22%
• Identified shifts in population and spending patterns through financial and behavioral analysis, informing a strategy that expanded the customer base by 10% within one year
• Partnered with senior managers to design customized reporting workflows, improving cross-departmental operational efficiency

Master of Science - Data Analytics / Health Administration - Missouri State University (2021-08 - 2023-05)

Bachelor of Science - Medical Technology / Analytics - University of Lagos (2014-06 - 2018-05)