Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

JOHNNY STEWART

Payroll Analyst
Farmers Branch,TX
JOHNNY STEWART

Summary

With over 15 years of experience in payroll administration, I am a seasoned payroll professional who has managed large-scale, end-to-end, multiple-state payrolls for various industries. I have a strong track record of implementing quality control procedures, streamlining payroll processes, and developing tools and reports to enhance payroll efficiency and accuracy.

In my most recent role as Payroll Analyst at Artisan Design Group, I contributed to the Mergers and Acquisitions team, handled mass data import files for 5k+ contractor employees across 25 business entities, and worked directly with the payroll vendor to tailor software capability to the company's needs. I also have a background in accounting, which enable me to reconcile GL discrepancies, and produce ad hoc reports for quarterly payroll reporting projects. I am highly adept at analyzing complex data and collaborating with various teams and stakeholders to deliver innovative solutions.

Overview

19
years of professional experience

Work History

NTT Data Inc

Senior Payroll Analyst
04.2021 - 10.2023

Job overview

Managed US Corporate and hourly staff payrolls for 4k+ exempt and nonexempt employees, loaded payroll import files for incentive and severance payments, tax adjustments, and benefit corrections. Worked with payroll software vendor to test new versions and updates prior to rollout. Assisted Accounting team with GL account reconciliations, and produced ad hoc reports for Payroll Senior Management, and Director. Partnered with leads on Time and Attendance Team, and Payroll Groups to standardize payroll processes.

Achievements:

  • Implemented quality control procedures for semimonthly and biweekly payrolls.
  • Built audit spreadsheets to streamline pre/post payroll processes.
  • Developed tools for Payroll Ticketing Team to aid with ticket resolution.
  • Created detailed job aid procedures for new hire training.

Artisan Design Group

Payroll Analyst
03.2020 - 09.2020

Job overview

Produced ad hoc reports for quarterly payroll reporting projects and worked with accounting to reconcile GL discrepancies. Setup GL accounts and pay codes, maintained employee portal accounts. Managed company’s professional and administrative staff payroll. Other key payroll functions included mass data import file loading for time punches and certified payroll for 5k+ contractor employees across 25 business entities. Worked directly with payroll vendor to tailor software capability to company needs. Tested data alignment for acquisition integration projects.

Achievements:

  • Contributed on Mergers and Acquisitions team.
  • SME on mass data movement projects.
  • Removed silos by developing working rapport with entities.

AccentCare Inc

Payroll Specialist
11.2016 - 03.2020

Job overview

Managed workflow to coincide with payroll production cycles and deadlines for 3k+ health professionals and administrative staffs. Constructed and loaded mass-import time files. Analyzed period-over-period variance data to monitor for overpayments. Performing payroll pre-calculation audits and balancing. Tasked with training new hires on end-to-end payroll process.

Achievements:

  • Commended on ability to quickly research and resolve complex payroll issues.
  • Collaborated with HRIS and CA regional Office Coordinators to automate pay code import process.
  • Created dynamic VLOOKUP Excel tools for balancing payroll and reducing errors.

Computershare Inc

Dividend Disbursements Analyst
01.2005 - 11.2015

Job overview

Calculated disbursements and produced funding letters for over 100 declared dividends quarterly for large global clients and fund institutions. Analyzed variances reports and balanced depository shares, treasury shares, and reinvestment shares. Worked with Relationship Managers to resolve funding letter discrepancies.

Achievements:

  • Increased efficiency by implementing macros automation tools.
  • Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.

Education

Moraine Valley Community College
Palos Hills, IL

Studied Accounting And Finance
2012

Skills

  • Payroll Management
  • Audit and Reconciliation
  • Payroll Accounting
  • Training & Development
  • Workday
  • Dayforce
  • Paylocity
  • SAP
  • Excel Proficient
  • Data Imports & Integration
  • Ad Hoc Reports
  • Trends Analysis

Timeline

Senior Payroll Analyst

NTT Data Inc
04.2021 - 10.2023

Payroll Analyst

Artisan Design Group
03.2020 - 09.2020

Payroll Specialist

AccentCare Inc
11.2016 - 03.2020

Dividend Disbursements Analyst

Computershare Inc
01.2005 - 11.2015

Moraine Valley Community College

Studied Accounting And Finance
JOHNNY STEWARTPayroll Analyst