We provide IT Staff Augmentation Services!

Hyperion Consultant Resume

0/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • Over 8+ years of IT experience, with 6 years in administration, design, development, analysis, and implementation of various applications in Client/Server OLAP environment using Hyperion Essbase and Hyperion Planning.
  • Experience in Hyperion Public Sector Planning and Budgeting (PSPB)
  • Experience in Enterprise Performance Management Architect (EPMA)
  • Extensive experience with development of highly formatted complex reports using financial Reporting/Hyperion Reports with multiple data sources
  • Experience in installing Hyperion product patches
  • Extensive knowledge of PL/SQL and SQL in writing queries, creating stored procedures, tables, schemas and functions
  • Working Knowledge with building dashboards in WebAnalysis and Interactive Reporting
  • Experience with building and deploying Hyperion Planning applications from the conceptual stage
  • Proficient in technical documentation including Design, SLAs, Requirements, Application maintenance and troubleshooting documentation
  • Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation for corporate finance
  • Expertise with developing on Windows and UNIX/SOLARIS environments
  • Strong database development and business intelligence modeling capabilities
  • Experience in Hyperion Essbase Security, Shared Services, User provisioning - native as-well as external authentication
  • Extensive experience on the installation, configuration, server settings, backups, client and server installations of Hyperion products such as Essbase, Essbase Integration Services and Hyperion Reports on both Windows and UNIX environments

TECHNICAL SKILLS

Tools: Hyperion Essbase 9.x/11.x, Hyperion Planning 9.x/11.x, Hyperion Essbase Administration Services(EAS).

Reporting Tools: Hyperion Web Analysis, Hyperion Financial Reporting 11.x

Languages: C, SQL

Operating Systems: Windows NT 4.0/XP/2000/2003, Oracle Solaris

Database: SQL (2008), Oracle 9i/10g/11

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Hyperion Consultant

Responsibilities:

  • Maintained Oracle Hyperion Public Sector Planning and Budgeting application
  • Suggested and improved the metadata load process from Banner to EPMA shared library
  • Evaluated and tested EPMA Scripts for automating the dimensions load
  • Evaluated and tested MaxL Scripts to run data load and calculations
  • Suggested improvements for Essbase cube performance
  • Developed both Smartview templates and Hyperion Financial Reports
  • Prepared training documents and trained users on pre built Smartview templates
  • Migrated EPMA, Planning and Essbase objects using LCM

Environment: Oracle Hyperion 11.1.2.3, Windows Server 2008 R2

Confidential, Sacramento, CA

Hyperion Consultant

Responsibilities:

  • Built a Hyperion Public Sector Planning and Budgeting application
  • Developed and maintained Essbase Application Objects such as database outlines (both BSO and ASO) and calculation scripts
  • Created Business Rules for budget cube
  • Developed complex templates for adjustment and other data entry into Essbase using Planning web forms
  • Developed complex Hyperion Financial Reports including Revenue and Expenditure reports of various departments
  • Designed and Maintained dimensional security in Planning and filters in both ASO/BSO cubes
  • Provided support and troubleshooting Essbase applications
  • Worked extensively with SmartView to upload data from PeopleSoft to Hyperion

Environment: Hyperion System 11.1.2.3, SQL 2008, Oracle Linux 6.3

Confidential, Seattle, WA

Hyperion Consultant

Responsibilities:

  • Developed complex Hyperion Financial Reports including Profit and Loss reports of various departments and Cost trend graphs for decision making
  • Installed critical Hyperion Financial Studio Patches on Oracle Solaris and Windows server environment
  • Developed various Hyperion Planning artifacts including Dataforms, validations rules
  • Designed and maintained security of users through Hyperion Shared Services
  • Proficient in migrating Hyperion Planning artifacts, Hyperion Essbase artifacts and Hyperion Financial Reports using both Life Cycle Management (LCM) and in built utilities
  • Fine-tuned the Hyperion Essbase cubes and Calscripts
  • Trained users to install and setup Hyperion SmartView

Environment: Hyperion EPM System 11.1.2, Oracle 11i, Oracle Solaris on SPARC, Windows Server 2008

Confidential, Warren, MI

Hyperion Planning/Essbase Consultant

Responsibilities:

  • Created Business Rules for allocation and forecasting related to headcount and benefits expenses
  • Examined existing process for budgeting and proposed technical changes for optimization
  • Responsible for maintaining security in Shared Services
  • Created Dataforms for Hyperion Planning application
  • Troubleshooted data validation issues as well as batch job failures
  • Rewrote the existing budgeting process including business rules, data load rules, batch jobs, outline changes and reports

Environment: Hyperion EPM System 9.3, Oracle 11i, Windows 2008 server

Confidential, Berkeley Heights, NJ

Responsibilities:

  • Created Business Rules for forecasting future year data and then allocating at brand, customer and entity level based on business process off of Raw G/L data feed
  • Developed dashboards in WebAnalysis for Key Performance Metrics & Brand Summary
  • Create Scorecard reports, Summary PnLs and KPI reports in Financial Reporting, grouped them into books and scheduled them using batches
  • Created tables and stored procedures in oracle to support the Essbase data load and dimension build
  • Involved in upgrading Hyperion from version 9 to 11 including re-writing data load and build jobs and processes as well implementing new version 11 features like transaction replay
  • Developed complex templates for adjustment and other data entry into Essbase using Planning web forms
  • Created automation to export out the budget and forecast data to load back into Oracle

Environment: Hyperion EPM System 9, Hyperion Financial Reporting 9, Hyperion Webanalysis 9, Hyperion Planning 11, Oracle 11i, Windows 2003 server

Confidential, Jersey City, NJ

Hyperion Developer/ Administrator

Responsibilities:

  • Developed automation jobs to refresh the hierarchies from MDM into the oracle warehouse and then into Essbase
  • Involved in upgrading Hyperion from version 9 to 11 including re-writing data load and build jobs and processes as well implementing new version 11 features like transaction replay
  • Developed complex templates for adjustment and other data entry into Essbase using Planning web forms
  • Created stored procedures to generate flat file extracts to feed Essbase cubes
  • Developed automation for cube build, data load, updating partitions using MaxL and windows batch scripts
  • Configured Hyperion DIM to load ledger data from Oracle Financials into Essbase cubes.
  • Developed various dashboards using Webanalysis with cascade filters, drop down menus, split panels and conditional formatting

Environment: Hyperion EPM System 9, Hyperion Data Relationship Manager (DRM) 9, Hyperion Data Integration Management (DIM) 9, Hyperion Financial Reporting 9, Hyperion Webanalysis 9, Hyperion System 9 Planning, Oracle 10g/11i, Ms SQL Server 2005, UNIX AIX

Confidential, New York, NY

Hyperion Analyst/ Administrator

Responsibilities:

  • Involved in performing DBA activities such as performance tuning the Calc scripts, database tuning, and taking the Essbase backups
  • Developed calculation scripts for budgeting and forecasting based on actual data.
  • Responsible for overseeing automation, running month end jobs, scheduling report batches and ensuring data integrity in the Hyperion environment
  • Developed VBA macros in excel to create customized excel reports using the essbase excel add in
  • Created custom graphical dashboards with pivots, charts and pinboards in Hyperion Analyzer (Webanalysis), developed javascript to provide functionality to various dashboard objects

Environment: Hyperion Essbase 9, Analytical Integration Services (AIS), Hyperion Planning 9 (workforce planning module), Oracle E Business Suite 11i, SQL Server 2005, Windows 2003 Server

Confidential

Application Developer

Responsibilities:

  • The project involved the development and customization of the Inventory management/ Purchase Order, Sales Order (IM/POSO) modules of the Materials Management System (MMS).
  • The application does the inventory management tasks like creating and maintaining purchase order, sales orders and performs excise calculations on the orders.

Environment: Oracle 7.0, Crystal Reports, Windows 2003.

We'd love your feedback!