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

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

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.

ConfidentiaI

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.

.

Confidential 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

ConfidentialPerformed 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.

Confidential 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.

Confidential 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.