Data Analyst United States

Bryan Ito, Data Analyst

Temecula, United States, 951-***-****, *******@*****.***

Professional Summary

I’m a data-driven professional with a background in HR technology, data migration, Data analysis and reporting. I specialize in transforming raw datasets into meaningful insights through tools like SQL, Excel, and VBA. I thrive in collaborative environments, solving data problems, and optimizing systems for accurate, actionable results.

Professional Experience

CX Data Consultant, Paycor

Cincinnati, OH United States - 07/2023 – 04/2025

Ensured accurate collection and analysis of client-level historical payroll data.

Identified and resolved data discrepancies in tax treatments, earnings, deductions, employer codes, and liabilities.

Used advanced Excel (including Macros, VBA, and Pivot Tables) for data analysis and troubleshooting.

Collaborated with cross-functional teams to resolve complex tax issues and enhance process efficiency.

Trained Data Conversion and Implementation teams on historical documentation standards and tax processes.

Data Conversion Consultant, Paylocity Corporation

Schaumburg, IL United States - 05/2013 – 06/2023

Executed electronic data conversion from over 200 diverse payroll systems.

Served as a subject matter expert on payroll systems extraction strategies.

Tested the converted data for compliance with business rules.

Conducted complex electronic data transfer programming using SQL, VBA, and MS Office products.

Evaluated legacy system data quality and performed necessary data cleanups.

Professional Services Data Analyst, Fidelity Information Systems

Jacksonville, FL United States - 03/2012 – 02/2013

Delivered data-driven reports and dashboards to support HR and payroll operations, enabling stakeholders to make informed, strategic decisions

Analyzed complex datasets to identify trends, discrepancies, and performance metrics related to employee benefits, payroll, and system configurations.

Designed and maintained SQL queries for ad hoc and scheduled reporting needs across various internal teams and clients.

Collaborated with cross-functional teams to troubleshoot data issues and optimize system workflows.

Supported benefit configuration data and generated compliance-focused reports for auditing, payroll processing, and bonus/commission tracking.

Application Data Specialist, Ceridian Corporation

Minneapolis, MN, United States - 08/1997 – 02/2012

Led discovery sessions and analyzed client data requirements for system implementations.

Developed custom SQL reports to support payroll, benefits, and HR analytics.

Conducted risk and GAP analyses to improve data accuracy and system efficiency.

Configured data imports and exports across platforms, ensuring seamless transitions and accurate reporting.

Skills

SQL

Data Cleaning & Transformation

Report Building & Analysis

Advanced Excel (Pivot Tables, Macros, VBA)

Salesforce

Data Integrity Auditing

Tools & Technologies:

Excel: Data manipulation, VLOOKUP, pivot tables, conditional formatting, error checking, and formula-based validation

Power BI: Imported and explored HR datasets (e.g., headcount, turnover, demographics). Note: Experience using Power BI Power Query for data preparation tasks, including merging datasets, filtering, and data cleanup. I am familiar with the Power BI environment and eager to expand my skills in visualization and dashboarding.

Strengths

Analytical Thinking

Cross-functional Collaboration

Contact this candidate