Mahesh Kumar
Manager EPM
Summary
PMP-certified EPM Manager with 16 years of experience in business applications, specializing in Oracle Cloud EPM and Hyperion suite implementations. Expert in bridging business needs with technology solutions through business analysis, project management, and vendor coordination. Proven track record of delivering complex financial consolidation, planning, and reporting systems across banking, telecom, energy, and enterprise sectors.
Skills
Experience
Serves as Principal Consultant for a major UAE bank, leading corporate planning, consolidation, and reporting system implementations. Manages multiple vendors to deliver EPM internal projects within timelines and budgets, acting as subject matter expert for corporate business applications. Oversees month-end close processes, upgrades, and enhancements across Cloud EPM applications while ensuring compliance and providing guidance to colleagues.
- Managed multiple vendors to successfully roll out ENBD EPM internal projects within timelines and budget
- Responsible for month-end close processes for FCCS, EPBCS, and EPRCS applications
- Delivered Predictive Planning project with vendor collaboration
- Built new dimensions (Accounts, Entity, Cost Center, Segments) into Cloud EPM (FCCS/EPBCS)
- Performed FDMEE/DM setups and customization of objects and mapping across Cloud EPM applications
- Actively participated in design and continual improvements of corporate business architecture
- Provided advanced-level advice, guidance, and assistance to less experienced colleagues
Led assessment, design, upgrade, and enhancements of Finance Hyperion Applications and Cloud EPM applications for a major telecom giant. Managed corporate consolidation, planning, and reporting systems while providing day-to-day operational support and responding to incidents and service requests. Collaborated with business users to gather requirements and deliver solutions aligned with industry best practices.
- Assessed, designed, and upgraded Finance Hyperion Applications and Cloud EPM Applications
- Participated in design, planning, and implementation of Corporate Business Applications enhancement projects
- Provided day-to-day operational support including responding to incidents, service requests, and tasks
- Responsible for month-end close for HFM, Planning, and MI applications
- Built new dimensions (Accounts, Entity, Cost Center, Segment) into HFM, HP, and Essbase using EPMA
- Performed FDMEE/DM setups, customization, and data loading across EPM applications
- Worked with star schema using extended analytics
- Conducted upgradation and migration of HSS, Financial Reports, Essbase, Planning, HFM, and FDM applications
- Provided direct user training and training materials to corporate users
Managed EPM operations for a global energy leader and Abu Dhabi government company, overseeing corporate planning, consolidation, and reporting systems for oil & gas, water, and energy sectors. Led multiple vendor teams to deliver EPM internal projects successfully within timelines and budgets. Responsible for application upgrades, month-end close processes, dimensional builds, and migrations across both on-premise Hyperion and Cloud EPM platforms.
- Managed multiple vendors to successfully roll out TAQA EPM internal projects within timelines and budget
- Led transformation of on-premise to cloud Oracle BI EPM projects
- Responsible for month-end close for HFM, Planning, MI Reporting, FCCS, and PBCS
- Built new dimensions (Accounts, Entity, Cost Center, Segments, Employee) into HFM, HP, Essbase using EPMA and ODI, and Cloud EPM (FCCS/PBCS)
- Performed FDMEE/DM setups and customization of objects and mapping across Cloud EPM applications
- Loaded data using ODI and integrated Actual, Budget, Forecast, and historical data across Hyperion products
- Worked with star schema using extended analytics to integrate Oracle 11g with HFM and transfer data to Planning and Essbase
- Migrated HSS, Financial Reports, ODI, EPMA, Essbase, Planning, HFM, and FDM applications across environments
- Developed and enhanced Hyperion FR Reports
- Took ownership of Corporate Business Applications integrations and worked with internal and external partners
Led EPM consulting services for a Fortune 500 IT and business process outsourcing company, delivering financial consolidation solutions for business units across the globe. Managed offshore team activities while handling dimension setup, upgrades, enhancements, and FDMEE customizations. Responsible for daily, weekly, and monthly data loads, metadata changes, security setup, and overall system stability of Hyperion applications.
- Led dimension setup and enhancement for EPMA Application metadata
- Designed and implemented upgrade and enhancements of Cognizant Finance Hyperion Applications
- Performed FDMEE setups and customization of objects with Jython scripting
- Managed offshore team activities and led testing of FDMEE, HFM, HTP, and FCM applications
- Handled security setup and security classes configuration
- Performed daily, weekly, and monthly data loads through FDMEE in HFM applications
- Developed and maintained technical aspects of HFM Application including metadata changes and grid development
- Analyzed and consolidated grids to refresh values and validate with external reports
- Ensured overall system stability of Hyperion applications
Administered Hyperion HFM solution for consolidation of the Bukhatir Group's business units at group level. Handled end-to-end application development including financial consolidation application creation, EPMA metadata management, FDQM configuration, and data loading. Developed complex financial reports, conducted UAT, provided user training, and prepared training documentation.
- Created financial consolidation application and led application development
- Built EPMA metadata for Accounts, Entities, and Custom Dimensions
- Configured FDQM and performed activities including changing mapping and loading TBS
- Configured application settings, currencies, and security setup
- Loaded actual data on monthly basis into consolidation application
- Developed complex financial reports and created reporting solutions
- Migrated reports and report books from development to production server
- Compared database values with report-generated values through SmartView for testing
- Conducted UAT and user trainings, prepared user training documents
Led offshore team to deliver Hyperion solutions for financial close and Essbase FP&A reporting, implementing HFM to FDM drill-through capabilities. Built standard systems to increase process efficiency, improve data accuracy, and reduce reporting cycle time. Managed requirement gathering, FDQM location and mapping builds, cube building, data loads, and restate interface development.
- Built standard system to increase process efficiency, improve data accuracy, and reduce manual effort
- Developed Hyperion FP&A application to report and analyze actual data at detail level including source account and department
- Built application with ability to report elimination and currency conversion details
- Led requirement gathering activities
- Built FDQM locations and mappings
- Performed multi-load of multiple periods
- Prepared design documents
- Built cubes and performed data loads
- Developed restate interfaces for four locations
Executed process re-engineering and end-to-end implementation of HFM suite applications for a leading US premium chocolate maker, including rollout for 10 countries operating in more than 10 currencies. Handled application profile creation, consolidation application development, metadata loading, and monthly data loads. Developed complex financial reports including P&L statements, balance sheets, cash flow statements, and variance analysis reports.
- Created application profile to bring calendar intelligence and system-generated view dimension members
- Analyzed and fixed scope on number of years for consolidation application support
- Created financial consolidation application to maintain Actual, Plan, and Projection data
- Loaded metadata for Accounts, Entities, and Custom Dimensions
- Configured application settings and currencies
- Loaded actual data on monthly basis into consolidation application
- Developed complex financial reports including P&L Statement, Balance Sheet, Cash Flow Statement, KPIs, and Variance Analysis
- Created reports comparing Actual, Plan, and Projections using Hyperion Financial Reporting
- Developed management and legal reports, report books in both PDF and PPT formats
- Migrated reports and report books from development to production server
- Prepared Hyperion Financial Reporting user manual with step-by-step navigation for 150+ reports