SA - Consulting - Oracle

Job description

Line of Service Advisory Industry/Sector Not Applicable Specialism Oracle Management Level Senior Associate Job Description & Summary At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. As an Oracle consulting generalist at PwC, you will possess a broad range of consulting skills and experience across various Oracle applications. You will provide consulting services to clients, analysing their needs, implementing software solutions, and offering training and support for effective utilisation of Oracle applications. Your versatile knowledge will allow you to assist clients in optimising operational efficiency and achieving their strategic objectives. Role summary Deliver Oracle EPM Cloud solutions for planning, consolidation/close, account reconciliation, narrative/management reporting, and enterprise data governance. Lead specific functional or technical EPM workstreams through design, build, testing, cutover, and hypercare; contribute to proposals/demos and delivery quality. Primary EPM focus areas (candidate may specialize in one or more) Planning: Enterprise Planning and Budgeting (EPBCS)/FreeForm, driver-based planning, forecasting, workforce/capex/projects modules. Financial Consolidation and Close (FCCS): consolidations, ownership methods, journals, intercompany eliminations, close tasks, supplemental data. Account Reconciliation (ARCS): profiles, rules, match processes, compliance workflows, dashboards. Narrative/Management Reporting: report packages, document narratives, pixel-perfect/management reporting, Smart View. Enterprise Data Management (EDMCS): dimensions/hierarchies, node types, data governance workflows, change approvals, subscriptions. Profitability and Cost Management (PCMCS) and Tax Reporting (TRCS) as applicable. Key responsibilities Lead or co-lead end-to-end EPM workstreams: discovery, fit–gap, solution design, configuration/build, testing (SIT/UAT), cutover, and post–go live support. Design planning models: dimension architecture, driver logic, forms, dashboards, approval workflows; build rules using Calculation Manager and valid business logic. Configure FCCS: consolidation methods, ownership/percentages, intercompany eliminations, consolidation rules, journals, close manager tasks, and monitoring. Configure ARCS: reconciliation profiles, matching rules, workflow, compliance attestations, dashboards, and automation schedules. Implement Narrative/Management Reporting: report packages, management reports, bursting, Smart View integration, and distribution. Govern metadata with EDMCS: design node types/hierarchies, validations, approvals, subscriptions, and application deployments across environments. Design and run integrations: Data Management import formats, mappings, locations, load/validate/export; EPM Automate/REST API scripts; scheduling and error handling. Plan and execute data migration: extraction, cleansing, mapping, reconciliation, and validation for historicals/opening balances/master data. Define and execute test strategies (SIT/UAT/Regression), manage defect triage, capture test evidence, and obtain acceptance sign-offs. Implement security and access: role provisioning, segregation of duties, audit trails, and environment controls. Prepare cutover run books and hypercare procedures; track stabilization KPIs and resolve production issues. Support project governance: plans, RAID logs, status reporting, and change control; comply with PwC delivery methods and quality standards. Contribute to proposals, demos, estimates, and solution accelerators; coach Associates/junior team members. Required qualifications Bachelor’s degree in Information Systems, Computer Science, Accounting/Finance, Industrial Engineering, or related field. 3–6+ years of hands-on Oracle EPM Cloud implementation/upgrade experience in at least one primary focus area (Planning, FCCS, ARCS, Narrative/Management Reporting, EDMCS). Minimum 1–2 full-cycle EPM Cloud implementations covering design, configuration/build, testing, and cutover. Demonstrated configuration expertise: Planning: dimensions/metadata, forms, business rules (Calculation Manager), approvals, dashboards. FCCS: consolidation setup, ownership/eliminations, journals, close manager, supplemental data. ARCS: profile design, matching rules, workflow, automation and reporting. Reporting: Smart View, Narrative/Management Reporting (report packages, management reports). EDMCS: data governance workflows, node types/hierarchies, validations, subscriptions. Integration experience with EPM Data Management, EPM Automate, and/or REST APIs; familiarity with scheduling, logs, and error remediation. Data migration and reconciliation experience for actuals, budgets/forecasts, consolidations, and master data. Exposure to Agile/Scrum and/or Waterfall delivery; use of ALM/defect tools (e.g., Jira, Azure DevOps) and collaboration tools (e.g., Confluence). Language: Professional proficiency in English and Bahasa Indonesia. Willingness to travel within Indonesia/SEA; ability to work with regional/global teams across time zones. Work authorization in Indonesia. Preferred qualifications Oracle certifications in EPM Cloud (e.g., Planning, FCCS, ARCS, EDMCS, Narrative Reporting). Prior Hyperion on‑prem experience (Planning/HFM/DRM/AR) beneficial for cloud transitions. Experience with PCMCS or TRCS; or advanced EDMCS governance across multiple target applications. Scripting/automation skills (shell/PowerShell/Python) for EPM Automate/REST; basic SQL for extracts/validations. Performance tuning of forms/rules and data loads; understanding of consolidation performance drivers. Experience in pre-sales (RFP responses, solution demos, PoCs) and effort estimation. Industry exposure in one or more: Consumer/Retail, Energy/Resources, Financial Services, Industrial/Manufacturing, Public Sector. Tools and technologies (role-dependent) Oracle EPM Cloud suite: Planning (EPBCS/FreeForm), FCCS, ARCS, Narrative/Management Reporting, EDMCS, PCMCS/TRCS (as applicable). Integration and automation: Data Management, EPM Automate, REST APIs; scheduling/monitoring. Reporting: Smart View, Narrative Reporting, Management Reporting. Project/ALM: Jira, Azure DevOps; Confluence; MS Project/Excel/Visio/PowerPoint. Source control/CI (as applicable): Git-based tools. Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Application Software, Business Model Development, Business Process Modeling, Business Systems, Communication, Creativity, Developing Training Materials, Embracing Change, Emerging Technologies, Emotional Regulation, Empathy, Enterprise Integration, Enterprise Software, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Innovative Design, Intellectual Curiosity, IT Infrastructure, Learning Agility {+ 16 more} Desired Languages (If blank, desired languages not specified) Travel Requirements Not Specified Available for Work Visa Sponsorship? No Government Clearance Required? No Job Posting End Date