SUMMARY:

• Senior resource with around 12+ years of technical & Management experience in Hyperion & BI.
• Technical experience includes Oracle’s Hyperion 9.x & 11.x Suite including HFM, Hyperion Planning, FDM, FDMEE, Essbase, Financial Reporting, Interactive Reporting, Web Analysis, Workspace and shared services.
• Functional experience working with the Financial Planning & Analysis (FP&A) Team to simplify their business process and enhance their reporting abilities
• Experience with upgrading to Hyperion System 9, System 11 and 11.1.2.4
• Knowledge of BI Tools including Cognos 7, Business objects 8, ReportNet, OBIEE
• Trained in ETL Tools namely Datastage, Informatica, Abinitio
• Experience in Datawarehouse and Dimensional modeling techniques
• Experience in Full cycle implementation of Hyperion Suite of products.
• Experience with onsite offshore model in implementation and support of products
• Working with the Financial Planning & Analysis Team to help simplify their business process and enhance the reporting capabilities
• Help setup the month end process
• Work closely with the Business users on the Forecasting and Annual Budgeting process
• Translate the FP&A and Finance Teams business requirements to feasible technical specification.
• Architect new solutions to help facilitate business process.
• Maintain and administer the existing Financial and Planning application.
• Enhance and improve synchronizing the data between HFM & Planning systems.
• Work with the functional teams to help align the Financial systems whenever there is an organizational restructure.
• During acquisitions or mergers of an organization, work with the management & technical team to integrate their financial systems.
• Initial application setup such as creating an application profile and registering with shared services
• Design & develop Metadata - Dimensions, Rules, Workspace, Data Forms, Data Grids, Journal Templates, etc.
• Design and implement user provisioning details using Shared services and Security Classes for each dimension
• Application migration from HFM 3.5 to HFM 11.1.1 to 11.1.2.4 - Design & document the variances in data
• HFM Artifacts & Data migration
• Support / Maintenance of Application which includes creating and maintaining Metadata & Business Rules
• Support data approval process through Process Management
• Help with the Organizational restructure utilizing HFM’s org by period
• Maintain the Investment Subsidiary relationship in an organization using ownership percentage
• Automate certain HFM processes using Taskflows
• Creating an application and integrating with HFM
• Setting up the locations
• Identify relevant source systems (ERP’s), design and develop the required data formats for each location
• Load maps and data files
• Handle Data Load Rules
• Setting up Validation / Consolidation for every location
• Create Validation scripts to test the data load and provide reports on their validated data
• Develop test cases to test the developed artifacts to meet the business specifications
• Also involved in migrating mapping tables from HAL for all sites to FDM.
• Migrate from FDM to FDMEE 11.1.2.4
• Setup artifacts in FDMEE and Jython import scripts
• Creating Application
• Creating Data Forms / Templates for the Budget and Forecast process
• Setting up business rules for various allocations
• Manage approval process using process control
• Migrating Planning applications between different environments
• Migrating / Copying Data between applications
• Create and maintain Calc scripts for various activities like aggregation, currency translation for multi-currency support, elimination, allocation, etc.
• Developing business rules for budgeting processes
• Use Task flows to move data between HFM & Planning utilizing HFM’s elimination logic during the forecast process in Planning.
• Automate Scripts to move data from HFM to Planning during the forecast process and utilize the calculation scripts in planning to mimic the elimination logic in HFM
• Use FDMEE to extract data out of HFM and load it into Planning
• Report Development / Migration using Hyperion Financial Report Studio
• Implementing Dashboard facilities using web analysis for reporting to the Senior management
• Create Dynamic excel reports using Hyperion Smart View Excel Add-in
• Install Hyperion Suite of products (System 9 & 11)
• Experience with system upgrade to 11.1.2.4
• Migrate FDM to FDMEE
• Maintain regular Patch updates to keep the systems up to date.
• Setup application related backup and restore procedures
• Work with Organizations infrastructure team on the Windows and Bowser compatibility to support the application.

TECHNICAL SKILLS:

Application Tools: Hyperion System 9 & 11 includes HFM / HP / FDM / FDMEE/ EPM / Essbase

BI Tools: Hyperion BI Interactive Reporting, Hyperion Financial Report, Web Analysis studio, Cognos 7.2, Report Net 1.1 M.R. 1, OBIEE

ETL Tools: Datastage 7.3, Informatica 6.2

Database development tools: SQL Server 2005, Oracle 9i & R12, MS-Access

Operating Systems: MS-DOS, Windows XP, Sun Solaris

Web technologies: Java, J2EE

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Lead

Responsibilities:

• A Motor Manufacturing, USD 3 billion company that contains a wide distribution of Operating Divisions and Subsidiaries. We were administrating the Consolidation application on Hyperion Fusion Edition.
• Budgeting and Forecast Process is also maintained using the same application. HFM is used for the monthly Financial statement reporting and Planning & Essbase for the Budgeting and Forecast process along with FDM which will be the regular data load for the Actual numbers on a monthly basis.

Technical Environment: HFM, Planning, FDM, FDMEE & Essbase 11.1.2.4,OBIEE R12

Confidential

Hyperion Manager

Responsibilities:

• General Trading, USD 5 billion company that contains a wide distribution of Operating Divisions and Subsidiaries. We were administrating the Consolidation application on HFM 3.5 and HAL. Budgeting and Forecast Process is also maintained using the same application. The application was then migrated to HFM Fusion Version 11.1.1 to in corporate the functionalities of OrgByPeriod and Audit Reporting on the Fusion Edition and to implement Hyperion Planning & Essbase for the Budgeting and Forecast process along with FDM which will be the regular data load for the Actual numbers on a monthly basis.

Technical Environment: HFM, Planning, FDM, Essbase & WebAnalysis 11.1.2.1

Confidential

Hyperion Sr. Consultant

Responsibilities:

• As a leading global entertainment content company, our client has a wide distribution of Operating Divisions and Subsidiaries. It uses HFM 9.2 as their consolidation application and loading financial data into the consolidation application is through FDM 9.2. It is a support and enhancement project that involves, maintaining their existing application that constitutes HFM, FDM and FR along with enhancements to the existing application.

Technical Environment: HFM, FDM & Financial Report Studio 9.2,MS SQL 2000

Confidential

Project Lead / Application Administrator

Responsibilities:

• Our client is a technology-driven USD 5 billion company that contains a wide distribution of Operating Divisions and Subsidiaries. The project involved building their consolidation application using HFM 9.3 to overcome the limitations of their existing consolidation application Enterprise 6.4 which included, distribution of the functionality of quick & easy data load at their respective entity levels with proper validation of data using Hyperion’s Financial Data Quality Management, restructuring / building their consolidation hierarchy leveraging the functionalities of Hyperion Financial Management 9.3, providing options to consolidate the Financial Data at Operating Division level.

Technical Environment: HFM, FDM & HFR 9.3, MS SQL Server 2005

Confidential

Designer/Application Administrator

Responsibilities:

• The client requires developing adhoc and standard analysis reports and dashboards for analyzing commodities trading activities in various regions and by various time frames such as monthly, quarterly, semester and annual. The data for analysis would be made available by a group of economists through excel sheets. This would be loaded into an Oracle staging area for data cleansing and preparing for upload into Essbase. Reports and dashboards were generated from the Essbase outlines

Technical Environment: Hyperion Web Analyzer, Interactive Reporting, Essbase 9.3, Oracle 10g

Confidential

Designer/Developer

Responsibilities:

• The client requires developing reports for their inventory Data Mart and Sales Data Mart to keep track of their Item’s Quantity Sold and Required Quantity & other key metrics to take corrective actions when the actual values deviate from the planned values. The Client had JDE as their ERP with Oracle 9i as their backend. Data Entry is done through the ASP Pages. Other data such as transportation cost, complaint details, etc. came into the system through excel files. The reports had to be developed using Hyperion Interactive Reporting.

Technical Environment: Interactive Reporting Studio & Workspace 9.0,Oracle 8i