SUMMARY:

A Vision driven Integration expert, Analytical and Certified Professional with over 20 years of experience in Oracle Hyperion Application Solutions for clients in the private, public and industrial sectors. Certified Oracle Hyperion Specialist Technical Developer, Administrator and Performance tuner. Responsible for implementing best practices in different areas of Hyperion. A well versed in multiple Hyperion products on Windows, UNIX and Linux.

CORE COMPETENCIES:

Hyperion EPM

Hyperion HFM

Hyperion FDMEE

Hyperion Planning

Hyperion Essbase

Hyperion DRM

Hyperion ODI

Oracle Data Integrator

Data Integration

Oracle Database

SQL Server Database

Financial Statements.

Complex Problem Solving

Software Development

System Documentation

ORGANIZATIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle Hyperion Specialist

Responsibilities:

• Analyzed Existing FDM System for Locations, Data Load, VBS Scripts.
• Created EPM - EPM Integrations for HFM-HFM Loads.
• Recommended Jython Scripts and Batch Scripts from command line for FDMEE System.
• Made Recommendations about how existing load functionality can be recreated in FDMEE using Mix-n-Match load Strategies.

Confidential

Technical Developer

Responsibilities:

• Essbase Development & Performance Tuning
• Successfully resolved problems with Hyperion Services.
• Resolved access, locking, performance, timeout issues within various modules of Hyperion Infrastructure.
• Applied new Parameters to Administration services for continual functioning.
• Essbase Forecast Calculation Enhancement - Updated the calc scripts with new logic.

Confidential, Los Angeles, CA

Technical Developer

Responsibilities:

• FDM to FDEE Upgrade, HFM & Essbase Upgrade (11.1.2.2. to 11.1.2.4)
• Analyzed the FDM classic system with 53 locations and 95 VBS scripts for conversion purposes.
• Created Import formats, Locations, Mappings, Data Load Rules.
• Loaded flat files to converted locations.
• Converted VBS Scripts to python scripts. Resolved issues that came up with script conversion and logic.
• Hyperion Installation and Patchwork
• Installed Hyperion Products (Foundation, Essbase, Reports, SmartView, HFM, FDMEE, RA Framework, Calculation Manager, Oracle Http server) 11.1.2.4 on Windows 2012 R2 Servers with SQL server repositories.
• Applied patches as and when needed.
• Tested the install with sample applications. Upgraded shared services and application security from previous environment to new environment. Documented the install process. Created maintenance scripts.
• HFM Upgrade
• Upgraded Classic HFM application with Actuals and History.
• Upgraded Metadata, Data, Rules, Data Grid Forms and Security.
• Resolved many issues with upgrade.
• Loaded data and exchange rates.
• Assisted in data reconciliation with previous application.
• Essbase Upgrade
• Upgraded 3 BSO applications and 1 ASO application from 11.1.2.2 to 11.1.2.4.
• Loaded Outlines, Data Load rules, security, permissions and data.
• Assisted in data reconciliation and update of new environment.

Confidential, Miami, FL

Oracle Hyperion Administrator

Responsibilities:

• Created Integrations in FDMEE for data loads to HFM, Hyperion Planning and Essbase.
• Created Import formats, Locations, Mappings, Data Load Rules.
• Loaded flat files, Essbase RPT reports into Hyperion applications.
• Created EPM-to-EPM integrations for loading Essbase data into HFM.
• Created FDMEE batches for automated loads.
• Created Windows automation scripts.
• Wrote Jython import scripts and mapping scripts.

Confidential, Middlesex, NJ

Oracle Hyperion Administrator

Responsibilities:

• FDMEE/DRM Installation and Configuration 11.1.2.3
• Installed FDMEE on Windows 2008 Server.
• Performed prerequisites like creating SQL database, OS tasks.
• Installed software, applied critical patches to system.
• Integrated FDMEE with existing Hyperion environment comprising of HFM, Planning and Essbase. Configured Weblogic server to integrate new Hyperion environment.
• Created test file integrations to verify system functionality.

Confidential, St Louis, MO

Oracle Hyperion Administrator

Responsibilities:

• FDMEE Data Load 11.1.2.3.5 00
• Created locations for data loads (Single period and multi period) to Planning (BSO) and ASO Essbase cubes.
• Loaded explicit mappings from files.
• Wrote Jython mapping script for Entity Mapping.
• Loaded monthly data from 3 sources HFM (Native extracts), Planning (Essbaserpt extracts) and a flat file.

Confidential, Dallas, TX

Oracle Hyperion Administrator

Responsibilities:

• Mapping scripts and data load - 11.1.2.3
• Created locations for data load.
• Wrote Jython Mapping scripts for ICP dimension.
• Created mappings for other HFM dimensions.
• Performed data load into HFM and validations.

Confidential, Irving, TX

Oracle Hyperion Administrator

Responsibilities:

• Hyperion Infrastructure - Upgrade - Administration 11.1.2.3.5
• Installation - Installed Hyperion 11.1.2.3 Foundation, EAS, Essbase, FR on Linux.
• Installed Linux packages, created users, permissions and performed prerequisites for Hyperion install.
• Fixed configuration and connectivity issues between Hyperion servers.
• Migrated Hyperion planning and related artifacts from old development environment to new development environment.
• Migrated oracle schemas to newly named schemas for planning. Migrated security groups, roles and users for planning.
• Upgraded Hyperion planning from 11.1.2.2 to 11.1.2.3 on Linux servers.
• Applied patch 500 to further upgrade to 11.1.2.3.5 00 .

Confidential, NewtownSq, PA

Performance Tuner

Responsibilities:

• Hyperion Administration 11.1.2.3
• HFM admin - Performed LCM backups of metadata, data, grids forms and journals. Resolved
• Reports performance issues and performed day to day admin requests from users. Updated HFM application with new.
• Data using files from SQL server db.
• Planning Admin- Performed LCM backup of planning objects like webforms, business rules, took Essbase data backups.
• Fixed issues with smart view retrieval Installation - Installed.

Confidential, St Louis, MO

Oracle Hyperion Data Relationship Management Implementation Specialist

Responsibilities:

• Hyperion Planning- Essbase Performance tuning (v 11.1.2.2)
• Calc Script and Business Rules Tuning.
• Analyzed Forecast calcs and business rules and tuned them to run faster.
• Tuned Essbase export scripts.
• Updated Essbase configuration, Application and script settings to make best use of system resources.
• Miscellaneous Hyperion Tasks.
• Resolved many daily issues like EPMA dimension load problems.
• Data load issues, XCP files, Refreshing Development and QA from Production.
• Fixed Webform issues, reports issues.
• Wrote formulas for new members. Took Backups of apps. Updated Business rules.
• Wrote new calcs.

Confidential, Palo Alto, CA

Oracle Hyperion Implementation Specialist

Responsibilities:

• HFM Administration - Resolved problems with HFM apps in multiple environments. Took LCM backups of Grids and XML exports of reports and reports.
• Worked on reloading EBS data using ERPiin stage environment and fixed issues and reconciled with production.
• Fixed issues with planning server, data sources and webform problems.
• Updated Hierarchies, Added Nodes, loaded members using automation scripts and import profiles.
• Generated exports. Used Blenders to merge hierarchies.
• Performed backup, User access/ Security configuration of DRM.

Confidential, San Francisco, CA

Oracle Hyperion Specialist

Responsibilities:

• Created main and reporting hierarchies in excel from source files for two HFM applications.
• Hierarchies were of commonly used HFM dimensions (Account, Entity, Customs, and POV’s).
• EPMA/HFM Hierarchy build.
• Created/Updated Applications using EPMA.
• Created ADS files for loading in EPMA.
• Accounts, Entity, Customs, Scenario, Year, Period.
• Created and updated 2 applications in HFM.

Confidential, Atlanta, GA

Oracle Hyperion Specialist

Responsibilities:

• Hyperion Administration (v 11.1.2.1)
• Hyperion Planning Administration: Administered Planning applications in Development, QA and Production environment.
• Performed user tasks like data load, calc script execution, LCM migration, Security setup and refresh.
• Hyperion Essbase Administration.
• Created/Updated Applications using EPMA, Load rules, calcs, maxl scripts.
• Fixed issues relating to environment availability, took backups, performed application recovery, and updated Essbase cfg for applications and system.
• Installed EPMA batch client, Fixed Metadata load issues. Fixed batch client script issues.

Confidential, Houston, TX

Oracle Hyperion Specialist

Responsibilities:

• Hyperion Disaster Recovery Analysis and Enhancement (v 11.1.2.1)
• Assessment - Assessed current Hyperion Planning/HFM environment for Disaster Recovery Readiness.
• Installation - Installed Essbase on Windows2008 Server.
• Integrated new server with Hyperion infrastructure.
• Tested Functionality of the Disaster Recovery System.
• Tested EPMA with ADS files and LCM imports in Shared Services.
• Automation.
• Enhanced Lifecycle Management (LCM) script and Migration Definition file for backup from Production Hyperion and import into DR system.

Confidential, Lyndhurst, NJ

Oracle Hyperion Specialist

Responsibilities:

• Essbase Global Cube Technical Design & Analysis (11.1.1.3)
• Essbase - Analyzed existing cubes for metadata and data and for consolidation Purposes.
• Documented metadata and data structures for US, Asia-Pac, Korea, Japan and Regional cubes.
• Created Mapping documents for all regional cubes for all dimensions and provided to business users.
• Created a technical design document for how regional cubes merge to form a Global cube and outlined various parameters.
• HFM Rules Enhancement (11.1.2.1)
• HFM Rules - Added Minority interest rules for Equity Accounts in Calculate subroutine.
• Added CTA Rules for certain accounts. Suggested solution for Smart view Workspace retrieval problem.
• Provided solution for Updating Account Type so translations can be performed on them.

Confidential, St Paul, MN

Oracle Hyperion Specialist

Responsibilities:

• Performed validation to assess PeopleSoft’s readiness for configuration with ERPi. Configured ERPi to pull data from PeopleSoft GL.
• Setup source system, Period mapping, Locations, Import format, data load rule.
• Resolved many issues that occurred during above configuration. Worked on configuring ERPi for PeopleSoft Commitment control module.
• ODI Configuration - Configured ODI master and workoft repository to pull data from PeopleSoft GL and load into ERPi and connected to Hyperion Planning for receiving data.
• FDM Configuration - Configured FDM to receive data from Erpi and load into Hyperion PSPB (Public Sector Planning and Budgeting) application.
• Hyperion Essbase, EIS Upgrade (v 7.1 to 11.1.2.1)
• This assignment occurred in parallel with one below it ( Confidential ).
• Installation - Installed Hyperion 11.1.2.1 products (Shared Services, Oracle Weblogic, RA Framework, Essbase, Web Analysis, Essbase Integration Services (EIS) on Windows 64 bit servers and SQL server on two environments, Production and Disaster Recovery. Attached Active directory for user authentication.
• Essbase Integration Services / Essbase Cubes - Upgraded EIS model and Metaoutline to generate Essbase cubes to new Production and Disaster Recovery environments.
• Resolved issues that occurred during upgrade process.
• Upgraded Automation scripts for above module.
• Hyperion Reports - Upgraded reports from old version to new version.
• Security created security groups and assigned permissions in new environments for accessing various modules of 11.1.2.1

Confidential, Houston, TX

Oracle Hyperion Specialist

Responsibilities:

• Updated Outline based on new hierarchies. Applied XREF Functionality.
• Created new data load rules. Updated Calc scripts.
• Resolved problems with reports, applied security in shared Services.
• Resolved access, locking, performance, timeout issues within various modules of foundation server.
• Enhanced automation by introducing more debugging help via File loads instead of SQL loads.
• Installation - Installed Hyperion 11.1.2.1 products (Shared Services, Oracle Weblogic, RA Framework, Essbase, Web Analysis) on Windows 64 bit servers and SQL server on two environments, Development and Production.
• Essbase Cubes - Upgraded 4 Essabse cubes to new Production and Development.
• Resolved issues that occurred during upgrade process.
• Hyperion 11.1.2.1 Administration
• Updated Essbase server parameters for Hyperion planning performance. Established Essbase filter security.
• Suggested patch for EPMA business rule problem.
• Resolved Essbase retrieval problem for ASO cube.
• Hyperion 11.1.2.1 Installation and FDM (now FDMEE) Development
• Installation - Installed the latest version (11.1.2.1) Hyperion products (SS,OracleWeblogic, RA Framework, HFM, and FDM) on Windows 64 bit servers and SQL server on three environments, Development of QA and Production.
• Fixed many issues on new installs. Migrated FDM app from Dev. to QA and then to Production.
• FDM Development - Created Locations, Maps, Control Tables, Event Scripts. Loaded data into HFM via FDM (SAP data).
• FDM-ERPiIntegration Review (now FDMEE)
• Reviewed current system, modules and connections to General Ledger (EBS12).
• Studied current installation of ODIand provided estimate of work and duration. Wrote a replica table HFM business rule to resolve an account override problem.
• HFM-FDM (now FDMEE) Upgrade (v9.3.1 to 11.1.1.3)
• Installation- Installed and configured software (SS, Workspace, HFM, FDM, Reports) on windows servers.
• Upgrade- Extracted HFM data and metadata from version 9 and loaded into version 11.Performed extracts from FDM and loaded into 11.Extracted and loaded reports. Fixed many issues that occurred during upgrade.
• Data Reconciliation- Assisted corporate users during data reconciliation between new and previous versions.
• Security - Replicated security from version 9 to 11.
• Go-Live Support- Performed Hyperion v11 Disaster Recovery system configuration.
• Assisted Users with reconciliation tasks and use of new system.
• Hyperion DRM (v9)-Essbase
• Resolved the Load issues with DRM. Created Structures, Properties, validations, imports, exports, blends from new data source and for loading into Essbase.
• Resolved Attribute Dimension problem while loading Hyperion Essbase Metadata. Corrected underlying Dimension Configuration issue and rebuilt Essbase apps and databases.
• Configured FDM to pull data from Oracle E-Business Suite v 11 and load into HFM.
• Installed ODI, Erpi. Performed Physical-Logical Schema configuration in ODI.
• Created FDM Locations for Data load from EBS.
• Performed ERPi configuration for FDM.
• Created Metadata and Data Load rules in FDM-ERPi.
• HFM-DRM - performed Metadata addition for entity reorganization.
• Created node types, hierarchies, hierarchy groups, properties. Generated export files for various dimensions for loading purposes.
• Used automate and import profile for uploading data in DRM.
• Updated business rules and loaded data for the new entity structure.
• Added email functionality in FDM. Emails were sent at various stages of FDM multiload Workflow process.
• Coded Scenario, User group based email notifications.
• Coding was performed for Import, Validate and After Load events.
• Hyperion Planning Performance Tuning
• Performed tuning on Hyperion Planning Application.
• Configured dense and sparse dimensions.
• Assigned appropriate parameters to applications.
• FDM Enhancement and Upgrade to 11.1.1.3 (now FDMEE)
• Added the Hyperion Planning module in existing FDM-HFM system (9.3.0). Assisted in FDM v11 install in Development and QA Environment.
• Moved the code to v11.1.1.3 and made it functional. Work also included adding Hyperion Planning code to event scripts and adapter code.
• Created new planning locations and Import Formats.

Confidential, Newtown Sq, PA

Oracle Hyperion Specialist

Responsibilities:

• Diagnosed and Resolved workspace problems. Verified Hyperion Planning, Essbase, EAS functionality.
• Performed HFM Backup.
• Resolved HFM server issues with DCOM components.
• Synchronized Shared Services database with Open LDAP.
• Created Locations for Ledger Systems in Oracle ERP and Flat files.
• Worked with database personnel to prepare data to load in FDM Applications.
• Provided Assistance in HFM Metadata preparation regarding member properties.
• Assigned Financial controls to data locations. Loaded FY08 data in system. Prepared Control tables. Assisted in extracting mapping info from legacy system.
• Created and loaded Mapping tables for Account, Entity, and ICP and Custom dimensions.
• Internal HFM-FDM (now FDMEE) Implementation- Oracle/Hyperion v 11.1.1.1
• Used new EPMA functionality to create Metadata, FDM to Load Data.
• Resolved Problems in Configuration, Security and other development areas.
• Created Base applications for Currency translation.
• Installation- Oracle Hyperion EPM 11.1.1.1 Fusion Edition
• Installed Hyperion products (11.1.1.2) Hyperion Fusion Edition- HFM, Foundation Services, Reporting Products (FR, IR, WA), Essbase, Essbase Integration services, BPMA on Java container.
• Configured Active Directory with Shared Services.
• Installed ODI 10.1.3.5 with Java Container/Axis.
• Built an ODI to ESSBASE interface. Built ODI(10.1.3.0) Projects, TechnologiesSeacastle, Princeton, NJ May 2009
• HFM-FDM (now FDMEE) Repair
• Fixed Configuration Problems of FDM with HFM (9.3.1).
• Tested Shared Services, Workspace, WebAnalysis, Financial Reporting, Smart viewto ensure connectivity among components.
• Addressed Reconfiguration of Hyperion Infrastructure Servers and HFM cluster. Ensured Shared Services was connected properly to Active Directory.
• Performed checks on Metadata, Consolidation and Data Entry Grids, Webforms, Member lists, Data and Business Rules and readied Applications for Reconciliation process. Prepared documentation for Hyperion System9 Features and Usage (HFM and Reports Usage).
• Installed Hyperion products(11.1.1.2) Hyperion Fusion Edition- HFM,FDM(now FDMEE),Hyperion Planning,Foundation Services, Reporting Products (FR,IR,PR,WA), Essbase,Essbase Integration services, BPMA, DRM/MDM on Weblogic Web Server.
• Installed ODI 10.1.3.5 with Weblogic/Axis.
• Created ODI Connections with Essbase, Planning and HFM. Installed Hyperion Strategic Finance and setup security.