Open to opportunities

Crystal McCarthy

@crystalmccarthy

Message

HR Analyst at City of Mesquite who built a turnover report and automated workforce data audits.

United States

Message

What I'm looking for

I’m seeking an HR Analyst, HRIS Specialist, or HR Data Analyst role.

At City of Mesquite – Public Works, I process hiring, separation, promotion, and pay actions, and keep personnel and position records current. I built a turnover analysis and leadership report from HR system exports.

I also created Excel dashboards with VBA macros and Python tools to reconcile invoices and audit CityWorks service requests. My data cleanup reduced reporting discrepancies and duplicate entries by 20%.

At City of Arlington, I analyzed turnover trends across a 4,000-employee workforce and built Power BI dashboards and monthly compliance reports. I’m a U.S. Air Force veteran with a Master of Science in Human Resource Management, and I’m seeking HR Analyst, HRIS Specialist, or HR Data Analyst roles.

Experience

Work history, roles, and key accomplishments

Current

Administrative Assistant (HR, Data & Reporting)

Current

City of Mesquite

Dec 2025 - Present (11 months)

Processed HR actions including promotions, merit increases, and new hires; built Excel and Python tools for data reconciliation and reporting. Reduced reporting discrepancies by 20% and service request backlog by 35%.

Workday Tyler ExecuTime Excel VBA Python Power BI Data Auditing HRIS Timekeeping Leave Management

Human Resources Assistant

City of Arlington

Sep 2024 - Apr 2025 (7 months)

Analyzed turnover trends for a 4,000-employee workforce and built Power BI dashboards, reducing manual reporting time by 25%. Managed personnel files and responded to HR inquiries.

Power BI Data Analysis HRIS Compliance Employee Relations Reporting

Human Resources Intern

Texas Commission on Environmental Quality (TCEQ)

May 2023 - Aug 2023 (3 months)

Verified and corrected employee data for 484 personnel, conducted cost-per-hire analysis, and screened applicants. Created SOP for hiring process in CAPPS.

CAPPS Data Integrity Candidate Screening Cost Analysis SOP Development

Bioenvironmental Engineering Technician

United States Air Force

Apr 2016 - Apr 2020 (4 years)

Onboarded new Airmen in DOEHRS, delivered analytical reports, and developed SOPs for safety programs. Led audits covering 50+ workplaces and 180 personnel.

DOEHRS Data Reporting SOP Development Compliance Auditing Training Logistics