SUMMARY

• 15 years of hands - on Oracle Apps and 7 years Kronos support. Strong technical and functional knowledge from Oracle & Kronos courses and hands-on experience utilizing the training.
• Project lead performed setups for Oracle EBS implementations of:
• Benefits (OAB),
• Timesheets (OTL) and
• Self Service (SSHR), EE & Mgr
• Payroll Tax Interface, ADP Transporter (Oracle AIM Methodology: CR010 PMP, RD020, BR010, MD050, MD070, BR100, PM010, CV060.)
• HCM support for Oracle EBS versions 12.3, 11i & 11.0 Payroll (incl Costing, Retro), Benefits, SSHR and HR
• Payroll Setup, customization of Payroll formulas, functions, elements, 401k/Roth, Costing, Retro, FIT SIT Local/School Tax, Acquisitions, Year End Patches, W2 rules for GRE, Setup Payroll tax Withholding for new state.
• HR Setup EIT (Visa Details, Expiry Date, US Ethnic Origin), SIT (Citizenship Code, Country of Citizenship), Organization/GRE/Legal Entity.
• Spec’d CV060 for Confidential file update of EBS using PGP & SFTP.
• Expert knowledge of Oracle 12.3 HCM tables, having developed hundreds of views and PL/SQL functions used within Oracle .rdf reports and Discoverer end user queries.
• Lead of Kronos 5.2 implementation of Discrete Manufacturing time tracking.
• Developed the Oracle HR Employee and Payroll BEE views used in the Kronos interfaces.
• Performed the first 2 annual Open Enrollment updates of rates and plans, working directly with the Benefits Manager, and ran all open enrollment processes in Oracle Advanced Benefits.
• Taught the first 4 Discoverer classes for HR, Accounting and Tax departments from customized training material which was developed to present the basics within 2 hours.
• HR Lead for Oracle EBS Rollouts to over 10 countries, setup each of the 10 Oracle Business Groups and developed and ran the PL/SQL programs for the employee/job load using APIs
• Lead 3 Oracle IT MFG Analysts for daily support and rollouts of Purchasing, Order Management and Inventory to major international operations.
• HCM Lead / Senior Analyst of multi-national EBS, 15 years
• Advanced Benefits implementation and support, 3 years
• Time & Labor (Timesheets) implementation and support, 2 years
• HRMS Self Service implementation and support, 2 years
• Oracle Applications HR and Payroll support,12 years
• Oracle AIM Methodology: CR010 PMP, RD020, BR010, MD050, MD070, BR100, PM010 etc., 15 years
• Lead of Oracle Applications IT Mfg. support, while performing as Lead HCM Analyst,10 years
• Implemented ADP Transporter to replace Custom ADP Tax Interface
• Implemented Affordable Care Act within OAB defining requirements and gaps with Benefits Manager
• Setup over 20 Business Groups for multi-national Oracle Applications rollouts of FIN, MFG, HR
• Lead/Sr Analyst for Kronos Discrete Mfg. & Oracle Payroll BEE implementation and support

TECHNICAL SKILLS

Software: PL/SQL, Reports 2.5/ 3.0, Forms 4.5 (light), SQL Loader, SQL Plus, System Administration, Workflow, Flex Fields, Polaris, Discoverer

RDBMS: Oracle 8, 9, 10; MS SQL Server, Sybase

Operating Systems: HP UNIX, Oracle Linux, Sun Solaris 2.5 UNIX

Microsoft: Word, Excel, PowerPoint, Outlook, Microsoft Projects, SharePoint

Oracle Applications, R elease 12.1.3: Oracle Advanced Benefits,Oracle Time & Labor, Oracle HR Self Service (MGR & EE), Oracle Advanced Supply Chain Production, Oracle Production Scheduling, Oracle DemantraPurchasing

PROFESSIONAL EXPERIENCE

Confidential

Oracle Payroll Consultant Supporting

Responsibilities:

• Modified Element Formulas for Defined Benefit Plan, 415(c)
• Analyzed issues with Health, Dental, and Vision Effective Dates to Benefit Vendors
• Modified view of Banking Info Audit Report
• Developed custom SQL to produce EOCR file for OFCCP Audit
• Modified SSHR-EE OAF Personalization’s to disable updates to Bank Account No. on the "Update Deposit Payment" screen.
• Analyzed Errors in Benefits file to Carrier: In Benefits Service Center Children were checked as Covered but in HR, children weren’t setup as designated dependents.
• Analyzed interface file PL/SQL issues & updated CV060 spec for Benefits file to Carrier,Earnings file to 3rd Party, Pay Vendor Outbound file
• Spec'd CV060 UNIX & PL/SQL for Confidential interface that updated SIT with APPS.hr sit api.
• Copied our PGP & SFTP keys to Equifax & their PGP key to DBA.
• Spec'd Custom Updates After Year End 2018 Patching:
• Payroll Check, NACHA Process Parameters, Timecard Approval Workflow & Timekeeper form
• Modified Discoverer view & Compensation Discoverer reports
• Modified Setup of Retirement Element Tax Category to "State Retirement (Defined Contribution Plan)".
• Included Setup new Balance Feeds, process Balance Adjustments with BBA. Developed custom Excel Spreadsheet of SOE to calculated expected values after BBA.
• Modified CV060 Specs for Payroll processing of new state:
• Setup new Segment in DFF Additional Personal Details for "Tax Home Address" Modified CV060 Spec for SQWL report to run for any state, one at a time.
• Added parameter “State to Report”; modified 5 cursors to use parameter; Modified file name to append ST parameter at end
• Modified CV060 Spec to process for Home State if Taxation Address isn’t set; modified two PL/SQL cursors.
• Setup Tax Home State DFF
• Setup Element Links to SIT RS & City WK for new location and new acct string
• Created CV060 specs for Workday-to-Oracle EBS:People & Assignment, Telephones & Salary Interface
• Modified Workday-EBS interface PL/SQL to process:
• New Hire, Rehire, Add Assignment, Add Goal Pay (Workday Pay Activities),
• Replace Primary or Secondary Assignment, Terminate Secondary Assignment,
• Terminate Employee, Update Employee, Update Assignment, Update Salary,
• Update Address.
• Oracle API's used in PL/SQL: hr employee api.create us employee, HR EMPLOYEE API.HIRE INTO JOB, hr employee api.re hire ex employee, hr person api.update us person, hr assignment api.create us secondary emp asg, hr assignment api.update us emp asg, hr assignment api.update emp asg criteria, hr assignment api.set new primary asg, hr person type usage api.update person type usage, hr ex employee api.final process emp, hr assignment api.actual termination emp asg, hr position api.update position, hr person address api.cre or upd person address, hr maintain proposal api.insert salary proposal, hr phone api.create or update phone

Confidential

Oracle Payroll Consultant Supporting

Responsibilities:

• Consultant of best practices for Payroll AME controls of Location Updates in MSS & iReq.
• Analysis of HAS mapping to W-2
• UAT for Mass Reorg Updates
• Custom SQL to list comparison of last year vs current SUI rates
• Custom SQL to list Employees by Accounting Rollup
• Custom SQL to list Assignment Actions by Login ID
• Used Security Role to setup Output Sharing for US Payroll Manager in R12.3.

Confidential, Houston TX

Lead HCM Support/ Lead MFG Support/ Financials Support

Responsibilities:

• Directly Supported Oracle HCM and Lead Oracle IT Mfg Support; direct report managed Oracle FIN Support.
• Provided HCM support working directly with Benefits Manager, Payroll Manager & HR Manager.
• Worked with Benefits Manager to gather requirements for annual Plan adjustments and rate updates.
• Personally defined and performed setup updates in OAB using DataLoad for rates.
• Accomplished Oracle R12 Upgrade: directly upgraded HCM and managed staff that upgraded MFG & FIN
• Lead for the following implementations: Advanced Benefits (OAB), Time & Labor (OTL), HRMS Self Service (SSHR) (using AIM and support), and Kronos upgrade to 6.2 HR-to-Kronos and Kronos-to-BEE Payroll interfaces
• Implemented Oracle Advanced Benefits, OAB, in production with consultants BR100
• Updated and setup new OAB programs, plans, life events and rates in preparation for Open Enrollment
• Updated OAB US & INTL Plans for annual changes, including Affordable Care Act compliance
• Developed OAB DataLoad programs and ran to load Rate Updates
• Ran "Open" Life Event for OAB US & INTL Open Access Processes
• Implemented Oracle SSHR (self Service) and OTL (Timecards), in production with consultants BR100s
• Developed views to join the SSHR tables with standard HR tables for Discoverer Audit Reports of Self Service
• Manager transactions and all approvals to final saving of HR table updates of Salary, Job, Supervisor, etc
• Developed and ran DataLoad program to load US Employee Categories into Oracle HR
• Developed DataLoad programs to load Performance Appraisals into Oracle HR from Excel files
• Developed PL/SQL API programs to reload Canada employees into new Business Group.
• Project Manager for Oracle Mandatory End of Year Patches
• Setup new 401k Plan 2010 with Catchup, Roth and Roth Catchup
• Implemented Quarterly ADP Transporter Updates
• Developed Oracle PL\SQL API Loads to update all US Jobs to add new Job Code and Position Category
• Modified Job KFF to add Job Code and Position Category
• Setup multiple Benefits and Payroll Elements, including Balance Loads with Oracle APIs
• Setup multiple US & INTL Jobs (KFF and JOB table)
• Setup Business Groups for Implementation of Financials, HR & Purchasing in 23 Countries
• Developed views to join the Purchase Order Approval setup tables with Set Of Books & Operating Units
• Responsible for Oracle User tables for Discoverer Audit Reports of PO Approval Limits by Business Unit
• Project Lead Oracle IT R12 HR and Mfg Upgrade; personally performed R12 HCM setups in Production.
• Project Lead of Kronos HR Interfaces Upgrade to 6.2
• Modified Purchasing Approval Workflow to return any PO under $100K that was forwarded to COO.
• Project Manager of Canada Reimplementation of Discrete Mfg, Purchasing & HR Employees
• Developed views to join the Purchase Requisition tables with Purchase Order tables for Discoverer Audit
• Reports of PO Req transactions and all approvals to final saving in PO tables.

Lead HCM Support/ Lead MFG Support/ Financials Support

Responsibilities:

• Implemented ADP Transporter to replace Custom ADP Tax Interface
• Developed interface from Oracle HR Vacancies to Core Lab Web Job Applicant System
• Setup 8 New Vacation Plans that reset balance on Hire Date Anniversary
• Setup new 401k Plan 2009 with Catchup
• Project Manager for multi-national User Testing of Oracle Mandatory End of Year Patches.
• Included development of Microsoft Projects plan and reporting of CRP-1, CRP-2.
• Modified Oracle Payroll Advice and Optio report
• Implemented Quarterly ADP Transporter Updates
• Modified Oracle Payroll Check, Advice & 3rd Party Check, rdf and Optio report
• Updated Oracle HR Workers Comp Codes and Rates
• Setup multiple Payroll Elements, including Balance Loads with Oracle APIs
• Upgraded Oracle HRMS from 11.0 to 11.5.10.2
• Setup Employee Performance Tracking within Oracle HR Reviews
• Setup Leadership Course Tracking within Oracle HR Qualifications
• Developed multiple Discoverer reports, views and folders for HR
• Developed PL/SQL with APIs to load Date First Hired for all US employees into Oracle HR
• Setup multiple US & INTL Jobs (KFF and JOB table)
• Developed COP Oracle HR Employee & Job Loads with Oracle APIs for Purchasing
• Prepared and Delivered Discoverer End User Training to CORP HR and ACCT
• Setup 5 Business Groups for Implementation of Financials (SEK, INR, FIE, VEF and MTE)
• Lead for staff of 3 for Kronos 5.2 Implementation of Mfg Activities WO/WIP Interfaces and HR/BEE Payroll Interfaces
• Personally designed and programmed the Oracle HR-to-Kronos and Kronos-to-BEE Payroll views
• Lead of Oracle Application Mfg. IT Support Staff

Senior Oracle Analyst

Responsibilities:

• Sole Oracle IT analyst supporting HCM; worked directly with Payroll Manager 80% of the time to define requirements, design solutions and define user test plans and test cases for standard and “tricky” payroll elements.
• Ran all 4 payrolls in test to ensure accuracy of modifications and Oracle Year-End patches.
• Setup all new payroll elements and 401k plans, “Grandfather” vacation and sick plans for employees of acquisition companies.
• Worked with Benefits Manager and HR Manager to complete Year-End Oracle Processes.
• Worked with the HR Department to move them into ownership position of Oracle HCM modifications as opposed to working with Oracle IT Support to apply updates to production.
• ADP Transporter Tax interface implementation from Oracle Payroll
• More than 3 401k systems (incl Roth 401k, Catchup) implementations
• More than 6 new Vacation & Sick Accrual Plans implementations
• Project Manager for Oracle Mandatory End of Year Patches
• Setup Company Car Payroll Element
• PL/SQL API development loading Oracle HRMS employees, jobs and supervisors for over 10 countries
• Implemented Applicant Tracking within Oracle HR, interfaced with public web site
• Leadership Course Tracking implemented within Oracle HR Qualifications module
• Implemented Oracle Performance Appraisals within Oracle HR, Developed DataLoad programs
• Setup Degree and Certification tracking within Oracle HR
• Implemented Discoverer for Oracle Human Resources and Payroll
• Developed hundreds of custom SQL views and PL/SQL functions for Discoverer HR & ACCT
• Prepared and Delivered Discoverer End User Training to CORP HR, ACCT and INTL
• Developed PL/SQL APIs for CA, NL, UAE, UK & MXP Oracle HR Employee & Job Loads for Purchasing
• Setup multiple US & INTL Jobs (KFF and JOB table)
• Updated Workers Comp Codes-Rates
• Developed Discoverer vacation accrual views and reports for Accounting