Paycom
David C. Rogers
HR Analytics Specialist
Phoenix,az
Summary
Over 30 years experience as a Human Resource professional including analytics, supporting Human Resource Business Partners, Benefits, Recruitment, and Information Systems. Experience includes HCM and conversion with AS400/CMS, to Microsoft Dynamics then to Paycom. Extensive experience as Administrator to ADP Workforce Now and working knowledge with Workday HCM. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy
Overview
18
18
years of professional experience
15
15
Certificate of completion focus on analytics
Work History
HRIS Specialist
Self-Employment Specialist
02.2023 - Current
- Enhanced HRIS efficiency by streamlining data entry processes and implementing automated workflows.
- Presented actionable insights and recommendations to the customer, influencing key decisions in the use of Excel and Business Intelligence.
- Created comprehensive dashboards and reports unique to the customer.
- Effectively communicated findings to non-technical stakeholders, enabling them to make data-informed decisions that positively impacted the business.
HR Analytics
DBM Global, Inc.
01.2007 - 01.2023
- Provided day-to-day support for issues related to HR systems by investigating problems and developing detailed suggestions for resolution of issues.
- Continually monitored data integrity of the HCM system that improved the quality and accuracy of workforce data.
- Designed, maintained, HR dashboards and interpreted reports while adhering to internal standards to ensure accuracy and confidentiality.
- Provided leadership for total HRIS system conversion with multiple systems, involving HR and Payroll.
- Created test scripts during the conversion of HCM software that included multiple departments such as Information Technology, Human Capital Management, and Benefits until all issues encountered are resolved.
- Worked closely with IT with monthly security and SOX compliance.
- Ensured security of HR information through established security protocol.
- Develop updates and modified security tables to ensure data integrity and system stability.
- Developed user procedures and guidelines and trained system users on these processes and functionality.
- Developed a compensation program with standard operating procedures that is aligned with business processes and goals in creating the total compensation package.
- Responded to government reporting obligations related to EEO, AAP, VETS, and California Pay Data
- Made sure that EEO/AA policies, programs, and procedures are implemented and communicated with all employees in the organization
Benefits Manager
DBM Global, Inc
09.2005 - 01.2007
- Identified benefit options by studying programs and obtaining advice from consultants with a national workforce with multiple health plans
- Ensured compliance with federal, state, and local legal requirements by studying existing laws and regulations and updates to legal requirements
- Informed employees of benefit usage by preparing and distributing benefit reports
- Managed benefits staff by coaching, counseling, and mentoring employees
- Resolved employee questions and problems by interpreting benefit policies and procedures
- Prepared special reports by collecting, analyzing, and summarizing information and trends
Accomplishments
- Created Excel workbook utilizing VBA and Macro codes that significantly boosted the efficiency of the benefits department by reducing the time needed to reconcile multiple invoices by an impressive 70%. As a result, the department was able to enhance overall effectiveness, leading to a remarkable return on investment that positively impacted on the organization's bottom line.
- Collaborated with human resources and payroll departments in creating a consolidated, multi-facility manpower report that streamlined status change form, resulting in an impressive 50% reduction in processing time. This efficient process overhaul not only significantly saved time but also greatly minimized errors, ensuring accurate and prompt updates for employee status changes.
Skills
- In-depth knowledge of HRIS software including ADP Workforce Now, Paycom, and MS-Dynamics
- Knowledgeable in Workday-HCM
- Expert in Microsoft Excel
- Advanced knowledge creating VBA, and Macro
- Proficient in the use of Business Intelligence and dashboards
- Comfortable with autonomous role working with multiple departments, addressing their needs for reports, both ad-hoc and regular re-occurring basis
- Advanced working knowledge with Salarycom-CompAnalyst
- Initiative-taking maintenance of human capital database
- Leadership in HR information systems conversion, as well as auditing for quality
- Advanced working knowledge with Microsoft Office 365
- Development of compensation plans
- Creating detailed dashboards focused for executives, general managers, human resource partners
Certification
Power BI Data Modeling and DashboardsSQL Essential TrainingExcel 2016: Advanced Formulas and Functions, Multiple Worksheet and Workbook Management,Excel Business Intelligence – Intermediate level with Power Pivot, DAX, Power Query, and Data Modeling,Excel Data Analytics,Excel Data Tracking. Phlebotomy Technician, BLS Health Care Provider.
Education
Bachelor of Science - Business Management
University of Phoenix
Phoenix, AZ04.1998
Certificate of Completion - Human Resource Management
University of Phoenix
Phoenix, AZ12.1995
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The best way out is always through.
Robert Frost
Software
ADP Workforce Now
MS Dynamics / Hitachi Solutions
MS Excel
MS Power BI
MS Word
MS Power Pivot
VBA codes
MACRO codes
Workday HCM
Timeline
HRIS Specialist
Self-Employment Specialist
02.2023 - Current
HR Analytics
DBM Global, Inc.
01.2007 - 01.2023
Benefits Manager
DBM Global, Inc
09.2005 - 01.2007
Power BI Data Modeling and DashboardsSQL Essential TrainingExcel 2016: Advanced Formulas and Functions, Multiple Worksheet and Workbook Management,Excel Business Intelligence – Intermediate level with Power Pivot, DAX, Power Query, and Data Modeling,Excel Data Analytics,Excel Data Tracking.
Bachelor of Science - Business Management
University of Phoenix
Certificate of Completion - Human Resource Management
University of Phoenix
Similar Profiles
Rosie BauerRosie Bauer
Business Employment Specialist at Business Employment SpecialistBusiness Employment Specialist at Business Employment Specialist
Christina Papaioannou-MalcolmChristina Papaioannou-Malcolm
Abilities To Work at Accessibility Employment SpecialistAbilities To Work at Accessibility Employment Specialist
Angeleah PantojaAngeleah Pantoja
Business Employment Specialist at Oregon Employment SpecialistBusiness Employment Specialist at Oregon Employment Specialist