HALEY MAES

DATA ANALYST

CONTACT

Arvada, CO (720) 467 - 3584 haleymykellemaes@gmail.com

linkedin.com/in/haleymmaes https://haleymykellemaes-beep.github.io/

SUMMARY

Data Analyst with experience transforming complex operational and financial data into actionable business insights. Proficient in SQL, Python, advanced Excel, Tableau, and Power BI, with expertise in reporting, data validation, trend analysis, and process improvement. Proven ability to identify inefficiencies, improve financial performance, and communicate findings that support strategic decisions.

TECHNICAL & ANALYTICAL SKILLS

Tools: SQL (PostgreSQL) · Python (pandas, NumPy) · Advanced Excel (PivotTables, XLOOKUP) · Tableau · Power BI · Google Sheets · GitHub · Cursor · Claude

Analysis: Data cleaning & validation · KPI & dashboard reporting · Statistical analysis · Trend, variance & root-cause analysis · Data visualization · Reconciliation

PROFESSIONAL EXPERIENCE

Billing & Operations Analyst

JUNE 2024 - PRESENT

Denver Family Dental | Denver, CO

Analyze 100-150 insurance claims per week; transform claims, payment, and accounts receivable data into leadership reporting used to prioritize collections and business decisions.
Built an Excel aging tracker separating patient and insurance balances, denial reasons, and follow-up actions; cut receivables older than 90 days by $11K, from 31.4% to 18.7% of open A/R.
Developed denial tracking by root cause to identify recurring errors, direct corrections, and improve visibility into outstanding claims.
Reconcile activity across 10+ payment types, including overpayments and refunds; reported collections increased 14% ($388K to $443K) during the same period.
Led a payment-platform rollout that reduced card-processing fees from 2.4% to under 1%; assess vendor spending and operational trends to identify cost and service improvements.

Assistant Head of School (Promoted from Lead Teacher)

JULY 2023-JUNE 2024

Guidepost Montessori | Dallas, TX

Reconciled tuition accounts for 100+ families, tracked variable charges, and resolved payment and record discrepancies across systems.
Established data-entry standards and trained staff, replacing inconsistent records with more reliable, centralized information.

SELECTED ANALYTICAL PROJECTS

SQL | Student Performance Triage Analyzed 6,607 students across 20 variables in PostgreSQL; found 687 previously high-scoring students who later scored 65 or below. Built an exception-based advising queue with automated SQL refresh logic.

Python | Happiness & GDP Joined World Bank and World Happiness Report data into 1,927 country-year records; used pandas and NumPy for data cleaning, transformation, and correlation analysis (r = 0.836).

Tableau | Channel & Inventory Analysis Visualized revenue and inventory trends from a FY25 10-K; identified a 10% revenue decline against flat inventory and recommended channel-specific allocation changes.

EDUCATION & PROFESSIONAL DEVELOPMENT

B.S. Data Analytics |Western Governors University | November 2026

Data Analyst Nanodegree | Udacity

Computational Mathematical Sciences | Arizona State University