EBS HR/HCM Consultant at Splash BI · Hyderabad · 4 - 10 years · ₹6L - ₹15L / yr · Profitable · Posted 30 May 2024

Responsibilities
• Should be able to understand functional & technical requirements from business and come up with solutions.
• Development, Support, Debugging and troubleshooting of the existing developed applications (Forms, Reports, Interfaces etc.).
• Should be able to configure Oracle EBS/Cloud including the configuration of Business Processes and security.
• Integrations of customized applications with Oracle standard applications modules.
• Should be very strong in SQL and strong in PLSQL (especially Packages, Procedures and Functions).
• Database structure design for Tables, views, sequences, synonyms, and database triggers etc.
• Training users/BSAs when required & preparing technical documentation.
• Ensure customer satisfaction, Self-drive and perform duties with minimal supervision.
• Ensure tickets are resolved within SLA’s and assignments are completed within the agreed deadlines
• Good enough to understand the existing PLSQL packages/procedures/functions and modified / create new ones as needed.
• Ability and willingness to stay updated with the latest developments and updates in Oracle Fusion technologies and best practices.
Requirement:
• 4+ years of Technical or Techno-Functional experience in Oracle EBS R12/Cloud Applications on Oracle HR/HCM (Any Modules in HR), SQL/PLSQL.
• Good experience with HR/HCM (Any Modules in HR) is a must and should understand the functionality.
• Should be able to understand (Any Modules in HR) data model and should be quick enough to switch from one product to another product easily.
• Ability to develop custom solutions, extensions, and integrations to meet specific business requirements.
• Proficiency in creating custom reports, dashboards, and analytics using Oracle BI Publisher, Oracle OTBI (Oracle Transactional Business Intelligence), and other reporting tools.
• Knowledge of security models, user roles, and access controls within Oracle Fusion applications to ensure data integrity and compliance.
• Strong analytical and problem-solving skills to identify and address technical issues, system errors, and integration challenges.
• Good to have experience in Performance tuning techniques.
• Effective communication skills at all organizational levels, including written, oral, and presentation skills.
• Should be a good team with can do attitude.
• Capability to switch and willingness to work in any of the technologies as per the need basis.
• Should have a good understanding in working with onsite-offshore model.

About Splash BI
About
Connect with the team
Similar jobs (2)
We are looking for an experienced Oracle EBS Techno-Functional Consultant specializing in Oracle Projects (Project Costing, Project Billing, and Project Management), to support and maintain enterprise Oracle EBS applications. The ideal candidate will have a strong blend of functional expertise in project accounting processes and technical skills to independently troubleshoot, customize, and enhance the application, ensuring smooth day-to-day operations in a production support environment.
Key Responsibilities
Functional
- Provide L2/L3 production support for Oracle Projects (PA) module, covering Project Costing (PC), Project Billing (PB), and Project Management (PM) processes.
- Act as the primary point of contact for Project Managers, Finance, and Delivery teams, leading root-cause analysis and resolution for complex incidents.
- Configure and maintain PA setups: Project Types, Project Templates, Task Structures, Costing/Billing Rules, Burden/Overhead structures, Rate Schedules, Agreements, and Funding.
- Support integration points between Oracle Projects and other modules (GL, AP, AR, HR/OTL, PO, FA) for cost/labor/expenditure flows.
- Troubleshoot issues related to Cost Distribution, Cross-Charge/Inter-company billing, Revenue Recognition, Invoice Generation, and Project-GL/AR interfaces.
- Support project close, period close, and cross-period adjustment processes; resolve exceptions in cost/revenue/billing distribution.
- Manage transaction import failures (Cost Collector, Transaction Import), unprocessed transactions, and expenditure batch errors.
- Prepare functional design documents (FDD/MD-050) and test cases (test scripts, UAT support) for enhancements/patches.
- Ensure compliance with SLA/OLA for ticket resolution (incidents, service requests, minor enhancements).
- Support statutory/regulatory and client-specific billing/revenue recognition compliance requirements.
Technical
- Analyze and resolve complex issues related to interfaces (Transaction Import, Cost Collector, Labor/Usage/Expense Report Interfaces), conversions, and custom reports impacting Projects.
- Develop/debug PL/SQL procedures, packages, and triggers for PA-related customizations and data fixes.
- Work on Oracle Workflow (Project/Budget/Invoice approval workflows), Oracle Alerts, and Application Object Library (AOL) objects.
- Support and troubleshoot BI Publisher (BIP)/XML Publisher reports, project status reports, billing/invoice formats, and custom PA reports.
- Perform back-end data fixes/updates (with due approvals) for stuck transactions, failed cost distributions, or interface errors.
- Coordinate with DBA/Infra teams for patches, cloning, and environment refresh activities impacting Projects module.
- Prepare and maintain Technical Design Documents (TDD/MD-070) for custom objects and interfaces.
- Mentor junior consultants on technical troubleshooting and PA functional processes.
Support Process & Governance
- Log, track, and manage tickets via ITSM tools (Zendesk, Remedy, JIRA, etc.).
- Participate in on-call/rotational support.
- Adhere to and help enforce change management (CR) and incident management processes.
- Provide RCA (Root Cause Analysis) documentation for recurring/critical issues.
- Drive knowledge base (KB) documentation and continuous process improvement initiatives.
Job Description – PeopleSoft Technical Consultant
Role: PeopleSoft Technical Consultant
Experience: 6–11 Years (as per requirement)
Primary Skills: PeopleSoft Technical Development, Integration Broker, Oracle Database, SQL, PL/SQL
Job Summary
We are looking for an experienced PeopleSoft Technical Consultant with strong expertise in PeopleSoft development, Integration Broker, Oracle Database, SQL, and PL/SQL. The candidate should have hands-on experience in developing, customizing, integrating, and supporting PeopleSoft applications, along with troubleshooting technical issues and optimizing application performance.
Key Responsibilities
- Design, develop, customize, and maintain PeopleSoft applications based on business requirements.
- Hands-on experience in PeopleSoft technical development, including Application Engine, PeopleCode, Component Interface, and SQR.
- Develop and maintain integrations using PeopleSoft Integration Broker.
- Configure and manage Integration Broker services, service operations, handlers, routings, and nodes.
- Develop and troubleshoot synchronous and asynchronous integrations.
- Work extensively with Oracle Database, SQL, and PL/SQL.
- Create and optimize SQL queries, stored procedures, functions, triggers, and packages.
- Perform debugging, performance tuning, and production issue resolution.
- Work on PeopleSoft customizations, enhancements, interfaces, and reports.
- Collaborate with functional teams and business stakeholders to understand requirements.
- Support PeopleSoft application upgrades, patches, testing, and deployments.
- Prepare technical documentation and support unit, integration, and regression testing.
Mandatory Technical Skills
- PeopleSoft Technical Development
- PeopleCode
- PeopleSoft Integration Broker
- Application Engine
- Component Interface
- SQR
- Oracle Database
- SQL and PL/SQL
- REST and SOAP Web Services
- PeopleSoft Application Troubleshooting







