Oracle EPM - Consultant

KPMG Ignition Tax in the United States partners with KPMG Global Services (KGS) to deliver Oracle Tax Reporting Cloud Service (TRCS) and the broader Oracle EPM suite.

As a non-client-facing Senior Associate, you will focus on hands-on configuration, data integration, and quality assurance—bringing together TRCS, Financial Close (FCCS), and Oracle’s integration toolset (Data Exchange, Data Management, EPM Integration Agent, Oracle Integration Cloud, REST / SOAP APIs).

You will work primarily with U.S. engagement teams, translating functional tax requirements into robust, scalable technical designs that follow KPMG Powered Enterprise and Oracle OUM/ACT delivery standards.

Key Responsibilities

Oracle EPM Build & Configuration

• Configure TRCS tax automation, hierarchies, security, and workflow.
• Build calculation scripts, business rules, and member formulas (Essbase).

End-to-End Data & System Integration

• Design and deploy integrations using Oracle Data Exchange, Data Management / FDMEE, EPM Integration Agent, and Oracle Integration Cloud (OIC).
• Develop and maintain REST / SOAP API calls, EPM Automate scripts, and scheduled jobs for continuous data flows.
• Map and transform data from multiple ERPs (Oracle ERP Cloud, SAP, Workday, etc.) into TRCS / FCCS tax and finance models.

Solution Design Support

• Convert Functional Design Documents into detailed Technical Design Documents that cover data mappings, integration specs, and control points.
• Ensure traceability from ASC 740 and tax-provision requirements through to configuration and reporting.

Testing & Quality Assurance

• Author unit, SIT, and performance test scripts; execute tests and log defects in JIRA.
• Manage migration artifacts (Dev → Test → Prod) via Lifecycle Management (LCM) and OIC pipelines; capture evidence for SOX & KPMG QA reviews.

Documentation & Knowledge Management

• Produce configuration workbooks, integration run-books, and user guides.
• Contribute reusable integration templates and lessons learned to KPMG’s global EPM knowledge base.

Collaboration & Mentoring

• Participate in daily U.S. / India stand-ups; provide progress updates, raise blockers, and manage time-zone hand-offs.
• Coach junior team members on Oracle EPM and integration best practices.

Daily Activities

• Configure dimensions, data forms, integrations, and security in TRCS / Data Exchange.
• Run and troubleshoot data loads; reconcile tax balances and address data exceptions.
• Update RAID items in JIRA / ServiceNow and participate in design walkthroughs and peer reviews.
• Automate integration jobs and monitor schedules, ensuring data is available for tax close cycles.

-

-