Oracle Manager

Adam Smith

Dallas, Texas

Cell Phone: 580-***-****

E-Mail: **************@*****.***

Web site: www.oraclehrguru.com

Overview

Adam has 12 years functional consulting experience with Oracle e-

Business Suite including Oracle Payroll, Oracle HRMS, Oracle i-

Recruitment, Oracle Manager & Employee Self-Service and Oracle Time

and Labor. He has performed several end-to-end implementations, as

well as providing post-production support, end-user training and

documentation, writing Oracle fast-formulas, year-end W-2

processing and reconciling payroll costing to the general ledger.

Additionally, he has more than 20 years experience in the Human

Resource/Payroll field performing diverse roles including Payroll

Coordinator, Business Analyst, Payroll Accounting Specialist, and

Senior Functional Lead consultant.

Application, Tools & Technical Expertise

Oracle e-Business Suite of Applications 10.7SC through r12.

. Oracle Payroll

. Oracle HRMS

. Oracle Manager & Employee Self-Service

. Oracle i-Recruitment

. Oracle Time & Labor

. Oracle Learning Management

Payroll, Recruiting and Time & Attendance software- Resume Mirror,

Ceridian, Genesys, PeopleSoft, Pro-Business, Kronos

Professional Summary

AST Corporation - Chicago, Illinois

1/14 - 5/14

Principal Oracle HRMS/Payroll consultant. Responsible for gathering client

requirements, performing gap/fit analysis. Presented workshops

demonstrating Oracle r12 payroll functionality. Configured Oracle to

process bi-weekly payroll for a public sector client employing 3,000

employees. Created to-be Visio process flows, wrote functional

specification documents related to interfaces and custom processes and

reports. Led a team of 4 super-users and subject matter experts.

Oman Oil Company Exploration & Production - Muscat, Oman

9/13 to 11/13

Lead functional consultant for an Oracle r12 reconfiguration project.

Reviewed functional requirements related to Oracle payroll, HRMS, I-

Recruitment, Time & Labor, and Manager and Employee Self-Service written by

a previous consultant. Created a functional gap analysis identifying gaps

between client's functional and technical requirements and standard Oracle

functionality. Conducted a Way Forward presentation for upper management

to present my recommendations and analysis of the requirements and current

processes. Made recommendations to senior management emphasizing

functionality available in the HCM modules that could be leveraged to meet

the company's expectation for rapid growth.

ClubCorp - Dallas, TX

1/13 to 9/13

Lead functional Oracle consultant for an Oracle 11i to r12 upgrade.

Performed all functional testing to ensure that the standard and custom

payroll processes and reports worked correctly after the upgrade to r12.

Validated payroll run results for six different bi-weekly payrolls.

Compared the payroll run results from the 11i payroll to the R12 payroll

identifying and resolving any discrepancies found in the validation.

Assisted the payroll department staff with payroll production issues.

Implemented functionality related to Pennsylvania Political Subdivision

codes. Performed tax balance adjustments to correct employee payroll

balances for Pennsylvania PSD withholding. Assisted in reformatting of

payroll checks using the Payroll Archive check style. Coordinated testing

of redesigned payroll checks and NACHA file with three different banks.

Wrote payroll fast formulas to create a custom skip rule and correct

deductions with a Total-Reached processing rule.

Matson Navigation - Oakland, CA

5/12 to 10/12

Lead functional Oracle consultant for an Oracle r12 payroll implementation.

Gathered requirements and configured Oracle module for several hundred

earnings and deductions, 28 payrolls and 4 GRE's. Conducted CRP1 and CRP2,

processing parallel payrolls for 20+ payrolls. Validated payroll run

results. Identified and corrected variances discovered through parallel

validation. Documented requirements and tested interfaces to load Kronos

and other third party time-keeping systems into Oracle through Batch

Element Entry. Identified issues related to HR employee data conversion

affecting parallel payroll. Loaded recurring employee earnings and

deductions using Batch Spreadsheet Interface process.

British Telecom - Atlanta, GA

12/2011 to 5/2012

Managed a 4 person payroll department processing payroll for 3500 U.S.

employees. Transferred employee masterfile and benefit deduction data from

the PeopleSoft Human Resource system to the ADP GlobalView payroll system

using a manual process consisting of ad-hoc queries, Excel macro

spreadsheets and dataloaders. Validated data from PeopleSoft and

GlobalView to ensure that all data transferred accurately. Cooperated with

ADP to resolve several outstanding service tickets that were unresolved for

2-3 months. Approved configuration change requests and custom report

requests. Responsible for the day-to-day activities of the payroll

analysts and tax analyst. Created training calendar to train Dallas new-

hires in preparation of moving the payroll department to Dallas.

Researched ADP GlobalView functionality to allocate employee wages to the

state in which the work was performed. Cooperated with Ernst & Young to

close State and Local tax accounts affected by British Telecom mergers and

acquisitions.

Nintendo of America - Seattle, WA

04/2011 to 10/2011

Implemented Oracle Payroll r12.1.3. Joined a project that was seriously

behind schedule and successfully implemented Oracle payroll for 8 different

hourly and salaried payrolls, consisting of 1500 employees. Wrote custom

fast formulas, performed functional configuration of payroll elements. Led

5 person team through Parallel Payroll Testing, User Acceptance Testing and

Go-Live. Responsible for testing mid-year payroll balance conversion.

Worked with technical developers to create custom XML direct deposit and

payroll checks. Performed balance adjustments to correct missing mid-year

payroll balances. Provided extensive post-production support and end-user

training.

Alpha Natural Resources - Abingdon, VA

10/2010 - 02/2011

Tested Family Pack K rollup patch, and Year-End patches to determine if

these patches introduced any issues with the client's current 11i instance

and custom payroll processes. Assisted client end-users in Oracle payroll

year-end processing and printing of employee W2's. Researched and resolved

issues related to data printing correctly on the employee W2's. Trained

client payroll business analyst in configuration and setup of new earnings

and deductions to record Long Term Incentive Plan payouts through

supplemental payroll processing. Instructed and assisted payroll

specialists in the recording of taxable and non-taxable moving expenses on

the employees' payroll record and W2. Created end-user documentation to

record process for recording taxable and non-taxable moving expenses.

Wrote skip rule fast formulas to correct issues related to recurring

deductions.

Glendale Community College - Glendale, CA

02/2010 - 07/2010

Performed requirement gathering, gap analysis and configuration for an

Oracle Time & Labor implementation at a Higher Education client. Analyzed

existing processes and mapped current processes to future processes in

Oracle. Researched and assisted developer in enabling multiple-assignment

functionality using the TimeKeeper Entry form. Configured OTL preferences

based on client's requirements. Added additional fields to the TimeKeeper

Entry form enabling costing information to be entered with the employee's

time. Defined earning rules to help eliminate keying mistakes made by

timekeepers.

Wendy's/Arby's - Atlanta, GA

10/2009 - 01/2010

Lead a 6-person team in validation of converted employee data for 70,000

employees, including employee federal and state tax records, recurring

earnings and deductions, direct deposit information, and salary.

Instructed payroll managers in use of dataloader to load salary changes for

parallel payroll processing. Researched and documented interfaces and

processes related to payroll. Assisted in conducting payroll test scripts

and creating test scenarios. Researched discrepancies identified in

parallel payroll processing.

Navilyst Medical - Glenns Falls, NY

7/2008 - 7/2009

Implemented Oracle Human Resources r12 and assisted in the configuration

and interface of Oracle HR to ADP payroll. Performed requirements

analysis, created AS-IS and TO-BE Visio diagrams, and performed design,

gap/fit, User Acceptance Testing and Conference Room Pilot for Oracle HR,

Learning Management and iRecruitment. Provided post-production support and

end-user training for Oracle HR and iRecruitment application. Assisted

technical developer with loading legacy HR data into Oracle utilizing API's

and DataLoader. Performed requirements analysis for Oracle Learning

Management for a medical device manufacturer requiring FDA validation.

Cooperated with FDA compliance consultants to identify OLM gaps within the

FDA compliance regulations. Documented AS-IS Visio process flows for the

legacy training system processes. Researched ability to include electronic

signatures within OLM application.

.

Burns & McDonnell Engineering - Kansas City, MO

9/2007 - 6/2008

Provided production support for a payroll department that had experience

huge turnover. Evaluated current processes and payroll setup, defined new

processes and corrected payroll setup to allow more accurate and efficient

processing of payroll, more accurate reconciliation of payroll benefit

deductions with the general ledger, and calculation of multiple involuntary

deductions using Oracle seeded functionality. Guided client through year-

end and W-2 processing, including filing of annual tax reports and

installing and testing Oracle year-end payroll patches. Created extensive

payroll training materials and provided issue resolution related to the

payroll process, payroll tax filing and payroll reconciliation

Owens & Minor Inc. - Richmond, VA

6/2007 - 9/2007

Performed lead role in implementing Oracle Payroll 11i. Created payroll

requirements documentation. Provided end-user training on setup of

earnings and deduction codes in Oracle. Presented functional demonstration

of Oracle payroll process end-to-end. Created estimated payroll processing

time document to assist in understanding the Oracle payroll process and

ability to meet deadlines for submitting check/deposit advice print file to

Ceridian. Documented payroll costing requirements. Defined payrolls,

payment methods, earnings, deductions, and Federal and State tax data in

Oracle.

Care One LLC - Fort Lee, NJ

10/2006 - 6/2007

Served as senior functional lead on a Oracle Human Resource implementation.

Gathered Human Resource Transfer, Employee Termination, and Creating Jobs,

Creating HR organizations and Salary increases. Prbusiness requirements,

lead discussions regarding design solution and best-practice setup and use

of Oracle application functionality. Created documentation outlining Human

Resource processes including New Hire, esented CRP demonstrations to client-

end users demonstrating human resource processes based on client design

solution and requirements.

Citizens Gas & Coke Company - Indianapolis, IN

01/2006 - 10/2006

Performed lead role in implementing Oracle Human Resource and Payroll

applications. Identified functional requirements, analyzed gap analysis,

created design documents, performed setup and user testing, and led end-

users through parallel payroll testing. Provided end-user training related

to Human Resource and Payroll processes. Assisted technical resource in

documenting and testing several complex payroll fast formulas. Created

form personalizations related to customizing self-service forms.

Oklahoma Department of Human Services - Oklahoma City, OK

8/2005 - 01/2006

Served as functional lead consultant in upgrade of Oracle Human Resouce and

Training Administration from 11.0.3 to 11i for a large, state government

agency. Tested functional processes after upgrade, researched issues and

resolved upgrade problems. Worked extensively with end-users to understand

new functionality and changes delivered with the Oracle Learning Management

application. Provided training to field staff and assisted in testing of

several custom forms and interfaces.

Zales Inc - Dallas, TX

12/2004 - 07/2005

Performed role as functional payroll lead implementing Oracle payroll for a

large multi-state client. Created functional design for interfacing check

and direct deposit output files to a third-party printing service.

Performed setup of all earnings, deductions, payrolls, costing and element

links. Mapped payroll balances for mid-year go-live. Provided end-user

training and assisted in unit testing. Provided fast formula instruction

to technical end-user. Assisted in creation of payroll fast formula design

and testing.

Solbourne Inc. - Denver, CO

02/2004 - 12/2004

Served as Oracle payroll lead on an Oracle 11i implementation.. Identified

payroll requirements, gap analysis, and solutions. Worked with payroll

department manager, General Ledger and Human Resources in the

implementation design of Oracle HRMS. Instructed and trained payroll

department manager in the set-up and design of payroll earnings,

deductions, and benefit elements. Created PTO accrual plans, researched

issues related to International and ex-pat employees Human Resource

information, and provided application expertise to end-users.

Dallas Independent School District - Dallas, TX

11/2003 - 02/2004

Performed W2 and year-end processing. Identified and corrected employees

with incorrect W2 tax balances. Analyzed employee information to identify

employees with incorrect or incomplete processes. Advised client on

methods to improve processing procedures. Created the Federal W2 magnetic

media file and the employees paper W2's. Assisted in the balancing of

Federal and State tax remittance reports. Created Discoverer reports to

identify employees wth W2 related issues. Reviewed setup and configuration

of the payroll application.

1

2 Smithfield Foods Inc. - Smithfield, VA

04/2003 - 10/2003

Served as lead Oracle payroll consultant for a two phase Oracle 11i

HRMS/Payroll implementation. Provided post production support for Phase 1,

including functional guidance and training to payroll and HRMS supervisors

and users. Implemented processing procedures, audit controls and reporting

procedures to ensure accurate payroll processing for several weekly

payrolls. Verified accurate configuration and set-up for Phase 2 earnings,

deductions and benefit elements. Created functional training guides for

end users. Responsible for parallel testing of Executive Salary payroll

containing extremely sensitive Executive salary information. Ensured

accurate processing of all payroll transactions including payroll

reversals, balance adjustments, costing processes, and quickpays.

Metalsa - Monterrey, Mexico

03/2003 - 04/2003

Provided direction to Oracle payroll 11i implementation. Performed

analysis on problems resulting from Global localization using Mexico and

U.S. business group legislation. Analyzed earning fast-formulas, third-

party payroll interface and functionality of Mexico templates created by

Oracle Consulting Mexico.

3 Saudi Business Machines - Riyadh, Saudi Arabia

11/2002 - 01/2003

Analyzed requirements for an Oracle payroll implementation using the Saudi

Arabia localization. Researched option of using both Arabic and English in

the HRMS/Payroll application. Evaluated possibilities of using Hijri

calendar date format, as well as the Gregorian calendar. Assisted in

creating proposal presented to client and ensuring realistic implementation

deadlines.

Laclede Gas Company - Saint Louis, MO

10/2001 - 10/2002

Evaluated and corrected an unsuccessful Oracle 11i payroll implementation

on a Windows NT operating system. Reviewed and corrected all existing set-

up including payroll calendar definition and salary basis. Created custom

salary and hourly wage elements, wrote custom fast-formulas for earnings,

deductions, informational elements and skip-rule processing. Implemented

seven separate payrolls, including union hourly, monthly and bi-weekly

salary, and qualified and non-qualified annuitant payrolls. Implemented

payroll costing and transfer of costing information to a Walker general

ledger system. Performed testing and validation of all employee earning

and tax balances loaded into Oracle payroll. Wrote instruction manuals and

presented end-user training for functional end-users in the Human Resource

and Payroll departments.

2

3 Burns & McDonnell Engineering - Kansas City, MO

01/2001 - 06/2001

Researched and corrected 2,000 employee W-2's. Identified errors in the

initial employee balance load converting employee payroll balances from

Legacy system to the Oracle Payroll 11i application. Researched and

implemented a process for reporting and submitting all bi-weekly, quarterly

and annual tax reconciliation for employee and employer tax liabilities.

Provided post-implementation support and training to functional end-users.

Identified and corrected several major issues resulting from improper

HR/Payroll setup or improper processing steps. Served as interim Payroll

technical analyst and liaison between functional end-users and the IT

department.

4 Modesto Irrigation District - Modesto, CA

07/2000 - 12/2000

Implemented Oracle Training Administration 11.0.3 for a semi-public sector

client. Performed all steps related to the implementation of the Training

Administration module, including the development of Business, Functional

and Reporting requirements, completion of Conversion requirements,

Requirements mapping, and the Design/Build phase of the OTA implementation.

Assisted the HRMS and Payroll module leads in the setup and testing of

the HR and Payroll applications. Assisted in the mapping of payroll tax

balances and initial balance loads. Prepared and presented end-user

functional training classes and documentation covering all topics related

to Oracle HR/Payroll. Supervised the manual conversion of all employee

data from the Legacy system into the Oracle HRMS module. Provided post-

production support for the Human Resource and Payroll departments.

Dallas County - Dallas, TX

05/2000 - 07/2000

Analyzed 7,000 employee organization determining the most effective means

of implementing the Kronos Workforce Timekeeper System. Assisted in the

research of all issues related to the connectivity and development of an

organizational-wide timekeeping system. Worked with Kronos account

managers to determine the optimal number of time clocks, software licenses,

and all related hardware/software. Involved in the creation of the

programming rules implemented in the Kronos time clocks and software

ensuring proper interfacing to the Oracle HR/Payroll module. Supervised a

ten-person team, delegating tasks and duties related to the creation of

test scripts and project related information requirements.

Northwest Arctic Native Alaskan Assoc.- Anchorage, AK

01/2000 - 03/2000

Provided payroll support for an Oracle 11.0.3 Payroll/HR implementation in

Anchorage, Alaska. Assisted client in the definition, set-up, and testing

of all earnings and deductions. Defined linking parameters for all

earnings. Tested costing at the element, assignment and paymix level.

Instructed client on proper set-up of several HR/Payroll tables including

the wage rate and worker's compensation rates and codes tables. Tested

earning and deduction elements through quick pay and assignment set payroll

processing. Trained client payroll staff on functional aspects of the

payroll process.

Excel Telecommunications - Dallas, TX

11/1999 - 01/2000

Assisted Payroll Manager in completing year-end special projects using the

Ceridian Payroll System. Audited relocation expense reports to determine

taxable or non-taxable status of reimbursed relocation expenses.

Calculated gross-up for federal, social security and Medicare taxes.

Researched posting of manual checks, stop pays and voided payroll checks on

the bank reconciliation report. Identified and corrected errors associated

with the bank reconciliation process.

Raytheon - Dallas, TX

05/1999 - 11/1999

Assisted as a team member in the implementation of PeopleSoft HRIS/Payroll

conversion for a large Fortune 100 company involved in the defense contract

industry. Verified data conversion, researched variances and assisted in

the resolution of data conversion problems. Assisted in parallel testing

and post-implementation verification. Provided research for the payroll-

processing department in resolving employee questions and errors in

paycheck data.

JPI Partners, Inc. - Las Colinas, TX

11/1998 - 05/1999

Served as back up to the payroll manager in a four-person department

producing a multi-state payroll on the Oracle HR/Payroll System.

Interfaced payroll and benefit costing to the general ledger. Prepared

journal vouchers to correct any discrepancies or retroactive changes, which

posted to the general ledger. Transmitted electronically all payroll ACH

files, verifying receipt and accuracy of these files. Reported all federal,

state and local taxes electronically to Pro-Business on a weekly and

quarterly basis. Served as Oracle system expert, providing testing and

problem resolution. Prepared instructional documentation of payroll

processing procedures.

Tenet Healthcare, Inc. - Dallas, TX

03/1997 - 11/1998

Provided complete Genesys payroll system support to approximately 200

hospitals nationwide employing over eighty thousand employees. Resolved

inquiries from hospital payroll staffs concerning all aspects of payroll

including: time clocks, detail time records, manual checks, adjustments

and corrections to payroll, garnishments and levies, weekly and monthly

reports, etc. Researched and tested all changes made to mainframe

programs. Provided comprehensive help desk support to hospitals using an

in-house developed payroll system interface. Verified transmission and

receipt of payroll information and ensured accuracy of payrolls.

U.S. Marine Corps - Marine Corps Base Kaneohe Bay, HI

11/1988 - 11/1994

Completed six years honorable service as a military payroll specialist.

Prepared and audited payrolls for 3,000 personnel. Calculated daily

special payments and applicable federal and state taxes. Audited personnel

financial records to ascertain proper credit and debit of pay and

entitlements. Researched and corrected pay and benefit errors. Reviewed

monthly and annual state and federal tax withholding to correct tax

liability.

Education

Bachelor of Science; Business Administration Hawaii Pacific University,

Honolulu, Hawaii 1995

Certifications and Awards

Non-Commissioned Officer of the Month

Non-Commissioned Officer of the Quarter

Commanding General's Honor Roll

Commanding General Certificate of Commendation

Rotary Club International Exchange Student

Contact this candidate