Manager Human Resources

Rhonda R. Jackson

indeed.com/me/rhondajackson

Cell 301-***-****: ******.********@*****.***

Summary

An experienced, consistent and professional Human Resources Information Systems professional with profound knowledge

of developing, maintaining and implementing HR and Payroll platforms to improve data integrity, compliance and

management reporting. Various systems include Oracle Hyperion, PeopleSoft, Ceridian, ADP, SAP FI HR/Payroll.

Professional Experience:

Marriott International, Bethesda, Maryland Mar 2012 –Present

Manager of Accounting/Oracle Financial Reporting Systems

• Design and configure Oracle Hyperion Essbase application and associated reports.

• Rationalize existing reports, identify and document future-state reporting requirements to be delivered via the

Essbase application, and participate in a proof of concept (POC) to determine the best method to deliver constant-

currency reporting in the future-state reporting solution.

• Design and configure Hyperion Financial Data Quality Management (FDM) tool, including configuration of

various data flows into Essbase from PeopleSoft Financials and EPM financial data source.

• Anticipate, identify and mitigate risks and managing resolution of implementation issues including test planning,

test preparation and test execution activities during the Reporting System Test.

• Identify and document test conditions, produce and review test scripts, execute test scripts, document test errors

and provide resolutions.

• Connect with Business Financial Leaders and SME’s to define report requirements, suggestions for improving

reports and report analysis.

• Design, build, develop and present financial report format and customized layouts to Business Finance Leaders

using Oracle Hyperion Financial Reporting Studio, Fusion Edition (HFR), Workspace and SmartView in Test,

DEV, and Production. Develop and maintain Framework Manager Metadata Model and Report Studio report

specifications.

• Design and configure Data Relationship Manager (DRM) tool. DRM Functional Administrator, Security

implementation, script automation, database performance

• Oracle HFR, DRM, and Essbase Production support. Communicate with PeopleSoft (9.1) general ledger and

governance team on data requirements for reporting.

Trinity Washington University, Washington, D.C. Jun 2011 – Mar 2012

Payroll /HRIS Implementations Manager, Washington, DC

• Provided leadership and expertise in all aspects of design, development, testing, and implementation Ceridian’s

Latitude HRIS system and interfacing with internal technology and platforms.

• Support management by providing expertise in the area of Human Resources Information Systems, Technology

and Payroll (recommended 3 internal companies to support monthly faculty and staff payrolls, hourly and student

and adjunct faculty contract payrolls), including BDI; HR benefits to payroll deduction interface.

• Provided guidance and maintain relationship between Human Resources, Information Technology, Accounting and other

business areas to ensure Ceridian’s Benefits and Payroll HRIS and all internal systems will interface effectively (Great Plans

Accounting System, TimeTrak, TIAA Cref) according to the requirements of the University.

• Identified new HR and Payroll needs and the software products to fulfill those needs. Prepare HR/Payroll Scripts from

ADP for Ceridian database upload. Created CSV formatted uhr files using Ceridian’s required specifications for HR and

Benefits modules.

• Prepared test scripts for HR, Payroll, TimeTrak (time and attendance software), and General Ledger interface. Resolved

data scrub issues related to records and dating issues in previous HR/Payroll database.

• Provided, interpret and scheduled adhoc reports to senior managers explaining data definitions, parameters and

limitations of current reporting system.

• Consult with management to determine data requirements, business needs and required custom reporting to meet

the overall institutions reporting needs for internal reporting and external auditing.

• Developed and implemented improvements to HR data gathering methodology for complete, consistent, and

accurate HR measurements.

• Responsible for day-to-day management of payroll activities, accounting and financial reporting functions including all

aspects of bi-weekly and monthly payrolls including time card reviews, editing, variance resolutions, inconsistencies and

reporting.

• Account reconciliation, and record keeping for payroll accounting, benefit including TIAA Cref (403B) retirement

accounts. Processed monthly bi-weekly, and adjunct contract payrolls.

NorthgateArinso, Atlanta, GA Jun 2010 – Jun 2011

Senior Payroll Operations Analyst

• Responsible for managing pre-payroll, payroll and post payroll processes for routine client payrolls (US Payroll

driver RPCALCUO) and tax data (BSI Tax factory used to generate tax wage types).

• Configured garnishments, taxes and benefits integrations, using proper SAP Infotypes.

• Generated payroll reconciliation reports to determine differences in payroll results and Tax Reporter as well as

financial postings and retro payroll discrepancies. Other reports based on client needs including gross to net, and

tax reporting. Ensured payroll and payroll accounting activities and practices were in compliance with Sarbanes-

Oxley guidelines (SOX)

• Managed payroll results (payroll clusters) and the output of the payroll process generated by benefit wage types

used containing tables of payroll-period related results, year to date accumulations and taxes.

• Managed Third-party file feeds into SAP Payroll and HR. Processed all payroll output transmissions (e.g., ACH,

ADP, positive pay, credit union, expat/impat)

• Identified and resolved off-cycle payroll errors related to HR benefit to payroll deduction interface. Worked

closely with AMO team to resolve interface issues related to payroll processing, time interface, and processor

entries (including, NAMC, YANA, etc.), and retro payrolls.

• Serve as intermediary with clients and AMO when critical service issues were escalated, worked closely with

AMO to develop and implement process improvements based on client needs, clients company’s and system

requirements.

• Transmitted payroll-funding to bank and reconciled payroll bank accounts. Collaborated with banking institution

regarding ACH, positive pay files and payroll funding.

• Provided supervision within Operations to internal and offshore team members related to client-specific needs,

HR/payroll processes and improvements.

Ceridian Corporation, Atlanta, GA Mar 2006 - Jun 2010

HR/Payroll/Client Service Software Analyst

• Responsible for providing accurate and timely analytical responses to end users utilizing Ceridian’s full Human

Resources, Payroll, Time and Attendance and other software applications.

• Provided practical application support, database design using relational database management systems (SQL).

• Provided SQL statements, Custom Crystal Reports, EZ Query, EasyAsk and Power Query reporting solutions.

• Provided technical support and training to HRIS users for problems related to Human Resources, Payroll, Payroll Tax,

Benefits and related accounting, retirement and time track systems interfaced with Ceridian’s HPL, HPW and HPS HRIS

platform. Manage clients HRIS related projects including system enhancements, implementations, upgrades, HR benefit

to payroll deductions interface and GL interfaces.

• Troubleshooting was primarily via phone using logmein123.com web sessions and periodic on-site client face to face

support. Managed customers back end changes and updates via Ceridian’s mainframe.

• Identified root causes for subjects of concern, developed solutions and recommended appropriate actions to prevent

recurrences. Guaranteed clients were in compliance with HR/Payroll federal, state and local regulations based on their

company’s requirements and system customizations.

• Used customer focused electronic communication devises to build customer confidence in Ceridian’s services and their

own ability to utilize Ceridian’s products and services.

• Assist client finance and IT personnel by providing systems interfacing assistance, payroll-funding details and

reconciliation of payroll bank accounts by researching and troubleshooting related HR Benefits and payroll issues.

BearingPoint Inc., Atlanta, GA Nov 2004 - Jan 2006

Financial Accountant - Accounting Operations

• Responsible for Account analysis and reconciling several balance sheet and income statement accounts including

researching and resolving all reconciling items.

• Bank reconciliation for cash accounts, including monthly accruals and adjustments. Responsible for reviewing accounts

ensuring all reconciling items are cleared within 30 days.

• Assist Manager in preparing variance explanations for month-end close.

• Prepare Financial Reports and analysis and ensure accounting activity is in accordance with GAAP compliances.

• Ensure accounting activity and practices are in compliance with Sarbanes-Oxley guidelines (SOX)

• Prepare and post month end journal entries via PeopleSoft.

• Utilize Microsoft Applications to perform daily task and duties

Great West Life Assurance Company/Canada Life, Atlanta, GA Oct 1994 – Feb 2004

Financial Analyst - Individual Life and Annuity Products Division Nov 1998 – Feb 2004

• Responsible for providing detail account analysis to management for reporting purposes.

• Prepared monthly Income Statements, Balance Sheets and Trend Analysis.

• Analyzing and explain variances, risks, and opportunities for all metrics, including but not limited to actual vs. forecast,

and budget vs. forecast.

• Prepared and analyzed monthly management reports of policy premium gain/loss activity.

• Balanced Master file accounting records to general ledger daily, identifying, researching and resolving major accounting

discrepancies.

• Master Balancing included reconciling balance sheet accounts back to source systems (including deposit, disbursement

bank and suspense holding accounts for 4 companies, as well as P & L and premium accounts).

• Due diligence for potential unclaimed property.

• Prepared and posted journal entries for monthly, quarterly, and year-end closings and accruals.

• Liaison between Business Units, IT and finance area to resolve accounting discrepancies.

• Address and spec out any accounting issues related to systems production and coordinate testing and implementation.

• Verify accounting files to the general ledger interfaced files before during and after system implementations.

• Assist IT with mapping and implementation of new general ledger system (Peoplesoft General Ledger).

• Tax reporting of 1099R’s and 5498’s.

• Manage contractual and fulltime staff.

• Instituted weekly balancing procedures to reconcile bank accounts

• Provided leadership and direction to administration staff to clear suspense and bank accounts

• Decreased cash account out of balance items from 840 to less than 100 items between September and year-end. Out of

balance exceeded $1 million dollars

• Established desktop manuals to improve time management and workflow

• Reviewed and tested accounting data for new products implementation

• Reconciled large cash and suspense out of balances

• Utilize excel pivot/v-look up tables, macros to analyze data as needed

Junior Financial Analyst - Payroll and Accounts Payable Department Oct 1994 – Nov1998

• Managed US division multi-state Payroll processing and associated accounting (including reconciling each pay to the

general ledger and wage garnishments) review and distribute W-2’s and W-2C’s for US division.

• Prepare relocation expenses and gross-ups, posted payroll entries to the general ledger. Reconcile 941 to the general

ledger,

• Provided monthly multi state budget variance reporting and analysis for 3 US division subsidiaries.

• Verify accounting files to the general ledger interfaced files before during and after system implementation.

• Prepared and maintain system implementation deliverables.

• Posted entries daily to the general ledger and reconcile company’s cash accounts including 3 sub companies.

• Issue disbursements, wire transfers, ACH’s and EFT’s on a daily basis.

• Supervise a 2 fulltime Accounting Specialist, 3 contractual staff and one part-time payroll analyst.

• Implementing a $50,000.00 Corporate Payroll System; annual cost over $150,000.00, (included payroll for 3

companies). Transferred payroll function from Toronto to U.S. home office.

• Reconciled payroll suspense account out of balance (balance in excess of $2,000,000.00). Reconciled travel suspense

account out of balance since 1991, reconciliation total exceeded $1,000,000.00

• Processed expense reports for US division travelers (3 divisions)

• Assisted in selecting bank reconciliation and accounts payable Dunn and Bradstreet, and Total Reconciliation Solutions

(T-Recs, Chesapeake system) to help organize and improve risk management for accurate financial reporting,

Platforms/Databases:

PeopleSoft 9.0, Oracle Hyperion ESSBASE (BSO and ASO), HFR, FDM, DRM, UPK and SmartView, ADP/PC Payroll and

ReportSMith Report Writer, Ceridian HR/Payroll Access SQL, Knowledge Base (KB), Legacy Mainframe, Cognos,

Microsoft Office Applications, T-RECS, LifePRO, Leverage, Ceridian Time Solutions/Integration of HR/Payroll and Time

Solutions, My Ceridian Solutions (Ceridian Security Manager, Service Assistant, Trial Payroll, and Enterprise Reporting),

Ceridian Payroll HR/PR SQL, HPW, HPL, InView Business Intelligence, SAP PHI

Education/Training:

• Strayer University, Bachelors of Arts Accounting major

• Minneapolis Community College, Associates in Arts Degree

• Oracle Hyperion HFR, FDM, DRM, UPK, Workspace and SmartView

• PeopleSoft8.6 - Advanced GL, GL and EPM Query writing, Hyperion, Hyperion ESSBASE, Hyperion Analyzer,

Ceridian Payroll HR/PR SQL, HPW, HPL, Auditing and Benefits Level I and II, Six Sigma White Belt Training

References are Available.

Contact this candidate