Oracle EBS R12 HCM & Payroll Techno-Functional Consultant

Oracle EBS R12 HCM & Payroll Techno-Functional Consultant - Louisville, KY (Remote) .

Please check the PL/SQL code writing proficiency, as person needs to be strong in that.

Also payroll/W2/pay slips functional knowledge as well.

About the Role:

We are seeking a senior Oracle E-Business Suite (EBS) R12 HCM & Payroll Techno-Functional Consultant with deep expertise across EBS HCM modules, US Payroll, Absence, W-2, Fast formulas, Accrual Calculations, Concurrent Programs, Pay Run Results, US Tax, Payroll Data Marts, and strong technical skills in PL/SQL, Shell scripting, Reports, Forms, and BI/XML Publisher.

The role includes full-cycle implementation work, solution leadership, troubleshooting, documentation, and cross-functional collaboration.

Key Responsibilities:

• HCM, Payroll & Performance Management (Techno Functional).

• Implement, configure, and support Oracle EBS R12 HCM modules, including Core HR, Payroll, and Absence.

• Manage end-to-end US Payroll configuration (earnings, deductions, tax rules, balances, costing, retro calculations).

• Deliver statutory payroll outputs: W-2, Pay Slip, Statement of Earnings.

• Support integration with GL, AP, and other systems; perform requirements gathering, UAT, issue resolution, and user documentation.

• Develop advanced PL/SQL programs (packages, functions, ETL, performance tuning).

• Experience in shell scripts and generating PDF files using the PL/SQL Packages.

• Configure, schedule, and troubleshoot Concurrent Programs (PL/SQL, host/shell, Request Sets).

• Thorough knowledge of US Payroll Processes and Reports.

• Develop reports using BI/XML Publisher, Oracle Reports, and Oracle Forms.

• Create Shell scripts for automation, payroll processing, integrations, and archival flows.

• Build integrations using APIs, Open Interfaces, SFTP, and custom RICEW components.

• Data, Reporting & Data Mart Development.

• Design and implement a Payroll Historical Data Mart for historic balance snapshots, multi-period analytics, and retro/true-up history.

• Build ETL processes using EBS core payroll tables (PAY_BALANCE_VALUES, PAY_RUN_RESULTS, HR/PER tables).

• Deliver high-performance reporting for Finance, Audit, and HR analytics.

US Tax & Payroll Reporting, Compliance:

• Deep knowledge of US Payroll tax regulations (federal, state, local).

• Support tax updates, regulatory patches, and year-end balancing/W-2 processes. Support, Integration & Lifecycle Management.

• Root cause analysis, troubleshooting, and performance optimization.

• Perform UAT, regression testing, and multi-environment migrations.

• Deliver end-user training and create SOPs, process maps. Archival & Data Governance.

• Implement payroll data archival strategies and retention policies.

• Ensure compliance with audit, SOX, and data governance requirements.

Required Qualifications (Must-Have)

• 7+ years of Oracle EBS R12 HCM & Payroll techno-functional experience.

• Deep understanding of Oracle EBS HCM modules (Core HR, Payroll, Absence, Performance Management).

• HRMS Fast Formulas (Payroll & Absence) creation, debugging, and maintenance.

• End-to-end Oracle EBS full-cycle implementations.

• Strong expertise in US Payroll, including configuration, processing, and compliance.

• Strong knowledge of Pay Run Results and related payroll tables.

• Ability to extract W-2 information from the EBS Tables.

• Ability to extract data from the Pay Result tables or do reporting on the US Statement of Earnings.

• Advanced PL/SQL, SQL tuning, and Shell scripting skills.

• Knowledge of Payroll, HCM Tables and stored procedures

• Expertise in Concurrent Programs, BI/XML Publisher, Reports, and Forms.

• Ability to design and implement Payroll Data Marts and analytics pipelines.

• Solid understanding of US Payroll Tax regulations and statutory updates.

• Excellent problem-solving, analytical, communication, and interpersonal skills.

• Excellent Report Writing using BI Templates.

Nice to Have

• Oracle APEX Report Development.

• Integrations via OIC, Object Storage, Data Bricks, or other downstream systems.

• Exposure to hybrid EBS-Cloud HCM transformation projects, Data Archival Projects