Projects

Welcome to the hub of my personal and professional builds. Here you'll find a curated collection of data projects, creative experiments, and real world solutions, each designed to sharpen my skills and solve meaningful problems. Whether it's analytics dashboards, Python projects, or social experiments, every project here reflects growth, curiosity, and execution.

Payroll Calendar Validator

Problem

71% of payroll defects were caused by misconfigured or outdated calendars.

Solution

Python-based validator that scans 500+ calendars weekly, flags structural issues, and auto-emails error summaries to responsible teams.

Skills Used

Python · Pandas · Data Validation · Automation Scripting

Email Automation (pywin32) · Excel File Handling (openpyxl)

Operational Auditing · Payroll & Benefits Domain Knowledge

👉 View Full Project

HRIS File Cleaner

Problem

Employees were getting stuck during enrollment due to improperly formatted phone numbers (e.g., +1). The product team determined the issue did not impact a broad enough client base to prioritize an urgent system fix.

Solution

Python-based ETL tool that cleans HRIS phone numbers, logs all corrections with reason codes, and generates both an updated file and Excel audit report for compliance tracking.

Skills Used in This Project

Python · Pandas · Regex · Data Cleaning

Excel Reporting (openpyxl) · Logging (logging)

File I/O · Modular Design · HRIS Data Management

👉 View Full Project

HSA Contribution Guardrail

Problem

Employer HSA contributions were being duplicated during off-cycle benefit updates (e.g., marriage, birth, address changes). Each update triggered a new HSAER row in the payroll file — even if the $500 annual contribution had already been issued. This resulted in unnecessary costs, manual corrections, and compliance concerns.

Solution

A Python-based ETL workflow that compares the current payroll file against a historical full file. It removes duplicate HSAER entries from payroll and logs which SSNs were excluded. It also generates an updated version of the full file with valid new HSAER entries appended for future audits.

Skills Used in This Project

Python · Pandas · Regex · File Parsing

Data Deduplication · Logging (logging) · Data Auditing

Modular ETL Design · Payroll & Benefits Domain Knowledge

👉 View Full Project

Key Technologies

Python · Pandas · SQL · Oracle

Excel · Outlook

Power BI · Matplotlib