We provide IT Staff Augmentation Services!

R. Hyperion Essbase/planning Consultant Resume

San Jose, CA

SUMMARY:

  • 14 years of total IT experience of which Over 6+ years of experience in design, analysis, development and implementation of various applications in Client/Server environment using ETL, Hyperion Essbase 11.x,9.x, & 7.x, Hyperion Planning, Hyperion Reports, ESSCMD, MaxL, Essbase Excel Add in, Essbase Query Designer, under Windows 2000/NT4.0 and Unix environment.)
  • Experience in providing services related to Hyperion BI Platform OLAP Essbase server & Client tools such as Application manager, Integration Services, Planning, and Administrative Services, that combines data integration, metadata management, and online analytical processing (OLAP) with query and reporting.
  • Involved in different Hyperion Planning application integration, migration and production support.
  • Excellent proficiency in Hyperion Planning web - forms (Planner group, admin group).
  • Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports
  • Developed Foreign Exchange rate web-form to support multi currency budget application without using in-build multi currency budget functionality in Hyperion Planning.
  • Implemented Driver based methods using smart list in Hyperion Planning for various calculation. To support Salary calculations (% Sal per year, % Sal per month), Headcount Adjustment, Salary Band.
  • Excellent proficiency in Business rules.
  • Developed Hyperion Planning Security.
  • Involved in Hyperion planning application migration for QA and Production environment.
  • Excellent proficiency in Hyperion Planning end user (Financial Users) training, training documentation and daily production support.
  • Developed generic scripts to take back up for Hyperion Planning Applications (Essbase cubes & Relational Database).
  • Developed Error log reporting system to send out to user before the scenarios occur during Actual load in Hyperion Planning.
  • Excellent proficiency in both Star Schema and Snow-Flack Schema data modeling techniques.
  • Having Strong knowledge and expertise in Optimization of Dimension Building and Data Loading.
  • Excellent control over ESSCMD for total automation of the process.
  • Strong in developing Use Case Model, Analysis Model, Design Model, Implementation Model.
  • Excellent knowledge of data analysis and modeling.
  • Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Meta Data Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
  • Having extensive experience in integrating Business Analysis, Multi-Dimensional Modeling using Hyperion Essbase, creating, manipulating and maintaining calculation scripts (Calc Scripts) using Planning, Business Rules and creating reports using Hyperion Reports to help financial facilities and other business logics in an organization. Executed data migration between different Hyperion applications.
  • Involved in Hyperion Applications Development and Production Support. Experience in providing Support & Maintenance for Hyperion OLAP Essbase Systems, including both client and server level services and consulting.
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
  • Expertise with Microsoft Office tools

TECHNICAL SKILLS:

OLAP and BI Tools: Oracle Hyperion Essbase 11.x/9.x/7.x, Oracle Hyperion Planning 11.x/9.x, Essbase Administration Services (EAS), Hyperion DRM, Shared services, Essbase Integration Services, Workspace, Essbase query designer, Oracle Data Integrator (ODI), Hyperion Financial Data Quality Management (FDM/FDQM).Financial Reporting, Web Analysis, Spreadsheet Add In, Smartview, Interactive reporting (BRIO).

Languages: MaxL, MDX, SQL, PL/SQL, C, C++

Client Tools: MS Office Suite 2010, 2007, 2003, 2000.

Databases: Oracle 11g/10g/9i, MS SQL Server (2003, 2005), MS Access, Toad.

O.S.: Windows N.T /2000/XP/Server 2003, Server 2008, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1,Hyperion DRM 11.1.2.1, Hyperion Financial reporting 11.1.2.1, Windows Scheduled tasks, Hyperion Smartview, Essbase Utilities, Windows Server 2008, Oracle Database 11g.

Sr. Hyperion Essbase/Planning Consultant

Roles & Responsibilities:

  • Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training across subsidiaries.
  • Created Budgeting and Forecasting applications using Hyperion Planning Classic method for the Finance department.
  • Developed sym and asym data forms, Composite data forms, task lists, calculation scripts, define business rules with run-time prompts and menu lists for the users to enable them to enter financial data into the system.
  • Automated Outline load utility and rules files for data and metadata load in planning application.
  • Worked on performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision
  • Created a transparent partition for the ASO cube as target for BSO source cubes to enhance reporting.
  • Migrated the Planning Applications, Data forms & Business Rules from Dev to Prod Environment.
  • Designed financial reports for the upper management and comprehensive reports for the daily users by using Hyperion Financial reporting.
  • Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting.
  • Created Balance Sheet and P&L statement using financial reporting.
  • Coordinated several offshore sessions to guide them on building application specific reports.
  • Used Shared Services for defining and allocating provisions to the users of the company as per the needs of higher management.
  • Coordinated several offshore sessions to guide them on building application specific reports.
  • Used Shared Services for defining and allocating provisions to the users of the company as per the needs of higher management.
  • Performed monthly backups of Hyperion data. Helped facilitate creation and loading of quarterly budget data.
  • Responsible for month-end tie-out and provide related support to financial controllers.
  • Worked on creating design documents explaining end to end implementation of the project.
  • Conducted various workshops explaining users how to build reports in financial reporting studio.
Confidential , Emeryville, CA

Sr. Hyperion DRM Developer

Roles & Responsibilities:

  • Did the functional/performance testing of the new DRM system.
  • Gathered the requirements for developing new versions/Hierarchies.
  • Developed brand New Hierarchy in DRM by using importing.
  • Created derived and defined attributes which are required for the DRM system and for the hierarchy maintenance in DRM.
  • Developed exports for the data validation and the maintenance of the metadata.
  • Created validations in DRM.
  • Created Sort by property for the Sorting order to be in control.
  • Categorized the exports based on each version by creating books.
  • Created node types and associated them with Property categories for populating property categories.

Confidential , Emeryville, CA

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3.Hyperion DRM 11.1.1.3, Hyperion Interactive Reports Studio 11.1.1.3, Hyperion Financial Data Management 11.1.1.3, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Oracle Database 11g, Windows server 2003/Linux.

Sr. Hyperion Essbase/Planning Developer

Roles & Responsibilities:

  • Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
  • Performed metadata building using outline load utility for different dimension and various applications.
  • Worked on Creating Locations, Import formats, and mapping for loading data into Essbase applications using Hyperion FDM.
  • Setup security for FDM locations for users.
  • Developed Dynamic Web forms for various applications with POVs, menus, run time prompts and Pages.
  • Build various business rules for to perform various calculations for different application. Build admin rules and user rules.
  • Worked on building rule files for data load and metadata loading for ASO applications.
  • Worked on migration of applications from development server to Pre-Production and Production server.
  • Worked on security in shared services. Build various security filters and granted access to the application and its dimensionality according to the requirement provided. For various users/groups.
  • Worked on MAXL scripting for automation. Used MAXL scripts in batch files for performing data and metadata
  • Designed and developed various types of chart reports, pivot reports, view reports, tabular reports in Interactive reporting.
  • Created Dashboards getting data from Oracle & Essbase cubes in Interactive Reports.
  • Worked on Design Documentation for various applications. Explained from starting to end about the description of application. Its dimensionality, various data forms, menus associated and business rules. The Various financial reports associated with it.
  • Worked on providing User training documents. Build Documents (excel files) describing the data forms, how they work and business rules association with them and what rule is doing.
  • Worked on designing filters for the entire reporting cube giving user read access to Essbase.
  • Modified Essbase filter for planning applications giving users write back capabilities in smart view for their specific security allotment.
Confidential , Emeryville, CA

Sr. Hyperion DRM Developer

Roles & Responsibilities:

  • Created version and Hierarchies in DRM.
  • Loaded the data by Automator and also by creating import profile in DRM.
  • Created properties and categories in DRM.
  • Built the logic for the hierarchies in DRM.
  • Created both Read only hierarchies with no export profiles and also hierarchies with export profiles in DRM.
  • Done incremental loads in DRM.
  • Worked on security in DRM.
  • Scheduled tasks in DRM using windows scheduler.
  • Created a release document for deploying the hierarchy in DRM production environment.

Confidential, Melville, NY

Environment: Hyperion Essbase 9.3.3/11.1.1.3, Hyperion Planning 9.3.3/11.1.1.3, Hyperion Financial Reports 11.1.1.3, Hyperion Integration Services, Hyperion Administration Services, Oracle Data Integrator (ODI), Hyperion Web Analysis, MAXL, ESSCMD, Excel Add-In, Windows NT/2000, Oracle 9i.

Sr. Hyperion Essbase/Planning Consultant

Roles & Responsibilities:

  • Upgraded Hyperion system from version 9.3.3 to 11.1.1.3.
  • Involved in production support and maintenance of four existing cubes.
  • Responsible for the conversion of a BSO application to ASO.
  • Created planning application using Workspace and Planning Studio.
  • Developed custom fact table according to business needs.
  • Developed business rules and calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance and budgeted cash flow statements.
  • Automated the dimension build and data load process using MaxL Scripts.
  • Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
  • Designed Task lists and Workflow process for all the Planning applications.
  • Used the Conditional Suppression functionality in Financial Reporting to suppress the rows/columns to display dynamically based on Prompts, User POV.
  • Extensively used Traffic Lights in Web Analysis Reports.
  • Used ODI as a data integration (ETL) tool.
  • Created Data Integration interfaces, procedures and projects for loading SQL and File System data into Planning and Essbase using ODI.
  • Use of Operator GUI within ODI in-order to debug data loading issues and also schedule procedures.
  • Created Users and groups in Hyperion Shared services and assigned privileges to them.
  • Optimized the existing cubes and calculation scripts to improve the performance.
  • Applied security on different applications by creating Filters on its dimension members.
  • Extensively involved in documentation and end user training.

Confidential, Dallas, TX

Environment: Hyperion System 9, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View, Windows NT, Oracle 10g

Hyperion Essbase Consultant

Roles & Responsibilities:

  • Developed complex formulas and calc scripts reflecting the business user’s requirements.
  • Created rules files for building Dimensions dynamically and loading data.
  • Executed calculations such as Dynamic calc, Two-Pass Calc, Intelligent calc on application outlines.
  • Conducted Essbase performance tuning and troubleshooting activities such as periodic export and data load, re-arranging the Dimensions for optimized performance.
  • Loaded data by writing automated batch files.
  • Analysis of variance - current year’s performance vis-a-vis last year’s budget.
  • Generated ad-hoc reports using Hyperion Reports.
  • Monitored monthly and weekly data load.
  • Designed and developed predefined management reports using Hyperion Reports and Hyperion Analyzer, and also generated ad hoc reports using Hyperion Essbase Excel Add-in.
  • Involved in security setup, Filters for user groups in Essbase and Web reports.
  • Provided troubleshooting and advice to improve the current Essbase database.

Confidential , North Wales, PA

Environment: Hyperion Essbase 7.1, Excel Add-In, Hyperion Reports 7.0, Oracle 9i, Windows NT/2000 and UNIX SUN Solaris

Hyperion Essbase Developer

Roles & Responsibilities:

  • Worked on design and development of different cubes used for creating reports about various business strategies, decision-making and future planning.
  • Involved in developing design specifications of Essbase cube with customers.
  • Extensively involved in designing and modifying the outlines for Essbase Cubes.
  • Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
  • Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
  • Developed OLAP Models and Meta outlines using Essbase Integration Services from star schema in relational databases.
  • Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Reports.
  • Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection.
  • Optimized the applications to bring down the runtime and database size considerably.
  • Involved in production support and maintenance of existing cubes.

Confidential, Reston, VA

Environment: Hyperion Essbase 7.1, Excel Add-In, Hyperion Reports 7.0, Oracle 9i, Windows NT/2000 and UNIX SUN Solaris

Hyperion Essbase Developer

Roles & Responsibilities:

  • Involved in the installation of Essbase Administration Services, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer and Hyperion Application Link in Windows environment.
  • Migrating Essbase cubes into newer versions and newer operating systems.
  • Involved in analysis, development and enhancement of database (MDDB) outlines.
  • Responsible for creating users and groups and providing authorization to them.
  • Provided Essbase technical supports to all business units, offered suggestions and proposed solutions to resolve issues
  • Developed EIS OLAP Models and Meta outlines for the cube.
  • Created one Essbase cube for DFS’s financial data related to the cost of processing checks and credit cards.
  • Restructured and redesigned previous Essbase cubes.
  • Involved in the performance tuning and optimization of data load calc scripts.
  • Used ESSBASE functions like @RELATIVE, @SUMRANGE and @SHIFT in creating the Calc Scripts.
  • Extensively used MaxL, ESSCMDS for creating batch files for automation.
  • Hyperion Planning was used to maintain data access to the cube.
  • Used Hyperion Planning environment to build interfaces and upgraded Business Rules.
  • Created numerous new web forms in Hyperion Planning from sample Excel Mock Up’s.
  • Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends and Expense Variances over prior periods.
  • Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Reports, Hyperion Analyzer.
  • Involved in defining requirements, functional specifications, designing documentations and testing strategies.
  • Responsible for providing training to the end users.

Confidential, Waltham, MA

Environment: Hyperion Essbase 7.15, Hyperion Web Analysis 7.0, Excel-Add in, MaxL, Windows, Oracle 9i.

Hyperion Essbase Developer

Roles & Responsibilities:

  • Designed and developed two BSO cubes
  • Created rules files for dimension building, and loading data into cubes
  • Developed Calc scripts to perform aggregations on the database
  • Optimized Cubes for faster calculations and performance.
  • Designed MDX queries using Essbase Query Designer to retrieve data when report is processed.
  • Used Hyperion Reports to generate reports for forecasting monthly expenditures, expense management
  • Provided technical support for existing cubes, problem identification, resolution and documentation

Confidential

Financial Analyst

Roles & Responsibilities:

  • Involved in migration of an offshore project related to cash exception.
  • Guided in the training to the pilot team members.
  • Extracting reports from the Citrix website and preparing dashboard on the reports.
  • Provide financial reports requiring excellent communication skills and solid quantification capabilities.
  • Involved in project with client for the preparation of automation script.
  • Processed payrolls and providing daily reconciliations.
  • Prepared customized reconciliation statements on the request of business partners which are referred to as Specials or Ad-Hoc request.

Hire Now