PROFILE:

• High - performing Developer with over 14 years of experience in designing and implementing Oracle Hyperion EPM suite of products.
• Extensive experience in delivering ambitious change programs that are enabled by technology.
• Design and rollout of Detailed Cost & Profitability analysis model to help organization to get insight to cost drivers across organization.
• Design and implement a driver-based planning solution for a global payroll services company.
• Responsible for delivering global Costing and Revenue model, to facilitate the generation of bill rates to support the engagement planning process.
• Develop driver based financial models, using Hyperion Planning, to facilitate analysis of key competitive benchmarks in support of Executive operational decision-making and long-term strategic planning across enterprise.
• Designed and Implemented a fully automated financial and operations reporting and analytics system that gave Partners and CFO’s analytic and decision making capabilities related to service offerings
• Proven track record of delivering ambitious change programs in a rapidly changing environment.

AREA OF SPECIALTY:

Process Improvement, Solution Architecture, Cost Allocation, Planning, Management reporting, Strategic Planning

CORE COMPETENCY:

ASO/BSO/Hybrid

Planning/EPBCS/PBCS

PCMCS

FDMEE

Python/VBA/VB

Additional Skills

FCCS

Groovy

OIC

EDMCS

OAC

EXPERIENCE:

Confidential, NJ

Planning / Costing SME

Responsibilities:

• Design and delivered Detailed Cost & Profitability analysis model to help organization to get insight to cost drivers across drivers across services and products. This includes technical requirements gathering, developing, testing, end-user training and rollout
• Developed and supported over 10 Confidential BSO and ASO application to manage organizations month-end financial process and executive reporting.
• Developed VB/Python based Automation module leveraging MAXL and EPM Automate to manage daily maintenance (exports, cube restructures, imports). Created highly optimized complex Confidential calculations and allocations to handle shared services allocation and to derive financial metrics.
• Created and supported numerous driver - based Hyperion Planning applications. Applications were for detailed plan as well as higher level forecasts.
• Created and supported executive reporting solution using Confidential ASO to facilitate real-time aggregated analysis to support operational decision-making process.
• Developed multiple financial reports using HFR for upper management consumption.

Confidential, NJ

Technical Lead / Senior Application Engineer

Responsibilities:

• Worked as Technical Lead responsible for delivering the solution for generating and reporting Annual Plan using Oracle EPM system.
• Worked through multiple life-cycles of annual planning and reporting application using Oracle EPM (On-Prem & EPBCS)
• Built and automated the process to load custom hierarchies and data obtained from the ETL solution.
• Designed and scripted custom currency conversion script to optimize the out of the box solution
• Provided various solutions for Pre-population and mass change of the budget data.
• Implemented solution for mass data entries by super users controlled by geography and management to initiate the planning process
• Designed and implemented Real-Time Analytics of Budget using Confidential aggregate storage with Hyperion Planning integrated with Microsoft SSRS
• Created custom-defined calculation functions using Java
• Developed security model and bulk upload process
• Lead the development of Global Forecasting and Market Leadership Plan with several customizations to meet the business need.
• Develop driver based financial models, using Hyperion Planning, to facilitate analysis of key competitive benchmarks in support of Executive operational decision-making and long-term strategic planning across enterprise.
• Designed and Implemented a fully automated financial and operations reporting and analytics system that gave Partners and CFO’s analytic and decision making capabilities related to service offerings.
• Support and manage financial applications through the system lifecycle. Work with multiple teams to support the integration of financial processes.
• Led and delivered the implementation of a key-metrics dashboard application for a northeast regional Health care provider. The monthly key-metrics application tracked key revenue, expense, and membership metrics throughout the organization. The application increased visibility to drivers affecting profitability and enabled more timely business decisions.
• Responsible for delivering global Costing and Revenue model, to facilitate the generation of bill rates to support the engagement planning.

Confidential, NJ

Principal Consultant

Responsibilities:

• Lead Enterprise Business Intelligence and Financial Planning teams through design and deployment of global consolidated driver based planning and reporting solution for a professional service company.
• Designed and developed an integrated data transfer interface framework using Confidential Custom Integration to integrate SAP ERP and Hyperion Financial Management system.
• Designed and developed a real time reporting and data transfer framework to enable the real time reporting using VB.net/VB and Hyperion ASO.
• Developed an excel based planning tool to support strategic planning process.
• The tool was created using excel as a front end to collect the data and excel VBA, Confidential API, SmartView API to send the data to Confidential BSO.

Confidential

Consultant

Responsibilities:

• Responsible for implementing several high-profile enterprises wide reporting implementations. Specifically designing, building, and creating highly customized Confidential cubes, with complex calculations and reporting for a banking client.
• Responsible for migrating Financial Analyzer solution to Oracle EPM Including developing a new Profit & Loss planning Model and reporting solution. for a multinational telecommunications company.
• Led the design, implementation and deployment of the Management Reporting solution using Confidential ASO technology for a multinational Hotels & Resorts Company.
• Migrated existing applications to new Hyperion System 9.3.1 environment.