Basak R.

Oracle EPM Lead Architect and Solution Designed - EDMCS (Complex, Global, Domestic, Multi ERP and EPM) - FCCS Implementation an Hypercare - HFM to FCCS Upgrade/Migration - COA Upgrade and simplification - Subledger and GL Account Reconciliation and Transaction Matching / ARCS - Adjustment Journal and Management Journal - Data Load, Data management and Data Pipeline - CRP, UAT Assistance, Hypercare

FCCS, ARCS, Cloud Data Management, Data Recon, Smart View, SQL/PLSQL, Oracle OCI, IDCS, MFA, Azure AD, OIC Integration, Managing Oracle EPM and Solution Architect

Oracle EPM Cloud Architect • Analyze /Design /Develop EPM Applications to meet Business Requirements • Design and Build FP&A Planning and Budgeting process and enhancements • Implemented ARCS and TRSC from scratch - empty POD. Reused EDMCS dimension and hierarchy • HFM to FCCS Migration (Consolidation, Translation, CTA, Elimination, Plug Account Analysis, Reconciliation, Validation Reporting) • Cost Allocation application creation, Update Master Data from DRM, Allocation POV Creation and allocation rule and rule set building. Driver configuration, priority set for rules and allocation flow and allocation validation using Smart View and Web • Narrative Reporting book building. EPRCS Implementation from scratch for CFO Team • Financial Reporting report migration, New Report creation, Fixing of Migration issues • EPBCS Change request implementation - Master Data - Account, Product, Project, Cost Center update • Calculation scripts writing and execution performance enhancement • Design and Build documentation for Project and Process • Conducting User Acceptance Training • Complex Planning web forms design for new requirements • Data Load and Data Load Automation • FDMEE Mapping and load rule maintenance. Migration of FDMEE location to Cloud data management • Extensive knowledge on Oracle DRM, Hyperion MDM and EDMCS migration • Various DRM Batch – Version Export, Export to files, Export to HFM format (app file), export for Planning / PBCS by dimensions, export to Essbase / OAC format • DRM Version Management, Copy Version, Archive Version, Compare, Blend, export Audit Report, Action Script,External Connection setup,Validations via DRM Scripts using various DRM Functions – i.e. PropValue, Core property, Length, GreaterThanOrEqual(), SubString, etc. Realtime Validation and Batch Validation, DRM Security • Strong SQL/PLSQL knowledge including Star and Datavault 2.0 modeling, connect, prior, group by, sort by siblings, rank, etc.

Oracle EPM Cloud Enterprise SME Architect Techno Functional • Analyze /Design /Develop EPM Applications to meet Business Requirements • FCCS POD configuration (4 environment) from scratch. GL Chart of account migration, HFM rule to FCCS Business rule conversion. Consolidation, Elimination, IFRS, US-GAAP, Financial Report (BS, PL, Cash Flow), UAT Sign off • EPBCS Implementation. • Design and Build FP&A Planning and Budgeting process and enhancements • Calculation scripts writing and execution performance enhancement • Design and Build documentation for Project and Process • Conducting User Acceptance Training • Complex Planning web forms design for new requirements • Data Load and Data Load Automation • FDMEE Mapping and load rule maintenance • PCMCS Cost Model implementation - POC, Phase 1, Phase 2 (Rollout to key Customers). Various Shared Cost Allocation by Product, Project, Department by respective 1 month lagging driver • Extensive knowledge on Oracle DRM, Hyperion MDM for 12+ years. Oracle DRM 11.1.2.4 and EDMCS • Various DRM Batch – Version Export, Export to files, Export to HFM format (app file), export for Planning / PBCS by dimensions, export to Essbase / OAC format • DRM Version Management, Copy Version, Archive Version, Compare, Blend, export Audit Report for various changes for quarterly SOX report • DRM to EBS Integration via DRM-EBS Tool-kit integration • Creating of DRM Action Script for mass operations and across multiple environment • External Connection setup for export to Database in Parent-Child format and Hierarchical format • DRM Validations via DRM Scripts using various DRM Functions – i.e. PropValue, Core property, Length, GreaterThanOrEqual(), SubString, etc. Realtime Validation and Batch Validation. • Strong SQL/PLSQL knowledge including connect, prior, group by, sort by siblings, etc. • Worked for multiple Business Unit of Toyota including Insurance and Bank

• Analyze /Design /Develop EPM Applications as per Business Requirements • Interacting Business users to perform Month and Year End close process and • Design and Build FP&A Planning and Budgeting process and enhancements • Calculation scripts writing and execution performance enhancement • Design and Build documentation for Project and Process • Conducting User Acceptance Training • Complex Planning web forms design for new requirements • Data Load and Data Load Automation • FDMEE Mapping and load rule maintenance • Essbase Restructure, Dense Restructure, Essbase Defragmentation • Building new application on Essbase Cloud / OAC / Oracle Analytic Cloud 21c • Migration of Planning application from On-Prem Hyperion Planning to EPBCS Application • Smart View report building • Financial Report building • POD Initialization, Create EPBCS Application, Building EPBCS Application from snapshot, Metadata Load from CSV, Data Load using Cloud Data Management, On-Prem FDMEE to EPBCS Actual data load • Conversion of traditional application to Unicode application, Migration of On-Prem Essbase application to OAC, OAC Application data load, Data Recon, Smart View template creation with OAC Cloud • Creating Virtual instance in OCI, Creating Network group for OAC, Install OAC from image, publish OAC JET URL, OAC to OKTA integration using Oracle IAM taking help from oracle consultant via SR, OAC Business Friendly URL creation • Worked for multiple Business Unit of Toyota including Insurance and Bank

- Installation and Configuration of Oracle EPM 11.1.2.4 in a clustered environment - Configure Phoenix User Directory with Oracle EPM and Shared Service - Build Portfolio Category based Pension fund Essbase cube - Build Invest Performance monitoring Essbase Cube using BSO Technology - Build Invest Performance monitoring Essbase Cube using ASO technology for reporting - Build and implement Essbase Business Logic using Calculation Script - Create rue using Calculation Manager - Create EPMA based dimension library - User security implementation using Hierarchical Groups - Build month end activity book for support team - Build month end workflow Financial Close Management

Hyperion Essbase/Planning SME • Analyze /Design /Develop EPM Applications as per Business Requirements • Interacting Business users to perform Month and Year End close process and • Design and Build FP&A Planning and Budgeting process and enhancements • Calculation scripts writing and execution performance enhancement • Design and Build documentation for Project and Process • Conducting User Acceptance Training • Complex Planning web forms design for new requirements • Data Load and Data Load Automation • FDMEE Mapping and load rule maintenance • Essbase Restructure, Dense Restructure, Essbase Defragmentation • Building new application on Essbase Cloud / OAC / Oracle Analytic Cloud 21c • Migration of Planning application from On-Prem Hyperion Planning to EPBCS Application • Smart View report building • Financial Report building • Full functional POC on vanilla PBCS and EPRCS • Planning dimension load, Web Form creation, Business Rule creation, Data Load, Actual Data Load, Actual to Budget Data Copy, Forecasting Cycle Opening, Rolling Forecast Opening, Assisting Power User to close budgeting cycle

Hyperion Essbase/Planning SME • Building Hyperion Planning application from scratch • Creating Essbase BSO and ASO application for management reporting for appx. 3000 hotels • Analyze /Design /Develop Hyperion Planning Applications as per Business Requirements and 200+ excel based templates • Interacting with Business users to finalize and closure of BRD • Design and Build FP&A Planning and Budgeting application using BSO and ASO cube of underlying cubes • Calculation scripts writing and execution performance enhancement • Design and Build documentation for Project and Process • Conducting CRP, SIT and UAT • Complex Planning web forms design for new requirements • Data Load and Data Load Automation