Alikai Health

RoleData Analyst & Automation Engineer
PeriodMarch 2025 - September 2025
Tech Stack
PythonRSQLPower BI
01

Automation

Automated doctor intake, credentialing, and contract execution—cutting manual processing by 80–90% across 500+ providers.

/ ~1 WEEK → 1 DAY

Built end-to-end automation pipelines using the DocuSign and Zapier APIs to handle provider onboarding from intake form submission through credentialing verification to contract execution. What previously required a week of manual back-and-forth now completes in a single business day, scaling reliably across the full provider network.

02

Analytics

Churn & Anomaly Detection

Wrote SQL queries and DAX measures across 500+ doctor accounts to identify churn signals and billing anomalies. Flagged 30+ at-risk clients that directly shaped weekly sales outreach priorities and retention strategy.

Power BI Dashboards

Built patient throughput and referral conversion dashboards that achieved a 30% latency reduction in reporting cycles. These dashboards enabled real-time staffing decisions for a 20+ person operations team, replacing weekly manual spreadsheet reviews.

03

Operations

CRM & Identity

Administered Pipedrive CRM and Microsoft Entra identity management for a 14-person sales team. Integrated Seamless.ai for lead enrichment, onboarded 3 new sales reps, and resolved 50+ access and configuration issues to keep the team unblocked.

Trend Reporting

Produced week-over-week and month-over-month reports across 10,000+ records using Python and R. Delivered insights over 12 bi-weekly reporting cycles that shaped staffing allocations and provider retention strategy for the executive team.

END OF FILE

Return