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 (6)
Oracle Planning Functional Analyst
6 + years
Duration - 6 Months
Need min 6+ years of experience in implementing Oracle Fusion Cloud Planning solutions. Candidates should have strong expertise in Supply Planning, Demand Planning, and Supply Chain Planning (SCP), along with hands-on experience integrating Planning modules with other Oracle Fusion applications. The ideal candidate should have implementation experience, strong business process understanding, configuration and testing expertise, and the ability to translate business requirements into effective planning solutions. Exposure to SQL/PLSQL and Oracle SCM processes is preferred.
Planning roles:
2:00 PM to 11:00 PM IST during the U.S. Daylight Saving period (approximately March to early November each year) / 3:00 PM to 12:00 Midnight IST during the non-Daylight Saving period (approximately November to the end of February each year).
Job Description — L2/L3 Oracle DBA and Oracle Apps DBA
Experience: 5–10 years of relevant experience
Support coverage: Dubai customer business hours and on-call support as required
Role Overview
We are seeking an experienced Oracle DBA and Oracle Apps DBA to support
customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role
involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,
upgrades, and maintaining database and application availability.
Key Responsibilities
Oracle Database Administration
∙Install, configure, administer, and maintain Oracle databases across
production and non-production environments.
∙Monitor database health, availability, performance, storage, and capacity.
∙Troubleshoot database incidents, connectivity failures, locking, blocking, and
resource issues.
∙Analyse AWR and ASH reports, SQL execution plans, and database wait
events to resolve performance problems.
∙Configure and manage RMAN backups; perform recovery and restore
validation.
∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard
environments.
∙Perform database patching, upgrades, migrations, and refreshes through
approved change procedures.
∙Manage database users, roles, privileges, auditing, and security controls.
∙Execute disaster recovery drills, Data Guard switchovers, and failovers.
∙Automate routine administration and monitoring using shell scripts and SQL.
Oracle Applications DBA
∙Administer Oracle E-Business Suite R12.2 application and database tiers.
∙Monitor and troubleshoot concurrent managers, concurrent requests,
Workflow Mailer, application services, and login issues.
∙Perform EBS online patching using ADOP and manage the associated
patching lifecycle.
∙Clone and refresh EBS environments using supported tools, including Rapid
Clone.
∙Maintain application configuration using AutoConfig and context files.
∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms
services.
∙Troubleshoot application-tier performance and coordinate with functional
and development teams.
∙Support EBS upgrades, technology-stack patches, certificate renewals, and
integration-related incidents.
∙Maintain operational procedures for application startup, shutdown, backup,
recovery, and maintenance.
L2/L3 Support and Customer Operations
∙Own incidents and service requests within agreed SLAs.
∙Provide L2 troubleshooting and escalate complex issues with complete
diagnostic evidence.
∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.
∙Support major incidents, communicate progress, and document recovery
actions.
∙Raise and manage Oracle Support service requests.
∙Prepare change plans, risk assessments, validation steps, and rollback
procedures.
∙Maintain runbooks, knowledge articles, configuration records, and shift
handovers.
∙Coordinate with customer teams and internal infrastructure, storage,
network, and application teams.
∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.
Required Skills and Experience
∙Hands-on production experience administering Oracle Database, including
Oracle 10g, 11g, 12c, 18c and 19c.
∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.
∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and
Oracle Fusion Cloud PPM Functional Consultant – Onsite
We are seeking an experienced Oracle Fusion Cloud PPM Functional Consultant to implement, configure, and support Oracle PPM modules. You will gather business requirements, perform fit-gap analysis, and ensure seamless integration across Oracle financial systems.
Key Responsibilities
- Implement, configure, and support Oracle Fusion Cloud PPM modules including Project Costing, Billing, Contracts, and Financial Management.
- Gather business requirements, conduct fit-gap analysis, and prepare functional design and solution documents.
- Configure project accounting, budgeting, costing, billing, revenue recognition, and capitalization processes.
- Ensure seamless integration between Oracle PPM and Oracle Financials modules (GL, AP, AR, FA).
- Support end-to-end implementation activities including CRP, SIT, UAT, data migration, and cutover.
- Troubleshoot functional issues, provide production support, and perform impact analysis for quarterly updates.
Required Skills & Experience
- Strong expertise in Oracle Fusion Cloud PPM modules.
- Experience in gathering business requirements and writing functional designs.
- Knowledge of Oracle Financials integration and month-end activities.
- Familiarity with cross-charge processes between entities and project billing.
Role / Responsibilities
- Own functional configuration and implementation of Oracle Fusion Cloud Procurement, Supplier, Inventory, and Product Information Management (PIM/PDH) modules.
- Manage the complete Procure-to-Pay (P2P) lifecycle, including requisitions, purchase orders, receipts, and 2/3/4-way invoice matching.
- Configure and support Self-Service Procurement (SSP), Sourcing, Procurement Contracts, and BPM approval hierarchies.
- Manage the end-to-end Supplier lifecycle, including supplier and supplier-site setup, Supplier Portal onboarding, Supplier Qualification, and Blanket/Contract Purchase Agreements.
- Configure and support Inventory Management, including inventory organizations, subinventories, locators, material status, transfers, shipping networks, FOB points, reservations, and on-hand tracking.
- Manage PIM/Item Management, including item classes, attributes, templates, catalogs, categories, item structures/BOMs, and New Item Request (NIR) workflows.
- Handle item data migration using FBDI/ADFDi and support data validation and reconciliation.
- Perform requirement gathering, fit-gap analysis, solution design, and functional documentation.
- Work with technical teams on RICE objects, including functional requirements, specifications, interfaces, conversions, reports, and extensions.
- Perform functional unit testing and support CRP, SIT, and UAT cycles.
- Troubleshoot interface and ESS errors, support data migration activities, and manage Oracle Support SRs.
- Support implementation and post-production application support lifecycles.
- Conduct end-user training and prepare functional documentation and training materials.
- Provide functional guidance on Cost Management, including standard/average costing and landed cost, where required.
Roles & Responsibilities
- Lead functional activities for Oracle Fusion Cloud PPM implementations and support engagements.
- Gather business requirements and translate them into Oracle Fusion PPM solutions.
- Configure and maintain PPM modules based on business requirements.
- Perform fit-gap analysis and recommend standard Oracle solutions while minimizing unnecessary customizations.
- Configure project structures, templates, project types, classifications, organizations, roles, and task structures.
- Configure project budgeting, forecasting, financial plans, baselines, estimates, commitments, and actuals.
- Support Project Costing, Billing, Contracts, Management, and Resource Management processes.
- Analyze integration points between PPM and AP, AR, GL, Fixed Assets, and Payroll.
- Work with technical teams on RICE requirements and provide functional specifications.
- Review and validate reports, interfaces, conversions, and extensions from a functional perspective.
- Participate in CRP, SIT, UAT, and functional unit testing.
- Support FBDI/ADFDI-based data migration activities and validate migrated data.
- Troubleshoot functional issues, interface errors, ESS jobs, and integration failures.
- Raise, manage, and follow up on Oracle Support SRs where required.
- Prepare functional design documents, configuration documents, test scenarios, and user guides.
- Conduct end-user training and support business users during implementation and post-go-live.
- Provide production support and ensure timely resolution of PPM-related issues.
- Collaborate effectively with business stakeholders, technical teams, project managers, and other Oracle functional consultants.
We are seeking an experienced Fusion Receivables Functional Consultant with following skills:
- Designing Oracle Fusion Receivables process flows to handle data migrations, transformation and orchestration of Interfaces between third party systems and Oracle Cloud.
- Responsible for designing, developing, and maintaining expert level skills on Fusion Receivables.
- Demonstrated experience in gathering and documenting business requirements, leading fit-gap analysis, conference room pilots (CRPs) functional configuration, testing, client user training.
- Design and develop integrations to/from Oracle ERP Fusion receivables FBDI File Uploads.






