EPM Technical Consultant

Job Summary

We are looking for an experienced Essbase Developer / Consultant with strong hands-on experience in Oracle Essbase OLAP (ASO/BSO) and financial reporting solutions. The candidate will be responsible for designing, developing, testing, supporting, and optimizing Essbase applications and reporting solutions.

The role requires strong technical expertise in Essbase, financial reporting, database modeling, Unix/Linux scripting, and production support.

Key Responsibilities

• Design, develop, test, debug, document, and maintain Essbase solutions using Agile development practices.
• Manage the complete lifecycle of multidimensional financial reporting and analytical applications, including requirements gathering, design, development, testing, deployment, and maintenance.
• Develop and support Oracle Essbase ASO/BSO applications.
• Work extensively with:
• Essbase Outline Design
• Load Rules
• MaxL Scripts
• Calculation Scripts
• Partitions
• Security
• Performance Tuning and Optimization
• Smart View / Excel Add-in
• Design and maintain financial reporting and analytical solutions.
• Work with Star Schema design and relational database modeling using Oracle or SQL Server.
• Source hierarchy and fact data from file-based and relational data sources.
• Work with metadata management systems such as DRM (Data Relationship Management).
• Develop Unix/Linux shell scripts to automate Essbase database outline builds, data loads, and aggregations.
• Build and maintain automation processes using CA AutoSys.
• Troubleshoot and resolve complex technical issues in Essbase applications.
• Provide production and on-call support when required.
• Ensure quality, security, and compliance requirements are met.
• Collaborate with business users, finance teams, and technical stakeholders.
• Document technical solutions, processes, and application changes.

Mandatory Skills

• 7+ years of overall IT/application development experience.
• 5–7 years of hands-on experience with Oracle Essbase OLAP.
• Strong experience with Essbase ASO and BSO.
• Hands-on experience with Outline Design, Load Rules, MaxL, Calc Scripts, Partitions, Security, and Performance Tuning.
• Strong experience with Smart View / Excel Add-in.
• Experience with financial reporting and multidimensional analytical applications.
• Experience with Oracle or SQL Server databases.
• Strong knowledge of Star Schema and relational database modeling.
• Experience with Unix/Linux Shell Scripting.
• Experience with CA AutoSys.
• Experience supporting production environments and providing on-call support.
• Strong communication and stakeholder management skills.

ob Title

Consultant – Oracle Fusion HCM UK Payroll 

Work Experience

5 to 8 Years

Job Location - India

Job Summary

Oracle HCM – Oracle Fusion Cloud – UK Payroll (Functional) and Fast Formula (Functional) Consultant-Oracle responsible for implementing, configuring, and supporting UK Payroll solutions on Oracle Fusion Cloud, with a focus on Fast Formula-driven rules and calculations. 

Key Responsibilities

• Lead and deliver end-to-end implementations of Oracle Fusion Cloud HCM UK Payroll, including requirements gathering, solution design, configuration, testing, and deployment. Must be well versed with Fast Formula for payroll.

• Configure and maintain UK Payroll elements, balances, payroll definitions, statutory calculations, and legislative updates in Oracle Fusion Cloud.

• Design, develop, and optimize Oracle Fusion Fast Formulas for payroll calculations, validations, absence, time and labor, and other HCM-related rules.

• Collaborate with business stakeholders to understand UK payroll processes, statutory requirements, and compliance needs, and translate them into Oracle Fusion solutions.

• Perform impact analysis and implement changes for UK legislative updates, HMRC requirements, and other statutory changes in payroll.

• Conduct system testing, integration testing, and user acceptance testing (UAT) for payroll and Fast Formula changes, ensuring accuracy and compliance.

• Provide production support for UK payroll cycles, including payroll run issue resolution, reconciliation, and post-payroll activities.

• Work closely with technical teams on integrations between Oracle Fusion HCM and third-party systems (e.g., HR, finance, time and attendance, benefits).

• Prepare functional design documents, configuration workbooks, test scripts, and user guides for UK Payroll and Fast Formula solutions.

• Train and support end users, payroll teams, and HR stakeholders on Oracle Fusion UK Payroll functionalities and best practices.

• Ensure robust controls, audit readiness, and data accuracy across all UK payroll processes implemented in Oracle Fusion Cloud.

• Participate in solution reviews, quality checks, and continuous improvement initiatives to enhance payroll efficiency and user experience.

Other Capabilities

• Strong understanding of UK payroll legislation, statutory deductions, and HMRC reporting requirements.

• Ability to analyze complex payroll scenarios and design scalable Fast Formula-based solutions.

• Effective stakeholder management skills, with the ability to work with HR, Payroll, Finance, and IT teams.

• Good documentation, presentation, and communication skills for functional deliverables and stakeholder updates.

• Proactive problem-solving mindset with attention to detail and a focus on accuracy in payroll outcomes.

• Ability to work independently as well as in a collaborative, global team environment.

Qualifications and Skills

• Proven experience as a functional consultant in Oracle Fusion Cloud HCM with specialization in UK Payroll.

• Hands-on experience configuring Oracle Fusion Cloud – UK Payroll (Functional), including payroll elements, balances, and statutory rules.

• Strong expertise in Oracle Fusion Cloud – Fast Formula (Functional) for payroll and related HCM modules.

• Experience in at least one full-cycle implementation or major enhancement project for Oracle Fusion UK Payroll.

• Good understanding of Oracle HCM Cloud data model, security, and reporting related to payroll.

• Bachelor’s degree in Information Technology, Computer Science, HR, Finance, or a related field (or equivalent experience).

• Relevant Oracle HCM Cloud certifications in UK Payroll and/or Fast Formula are preferred.

• Strong analytical and debugging skills for resolving payroll calculation and Fast Formula issues.

• Comfortable working in an onshore–offshore delivery model and interacting with UK-based stakeholders.

Key Responsibilities

• Implement and configure Oracle Fusion Cloud for Bahrain Payroll and Absence Management.
•  
• Should have conducted client Workshops/Solution Designing and Configuration on the module
• Preferred to have knowledge & experience with data migration to Oracle Cloud.
• Ability to handle multiple tasks simultaneously and switch between tasks quickly.
• Must have experience in migration of setup changes from non-Production to Production environment
• Must have worked on implementation projects
• Provide ongoing support and troubleshooting for system issues.
• Collaborate with stakeholders to gather requirements and ensure system alignment.
• Conduct training sessions for end-users to enhance system utilization.
• Stay updated with the latest Oracle Fusion Cloud updates and features.