PSA | Oracle Report Analyst

Prudential’s 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 people’s 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 (AP,AR,FA,Projects,Lease 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 Prudential’s 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

• Bachelor's or Master's 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, Projects,Lease 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.