We provide IT Staff Augmentation Services!

Sr. Hyperion Consultant Resume

4.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Around 8+ years of professional experience in development, analysis, implementation, Administration in a client - server environment.
  • Over 6+ years of experience as Hyperion Developer, Planning and Administrator, hands on experience using Hyperion ESSBASE, Planning, ESSCMD, MAXL, MDX, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports, Hyperion Analyzer, Financial Reporting Studio, HAL, Work space in Windows 2000/NT and UNIX Environment.
  • Thorough Knowledge of entire life cycle of Data Warehouse Design, development and implementation.
  • Worked in environment that had E-R, Star and Snow flake schemas.
  • Developed ESSBASE cubes using Block/Aggregate storage technologies.
  • Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child references.
  • Involved in performing regular Database backups, Dense/Sparse settings, Partitioning (using Transparent, Replication and Linked Techniques).
  • Hands on Experience in calculation scripts (creation, Manipulation and maintenance), ESSCMD scripts, MAXL scripts and MDX scripts.
  • Experience in Hyperion System 11.X and 9.X modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards).
  • Involved in migrating Essbase /planning/Reporting of 7.X/9.X versions to Essbase 11.X.
  • Used Business rules for allocation and budgeting in Hyperion Planning.
  • Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
  • Proficiency in Oracle Hyperion Data Relationship Management (DRM) solutions. Expertise in using DRM for managing users, properties, verifications and validations, managing system categories, node types, migrating DRM metadata, working with formulas and transaction requests.
  • Performed several administrative tasks like installing, configuring and troubleshooting of ESSBASE Administrative services, Shared Services and Planning on server machines.
  • Designed and developed web forms for data inputs as per the business requirements using Hyperion Planning. Developed numerous simple to complex Business Rules and attached them to the web forms.
  • Applied Hyperion Application Link (HAL),Oracle Data Integrator(10.3.5) and Essbase Integration Service(EIS) to develop standardized data management processes using Web-based user flow interface. Integrated and validated financial data from source systems and had key responsibility of reducing data based integration costs.
  • Interacted with Business Users in gathering functional requirements and need for planning cubes.
  • Involved in the complete cycle of design, build, testing and implementation of CFS Closing cube using Hyperion Planning
  • Responsible for development of Workforce planning application in order to calculate workforce data such as FTE’s,Taxes,Economic factors for various employees based on their salary grades.
  • Developed and implemented Sequences, RTP’s and Macros for business rules in order to stream line calculations and perform in a sequential order and reduced complexity.
  • Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.
  • Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
  • Result oriented experience in database and retrieval performance optimization, tuning, performance analysis, and creation of debugging procedures through development of dynamic test cases.
  • Developed automation scripts for Back up and Refresh of all Production Cubes during Recovery.
  • Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle, SQL Server, DB2,TeraData databases.
  • Experience in Object-oriented programming using JAVA, C++.
  • Excellent communication skills with proficient expression, transmission and interpretation of knowledge and ideas.
  • Outstanding team player with an aptitude to learn.

TECHNICAL SKILLS

OLAP Expansion Tool: Hyperion System 11/9 BI+ Analytic Administration Services, Hyperion Planning System 11.3.1/9.x/4.0/3.5.1, Hyperion Shared Services11.x/ 9.x, Web Forms, Hyperion Essbase 11.3.1/9.X/7.X/6.X, Essbase Integration Services 7.X/6.X (EIS), Hyperion System 11.x/ 9.x Smart View, Essbase Excel Add In, ESSCMD, MAXL, MDX, Hyperion Reports 7.2/7.0, Hyperion Financial Reporting Studio 9.3, HAL 7.3/7.1, Hyperion Analyzer 7.2/7.0, Hyperion Performance Suite,Oracle Data Integrator 11.1/10.3.5.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis11.1.1.3, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion System 11/9 Smart View,Hyperion Work Space,Oracle Data Integrator 10.1.3.5/11

Databases: ESSBASE11.x/ 9 BI+, Oracle 9i/10g, DB2, SQL Server 2000, MS Access,TeraData

Web &Application Servers: Apache Tomcat,WebLogic 8.1.2, Web Sphere 6.1

Languages: C++, SQL, PL/SQL, Java and HTML

Operation Systems: Windows 9x/NT 4.0/XP/ 2000/2003/2008 , UNIX (HP/AIX)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Hyperion Consultant

Responsibilities:

  • Gathered requirements from business users, created application and technical architecture documents for management based on existing and new requirements
  • Analyzed existing applications and databases and documented all requirements for the design and development phase of the project
  • Designed and developed an Essbase Applications to meet the business requirements, and migrated these databases to production environment.
  • Designed and implemented an automated dimension build process for the Essbase Reporting Cube.
  • Designed and built a partitioned database using Replicated and Linked Partitioning for reporting needs as per business requirements.
  • Created Essbase Block Storage (BSO) and Aggregate Storage (ASO) cubes for reporting needs with complex aggregation process.
  • Used the metadata supplied from DRM to build the Cubes in Essbase as well as Planning Applications.
  • Extensively performed data validation for Actual, Budget and Forecast load
  • Studied the FDM mapping and created automated templates for actual, budget and forecast data loads
  • Involved in the migration of Business Rules from Test environment to Production using Import/Export functionality.
  • Directly involved in designing an outline, Dimensions, Members and Node attributes.
  • Developed business objects including Calculation Scripts for calculation and aggregations and Report Scripts for generating reports.
  • Developed and maintained several report scripts and calculation scripts from two main corporate reporting database
  • Monitored and oversaw batch jobs developed in the reporting environment
  • Created Security filter for Essbase applications using Essbase Administration Services database security functionality.
  • Extensively involved in performance tuning of existing Essbase and Planning applications using Oracle Essbase best practices.
  • Assessed and tested new releases of the software and applied patches as necessary. Managed and performed system upgrades as needed for both environments
  • Consulted with new project developments to ensure compliance with corporate standards
  • Managed vendor relationship and licensing arrangements with Essbase. Ensured compliance with licensing agreements and facilitated annual licensing renewal as required.

Environment: Hyperion Essbase 11.x, Essbase Integration Services 9.x, Hyperion Financial management, Hyperion Workspace 9.x/11.x, Hyperion Web Analysis 9.x/11.x, Hyperion Financial Reporting 9.3.3/9.3.1 , Essbase Studio, Hyperion Smart view 9.x/11.x, Hyperion Shared Services, Oracle Data Integrator (ODI), Financail Data quality management, SQL Scripts

Confidential, Boston,MA

Hyperion Planning Consultant

Responsibilities:

  • Worked with Business Analysts, Business Users and other team members in gathering requirements, functional specifications, testing strategies and planning the project.
  • Involved in development of Hyperion Planning Apps such as ActualDB, Capex, Workforce, Prioritization, Margin and Forecast.
  • Involved in setting up actual and budget data flow process between the Planning applications.
  • Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
  • Developed and updated the Calc scripts (Taxes, Accruals, LnA’s, AFUDC, Depr etc.), MaxL scripts, Load Rules, web forms, business rules and other artifacts for all Hyperion Apps.
  • Coordinated setup and maintenance of Hyperion environments (Dev, QA, Test and Prod) and migration of various Hyperion applications artifacts across the environments via LCM.
  • Performed Unit Testing and validation for both break/fix and maintenance/minor enhancements.
  • Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child references.
  • Involved in performing regular Database backups, Dense/Sparse settings, Partitioning (using Transparent, Replication and Linked Techniques).
  • Created/Updated the Summary, Monthly, Annual and Income Statement Reports through Financial Reporting Studio.
  • Involved in integration of oracle applications with Hyperion Essbase to load Actuals.
  • Developed and implemented Sequences, RTP’s and Macros for business rules in order to stream line calculations and perform in a sequential order and reduced complexity.
  • Involved in the creation of Admin Guides and Procedure Manuals of the related tasks for all the applications in the project.
  • Worked as a team member to utilize ETL (Extract Transform Load) tools to enable data reformatting to migrate from multiple sources into data warehouse andHyperionEssbase for analysis to support business processes and requirements.
  • Involved in trouble shooting of reconciliation issues coming from the nightly build of Cubes.
  • Used Maxl and Esscmd scripts for database administration tasks.
  • Used Maxl Scripts for dense restructuring and to reduce data fragmentation.
  • Responsible in giving 24/7 hrs supports to users who were located in various parts of world
  • Support existing cubes, problem identification, resolution and documentation.

Environment: Oracle EPM System 11.1.2, Hyperion Planning 11.1.2, Hyperion Analytic Services11.1.2, Shared Services 11.1.2,, Enterprise Performance Management Architect (EPMA)11.1.2, Hyperion Application Link (HAL), Hyperion Data Relationship Management 11.1.2, Workspace 11.1.2, Financial Reporting Studio 11.1.2, Hyperion Financial Management, Hyperion web Analysis Studio 11.1.2, Excel Add-In11.1.2, Smart View11.1.2, MaxLSun Solaris 9.

Confidential, SunnyVale,CA

Essbase Consultant

Responsibilities:

  • Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM 11.1.1.3, Hyperion Essbase, Workspace, Shared Services, Financial Reporting and Web Analysis, Essbase Integration services, Oracle Data Integrator 10.1.3.5 and Hyperion Smart View in Unix environment.
  • Involved in gathering requirements and developing project plan & system level requirement definition(SLRD), defining functional specifications, developing design documentations and testing strategies
  • Analyzing the raw data from oracle R12 ERP systems and converting it into valuable business information by design & development of appropriate cubes & reports provided seamless integration of historical, projected & derived data.
  • Provided hands on Document which explains the functionality of each and every Cube and Reports which helps end user to understand what they can do with Cubes and Reports.
  • Created Master and Work Repositries in Oracle data Integrator for oracle and Hyperion Essbase.
  • Created projects,scenarios and packages to integrate data-ware house with Hyperion Essbase for loading data from source system to target system using Sunopsys memory Engine.
  • Created Maximum number of ASO and BSO cubes for reporting and allocation requirements in very short period of time.
  • Developed dashboard templates in the Web Analysis studio to make it easy to add new reports to the existing dashboard in the future without much effort on the design.
  • Created Hyperion Business Rules (HBR), calc scripts, report scripts, security for HBR’s—Global Secuirty Filters and Web forms. Salary script based on Headcounts, Rundown units calculation, cost of sales were few of HBR’s.
  • Responsible for automating jobs and processes in Essbase and Planning. Automation involved Batch scripting, and Maxl.
  • Responsible for developing rules files for data load,dimension building and removing members from a specific dimensions.
  • Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using Web Analysis and Smart View.
  • Responsible for Migrating of cubes and Artifacts from and to various environments using Life Cycle Management(LCM) and Command Line Utility using Hyperion Shared Services.
  • Developed and Automated Adhoc reports in Smart-view based on the user requirements for Day-to-Day reporting needs.
  • Trained end user in using and refreshing data in Dash Boards using WebAnalysis artifacts and developing and running Hyperion and Excel Add-in and financial reports.
  • Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
  • Troubleshoot and resolve anyHyperionSystem related Issues.

Environment: Oracle EPM System 11.1.1.3, Hyperion Planning 11.x/ 9.x, Hyperion Analytic Services11.x/ 9.x, Shared Services11.x/ 9.x, Business Rules 11.x/9.x, Enterprise Performance Management Architect (EPMA), Hyperion Application Link (HAL), Essbase Integration Services (EIS), Crystal Reports, Hyperion Data Relationship management 11.x/9.x, Workspace11.x/ 9.x, Financial Reporting Studio11.x/ 9.3, Hyperion Financial Management, Hyperion web Analysis Studio11.x/ 9.x, Excel Add-In, Smart View11.x/9.x, MaxL, Oracle 10g/9i, Sun Solaris 9.

Confidential, Detroit, MI

Hyperion Planning / Essbase Consultant

Responsibilities:

  • Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM 11.1.1.3, Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis, HFM and Smart View.
  • Involved in gathering requirements and developing project plan & system level requirement definition(SLRD), defining functional specifications, developing design documentations and testing strategies
  • Analyzing the raw data and converting it into valuable business information by design & development of appropriate cubes & reports provided seamless integration of historical, projected & derived data.
  • Designed OLAP database to support Market strategy planning, Workforce planning, resource utilization and logistics for nationwide sales and operations.
  • Assisted Project Manager with modifications of Planning application Entity and Accounts dimensions to improve application capabilities interacted with IT to develop overall system Security standards on Shared Services.
  • Developed the Calc scripts and Business Rules to calculate complex values like Infrastructure, Net Income and YTD & MTD Commitment, Variance, Capital expenditures, Forecasts, Budgeted cash flow statements, & etc.
  • Developed and managed Web Forms for users to input data values and acreated Task List, Menu’s for the assigned tasks in order to organize process flow and monitoring of budgeting process by business partners to meet deadlines.
  • Extensively worked with Financial Reports & Hyperion Analyzer 11.x/9.x, Developed reports for annual planning and beyond, Budgeting monthly expenditures, Expense management and control, Reconciliation reports, comparing actual vs. budget expenditures using Financial Reports 11.x/9.x and Hyperion Smart view11.x/9.x.
  • Developed Complex web forms for calculating workforce calculations and attached them to business rules and sequence for calculating workforce data like benefits, taxes and salaries using runtime prompts.
  • Coordinated Hyperion application and planning artifacts migrations across the Environments, Security set-up and using Life cycle management(LCM) and command line prompts.
  • Responsible for development of Workforce planning application in order to calculate workforce data such as FTE’s,Taxes,Economic factors for various employees based on their salary grades.
  • Developed and implemented Sequences, RTP’s and Macros for business rules in order to stream line calculations and perform in a sequential order and reduced complexity.
  • Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
  • Setting up MAXL scripts to batch outline updates, data loads and Calc Script executions and automating Hyperion data load and created scheduled batches from Workspace using report and batch bursting techniques.
  • Responsible for setting up securities to distribute the system among various levels of users who were accessing the database and also creating dimension and member level security for dimensions like accounts, entities and scenarios .Setting new groups and users under the modules of the organization and giving privileges according to their access requirements using single sign on.
  • Trained end user in budgeting and forecasting using web forms for both general ledger and workforce artifacts and developing and running Hyperion and Excel Add-in and financial reports.
  • Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
  • Troubleshoot and resolve anyHyperionSystem related Issues.

Environment: Oracle EPM System 11.1.1.3, Hyperion Planning 11.x/ 9.x, Hyperion Analytic Services11.x/ 9.x, Shared Services11.x/ 9.x, Business Rules 11.x/9.x, Enterprise Performance Management Architect (EPMA), Hyperion Application Link (HAL), Essbase Integration Services (EIS), Crystal Reports, Hyperion Data Relationship management 11.x/9.x, Workspace11.x/ 9.x, Financial Reporting Studio11.x/ 9.3, Hyperion Financial Management, Hyperion web Analysis Studio11.x/ 9.x, Excel Add-In, Smart View11.x/9.x, MaxL, Tera Data SQL Assistant 7.1.0,TeraData Administrative Manager V7.1.0,TeraData Profiler 5.0, Sun Solaris 9.

Confidential, Denver, CO

Hyperion Planning/Essbase Consultant.

Responsibilities:

  • Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM 11.1.1.1, Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis, HFM and Smart View.
  • Designed OLAP database to support Market strategy planning, resource utilization and logistics for nationwide sales and operations.
  • Assisted Project Manager with modifications of Planning application Entity and Accounts dimensions to improve application capabilities interacted with IT to develop overall system Security standards on Shared Services.
  • Involved in maintaining existing Hyperion Planning 9.2 Environments.
  • Coordinated Hyperion application migrations across the Environments, Security set-up and ongoing support.
  • Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
  • Performed Unit testing for both break/fix and maintenance/minor enhancements.
  • Coordinated Disaster Recovery Planning and Capacity Planning.
  • Applied software patches to resolve the issues encountered by Hyperion system 9.
  • Created and maintained batch - jobs (UNIX and Windows) which automate Data Loads, Calculation and developed scripts for automation of services start up and stop up using CONTROL-M Scheduler.
  • Debug and enhance various calculation scripts and business rules.
  • Maintain outline, metadata and member formulas as business requirements.
  • Load and extract submission group assignments, configuring scenarios that include Phased submissions..
  • Maintained Rules file for loading of data using Essbase administrative services and loading the metadata using Enterprise Performance Management Architect.
  • Responsible for developing composite web forms and complex business rules in order to perform complex calculations required for budgeting and forecasting purposes of business requirements.
  • Developing numerous simple to complex Business Rules and attached them to the web forms.
  • Developed and maintained Web Forms, Task lists and Planning Units and managed security for the same.
  • Managed Hierarchies, Business Rules, Mappings and Validations using Data Relationship Management (DRM) and Hyperion Application Link (HAL).
  • Implemented robust data-access security and user management.
  • Created and scheduled batches to run Financial Reporting reports for multiple members through Workspace.
  • Automated data loading from multiple sheets using MaxL.
  • Tuned Analytic services for optimal performance, data retrieval and calculation.
  • Provided oversight of the technical migration of the code and configuration in Hyperion Planning Environment.
  • Coordinated in End-user training and developed appropriate Training materials.
  • Troubleshoot and resolve anyHyperionSystem related Issues.

Environment: Oracle EPM System 11.1.1, Hyperion Planning 9.3.1, Hyperion Analytic Services 9.3, Shared Services 9.3, Business Rules 9.3, Enterprise Performance Management Architect (EPMA), Hyperion Application Link (HAL), Crystal Reports, Hyperion Data Relationship Management 9.3, Workspace 9.3, Financial Reporting Studio 9.3, Hyperion Financial Management, Hyperion web Analysis Studio 9.3, Excel Add-In, Smart View, MaxL, Teradata, Sun Solaris 9.

Confidential, San Francisco, CA

HyperionEssbase Developer/Consultant

Responsibilities:

  • Involved in gathering requirements and developing a project plan.
  • Responsible for the Installation, configuration and Overall Maintenance of Hyperion 11 Essbase planning, Work space, Shared services, Provider services, Financial Reporting and Web Analysis, Smartview.
  • Designed, developed, and implemented Expense Planning and Reporting System for the Financial Department using Essbase.
  • Wrote Hyperion Business rules for Budget, Actual and rolling Forecast and Design, build, enhance and support web based data entry forms within The Hyperion Planning application.
  • Analyzed all the dimensions and members in the Essbase database using Essbase Application Manager.
  • Managed Hierarchies, Business Rules, Mappings and Validations using Data Relationship Management (DRM).
  • Created Business Rules to assign them to Planning Web forms and also to launch them on demand from time to time with end users.
  • Coordinated software upgrade from Hyperion System 9 to Oracle Hyperion EPM system 11.
  • Extract the data from legacy system, stored in staging area using ODI.
  • Optimized applications by balancing out the block size with Sparse/Dense dimension alterations.
  • Worked with Essbase Integration Services to create meta-outline for new cubes.
  • Create Dimensions and Load data using rules file and automate the same using MAXL scripts.
  • Used Essbase ASO wizard to convert BSO to ASO and applied MDX formula’s to the ASO outline.
  • Used various types of Calculations such as Two-Pass Calc, Intelligent calc for Outline Calculations.
  • Involved in maintenance of Hyperion Planning 11.X cube, involved in creation of Web Forms, data refreshes and user creation in Planning.
  • Assisted users in implementing Budget Review Process from setting up planning units to promotion, rejection, approval and completion of the overall planning process.
  • Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
  • Used Essbase source load feature to configure source file for proper dimension building and data loading.
  • Designed and developed predefined management reports usingHyperionAnalyzer.
  • Involved in writing and modifying shell scripts for automation of Essbase jobs.
  • Provided technical guidance and support to end-users by developing the documentation required.

Environment: HyperionShared Services 11/9.x, Enterprise Analytics 11/9.x, Essbase Analytics 11x, Analytic Administration Services 11.x,, Analytic Integration Services 11.x, Web Analysis 11.x,Hyperion DRM, Financial Reporting 11.x, AutoSys, Informatica, Clarity, Oracle 10g.

Confidential, Chicago, IL

HyperionEssbase/Planning Consultant.

Responsibilities:

  • Discussed with clients on user needs and analyzed their business requirements in converting draft outlines into technical and functional specifications of Essbase.
  • Managed system upgrades and client installations based on users’ requirements, extensively involved in upgrading current 7.1.6Hyperionenvironment to system 9.
  • InstalledHyperionPlanning and operatedHyperionReports and Analyzer to produce sophisticated reports on the Web that contained Measures, Markets, and Product information forfinancialmanagement teams.
  • Monitored and maintainedHyperionPlanning &FinancialReports folder structures within the BI+ Workspace.
  • Responsible in planning and budgeting workflows, created and applied the business rules, managed user data forms and various business models like P& L, B/S and also some operational planning models usingHyperionPlanning 9.3.
  • Modified DRM routine to the changing need of a business and deployed on testing environment to extract data from Oracle and populate in new application of Planning.
  • Developed successful multi-phase implementation ofHyperionPlanning solution.
  • Used EPMA interface tables to load meta-data from ERP systems into planning applications.
  • Used Import Security Utility to import dimension members’ access rights into Planning from text files.
  • Created global and local variables to be used as run-prompts in business rules to facilitate the users to enter the member’s on-the-fly for the data-forms.
  • Created filters and groups to assign specific privileges for the planning users using Shared Services.
  • Worked as a team member to utilize ETL (Extract Transform Load) tools to enable data reformatting to migrate from multiple sources into data warehouse andHyperionEssbase for analysis to support business processes and requirements.
  • Developed ASO cube which contained dimensions with very large members. Also, developed BSO cubes for different business requirements.
  • Involved in developing calc scripts & queries which would allocate Plan, Actual and Forecast data values to various locations. Optimized the cubes which improved overall performance.
  • Used MDX for querying data to precisely define analytical requests against ASO databases. Used Smart View to surface the results, packaging business analysis to hide technicalities from the end users.
  • Generated rules files to accurately build dimensions and load data accordingly to client requirements.
  • Generated reports of Forecast Trend, Comparative Performance, and Stock Exchange for their business partners using Excel Add-in.
  • Prepared profitability reports detailing price/volume trends and expense variance over previous periods by usingFinancialReporting &, Web Analysis.
  • Documented all Essbase changes, automation scripts, and optimization processes for other Essbase users to coordinate in developing the database system.

Environment: HyperionEssbase 7.2.5/9.3,HyperionPlanning, Essbase Administration Services, Essbase Integration Services, Shared Services, Essbase Excel Add-In, Web Analysis, Hyperion Data Relationship Management(DRM),HyperionReports, Unix.

Confidential, New York

Hyperion Developer

Responsibilities:

  • Involved in building Management cube, financial cube and Intercompany cube using PeopleSoft process and Essbase integration services.
  • Responsible to solve the performance issues in the Reports.
  • Designed and developed financial reports using financial cube.
  • Designed and Developed Management reports using management cube.
  • Designed nested reports (Sub reports) for Management group.
  • Support and maintenance of the Financial Hyperion reports for the Delaware accounting unit.
  • Support and maintenance of all the three cubes.
  • Migrated reports from development to Preproduction and then to production.
  • Responsible for solving the reports issues related with the help of Hyperion tech support.
  • Enhancements to the management reports due to change in user requirements.
  • Developed Dashboard reports using Hyperion Analyzer and implemented the drill through and traffic lighting scenario reports.
  • Testing of Hyperion reports and training the users to the new Hyperion reports.
  • Developing and Modifying the Outline, Calc scripts.

Environment: Hyperion Essbase 6.2/6.5.1, Hyperion Analyzer 6.5, Hyperion Reports 2.5/2.6, Essbase API, Excel, Oracle8.x, Windows NT 4.0/2000.

We'd love your feedback!