Skip to content
Crystal Franklin

About me

Analytics grounded in how businesses actually run.

Before analyzing data, I spent years producing it — tracking enrollment and staffing, reconciling books, and documenting patient and claim records. That experience shapes how I ask questions and what I consider a useful answer.

Where my perspective comes from

Business operations

Coordinated daily operations, staffing, enrollment, and compliance for centers serving 120+ and 170+ children.

Financial reporting & bookkeeping

Reconciling transactions in QuickBooks and Excel, and preparing profit-and-loss statements for small-business clients.

Healthcare administration

Patient records, insurance verification, and pharmacy claim research on a Cigna pharmacy help desk.

Data analytics

Google Data Analytics certified, working in Excel, SQL/BigQuery, Power BI, Tableau, and R.

Digital product creation

Building and organizing knowledge platforms and an interactive learning site.

Professional development

Pursuing a B.S. in Business Management, with completion estimated in 2030.

Skills & certifications

What I bring

The full, interactive skills explorer lives on My Journey.

Data Analytics & Reporting

Microsoft ExcelSQL (BigQuery)Power BITableauR/RStudioData cleaning

Financial & Business Operations

QuickBooksAccounts payable & receivableJournal entriesBank reconciliationMonth-end close supportExpense categorization

Healthcare & Administrative Support

Patient recordsInsurance verificationPharmacy claim troubleshootingDocumentation reviewSchedulingConfidential information handling

Digital Tools & Collaboration

Microsoft 365Google WorkspaceSalesforceNetSuiteCitrixAmazon Connect

Education

Bachelor of Science in Business Management

Penn Foster College, Online · In progress · estimated completion 2030

Certification

Google Data Analytics Professional Certificate

Merit America · September 2025

Connect with me