IT ERP / SAP Process Analyst

Results-driven Oracle EPM Consultant/Business Process Analyst with 7+ years of experience in Oracle EPBCS/PBCS, Hyperion Planning, Essbase, FCCS, and EPM Data Integration. Proven expertise in supporting enterprise-wide budgeting, forecasting, financial planning, and reporting processes through administration, development, and optimization of Oracle EPM applications. Strong background in Essbase cube design, business rules, calculation scripts, metadata management, data integrations, and EPM Automate. Experienced in partnering with Finance, ERP, and IT teams to enhance financial systems, support forecasting cycles, perform root-cause analysis, and drive continuous process improvements while maintaining SOX-compliant controls and documentation.

Core Competencies:

• Oracle EPBCS / PBCS Administration & Development
• Oracle Hyperion Planning & Essbase (BSO/ASO)
• Oracle FCCS Integration & Reconciliations
• EPM Data Integration / FDMEE / Data Management
• EPM Automate Scripting & Process Automation
• Budgeting, Forecasting & Long-Range Planning
• Metadata Management & Data Validation
• Business Rules & Calc Scripts Development
• Smart View Reporting & Financial Analytics
• Environment Migration & Release Management
• Application Testing, UAT & Defect Resolution
• Financial Systems & Accounting Processes
• SOX Compliance & Audit Support
• Cross-Functional Stakeholder Management

Relevant Experience:

• Administered and supported Oracle Planning and Budgeting Cloud Service (EPBCS/PBCS) applications for enterprise-wide budgeting, forecasting, and financial planning processes.
• Managed Oracle Hyperion Planning artifacts including web forms, business rules, calculation scripts, Smart View templates, metadata, and security configurations.
• Designed, maintained, and optimized Essbase BSO and ASO cubes, improving calculation performance, data integrity, and reporting efficiency.
• Supported Oracle FCCS integrations by managing data movement, reconciliation processes, validations, and financial data consistency across EPM applications.
• Developed and maintained Data Integration/FDMEE mappings, load rules, transformations, and validation routines for inbound and outbound financial data.
• Leveraged EPM Automate to streamline administrative activities including metadata refreshes, data loads, cube refreshes, environment snapshots, and migration activities.
• Executed and supported monthly forecast cycles and annual budgeting processes by ensuring system readiness, metadata accuracy, and timely issue resolution.
• Performed functional and technical troubleshooting across EPBCS, FCCS, Essbase, and Data Integration applications, conducting root-cause analysis and implementing sustainable solutions.
• Managed application lifecycle activities including environment refreshes, migrations, release deployments, patch validation, and backup procedures.
• Conducted system testing, UAT support, defect tracking, and validation of enhancements to ensure application stability and business continuity.
• Maintained technical documentation, operational procedures, process controls, and audit support documentation to support compliance requirements.
• Collaborated closely with Finance, Accounting, ERP, and IT teams to improve EPM architecture, governance, reporting capabilities, and overall system performance.
• Provided end-user support and training for budgeting and forecasting applications, ensuring effective utilization of Oracle EPM solutions.
• Demonstrated strong analytical, problem-solving, and communication skills while managing multiple priorities and delivering within tight deadlines.

Technical Skills:

Oracle EPM: EPBCS, PBCS, Hyperion Planning, Essbase (BSO/ASO), FCCS, Smart View, Calculation Manager, Business Rules

Data Integration & Automation: FDMEE, Data Management, EPM Automate, Metadata Management, Data Load Rules, Validation Rules

Financial Processes: Budgeting, Forecasting, Long-Range Planning, Financial Reporting, Reconciliations, Financial Consolidation

Tools & Methodologies: UAT, Change Management, Release Management, Root Cause Analysis, Process Documentation, SOX Compliance.