We provide IT Staff Augmentation Services!

Sr Hyperion Planning/essbase Developer Resume

SUMMARY

  • Over 9+ years of IT experience in Oracle Hyperion Planning/Essbase in Analysis, Design, Development, Administration, Implementation, Maintenance/Support of various applications in Client/Server environment on Windows/Unix platforms
  • Extensively worked on application designing and development in Hyperion Planning 11.x/9.x, Hyperion Essbase 11.x/9.x/7.x, Hyperion Reports (Financial Reports), ESSCMD, MAXL, Essbase Excel Add - In and Hyperion Web Analyzer
  • Extensively worked in Calc Scripting, Dynamic dimension build methods, Data Load Rules, Tuning and Optimization
  • Expertise in Creation and Maintenance of Hyperion Planning applications, Business Rules, Web forms, Security Groups and Users etc
  • Strong database development and Business Intelligence Modeling Capabilities, Essbase Calculation Script & Configuration Settings
  • Skilled in Automation, Optimization, and Performance Tuning of Essbase Application Data/Metadata processing, upgrading, testing and migrating of cubes in different environment
  • Worked in Architecture design of Essbase Cubes using Block storage (BSO) and Aggregate Storage (ASO)
  • Created OLAP Models and Meta outlines using Essbase Integration Services (EIS) to populate Essbase database
  • Worked in conversion of EIS OLAP models to Essbase Studio Schemas, Writing custom Essbase calculations scripts and Automating the Essbase Cubes using ESSCMD, MAXL
  • Worked on dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes
  • Executed Master Data Conversions by working with business users and analysts
  • Supported building DRM application components as per business needs and specifications
  • Created Excel macros to filter the date at the Retrieval Time, Developed Calc Scripts working with different Foreign Exchange Currencies
  • Worked in developing complex reports in Hyperion Interactive Reporting Studio V 9.3.1 (BRIO) & Hyperion Web Analyzer 6.5/7.0
  • Expert in Hyperion Planning Forms, Security, Metadata Maintenance, Business Rules and ESSBASE Excel Add-In
  • Extensive expertise in Database Optimization with Dimension Building, Data Loading, Indexing, Formulas Oracle Calculation Scripts, Cache Management, Business Rules and Partition Management
  • Experience in creating customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the Client requirements
  • Involved in Installation, Configuration and Maintenance of Hyperion Shared services 11.x/9.x, Hyperion Essbase 11.x/9.x and Administration Services 11.x/9.x
  • Involved in upgrade of various Hyperion Software products and strong experience in working with various Databases like Oracle PL/SQL 11i/10g, SQL Server 2008/2005
  • Proficient in Software Documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules
  • Good communication skills and flexible to learn advancements in the IT industry
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment
  • Versatile team player with excellent analytical, presentation and inter-personal skills.

TECHNICAL SKILLS

Tools: & Technologies Hyperion Planning 11.x/9.x/4.x/3.x, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Analyzer7.x/6.x, Hyperion Reports 7.x, H.A.L 7.x, Financial Reports, Web Analysis

OLAP Tools: Hyperion System 9 BI+, Hyperion Essbase 9.3/7.1.5/6. x, EAS 9.3/7.1.5/6. x, EIS.

RDBMS: Oracle 7/8/8i/9i/10g, and SQL Server 2005/2000.

GUI’s: Visual Basic 6.x/5.0

TOOLS: SQL Plus, SQL Loader, ESSCMD, MaxL.

Operating Systems: Windows Server 2008/2003/XP/NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Sr Hyperion Planning/Essbase Developer

Responsibilities:

  • Involved in meetings with the business users to get the requirements, worked on documenting the detailed requirement specifications
  • Engaged in entire software development Life cycle, involved in defining requirements, participated in outlining requirements and development of a project plan with business personnel
  • Created OLAP Model and Meta data Outline for Essbase OLAP server using Essbase Integration Services
  • Developed outlines and optimized and optimized them by grouping and positioning
  • Created and modified rules files for accommodating data format changes and enabling cube loading
  • Developed Aggregate storage cubes (ASO) cubes, wrote MDX Queries for aggregate views
  • Developed batch scripts and rules files to dynamically upload dimensions and data from Legacy system to Esssbase Cubes. Developed scripts to populate the outline and data into data cubes
  • Executed performance tuning and optimization in both data retrieval and data loading scenarios
  • Extensively worked on Hyperion Planning reporting infrastructure including Metadata Layer Infrastructure, Data Acquisition and Data Distribution Infrastructure
  • Involved in developing web forms applications, assigning security, Workflow procedures and developed several planning applications as per the business needs and best performance
  • Design of BSO Cube as per the requirement, setup load rule files to load data from data warehouse into Essbase Cube
  • Designed the Excel templates for business users to load the budget data, developed MaxL scripts, Calc Scripts, ESSCMD and MDX formulas Developed SQL statements to extract data from server
  • Optimization of Data Loads and Calc scripts according to system specifications and capabilities, to reduce runtime
  • Created Planning Web input forms and task lists to load budget data into Essbase cubes
  • Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through ODI
  • Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
  • Adjusted and reconstructed the Essbase database outlines in order to optimize data loading time, database performance, and database size. In addition to reduce calculation time, Intelligent Calculation was utilized
  • Used Hyperion Web Analysis to develop and maintain various traditional and non-traditional reports
  • Created the Data forms (Web forms) and Data grids for the data representation for the end users
  • Modified existing reports within Hyperion Reports according to business requirements
  • Designed and developed complex ESSBASE applications with excellent balance of Dense and sparse dimensions, arranged in an hourglass fashion
  • Trained end users on process control for budget data and assisted in setting up smart view for data retrieving
  • Supported complete project go live and post go live support including new enhancements and loading data

Environment: Hyperion Planning 11.1.2.0, Hyperion Essbase 11.1.2.0, Hyperion Shared Services 11.1.2.0, EIS, HFM, Workspace, Oracle 11g, Smart view, Excel Add-In, MaxL, Windows Server 2008, Unix

Confidential, NY

Sr Hyperion Planning/Essbase Developer

Responsibilities:

  • Worked in end-to-end implementation activities such as design, development, testing and user training.
  • Assist in developing the Hyperion planning dimensions using the function specification document
  • Developed web forms using Hyperion Planning web client for the users to input Forecast and Plan numbers and also the statistical accounts like rates
  • Developed the business rules to use runtime prompts functionality for end users
  • Developed, automated and scheduled the HAL jobs to perform the bulk metadata loading activity
  • Worked on Hyperion system 9 BI+ to create various BSO applications for budgeting planning and forecasting
  • Assisted in scheduling the Hyperion reports, created dashboards with Interactive reporting studio as well as with Web Analysis
  • Created and modified load rules, dimension building, Business Rules and performed data loading from external sources to populate the database by free form data load method or rules file to plot values to the outline
  • Created and maintained Essbase financial application objects including outline, calc scripts, data load rules and user security objects
  • Created ASO outline from BSO cube and examined all standard and attribute dimensions and members in the Essbase outline editor for optimization and performance using Analytic Administration Service 9.3.
  • Used MaxL and Esscmd scripts to create batch files for database optimization
  • Responsible for tuning the multidimensional cubes to optimize calculations time by using the calculation scripts using the combination of ESSCMD and MaxL
  • Worked on quarterly/annually forecasts and budget reports using Excel Ad-In utility. Optimized performance of Essbase cubes by restructuring the database outline
  • Worked on performance tuning to minimize data load time that was feeding Essbase Cubes using various external database systems

Environment: s: Hyperion Planning 11.1.1, 9.3.1, Hyperion Essbase 9.3.1, Hyperion Analytic Server 9.3, Hyperion AAS 9.3, Hyperion Business Rules 9.3, Hyperion Application Link, Financial Reporting, Hyperion Web Analysis v9.3.1,Oracle 9i, Windows 2003 Server, MS-Excel, MS-Access, MaxL, ESSCMD scripting

Confidential, Schenectady, NY

Senior Hyperion Planning & Essbase Consultant

Responsibilities:

  • Responsible for gathering business requirements, defining, designing, developing, testing and deploying the application
  • Involved in the entire SDLC of implementation of the Hyperion Planning and Essbase applications
  • Involved in installation and up-gradation of Hyperion Essbase from 7.1.2 to System 9
  • Implemented Hyperion Planning and developed web-based forms for the various budgeting purposes and implemented whole security matrix in Hyperion Planning
  • Developed, automated and scheduled the HAL jobs to perform the bulk metadata loading activity
  • Design and developed the reports using Hyperion Reports, generated ad-hoc reports using Web Analysis
  • Designed the workflow in Hyperion planning
  • Performed data loading from external sources to populate the database by free form data load method or rules file to plot values to the outline
  • Involved in setting the database properties, and creating filters on Dimensions
  • Designed and developed the database calculations like consolidations, member formulas, and complex Allocation calc scripts to tailor specific tasks on dimensions and members
  • Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server/applications
  • Optimization of Data Load Rules and Calc Scripts, designed and developed business rules and enhanced calc scripts
  • Designed and developed numerous complex Essbase applications with excellent balance of Dense and Sparse dimensions, arranged in an hourglass fashion
  • Converted 180 GB BSO database to ASO database for better calculation and Retrieval performance
  • Produced reports by queries, and filters using Essbase Query Designer to display meaningful, and easy to read reports for management as well using Essbase Excel Spreadsheet add-in to retrieve and drill down on relevant information
  • Involved in provisioning the users in Hyperion Shared Service, creating groups and users in Shared Service Native security mode
  • Used ESSCMD, MAXL scripting for batch processing, provided technical guidance and support to end-users by developing the documentation required
  • Provided necessary help for Analysts to develop the financial results and helped to prepare trend reports to support business managers make profitable decisions
  • Designed and developed may web based reports using Hyperion Analyzer, Hyperion Reports and Excel Add-in
  • Developed the documentation required to transfer knowledge for the users and for the admin and support

Environment: s: Hyperion Planning 4.0.5, Hyperion Essbase system 9 BI+/7.x, Hyperion Analyzer 7.0, Hyperion Reports 7.2, Hyperion Application Link 7.2, Smart view utility with Essbase Excel Add-in, Microsoft SQL Server 2005, MS-Excel, MS-Access, MAXL, ESSCMD scripting

Confidential, Chicago, IL

Senior Essbase Analyst

Responsibilities:

  • Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
  • Translated end user requirements into application design specifications, maintained optimal match between cube design and report specifications
  • Extensively worked with the Essbase database settings, caches and the outline optimization for the better performance
  • Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging
  • Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts
  • Developed and designed cubes using Essbase Integration Services, Managed system upgrades and client installations based on requirements and Migrated Essbase from 7.1.5 to 9.3 version
  • Developed four cubes developed four cubes one for Confidential Loans, one for Confidential Credits, one for Market Research and one for Customer Analysis
  • Developed Batch files using MAXL, PERL and ESSCMDs and Rules files to upload data from financial systems database to Essbase cube
  • Performed Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers
  • Performed Essbase administration activities such as creating new cubes
  • Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
  • Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users
  • Documented and issued procedures pertaining to Essbase applications
  • Provided business analysts with advice and options on opportunities to leverage the tool and increase usage.

Environment: Hyperion Essbase 7.15/9.3, EAS 6.5.1, EIS, Excel Spreadsheet Add-In, Hyperion Analyzer 6.5, Hyperion Planning 9.3, Hyperion Reports 6.0, SQL Server 2005,Windows 2000, Perl

Hire Now