Oracle Fusion / Reporting & Analytics (FDI/OAC)
· Developed reports using FAW/FDI, OAC, EDW/ADW, BIP/OTBI, OBIEE, set-up ESS job using BIP for GL to FCCS custom integration.
· Hands-on experience with GL, GL Essbase Main/Actuals & ADB (Average Daily Balance) Cubes, AR, AP, Fixed Assets, Projects, GL Suspense account, Custom Account Analysis (GL + Subledgers), AP invoice approval workflow, AR & AP Invoice aging, AR DSO, Accounting Hub Transactions, Global Subledger Detail Journal Report, Journal Lines Details, and PO Historical reports.
· Lead mission-critical implementations of Oracle Fusion Cloud BI and Oracle EPM Cloud (FCCS, HFM, EPBCS) across on-prem, SaaS, and PaaS environments, delivering end-to-end solution lifecycles including FRD/MD50, TDD/MD70, RTM, RFP/RFI, UAT, KT, production support, and post-go-live stabilization.
EPM Cloud (FCCS/HFM/GL ESSBASE CUBES)
· Implemented FCCS and executed HFM-to-FCCS migrations, including POD configuration for Balance Sheet, P&L, Cash Flow, and Ownership Management (Holdings/Subsidiaries/Interest %), supporting US GAAP and IFRS.
· Designed/managed dimensions, data intersections, business rules, forms, journals, consolidations, FX rates, and close processes.
· Strong collaboration with Finance, Accounting, IT, and Integration teams to translate complex business requirements into scalable Oracle solutions, delivering high-quality, audit-ready, and performance-optimized financial systems; involving Close Management, multi-currency consolidations, Month-end rates, CTA adj, benchmark calc, intercompany eliminations, and SOX compliance.
· Delivered EPM reporting via FRS, Management Reports, Narrative Reporting, Smart View, and Excel. Created executive-level financial and operational reports: Balance Sheet, GL Essbase B/S (ADB), Income Statement, Cash Flow, Audit Trails, Avg_Balance accts, Interest Expenses, Gross-up calc, Yield calc, Run Rate, and SEC 10K Yields, with audit-ready outputs including Trial Balance, Retained Earnings vs. Net Income validation, FX revaluation gains/losses, and other SEC-aligned reporting.
· Administered jobs, task audits, migrations, variance analysis, journal workflows, supported FCCS BSA activities, collaborated with OIC teams for integration, audit logging, object storage governance, and data validations at source, database, and report levels.
Planning, Budgeting & Forecasting (EPBCS)
· Implemented Planning & Budgeting (EPBCS) solutions supporting rolling forecasts, budget revisions, and scenario modeling.
· Delivered Actuals vs Plan, YoY & QoQ analysis, run-rate modeling, interest expense, yield calculations, and trends analysis.
· Supported strategic finance decision-making through accurate projections and valuation models.