SUMMARY

• HRIS/Payroll Systems Analyst
• Organized and detail oriented HRIS/Payroll Systems Analyst with extensive, diversified knowledge and experience who adapts seamlessly to evolving processes and technologies.
• Core Competencies & Strengths
• Advanced Excel (Pivot Tables, VLookups, Chart, Macros, etc.)
• Advanced Access (Forms, Reports, Graphs, Charts, ODBC links/connections, etc.)
• Software role and user security setup and administration
• HR, Payroll, Benefit, and Accounting software system lifecycle development processes
• Maximizing best practices according to system functionality, company structure, industry standards, user competencies
• Data integrity utilizing reporting software, tools, scripts and queries
• Work with minimal supervision to achieve individual tasks and responsibilities while working with a team to achieve departmental and company goals and objectives
• Implement, QA, train and support users on software upgrades, modules, best practices, industry standards, governmental compliance and regulations
• System Skills, Strengths & Experience
• Oracle Fusion HCM SAP (ADP Global View Microsoft Office Suite 365
• UltiPro ADP EV5 PeopleSoft
• Ceridian UltiPro Time & Attendance Kronos Workforce Central 7.0
• Cognos Business Intelligence Reporting Crystal Reports XI ReportSmith
• PeopleCode/PeopleTools SQL Developer SQR

PROFESSIONAL EXPERIENCE

Confidential

HRIS Analyst II

Responsibilities:

• Complete end to end understanding of all ERP and Operating Systems during the Implementation life - cycle (Oracle Taleo, Oracle Fusion HCM, Network Ninja, Kronos Time and Attendance, SAP ADP Global View)
• Complete end to end understanding of all existing ERP and Operating Systems (iCims, Taleo, ADP EV5, Lawson, Ceridian, SQL Developer)
• Designed streamlined solutions in collaboration with team members across HRIS/HR/IT and Operations
• Mapped data for new integrations between all ERP integrations and third-party vendors
• Complete understanding of all data integrations between existing HR, Payroll, Operational systems and vendors
• Develop project plans to manage end-to-end deliverables, interdependencies and execution
• Metrics and data analysis to identify issues related to operations, productivity, and efficiency
• Identify system issues and partner with IT and management for solutions
• Continuously audit and identify issues, isolate root cause, implement best practices and recommend and implement improvements
• Provide HRIS team coaching, mentorship, and assistance with meeting career goals and development
• Coordinate, oversee and ensure quarterly and annual statutory compliance
• Document policies and procedures
• System configuration and harmonization of system and transactional data across all legacy and future systems
• Develop custom SQL statements and reports to accommodate user and vender requests and data loads
• Documenting all Functional and Technical Specifications for all current and future inbound/outbound interfaces

Confidential

HRIS Consultant (Contractor

Responsibilities:

• Creating Business Intelligence Reports for users to streamline and audit payroll and HR records for over 12,000 employees.
• Creating and running 6-8 SQL queries, reports and stored procedures daily to reduce and eliminate manual processes ad entry, where possible.
• Document HR and payroll processes and procedures to provide to each region and location (specifically as relates to time off earned based upon state, work hours, and attendance records) as a reference tool and guide.

Confidential

HR/Payroll System Analyst II

Responsibilities:

• PPACA reporting understanding, explanation, and preparation
• Project Team Lead throughout the life cycle of system implementations including cost/benefit analysis, business requirements analysis, documentation of processes and procedures, system configuration, security authorization and administration, data mapping and conversion, and Quality Assurance testing
• Work with business partners (Benefits, Payroll, Accounting, Finance) to develop, configure and implement business policies and procedures with the SaaS based Ultipro system
• Troubleshoot, resolve and correct system problems identified by end users
• Create Business Intelligence reports and SQL queries for workforce analysis and planning
• Develop, test, implement and support system interfaces with our third party vendors: BCBS of TX for health benefits, Chernoff 401(k) Plan Administration, VSP Vision, and BCBS COBRA Administration
• Prepared, created, documented, and customized statistical dashboards, metrics and reports
• Scheduled and prepared ad-hoc reports using various reporting tools
• Ensured schedule HR and Payroll reports and interfaces are accurate and process timely
• Business Unit and Vender point of contact for the implementation of various UltiPro modules including Recruiting, Onboarding, Benefit Life Events and Open Enrollment, Payroll, Training Management, Compensation Management, Performance Management, Career Development, Talent Management, and Succession Management.
• Assisted efficiently in the design, development, testing, and implementation of HR and Payroll systems and processes

Confidential

Payroll System Analyst

Responsibilities:

• Performed data integrity and analysis for the UltiPro (SaaS based ) - Time and Attendance System (UTA) for 5,000+ employees, including new hires, job changes, transfers, terminations, tax information, accruals, etc. to ensure timely and accurate multi-state payroll processing.
• Support and troubleshoot Time and Attendance to Payroll system interfaces.
• Managed implementation of Kronos 7.0 and UltiPro HR/Payroll Systems for new international acquisitions
• Provide cost benefit analysis to determine impact of system and module procurement, implementation and enhancements to meet business unit requirements and practices
• Evaluate work processes and procedures, recommend improvements, implement changes, and train users to meet changing business requirements.
• Create and maintain technical and functional documentation
• Develop and modify Business Intelligent Reports and queries for workforce analysis and system audits.
• Managed and applied systems updates to UltiPro (SaaS based) for over 1,800 employees internationally.
• Implemented Kronos time capture system 7.0.
• Develop scheduled and ad-hoc reports and queries for data audits, reviews, and payroll processing.
• Process payroll for over 1,200 employees throughout Canada, including payroll hours, garnishments, tax information, leaves of absence and PTO accruals in PeopleSoft.
• File ROE’s, T4’s, RL1’s and additional reports for Canadian government compliance.

Confidential

HR/Payroll System Analyst

Responsibilities:

• Responsible for creation and design of reports and queries for senior management and business units as determined by business heads within HR, Benefits, payroll, accounting, recruitment and training and development
• Create and apply SQL scripts to perform table edits in the payroll/HR system
• Support end users by troubleshooting, identifying and resolving system issues
• Managed and applied system upgrades for over 1,500 employees throughout the U.S. in Ceridian.
• Configure, test and implement system changes and enhancements aligned with business practices and requirements throughout all functional areas in HR, payroll and accounting
• Administer database security for end users in various departments based upon role functionality
• Construct and maintain organization chart and reports utilizing Microsoft Excel, Access, Visio, PowerPoint and Org Plus software.
• Integrate requisition, employee and position database with organizational charts for international projects.
• Enter journal entries into PeopleSoft Financials system.
• Analyze and reconcile international business unit accounts.
• Research discrepancies between Host hotels’ and individual properties’ ledgers.
• Audit Lawson HR system for employees with an active status receiving no pay.
• Modify and distribute Retention and Turnover reports.
• Liaison between business units and Information Technology for system development.
• Responsible for incoming and outgoing data transfer between HR database and outsourced HR vendors
• Develop SQR’s for interfaces between ADP Workforce Now system and third party vendors, such as benefits providers.
• System Administrator Implement New Hire and Salary Change workflow processes within the ADP Workforce Now application.
• Establish and administer ODBC connectivity for client workstations
• First level of technical and functional support for end users and vendors for ADP Workforce Now application as well as Kronos time capture system.
• Responsible for routine as well as ad-hoc reports for senior management, department heads utilizing PeopleTools and PeopleCode.
• Liaison for end users within HR, Payroll, Accounting, Information Technology Department and third party vendors

Confidential

Systems Analyst

Responsibilities:

• Project Manager for implementation of Kronos time capture system for over 1,500 employees throughout the U.S
• Create benefit interfaces and reports for self-billing
• Implement procedure for paying garnishments within the Oracle financials system.
• System administrator for Ceridian’s Source 500 HR/Payroll system as well as Kronos time capture system.
• Responsible for creating and scheduling reports for senior management, department heads and office managers.

Sr. Business Analyst

Confidential

Responsibilities:

• Implement Kronos time capture system.
• Develop a payroll budgeting database for department heads in accordance with the fiscal budgeting year and annual compensation plan.
• Develop payroll variance reports based on budgeted salaries versus actual salaries.
• Develop and implement position management and work flow procedures with Recruiting, New Hires, Information Technology, Associate Benefits, Payroll and Accounting.
• Liaison between Lockton’s business departments and Information Technology department to automate manual processes.
• Project manager to implement web-based solutions to varying department heads.
• Configured system for Open Enrollment Employee Benefits and Benefit Reporting
• Liaison for end users within HR, Payroll, Accounting, Information Technology Department and third party vendors. Responsible for coordination of Ceridian system upgrades and ensuring all minimum hardware requirements are met as suggested by Ceridian.
• Migrate data from customer’s existing HR/Payroll system to Ceridian’s HR/Payroll database.
• Developed custom Crystal Reports to meet customer’s business needs.
• Train users on Ceridian’s HR/Payroll software.
• Technical support to users of Ceridian’s Source 500 HR/Payroll software.