Oracle Ebs Hrms Technical Consultant

• Analyze functional specifications for HR, payroll, and time and labor processes and translate them into technical designs.
• Develop and maintain customizations for Oracle EBS HRMS modules, including Payroll and OTL, using PL/SQL, Oracle Forms, Oracle Reports, and Oracle Application Framework (OAF).
• Build and enhance Oracle Payroll fast Formulas (element input validation, skip rules, proration, formula results, and balance calculations).
• Develop OTL technical components, including timecard layout extensions, HXC/HXT time entry rules and validations, retrieval rule extensions, and time transfer processes to Payroll (BEE, Payroll Retro-Notification).
• Design and develop inbound and outbound interfaces (time clock integrations, bank and payment files, GL and costing interfaces, third-party benefits and statutory feeds) using PL/SQL, concurrent programs, SQL*Loader, UTL_FILE, and web services.
• Build data conversion and migration programs for employees, assignments, elements, balances, and historical time data, including validation and reconciliation scripts.
• Develop and customize Oracle Workflow components for timecard approvals, notifications, and HR processes.
• Create and tune reports (BI Publisher/XML Publisher, Oracle Reports) for payroll registers, statutory reporting, time summaries, and audit needs.
• Implement HRMS security-related technical components, including custom security profiles, responsibility and data access controls, and API-based user provisioning.
• Use seeded HR APIs (e.g., hr_assignment_api, hr_person_api, element entry APIs) in place of direct table updates, in line with Oracle best practices.
• Troubleshoot and resolve production issues, including failed payroll processes, transfer errors, interface failures, and performance bottlenecks, with documented root-cause analysis.
• Prepare technical design documents, unit test scripts, deployment instructions, and support runbooks, and conduct knowledge transfer to support teams.
• Follow development standards, version control, and migration processes across environments.

• 10+ years of hands-on technical development experience with Oracle EBS (R12 or later), with a significant focus on HRMS.
• Strong command of PL/SQL, including packages, procedures, triggers, APIs, and SQL performance tuning.
• Proven experience with Oracle Payroll technical development, including Fast Formulas, element and balance setup impacts, payroll process troubleshooting, and costing and payment interfaces.
• Hands-on experience with Oracle Time and Labor (OTL) technical components, including timecard layouts, time entry rules, approval workflows, and the transfer of time to Payroll.
• Working knowledge of Core HR data model and APIs (people, assignments, organizations, absence management).
• Experience with Oracle Workflow Builder, BI/XML Publisher, Oracle Forms and Reports, and concurrent program development.
• Experience building interfaces and conversions, including file-based and API-based integrations.

Cloud BC Labs Inc is a digital transformation organization aimed at creating seamless solutions for clients to effectively manage their business operations. The company specializes in Business and Management Consulting, AI/ML, Data Analytics & Visualization, Cloud Data Warehouse Migration, Snowflake Implementation, Informatica Implementation & Upgrade, Staffing Services and Data Management Solutions