Payroll Manager And Payroll System Analyst Resume Example RANGAM CONSULTANTS, INC., JOHNSON & JOHNSON VISTAKON

PAYROLL MANAGER AND PAYROLL SYSTEM ANALYST

Summary

To obtain a position working with business systems. I have a lengthy history of project management, data, business and system analyst roles, testing, documentation management, operations and team management. I am looking for a role that will allow me to utilize my skills and be an enhancement to the organization. I welcome the opportunity to serve in any capacity for which my skill set is available.

Experience

09/2015 to Current

RANGAM CONSULTANTS, INC., JOHNSON & JOHNSON VISTAKON － Jacksonville, Florida

Project Manager and IT Business Analyst for the implementation of Optymyze, a Sales and Compensation cloud solution.
Managed daily scrum calls and distributed minutes (Agile project).
Responsible for all Agile, SOX and Compliance documentation.
Managed project sprint cycle backlog.
Wrote HP ALM test scripts for all testing scenarios.
Manipulated data to compare legacy and Optymyze systems for accuracy of reporting.
Created data feed requirements detailing fields.
Wrote functional specifications and provided Visio diagrams and workflows, created diagrams for the system solution of sales quota and compensation and diagramed the data exchange feeds.
Prepared Quick Reference Guides for business partners.

12/2013 to 06/2014

Payroll Manager and Payroll System AnalystNORTHGATE ARINSO － Jacksonville, Florida

Supported 22 direct reports - SAP Managed payroll operations payroll for 2 companies with a combined total of 12k employees.
Client Liaison.
Provided oversight and leadership to a team of 20 in Manila who provided call center and payroll processing support, HRIS staff lead with employees in Jacksonville, Cincinnati and Atlanta, worked with IT staff in Jacksonville and India providing SAP payroll support and testing.
Supported the Manila team for advanced issues, creating files to correct premiums, dates, taxes values, etc.
Received files several days a week from Lawson, Workday, Kronos, Cognos and other related payroll deduction files - Merrill Lynch, Insurance Vendors and 3rd party deductions such as United Way.
Processed payroll and worked error reports prior to final payroll processing.
Client Liaison.
Provided oversight and leadership to a team of 20 in Manila who provided call center and payroll processing support, HRIS staff lead with employees in Jacksonville, Cincinnati and Atlanta, worked with IT staff in Jacksonville and India providing SAP payroll support and testing.
Supported the Manila team for advanced issues.
Production Support for HRIS Tickets and Projects, pulled mass data to compile diverse test cases for all scenarios plus regression testing scenarios, executed test cases and compiled results, tested items in the development system, ran ad hoc reports, wrote business requirements and desk procedures.
Wrote Technical Specifications, managed projects.
Assigned special review of vendor financials with other reports and imports/exports for Merrill Lynch and TALX.

08/2004 to 12/2013

HRIS System AdministratorFIDELITY NATIONAL FINANCIAL － Jacksonville, Florida

HRIS/HRIT Business, Data and System Analyst Business, Benefits, Payroll, Finance and HR), Direct liaison to IT, Assisted Payroll Administrator, Finance Director, Benefits Director, Compensation Manager and Sr.
HR Generalist, Report Writer, Project Manager on many Projects.
Oracle HRIS system 6 years 2007-2013.
Supported HR, Benefits, Payroll and Finance.
Using sql, Discoverer and EIS Reporting, extracted data for either analysis work, testing or end user report creation.
Worked on Total Compensation Statements, worked employee Self Enrollment project and many others, worked in developing a method to handle cross year rate changes, performed IT unit testing on the development server before the test data rolled out to the front end testers.
Also assisted in requirements and testing for all system tickets.
Worked a number of acquisitions, mergers, spin offs and the Oracle implementation.
Implemented a benefits compensation program that translated commissioned earnings for 4,000+ sales personnel into benefits compensation values to enable them to enroll in salary related benefits.
Worked with data gathering hundreds of thousands of rows of information and reducing to the most distinct set of test cases for all testing, compiled carrier file content when exchange files were not complete in IT, mapped vendor files for testing purposes being able to test all fields and data greatly reducing the number of test file exchanges, compiled data into reports for intranet reporting, RFPs, department head requests and end users.
Reformatted data from other external vendor systems for acquisitions and mergers, transitioning to data ready import files of HR, Benefits and Dependent information into Oracle API files.
Ceridian HRIS system 3.5 years utilized for internal operations of a 64k employee company prior to spinning Alltel off to Fidelity Information Services, reduced to 46k; passed payroll files to Ceridian for check execution and taxation.
Remainder of all other aspects of HR, Benefits, Payroll and Finance were handled internally.
Continual weekly conversion of data and related troubleshooting due to payroll system being a mainframe and the GUI software running on Windows - considerable mapping of fields and data clean up.
Ceridian has an excellent schema and all tables have a mapped primary key to all other tables.
Made sql ad hoc queries so much easier to develop.
Ceridian had an sql entry box where raw sql queries could be written in a text editor and pasted directly for data extraction as well as using an ODBC connection to pull data, it was also accompanied with Crystal Reports for extraction or end user report creation.

01/2003 to 01/2004

HRMS Business AnalystWINN-DIXIE － Jacksonville, Florida

Conversion from legacy to PeopleSoft, Production Support Specialist to Benefits & Payroll.
PeopleSoft HRMS 12 months HRMS support provided post conversion from legacy system to PeopleSoft for 113k employees.
Provided internal call center support, payroll and finance report writing support, ticket tracking, vendor file maintenance - implementations, testing, imports/exports.
Gathered data from legacy system, wrote reports in the PeopleSoft system either via sqr or direct data select through ODBC connection.
Wrote business requirements and performed testing.
Gathered data for analyzing vendor file transfers to troubleshoot payroll deductions.
Reviewed premium data analyzing missed premiums from payroll for purposes of self-billing.

01/1997 to 01/2003

System Implementation Project Manager, System Analyst, Business Analyst, Operations ManagerCITISTREET － Jacksonville, Florida

16 direct reports.
NextGen HRIT Support 2 years - Assistant project manager for Quest, TRW, R R Donnelley implementations, and several other large clients.
Interfaced with customer and vendors to write business requirements, assisted with technical specifications, designed programs.
Services included HR self-service enrollment, 401k management, Compensation management, bereavement services, automation of manually paid premiums, HRIT support - duties were preparing documentation for code moves and also maintained requirements version control.
ODBC connection for data extraction.
Worked with data from clients for formatting into NextGen import tables for conversion purposes.
Worked with data exported from NextGen for formatting into insurance vendor files for reporting benefits.
GIBS COBRA billing system 5 years.
Implemented 14 COBRA clients as project manager with a shoestring budget, small staff and tight time frames.
Always met deliverables.
Worked with billing data for confirmation of payment receipts, client account balancing, and with data setups to ensure compliance with timely COBRA notification and premium collection periods.
I was able to map the difficult COBRA subsidies from NextGen to COBRA so that all the information could be passed electronically.
One company, Quest Telecommunications had 23 different subsidy plans due to the ma bell and baby bell companies with adjusted service dates.
Integrated the COBRA servicing with the NextGen system and was able to close the department and have this segment handled by the general call center.
Moved to HRIT following this automation.

01/1996 to 01/1997

Operations ManagerHUMANA INSURANCE COMPANY － Jacksonville, Florida

80 direct/indirect reports.
Lead manager for Medicare of South Florida claims processing.
Reporting, audit work, approve system tickets.
Data analyst for Medicare claims searching mass amounts of data for repetitive claim billing, overlapping date billing, correct diagnosis coding and other Medicare checkpoints to prevent fraudulent billing.

01/1994 to 01/1996

Operations ManagerREINSURANCE MANAGEMENT, INC － Jacksonville, Florida

Excess Loss Claims 26 direct reports.
Third Party benefits and claims administration, internally developed system.
401k both defined benefit and defined contribution and Employer Benefits outsourcing provider of various client determined products 7 years, Implementations, maintenance and production support and Open Enrollment with team of IT and other staff to support the many projects.
Learned a number of augmenting systems including Crystal report, sql queries, unique joins, etc.
Prepared appeals for board review; maintained mandatory state appeal log and reported annually as required.

Education

Bachelor of Arts: Business AdministrationLiberty International University － Tampa, FloridaBusiness Administration

Skills

Agile, SDLC, Waterfall *HP ALM Test System *PHP *SAP Payroll, SAP Ad Hoc reporting *Oracle Benefits, Payroll, HR, Discoverer Reports and EIS Reports *Ceridian Benefits, Payroll and HR, Integrated Crystal Reports *PeopleSoft Benefits, Payroll, HR, SQR, ReportSmith *ICA I & II, LOMA Pats 1, 2, 5, 7, 8, HIAA I & II Certificates *Proficient in the following software/products: *Advanced MS Office skills: Access, Excel, Word, PowerPoint, Visio, Edit Pad Pro SQL editor and MS Project; other project management processes include AGILE, SDLC Waterfall, Clarity, Instantis, PMx and SixSigma. *Report writing tools such as Access, Excel Pivots and other complex computations, SQL and SQR, Communications writing and version control tools, Crystal Reports. *IT testing logs and ticket management (using HP ALM, Clear Quest, Tracker and others).

Resume Overview

Companies Worked For:

RANGAM CONSULTANTS, INC., JOHNSON & JOHNSON VISTAKON
NORTHGATE ARINSO
FIDELITY NATIONAL FINANCIAL
WINN-DIXIE
CITISTREET
HUMANA INSURANCE COMPANY
REINSURANCE MANAGEMENT, INC

School Attended

Liberty International University

Job Titles Held:

Payroll Manager and Payroll System Analyst
HRIS System Administrator
HRMS Business Analyst
System Implementation Project Manager, System Analyst, Business Analyst, Operations Manager
Operations Manager

Degrees

Bachelor of Arts : Business Administration

Payroll Manager and Payroll System Analyst Resume Example

Resume Score: 80%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes