We provide IT Staff Augmentation Services!

Senior Hyperion Planning/essbase Consultant Resume

Alpharetta, GA

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.

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 Integration Services, ESSCMD, MAXL, Essbase API.

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, Alpharetta, GA

Sr Hyperion Planning/Essbase Developer

Confidential is an international hotel group whose goal is to create Great hotels guests love.The project was to review, design and implement modifications to existing applications to correct errors and improve afficiency

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

Confidential is one of the leading players in the BFI. Nation Wide Insurance has chosen Hyperion products to meet its financial consolidation, budgeting & forecasting and reporting needs. This project is to build financial cubes for the management based on their businesses, projects and lines of businesses to the managerial and decision-makers to help them to analyze the business trends, company P/L’s and other budget analyses. The built cubes are then automated and reports are designed in Hyperion reports and also with Excel Add-In.

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

Environments: 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

Confidential is part of GE Capital that provides the services in mid, large scale business in the area such as leasing the commercial equipment and provides the finance. FP&A group requires forecasting the financial performance of the group for plan1 (12 months) and plan2 (3 years) budgets.

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

Environments: 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

Confidential is an international bank, which already had a well established Hyperion Essbase, required some minor cube additions to the existing suite of main applications for its local usage for approving loans and credits to its consumers and departmental analysis which was successfully completed during the contract.

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 HSBC Loans, one for HSBC 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

Confidential, Irving, TX

Hyperion Consultant

Confidential Company is wholly owned by Allstate Insurance Company, the largest publicly held personal lines insurance company in America. The project was to design and implement Hyperion Application for Financial Performance and Operating Expense Analysis and Reporting. Windows scheduler was used for Batch processing and execution of Essbase scripts to automate Outline updating and data loading to Essbase database. Hyperion Report and Essbase Excel add-ins were used for reporting and analysis.

Responsibilities:

  • Developed multi-dimensional database (MDDB) application using Hyperion that stored and maintained company’s financial and marketing data for trend analysis and reporting
  • Imported data from different data sources including OLTP database, excel and text files, created rule files and built dimensions and loaded data using Load Rules files
  • Created and maintained Rule files, Report Scripts and Calc Scripts
  • Wrote batch scripts and scheduled them automatically to run ESSCMDS to take regular backups
  • Restructured cubes in Essbase outlines in order to optimize performance and calculations
  • Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers
  • Extensively worked with Hyperion Reports, Hyperion Analyzer and Essbase Excel Add-ins
  • Designed and implemented standard reports using excel pivoting and chart utilities
  • Optimized the applications to bring down the runtime and database size considerably
  • Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with certain updates on data values

Environment: Hyperion Essbase 7.1.5, Hyperion Reports 7.0, Hyperion Analyzer 7.0,Hyperion Planning 3.3,MaxL, Essbase Excel Add-ins, Oracle 9i, SQL Server 7.0/2000,Unix, Windows 2000/2003 Server/Professional

Confidential, Cleveland, OH

Business Analyst/Data Analyst

The LOS (Loan Originating System) Track is responsible for the overall design and development of all forms and setup items to support origination, processing, underwriting, closing, funding and secondary processes. LOS is divided into two primary work groups for the purposes of delivering the agreed upon scope. The first is LOS Application which is focused on validation and customization of the application. The second is the LOS Setups group which is charged with ensuring all setups required to support application functionality are present and contain supporting data required to meet project requirements.

Responsibilities:

  • Developed Product Prototypes, Use Case and Sequence diagrams that provided a view of the requirements
  • Tasked to gather and document requirements to integrate 6 applications into a currently utilized COTS application
  • Used TSO, UNIX, WebSphere MQ, & Proprietary Apollo Credit Decision software applications
  • Collaborated with users on the definition of requirements and the design of applications
  • Developed Functionality Plan and SWIFT message layouts for Clearing and Settlement, P& L allocation processing
  • Played a key role in technical design, architecture, construction, and system integration testing involved in client presentations and training
  • Evaluated technical impact, proposed technical design, modified programs, supported system integration and implemented system in production on time and budget (Personal Loans, Collection System and Mortgages System)
  • Investigated on-line and batch amends of any complexity and found solution in the shortest time possible for Loans, Mortgages and Collection systems
  • Providing production support, and problem analysis, with 7/24 on call. Successfully resolved on call issues under extremely stressful and time pressured situations
  • Implemented and coordinate a new sub-system in Collection System: made all necessary changes including unit testing, functional system testing and took the system through PSEUDO verification (UAT)
  • Performed technical analysis in major modifications for VISA and Collection System components
  • Maintaining systems components: Load Library, PEM, SYSIN, Databases, and Activity Record

Environment: IBM Mainframe (MVS/TSO), COBOL OS390, IMS (PEM-HOGAN, DB/DC), RequisitePro, UML, DB2/SQL, SPUFI, JCL, VSAM, File Aid, AbendAid, WebSphere, MQ Series, ENDEVOR, EASYTRIEVE PLUS, FOCUS rpt, Quality Center

Hire Now