Sahil Gupta

• Lead end-to-end implementation of Oracle EPM Cloud solutions, including EPBCS, for
financial planning, reporting, and consolidation processes.
• Designed and maintained EDMCS applications, including node types, properties, and
hierarchies for multiple business dimensions.
• Integrated Oracle EDMCS with ERP and EPM systems like Oracle ERP Cloud, FCCS, and
EPBCS for seamless data synchronization
• Configured complex EDMCS subscriptions and data enrichment rules to automate
hierarchical updates and ensure data quality across EPM and ERP applications.
• Developed and managed approval workflows in EDMCS to streamline data governance
processes and ensure data integrity.
• Collaborated with cross-functional teams to optimize EPM solutions, implementing
performance tuning strategies to improve system efficiency
• Led the end-to-end migration of Hyperion on-premises applications to Oracle Cloud EPM
(EPBCS)
• Designed and implemented data integration workflows from on-premises ERP systems
to Oracle Cloud.
• Configured metadata, hierarchies, security roles, and data access in FCCS and EPBCS.
• Developed business rules, calculation scripts, and automation solutions
• EPM application deployments, ensuring successful configuration and testing of Oracle
PBCS and Hyperion Planning applications
• Develop and automate data integration solutions using EPM Automate, REST APIs, and
FDMEE.
• Designed and implemented ETL processes using Data Exchange for seamless data
integration from multiple sources into Oracle Essbase
• Developed scripts to automate data loading and maintenance tasks, significantly
reducing manual intervention and increasing accuracy
• Conducted detailed performance tuning of Essbase and Planning applications, resulting
in a 30% improvement in query response times
• Proficient in Groovy scripting to create dynamic, event-driven business rules in Oracle
EPM, enhancing performance and user interactivity.
• Developed customized calculation logic using Groovy to streamline allocations, driver
based planning, and real-time data validation.
• Leveraged Oracle EPM REST APIs for efficient automation of metadata updates, data
integrations, and lifecycle management tasks.
• Provided hands-on training sessions for end-users on SmartView and Hyperion
functionalities, enhancing user adoption and proficiency
• Created comprehensive technical documentation for all implemented solutions,
including user manuals and troubleshooting guides
• Actively monitored application performance and proactively resolved issues, ensuring
minimal downtime and optimal user experience
• Managed integration of Oracle EPM with Oracle EBS and other third-party applications,
ensuring smooth data flow and operational continuity
• Provide training and support to end-users on EPBCS, FCCS and EDMCS functionality,
best practices, and data management processes
• Developed and configured EDMCS to manage metadata changes effectively, ensuring
consistency and accuracy across the enterprise
• Implemented workflows in EDMCS to streamline the approval process for metadata
changes, enhancing governance and reducing cycle times
• Utilized PCMCS for effective cost management, creating allocation models and running
scenarios to optimize resource allocation
• Conducted user training and provided support for EDMCS and PCMCS, ensuring users
understood best practices for data management and reporting
• Configured ARCS for automated reconciliation processes, improving accuracy and
reducing time spent on manual reconciliations

• Support the team in the execution of the IT Asset and Inventory Management system
design, development and execution
• Involved in creating business processes and modeling diagrams
• Coordinate with management in utilizing the asset management tools to perform a root
cause analysis, review and track asset data
• Assisted the lead BA in Business Requirements Documents (BRD), Business Process
modelling, data analysis and SDLC methodologies
• Managed asset reconciliation and asset disposal agreements and also monitor software
licenses to ensure they comply with license agreements and usage standards
• Experience with Excel Calculation services, Analysis Services, and other services in
SharePoint
• Created Use Cases and Process Flows for IT Assets such as server, software licensing,
and hardware etc
• Maintained automated discovery tool such as CMDB and followed IT Service
Management Processes and reconciliation activities for more accuracy
• Assist in the development and execution of the Infrastructure Service business reporting
cadence (including the development and implementation of the framework for these)
• Performed license management administration for IBM and maintain software
scorecards for quarterly meetings and change management related operations with all
the vendors including (Microsoft, Adobe, IBM, Univeris, HP)
• Followed ITIL principles for the analysis of infrastructure services to identify gaps and
opportunities
• Worked on multiple Software Asset Management tools including HP Asset Manager,
SCCM to locate the servers and machines for the data analysis

Planning, FDMEE, MaxL,
Hyperion Financial Reports, SmartView, Shell Scripts, Oracle
EBS

• Managed Hyperion Essbase security through shared services and security filter
• Managed, executed and troubleshoot data load and calculation process using rules files
and calculation scripts
• Supported Hyperion including server reboots, configuration and patches
• Managed application lifecycle support manually for Hyperion Essbase
• Supported finance users with ad-hoc queries, reports and trainings on Hyperion Essbase
• Modified backup processes using maxl, batch scripts and windows scheduler
• Supported Hyperion recovery process during application failures
• Managed hardware and software configurations and maintain systems documentation
• Troubleshoot and coordinate resolving client issues, software and equipment errors
identified by system generated alarms or systems users by updating SAP and SRM
records as appropriate
• Performed re-imaging, configuring, OS installation, OS updating, drivers installation,
troubleshooting and preparing the equipment for deployment
• Substantially increased security and performance of the systems by initiating
installation and supporting of antivirus, anti-malware and critical windows updates
• Directly worked with hardware and software vendors regarding resolution of application
bugs and other systems issues
• Research, evaluate and test hardware and software products and solutions and prepare
reports and proposals for service install and configure new systems or upgrade existing
ones (patches and releases)
• Develop, update and maintain existing system scripts and configurations
• Coordinate equipment deliveries, software licensing compliance, inventory, and asset
control
• Function as a back-up to the Lead Systems Analyst
• Manage new and surplus computer equipment (desktops, laptops, servers, network
equipment, phones, printers/plotters, peripherals, etc) in the IT Lab
• Support the Lab in accordance with the ExxonMobil Computer Equipment Lifecycle
Principles