HR Analyst

HR Analyst — Apex Retail Solutions

Chicago, IL | October 2023 – Present

• Designed 8 interactive HR dashboards in Power BI and Workday, automating weekly headcount reports for executive leaders and reducing manual spreadsheet processing time by 28%.
• Constructed an employee retention prediction model using Python and SQL, identifying turnover risks for 650 staff members and improving department retention rates by 12% over 18 months.
• Audited employee compensation databases containing 1,200 records, correcting payroll discrepancies and saving $34,000 in annual licensing and misallocated benefits expenses.
• Facilitated HR data migration of 4 business units into a unified Workday HRIS system, validating information integrity for 950 employees with a low data-error rate of under 0.5%.

Junior HR Analyst — Beacon Logistics Corp

Milwaukee, WI | June 2021 – September 2023

• Extracted and compiled monthly recruiting performance metrics using SQL and Tableau, which increased applicant tracking efficiency by 15% across 45 open requisitions.
• Engineered automated exit interview surveys in Qualtrics, capturing data from 200 departing employees to identify and address core turnover causes, reducing HR response delay by 30%.
• Conducted market salary benchmarking analyses using Mercer survey data, leading to competitive salary structure updates for 140 employees and cutting hiring time by 18%.
• Streamlined onboarding processes by building custom SharePoint documentation, accelerating training completion rates for 120 new hires by 22% over a 12-month period.

Data analysis, SQL, Tableau, Power BI, Python, Workday, HRIS database management, Advanced Excel, Data visualization, Benchmarking, Recruiting metrics, Employee turnover modeling, Compensation analysis, BambooHR, Qualtrics, SharePoint

Predictive Attrition Modeling

Role: Lead Data Analyst

Tools: Python, SQL, Tableau, Jira

Designed a statistical attrition model analyzing 3 years of exit interview data, which predicted turnover risk with 85% accuracy and helped retain 40 key personnel.

Compensation Benchmarking Project

Role: HR Analyst

Tools: Microsoft Excel, PayScale API, Workday

Realigned compensation structures for 18 internal jobs against market averages, correcting 25 payroll inequities and reducing turnover within underpaid departments by 14%.

• SHRM Certified Professional (SHRM-CP) (2023)
• Associate Professional in Human Resources (aPHR) (2021)
• Tableau Desktop Specialist (2022)

• Professional Memberships: Active member of the Society for Human Resource Management (SHRM) Chicago Chapter (2021-present)
• Languages: English (Native), French (Conversational)
• Availability: 2 weeks notice