PSA | Oracle Report Analyst

Prudentials purpose is to be partners for every life and protectors for every future. Our purpose encourages everything we do by creating a culture in which diversity is celebrated and inclusion assured for our people customers and partners. We provide a platform for our people to do their best work and make an impact to the business and we support our peoples career ambitions. We pledge to make Prudential a place where you can Connect Grow and Succeed.

The A&R Financial Operations Report Analyst (Oracle Fusion Financial Report Consultant) is responsible for analysing the design & E2E implementation of the Oracle Report ecosystem supporting all subledger processes (APARFAProjectsLease Accounting) bank payments and reconciliations along with integrating Oracle Fusion ERP with relevant source & consuming systems (e.g. Coupa).

This role collaborates closely with cross-geo teams (Pilot entity and wave 1 entities) cross-functional teams (& other FFP workstreams) and cross-systems teams (source & consuming systems teams from both local business entities and group office) to ensure the integrity security and performance of Prudentials E2E closing throughout the system lifecycle.

JOB DESCRIPTION

Job Responsibilities

Technical Support

• Design and implement Oracle Fusion Reports and Integrations such as BIP XML OTBI SmartView and FRS; OCI and ATP Database (Oracle SQL PL/SQL)

• Provide second-level technical support for Oracle Complete Report ecosystem involving ERP finance modules including General Ledger Accounts Payable Accounts Receivable Fixed Assets GL Inter Company Tax and Cash Management.

• Troubleshoot and resolve incidents related to Oracle ERP functionality user access system performance and data integrity.

• Collaborate with L1 support teams to ensure timely escalation and resolution of complex issues.

• Perform root cause analysis of recurring issues and recommend long-term solutions to prevent future occurrences.

User Assistance Knowledge Management and Training

• Assist end-users with navigation data entry and reporting within the Oracle ERP finance modules.

• Develop and deliver training materials and sessions to enhance user proficiency and understanding of the ERP system.

• Provide guidance on best practices and procedural compliance to ensure accurate financial reporting and analysis.

• Create Knowledge documents and repositories to capture Standard Operating Procedures Known error database etc

• Mentor and train L1 support staff on advanced troubleshooting techniques and best practices for Oracle ERP support

• Stay current with Oracle ERP technologies updates and industry best practices to continuously improve support services and drive innovation

System Maintenance and Enhancement

• Monitor system performance and conduct regular maintenance activities to ensure optimal functionality.

• Assist in the configuration and testing of new features patches and upgrades to the Oracle ERP system.

• Participate in system integration projects and collaborate with IT and business teams to implement enhancements.

• Document system changes configurations and procedures to maintain accurate records and support knowledge transfer

Compliance and Reporting

• Ensure compliance with industry regulations and internal policies related to financial data management and reporting.

• Generate and review financial reports to identify discrepancies trends and opportunities for improvement.

• Collaborate with auditors and compliance officers to provide necessary documentation and support during audits.

Job Requirement

• Bachelors or Masters degree in Computer Science Information Technology or a related field

• 8 years of experience in designing and implementing report architectures for complex Oracle Fusion financial systems preferably in the Oracle Subledgers ((AP AR FA ProjectsLease Accounting)

• Experience with data migration data quality management and data governance frameworks.

• Excellent problem-solving and analytical skills

• Effective communication and leadership abilities

• Ability to work collaboratively in a fast-paced multi-stakeholder environment.

Mandatory skills

• Strong expertise in Oracle Fusion Financials Reports including BIP XML OTBI SmartView and FRS; OCI and ATP Database (Oracle SQL PL/SQL) and their underlying data structures.

• Experience with data architecture data engineering and integration patterns in Financial Services (with Insurance as preferred).

• Familiarity with financial accounting concepts and processes

Preferred skills

• Technology delivery project management experience especially legacy systems migration

• Experience with DevOps CI/CD practices master data management and data governance.

• In-depth knowledge of Oracle Fusion report ecosystem along with Financial data structure and data integration techniques

Prudential is an equal opportunity employer. We provide equality of opportunity of benefits for all who apply and who perform work for our organisation irrespective of sex race age ethnic origin educational social and cultural background marital status pregnancy and maternity religion or belief disability or part-time / fixed-term work or any other status protected by applicable law. We encourage the same standards from our recruitment and third-party suppliers taking into account the context of grade job and location. We also allow for reasonable adjustments to support people with individual physical or mental health requirements.